DBA Data[Home] [Help]

APPS.EGO_PAGES_BULKLOAD_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 38: SET transaction_id = mtl_system_items_interface_s.nextval,

34: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
35:
36: /*Sets the Transaction_id and upper case the transaction_type for pages interface table*/
37: UPDATE ego_pages_interface
38: SET transaction_id = mtl_system_items_interface_s.nextval,
39: transaction_type = Upper(transaction_type),
40: created_by = G_USER_ID,
41: creation_date = SYSDATE,
42: last_updated_by = G_USER_ID,

Line 66: SET transaction_id = mtl_system_items_interface_s.nextval,

62: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
63:
64: /*Sets the Transaction_id and upper case the transaction_type for page entries interface table*/
65: UPDATE ego_page_entries_interface
66: SET transaction_id = mtl_system_items_interface_s.nextval,
67: transaction_type = Upper(transaction_type),
68: created_by = G_USER_ID,
69: creation_date = SYSDATE,
70: last_updated_by = G_USER_ID,

Line 144: mtl_system_items_interface_s.nextval,

140: program_application_id,
141: program_id,
142: program_update_date)
143: SELECT transaction_id,
144: mtl_system_items_interface_s.nextval,
145: NULL,
146: NULL,
147: G_ENTITY_PG_TAB,
148: G_BO_IDENTIFIER_PG,

Line 205: mtl_system_items_interface_s.nextval,

201: program_application_id,
202: program_id,
203: program_update_date)
204: SELECT transaction_id,
205: mtl_system_items_interface_s.nextval,
206: NULL,
207: NULL,
208: G_ENTITY_ENT_TAB,
209: G_BO_IDENTIFIER_PG,

Line 1403: mtl_system_items_interface_s.nextval,

1399: program_application_id,
1400: program_id,
1401: program_update_date)
1402: SELECT transaction_id,
1403: mtl_system_items_interface_s.nextval,
1404: NULL,
1405: NULL,
1406: G_ENTITY_PG_TAB,
1407: G_BO_IDENTIFIER_PG,

Line 1470: mtl_system_items_interface_s.nextval,

1466: program_application_id,
1467: program_id,
1468: program_update_date)
1469: SELECT transaction_id,
1470: mtl_system_items_interface_s.nextval,
1471: NULL,
1472: NULL,
1473: G_ENTITY_PG_TAB,
1474: G_BO_IDENTIFIER_PG,

Line 1539: mtl_system_items_interface_s.nextval,

1535: program_application_id,
1536: program_id,
1537: program_update_date)
1538: SELECT transaction_id,
1539: mtl_system_items_interface_s.nextval,
1540: NULL,
1541: NULL,
1542: G_ENTITY_PG_TAB,
1543: G_BO_IDENTIFIER_PG,

Line 1614: mtl_system_items_interface_s.nextval,

1610: program_application_id,
1611: program_id,
1612: program_update_date)
1613: SELECT transaction_id,
1614: mtl_system_items_interface_s.nextval,
1615: NULL,
1616: NULL,
1617: G_ENTITY_PG_TAB,
1618: G_BO_IDENTIFIER_PG,

Line 1717: mtl_system_items_interface_s.nextval,

1713: program_application_id,
1714: program_id,
1715: program_update_date)
1716: SELECT transaction_id,
1717: mtl_system_items_interface_s.nextval,
1718: NULL,
1719: NULL,
1720: G_ENTITY_ENT_TAB,
1721: G_BO_IDENTIFIER_PG,

Line 1794: mtl_system_items_interface_s.nextval,

1790: program_application_id,
1791: program_id,
1792: program_update_date)
1793: SELECT transaction_id,
1794: mtl_system_items_interface_s.nextval,
1795: NULL,
1796: NULL,
1797: G_ENTITY_ENT_TAB,
1798: G_BO_IDENTIFIER_PG,