[Home] [Help]
815: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
816: bom_sub_comps_ifce_key
817: --Bug 3396529: Added New_revised_Item_Revision
818: , New_revised_Item_Revision
819: FROM bom_sub_comps_interface
820: WHERE eng_changes_ifce_key = g_ECO_ifce_key
821: and process_flag = 1
822: AND (g_all_org = 1
823: OR
827: -- Group substitute components by ECO Header ifce values
828:
829: CURSOR GetSbcWithSameECOifce IS
830: SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
831: FROM bom_sub_comps_interface
832: WHERE process_flag = 1
833: AND (g_all_org = 1
834: OR
835: (g_all_org = 2 AND organization_id = g_org_id));
852: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
853: bom_sub_comps_ifce_key
854: --Bug 3396529: Added New_revised_Item_Revision
855: , New_revised_Item_Revision
856: FROM bom_sub_comps_interface
857: WHERE eng_revised_items_ifce_key = g_revised_item_ifce_key
858: AND interface_entity_type = 'ECO'
859: AND process_flag = 1
860: AND (g_all_org = 1
865: -- Group substitute components by revised item ifce values
866:
867: CURSOR GetSbcWithSameItemifce IS
868: SELECT DISTINCT(eng_revised_items_ifce_key) item_ifce_key
869: FROM bom_sub_comps_interface
870: WHERE process_flag = 1
871: AND (g_all_org = 1
872: OR
873: (g_all_org = 2 AND organization_id = g_org_id));
890: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
891: bom_sub_comps_ifce_key
892: --Bug 3396529: Added New_revised_Item_Revision
893: , New_revised_Item_Revision
894: FROM bom_sub_comps_interface
895: WHERE bom_inventory_comps_ifce_key = g_revised_comp_ifce_key
896: AND interface_entity_type = 'ECO'
897: AND process_flag = 1
898: AND (g_all_org = 1
903: -- Group substitute components by revised component ifce values
904:
905: CURSOR GetSbcWithSameCompifce IS
906: SELECT DISTINCT(bom_inventory_comps_ifce_key) comp_ifce_key
907: FROM bom_sub_comps_interface
908: WHERE process_flag = 1
909: AND (g_all_org = 1
910: OR
911: (g_all_org = 2 AND organization_id = g_org_id));
928: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
929: bom_sub_comps_ifce_key
930: --Bug 3396529: Added New_revised_Item_Revision
931: , New_revised_Item_Revision
932: FROM bom_sub_comps_interface
933: WHERE process_flag = 1
934: AND (g_all_org = 1
935: OR
936: (g_all_org = 2 AND organization_id = g_org_id));
999: UPDATE bom_inventory_comps_interface
1000: SET PROCESS_FLAG = l_process_flag
1001: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1002:
1003: UPDATE bom_sub_comps_interface
1004: SET PROCESS_FLAG = l_process_flag
1005: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1006:
1007: UPDATE bom_ref_desgs_interface
1287: p_sub_comp_tbl BOM_Bo_PUB.Sub_Component_Tbl_Type
1288: ) IS
1289: BEGIN
1290: FOR i IN 1..p_sub_comp_tbl.COUNT LOOP
1291: UPDATE bom_sub_comps_interface SET
1292: -- substitute_component_id = p_sub_comp_tbl(i).substitute_component_id,
1293: -- last_update_date = p_sub_comp_tbl(i).last_update_date,
1294: -- last_updated_by = p_sub_comp_tbl(i).last_updated_by,
1295: -- creation_date = p_sub_comp_tbl(i).creation_date,
3068: FROM mtl_parameters mp2
3069: WHERE mp2.organization_code = bici.organization_code);
3070:
3071: stmt_num := 7;
3072: UPDATE bom_sub_comps_interface bsci
3073: SET organization_id = (SELECT organization_id
3074: FROM mtl_parameters mp1
3075: WHERE mp1.organization_code = bsci.organization_code)
3076: WHERE process_flag = 1
3186: OR
3187: (p_all_org = 2 AND organization_id = p_org_id));
3188:
3189: stmt_num := 10.5;
3190: UPDATE bom_sub_comps_interface
3191: SET transaction_id = mtl_system_items_interface_s.nextval,
3192: transaction_type = UPPER(transaction_type)
3193: WHERE process_flag = 1
3194: AND (transaction_id is NULL
6187: END LOOP;
6188:
6189: stmt_num := 518;
6190: LOOP
6191: DELETE from bom_sub_comps_interface
6192: WHERE process_flag = 7
6193: AND rownum < G_ROWS_TO_COMMIT;
6194:
6195: EXIT when SQL%NOTFOUND;