[Home] [Help]
148: l_Count NUMBER := 0;
149: CURSOR All_Numbers_BIC IS
150: SELECT 'X' unit_available FROM sys.dual
151: WHERE EXISTS (
152: SELECT 1 from BOM_INVENTORY_COMPONENTS
153: WHERE Component_Item_Id = p_Component_Item_Id
154: AND Bill_Sequence_Id = p_Bill_Sequence_Id
155: AND Operation_Seq_Num = p_Operation_Seq_Num
156: /* AND
208: CURSOR All_Numbers_BCO IS
209: SELECT 'X' unit_available FROM sys.dual
210: WHERE EXISTS (
211: SELECT 1 from BOM_COMPONENT_OPERATIONS BCO,
212: BOM_INVENTORY_COMPONENTS BIC
213: WHERE BCO.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
214: AND BIC.Component_Item_Id = p_Component_Item_Id
215: AND BIC.Bill_Sequence_Id = p_Bill_Sequence_Id
216: AND BCO.Operation_Seq_Num = p_Operation_Seq_Num
368:
369:
370: /* Select the didsable date which is one of the key parameters */
371:
372: SELECT disable_date INTO l_disable_date FROM bom_inventory_components WHERE
373: component_sequence_id = p_bom_comp_ops_unexp_rec.component_sequence_id;
374:
375: /* Validate for Duplicate entries/Overlapping of the component */
376:
747: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
748:
749: CURSOR c_GetComponent IS
750: SELECT component_sequence_id
751: FROM bom_inventory_components
752: WHERE component_item_id= p_bom_comp_ops_unexp_rec.component_item_id
753: AND operation_seq_num=p_bom_comp_ops_rec.operation_sequence_number
754: AND effectivity_date = p_bom_comp_ops_rec.start_effective_date
755: AND bill_sequence_id = p_bom_comp_ops_unexp_rec.bill_sequence_id;