eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_BO_PUB dependencies on BOM_BO_PUB

Line 1: PACKAGE BODY Bom_Bo_Pub AS

1: PACKAGE BODY Bom_Bo_Pub AS
2: /* $Header: BOMBBOMB.pls 120.1 2005/08/24 05:08:14 vhymavat noship $ */
3: /***************************************************************************
4: --
5: -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA

Line 14: -- Body of package Bom_BO_Pub

10: -- BOMBBOMB.pls
11: --
12: -- DESCRIPTION
13: --
14: -- Body of package Bom_BO_Pub
15: --
16: -- NOTES
17: --
18: -- HISTORY

Line 44: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type :=

40: * records is different, this has to done on a field
41: * by field basis.
42: ******************************************************************/
43: PROCEDURE Convert_BomComp_To_EcoComp
44: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type :=
45: Bom_bo_Pub.G_MISS_BOM_COMPONENT_REC
46: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type :=
47: Bom_Bo_Pub.G_MISS_BOM_COMP_UNEXP_REC
48: , x_rev_component_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type

Line 45: Bom_bo_Pub.G_MISS_BOM_COMPONENT_REC

41: * by field basis.
42: ******************************************************************/
43: PROCEDURE Convert_BomComp_To_EcoComp
44: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type :=
45: Bom_bo_Pub.G_MISS_BOM_COMPONENT_REC
46: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type :=
47: Bom_Bo_Pub.G_MISS_BOM_COMP_UNEXP_REC
48: , x_rev_component_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
49: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

Line 46: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type :=

42: ******************************************************************/
43: PROCEDURE Convert_BomComp_To_EcoComp
44: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type :=
45: Bom_bo_Pub.G_MISS_BOM_COMPONENT_REC
46: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type :=
47: Bom_Bo_Pub.G_MISS_BOM_COMP_UNEXP_REC
48: , x_rev_component_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
49: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
50: )

Line 47: Bom_Bo_Pub.G_MISS_BOM_COMP_UNEXP_REC

43: PROCEDURE Convert_BomComp_To_EcoComp
44: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type :=
45: Bom_bo_Pub.G_MISS_BOM_COMPONENT_REC
46: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type :=
47: Bom_Bo_Pub.G_MISS_BOM_COMP_UNEXP_REC
48: , x_rev_component_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
49: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
50: )
51: IS

Line 48: , x_rev_component_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type

44: ( p_bom_component_rec IN Bom_Bo_Pub.Bom_Comps_Rec_Type :=
45: Bom_bo_Pub.G_MISS_BOM_COMPONENT_REC
46: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type :=
47: Bom_Bo_Pub.G_MISS_BOM_COMP_UNEXP_REC
48: , x_rev_component_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
49: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
50: )
51: IS
52: BEGIN

Line 49: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type

45: Bom_bo_Pub.G_MISS_BOM_COMPONENT_REC
46: , p_bom_comp_unexp_rec IN Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type :=
47: Bom_Bo_Pub.G_MISS_BOM_COMP_UNEXP_REC
48: , x_rev_component_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Rec_Type
49: , x_rev_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type
50: )
51: IS
52: BEGIN
53: x_rev_component_rec.eco_name := NULL;

Line 236: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type :=

232: * records is different, this has to done on a field
233: * by field basis.
234: ******************************************************************/
235: PROCEDURE Convert_EcoComp_To_BomComp
236: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type :=
237: Bom_Bo_Pub.G_MISS_REV_COMPONENT_REC
238: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
239: Bom_Bo_Pub.G_MISS_REV_COMP_UNEXP_REC
240: , x_bom_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type

Line 237: Bom_Bo_Pub.G_MISS_REV_COMPONENT_REC

233: * by field basis.
234: ******************************************************************/
235: PROCEDURE Convert_EcoComp_To_BomComp
236: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type :=
237: Bom_Bo_Pub.G_MISS_REV_COMPONENT_REC
238: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
239: Bom_Bo_Pub.G_MISS_REV_COMP_UNEXP_REC
240: , x_bom_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
241: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

Line 238: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=

234: ******************************************************************/
235: PROCEDURE Convert_EcoComp_To_BomComp
236: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type :=
237: Bom_Bo_Pub.G_MISS_REV_COMPONENT_REC
238: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
239: Bom_Bo_Pub.G_MISS_REV_COMP_UNEXP_REC
240: , x_bom_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
241: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
242: )

Line 239: Bom_Bo_Pub.G_MISS_REV_COMP_UNEXP_REC

235: PROCEDURE Convert_EcoComp_To_BomComp
236: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type :=
237: Bom_Bo_Pub.G_MISS_REV_COMPONENT_REC
238: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
239: Bom_Bo_Pub.G_MISS_REV_COMP_UNEXP_REC
240: , x_bom_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
241: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
242: )
243: IS

Line 240: , x_bom_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type

236: ( p_rev_component_rec IN Bom_Bo_Pub.Rev_Component_Rec_Type :=
237: Bom_Bo_Pub.G_MISS_REV_COMPONENT_REC
238: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
239: Bom_Bo_Pub.G_MISS_REV_COMP_UNEXP_REC
240: , x_bom_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
241: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
242: )
243: IS
244: BEGIN

Line 241: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type

237: Bom_Bo_Pub.G_MISS_REV_COMPONENT_REC
238: , p_rev_comp_unexp_rec IN Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
239: Bom_Bo_Pub.G_MISS_REV_COMP_UNEXP_REC
240: , x_bom_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Rec_Type
241: , x_bom_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type
242: )
243: IS
244: BEGIN
245: x_bom_component_rec.organization_code :=

Line 410: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

406:
407: END Convert_EcoComp_To_BomComp;
408:
409: PROCEDURE Convert_BomDesg_To_EcoDesg
410: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
411: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_REC
412: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
413: := Bom_Bo_Pub.G_MISS_BOM_REF_DESG_UNEXP_REC
414: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type

Line 411: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_REC

407: END Convert_EcoComp_To_BomComp;
408:
409: PROCEDURE Convert_BomDesg_To_EcoDesg
410: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
411: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_REC
412: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
413: := Bom_Bo_Pub.G_MISS_BOM_REF_DESG_UNEXP_REC
414: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
415: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

Line 412: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

408:
409: PROCEDURE Convert_BomDesg_To_EcoDesg
410: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
411: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_REC
412: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
413: := Bom_Bo_Pub.G_MISS_BOM_REF_DESG_UNEXP_REC
414: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
415: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
416: )

Line 413: := Bom_Bo_Pub.G_MISS_BOM_REF_DESG_UNEXP_REC

409: PROCEDURE Convert_BomDesg_To_EcoDesg
410: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
411: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_REC
412: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
413: := Bom_Bo_Pub.G_MISS_BOM_REF_DESG_UNEXP_REC
414: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
415: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
416: )
417: IS

Line 414: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type

410: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
411: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_REC
412: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
413: := Bom_Bo_Pub.G_MISS_BOM_REF_DESG_UNEXP_REC
414: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
415: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
416: )
417: IS
418: BEGIN

Line 415: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

411: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_REC
412: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
413: := Bom_Bo_Pub.G_MISS_BOM_REF_DESG_UNEXP_REC
414: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
415: , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
416: )
417: IS
418: BEGIN
419: x_ref_designator_rec.eco_name := NULL;

Line 497: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

493: p_bom_ref_desg_unexp_rec.bill_sequence_id;
494: END Convert_BomDesg_To_EcoDesg;
495:
496: PROCEDURE Convert_EcoDesg_To_BomDesg
497: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
498: := Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
499: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
500: := Bom_Bo_Pub.G_MISS_REF_DESG_UNEXP_REC
501: , x_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

Line 498: := Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC

494: END Convert_BomDesg_To_EcoDesg;
495:
496: PROCEDURE Convert_EcoDesg_To_BomDesg
497: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
498: := Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
499: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
500: := Bom_Bo_Pub.G_MISS_REF_DESG_UNEXP_REC
501: , x_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
502: , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

Line 499: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

495:
496: PROCEDURE Convert_EcoDesg_To_BomDesg
497: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
498: := Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
499: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
500: := Bom_Bo_Pub.G_MISS_REF_DESG_UNEXP_REC
501: , x_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
502: , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
503: )

Line 500: := Bom_Bo_Pub.G_MISS_REF_DESG_UNEXP_REC

496: PROCEDURE Convert_EcoDesg_To_BomDesg
497: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
498: := Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
499: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
500: := Bom_Bo_Pub.G_MISS_REF_DESG_UNEXP_REC
501: , x_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
502: , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
503: )
504: IS

Line 501: , x_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

497: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
498: := Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
499: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
500: := Bom_Bo_Pub.G_MISS_REF_DESG_UNEXP_REC
501: , x_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
502: , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
503: )
504: IS
505: BEGIN

Line 502: , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

498: := Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
499: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
500: := Bom_Bo_Pub.G_MISS_REF_DESG_UNEXP_REC
501: , x_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
502: , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
503: )
504: IS
505: BEGIN
506: x_bom_ref_designator_rec.assembly_item_name :=

Line 583: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

579:
580: END Convert_EcoDesg_To_BomDesg;
581:
582: PROCEDURE Convert_BomSComp_To_EcoSComp
583: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
584: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_REC
585: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
586: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMP_UNEXP_REC
587: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type

Line 584: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_REC

580: END Convert_EcoDesg_To_BomDesg;
581:
582: PROCEDURE Convert_BomSComp_To_EcoSComp
583: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
584: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_REC
585: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
586: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMP_UNEXP_REC
587: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
588: , x_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

Line 585: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

581:
582: PROCEDURE Convert_BomSComp_To_EcoSComp
583: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
584: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_REC
585: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
586: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMP_UNEXP_REC
587: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
588: , x_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
589: )

Line 586: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMP_UNEXP_REC

582: PROCEDURE Convert_BomSComp_To_EcoSComp
583: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
584: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_REC
585: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
586: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMP_UNEXP_REC
587: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
588: , x_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
589: )
590: IS

Line 587: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type

583: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
584: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_REC
585: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
586: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMP_UNEXP_REC
587: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
588: , x_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
589: )
590: IS
591: BEGIN

Line 588: , x_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

584: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_REC
585: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
586: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMP_UNEXP_REC
587: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
588: , x_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
589: )
590: IS
591: BEGIN
592: x_sub_component_rec.eco_name := NULL;

Line 684: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

680:
681: END Convert_BomSComp_To_EcoSComp;
682:
683: PROCEDURE Convert_EcoSComp_To_BomSComp
684: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
685: := Bom_Bo_Pub.G_MISS_SUB_COMPONENT_REC
686: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
687: := Bom_bo_Pub.G_MISS_SUB_COMP_UNEXP_REC
688: , x_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

Line 685: := Bom_Bo_Pub.G_MISS_SUB_COMPONENT_REC

681: END Convert_BomSComp_To_EcoSComp;
682:
683: PROCEDURE Convert_EcoSComp_To_BomSComp
684: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
685: := Bom_Bo_Pub.G_MISS_SUB_COMPONENT_REC
686: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
687: := Bom_bo_Pub.G_MISS_SUB_COMP_UNEXP_REC
688: , x_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
689: , x_bom_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

Line 686: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

682:
683: PROCEDURE Convert_EcoSComp_To_BomSComp
684: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
685: := Bom_Bo_Pub.G_MISS_SUB_COMPONENT_REC
686: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
687: := Bom_bo_Pub.G_MISS_SUB_COMP_UNEXP_REC
688: , x_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
689: , x_bom_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
690: )

Line 687: := Bom_bo_Pub.G_MISS_SUB_COMP_UNEXP_REC

683: PROCEDURE Convert_EcoSComp_To_BomSComp
684: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
685: := Bom_Bo_Pub.G_MISS_SUB_COMPONENT_REC
686: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
687: := Bom_bo_Pub.G_MISS_SUB_COMP_UNEXP_REC
688: , x_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
689: , x_bom_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
690: )
691: IS

Line 688: , x_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

684: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
685: := Bom_Bo_Pub.G_MISS_SUB_COMPONENT_REC
686: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
687: := Bom_bo_Pub.G_MISS_SUB_COMP_UNEXP_REC
688: , x_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
689: , x_bom_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
690: )
691: IS
692: BEGIN

Line 689: , x_bom_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

685: := Bom_Bo_Pub.G_MISS_SUB_COMPONENT_REC
686: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
687: := Bom_bo_Pub.G_MISS_SUB_COMP_UNEXP_REC
688: , x_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
689: , x_bom_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
690: )
691: IS
692: BEGIN
693: x_bom_sub_component_rec.organization_code :=

Line 782: ( p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type

778: END Convert_EcoSComp_To_BomSComp;
779:
780:
781: FUNCTION Does_Rev_Have_Same_Bom
782: ( p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
783: , p_assembly_item_name IN VARCHAR2
784: , p_organization_code IN VARCHAR2
785: ) RETURN BOOLEAN
786: IS

Line 811: ( p_bom_component_tbl IN BOM_BO_PUB.Bom_Comps_Tbl_Type

807: END Does_Rev_Have_Same_Bom;
808:
809:
810: FUNCTION Does_Comp_Have_Same_Bom
811: ( p_bom_component_tbl IN BOM_BO_PUB.Bom_Comps_Tbl_Type
812: , p_assembly_item_name IN VARCHAR2
813: , p_organization_code IN VARCHAR2
814: ) RETURN BOOLEAN
815: IS

Line 838: ( p_bom_ref_designator_tbl IN BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type

834: END Does_Comp_Have_Same_Bom;
835:
836:
837: FUNCTION Does_Desg_Have_Same_Bom
838: ( p_bom_ref_designator_tbl IN BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type
839: , p_assembly_item_name IN VARCHAR2
840: , p_organization_code IN VARCHAR2
841: ) RETURN BOOLEAN
842: IS

Line 865: ( p_bom_sub_component_tbl IN BOM_BO_PUB.Bom_Sub_Component_Tbl_Type

861: END Does_Desg_Have_Same_Bom;
862:
863:
864: FUNCTION Does_SComp_Have_Same_Bom
865: ( p_bom_sub_component_tbl IN BOM_BO_PUB.Bom_Sub_Component_Tbl_Type
866: , p_assembly_item_name IN VARCHAR2
867: , p_organization_code IN VARCHAR2
868: ) RETURN BOOLEAN
869: IS

Line 898: ( p_bom_comp_ops_tbl IN BOM_BO_PUB.Bom_Comp_Ops_Tbl_Type

894: END Does_SComp_Have_Same_Bom;
895:
896:
897: FUNCTION Does_CmpOps_Have_Same_Bom
898: ( p_bom_comp_ops_tbl IN BOM_BO_PUB.Bom_Comp_Ops_Tbl_Type
899: , p_assembly_item_name IN VARCHAR2
900: , p_organization_code IN VARCHAR2
901: ) RETURN BOOLEAN
902: IS

Line 939: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type

935: *
936: *
937: *******************************************************************/
938: FUNCTION Check_Records_In_Same_BOM
939: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
940: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
941: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
942: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
943: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 940: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type

936: *
937: *******************************************************************/
938: FUNCTION Check_Records_In_Same_BOM
939: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
940: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
941: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
942: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
943: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
944: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_ops_Tbl_Type

Line 941: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type

937: *******************************************************************/
938: FUNCTION Check_Records_In_Same_BOM
939: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
940: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
941: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
942: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
943: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
944: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_ops_Tbl_Type
945: , x_assembly_item_name IN OUT NOCOPY VARCHAR2

Line 942: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

938: FUNCTION Check_Records_In_Same_BOM
939: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
940: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
941: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
942: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
943: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
944: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_ops_Tbl_Type
945: , x_assembly_item_name IN OUT NOCOPY VARCHAR2
946: , x_organization_code IN OUT NOCOPY VARCHAR2

Line 943: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

939: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
940: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
941: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
942: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
943: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
944: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_ops_Tbl_Type
945: , x_assembly_item_name IN OUT NOCOPY VARCHAR2
946: , x_organization_code IN OUT NOCOPY VARCHAR2
947: )

Line 944: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_ops_Tbl_Type

940: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
941: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
942: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
943: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
944: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_ops_Tbl_Type
945: , x_assembly_item_name IN OUT NOCOPY VARCHAR2
946: , x_organization_code IN OUT NOCOPY VARCHAR2
947: )
948: RETURN BOOLEAN

Line 1282: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=

1278: PROCEDURE Process_Bom
1279: ( p_bo_identifier IN VARCHAR2 := 'BOM'
1280: , p_api_version_number IN NUMBER := 1.0
1281: , p_init_msg_list IN BOOLEAN := FALSE
1282: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1283: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1284: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1285: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1286: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=

Line 1283: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC

1279: ( p_bo_identifier IN VARCHAR2 := 'BOM'
1280: , p_api_version_number IN NUMBER := 1.0
1281: , p_init_msg_list IN BOOLEAN := FALSE
1282: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1283: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1284: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1285: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1286: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1287: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL

Line 1284: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=

1280: , p_api_version_number IN NUMBER := 1.0
1281: , p_init_msg_list IN BOOLEAN := FALSE
1282: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1283: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1284: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1285: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1286: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1287: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1288: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type

Line 1285: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL

1281: , p_init_msg_list IN BOOLEAN := FALSE
1282: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1283: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1284: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1285: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1286: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1287: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1288: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1289: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL

Line 1286: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=

1282: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1283: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1284: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1285: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1286: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1287: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1288: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1289: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1290: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 1287: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL

1283: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1284: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1285: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1286: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1287: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1288: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1289: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1290: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1291: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL

Line 1288: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type

1284: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1285: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1286: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1287: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1288: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1289: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1290: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1291: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1292: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=

Line 1289: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL

1285: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1286: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1287: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1288: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1289: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1290: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1291: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1292: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
1293: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL

Line 1290: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

1286: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1287: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1288: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1289: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1290: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1291: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1292: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
1293: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1294: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type

Line 1291: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL

1287: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1288: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1289: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1290: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1291: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1292: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
1293: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1294: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1295: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

Line 1292: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=

1288: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1289: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1290: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1291: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1292: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
1293: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1294: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1295: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1296: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type

Line 1293: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL

1289: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1290: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1291: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1292: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
1293: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1294: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1295: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1296: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1297: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

Line 1294: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type

1290: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1291: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1292: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
1293: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1294: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1295: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1296: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1297: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1298: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 1295: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

1291: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1292: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
1293: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1294: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1295: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1296: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1297: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1298: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1299: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

Line 1296: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type

1292: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
1293: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1294: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1295: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1296: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1297: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1298: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1299: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1300: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1297: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

1293: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1294: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1295: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1296: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1297: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1298: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1299: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1300: , x_return_status IN OUT NOCOPY VARCHAR2
1301: , x_msg_count IN OUT NOCOPY NUMBER

Line 1298: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

1294: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1295: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1296: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1297: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1298: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1299: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1300: , x_return_status IN OUT NOCOPY VARCHAR2
1301: , x_msg_count IN OUT NOCOPY NUMBER
1302: , p_debug IN VARCHAR2 := 'N'

Line 1299: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

1295: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1296: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1297: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1298: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1299: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1300: , x_return_status IN OUT NOCOPY VARCHAR2
1301: , x_msg_count IN OUT NOCOPY NUMBER
1302: , p_debug IN VARCHAR2 := 'N'
1303: , p_output_dir IN VARCHAR2 := NULL

Line 1322: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type := p_bom_header_rec;

1318:
1319: l_assembly_item_name VARCHAR2(240);
1320: l_organization_code VARCHAR2(3);
1321: l_organization_id NUMBER;
1322: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type := p_bom_header_rec;
1323: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1324: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1325: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1326: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;

Line 1323: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;

1319: l_assembly_item_name VARCHAR2(240);
1320: l_organization_code VARCHAR2(3);
1321: l_organization_id NUMBER;
1322: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type := p_bom_header_rec;
1323: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1324: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1325: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1326: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
1327: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;

Line 1324: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;

1320: l_organization_code VARCHAR2(3);
1321: l_organization_id NUMBER;
1322: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type := p_bom_header_rec;
1323: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1324: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1325: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1326: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
1327: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
1328: l_Debug_flag VARCHAR2(1) := p_debug;

Line 1325: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;

1321: l_organization_id NUMBER;
1322: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type := p_bom_header_rec;
1323: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1324: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1325: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1326: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
1327: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
1328: l_Debug_flag VARCHAR2(1) := p_debug;
1329: BEGIN

Line 1326: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;

1322: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type := p_bom_header_rec;
1323: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1324: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1325: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1326: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
1327: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
1328: l_Debug_flag VARCHAR2(1) := p_debug;
1329: BEGIN
1330:

Line 1327: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;

1323: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1324: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1325: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1326: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
1327: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
1328: l_Debug_flag VARCHAR2(1) := p_debug;
1329: BEGIN
1330:
1331: --

Line 1723: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=

1719: PROCEDURE Process_Bom
1720: ( p_bo_identifier IN VARCHAR2 := 'BOM'
1721: , p_api_version_number IN NUMBER := 1.0
1722: , p_init_msg_list IN BOOLEAN := FALSE
1723: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1724: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1725: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1726: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1727: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=

Line 1724: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC

1720: ( p_bo_identifier IN VARCHAR2 := 'BOM'
1721: , p_api_version_number IN NUMBER := 1.0
1722: , p_init_msg_list IN BOOLEAN := FALSE
1723: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1724: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1725: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1726: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1727: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1728: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL

Line 1725: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=

1721: , p_api_version_number IN NUMBER := 1.0
1722: , p_init_msg_list IN BOOLEAN := FALSE
1723: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1724: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1725: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1726: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1727: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1728: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1729: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type

Line 1726: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL

1722: , p_init_msg_list IN BOOLEAN := FALSE
1723: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1724: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1725: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1726: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1727: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1728: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1729: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1730: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL

Line 1727: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=

1723: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1724: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1725: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1726: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1727: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1728: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1729: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1730: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1731: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 1728: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL

1724: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1725: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1726: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1727: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1728: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1729: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1730: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1731: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1732: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL

Line 1729: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type

1725: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1726: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1727: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1728: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1729: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1730: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1731: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1732: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1733: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type

Line 1730: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL

1726: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1727: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1728: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1729: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1730: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1731: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1732: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1733: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1734: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

Line 1731: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

1727: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1728: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1729: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1730: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1731: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1732: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1733: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1734: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1735: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type

Line 1732: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL

1728: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1729: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1730: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1731: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1732: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1733: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1734: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1735: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1736: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

Line 1733: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type

1729: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
1730: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1731: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1732: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1733: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1734: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1735: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1736: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1737: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 1734: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

1730: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1731: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1732: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1733: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1734: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1735: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1736: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1737: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1738: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1735: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type

1731: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1732: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1733: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1734: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1735: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1736: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1737: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1738: , x_return_status IN OUT NOCOPY VARCHAR2
1739: , x_msg_count IN OUT NOCOPY NUMBER

Line 1736: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

1732: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1733: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1734: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1735: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1736: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1737: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1738: , x_return_status IN OUT NOCOPY VARCHAR2
1739: , x_msg_count IN OUT NOCOPY NUMBER
1740: , p_debug IN VARCHAR2 := 'N'

Line 1737: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

1733: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
1734: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1735: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
1736: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1737: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1738: , x_return_status IN OUT NOCOPY VARCHAR2
1739: , x_msg_count IN OUT NOCOPY NUMBER
1740: , p_debug IN VARCHAR2 := 'N'
1741: , p_output_dir IN VARCHAR2 := NULL

Line 1748: x_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;

1744: , p_write_err_to_conclog IN VARCHAR2 := 'N'
1745: , p_write_err_to_debugfile IN VARCHAR2 := 'N'
1746: )
1747: IS
1748: x_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
1749: BEGIN
1750:
1751: Process_Bom
1752: ( p_bo_identifier => p_bo_identifier

Line 1760: , p_bom_comp_ops_tbl => Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL

1756: , p_bom_revision_tbl => p_bom_revision_tbl
1757: , p_bom_component_tbl => p_bom_component_tbl
1758: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl
1759: , p_bom_sub_component_tbl => p_bom_sub_component_tbl
1760: , p_bom_comp_ops_tbl => Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1761: , x_bom_header_rec => x_bom_header_rec
1762: , x_bom_revision_tbl => x_bom_revision_tbl
1763: , x_bom_component_tbl => x_bom_component_tbl
1764: , x_bom_ref_designator_tbl => x_bom_ref_designator_tbl

Line 1831: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

1827:
1828:
1829: -- BOM BO input parameters
1830:
1831: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
1832: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1833: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1834: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1835: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;

Line 1832: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;

1828:
1829: -- BOM BO input parameters
1830:
1831: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
1832: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1833: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1834: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1835: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
1836: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;

Line 1833: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;

1829: -- BOM BO input parameters
1830:
1831: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
1832: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1833: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1834: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1835: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
1836: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
1837:

Line 1834: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;

1830:
1831: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
1832: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1833: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1834: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1835: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
1836: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
1837:
1838: -- Input records count

Line 1835: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;

1831: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
1832: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1833: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1834: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1835: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
1836: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
1837:
1838: -- Input records count
1839:

Line 1836: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;

1832: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1833: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1834: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
1835: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
1836: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
1837:
1838: -- Input records count
1839:
1840: l_listcount NUMBER;

Line 1938: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;

1934: LOOP
1935:
1936: -- Initialize all the variables for each business object
1937:
1938: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
1939: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1940: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1941: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1942: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;

Line 1939: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;

1935:
1936: -- Initialize all the variables for each business object
1937:
1938: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
1939: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1940: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1941: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1942: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1943: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;

Line 1940: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;

1936: -- Initialize all the variables for each business object
1937:
1938: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
1939: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1940: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1941: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1942: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1943: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1944:

Line 1941: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;

1937:
1938: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
1939: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1940: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1941: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1942: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1943: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1944:
1945:

Line 1942: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;

1938: l_bom_header_rec := Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
1939: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1940: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1941: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1942: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1943: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1944:
1945:
1946: l_assembly_item_name := NULL;

Line 1943: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;

1939: l_bom_revision_tbl := Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL;
1940: l_bom_component_tbl := Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
1941: l_bom_ref_designator_tbl := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL;
1942: l_bom_sub_component_tbl := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL;
1943: l_bom_comp_ops_tbl := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL;
1944:
1945:
1946: l_assembly_item_name := NULL;
1947: l_organization_code := NULL;

Line 3234: , P_bom_header_tbl IN Bom_Bo_Pub.Bom_Header_tbl_Type :=

3230: PROCEDURE Process_Bom
3231: ( P_bo_identifier IN VARCHAR2 := 'BOM'
3232: , P_api_version_number IN NUMBER := 1.0
3233: , P_init_msg_list IN BOOLEAN := FALSE
3234: , P_bom_header_tbl IN Bom_Bo_Pub.Bom_Header_tbl_Type :=
3235: Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL
3236: , P_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
3237: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
3238: , P_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=

Line 3235: Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL

3231: ( P_bo_identifier IN VARCHAR2 := 'BOM'
3232: , P_api_version_number IN NUMBER := 1.0
3233: , P_init_msg_list IN BOOLEAN := FALSE
3234: , P_bom_header_tbl IN Bom_Bo_Pub.Bom_Header_tbl_Type :=
3235: Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL
3236: , P_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
3237: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
3238: , P_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3239: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL

Line 3236: , P_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=

3232: , P_api_version_number IN NUMBER := 1.0
3233: , P_init_msg_list IN BOOLEAN := FALSE
3234: , P_bom_header_tbl IN Bom_Bo_Pub.Bom_Header_tbl_Type :=
3235: Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL
3236: , P_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
3237: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
3238: , P_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3239: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
3240: , P_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type

Line 3237: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL

3233: , P_init_msg_list IN BOOLEAN := FALSE
3234: , P_bom_header_tbl IN Bom_Bo_Pub.Bom_Header_tbl_Type :=
3235: Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL
3236: , P_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
3237: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
3238: , P_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3239: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
3240: , P_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
3241: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL

Line 3238: , P_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=

3234: , P_bom_header_tbl IN Bom_Bo_Pub.Bom_Header_tbl_Type :=
3235: Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL
3236: , P_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
3237: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
3238: , P_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3239: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
3240: , P_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
3241: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
3242: , P_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 3239: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL

3235: Bom_Bo_Pub.G_MISS_BOM_HEADER_TBL
3236: , P_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
3237: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
3238: , P_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3239: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
3240: , P_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
3241: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
3242: , P_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3243: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL

Line 3240: , P_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type

3236: , P_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
3237: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
3238: , P_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3239: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
3240: , P_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
3241: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
3242: , P_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3243: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
3244: , P_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=

Line 3241: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL

3237: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
3238: , P_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3239: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
3240: , P_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
3241: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
3242: , P_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3243: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
3244: , P_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
3245: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL

Line 3242: , P_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

3238: , P_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3239: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
3240: , P_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
3241: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
3242: , P_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3243: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
3244: , P_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
3245: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
3246: , X_bom_header_tbl IN OUT NOCOPY Bom_Bo_Pub.bom_Header_Tbl_Type

Line 3243: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL

3239: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
3240: , P_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
3241: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
3242: , P_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3243: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
3244: , P_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
3245: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
3246: , X_bom_header_tbl IN OUT NOCOPY Bom_Bo_Pub.bom_Header_Tbl_Type
3247: , X_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

Line 3244: , P_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=

3240: , P_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type
3241: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
3242: , P_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3243: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
3244: , P_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
3245: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
3246: , X_bom_header_tbl IN OUT NOCOPY Bom_Bo_Pub.bom_Header_Tbl_Type
3247: , X_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3248: , X_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type

Line 3245: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL

3241: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
3242: , P_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3243: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
3244: , P_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
3245: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
3246: , X_bom_header_tbl IN OUT NOCOPY Bom_Bo_Pub.bom_Header_Tbl_Type
3247: , X_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3248: , X_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
3249: , X_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

Line 3246: , X_bom_header_tbl IN OUT NOCOPY Bom_Bo_Pub.bom_Header_Tbl_Type

3242: , P_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3243: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
3244: , P_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
3245: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
3246: , X_bom_header_tbl IN OUT NOCOPY Bom_Bo_Pub.bom_Header_Tbl_Type
3247: , X_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3248: , X_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
3249: , X_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3250: , X_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 3247: , X_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

3243: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
3244: , P_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
3245: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
3246: , X_bom_header_tbl IN OUT NOCOPY Bom_Bo_Pub.bom_Header_Tbl_Type
3247: , X_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3248: , X_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
3249: , X_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3250: , X_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3251: , X_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

Line 3248: , X_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type

3244: , P_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
3245: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
3246: , X_bom_header_tbl IN OUT NOCOPY Bom_Bo_Pub.bom_Header_Tbl_Type
3247: , X_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3248: , X_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
3249: , X_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3250: , X_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3251: , X_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3252: , X_return_status IN OUT NOCOPY VARCHAR2

Line 3249: , X_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

3245: Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
3246: , X_bom_header_tbl IN OUT NOCOPY Bom_Bo_Pub.bom_Header_Tbl_Type
3247: , X_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3248: , X_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
3249: , X_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3250: , X_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3251: , X_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3252: , X_return_status IN OUT NOCOPY VARCHAR2
3253: , X_msg_count IN OUT NOCOPY NUMBER

Line 3250: , X_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

3246: , X_bom_header_tbl IN OUT NOCOPY Bom_Bo_Pub.bom_Header_Tbl_Type
3247: , X_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3248: , X_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
3249: , X_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3250: , X_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3251: , X_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3252: , X_return_status IN OUT NOCOPY VARCHAR2
3253: , X_msg_count IN OUT NOCOPY NUMBER
3254: , P_debug IN VARCHAR2 := 'N'

Line 3251: , X_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

3247: , X_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3248: , X_bom_component_tbl IN OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
3249: , X_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3250: , X_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3251: , X_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3252: , X_return_status IN OUT NOCOPY VARCHAR2
3253: , X_msg_count IN OUT NOCOPY NUMBER
3254: , P_debug IN VARCHAR2 := 'N'
3255: , P_output_dir IN VARCHAR2 := NULL

Line 3259: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

3255: , P_output_dir IN VARCHAR2 := NULL
3256: , P_debug_filename IN VARCHAR2 := 'BOM_BO_debug.log'
3257: )
3258: IS
3259: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
3260: l_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
3261: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3262: l_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3263: l_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 3260: l_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

3256: , P_debug_filename IN VARCHAR2 := 'BOM_BO_debug.log'
3257: )
3258: IS
3259: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
3260: l_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
3261: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3262: l_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3263: l_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3264: l_bom_comp_ops_tbl BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;

Line 3261: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

3257: )
3258: IS
3259: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
3260: l_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
3261: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3262: l_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3263: l_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3264: l_bom_comp_ops_tbl BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3265: l_bom_header_rec_out BOM_BO_PUB.Bom_Head_Rec_Type;

Line 3262: l_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

3258: IS
3259: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
3260: l_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
3261: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3262: l_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3263: l_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3264: l_bom_comp_ops_tbl BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3265: l_bom_header_rec_out BOM_BO_PUB.Bom_Head_Rec_Type;
3266: l_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;

Line 3263: l_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

3259: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
3260: l_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
3261: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3262: l_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3263: l_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3264: l_bom_comp_ops_tbl BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3265: l_bom_header_rec_out BOM_BO_PUB.Bom_Head_Rec_Type;
3266: l_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3267: l_bom_component_tbl_out BOM_BO_PUB.Bom_Comps_Tbl_Type;

Line 3264: l_bom_comp_ops_tbl BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;

3260: l_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
3261: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3262: l_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3263: l_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3264: l_bom_comp_ops_tbl BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3265: l_bom_header_rec_out BOM_BO_PUB.Bom_Head_Rec_Type;
3266: l_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3267: l_bom_component_tbl_out BOM_BO_PUB.Bom_Comps_Tbl_Type;
3268: l_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

Line 3265: l_bom_header_rec_out BOM_BO_PUB.Bom_Head_Rec_Type;

3261: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3262: l_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3263: l_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3264: l_bom_comp_ops_tbl BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3265: l_bom_header_rec_out BOM_BO_PUB.Bom_Head_Rec_Type;
3266: l_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3267: l_bom_component_tbl_out BOM_BO_PUB.Bom_Comps_Tbl_Type;
3268: l_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3269: l_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 3266: l_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;

3262: l_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3263: l_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3264: l_bom_comp_ops_tbl BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3265: l_bom_header_rec_out BOM_BO_PUB.Bom_Head_Rec_Type;
3266: l_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3267: l_bom_component_tbl_out BOM_BO_PUB.Bom_Comps_Tbl_Type;
3268: l_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3269: l_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3270: l_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;

Line 3267: l_bom_component_tbl_out BOM_BO_PUB.Bom_Comps_Tbl_Type;

3263: l_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3264: l_bom_comp_ops_tbl BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3265: l_bom_header_rec_out BOM_BO_PUB.Bom_Head_Rec_Type;
3266: l_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3267: l_bom_component_tbl_out BOM_BO_PUB.Bom_Comps_Tbl_Type;
3268: l_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3269: l_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3270: l_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3271: k NUMBER;

Line 3268: l_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

3264: l_bom_comp_ops_tbl BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3265: l_bom_header_rec_out BOM_BO_PUB.Bom_Head_Rec_Type;
3266: l_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3267: l_bom_component_tbl_out BOM_BO_PUB.Bom_Comps_Tbl_Type;
3268: l_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3269: l_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3270: l_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3271: k NUMBER;
3272: l NUMBER;

Line 3269: l_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

3265: l_bom_header_rec_out BOM_BO_PUB.Bom_Head_Rec_Type;
3266: l_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3267: l_bom_component_tbl_out BOM_BO_PUB.Bom_Comps_Tbl_Type;
3268: l_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3269: l_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3270: l_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3271: k NUMBER;
3272: l NUMBER;
3273: o NUMBER;

Line 3270: l_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;

3266: l_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3267: l_bom_component_tbl_out BOM_BO_PUB.Bom_Comps_Tbl_Type;
3268: l_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3269: l_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3270: l_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3271: k NUMBER;
3272: l NUMBER;
3273: o NUMBER;
3274: q NUMBER;

Line 3518: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type :=

3514: , p_Output_Dir IN VARCHAR2 := NULL
3515: , x_error_message OUT NOCOPY VARCHAR2
3516: )
3517: IS
3518: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type :=
3519: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
3520: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3521: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
3522: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;

Line 3519: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;

3515: , x_error_message OUT NOCOPY VARCHAR2
3516: )
3517: IS
3518: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type :=
3519: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
3520: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3521: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
3522: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
3523: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;

Line 3520: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type :=

3516: )
3517: IS
3518: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type :=
3519: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
3520: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3521: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
3522: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
3523: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
3524: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;

Line 3521: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;

3517: IS
3518: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type :=
3519: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
3520: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3521: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
3522: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
3523: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
3524: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
3525: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;

Line 3522: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;

3518: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type :=
3519: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
3520: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3521: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
3522: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
3523: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
3524: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
3525: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
3526: l_return_status VARCHAR2(1);

Line 3523: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;

3519: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC;
3520: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3521: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
3522: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
3523: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
3524: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
3525: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
3526: l_return_status VARCHAR2(1);
3527: l_msg_count NUMBER;

Line 3524: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;

3520: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
3521: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
3522: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
3523: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
3524: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
3525: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
3526: l_return_status VARCHAR2(1);
3527: l_msg_count NUMBER;
3528:

Line 3525: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;

3521: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL;
3522: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
3523: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
3524: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
3525: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
3526: l_return_status VARCHAR2(1);
3527: l_msg_count NUMBER;
3528:
3529: l_message_text varchar2(2000);

Line 3556: Bom_Bo_Pub.Process_Bom

3552: where alt.alternate_designator_code IS NULL
3553: and stype.structure_type_id = alt.structure_type_id;
3554:
3555:
3556: Bom_Bo_Pub.Process_Bom
3557: ( p_bo_identifier => 'BOM'
3558: , p_api_version_number => 1.0
3559: , p_init_msg_list => TRUE
3560: , p_bom_header_rec => l_bom_header_rec

Line 3617: Bom_Bo_Pub.Process_Bom

3613: l_bom_component_tbl(1).return_status := null;
3614:
3615:
3616: /* Call the Business object with just the header and component entities */
3617: Bom_Bo_Pub.Process_Bom
3618: ( p_bo_identifier => 'BOM'
3619: , p_api_version_number => 1.0
3620: , p_init_msg_list => TRUE
3621: , p_bom_header_rec => l_bom_header_rec

Line 3669: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Product_Rec_Type

3665: PROCEDURE Process_Bom
3666: ( p_bo_identifier IN VARCHAR2 := 'BOM'
3667: , p_api_version_number IN NUMBER := 1.0
3668: , p_init_msg_list IN BOOLEAN := FALSE
3669: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Product_Rec_Type
3670: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Product_Mem_Tab_Type
3671: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
3672: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
3673: , x_return_status OUT NOCOPY VARCHAR2

Line 3670: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Product_Mem_Tab_Type

3666: ( p_bo_identifier IN VARCHAR2 := 'BOM'
3667: , p_api_version_number IN NUMBER := 1.0
3668: , p_init_msg_list IN BOOLEAN := FALSE
3669: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Product_Rec_Type
3670: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Product_Mem_Tab_Type
3671: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
3672: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
3673: , x_return_status OUT NOCOPY VARCHAR2
3674: , x_msg_count OUT NOCOPY NUMBER

Line 3671: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type

3667: , p_api_version_number IN NUMBER := 1.0
3668: , p_init_msg_list IN BOOLEAN := FALSE
3669: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Product_Rec_Type
3670: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Product_Mem_Tab_Type
3671: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
3672: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
3673: , x_return_status OUT NOCOPY VARCHAR2
3674: , x_msg_count OUT NOCOPY NUMBER
3675: , p_debug IN VARCHAR2 := 'N'

Line 3672: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type

3668: , p_init_msg_list IN BOOLEAN := FALSE
3669: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Product_Rec_Type
3670: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Product_Mem_Tab_Type
3671: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
3672: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
3673: , x_return_status OUT NOCOPY VARCHAR2
3674: , x_msg_count OUT NOCOPY NUMBER
3675: , p_debug IN VARCHAR2 := 'N'
3676: , p_output_dir IN VARCHAR2 := NULL

Line 3684: l_input_bomheader_rec Bom_Bo_Pub.Bom_Product_Rec_Type := p_bom_header_rec;

3680:
3681:
3682: -- Local variables for the IN parameters
3683:
3684: l_input_bomheader_rec Bom_Bo_Pub.Bom_Product_Rec_Type := p_bom_header_rec;
3685: l_input_bomcomponents_tbl Bom_Bo_Pub.Bom_Product_Mem_Tab_Type := p_bom_component_tbl;
3686:
3687: -- BOM BO input parameters
3688: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

Line 3685: l_input_bomcomponents_tbl Bom_Bo_Pub.Bom_Product_Mem_Tab_Type := p_bom_component_tbl;

3681:
3682: -- Local variables for the IN parameters
3683:
3684: l_input_bomheader_rec Bom_Bo_Pub.Bom_Product_Rec_Type := p_bom_header_rec;
3685: l_input_bomcomponents_tbl Bom_Bo_Pub.Bom_Product_Mem_Tab_Type := p_bom_component_tbl;
3686:
3687: -- BOM BO input parameters
3688: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
3689: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

Line 3688: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

3684: l_input_bomheader_rec Bom_Bo_Pub.Bom_Product_Rec_Type := p_bom_header_rec;
3685: l_input_bomcomponents_tbl Bom_Bo_Pub.Bom_Product_Mem_Tab_Type := p_bom_component_tbl;
3686:
3687: -- BOM BO input parameters
3688: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
3689: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3690: x_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3691: x_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3692: x_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 3689: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

3685: l_input_bomcomponents_tbl Bom_Bo_Pub.Bom_Product_Mem_Tab_Type := p_bom_component_tbl;
3686:
3687: -- BOM BO input parameters
3688: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
3689: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3690: x_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3691: x_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3692: x_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3693: x_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;

Line 3690: x_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;

3686:
3687: -- BOM BO input parameters
3688: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
3689: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3690: x_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3691: x_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3692: x_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3693: x_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3694:

Line 3691: x_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

3687: -- BOM BO input parameters
3688: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
3689: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3690: x_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3691: x_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3692: x_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3693: x_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3694:
3695: l_other_message VARCHAR2(50);

Line 3692: x_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

3688: l_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
3689: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3690: x_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3691: x_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3692: x_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3693: x_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3694:
3695: l_other_message VARCHAR2(50);
3696: l_compcount NUMBER;

Line 3693: x_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;

3689: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
3690: x_bom_revision_tbl_out BOM_BO_PUB.Bom_Revision_Tbl_Type;
3691: x_bom_ref_designator_tbl_out BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
3692: x_bom_sub_component_tbl_out BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
3693: x_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3694:
3695: l_other_message VARCHAR2(50);
3696: l_compcount NUMBER;
3697: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 3884: END Bom_Bo_Pub;

3880: P_output_dir => P_output_dir,
3881: P_debug_filename => P_debug_filename);
3882: END IF;
3883: END;
3884: END Bom_Bo_Pub;