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 JTF_NUMBER_TABLE

Line 14: function get_updated_ids return JTF_NUMBER_TABLE

10: return 'A';
11:
12: end;
13:
14: function get_updated_ids return JTF_NUMBER_TABLE
15: IS
16:
17: BEGIN
18: return g_updated_ids;

Line 344: l_updated_keys JTF_NUMBER_TABLE;

340:
341: l_user_id NUMBER;
342: l_login_id NUMBER;
343:
344: l_updated_keys JTF_NUMBER_TABLE;
345:
346: l_prev_status_id NUMBER;
347: l_status_id NUMBER;
348: l_repair_line_id NUMBER;

Line 386: g_updated_ids := JTF_NUMBER_TABLE();

382: l_user_id := NVL(fnd_global.USER_ID, -1);
383: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
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,

Line 645: l_updated_keys JTF_NUMBER_TABLE;

641:
642: l_user_id NUMBER;
643: l_login_id NUMBER;
644:
645: l_updated_keys JTF_NUMBER_TABLE;
646:
647: l_prev_status_id NUMBER;
648: l_status_id NUMBER;
649: l_repair_line_id NUMBER;

Line 685: g_updated_ids := JTF_NUMBER_TABLE();

681: -- Api body starts
682: l_user_id := NVL(fnd_global.USER_ID, -1);
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,

Line 939: l_updated_keys JTF_NUMBER_TABLE;

935:
936: l_user_id NUMBER;
937: l_login_id NUMBER;
938:
939: l_updated_keys JTF_NUMBER_TABLE;
940:
941: l_prev_status_id NUMBER;
942: l_status_id NUMBER;
943: l_repair_line_id NUMBER;

Line 979: g_updated_ids := JTF_NUMBER_TABLE();

975: -- Api body starts
976: l_user_id := NVL(fnd_global.USER_ID, -1);
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,

Line 1237: l_updated_keys JTF_NUMBER_TABLE;

1233:
1234: l_user_id NUMBER;
1235: l_login_id NUMBER;
1236:
1237: l_updated_keys JTF_NUMBER_TABLE;
1238:
1239: l_prev_status_CODE VARCHAR2(80);
1240: l_status_CODE VARCHAR2(80);
1241: l_repair_line_id NUMBER;

Line 1284: g_updated_ids := JTF_NUMBER_TABLE();

1280: -- Api body starts
1281: l_user_id := NVL(fnd_global.USER_ID, -1);
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,

Line 1549: l_updated_keys JTF_NUMBER_TABLE;

1545:
1546: l_user_id NUMBER;
1547: l_login_id NUMBER;
1548:
1549: l_updated_keys JTF_NUMBER_TABLE;
1550:
1551: l_prev_status_CODE VARCHAR2(80);
1552: l_status_CODE VARCHAR2(80);
1553: l_repair_line_id NUMBER;

Line 1606: g_updated_ids := JTF_NUMBER_TABLE();

1602: -- Api body starts
1603: l_user_id := NVL(fnd_global.USER_ID, -1);
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,

Line 1876: l_updated_keys JTF_NUMBER_TABLE;

1872:
1873: l_user_id NUMBER;
1874: l_login_id NUMBER;
1875:
1876: l_updated_keys JTF_NUMBER_TABLE;
1877:
1878: l_prev_status_CODE VARCHAR2(80);
1879: l_status_CODE VARCHAR2(80);
1880: l_repair_line_id NUMBER;

Line 1917: g_updated_ids := JTF_NUMBER_TABLE();

1913: -- Api body starts
1914: l_user_id := NVL(fnd_global.USER_ID, -1);
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,

Line 2180: l_updated_keys JTF_NUMBER_TABLE;

2176:
2177: l_user_id NUMBER;
2178: l_login_id NUMBER;
2179:
2180: l_updated_keys JTF_NUMBER_TABLE;
2181:
2182: l_prev_status_CODE VARCHAR2(80);
2183: l_status_CODE VARCHAR2(80);
2184: l_repair_line_id NUMBER;

Line 2220: g_updated_ids := JTF_NUMBER_TABLE();

2216: -- Api body starts
2217: l_user_id := NVL(fnd_global.USER_ID, -1);
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,

Line 2482: l_updated_keys JTF_NUMBER_TABLE;

2478:
2479: l_user_id NUMBER;
2480: l_login_id NUMBER;
2481:
2482: l_updated_keys JTF_NUMBER_TABLE;
2483:
2484: l_prev_status_CODE VARCHAR2(80);
2485: l_status_CODE VARCHAR2(80);
2486: l_repair_line_id NUMBER;

Line 2522: g_updated_ids := JTF_NUMBER_TABLE();

2518: -- Api body starts
2519: l_user_id := NVL(fnd_global.USER_ID, -1);
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,

Line 2786: l_updated_keys JTF_NUMBER_TABLE;

2782:
2783: l_user_id NUMBER;
2784: l_login_id NUMBER;
2785:
2786: l_updated_keys JTF_NUMBER_TABLE;
2787:
2788: l_prev_status_CODE VARCHAR2(80);
2789: l_status_CODE VARCHAR2(80);
2790: l_repair_line_id NUMBER;

Line 2826: g_updated_ids := JTF_NUMBER_TABLE();

2822: -- Api body starts
2823: l_user_id := NVL(fnd_global.USER_ID, -1);
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,

Line 3090: l_updated_keys JTF_NUMBER_TABLE;

3086:
3087: l_user_id NUMBER;
3088: l_login_id NUMBER;
3089:
3090: l_updated_keys JTF_NUMBER_TABLE;
3091:
3092: l_prev_status_CODE VARCHAR2(80);
3093: l_status_CODE VARCHAR2(80);
3094: l_repair_line_id NUMBER;

Line 3130: g_updated_ids := JTF_NUMBER_TABLE();

3126: -- Api body starts
3127: l_user_id := NVL(fnd_global.USER_ID, -1);
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,

Line 3394: l_updated_keys JTF_NUMBER_TABLE;

3390:
3391: l_user_id NUMBER;
3392: l_login_id NUMBER;
3393:
3394: l_updated_keys JTF_NUMBER_TABLE;
3395:
3396: l_prev_status_CODE VARCHAR2(80);
3397: l_status_CODE VARCHAR2(80);
3398: l_repair_line_id NUMBER;

Line 3434: g_updated_ids := JTF_NUMBER_TABLE();

3430: -- Api body starts
3431: l_user_id := NVL(fnd_global.USER_ID, -1);
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,