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;
379: LOOP
380:
381: /* Initialize all the variables in business object */
382:
383: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
384: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
385: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
386: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
387: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
380:
381: /* Initialize all the variables in business object */
382:
383: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
384: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
385: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
386: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
387: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
388: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
381: /* Initialize all the variables in business object */
382:
383: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
384: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
385: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
386: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
387: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
388: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
389: l_assembly_item_name := NULL;
382:
383: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
384: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
385: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
386: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
387: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
388: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
389: l_assembly_item_name := NULL;
390: l_organization_code := NULL;
383: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
384: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
385: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
386: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
387: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
388: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
389: l_assembly_item_name := NULL;
390: l_organization_code := NULL;
391: l_alternate_designator := NULL;
384: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
385: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
386: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
387: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
388: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
389: l_assembly_item_name := NULL;
390: l_organization_code := NULL;
391: l_alternate_designator := NULL;
392: empty_bo :='YES';
775:
776: stmt_num:=10;
777:
778: if (empty_bo ='NO') then
779: bom_bo_pub.Process_Bom
780: ( p_bo_identifier => 'BOM'
781: , p_api_version_number => 1.0
782: , p_init_msg_list => TRUE
783: , p_bom_header_rec => l_bom_header_rec