APPS.ENG_LAUNCH_ECO_OI_PK dependencies on ENG_ECO_REVISIONS_INTERFACE

Line 120: FROM eng_eco_revisions_interface

116: attribute2, attribute3, attribute4, attribute5, attribute6,
117: attribute7, attribute8, attribute9, attribute10, new_revision,
118: process_flag, transaction_id,transaction_type, ORGANIZATION_CODE,
119: eng_changes_ifce_key
120: FROM eng_eco_revisions_interface
121: WHERE eng_changes_ifce_key = g_ECO_ifce_key
122: AND process_flag = 1
123: AND (g_all_org = 1
124: OR

Line 132: FROM eng_eco_revisions_interface

128: -- Group ECO revisions by ECO Header ifce values
129:
130: CURSOR GetRevWithSameECOifce IS
131: SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
132: FROM eng_eco_revisions_interface
133: WHERE process_flag = 1
134: AND (g_all_org = 1
135: OR
136: (g_all_org = 2 AND organization_id = g_org_id));

Line 150: FROM eng_eco_revisions_interface

146: attribute2, attribute3, attribute4, attribute5, attribute6,
147: attribute7, attribute8, attribute9, attribute10, new_revision,
148: process_flag, transaction_id,transaction_type, ORGANIZATION_CODE,
149: eng_changes_ifce_key, eng_eco_revisions_ifce_key
150: FROM eng_eco_revisions_interface
151: WHERE process_flag = 1
152: AND (g_all_org = 1
153: OR
154: (g_all_org = 2 AND organization_id = g_org_id));

Line 987: UPDATE eng_eco_revisions_interface

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
988: SET PROCESS_FLAG = l_process_flag
989: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
990:
991: UPDATE eng_change_lines_interface

Line 1094: UPDATE eng_eco_revisions_interface SET

1090: p_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type
1091: ) IS
1092: BEGIN
1093: FOR i IN 1..p_rev_tbl.COUNT LOOP
1094: UPDATE eng_eco_revisions_interface SET
1095: attribute11 = p_rev_tbl(i).attribute11,
1096: attribute12 = p_rev_tbl(i).attribute12,
1097: attribute13 = p_rev_tbl(i).attribute13,
1098: attribute14 = p_rev_tbl(i).attribute14,

Line 3031: UPDATE eng_eco_revisions_interface eeri

3027: FROM mtl_parameters mp2
3028: WHERE mp2.organization_code = eeci.organization_code);
3029:
3030: stmt_num := 4;
3031: UPDATE eng_eco_revisions_interface eeri
3032: SET organization_id = (SELECT organization_id
3033: FROM mtl_parameters mp1
3034: WHERE mp1.organization_code = eeri.organization_code)
3035: WHERE process_flag = 1

Line 3156: UPDATE eng_eco_revisions_interface

3152: OR
3153: (p_all_org = 2 AND organization_id = p_org_id));
3154:
3155: stmt_num := 10.2;
3156: UPDATE eng_eco_revisions_interface
3157: SET transaction_id = mtl_system_items_interface_s.nextval,
3158: transaction_type = UPPER(transaction_type)
3159: WHERE process_flag = 1
3160: AND (transaction_id is NULL

Line 6151: DELETE from eng_eco_revisions_interface

6147: END LOOP;
6148:
6149: stmt_num := 514;
6150: LOOP
6151: DELETE from eng_eco_revisions_interface
6152: WHERE process_flag = 7
6153: AND rownum < G_ROWS_TO_COMMIT;
6154:
6155: EXIT when SQL%NOTFOUND;