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.EGO_ICC_BULKLOAD_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 129: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

125: ,PROGRAM_ID
126: ,PROGRAM_UPDATE_DATE
127: )
128: SELECT transaction_id
129: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
130: ,null
131: ,null
132: ,G_ENTITY_ICC_HEADER_TAB
133: ,l_msg_name

Line 213: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

209: ,PROGRAM_ID
210: ,PROGRAM_UPDATE_DATE
211: )
212: SELECT transaction_id
213: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
214: ,null
215: ,null
216: ,G_ENTITY_ICC_HEADER_TAB
217: ,l_msg_name

Line 289: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

285: ,PROGRAM_ID
286: ,PROGRAM_UPDATE_DATE
287: )
288: SELECT transaction_id
289: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
290: ,null
291: ,null
292: ,G_ENTITY_FUNC_PARAM_MAP_TAB
293: ,l_msg_name

Line 371: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

367: ,PROGRAM_ID
368: ,PROGRAM_UPDATE_DATE
369: )
370: SELECT transaction_id
371: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
372: ,null
373: ,null
374: ,G_ENTITY_ICC_VERS_TAB
375: ,l_msg_name

Line 477: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

473: ,PROGRAM_ID
474: ,PROGRAM_UPDATE_DATE
475: )
476: SELECT transaction_id
477: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
478: ,null
479: ,null
480: ,G_ENTITY_ICC_HEADER_TAB
481: ,l_msg_name

Line 577: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

573: ,PROGRAM_ID
574: ,PROGRAM_UPDATE_DATE
575: )
576: SELECT transaction_id
577: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
578: ,null
579: ,null
580: ,G_ENTITY_ICC_HEADER_TAB
581: ,l_msg_name

Line 652: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

648: ,PROGRAM_ID
649: ,PROGRAM_UPDATE_DATE
650: )
651: SELECT transaction_id
652: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
653: ,null
654: ,null
655: ,G_ENTITY_FUNC_PARAM_MAP_TAB
656: ,l_msg_name

Line 751: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

747: ,PROGRAM_ID
748: ,PROGRAM_UPDATE_DATE
749: )
750: SELECT transaction_id
751: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
752: ,null
753: ,null
754: ,G_ENTITY_ICC_VERS_TAB
755: ,l_msg_name

Line 822: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

818: ,PROGRAM_ID
819: ,PROGRAM_UPDATE_DATE
820: )
821: SELECT transaction_id
822: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
823: ,null
824: ,null
825: ,G_ENTITY_ICC_VERS_TAB
826: ,l_msg_name

Line 898: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

894: ,PROGRAM_ID
895: ,PROGRAM_UPDATE_DATE
896: )
897: SELECT transaction_id
898: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
899: ,null
900: ,null
901: ,G_ENTITY_ICC_VERS_TAB
902: ,l_msg_name

Line 1065: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1061: ,PROGRAM_ID
1062: ,PROGRAM_UPDATE_DATE
1063: )
1064: SELECT transaction_id
1065: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1066: ,null
1067: ,null
1068: ,G_ENTITY_ICC_HEADER_TAB
1069: ,l_msg_name

Line 1180: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1176: ,PROGRAM_ID
1177: ,PROGRAM_UPDATE_DATE
1178: )
1179: SELECT transaction_id
1180: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1181: ,null
1182: ,null
1183: ,G_ENTITY_ICC_HEADER_TAB
1184: ,l_msg_name

Line 1333: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1329: ,PROGRAM_ID
1330: ,PROGRAM_UPDATE_DATE
1331: )
1332: SELECT transaction_id
1333: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1334: ,null
1335: ,null
1336: ,G_ENTITY_ICC_AG_ASSOC_TAB
1337: ,l_msg_name

Line 1390: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1386: ,PROGRAM_ID
1387: ,PROGRAM_UPDATE_DATE
1388: )
1389: SELECT transaction_id
1390: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1391: ,null
1392: ,null
1393: ,G_ENTITY_ICC_AG_ASSOC_TAB
1394: ,l_msg_name2

Line 1718: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1714: ,PROGRAM_ID
1715: ,PROGRAM_UPDATE_DATE
1716: )
1717: SELECT transaction_id
1718: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1719: ,null
1720: ,null
1721: ,G_ENTITY_FUNC_PARAM_MAP_TAB
1722: ,l_msg_name

Line 1769: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1765: ,PROGRAM_ID
1766: ,PROGRAM_UPDATE_DATE
1767: )
1768: SELECT transaction_id
1769: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1770: ,null
1771: ,null
1772: ,G_ENTITY_FUNC_PARAM_MAP_TAB
1773: ,l_msg_name2

Line 1820: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1816: ,PROGRAM_ID
1817: ,PROGRAM_UPDATE_DATE
1818: )
1819: SELECT transaction_id
1820: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1821: ,null
1822: ,null
1823: ,G_ENTITY_FUNC_PARAM_MAP_TAB
1824: ,l_msg_name3

Line 1875: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1871: ,PROGRAM_ID
1872: ,PROGRAM_UPDATE_DATE
1873: )
1874: SELECT transaction_id
1875: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1876: ,null
1877: ,null
1878: ,G_ENTITY_FUNC_PARAM_MAP_TAB
1879: ,l_msg_name3

Line 1927: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1923: ,PROGRAM_ID
1924: ,PROGRAM_UPDATE_DATE
1925: )
1926: SELECT transaction_id
1927: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1928: ,null
1929: ,null
1930: ,G_ENTITY_FUNC_PARAM_MAP_TAB
1931: ,l_msg_name5

Line 2054: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

2050: ,PROGRAM_ID
2051: ,PROGRAM_UPDATE_DATE
2052: )
2053: SELECT transaction_id
2054: ,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
2055: ,null
2056: ,null
2057: ,G_ENTITY_ICC_VERS_TAB
2058: ,l_msg_name

Line 9723: SET transaction_id = mtl_system_items_interface_s.nextval

9719: IF p_entity = G_ENTITY_ICC_HEADER THEN
9720: write_debug(l_proc_name,'Inside header update ');
9721:
9722: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE
9723: SET transaction_id = mtl_system_items_interface_s.nextval
9724: ,transaction_type = upper(transaction_type)
9725: ,creation_date = nvl(creation_date, l_sysdate)
9726: ,created_by = NVL(created_by , G_USER_ID)
9727: ,last_updated_by = G_USER_ID

Line 9749: SET transaction_id = mtl_system_items_interface_s.nextval

9745:
9746: write_debug(l_proc_name,'start ag assoc update ');
9747:
9748: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE
9749: SET transaction_id = mtl_system_items_interface_s.nextval
9750: ,transaction_type = upper(transaction_type)
9751: ,creation_date = nvl(creation_date, l_sysdate)
9752: ,created_by = NVL(created_by , G_USER_ID)
9753: ,last_updated_by = G_USER_ID

Line 9775: SET transaction_id = mtl_system_items_interface_s.nextval

9771:
9772: write_debug(l_proc_name,'start func param update ');
9773:
9774: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE
9775: SET transaction_id = mtl_system_items_interface_s.nextval
9776: ,transaction_type = upper(transaction_type)
9777: ,creation_date = nvl(creation_date, l_sysdate)
9778: ,created_by = NVL(created_by , G_USER_ID)
9779: ,last_updated_by = G_USER_ID

Line 9801: SET transaction_id = mtl_system_items_interface_s.nextval

9797:
9798: write_debug(l_proc_name,'start icc vers update ');
9799:
9800: UPDATE EGO_ICC_VERS_INTERFACE
9801: SET transaction_id = mtl_system_items_interface_s.nextval
9802: ,transaction_type = upper(transaction_type)
9803: ,creation_date = nvl(creation_date, l_sysdate)
9804: ,created_by = NVL(created_by , G_USER_ID)
9805: ,last_updated_by = G_USER_ID