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_SO_ORCHESTRATION

Line 355: FROM CSD_SO_ORCHESTRATION

351: l_rule_id NUMBER;
352:
353: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
354: SELECT prev_status_id, status_id, repair_line_id, document_header_id
355: FROM CSD_SO_ORCHESTRATION
356: WHERE orchestration_id = c_orchestration_id;
357:
358: BEGIN
359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering Refresh_Job...');

Line 388: MERGE INTO CSD_SO_ORCHESTRATION soo USING (

384:
385:
386: g_updated_ids := JTF_NUMBER_TABLE();
387:
388: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
389: select
390: xref.repair_line_id,
391: wdj.wip_entity_id document_header_id,
392: null document_line_id,

Line 495: (csd_so_orchestration_s1.nextval,

491: ATTRIBUTE14,
492: ATTRIBUTE15,
493: PARAMN1)
494: VALUES
495: (csd_so_orchestration_s1.nextval,
496: OLTP.repair_line_id,
497: 1,
498: l_user_id,
499: sysdate,

Line 530: -- Save changes to CSD_SO_ORCHESTRATION table even

526: null,
527: null,
528: OLTP.org_id); --paramn1
529:
530: -- Save changes to CSD_SO_ORCHESTRATION table even
531: -- if SOO rules engine fails.
532: IF FND_API.To_Boolean( p_commit ) THEN
533: COMMIT WORK;
534: END IF;

Line 655: FROM CSD_SO_ORCHESTRATION

651: l_rule_id NUMBER;
652:
653: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
654: SELECT prev_status_id, status_id, repair_line_id
655: FROM CSD_SO_ORCHESTRATION
656: WHERE orchestration_id = c_orchestration_id;
657:
658: BEGIN
659: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering Refresh_SR...');

Line 687: MERGE INTO CSD_SO_ORCHESTRATION soo USING (

683: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
684:
685: g_updated_ids := JTF_NUMBER_TABLE();
686:
687: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
688: select
689: dra.repair_line_id,
690: dra.incident_id document_header_id,
691: null document_line_id,

Line 789: (csd_so_orchestration_s1.nextval,

785: ATTRIBUTE14,
786: ATTRIBUTE15,
787: PARAMN1)
788: VALUES
789: (csd_so_orchestration_s1.nextval,
790: OLTP.repair_line_id,
791: 1,
792: l_user_id,
793: sysdate,

Line 824: -- Save changes to CSD_SO_ORCHESTRATION table even

820: null,
821: null,
822: null); -- paramn1
823:
824: -- Save changes to CSD_SO_ORCHESTRATION table even
825: -- if SOO rules engine fails.
826: IF FND_API.To_Boolean( p_commit ) THEN
827: COMMIT WORK;
828: END IF;

Line 949: FROM CSD_SO_ORCHESTRATION

945: l_rule_id NUMBER;
946:
947: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
948: SELECT prev_status_id, status_id, repair_line_id
949: FROM CSD_SO_ORCHESTRATION
950: WHERE orchestration_id = c_orchestration_id;
951:
952: BEGIN
953: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering Refresh_SR_Task...');

Line 981: MERGE INTO CSD_SO_ORCHESTRATION soo USING (

977: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
978:
979: g_updated_ids := JTF_NUMBER_TABLE();
980:
981: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
982: select
983: dra.repair_line_id,
984: tsk.task_id document_header_id,
985: null document_line_id,

Line 1087: (csd_so_orchestration_s1.nextval,

1083: ATTRIBUTE14,
1084: ATTRIBUTE15,
1085: PARAMN1)
1086: VALUES
1087: (csd_so_orchestration_s1.nextval,
1088: OLTP.repair_line_id,
1089: 1,
1090: l_user_id,
1091: sysdate,

Line 1122: -- Save changes to CSD_SO_ORCHESTRATION table even

1118: null,
1119: null,
1120: null); -- paramn1
1121:
1122: -- Save changes to CSD_SO_ORCHESTRATION table even
1123: -- if SOO rules engine fails.
1124: IF FND_API.To_Boolean( p_commit ) THEN
1125: COMMIT WORK;
1126: END IF;

Line 1249: FROM CSD_SO_ORCHESTRATION

1245: l_rule_id NUMBER;
1246:
1247: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
1248: SELECT prev_status_code, status_code, repair_line_id, document_header_id
1249: FROM CSD_SO_ORCHESTRATION
1250: WHERE orchestration_id = c_orchestration_id;
1251:
1252: CURSOR c_get_wip_entity_id(c_requisition_header_id NUMBER) IS
1253: SELECT wip_entity_id

Line 1286: MERGE INTO CSD_SO_ORCHESTRATION soo USING (

1282: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1283:
1284: g_updated_ids := JTF_NUMBER_TABLE();
1285:
1286: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
1287: select distinct
1288: xref.repair_line_id,
1289: porh.requisition_header_id document_header_id,
1290: null document_line_id,

Line 1395: (csd_so_orchestration_s1.nextval,

1391: ATTRIBUTE14,
1392: ATTRIBUTE15,
1393: PARAMN1)
1394: VALUES
1395: (csd_so_orchestration_s1.nextval,
1396: OLTP.repair_line_id,
1397: 1,
1398: l_user_id,
1399: sysdate,

Line 1430: -- Save changes to CSD_SO_ORCHESTRATION table even

1426: null,
1427: null,
1428: null); -- paramn1
1429:
1430: -- Save changes to CSD_SO_ORCHESTRATION table even
1431: -- if SOO rules engine fails.
1432: IF FND_API.To_Boolean( p_commit ) THEN
1433: COMMIT WORK;
1434: END IF;

Line 1563: FROM CSD_SO_ORCHESTRATION

1559: l_order_header_id NUMBER;
1560:
1561: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
1562: SELECT prev_status_code, status_code, repair_line_id, document_header_id
1563: FROM CSD_SO_ORCHESTRATION
1564: WHERE orchestration_id = c_orchestration_id;
1565:
1566: CURSOR c_get_wip_entity_id(c_requisition_header_id NUMBER) IS
1567: SELECT wip_entity_id

Line 1608: MERGE INTO CSD_SO_ORCHESTRATION soo USING (

1604: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1605:
1606: g_updated_ids := JTF_NUMBER_TABLE();
1607:
1608: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
1609: select distinct
1610: dra.repair_line_id,
1611: porh.requisition_header_id document_header_id,
1612: null document_line_id,

Line 1713: (csd_so_orchestration_s1.nextval,

1709: ATTRIBUTE14,
1710: ATTRIBUTE15,
1711: PARAMN1)
1712: VALUES
1713: (csd_so_orchestration_s1.nextval,
1714: OLTP.repair_line_id,
1715: 1,
1716: l_user_id,
1717: sysdate,

Line 1748: -- Save changes to CSD_SO_ORCHESTRATION table even

1744: null,
1745: null,
1746: null); -- paramn1
1747:
1748: -- Save changes to CSD_SO_ORCHESTRATION table even
1749: -- if SOO rules engine fails.
1750: IF FND_API.To_Boolean( p_commit ) THEN
1751: COMMIT WORK;
1752: END IF;

Line 1887: FROM CSD_SO_ORCHESTRATION

1883: l_rule_id NUMBER;
1884:
1885: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
1886: SELECT prev_status_code, status_code, repair_line_id, document_header_id
1887: FROM CSD_SO_ORCHESTRATION
1888: WHERE orchestration_id = c_orchestration_id;
1889:
1890: BEGIN
1891: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering Refresh_Int_Sales_Order...');

Line 1919: MERGE INTO CSD_SO_ORCHESTRATION soo USING (

1915: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1916:
1917: g_updated_ids := JTF_NUMBER_TABLE();
1918:
1919: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
1920: select distinct
1921: dra.repair_line_id,
1922: oel.header_id document_header_id,
1923: oel.line_id document_line_id,

Line 2027: (csd_so_orchestration_s1.nextval,

2023: ATTRIBUTE14,
2024: ATTRIBUTE15,
2025: PARAMN1)
2026: VALUES
2027: (csd_so_orchestration_s1.nextval,
2028: OLTP.repair_line_id,
2029: 1,
2030: l_user_id,
2031: sysdate,

Line 2062: -- Save changes to CSD_SO_ORCHESTRATION table even

2058: null,
2059: null,
2060: null); -- paramn1
2061:
2062: -- Save changes to CSD_SO_ORCHESTRATION table even
2063: -- if SOO rules engine fails.
2064: IF FND_API.To_Boolean( p_commit ) THEN
2065: COMMIT WORK;
2066: END IF;

Line 2190: FROM CSD_SO_ORCHESTRATION

2186: l_rule_id NUMBER;
2187:
2188: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
2189: SELECT prev_status_code, status_code, repair_line_id
2190: FROM CSD_SO_ORCHESTRATION
2191: WHERE orchestration_id = c_orchestration_id;
2192:
2193: BEGIN
2194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering Refresh_RMA...');

Line 2222: MERGE INTO CSD_SO_ORCHESTRATION soo USING (

2218: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
2219:
2220: g_updated_ids := JTF_NUMBER_TABLE();
2221:
2222: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
2223: select
2224: dra.repair_line_id,
2225: oel.header_id document_header_id,
2226: oel.line_id document_line_id,

Line 2332: (csd_so_orchestration_s1.nextval,

2328: ATTRIBUTE14,
2329: ATTRIBUTE15,
2330: PARAMN1)
2331: VALUES
2332: (csd_so_orchestration_s1.nextval,
2333: OLTP.repair_line_id,
2334: 1,
2335: l_user_id,
2336: sysdate,

Line 2367: -- Save changes to CSD_SO_ORCHESTRATION table even

2363: null,
2364: null,
2365: null); -- paramn1
2366:
2367: -- Save changes to CSD_SO_ORCHESTRATION table even
2368: -- if SOO rules engine fails.
2369: IF FND_API.To_Boolean( p_commit ) THEN
2370: COMMIT WORK;
2371: END IF;

Line 2492: FROM CSD_SO_ORCHESTRATION

2488: l_rule_id NUMBER;
2489:
2490: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
2491: SELECT prev_status_code, status_code, repair_line_id
2492: FROM CSD_SO_ORCHESTRATION
2493: WHERE orchestration_id = c_orchestration_id;
2494:
2495: BEGIN
2496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering Refresh_RMA_Third_Party...');

Line 2524: MERGE INTO CSD_SO_ORCHESTRATION soo USING (

2520: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
2521:
2522: g_updated_ids := JTF_NUMBER_TABLE();
2523:
2524: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
2525: select
2526: dra.repair_line_id,
2527: oel.header_id document_header_id,
2528: oel.line_id document_line_id,

Line 2635: (csd_so_orchestration_s1.nextval,

2631: ATTRIBUTE14,
2632: ATTRIBUTE15,
2633: PARAMN1)
2634: VALUES
2635: (csd_so_orchestration_s1.nextval,
2636: OLTP.repair_line_id,
2637: 1,
2638: l_user_id,
2639: sysdate,

Line 2670: -- Save changes to CSD_SO_ORCHESTRATION table even

2666: null,
2667: null,
2668: null); -- paramn1
2669:
2670: -- Save changes to CSD_SO_ORCHESTRATION table even
2671: -- if SOO rules engine fails.
2672: IF FND_API.To_Boolean( p_commit ) THEN
2673: COMMIT WORK;
2674: END IF;

Line 2796: FROM CSD_SO_ORCHESTRATION

2792: l_rule_id NUMBER;
2793:
2794: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
2795: SELECT prev_status_code, status_code, repair_line_id
2796: FROM CSD_SO_ORCHESTRATION
2797: WHERE orchestration_id = c_orchestration_id;
2798:
2799: BEGIN
2800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering Refresh_Ship...');

Line 2828: MERGE INTO CSD_SO_ORCHESTRATION soo USING (

2824: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
2825:
2826: g_updated_ids := JTF_NUMBER_TABLE();
2827:
2828: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
2829: select
2830: dra.repair_line_id,
2831: oel.header_id document_header_id,
2832: oel.line_id document_line_id,

Line 2939: (csd_so_orchestration_s1.nextval,

2935: ATTRIBUTE14,
2936: ATTRIBUTE15,
2937: PARAMN1)
2938: VALUES
2939: (csd_so_orchestration_s1.nextval,
2940: OLTP.repair_line_id,
2941: 1,
2942: l_user_id,
2943: sysdate,

Line 2974: -- Save changes to CSD_SO_ORCHESTRATION table even

2970: null,
2971: null,
2972: null); -- paramn1
2973:
2974: -- Save changes to CSD_SO_ORCHESTRATION table even
2975: -- if SOO rules engine fails.
2976: IF FND_API.To_Boolean( p_commit ) THEN
2977: COMMIT WORK;
2978: END IF;

Line 3100: FROM CSD_SO_ORCHESTRATION

3096: l_rule_id NUMBER;
3097:
3098: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
3099: SELECT prev_status_code, status_code, repair_line_id
3100: FROM CSD_SO_ORCHESTRATION
3101: WHERE orchestration_id = c_orchestration_id;
3102:
3103: BEGIN
3104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering Refresh_Ship_Third_Party...');

Line 3132: MERGE INTO CSD_SO_ORCHESTRATION soo USING (

3128: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
3129:
3130: g_updated_ids := JTF_NUMBER_TABLE();
3131:
3132: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
3133: select
3134: dra.repair_line_id,
3135: oel.header_id document_header_id,
3136: oel.line_id document_line_id,

Line 3243: (csd_so_orchestration_s1.nextval,

3239: ATTRIBUTE14,
3240: ATTRIBUTE15,
3241: PARAMN1)
3242: VALUES
3243: (csd_so_orchestration_s1.nextval,
3244: OLTP.repair_line_id,
3245: 1,
3246: l_user_id,
3247: sysdate,

Line 3278: -- Save changes to CSD_SO_ORCHESTRATION table even

3274: null,
3275: null,
3276: null); -- paramn1
3277:
3278: -- Save changes to CSD_SO_ORCHESTRATION table even
3279: -- if SOO rules engine fails.
3280: IF FND_API.To_Boolean( p_commit ) THEN
3281: COMMIT WORK;
3282: END IF;

Line 3404: FROM CSD_SO_ORCHESTRATION

3400: l_rule_id NUMBER;
3401:
3402: CURSOR c_get_defaulting_info(c_orchestration_id NUMBER) IS
3403: SELECT prev_status_code, status_code, repair_line_id
3404: FROM CSD_SO_ORCHESTRATION
3405: WHERE orchestration_id = c_orchestration_id;
3406:
3407: BEGIN
3408: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering Refresh_Delivery...');

Line 3436: MERGE INTO CSD_SO_ORCHESTRATION soo USING (

3432: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
3433:
3434: g_updated_ids := JTF_NUMBER_TABLE();
3435:
3436: MERGE INTO CSD_SO_ORCHESTRATION soo USING (
3437: select distinct
3438: dra.repair_line_id,
3439: wnd.delivery_id document_header_id,
3440: null document_line_id,

Line 3551: (csd_so_orchestration_s1.nextval,

3547: ATTRIBUTE14,
3548: ATTRIBUTE15,
3549: PARAMN1)
3550: VALUES
3551: (csd_so_orchestration_s1.nextval,
3552: OLTP.repair_line_id,
3553: 1,
3554: l_user_id,
3555: sysdate,

Line 3586: -- Save changes to CSD_SO_ORCHESTRATION table even

3582: null,
3583: null,
3584: null); -- paramn1
3585:
3586: -- Save changes to CSD_SO_ORCHESTRATION table even
3587: -- if SOO rules engine fails.
3588: IF FND_API.To_Boolean( p_commit ) THEN
3589: COMMIT WORK;
3590: END IF;

Line 3675: /* CSD_SO_ORCHESTRATION_B and */

3671:
3672: /*--------------------------------------------------*/
3673: /* procedure name: Refresh */
3674: /* description : procedure to load or update */
3675: /* CSD_SO_ORCHESTRATION_B and */
3676: /* CSD_SO_ORCHESTRATION_TL */
3677: /*--------------------------------------------------*/
3678: PROCEDURE Refresh(p_api_version IN NUMBER,
3679: p_commit IN VARCHAR2,

Line 3676: /* CSD_SO_ORCHESTRATION_TL */

3672: /*--------------------------------------------------*/
3673: /* procedure name: Refresh */
3674: /* description : procedure to load or update */
3675: /* CSD_SO_ORCHESTRATION_B and */
3676: /* CSD_SO_ORCHESTRATION_TL */
3677: /*--------------------------------------------------*/
3678: PROCEDURE Refresh(p_api_version IN NUMBER,
3679: p_commit IN VARCHAR2,
3680: p_init_msg_list IN VARCHAR2,

Line 3707: FROM csd_so_orchestration

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
3708: WHERE orchestration_id = c_orchestration_id;
3709:
3710: l_row_repair_line_id NUMBER;
3711: l_row_document_type VARCHAR2(50);

Line 3983: ELSE --csd_so_orchestration_key_tbl.first is null

3979: -- RAISE FND_API.G_EXC_ERROR;
3980: END IF;
3981: END IF; --IF l_row_document_type = ... THEN
3982: END LOOP;
3983: ELSE --csd_so_orchestration_key_tbl.first is null
3984: IF l_document_type = fnd_api.g_miss_char OR l_document_type = 'JOB' THEN
3985: Refresh_Job
3986: (p_api_version => l_api_version,
3987: p_commit => p_commit,

Line 4269: END IF; -- IF csd_so_orchestration_key_tbl.first is not null THEN

4265: l_return_status := FND_API.G_RET_STS_ERROR;
4266: -- RAISE FND_API.G_EXC_ERROR;
4267: END IF;
4268: END IF;
4269: END IF; -- IF csd_so_orchestration_key_tbl.first is not null THEN
4270:
4271: l_rma_repair_line_id := g_rma_ro_line_ids.FIRST;
4272: WHILE l_rma_repair_line_id IS NOT NULL LOOP
4273: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE