APPS.BOMPCMBM dependencies on BOM_INVENTORY_COMPONENTS_S

Line 838: * Function to return the nextval from Bom_Inventory_Components_S

834: Where bill_sequence_id = p_bill_sequence_id;
835: END;
836:
837: /*
838: * Function to return the nextval from Bom_Inventory_Components_S
839: */
840: FUNCTION Get_Component_Sequence
841: RETURN NUMBER
842: IS

Line 844: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence

840: FUNCTION Get_Component_Sequence
841: RETURN NUMBER
842: IS
843: CURSOR Comp_Seq IS
844: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence
845: FROM SYS.DUAL;
846: BEGIN
847: FOR c_Comp_Seq IN Comp_Seq LOOP
848: RETURN c_Comp_Seq.Component_Sequence;

Line 1221: , Bom_Inventory_Components_S.NEXTVAL

1217: , comp_rec.REVISED_ITEM_SEQUENCE_ID
1218: , comp_rec.COST_FACTOR
1219: , comp_rec.REQUIRED_FOR_REVENUE
1220: , comp_rec.HIGH_QUANTITY
1221: , Bom_Inventory_Components_S.NEXTVAL
1222: , comp_rec.PROGRAM_APPLICATION_ID
1223: --, decode(default_wip_params, 1, item.WIP_SUPPLY_TYPE, null)--supply type can be null --commented out for 9438586
1224: , decode(default_wip_params, 1, item.WIP_SUPPLY_TYPE, comp_rec.WIP_SUPPLY_TYPE) --changes made for bug 9438586
1225: , decode(default_wip_params, 1, item.WIP_SUPPLY_LOCATOR_ID, null)

Line 4627: SELECT bom_inventory_components_s.NEXTVAL INTO l_dest_new_comp_seq_id FROM dual;

4623: END;
4624: END IF;
4625: IF (l_return_status = 'S')
4626: THEN
4627: SELECT bom_inventory_components_s.NEXTVAL INTO l_dest_new_comp_seq_id FROM dual;
4628: -- changed values from other record
4629: l_component_rec.component_sequence_id := l_dest_new_comp_seq_id;
4630: l_component_rec.old_component_sequence_id := c_dest_comp_rec.component_sequence_id;
4631: l_component_rec.common_component_sequence_id := p_src_comp_seq_id;