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 383: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;

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;

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

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

Line 386: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;

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;

Line 387: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;

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;

Line 388: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;

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

Line 779: bom_bo_pub.Process_Bom

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