[Home] [Help]
607: process_flag )
608: FROM
609: (
610: SELECT BATCH_ID,ORGANIZATION_ID,REQUEST_ID,ASSEMBLY_ITEM_ID,BILL_SEQUENCE_ID,BUNDLE_ID,ALTERNATE_BOM_DESIGNATOR,process_flag
611: FROM BOM_BILL_OF_MTLS_INTERFACE I
612: WHERE I.BATCH_ID =batch_id_struct
613: AND I.PROCESS_FLAG IN ( Decode(purge_criteria,'SUCCESS',7,'ERROR',3,-123456), Decode(purge_criteria,'ERROR',6,-123456) ));
614:
615:
768: l_comp_entity_count := l_comp_entity_count + SQL%BULK_ROWCOUNT(i);
769: END LOOP;
770:
771:
772: --delete record from bom_bill_of_mtls_interface
773: stm_num := 7;
774:
775: FORALL comp IN l_structure_table.first .. l_structure_table.last
776:
773: stm_num := 7;
774:
775: FORALL comp IN l_structure_table.first .. l_structure_table.last
776:
777: DELETE FROM bom_bill_of_mtls_interface bbmi
778: WHERE bbmi.BATCH_ID = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).batch_id
779: AND bbmi.ORGANIZATION_ID = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).organization_id
780: AND Nvl(bbmi.REQUEST_ID,0) = Nvl(TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).request_id,0)
781: AND Nvl(bbmi.BUNDLE_ID,0) = Nvl(TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).bundle_id,0)
954: IF item_num >0 THEN
955:
956: FOR item IN l_item_table.first .. l_item_table.last LOOP
957:
958: SELECT Count(1) INTO l_item_table(item).isinbill FROM bom_bill_of_mtls_interface bbmi
959: WHERE bbmi.BATCH_ID = l_item_table(item).set_process_id
960: AND ( bbmi.ORGANIZATION_ID = l_item_table(item).organization_id
961: OR ( bbmi.ORGANIZATION_CODE = l_item_table(item).organization_code
962: AND ( bbmi.ORGANIZATION_CODE IS NULL OR l_item_table(item).organization_code IS NULL)
1082: IF l_batch_type='BOM_STRUCTURE' THEN
1083:
1084: stm_num :=8;
1085:
1086: DELETE bom_bill_of_mtls_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1087:
1088: fnd_file.put_line(fnd_file.Log,'No.of Structures deleted are '||SQL%ROWCOUNT);
1089:
1090: