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.

[Home] [Help]

APPS.EGO_AG_BULKLOAD_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 34: SET transaction_id = mtl_system_items_interface_s.nextval,

30: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
31:
32: /*Sets the Transaction_id and upper case the transaction_type*/
33: UPDATE ego_attr_groups_interface
34: SET transaction_id = mtl_system_items_interface_s.nextval,
35: transaction_type = Upper(transaction_type),
36: application_id = g_ego_application_id,
37: created_by = G_USER_ID,
38: creation_date = SYSDATE,

Line 62: SET transaction_id = mtl_system_items_interface_s.nextval,

58:
59: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
60:
61: UPDATE ego_attr_groups_dl_interface
62: SET transaction_id = mtl_system_items_interface_s.nextval,
63: transaction_type = Upper(transaction_type),
64: application_id = g_ego_application_id,
65: created_by = G_USER_ID,
66: creation_date = SYSDATE,

Line 90: SET transaction_id = mtl_system_items_interface_s.nextval,

86:
87: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
88:
89: UPDATE ego_attr_group_cols_intf
90: SET transaction_id = mtl_system_items_interface_s.nextval,
91: transaction_type = Upper(transaction_type),
92: application_id = g_ego_application_id,
93: created_by = G_USER_ID,
94: creation_date = SYSDATE,

Line 171: mtl_system_items_interface_s.nextval,

167: program_application_id,
168: program_id,
169: program_update_date)
170: SELECT transaction_id,
171: mtl_system_items_interface_s.nextval,
172: NULL,
173: NULL,
174: G_ENTITY_AG_TAB,
175: G_BO_IDENTIFIER_AG,

Line 232: mtl_system_items_interface_s.nextval,

228: program_application_id,
229: program_id,
230: program_update_date)
231: SELECT transaction_id,
232: mtl_system_items_interface_s.nextval,
233: NULL,
234: NULL,
235: G_ENTITY_DL_TAB,
236: G_BO_IDENTIFIER_AG,

Line 293: mtl_system_items_interface_s.nextval,

289: program_application_id,
290: program_id,
291: program_update_date)
292: SELECT transaction_id,
293: mtl_system_items_interface_s.nextval,
294: NULL,
295: NULL,
296: G_ENTITY_ATTR_TAB,
297: G_BO_IDENTIFIER_AG,

Line 397: mtl_system_items_interface_s.nextval,

393: program_application_id,
394: program_id,
395: program_update_date)
396: SELECT eagi.transaction_id,
397: mtl_system_items_interface_s.nextval,
398: NULL,
399: NULL,
400: G_ENTITY_AG_TAB,
401: G_BO_IDENTIFIER_AG,

Line 468: mtl_system_items_interface_s.nextval,

464: program_application_id,
465: program_id,
466: program_update_date)
467: SELECT eagi.transaction_id,
468: mtl_system_items_interface_s.nextval,
469: NULL,
470: NULL,
471: G_ENTITY_AG_TAB,
472: G_BO_IDENTIFIER_AG,

Line 535: mtl_system_items_interface_s.nextval,

531: program_application_id,
532: program_id,
533: program_update_date)
534: SELECT eagi.transaction_id,
535: mtl_system_items_interface_s.nextval,
536: NULL,
537: NULL,
538: G_ENTITY_DL_TAB,
539: G_BO_IDENTIFIER_AG,

Line 602: mtl_system_items_interface_s.nextval,

598: program_application_id,
599: program_id,
600: program_update_date)
601: SELECT eagi.transaction_id,
602: mtl_system_items_interface_s.nextval,
603: NULL,
604: NULL,
605: G_ENTITY_DL_TAB,
606: G_BO_IDENTIFIER_AG,

Line 675: mtl_system_items_interface_s.nextval,

671: program_application_id,
672: program_id,
673: program_update_date)
674: SELECT eagi.transaction_id,
675: mtl_system_items_interface_s.nextval,
676: NULL,
677: NULL,
678: G_ENTITY_AG_TAB,
679: G_BO_IDENTIFIER_AG,

Line 747: mtl_system_items_interface_s.nextval,

743: program_application_id,
744: program_id,
745: program_update_date)
746: SELECT eagdi.transaction_id,
747: mtl_system_items_interface_s.nextval,
748: NULL,
749: NULL,
750: G_ENTITY_DL_TAB,
751: G_BO_IDENTIFIER_AG,

Line 828: mtl_system_items_interface_s.nextval,

824: program_application_id,
825: program_id,
826: program_update_date)
827: SELECT eagi.transaction_id,
828: mtl_system_items_interface_s.nextval,
829: NULL,
830: NULL,
831: G_ENTITY_AG_TAB,
832: G_BO_IDENTIFIER_AG,

Line 907: mtl_system_items_interface_s.nextval,

903: program_application_id,
904: program_id,
905: program_update_date)
906: SELECT eagi.transaction_id,
907: mtl_system_items_interface_s.nextval,
908: NULL,
909: NULL,
910: G_ENTITY_AG_TAB,
911: G_BO_IDENTIFIER_AG,

Line 988: mtl_system_items_interface_s.nextval,

984: program_application_id,
985: program_id,
986: program_update_date)
987: SELECT eagi.transaction_id,
988: mtl_system_items_interface_s.nextval,
989: NULL,
990: NULL,
991: G_ENTITY_DL_TAB,
992: G_BO_IDENTIFIER_AG,

Line 1071: mtl_system_items_interface_s.nextval,

1067: program_application_id,
1068: program_id,
1069: program_update_date)
1070: SELECT transaction_id,
1071: mtl_system_items_interface_s.nextval,
1072: NULL,
1073: NULL,
1074: G_ENTITY_DL_TAB,
1075: G_BO_IDENTIFIER_AG,

Line 1140: mtl_system_items_interface_s.nextval,

1136: program_application_id,
1137: program_id,
1138: program_update_date)
1139: SELECT eagdi.transaction_id,
1140: mtl_system_items_interface_s.nextval,
1141: NULL,
1142: NULL,
1143: G_ENTITY_DL_TAB,
1144: G_BO_IDENTIFIER_AG,

Line 1240: mtl_system_items_interface_s.nextval,

1236: program_application_id,
1237: program_id,
1238: program_update_date)
1239: SELECT eagdi.transaction_id,
1240: mtl_system_items_interface_s.nextval,
1241: NULL,
1242: NULL,
1243: G_ENTITY_AG_TAB,
1244: G_BO_IDENTIFIER_AG,

Line 1318: mtl_system_items_interface_s.nextval,

1314: program_application_id,
1315: program_id,
1316: program_update_date)
1317: SELECT eagdi.transaction_id,
1318: mtl_system_items_interface_s.nextval,
1319: NULL,
1320: NULL,
1321: G_ENTITY_DL_TAB,
1322: G_BO_IDENTIFIER_AG,

Line 1401: mtl_system_items_interface_s.nextval,

1397: program_application_id,
1398: program_id,
1399: program_update_date)
1400: SELECT transaction_id,
1401: mtl_system_items_interface_s.nextval,
1402: NULL,
1403: NULL,
1404: G_ENTITY_DL_TAB,
1405: G_BO_IDENTIFIER_AG,

Line 1484: mtl_system_items_interface_s.nextval,

1480: program_application_id,
1481: program_id,
1482: program_update_date)
1483: SELECT transaction_id,
1484: mtl_system_items_interface_s.nextval,
1485: NULL,
1486: NULL,
1487: G_ENTITY_DL_TAB,
1488: G_BO_IDENTIFIER_AG,

Line 1559: mtl_system_items_interface_s.nextval,

1555: program_application_id,
1556: program_id,
1557: program_update_date)
1558: SELECT transaction_id,
1559: mtl_system_items_interface_s.nextval,
1560: NULL,
1561: NULL,
1562: G_ENTITY_DL_TAB,
1563: G_BO_IDENTIFIER_AG,

Line 1658: mtl_system_items_interface_s.nextval,

1654: program_application_id,
1655: program_id,
1656: program_update_date)
1657: SELECT transaction_id,
1658: mtl_system_items_interface_s.nextval,
1659: NULL,
1660: NULL,
1661: G_ENTITY_DL_TAB,
1662: G_BO_IDENTIFIER_AG,

Line 1733: mtl_system_items_interface_s.nextval,

1729: program_application_id,
1730: program_id,
1731: program_update_date)
1732: SELECT transaction_id,
1733: mtl_system_items_interface_s.nextval,
1734: NULL,
1735: NULL,
1736: G_ENTITY_AG_TAB,
1737: G_BO_IDENTIFIER_AG,

Line 1834: mtl_system_items_interface_s.nextval,

1830: program_application_id,
1831: program_id,
1832: program_update_date)
1833: SELECT eagi.transaction_id,
1834: mtl_system_items_interface_s.nextval,
1835: NULL,
1836: NULL,
1837: G_ENTITY_ATTR_TAB,
1838: G_BO_IDENTIFIER_AG,

Line 1901: mtl_system_items_interface_s.nextval,

1897: program_application_id,
1898: program_id,
1899: program_update_date)
1900: SELECT eagi.transaction_id,
1901: mtl_system_items_interface_s.nextval,
1902: NULL,
1903: NULL,
1904: G_ENTITY_ATTR_TAB,
1905: G_BO_IDENTIFIER_AG,

Line 1987: mtl_system_items_interface_s.nextval,

1983: program_application_id,
1984: program_id,
1985: program_update_date)
1986: SELECT transaction_id,
1987: mtl_system_items_interface_s.nextval,
1988: NULL,
1989: NULL,
1990: G_ENTITY_ATTR_TAB,
1991: G_BO_IDENTIFIER_AG,

Line 2065: mtl_system_items_interface_s.nextval,

2061: program_application_id,
2062: program_id,
2063: program_update_date)
2064: SELECT transaction_id,
2065: mtl_system_items_interface_s.nextval,
2066: NULL,
2067: NULL,
2068: G_ENTITY_ATTR_TAB,
2069: G_BO_IDENTIFIER_AG,

Line 2139: mtl_system_items_interface_s.nextval,

2135: program_application_id,
2136: program_id,
2137: program_update_date)
2138: SELECT transaction_id,
2139: mtl_system_items_interface_s.nextval,
2140: NULL,
2141: NULL,
2142: G_ENTITY_ATTR_TAB,
2143: G_BO_IDENTIFIER_AG,

Line 2216: mtl_system_items_interface_s.nextval,

2212: program_application_id,
2213: program_id,
2214: program_update_date)
2215: SELECT transaction_id,
2216: mtl_system_items_interface_s.nextval,
2217: NULL,
2218: NULL,
2219: G_ENTITY_ATTR_TAB,
2220: G_BO_IDENTIFIER_AG,

Line 3860: SELECT mtl_system_items_interface_s.nextval

3856:
3857: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
3858:
3859: /*Sets the transaction_id*/
3860: SELECT mtl_system_items_interface_s.nextval
3861: INTO P_ag_tbl(i).transaction_id
3862: FROM dual;
3863:
3864: lv_smt := 2;

Line 3946: SELECT mtl_system_items_interface_s.nextval

3942:
3943: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
3944:
3945: /*Sets the transaction_id*/
3946: SELECT mtl_system_items_interface_s.nextval
3947: INTO P_agdl_tbl(i).transaction_id
3948: FROM dual;
3949:
3950: lv_smt := 2;