APPS.ENG_LAUNCH_ECO_OI_PK dependencies on BOM_OP_SEQUENCES_INTERFACE

Line 955: FROM bom_op_sequences_interface

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

Line 1015: UPDATE bom_op_sequences_interface

1011: UPDATE bom_op_resources_interface
1012: SET PROCESS_FLAG = l_process_flag
1013: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1014:
1015: UPDATE bom_op_sequences_interface
1016: SET PROCESS_FLAG = l_process_flag
1017: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1018:
1019: UPDATE bom_sub_op_resources_interface

Line 2241: FROM bom_op_sequences_interface

2237: attribute11, attribute12, attribute13, attribute14, attribute15,
2238: original_system_reference, transaction_type
2239: -- Bug 3412268: Added New_Revised_Item_Revision
2240: , New_Revised_Item_Revision
2241: FROM bom_op_sequences_interface
2242: WHERE eng_changes_ifce_key = g_ECO_ifce_key;
2243: i NUMBER;
2244: BEGIN
2245: i := 0;

Line 3100: UPDATE bom_op_sequences_interface bosi

3096: FROM mtl_parameters mp2
3097: WHERE mp2.organization_code = brdi.organization_code);
3098:
3099: stmt_num := 8.1;
3100: UPDATE bom_op_sequences_interface bosi
3101: SET organization_id = (SELECT organization_id
3102: FROM mtl_parameters mp1
3103: WHERE mp1.organization_code = bosi.organization_code)
3104: WHERE process_flag = 1

Line 3214: UPDATE bom_op_sequences_interface

3210: OR
3211: (p_all_org = 2 AND organization_id = p_org_id));
3212:
3213: stmt_num := 10.7;
3214: UPDATE bom_op_sequences_interface
3215: SET transaction_id = mtl_system_items_interface_s.nextval,
3216: transaction_type = UPPER(transaction_type)
3217: WHERE process_flag = 1
3218: AND (transaction_id is NULL

Line 6211: DELETE from bom_op_sequences_interface

6207: END LOOP;
6208:
6209: stmt_num := 520;
6210: LOOP
6211: DELETE from bom_op_sequences_interface
6212: WHERE process_flag = 7
6213: AND rownum < G_ROWS_TO_COMMIT;
6214:
6215: EXIT when SQL%NOTFOUND;