eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_SOO_PVT dependencies on CSD_SOO_PVT

Line 1: PACKAGE BODY CSD_SOO_PVT AS

1: PACKAGE BODY CSD_SOO_PVT AS
2: /* $Header: csdvsoob.pls 120.0.12020000.4 2013/03/12 03:57:17 vicli noship $ */
3:
4:
5: function update_count(id IN NUMBER) return varchar2

Line 122: CSD_SOO_PVT.Get_Document_Status

118: l_msg_data varchar2(4000);
119: x_status_name varchar2(500);
120:
121: BEGIN
122: CSD_SOO_PVT.Get_Document_Status
123: (p_api_version => l_api_version,
124: p_commit => FND_API.G_FALSE,
125: p_init_msg_list => FND_API.G_TRUE,
126: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 157: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.get_document_status';

153: l_api_version CONSTANT NUMBER := 1.0;
154:
155: -- Variables used in FND Log
156: l_error_level number := FND_LOG.LEVEL_ERROR;
157: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.get_document_status';
158:
159: l_status_name varchar2(500);
160:
161: CURSOR c_sr_status_name(c_incident_status_id NUMBER) IS

Line 339: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_job';

335: l_api_version CONSTANT NUMBER := 1.0;
336:
337: -- Variables in FND log
338: l_error_level number := FND_LOG.LEVEL_ERROR;
339: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_job';
340:
341: l_user_id NUMBER;
342: l_login_id NUMBER;
343:

Line 640: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_sr';

636: l_api_version CONSTANT NUMBER := 1.0;
637:
638: -- Variables in FND log
639: l_error_level number := FND_LOG.LEVEL_ERROR;
640: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_sr';
641:
642: l_user_id NUMBER;
643: l_login_id NUMBER;
644:

Line 934: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_sr_task';

930: l_api_version CONSTANT NUMBER := 1.0;
931:
932: -- Variables in FND log
933: l_error_level number := FND_LOG.LEVEL_ERROR;
934: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_sr_task';
935:
936: l_user_id NUMBER;
937: l_login_id NUMBER;
938:

Line 1232: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_purchase_req';

1228: l_api_version CONSTANT NUMBER := 1.0;
1229:
1230: -- Variables in FND log
1231: l_error_level number := FND_LOG.LEVEL_ERROR;
1232: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_purchase_req';
1233:
1234: l_user_id NUMBER;
1235: l_login_id NUMBER;
1236:

Line 1544: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_internal_req';

1540: l_api_version CONSTANT NUMBER := 1.0;
1541:
1542: -- Variables in FND log
1543: l_error_level number := FND_LOG.LEVEL_ERROR;
1544: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_internal_req';
1545:
1546: l_user_id NUMBER;
1547: l_login_id NUMBER;
1548:

Line 1871: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_int_sales_order';

1867: l_api_version CONSTANT NUMBER := 1.0;
1868:
1869: -- Variables in FND log
1870: l_error_level number := FND_LOG.LEVEL_ERROR;
1871: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_int_sales_order';
1872:
1873: l_user_id NUMBER;
1874: l_login_id NUMBER;
1875:

Line 2175: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_rma';

2171: l_api_version CONSTANT NUMBER := 1.0;
2172:
2173: -- Variables in FND log
2174: l_error_level number := FND_LOG.LEVEL_ERROR;
2175: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_rma';
2176:
2177: l_user_id NUMBER;
2178: l_login_id NUMBER;
2179:

Line 2477: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_rma_third_party';

2473: l_api_version CONSTANT NUMBER := 1.0;
2474:
2475: -- Variables in FND log
2476: l_error_level number := FND_LOG.LEVEL_ERROR;
2477: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_rma_third_party';
2478:
2479: l_user_id NUMBER;
2480: l_login_id NUMBER;
2481:

Line 2781: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_ship';

2777: l_api_version CONSTANT NUMBER := 1.0;
2778:
2779: -- Variables in FND log
2780: l_error_level number := FND_LOG.LEVEL_ERROR;
2781: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_ship';
2782:
2783: l_user_id NUMBER;
2784: l_login_id NUMBER;
2785:

Line 3085: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_ship_third_party';

3081: l_api_version CONSTANT NUMBER := 1.0;
3082:
3083: -- Variables in FND log
3084: l_error_level number := FND_LOG.LEVEL_ERROR;
3085: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_ship_third_party';
3086:
3087: l_user_id NUMBER;
3088: l_login_id NUMBER;
3089:

Line 3389: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_delivery';

3385: l_api_version CONSTANT NUMBER := 1.0;
3386:
3387: -- Variables in FND log
3388: l_error_level number := FND_LOG.LEVEL_ERROR;
3389: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_delivery';
3390:
3391: l_user_id NUMBER;
3392: l_login_id NUMBER;
3393:

Line 3703: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh';

3699: l_api_version CONSTANT NUMBER := 1.0;
3700:
3701: -- Variables in FND log
3702: l_error_level number := FND_LOG.LEVEL_ERROR;
3703: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh';
3704:
3705: CURSOR c_so_orchestration_row(c_orchestration_id NUMBER) IS
3706: SELECT repair_line_id, document_type, document_header_id, document_line_id
3707: FROM csd_so_orchestration

Line 4425: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.Soo_Driver_Main';

4421: l_msg_data VARCHAR2(30000);
4422: l_msg_text VARCHAR2(2000);
4423:
4424: l_error_level number := FND_LOG.LEVEL_ERROR;
4425: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.Soo_Driver_Main';
4426:
4427: l_so_orchestration_key_tbl so_orchestration_key_tbl_type;
4428: l_repair_line_id NUMBER;
4429: l_document_type VARCHAR2(50);

Line 4511: END CSD_SOO_PVT;

4507: errbuf := l_msg_data;
4508:
4509: END Soo_Driver_Main;
4510:
4511: END CSD_SOO_PVT;