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 979: UPDATE eng_eng_changes_interface

975: ELSE
976: l_process_flag := G_PF_ERROR;
977: END IF;
978:
979: UPDATE eng_eng_changes_interface
980: SET PROCESS_FLAG = l_process_flag
981: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
982:
983: UPDATE eng_eco_revisions_interface

Line 1030: UPDATE eng_eng_changes_interface

1026: PROCEDURE Update_Eco_Interface (
1027: p_eco_rec ENG_Eco_PUB.Eco_Rec_Type
1028: ) IS
1029: BEGIN
1030: UPDATE eng_eng_changes_interface
1031: SET ATTRIBUTE7 = p_eco_rec.attribute7
1032: , ATTRIBUTE8 = p_eco_rec.attribute8
1033: , ATTRIBUTE9 = p_eco_rec.attribute9
1034: , ATTRIBUTE10 = p_eco_rec.attribute10

Line 3012: UPDATE eng_eng_changes_interface eeci

3008: -- SET ORG IDS
3009:
3010: --dbms_output.put_line('Set org ids');
3011: stmt_num := 3;
3012: UPDATE eng_eng_changes_interface eeci
3013: SET organization_id = (SELECT organization_id
3014: FROM mtl_parameters mp1
3015: WHERE mp1.organization_code = eeci.organization_code)
3016: WHERE process_flag = 1

Line 3139: UPDATE eng_eng_changes_interface

3135: -- SET TRANSACTION IDS
3136:
3137: --dbms_output.put_line('Set transaction ids');
3138: stmt_num := 10.1;
3139: UPDATE eng_eng_changes_interface
3140: SET transaction_id = mtl_system_items_interface_s.nextval,
3141: transaction_type = UPPER(transaction_type)
3142: WHERE process_flag = 1
3143: AND (transaction_id is NULL

Line 6111: DELETE from eng_eng_changes_interface

6107:
6108: stmt_num := 513;
6109: IF (p_del_rec_flag = 1) THEN
6110: LOOP
6111: DELETE from eng_eng_changes_interface
6112: WHERE process_flag = 7
6113: AND rownum < G_ROWS_TO_COMMIT;
6114:
6115: EXIT when SQL%NOTFOUND;