22: -- 01-JUN-05 Bhavnesh Patel Added Batch Id
23: -- 13-JUL-06 Bhavnesh Patel Added support for Structure Type
24: ***************************************************************************/
25:
26: l_bom_header_rec Bom_Bo_Pub.bom_Head_Rec_Type;
27: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
28: l_bom_component_tbl Bom_Bo_pub.Bom_Comps_Tbl_Type;
29: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
30: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
23: -- 13-JUL-06 Bhavnesh Patel Added support for Structure Type
24: ***************************************************************************/
25:
26: l_bom_header_rec Bom_Bo_Pub.bom_Head_Rec_Type;
27: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
28: l_bom_component_tbl Bom_Bo_pub.Bom_Comps_Tbl_Type;
29: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
30: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
31: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
24: ***************************************************************************/
25:
26: l_bom_header_rec Bom_Bo_Pub.bom_Head_Rec_Type;
27: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
28: l_bom_component_tbl Bom_Bo_pub.Bom_Comps_Tbl_Type;
29: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
30: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
31: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
32:
25:
26: l_bom_header_rec Bom_Bo_Pub.bom_Head_Rec_Type;
27: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
28: l_bom_component_tbl Bom_Bo_pub.Bom_Comps_Tbl_Type;
29: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
30: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
31: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
32:
33: --for updating interface tables
26: l_bom_header_rec Bom_Bo_Pub.bom_Head_Rec_Type;
27: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
28: l_bom_component_tbl Bom_Bo_pub.Bom_Comps_Tbl_Type;
29: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
30: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
31: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
32:
33: --for updating interface tables
34: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
27: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
28: l_bom_component_tbl Bom_Bo_pub.Bom_Comps_Tbl_Type;
29: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
30: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
31: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
32:
33: --for updating interface tables
34: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
35: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
30: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
31: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
32:
33: --for updating interface tables
34: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
35: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
36: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
37: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
38: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
31: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
32:
33: --for updating interface tables
34: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
35: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
36: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
37: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
38: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
39:
32:
33: --for updating interface tables
34: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
35: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
36: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
37: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
38: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
39:
40: Function Update_Interface_tables (
33: --for updating interface tables
34: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
35: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
36: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
37: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
38: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
39:
40: Function Update_Interface_tables (
41: err_text IN OUT NOCOPY VARCHAR2)
34: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
35: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
36: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
37: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
38: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
39:
40: Function Update_Interface_tables (
41: err_text IN OUT NOCOPY VARCHAR2)
42: return integer;
388: LOOP
389:
390: /* Initialize all the variables in business object */
391:
392: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
393: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
394: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
395: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
396: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
389:
390: /* Initialize all the variables in business object */
391:
392: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
393: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
394: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
395: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
396: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
397: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
390: /* Initialize all the variables in business object */
391:
392: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
393: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
394: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
395: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
396: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
397: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
398: l_assembly_item_name := NULL;
391:
392: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
393: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
394: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
395: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
396: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
397: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
398: l_assembly_item_name := NULL;
399: l_organization_code := NULL;
392: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
393: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
394: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
395: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
396: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
397: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
398: l_assembly_item_name := NULL;
399: l_organization_code := NULL;
400: l_alternate_designator := NULL;
393: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
394: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
395: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
396: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
397: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
398: l_assembly_item_name := NULL;
399: l_organization_code := NULL;
400: l_alternate_designator := NULL;
401: empty_bo :='YES';
784:
785: stmt_num:=10;
786:
787: if (empty_bo ='NO') then
788: bom_bo_pub.Process_Bom
789: ( p_bo_identifier => 'BOM'
790: , p_api_version_number => 1.0
791: , p_init_msg_list => TRUE
792: , p_bom_header_rec => l_bom_header_rec