This appendix presents information on the Oracle Depot Repair public API.
This appendix covers the following topics:
Oracle Depot Repair provides the following public APIs:
CSD_REPAIRS_PUB
This API is the public interface for managing a service order. It allows creation of service orders for service requests and includes the following procedures:
| Procedure Name | Description |
|---|---|
| CREATE_REPAIR_ORDER | This procedure create a service order. |
| UPDATE_REPAIR_ORDER | This procedure updates a service order. |
CSD_REPAIR_ACTUALS_PUB
This API is the public interface for managing a service order actual line. It allows creation of service order actual lines for a service request and includes the following procedures:
| Procedure Name | Description |
|---|---|
| CREATE_REPAIR_ACTUAL_LINES | This procedure creates service order actual lines. |
| UPDATE_REPAIR_ACTUAL_LINES | This procedure updates service order actual lines. |
| DELETE_REPAIR_ACTUAL_LINES | This procedure deletes service order actual lines. |
| LOCK_REPAIR_ACTUAL_LINES | This procedure locks service order actual lines. |
CSD_LOGISTICS_PUB
This API is the public interface for managing service logistics. It creates and updates service logistics lines for a service order and includes the following procedures:
| Procedure Name | Description |
|---|---|
| CREATE_DEFAULT_LOGISTICS | This procedure creates default logistics lines for the service order based on service type. |
| CREATE_LOGISTICS_LINE | This procedure creates a new service logistics line for the given service order. |
| UPDATE_LOGISTICS_LINE | This procedure updates a given logistics line. |
| CANCEL_LOGISTICS_LINE | This procedure cancels a given logistic line. |
CSD_REPAIR_ESTIMATE_PUB
This is the public interface for managing an estimate and includes the following procedures:
| Procedure Name | Description |
|---|---|
| CREATE_ESTIMATE_HEADER | This procedure creates a new estimate header for a given service order. |
| CREATE_ESTIMATE_LINE | This procedure creates a new estimate line record under a given estimate header. |
| UPDATE_ESTIMATE_HEADER | This procedure updates a given estimate header. |
| UPDATE_ESTIMATE_LINE | This procedure updates a given estimate line. |
CSD_HV_WIP_JOB_PUB
This API is the public interface for managing transactions in the Technician Portal and includes the following procedures:
| Procedure Name | Description |
|---|---|
| PROCESS_SAVE_MTL_TXN_DTLS | This procedure is called to process and save material transaction details. |
| PROCESS_SAVE_RES_TXN_DTLS | This procedure is called to process and save resource transaction details. |
| PROCESS_SAVE_OP_DTLS | This procedure is called to process and save operations transaction details. |
| CREATE_WIP_JOB | This procedure creates WIP jobs. |
CSD_REPAIR_HISTORY_PUB
This API is the public interface for retrieving detailed history for a service order and includes the following procedure:
| Procedure Name | Description |
|---|---|
| GET_HISTORY_DETAIL | This procedure is called to get history details for a service order. |
CSD_TO_FORM_REPAIR_HISTORY_PUB
This API is the public interface for logging repair activity and includes the following procedure:
| Procedure Name | Description |
|---|---|
| VALIDATE_AND_WRITE | This procedure is called to update CSD_REPAIR_HISTORY table. |
CSD_TO_FORM_REPAIR_JOB_PUB
This API is the public interface for managing repair jobs and includes the following procedure:
| Procedure Name | Description |
|---|---|
| VALIDATE_AND_WRITE | This procedure is called to update the CSD_REPAIR_JOB_XREF table. |
CSD_INTERNAL_ORDERS_PUB
This API is the public interface for managing internal move orders. It allows creation of internal move orders and includes the following procedure:
| Procedure Name | Description |
|---|---|
| CREATE_INTERNAL_MOVE_ORDER | This procedure creates internal move orders. |
CSD_RULES_ENGINE_PUB
This API is the public interface for managing default rules and includes the following procedure:
| Procedure Name | Description |
|---|---|
| GET_DEFAULT_VALUE_FROM_RULE | This procedure is called to derive the default value from the rule. |
For more details see: Oracle Integration Repository