DBA Data[Home] [Help]

APPS.BOM_OPEN_INTERFACE_API dependencies on BOM_BO_PUB

Line 26: l_bom_header_rec Bom_Bo_Pub.bom_Head_Rec_Type;

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;

Line 27: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_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;

Line 28: l_bom_component_tbl Bom_Bo_pub.Bom_Comps_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:

Line 29: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;

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

Line 30: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;

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;

Line 31: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_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;

Line 34: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_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;

Line 35: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_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:

Line 36: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_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:
40: Function Update_Interface_tables (

Line 37: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

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)

Line 38: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;

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;

Line 392: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;

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;

Line 393: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_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;

Line 394: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_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;

Line 395: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;

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;

Line 396: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;

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;

Line 397: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;

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';

Line 788: bom_bo_pub.Process_Bom

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