APPS.ENG_LAUNCH_ECO_OI_PK dependencies on ENG_CHANGE_LINES_INTERFACE

Line 966: FROM eng_change_lines_interface

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

Line 991: UPDATE eng_change_lines_interface

987: UPDATE eng_eco_revisions_interface
988: SET PROCESS_FLAG = l_process_flag
989: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
990:
991: UPDATE eng_change_lines_interface
992: SET PROCESS_FLAG = l_process_flag
993: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
994:
995: UPDATE eng_revised_items_interface

Line 2183: FROM eng_change_lines_interface

2179: status_name, object_display_name, pk1_name, pk2_name, pk3_name,
2180: pk4_name, pk5_name, assignee_name, need_by_date, scheduled_date,
2181: implementation_date, cancelation_date, original_system_reference,
2182: return_status, transaction_type
2183: FROM eng_change_lines_interface
2184: WHERE eng_changes_ifce_key = g_ECO_ifce_key
2185: AND process_flag = 1
2186: AND (g_all_org = 1
2187: OR

Line 6201: DELETE from eng_change_lines_interface

6197: END LOOP;
6198:
6199: stmt_num := 519;
6200: LOOP
6201: DELETE from eng_change_lines_interface
6202: WHERE process_flag = 7
6203: AND rownum < G_ROWS_TO_COMMIT;
6204:
6205: EXIT when SQL%NOTFOUND;