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 983: UPDATE eng_eco_revisions_interface

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
984: SET PROCESS_FLAG = l_process_flag
985: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
986:
987: UPDATE eng_change_lines_interface

Line 1090: UPDATE eng_eco_revisions_interface SET

1086: p_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type
1087: ) IS
1088: BEGIN
1089: FOR i IN 1..p_rev_tbl.COUNT LOOP
1090: UPDATE eng_eco_revisions_interface SET
1091: attribute11 = p_rev_tbl(i).attribute11,
1092: attribute12 = p_rev_tbl(i).attribute12,
1093: attribute13 = p_rev_tbl(i).attribute13,
1094: attribute14 = p_rev_tbl(i).attribute14,

Line 3025: UPDATE eng_eco_revisions_interface eeri

3021: FROM mtl_parameters mp2
3022: WHERE mp2.organization_code = eeci.organization_code);
3023:
3024: stmt_num := 4;
3025: UPDATE eng_eco_revisions_interface eeri
3026: SET organization_id = (SELECT organization_id
3027: FROM mtl_parameters mp1
3028: WHERE mp1.organization_code = eeri.organization_code)
3029: WHERE process_flag = 1

Line 3150: UPDATE eng_eco_revisions_interface

3146: OR
3147: (p_all_org = 2 AND organization_id = p_org_id));
3148:
3149: stmt_num := 10.2;
3150: UPDATE eng_eco_revisions_interface
3151: SET transaction_id = mtl_system_items_interface_s.nextval,
3152: transaction_type = UPPER(transaction_type)
3153: WHERE process_flag = 1
3154: AND (transaction_id is NULL

Line 6121: DELETE from eng_eco_revisions_interface

6117: END LOOP;
6118:
6119: stmt_num := 514;
6120: LOOP
6121: DELETE from eng_eco_revisions_interface
6122: WHERE process_flag = 7
6123: AND rownum < G_ROWS_TO_COMMIT;
6124:
6125: EXIT when SQL%NOTFOUND;