DBA Data[Home] [Help]

APPS.EGO_ICC_STRUCTURE_PVT dependencies on BOM_INVENTORY_COMPONENTS_S

Line 77: select bom_inventory_components_s.nextval

73: if l_create_header = 1 then
74:
75: for icc_structure in Get_str_catalog_hierarchy loop
76:
77: select bom_inventory_components_s.nextval
78: into l_bill_sequence_id
79: from dual;
80:
81: insert into BOM_STRUCTURES_B

Line 203: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL

199: and application_id = 702;
200:
201: for component in get_version_components(l_bill_seq_id) loop
202:
203: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
204: into l_new_component_seq_id
205: from dual;
206:
207: Insert into BOM_COMPONENTS_B

Line 639: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL

635: and attr_group_type = 'BOM_COMPONENTMGMT_GROUP'
636: and application_id = 702;
637: for cntr IN 1..v_struct_comp.COUNT LOOP
638:
639: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
640: into l_new_component_seq_id
641: from dual;
642:
643: Insert into BOM_COMPONENTS_B

Line 2048: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL

2044: for cntr in 1..v_insert_comp_tbl.count loop
2045:
2046: l_item_seq_incr := l_item_seq_incr+to_number(l_item_seq_incr_prof);
2047:
2048: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
2049: into l_new_component_seq_id
2050: from dual;
2051: l_stmt_no := 340;
2052: Insert into BOM_COMPONENTS_B

Line 2748: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL

2744: for cntr in 1..v_insert_comp_tbl.count loop
2745: l_stmt_no := 410;
2746: l_item_seq_incr := l_item_seq_incr + to_number(l_item_seq_incr_prof);
2747:
2748: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
2749: into l_new_component_seq_id
2750: from dual;
2751: l_stmt_no := 420;
2752: Insert into BOM_COMPONENTS_B

Line 3049: select bom_inventory_components_s.nextval

3045: if l_create_header = 1 then
3046:
3047: for icc_structure in Get_str_catalog_hierarchy loop
3048:
3049: select bom_inventory_components_s.nextval
3050: into l_bill_sequence_id
3051: from dual;
3052:
3053: insert into BOM_STRUCTURES_B