[Home] [Help]
811: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
812: bom_sub_comps_ifce_key
813: --Bug 3396529: Added New_revised_Item_Revision
814: , New_revised_Item_Revision
815: FROM bom_sub_comps_interface
816: WHERE eng_changes_ifce_key = g_ECO_ifce_key
817: and process_flag = 1
818: AND (g_all_org = 1
819: OR
823: -- Group substitute components by ECO Header ifce values
824:
825: CURSOR GetSbcWithSameECOifce IS
826: SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
827: FROM bom_sub_comps_interface
828: WHERE process_flag = 1
829: AND (g_all_org = 1
830: OR
831: (g_all_org = 2 AND organization_id = g_org_id));
848: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
849: bom_sub_comps_ifce_key
850: --Bug 3396529: Added New_revised_Item_Revision
851: , New_revised_Item_Revision
852: FROM bom_sub_comps_interface
853: WHERE eng_revised_items_ifce_key = g_revised_item_ifce_key
854: AND interface_entity_type = 'ECO'
855: AND process_flag = 1
856: AND (g_all_org = 1
861: -- Group substitute components by revised item ifce values
862:
863: CURSOR GetSbcWithSameItemifce IS
864: SELECT DISTINCT(eng_revised_items_ifce_key) item_ifce_key
865: FROM bom_sub_comps_interface
866: WHERE process_flag = 1
867: AND (g_all_org = 1
868: OR
869: (g_all_org = 2 AND organization_id = g_org_id));
886: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
887: bom_sub_comps_ifce_key
888: --Bug 3396529: Added New_revised_Item_Revision
889: , New_revised_Item_Revision
890: FROM bom_sub_comps_interface
891: WHERE bom_inventory_comps_ifce_key = g_revised_comp_ifce_key
892: AND interface_entity_type = 'ECO'
893: AND process_flag = 1
894: AND (g_all_org = 1
899: -- Group substitute components by revised component ifce values
900:
901: CURSOR GetSbcWithSameCompifce IS
902: SELECT DISTINCT(bom_inventory_comps_ifce_key) comp_ifce_key
903: FROM bom_sub_comps_interface
904: WHERE process_flag = 1
905: AND (g_all_org = 1
906: OR
907: (g_all_org = 2 AND organization_id = g_org_id));
924: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
925: bom_sub_comps_ifce_key
926: --Bug 3396529: Added New_revised_Item_Revision
927: , New_revised_Item_Revision
928: FROM bom_sub_comps_interface
929: WHERE process_flag = 1
930: AND (g_all_org = 1
931: OR
932: (g_all_org = 2 AND organization_id = g_org_id));
995: UPDATE bom_inventory_comps_interface
996: SET PROCESS_FLAG = l_process_flag
997: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
998:
999: UPDATE bom_sub_comps_interface
1000: SET PROCESS_FLAG = l_process_flag
1001: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1002:
1003: UPDATE bom_ref_desgs_interface
1283: p_sub_comp_tbl BOM_Bo_PUB.Sub_Component_Tbl_Type
1284: ) IS
1285: BEGIN
1286: FOR i IN 1..p_sub_comp_tbl.COUNT LOOP
1287: UPDATE bom_sub_comps_interface SET
1288: -- substitute_component_id = p_sub_comp_tbl(i).substitute_component_id,
1289: -- last_update_date = p_sub_comp_tbl(i).last_update_date,
1290: -- last_updated_by = p_sub_comp_tbl(i).last_updated_by,
1291: -- creation_date = p_sub_comp_tbl(i).creation_date,
3062: FROM mtl_parameters mp2
3063: WHERE mp2.organization_code = bici.organization_code);
3064:
3065: stmt_num := 7;
3066: UPDATE bom_sub_comps_interface bsci
3067: SET organization_id = (SELECT organization_id
3068: FROM mtl_parameters mp1
3069: WHERE mp1.organization_code = bsci.organization_code)
3070: WHERE process_flag = 1
3180: OR
3181: (p_all_org = 2 AND organization_id = p_org_id));
3182:
3183: stmt_num := 10.5;
3184: UPDATE bom_sub_comps_interface
3185: SET transaction_id = mtl_system_items_interface_s.nextval,
3186: transaction_type = UPPER(transaction_type)
3187: WHERE process_flag = 1
3188: AND (transaction_id is NULL
6157: END LOOP;
6158:
6159: stmt_num := 518;
6160: LOOP
6161: DELETE from bom_sub_comps_interface
6162: WHERE process_flag = 7
6163: AND rownum < G_ROWS_TO_COMMIT;
6164:
6165: EXIT when SQL%NOTFOUND;