APPS.ENG_LAUNCH_ECO_OI_PK dependencies on ENG_CHANGE_LINES_INTERFACE

Line 962: FROM eng_change_lines_interface

958: -- Group ECO revisions by ECO Header ifce values
959:
960: CURSOR GetLinesWithSameECOifce IS
961: SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key -- Bug 4033384
962: FROM eng_change_lines_interface
963: WHERE process_flag = 1
964: AND (g_all_org = 1
965: OR
966: (g_all_org = 2 AND organization_id = g_org_id));

Line 987: UPDATE eng_change_lines_interface

983: UPDATE eng_eco_revisions_interface
984: SET PROCESS_FLAG = l_process_flag
985: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
986:
987: UPDATE eng_change_lines_interface
988: SET PROCESS_FLAG = l_process_flag
989: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
990:
991: UPDATE eng_revised_items_interface

Line 2178: FROM eng_change_lines_interface

2174: status_name, object_display_name, pk1_name, pk2_name, pk3_name,
2175: pk4_name, pk5_name, assignee_name, need_by_date, scheduled_date,
2176: implementation_date, cancelation_date, original_system_reference,
2177: return_status, transaction_type
2178: FROM eng_change_lines_interface
2179: WHERE eng_changes_ifce_key = g_ECO_ifce_key
2180: AND process_flag = 1
2181: AND (g_all_org = 1
2182: OR

Line 6171: DELETE from eng_change_lines_interface

6167: END LOOP;
6168:
6169: stmt_num := 519;
6170: LOOP
6171: DELETE from eng_change_lines_interface
6172: WHERE process_flag = 7
6173: AND rownum < G_ROWS_TO_COMMIT;
6174:
6175: EXIT when SQL%NOTFOUND;