APPS.BOM_BO_PVT dependencies on BOM_BO_PUB

Line 60: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

56: , p_alternate_bom_code IN VARCHAR2 := NULL
57: , p_effectivity_date IN DATE := NULL
58: , p_component_item_name IN VARCHAR2 := NULL
59: , p_operation_seq_num IN NUMBER := NULL
60: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
61: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
62: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
63: , x_return_status IN OUT NOCOPY VARCHAR2
64: )

Line 61: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

57: , p_effectivity_date IN DATE := NULL
58: , p_component_item_name IN VARCHAR2 := NULL
59: , p_operation_seq_num IN NUMBER := NULL
60: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
61: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
62: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
63: , x_return_status IN OUT NOCOPY VARCHAR2
64: )
65: IS

Line 76: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

72: l_comp_parent_exists BOOLEAN := FALSE;
73: l_Return_Status VARCHAR2(1);
74: l_bo_return_status VARCHAR2(1);
75:
76: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
77: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
78: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
79: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
80: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;

Line 77: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;

73: l_Return_Status VARCHAR2(1);
74: l_bo_return_status VARCHAR2(1);
75:
76: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
77: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
78: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
79: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
80: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
81: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=

Line 78: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;

74: l_bo_return_status VARCHAR2(1);
75:
76: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
77: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
78: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
79: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
80: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
81: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
82: p_bom_comp_ops_tbl;

Line 79: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;

75:
76: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
77: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
78: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
79: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
80: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
81: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
82: p_bom_comp_ops_tbl;
83: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;

Line 80: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;

76: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
77: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
78: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
79: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
80: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
81: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
82: p_bom_comp_ops_tbl;
83: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
84: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;

Line 81: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=

77: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
78: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
79: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
80: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
81: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
82: p_bom_comp_ops_tbl;
83: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
84: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
85:

Line 83: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;

79: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
80: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
81: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
82: p_bom_comp_ops_tbl;
83: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
84: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
85:
86: l_old_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
87: l_old_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;

Line 84: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;

80: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
81: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
82: p_bom_comp_ops_tbl;
83: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
84: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
85:
86: l_old_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
87: l_old_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
88:

Line 86: l_old_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;

82: p_bom_comp_ops_tbl;
83: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
84: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
85:
86: l_old_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
87: l_old_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
88:
89: l_return_value NUMBER;
90: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 87: l_old_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;

83: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
84: l_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
85:
86: l_old_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
87: l_old_bom_comp_ops_unexp_rec Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type;
88:
89: l_return_value NUMBER;
90: l_Token_Tbl Error_Handler.Token_Tbl_Type;
91: l_comp_ops_processed BOOLEAN := FALSE;

Line 759: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

755: , p_alternate_bom_code IN VARCHAR2 := NULL
756: , p_effectivity_date IN DATE := NULL
757: , p_component_item_name IN VARCHAR2 := NULL
758: , p_operation_seq_num IN NUMBER := NULL
759: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
760: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
761: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
762: , x_return_status IN OUT NOCOPY VARCHAR2
763: )

Line 760: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

756: , p_effectivity_date IN DATE := NULL
757: , p_component_item_name IN VARCHAR2 := NULL
758: , p_operation_seq_num IN NUMBER := NULL
759: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
760: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
761: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
762: , x_return_status IN OUT NOCOPY VARCHAR2
763: )
764: IS

Line 774: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

770: l_item_parent_exists BOOLEAN := FALSE;
771: l_comp_parent_exists BOOLEAN := FALSE;
772: l_Return_Status VARCHAR2(1);
773: l_bo_return_status VARCHAR2(1);
774: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
775: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
776: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
777: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
778: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

Line 775: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;

771: l_comp_parent_exists BOOLEAN := FALSE;
772: l_Return_Status VARCHAR2(1);
773: l_bo_return_status VARCHAR2(1);
774: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
775: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
776: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
777: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
778: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
779: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 776: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;

772: l_Return_Status VARCHAR2(1);
773: l_bo_return_status VARCHAR2(1);
774: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
775: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
776: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
777: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
778: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
779: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
780: := p_bom_sub_component_tbl;

Line 777: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;

773: l_bo_return_status VARCHAR2(1);
774: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
775: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
776: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
777: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
778: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
779: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
780: := p_bom_sub_component_tbl;
781: l_old_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

Line 778: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

774: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
775: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
776: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
777: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
778: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
779: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
780: := p_bom_sub_component_tbl;
781: l_old_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
782: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;

Line 779: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

775: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
776: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
777: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
778: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
779: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
780: := p_bom_sub_component_tbl;
781: l_old_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
782: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
783: l_old_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;

Line 781: l_old_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

777: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
778: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
779: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
780: := p_bom_sub_component_tbl;
781: l_old_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
782: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
783: l_old_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
784: l_return_value NUMBER;
785: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 782: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;

778: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
779: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
780: := p_bom_sub_component_tbl;
781: l_old_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
782: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
783: l_old_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
784: l_return_value NUMBER;
785: l_Token_Tbl Error_Handler.Token_Tbl_Type;
786: l_sub_comp_processed BOOLEAN := FALSE;

Line 783: l_old_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;

779: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
780: := p_bom_sub_component_tbl;
781: l_old_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
782: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
783: l_old_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
784: l_return_value NUMBER;
785: l_Token_Tbl Error_Handler.Token_Tbl_Type;
786: l_sub_comp_processed BOOLEAN := FALSE;
787: BEGIN

Line 819: l_bom_sub_comp_unexp_rec := Bom_Bo_Pub.G_MISS_BOM_SUB_COMP_UNEXP_REC;

815:
816: -- Load local records.
817:
818: l_bom_sub_component_rec := l_bom_sub_component_tbl(I);
819: l_bom_sub_comp_unexp_rec := Bom_Bo_Pub.G_MISS_BOM_SUB_COMP_UNEXP_REC;
820: l_bom_sub_comp_unexp_rec.organization_id := Bom_Globals.Get_org_id;
821:
822:
823: IF Bom_Globals.Get_Debug = 'Y' THEN

Line 1520: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

1516: , p_alternate_bom_code IN VARCHAR2 := NULL
1517: , p_effectivity_date IN DATE := NULL
1518: , p_component_item_name IN VARCHAR2 := NULL
1519: , p_operation_seq_num IN NUMBER := NULL
1520: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1521: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1522: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1523: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1524: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1521: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

1517: , p_effectivity_date IN DATE := NULL
1518: , p_component_item_name IN VARCHAR2 := NULL
1519: , p_operation_seq_num IN NUMBER := NULL
1520: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1521: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1522: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1523: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1524: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1525: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1522: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

1518: , p_component_item_name IN VARCHAR2 := NULL
1519: , p_operation_seq_num IN NUMBER := NULL
1520: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1521: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1522: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1523: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1524: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1525: , x_return_status IN OUT NOCOPY VARCHAR2
1526: )

Line 1523: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

1519: , p_operation_seq_num IN NUMBER := NULL
1520: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1521: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1522: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1523: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1524: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1525: , x_return_status IN OUT NOCOPY VARCHAR2
1526: )
1527: IS

Line 1549: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

1545: l_item_parent_exists BOOLEAN := FALSE;
1546: l_comp_parent_exists BOOLEAN := FALSE;
1547: l_Return_Status VARCHAR2(1);
1548: l_bo_return_status VARCHAR2(1);
1549: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
1550: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1551: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1552: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1553: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=

Line 1550: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;

1546: l_comp_parent_exists BOOLEAN := FALSE;
1547: l_Return_Status VARCHAR2(1);
1548: l_bo_return_status VARCHAR2(1);
1549: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
1550: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1551: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1552: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1553: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
1554: p_bom_ref_designator_tbl;

Line 1551: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;

1547: l_Return_Status VARCHAR2(1);
1548: l_bo_return_status VARCHAR2(1);
1549: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
1550: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1551: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1552: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1553: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
1554: p_bom_ref_designator_tbl;
1555: l_old_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;

Line 1552: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;

1548: l_bo_return_status VARCHAR2(1);
1549: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
1550: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1551: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1552: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1553: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
1554: p_bom_ref_designator_tbl;
1555: l_old_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1556: l_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;

Line 1553: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=

1549: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
1550: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
1551: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1552: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1553: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
1554: p_bom_ref_designator_tbl;
1555: l_old_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1556: l_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;
1557: l_old_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;

Line 1555: l_old_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;

1551: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
1552: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1553: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
1554: p_bom_ref_designator_tbl;
1555: l_old_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1556: l_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;
1557: l_old_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;
1558: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
1559: p_bom_sub_component_tbl;

Line 1556: l_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;

1552: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1553: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
1554: p_bom_ref_designator_tbl;
1555: l_old_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1556: l_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;
1557: l_old_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;
1558: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
1559: p_bom_sub_component_tbl;
1560: l_return_value NUMBER;

Line 1557: l_old_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;

1553: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
1554: p_bom_ref_designator_tbl;
1555: l_old_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1556: l_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;
1557: l_old_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;
1558: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
1559: p_bom_sub_component_tbl;
1560: l_return_value NUMBER;
1561: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 1558: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=

1554: p_bom_ref_designator_tbl;
1555: l_old_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
1556: l_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;
1557: l_old_bom_ref_desg_unexp_rec Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type;
1558: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
1559: p_bom_sub_component_tbl;
1560: l_return_value NUMBER;
1561: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1562: l_ref_desig_processed BOOLEAN := FALSE;

Line 2208: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type

2204: , p_organization_id IN NUMBER := NULL
2205: , p_assembly_item_name IN VARCHAR2 := NULL
2206: , p_alternate_bom_code IN VARCHAR2 := NULL
2207: , p_effectivity_date IN DATE := NULL
2208: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
2209: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2210: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2211: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2212: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type

Line 2209: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

2205: , p_assembly_item_name IN VARCHAR2 := NULL
2206: , p_alternate_bom_code IN VARCHAR2 := NULL
2207: , p_effectivity_date IN DATE := NULL
2208: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
2209: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2210: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2211: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2212: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
2213: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

Line 2210: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

2206: , p_alternate_bom_code IN VARCHAR2 := NULL
2207: , p_effectivity_date IN DATE := NULL
2208: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
2209: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2210: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2211: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2212: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
2213: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2214: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 2211: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

2207: , p_effectivity_date IN DATE := NULL
2208: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
2209: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2210: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2211: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2212: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
2213: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2214: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2215: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

Line 2212: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type

2208: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
2209: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2210: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2211: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2212: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
2213: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2214: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2215: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2216: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2213: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

2209: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2210: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2211: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2212: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
2213: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2214: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2215: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2216: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2217: , x_return_status IN OUT NOCOPY VARCHAR2

Line 2214: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

2210: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2211: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2212: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
2213: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2214: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2215: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2216: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2217: , x_return_status IN OUT NOCOPY VARCHAR2
2218: )

Line 2215: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

2211: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2212: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
2213: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
2214: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
2215: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
2216: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2217: , x_return_status IN OUT NOCOPY VARCHAR2
2218: )
2219: IS

Line 2229: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

2225: l_item_parent_exists BOOLEAN := FALSE;
2226: l_Return_Status VARCHAR2(1);
2227: l_bo_return_status VARCHAR2(1);
2228:
2229: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
2230: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
2231: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2232: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
2233: l_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;

Line 2230: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;

2226: l_Return_Status VARCHAR2(1);
2227: l_bo_return_status VARCHAR2(1);
2228:
2229: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
2230: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
2231: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2232: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
2233: l_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2234: l_old_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;

Line 2231: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;

2227: l_bo_return_status VARCHAR2(1);
2228:
2229: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
2230: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
2231: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2232: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
2233: l_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2234: l_old_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2235: l_old_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;

Line 2232: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;

2228:
2229: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
2230: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
2231: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2232: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
2233: l_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2234: l_old_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2235: l_old_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2236: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=

Line 2233: l_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;

2229: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
2230: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
2231: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2232: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
2233: l_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2234: l_old_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2235: l_old_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2236: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
2237: p_bom_ref_designator_tbl;

Line 2234: l_old_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;

2230: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
2231: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2232: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
2233: l_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2234: l_old_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2235: l_old_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2236: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
2237: p_bom_ref_designator_tbl;
2238: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=

Line 2235: l_old_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;

2231: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2232: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
2233: l_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2234: l_old_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2235: l_old_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2236: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
2237: p_bom_ref_designator_tbl;
2238: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
2239: p_bom_sub_component_tbl;

Line 2236: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=

2232: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
2233: l_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2234: l_old_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2235: l_old_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2236: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
2237: p_bom_ref_designator_tbl;
2238: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
2239: p_bom_sub_component_tbl;
2240: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=

Line 2238: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=

2234: l_old_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
2235: l_old_bom_comp_unexp_rec Bom_Bo_Pub.Bom_Comps_Unexposed_Rec_Type;
2236: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
2237: p_bom_ref_designator_tbl;
2238: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
2239: p_bom_sub_component_tbl;
2240: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
2241: p_bom_comp_ops_tbl;
2242: l_return_value NUMBER;

Line 2240: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=

2236: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
2237: p_bom_ref_designator_tbl;
2238: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
2239: p_bom_sub_component_tbl;
2240: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
2241: p_bom_comp_ops_tbl;
2242: l_return_value NUMBER;
2243: l_process_children BOOLEAN := TRUE;
2244: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 2268: l_bom_comp_unexp_rec := Bom_Bo_Pub.G_MISS_BOM_COMP_UNEXP_REC;

2264:
2265: l_process_children := false;
2266:
2267: -- Initialize the unexposed record;
2268: l_bom_comp_unexp_rec := Bom_Bo_Pub.G_MISS_BOM_COMP_UNEXP_REC;
2269: l_bom_comp_unexp_rec.organization_id := Bom_Globals.Get_org_id;
2270:
2271:
2272: l_bom_component_rec.transaction_type :=

Line 3423: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type

3419: , p_assembly_item_name IN VARCHAR2 := NULL
3420: , p_assembly_item_id IN NUMBER := NULL
3421: , p_organization_id IN NUMBER := NULL
3422: , p_alternate_bom_code IN VARCHAR2 := NULL
3423: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
3424: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3425: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3426: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3427: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

Line 3424: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type

3420: , p_assembly_item_id IN NUMBER := NULL
3421: , p_organization_id IN NUMBER := NULL
3422: , p_alternate_bom_code IN VARCHAR2 := NULL
3423: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
3424: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3425: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3426: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3427: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3428: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

Line 3425: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

3421: , p_organization_id IN NUMBER := NULL
3422: , p_alternate_bom_code IN VARCHAR2 := NULL
3423: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
3424: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3425: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3426: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3427: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3428: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3429: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type

Line 3426: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

3422: , p_alternate_bom_code IN VARCHAR2 := NULL
3423: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
3424: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3425: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3426: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3427: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3428: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3429: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3430: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

Line 3427: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

3423: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
3424: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3425: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3426: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3427: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3428: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3429: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3430: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3431: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 3428: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

3424: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3425: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3426: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3427: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3428: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3429: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3430: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3431: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3432: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

Line 3429: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type

3425: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3426: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3427: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3428: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3429: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3430: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3431: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3432: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3433: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 3430: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

3426: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3427: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3428: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3429: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3430: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3431: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3432: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3433: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3434: , x_return_status IN OUT NOCOPY VARCHAR2

Line 3431: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

3427: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3428: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3429: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3430: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3431: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3432: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3433: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3434: , x_return_status IN OUT NOCOPY VARCHAR2
3435: )

Line 3432: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

3428: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3429: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3430: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3431: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3432: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3433: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3434: , x_return_status IN OUT NOCOPY VARCHAR2
3435: )
3436: IS

Line 3446: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

3442: l_Return_Status VARCHAR2(1);
3443: l_bo_return_status VARCHAR2(1);
3444: l_bom_parent_exists BOOLEAN := FALSE;
3445:
3446: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3447: l_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3448: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3449: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3450:

Line 3447: l_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;

3443: l_bo_return_status VARCHAR2(1);
3444: l_bom_parent_exists BOOLEAN := FALSE;
3445:
3446: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3447: l_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3448: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3449: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3450:
3451: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;

Line 3448: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

3444: l_bom_parent_exists BOOLEAN := FALSE;
3445:
3446: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3447: l_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3448: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3449: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3450:
3451: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
3452: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;

Line 3449: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;

3445:
3446: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3447: l_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3448: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3449: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3450:
3451: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
3452: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3453: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type;

Line 3451: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;

3447: l_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3448: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3449: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3450:
3451: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
3452: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3453: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type;
3454: l_old_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type := NULL;
3455: l_old_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type := NULL;

Line 3452: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;

3448: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3449: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3450:
3451: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
3452: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3453: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type;
3454: l_old_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type := NULL;
3455: l_old_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type := NULL;
3456:

Line 3453: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type;

3449: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3450:
3451: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
3452: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3453: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type;
3454: l_old_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type := NULL;
3455: l_old_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type := NULL;
3456:
3457: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;

Line 3454: l_old_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type := NULL;

3450:
3451: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
3452: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3453: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type;
3454: l_old_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type := NULL;
3455: l_old_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type := NULL;
3456:
3457: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
3458: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

Line 3455: l_old_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type := NULL;

3451: l_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type;
3452: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3453: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type;
3454: l_old_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type := NULL;
3455: l_old_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type := NULL;
3456:
3457: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
3458: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3459: := p_bom_ref_designator_tbl;

Line 3457: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;

3453: l_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type;
3454: l_old_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type := NULL;
3455: l_old_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type := NULL;
3456:
3457: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
3458: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3459: := p_bom_ref_designator_tbl;
3460: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3461: := p_bom_sub_component_tbl;

Line 3458: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

3454: l_old_bom_revision_rec Bom_Bo_Pub.Bom_Revision_Rec_Type := NULL;
3455: l_old_bom_rev_unexp_rec Bom_Bo_Pub.Bom_Rev_Unexposed_Rec_Type := NULL;
3456:
3457: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
3458: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3459: := p_bom_ref_designator_tbl;
3460: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3461: := p_bom_sub_component_tbl;
3462: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

Line 3460: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

3456:
3457: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
3458: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3459: := p_bom_ref_designator_tbl;
3460: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3461: := p_bom_sub_component_tbl;
3462: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3463: := p_bom_comp_ops_tbl;
3464: l_return_value NUMBER;

Line 3462: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

3458: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3459: := p_bom_ref_designator_tbl;
3460: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3461: := p_bom_sub_component_tbl;
3462: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3463: := p_bom_comp_ops_tbl;
3464: l_return_value NUMBER;
3465: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3466:

Line 3949: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type

3945: ***************************************************************************/
3946:
3947: PROCEDURE Bom_Header
3948: ( p_validation_level IN NUMBER
3949: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
3950: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
3951: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3952: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3953: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 3950: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type

3946:
3947: PROCEDURE Bom_Header
3948: ( p_validation_level IN NUMBER
3949: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
3950: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
3951: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3952: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3953: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3954: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

Line 3951: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type

3947: PROCEDURE Bom_Header
3948: ( p_validation_level IN NUMBER
3949: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
3950: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
3951: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3952: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3953: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3954: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3955: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type

Line 3952: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

3948: ( p_validation_level IN NUMBER
3949: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
3950: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
3951: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3952: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3953: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3954: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3955: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
3956: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

Line 3953: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

3949: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
3950: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
3951: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3952: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3953: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3954: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3955: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
3956: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3957: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type

Line 3954: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

3950: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type
3951: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3952: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3953: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3954: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3955: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
3956: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3957: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3958: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

Line 3955: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type

3951: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type
3952: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3953: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3954: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3955: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
3956: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3957: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3958: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3959: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 3956: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

3952: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3953: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3954: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3955: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
3956: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3957: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3958: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3959: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3960: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

Line 3957: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type

3953: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3954: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3955: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
3956: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3957: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3958: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3959: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3960: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3961: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 3958: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

3954: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3955: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
3956: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3957: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3958: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3959: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3960: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3961: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3962: , x_return_status IN OUT NOCOPY VARCHAR2

Line 3959: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

3955: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
3956: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3957: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3958: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3959: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3960: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3961: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3962: , x_return_status IN OUT NOCOPY VARCHAR2
3963: )

Line 3960: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

3956: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
3957: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
3958: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
3959: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
3960: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
3961: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3962: , x_return_status IN OUT NOCOPY VARCHAR2
3963: )
3964: IS

Line 3974: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

3970: l_valid BOOLEAN := TRUE;
3971: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3972: l_bo_return_status VARCHAR2(1) := 'S';
3973:
3974: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3975: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3976: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3977: l_bom_header_Unexp_Rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3978:

Line 3975: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

3971: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3972: l_bo_return_status VARCHAR2(1) := 'S';
3973:
3974: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3975: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3976: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3977: l_bom_header_Unexp_Rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3978:
3979: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;

Line 3976: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;

3972: l_bo_return_status VARCHAR2(1) := 'S';
3973:
3974: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3975: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3976: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3977: l_bom_header_Unexp_Rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3978:
3979: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3980: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;

Line 3977: l_bom_header_Unexp_Rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;

3973:
3974: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3975: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3976: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3977: l_bom_header_Unexp_Rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3978:
3979: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3980: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
3981: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=

Line 3979: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;

3975: l_old_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
3976: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3977: l_bom_header_Unexp_Rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3978:
3979: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3980: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
3981: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
3982: p_bom_ref_designator_tbl;
3983: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=

Line 3980: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;

3976: l_old_bom_header_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3977: l_bom_header_Unexp_Rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3978:
3979: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3980: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
3981: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
3982: p_bom_ref_designator_tbl;
3983: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
3984: p_bom_sub_component_tbl;

Line 3981: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=

3977: l_bom_header_Unexp_Rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
3978:
3979: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3980: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
3981: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
3982: p_bom_ref_designator_tbl;
3983: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
3984: p_bom_sub_component_tbl;
3985: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=

Line 3983: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=

3979: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type := p_bom_revision_tbl;
3980: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type := p_bom_component_tbl;
3981: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
3982: p_bom_ref_designator_tbl;
3983: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
3984: p_bom_sub_component_tbl;
3985: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
3986: p_bom_comp_ops_tbl;
3987: l_return_value NUMBER;

Line 3985: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=

3981: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type :=
3982: p_bom_ref_designator_tbl;
3983: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
3984: p_bom_sub_component_tbl;
3985: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type :=
3986: p_bom_comp_ops_tbl;
3987: l_return_value NUMBER;
3988: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3989:

Line 4876: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=

4872: ( p_api_version_number IN NUMBER
4873: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
4874: , x_return_status IN OUT NOCOPY VARCHAR2
4875: , x_msg_count IN OUT NOCOPY NUMBER
4876: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
4877: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
4878: , p_bom_revision_tbl IN Bom_Bo_PUB.Bom_Revision_Tbl_Type :=
4879: Bom_Bo_PUB.G_MISS_BOM_REVISION_TBL
4880: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=

Line 4877: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC

4873: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
4874: , x_return_status IN OUT NOCOPY VARCHAR2
4875: , x_msg_count IN OUT NOCOPY NUMBER
4876: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
4877: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
4878: , p_bom_revision_tbl IN Bom_Bo_PUB.Bom_Revision_Tbl_Type :=
4879: Bom_Bo_PUB.G_MISS_BOM_REVISION_TBL
4880: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
4881: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL

Line 4878: , p_bom_revision_tbl IN Bom_Bo_PUB.Bom_Revision_Tbl_Type :=

4874: , x_return_status IN OUT NOCOPY VARCHAR2
4875: , x_msg_count IN OUT NOCOPY NUMBER
4876: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
4877: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
4878: , p_bom_revision_tbl IN Bom_Bo_PUB.Bom_Revision_Tbl_Type :=
4879: Bom_Bo_PUB.G_MISS_BOM_REVISION_TBL
4880: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
4881: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
4882: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

Line 4879: Bom_Bo_PUB.G_MISS_BOM_REVISION_TBL

4875: , x_msg_count IN OUT NOCOPY NUMBER
4876: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
4877: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
4878: , p_bom_revision_tbl IN Bom_Bo_PUB.Bom_Revision_Tbl_Type :=
4879: Bom_Bo_PUB.G_MISS_BOM_REVISION_TBL
4880: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
4881: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
4882: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4883: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL

Line 4880: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=

4876: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
4877: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
4878: , p_bom_revision_tbl IN Bom_Bo_PUB.Bom_Revision_Tbl_Type :=
4879: Bom_Bo_PUB.G_MISS_BOM_REVISION_TBL
4880: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
4881: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
4882: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4883: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
4884: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 4881: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL

4877: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
4878: , p_bom_revision_tbl IN Bom_Bo_PUB.Bom_Revision_Tbl_Type :=
4879: Bom_Bo_PUB.G_MISS_BOM_REVISION_TBL
4880: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
4881: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
4882: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4883: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
4884: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4885: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL

Line 4882: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

4878: , p_bom_revision_tbl IN Bom_Bo_PUB.Bom_Revision_Tbl_Type :=
4879: Bom_Bo_PUB.G_MISS_BOM_REVISION_TBL
4880: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
4881: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
4882: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4883: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
4884: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4885: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
4886: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

Line 4883: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL

4879: Bom_Bo_PUB.G_MISS_BOM_REVISION_TBL
4880: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
4881: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
4882: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4883: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
4884: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4885: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
4886: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4887: := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL

Line 4884: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

4880: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
4881: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
4882: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4883: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
4884: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4885: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
4886: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4887: := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
4888: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type

Line 4885: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL

4881: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
4882: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4883: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
4884: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4885: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
4886: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4887: := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
4888: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
4889: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_PUB.Bom_Revision_Tbl_Type

Line 4886: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

4882: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4883: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
4884: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4885: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
4886: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4887: := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
4888: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
4889: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_PUB.Bom_Revision_Tbl_Type
4890: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type

Line 4887: := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL

4883: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
4884: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4885: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
4886: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4887: := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
4888: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
4889: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_PUB.Bom_Revision_Tbl_Type
4890: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
4891: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

Line 4888: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type

4884: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4885: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
4886: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4887: := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
4888: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
4889: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_PUB.Bom_Revision_Tbl_Type
4890: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
4891: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4892: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 4889: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_PUB.Bom_Revision_Tbl_Type

4885: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
4886: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4887: := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
4888: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
4889: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_PUB.Bom_Revision_Tbl_Type
4890: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
4891: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4892: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4893: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

Line 4890: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type

4886: , p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4887: := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
4888: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
4889: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_PUB.Bom_Revision_Tbl_Type
4890: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
4891: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4892: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4893: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4894: )

Line 4891: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

4887: := Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
4888: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
4889: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_PUB.Bom_Revision_Tbl_Type
4890: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
4891: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4892: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4893: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4894: )
4895: IS

Line 4892: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

4888: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
4889: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_PUB.Bom_Revision_Tbl_Type
4890: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
4891: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4892: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4893: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4894: )
4895: IS
4896: l_api_version_number CONSTANT NUMBER := 1.0;

Line 4893: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type

4889: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_PUB.Bom_Revision_Tbl_Type
4890: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
4891: , x_bom_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
4892: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
4893: , x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
4894: )
4895: IS
4896: l_api_version_number CONSTANT NUMBER := 1.0;
4897: l_api_name CONSTANT VARCHAR2(30):= 'Process_Bom';

Line 4903: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

4899: l_return_status VARCHAR2(1);
4900:
4901: l_bo_return_status VARCHAR2(1);
4902:
4903: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
4904: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
4905: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
4906: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
4907: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

Line 4904: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;

4900:
4901: l_bo_return_status VARCHAR2(1);
4902:
4903: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
4904: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
4905: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
4906: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
4907: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
4908: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;

Line 4905: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;

4901: l_bo_return_status VARCHAR2(1);
4902:
4903: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
4904: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
4905: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
4906: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
4907: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
4908: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
4909: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;

Line 4906: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;

4902:
4903: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
4904: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
4905: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
4906: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
4907: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
4908: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
4909: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
4910: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;

Line 4907: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

4903: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
4904: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
4905: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
4906: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
4907: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
4908: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
4909: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
4910: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
4911: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;

Line 4908: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;

4904: l_bom_component_rec Bom_Bo_Pub.Bom_Comps_Rec_Type;
4905: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
4906: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
4907: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
4908: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
4909: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
4910: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
4911: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
4912: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;

Line 4909: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;

4905: l_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
4906: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
4907: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
4908: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
4909: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
4910: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
4911: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
4912: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
4913:

Line 4910: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;

4906: l_bom_ref_designator_rec Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type;
4907: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
4908: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
4909: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
4910: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
4911: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
4912: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
4913:
4914: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 4911: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;

4907: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
4908: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
4909: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
4910: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
4911: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
4912: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
4913:
4914: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4915: l_other_message VARCHAR2(2000);

Line 4912: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;

4908: l_bom_comp_ops_rec Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type;
4909: l_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
4910: l_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
4911: l_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
4912: l_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
4913:
4914: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4915: l_other_message VARCHAR2(2000);
4916: l_other_token_tbl Error_Handler.Token_Tbl_Type;