APPS.BOMPCMBM dependencies on BOM_INVENTORY_COMPONENTS_S

Line 693: * Function to return the nextval from Bom_Inventory_Components_S

689: Where bill_sequence_id = p_bill_sequence_id;
690: END;
691:
692: /*
693: * Function to return the nextval from Bom_Inventory_Components_S
694: */
695: FUNCTION Get_Component_Sequence
696: RETURN NUMBER
697: IS

Line 699: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence

695: FUNCTION Get_Component_Sequence
696: RETURN NUMBER
697: IS
698: CURSOR Comp_Seq IS
699: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence
700: FROM SYS.DUAL;
701: BEGIN
702: FOR c_Comp_Seq IN Comp_Seq LOOP
703: RETURN c_Comp_Seq.Component_Sequence;

Line 1017: , Bom_Inventory_Components_S.NEXTVAL

1013: , comp_rec.REVISED_ITEM_SEQUENCE_ID
1014: , comp_rec.COST_FACTOR
1015: , comp_rec.REQUIRED_FOR_REVENUE
1016: , comp_rec.HIGH_QUANTITY
1017: , Bom_Inventory_Components_S.NEXTVAL
1018: , comp_rec.PROGRAM_APPLICATION_ID
1019: , decode(default_wip_params, 1, item.WIP_SUPPLY_TYPE, null)--supply type can be null
1020: , decode(default_wip_params, 1, item.WIP_SUPPLY_LOCATOR_ID, null)
1021: , comp_rec.BOM_ITEM_TYPE

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

4275: END;
4276: END IF;
4277: IF (l_return_status = 'S')
4278: THEN
4279: SELECT bom_inventory_components_s.NEXTVAL INTO l_dest_new_comp_seq_id FROM dual;
4280: -- changed values from other record
4281: l_component_rec.component_sequence_id := l_dest_new_comp_seq_id;
4282: l_component_rec.old_component_sequence_id := c_dest_comp_rec.component_sequence_id;
4283: l_component_rec.common_component_sequence_id := p_src_comp_seq_id;