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 583: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

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

Line 947: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

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

Line 1167: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

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

Line 1226: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

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

Line 1444: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

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

Line 1502: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

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

Line 1714: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

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

Line 1773: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

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

Line 1926: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

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

Line 1987: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,

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