APPS.ENG_LAUNCH_ECO_OI_PK dependencies on BOM_OP_SEQUENCES_INTERFACE

Line 951: FROM bom_op_sequences_interface

947: -- Group ECO Revised Operations by ECO Header ifce values
948:
949: CURSOR GetRevOpWithSameECOifce IS
950: SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
951: FROM bom_op_sequences_interface
952: WHERE process_flag = 1
953: AND (g_all_org = 1
954: OR
955: (g_all_org = 2 AND organization_id = g_org_id));

Line 1011: UPDATE bom_op_sequences_interface

1007: UPDATE bom_op_resources_interface
1008: SET PROCESS_FLAG = l_process_flag
1009: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1010:
1011: UPDATE bom_op_sequences_interface
1012: SET PROCESS_FLAG = l_process_flag
1013: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1014:
1015: UPDATE bom_sub_op_resources_interface

Line 2236: FROM bom_op_sequences_interface

2232: attribute11, attribute12, attribute13, attribute14, attribute15,
2233: original_system_reference, transaction_type
2234: -- Bug 3412268: Added New_Revised_Item_Revision
2235: , New_Revised_Item_Revision
2236: FROM bom_op_sequences_interface
2237: WHERE eng_changes_ifce_key = g_ECO_ifce_key;
2238: i NUMBER;
2239: BEGIN
2240: i := 0;

Line 3094: UPDATE bom_op_sequences_interface bosi

3090: FROM mtl_parameters mp2
3091: WHERE mp2.organization_code = brdi.organization_code);
3092:
3093: stmt_num := 8.1;
3094: UPDATE bom_op_sequences_interface bosi
3095: SET organization_id = (SELECT organization_id
3096: FROM mtl_parameters mp1
3097: WHERE mp1.organization_code = bosi.organization_code)
3098: WHERE process_flag = 1

Line 3208: UPDATE bom_op_sequences_interface

3204: OR
3205: (p_all_org = 2 AND organization_id = p_org_id));
3206:
3207: stmt_num := 10.7;
3208: UPDATE bom_op_sequences_interface
3209: SET transaction_id = mtl_system_items_interface_s.nextval,
3210: transaction_type = UPPER(transaction_type)
3211: WHERE process_flag = 1
3212: AND (transaction_id is NULL

Line 6181: DELETE from bom_op_sequences_interface

6177: END LOOP;
6178:
6179: stmt_num := 520;
6180: LOOP
6181: DELETE from bom_op_sequences_interface
6182: WHERE process_flag = 7
6183: AND rownum < G_ROWS_TO_COMMIT;
6184:
6185: EXIT when SQL%NOTFOUND;