82:
83: TYPE Header_Record_Id_Tbl_Type IS TABLE OF Header_Record_Id_Type
84: INDEX BY BINARY_INTEGER;
85: G_Header_Record_id_Tbl Header_Record_Id_Tbl_Type;
86: G_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
87: G_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
88: G_bom_components_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
89: G_bom_ref_designators_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
90: G_bom_sub_components_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
83: TYPE Header_Record_Id_Tbl_Type IS TABLE OF Header_Record_Id_Type
84: INDEX BY BINARY_INTEGER;
85: G_Header_Record_id_Tbl Header_Record_Id_Tbl_Type;
86: G_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
87: G_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
88: G_bom_components_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
89: G_bom_ref_designators_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
90: G_bom_sub_components_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
91: G_bom_comp_ops_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
84: INDEX BY BINARY_INTEGER;
85: G_Header_Record_id_Tbl Header_Record_Id_Tbl_Type;
86: G_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
87: G_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
88: G_bom_components_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
89: G_bom_ref_designators_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
90: G_bom_sub_components_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
91: G_bom_comp_ops_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
92: no_profile EXCEPTION;
85: G_Header_Record_id_Tbl Header_Record_Id_Tbl_Type;
86: G_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
87: G_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
88: G_bom_components_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
89: G_bom_ref_designators_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
90: G_bom_sub_components_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
91: G_bom_comp_ops_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
92: no_profile EXCEPTION;
93: invalid_org EXCEPTION;
86: G_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
87: G_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
88: G_bom_components_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
89: G_bom_ref_designators_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
90: G_bom_sub_components_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
91: G_bom_comp_ops_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
92: no_profile EXCEPTION;
93: invalid_org EXCEPTION;
94: invalid_assembly_item_name EXCEPTION;
87: G_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
88: G_bom_components_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
89: G_bom_ref_designators_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
90: G_bom_sub_components_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
91: G_bom_comp_ops_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
92: no_profile EXCEPTION;
93: invalid_org EXCEPTION;
94: invalid_assembly_item_name EXCEPTION;
95: invalid_comp_seq_id EXCEPTION;
1599: P_organization_code IN VARCHAR2,
1600: P_alternate_bm_designator IN VARCHAR2 DEFAULT NULL,
1601: P_costs IN NUMBER DEFAULT 2,
1602: P_cost_type_id IN NUMBER DEFAULT 0,
1603: X_bom_header_tbl OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE,
1604: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
1605: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
1606: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
1607: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
1600: P_alternate_bm_designator IN VARCHAR2 DEFAULT NULL,
1601: P_costs IN NUMBER DEFAULT 2,
1602: P_cost_type_id IN NUMBER DEFAULT 0,
1603: X_bom_header_tbl OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE,
1604: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
1605: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
1606: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
1607: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
1608: X_bom_comp_ops_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
1601: P_costs IN NUMBER DEFAULT 2,
1602: P_cost_type_id IN NUMBER DEFAULT 0,
1603: X_bom_header_tbl OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE,
1604: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
1605: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
1606: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
1607: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
1608: X_bom_comp_ops_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
1609: X_Err_Msg OUT NOCOPY VARCHAR2,
1602: P_cost_type_id IN NUMBER DEFAULT 0,
1603: X_bom_header_tbl OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE,
1604: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
1605: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
1606: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
1607: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
1608: X_bom_comp_ops_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
1609: X_Err_Msg OUT NOCOPY VARCHAR2,
1610: X_Error_Code OUT NOCOPY NUMBER
1603: X_bom_header_tbl OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE,
1604: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
1605: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
1606: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
1607: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
1608: X_bom_comp_ops_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
1609: X_Err_Msg OUT NOCOPY VARCHAR2,
1610: X_Error_Code OUT NOCOPY NUMBER
1611: ) IS
1604: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
1605: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
1606: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
1607: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
1608: X_bom_comp_ops_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
1609: X_Err_Msg OUT NOCOPY VARCHAR2,
1610: X_Error_Code OUT NOCOPY NUMBER
1611: ) IS
1612: l_organization_id NUMBER;