APPS.BOM_RTG_OI_UTIL dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 156: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

152: stmt_num := 5;
153: /* Assign transaction ids */
154:
155: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
156: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
157: WHERE transaction_id is null
158: --Bug 3411601 AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
159: AND upper(transaction_type) in (G_Create, G_Update, G_Delete, 'NO_OP')
160: AND process_flag = 1

Line 383: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

379: PROGRAM_UPDATE_DATE
380: )
381: Select
382: BORI.transaction_id,
383: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
384: Null,
385: null,
386: 'BOM_OP_ROUTINGS_INTERFACE',
387: decode ( BORI.Organization_code, null, msg_name1,msg_name2),

Line 585: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

581: stmt_num := 6;
582: /* Assign transaction ids */
583:
584: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
585: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
586: WHERE transaction_id is null
587: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
588: AND process_flag = 1
589: AND

Line 949: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

945: PROGRAM_UPDATE_DATE
946: )
947: Select
948: BOSI.transaction_id,
949: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
950: Null,
951: null,
952: 'BOM_OP_SEQUENCES_INTERFACE',
953: decode ( BOSI.Organization_code, null, msg_name1,msg_name2),

Line 1169: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1165: stmt_num := 7;
1166: /* Assign transaction ids */
1167:
1168: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1169: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1170: WHERE transaction_id is null
1171: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1172: AND process_flag = 1
1173: AND

Line 1228: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1224: PROGRAM_UPDATE_DATE
1225: )
1226: Select
1227: BORI.transaction_id,
1228: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1229: Null,
1230: null,
1231: 'BOM_OP_RESOURCES_INTERFACE',
1232: decode ( BORI.Organization_code, null, msg_name1,msg_name2),

Line 1446: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1442: stmt_num := 7;
1443: /* Assign transaction ids */
1444:
1445: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1446: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1447: WHERE transaction_id is null
1448: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1449: AND process_flag = 1
1450: AND

Line 1504: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1500: PROGRAM_UPDATE_DATE
1501: )
1502: Select
1503: BSORI.transaction_id,
1504: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1505: Null,
1506: null,
1507: 'BOM_SUB_OP_RESOURCES_INTERFACE',
1508: decode ( BSORI.Organization_code, null, msg_name1,msg_name2),

Line 1716: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1712:
1713: stmt_num := 6;
1714: /* Assign transaction ids */
1715: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1716: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1717: WHERE transaction_id is null
1718: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1719: AND process_flag = 1
1720: AND

Line 1775: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1771: PROGRAM_UPDATE_DATE
1772: )
1773: Select
1774: BONI.transaction_id,
1775: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1776: Null,
1777: null,
1778: 'BOM_OP_NETWORKS_INTERFACE',
1779: decode ( BONI.Organization_code, null, msg_name1,msg_name2),

Line 1928: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

1924: stmt_num := 4;
1925: /* Assign transaction ids */
1926:
1927: UPDATE MTL_RTG_ITEM_REVS_INTERFACE MRIRI
1928: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1929: WHERE transaction_id is null
1930: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1931: AND process_flag = 1
1932: AND

Line 1989: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

1985: PROGRAM_UPDATE_DATE
1986: )
1987: Select
1988: MRIRI.transaction_id,
1989: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1990: Null,
1991: null,
1992: 'MTL_RTG_ITEM_REVS_INTERFACE',
1993: decode ( MRIRI.Organization_code, null, msg_name1,msg_name2),