APPS.ENG_LAUNCH_ECO_OI_PK dependencies on ENG_ENG_CHANGES_INTERFACE

Line 102: FROM eng_eng_changes_interface

98: , source_type_name
99: , source_name
100: , need_by_date
101: , eco_department_name
102: FROM eng_eng_changes_interface
103: WHERE process_flag = 1
104: AND (g_all_org = 1
105: OR
106: (g_all_org = 2 AND organization_id = g_org_id));

Line 983: UPDATE eng_eng_changes_interface

979: ELSE
980: l_process_flag := G_PF_ERROR;
981: END IF;
982:
983: UPDATE eng_eng_changes_interface
984: SET PROCESS_FLAG = l_process_flag
985: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
986:
987: UPDATE eng_eco_revisions_interface

Line 1034: UPDATE eng_eng_changes_interface

1030: PROCEDURE Update_Eco_Interface (
1031: p_eco_rec ENG_Eco_PUB.Eco_Rec_Type
1032: ) IS
1033: BEGIN
1034: UPDATE eng_eng_changes_interface
1035: SET ATTRIBUTE7 = p_eco_rec.attribute7
1036: , ATTRIBUTE8 = p_eco_rec.attribute8
1037: , ATTRIBUTE9 = p_eco_rec.attribute9
1038: , ATTRIBUTE10 = p_eco_rec.attribute10

Line 3018: UPDATE eng_eng_changes_interface eeci

3014: -- SET ORG IDS
3015:
3016: --dbms_output.put_line('Set org ids');
3017: stmt_num := 3;
3018: UPDATE eng_eng_changes_interface eeci
3019: SET organization_id = (SELECT organization_id
3020: FROM mtl_parameters mp1
3021: WHERE mp1.organization_code = eeci.organization_code)
3022: WHERE process_flag = 1

Line 3145: UPDATE eng_eng_changes_interface

3141: -- SET TRANSACTION IDS
3142:
3143: --dbms_output.put_line('Set transaction ids');
3144: stmt_num := 10.1;
3145: UPDATE eng_eng_changes_interface
3146: SET transaction_id = mtl_system_items_interface_s.nextval,
3147: transaction_type = UPPER(transaction_type)
3148: WHERE process_flag = 1
3149: AND (transaction_id is NULL

Line 6141: DELETE from eng_eng_changes_interface

6137:
6138: stmt_num := 513;
6139: IF (p_del_rec_flag = 1) THEN
6140: LOOP
6141: DELETE from eng_eng_changes_interface
6142: WHERE process_flag = 7
6143: AND rownum < G_ROWS_TO_COMMIT;
6144:
6145: EXIT when SQL%NOTFOUND;