APPS.ENG_LAUNCH_ECO_OI_PK dependencies on ENG_REVISED_ITEMS_INTERFACE

Line 231: FROM eng_revised_items_interface

227: New_Revised_Item_Rev_Desc ,
228: new_revision_reason ,
229: from_end_item_unit_number
230: /*Bug 6377841*/
231: FROM eng_revised_items_interface
232: WHERE eng_changes_ifce_key = g_ECO_ifce_key
233: AND process_flag = 1
234: AND (g_all_org = 1
235: OR (g_all_org = 2

Line 244: FROM eng_revised_items_interface

240: -- Group revised items by ECO Header ifce values
241:
242: CURSOR GetItemWithSameECOifce IS
243: SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
244: FROM eng_revised_items_interface
245: WHERE process_flag = 1
246: AND (g_all_org = 1
247: OR
248: (g_all_org = 2 AND organization_id = g_org_id));

Line 323: FROM eng_revised_items_interface

319: New_Revised_Item_Rev_Desc ,
320: new_revision_reason ,
321: from_end_item_unit_number
322: /*Bug 6377841*/
323: FROM eng_revised_items_interface
324: WHERE process_flag = 1
325: AND (g_all_org = 1
326: OR (g_all_org = 2
327: AND organization_id = g_org_id))

Line 995: UPDATE eng_revised_items_interface

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
996: SET PROCESS_FLAG = l_process_flag
997: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
998:
999: UPDATE bom_inventory_comps_interface

Line 1138: UPDATE eng_revised_items_interface SET

1134: p_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type
1135: ) IS
1136: BEGIN
1137: FOR i IN 1..p_rev_item_tbl.COUNT LOOP
1138: UPDATE eng_revised_items_interface SET
1139: -- change_notice = p_rev_item_tbl(i).change_notice,
1140: -- organization_id = p_rev_item_tbl(i).organization_id,
1141: -- revised_item_id = p_rev_item_tbl(i).revised_item_id,
1142: -- last_update_date = p_rev_item_tbl(i).last_update_date,

Line 3044: UPDATE eng_revised_items_interface erii

3040: FROM mtl_parameters mp2
3041: WHERE mp2.organization_code = eeri.organization_code);
3042:
3043: stmt_num := 5;
3044: UPDATE eng_revised_items_interface erii
3045: SET organization_id = (SELECT organization_id
3046: FROM mtl_parameters mp1
3047: WHERE mp1.organization_code = erii.organization_code)
3048: WHERE process_flag = 1

Line 3167: UPDATE eng_revised_items_interface

3163: OR
3164: (p_all_org = 2 AND organization_id = p_org_id));
3165:
3166: stmt_num := 10.3;
3167: UPDATE eng_revised_items_interface
3168: SET transaction_id = mtl_system_items_interface_s.nextval,
3169: transaction_type = UPPER(transaction_type)
3170: WHERE process_flag = 1
3171: AND (transaction_id is NULL

Line 6161: DELETE from eng_revised_items_interface

6157: END LOOP;
6158:
6159: stmt_num := 515;
6160: LOOP
6161: DELETE from eng_revised_items_interface
6162: WHERE process_flag = 7
6163: AND rownum < G_ROWS_TO_COMMIT;
6164:
6165: EXIT when SQL%NOTFOUND;

Line 6384: FROM eng_revised_items_interface

6380: new_revision_label ,
6381: New_Revised_Item_Rev_Desc ,
6382: new_revision_reason ,
6383: from_end_item_unit_number
6384: FROM eng_revised_items_interface
6385: WHERE process_flag = -999
6386: AND (g_all_org = 1
6387: OR (g_all_org = 2
6388: AND organization_id = g_org_id))

Line 6566: UPDATE ENG_REVISED_ITEMS_INTERFACE

6562: ELSE
6563: l_process_flag := G_PF_ERROR;
6564: END IF;
6565:
6566: UPDATE ENG_REVISED_ITEMS_INTERFACE
6567: SET PROCESS_FLAG = l_process_flag
6568: WHERE TRANSACTION_ID = l_transaction_id;
6569:
6570: stmt_num := 255;

Line 6595: DELETE from eng_revised_items_interface

6591: stmt_num := 513;
6592: IF (p_del_rec_flag = 1) THEN
6593: stmt_num := 515;
6594: LOOP
6595: DELETE from eng_revised_items_interface
6596: WHERE process_flag = 7
6597: AND rownum < G_ROWS_TO_COMMIT;
6598:
6599: EXIT when SQL%NOTFOUND;