APPS.ENG_FORM_ECO_PVT dependencies on ENG_ECO_PUB

Line 9: G_MISS_ECO_REC ENG_Eco_PUB.ECO_Rec_Type;

5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_Eco_PVT';
7: G_EXC_QUIT_IMPORT EXCEPTION;
8:
9: G_MISS_ECO_REC ENG_Eco_PUB.ECO_Rec_Type;
10: G_MISS_ECO_REV_REC ENG_Eco_PUB.ECO_Revision_Rec_Type;
11: G_MISS_REV_ITEM_REC ENG_Eco_PUB.Revised_Item_Rec_Type;
12: G_MISS_REV_COMP_REC BOM_BO_PUB.Rev_Component_Rec_Type;
13: G_MISS_REF_DESG_REC BOM_BO_PUB.Ref_Designator_Rec_Type;

Line 10: G_MISS_ECO_REV_REC ENG_Eco_PUB.ECO_Revision_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_Eco_PVT';
7: G_EXC_QUIT_IMPORT EXCEPTION;
8:
9: G_MISS_ECO_REC ENG_Eco_PUB.ECO_Rec_Type;
10: G_MISS_ECO_REV_REC ENG_Eco_PUB.ECO_Revision_Rec_Type;
11: G_MISS_REV_ITEM_REC ENG_Eco_PUB.Revised_Item_Rec_Type;
12: G_MISS_REV_COMP_REC BOM_BO_PUB.Rev_Component_Rec_Type;
13: G_MISS_REF_DESG_REC BOM_BO_PUB.Ref_Designator_Rec_Type;
14: G_MISS_SUB_COMP_REC BOM_BO_PUB.Sub_Component_Rec_Type;

Line 11: G_MISS_REV_ITEM_REC ENG_Eco_PUB.Revised_Item_Rec_Type;

7: G_EXC_QUIT_IMPORT EXCEPTION;
8:
9: G_MISS_ECO_REC ENG_Eco_PUB.ECO_Rec_Type;
10: G_MISS_ECO_REV_REC ENG_Eco_PUB.ECO_Revision_Rec_Type;
11: G_MISS_REV_ITEM_REC ENG_Eco_PUB.Revised_Item_Rec_Type;
12: G_MISS_REV_COMP_REC BOM_BO_PUB.Rev_Component_Rec_Type;
13: G_MISS_REF_DESG_REC BOM_BO_PUB.Ref_Designator_Rec_Type;
14: G_MISS_SUB_COMP_REC BOM_BO_PUB.Sub_Component_Rec_Type;
15: G_MISS_REV_OP_REC BOM_RTG_PUB.Rev_Operation_Rec_Type; --add

Line 109: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

105: PROCEDURE Rev_Sub_Res
106: ( p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
107: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
108: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
109: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
110: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
111: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
112: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
113: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 111: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

107: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
108: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
109: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
110: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
111: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
112: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
113: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
114: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
115: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 112: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

108: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
109: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
110: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
111: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
112: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
113: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
114: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
115: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
116: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type

Line 135: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

131: l_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type;
132: l_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := p_unexp_Rev_Sub_Res_rec;
133: l_old_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type := NULL;
134: l_old_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL;
135: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
136: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
137: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
138: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
139: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 136: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

132: l_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := p_unexp_Rev_Sub_Res_rec;
133: l_old_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type := NULL;
134: l_old_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL;
135: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
136: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
137: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
138: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
139: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
140: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

Line 137: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

133: l_old_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type := NULL;
134: l_old_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL;
135: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
136: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
137: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
138: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
139: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
140: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
141: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;

Line 419: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

415: PROCEDURE Rev_Op_Res
416: ( p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
417: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
418: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
419: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
420: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
421: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
422: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
423: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 421: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

417: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
418: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
419: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
420: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
421: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
422: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
423: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
424: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
425: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 422: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

418: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
419: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
420: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
421: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
422: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
423: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
424: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
425: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
426: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type

Line 445: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

441: l_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type;
442: l_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := p_unexp_rev_op_res_rec;
443: l_old_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type := NULL;
444: l_old_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL;
445: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
446: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
447: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
448: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
449: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 446: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

442: l_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := p_unexp_rev_op_res_rec;
443: l_old_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type := NULL;
444: l_old_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL;
445: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
446: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
447: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
448: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
449: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
450: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

Line 447: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

443: l_old_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type := NULL;
444: l_old_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL;
445: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
446: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
447: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
448: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
449: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
450: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
451: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;

Line 728: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

724: ( p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type
725: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
726: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type
727: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
728: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
729: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
730: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
731: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
732: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 730: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

726: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type
727: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
728: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
729: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
730: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
731: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
732: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
733: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
734: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 731: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

727: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
728: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
729: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
730: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
731: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
732: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
733: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
734: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
735: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type

Line 754: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

750: l_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type;
751: l_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := p_unexp_rev_op_rec;
752: l_old_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type := NULL;
753: l_old_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL;
754: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
755: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
756: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
757: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
758: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 755: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

751: l_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := p_unexp_rev_op_rec;
752: l_old_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type := NULL;
753: l_old_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL;
754: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
755: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
756: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
757: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
758: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
759: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

Line 756: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

752: l_old_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type := NULL;
753: l_old_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL;
754: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
755: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
756: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
757: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
758: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
759: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
760: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;

Line 1455: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

1451: PROCEDURE Sub_Comps
1452: ( p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1453: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1454: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1455: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1456: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1457: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1458: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1459: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 1457: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

1453: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1454: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1455: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1456: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1457: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1458: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1459: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1460: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1461: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 1458: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

1454: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1455: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1456: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1457: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1458: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1459: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1460: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1461: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1462: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

Line 1481: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

1477: l_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type;
1478: l_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := p_unexp_sub_comp_rec;
1479: l_old_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type := NULL;
1480: l_old_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL;
1481: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1482: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1483: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1484: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1485: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

Line 1482: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

1478: l_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := p_unexp_sub_comp_rec;
1479: l_old_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type := NULL;
1480: l_old_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL;
1481: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1482: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1483: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1484: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1485: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1486: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

Line 1483: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

1479: l_old_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type := NULL;
1480: l_old_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL;
1481: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1482: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1483: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1484: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1485: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1486: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1487: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

Line 1755: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

1751: PROCEDURE Ref_Desgs
1752: ( p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1753: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1754: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1755: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1756: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1757: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1758: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1759: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 1757: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

1753: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1754: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1755: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1756: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1757: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1758: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1759: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1760: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1761: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 1758: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

1754: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1755: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1756: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1757: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1758: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1759: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1760: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1761: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1762: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

Line 1781: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

1777: l_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type;
1778: l_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := p_unexp_ref_desg_rec;
1779: l_old_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type := NULL;
1780: l_old_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL;
1781: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1782: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1783: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1784: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1785: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

Line 1782: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

1778: l_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := p_unexp_ref_desg_rec;
1779: l_old_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type := NULL;
1780: l_old_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL;
1781: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1782: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1783: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1784: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1785: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1786: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

Line 1783: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

1779: l_old_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type := NULL;
1780: l_old_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL;
1781: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1782: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1783: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1784: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1785: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1786: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1787: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

Line 2009: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

2005: ( p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
2006: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
2007: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
2008: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
2009: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2010: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
2011: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2012: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2013: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 2011: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

2007: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
2008: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
2009: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2010: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
2011: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2012: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2013: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2014: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2015: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 2012: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

2008: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
2009: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2010: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
2011: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2012: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2013: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2014: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2015: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2016: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

Line 2035: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

2031: l_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type;
2032: l_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := p_unexp_rev_comp_rec;
2033: l_old_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type := NULL;
2034: l_old_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL;
2035: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2036: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2037: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2038: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2039: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

Line 2036: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

2032: l_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := p_unexp_rev_comp_rec;
2033: l_old_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type := NULL;
2034: l_old_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL;
2035: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2036: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2037: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2038: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2039: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2040: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

Line 2037: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

2033: l_old_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type := NULL;
2034: l_old_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL;
2035: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2036: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2037: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2038: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2039: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2040: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2041: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

Line 2504: ( p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type

2500:
2501: -- Rev_Items
2502:
2503: PROCEDURE Rev_Items
2504: ( p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
2505: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2506: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
2507: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
2508: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

Line 2505: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type

2501: -- Rev_Items
2502:
2503: PROCEDURE Rev_Items
2504: ( p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
2505: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2506: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
2507: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
2508: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
2509: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type --add

Line 2512: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

2508: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
2509: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type --add
2510: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type --add
2511: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type --add
2512: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2513: , x_unexp_rev_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2514: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2515: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2516: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 2513: , x_unexp_rev_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type

2509: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type --add
2510: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type --add
2511: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type --add
2512: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2513: , x_unexp_rev_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2514: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2515: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2516: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2517: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 2514: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

2510: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type --add
2511: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type --add
2512: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2513: , x_unexp_rev_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2514: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2515: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2516: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2517: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2518: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 2515: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

2511: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type --add
2512: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2513: , x_unexp_rev_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2514: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2515: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2516: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2517: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2518: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2519: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

Line 2535: l_revised_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type;

2531: l_err_text VARCHAR2(2000);
2532: l_valid BOOLEAN := TRUE;
2533: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2534: l_bo_return_status VARCHAR2(1) := 'S';
2535: l_revised_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type;
2536: l_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := p_unexp_rev_item_rec;
2537: l_old_rev_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type := NULL;
2538: l_old_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := NULL;
2539: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

Line 2536: l_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := p_unexp_rev_item_rec;

2532: l_valid BOOLEAN := TRUE;
2533: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2534: l_bo_return_status VARCHAR2(1) := 'S';
2535: l_revised_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type;
2536: l_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := p_unexp_rev_item_rec;
2537: l_old_rev_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type := NULL;
2538: l_old_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := NULL;
2539: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2540: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 2537: l_old_rev_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type := NULL;

2533: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2534: l_bo_return_status VARCHAR2(1) := 'S';
2535: l_revised_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type;
2536: l_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := p_unexp_rev_item_rec;
2537: l_old_rev_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type := NULL;
2538: l_old_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := NULL;
2539: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2540: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2541: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;

Line 2538: l_old_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := NULL;

2534: l_bo_return_status VARCHAR2(1) := 'S';
2535: l_revised_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type;
2536: l_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := p_unexp_rev_item_rec;
2537: l_old_rev_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type := NULL;
2538: l_old_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := NULL;
2539: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2540: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2541: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
2542: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

Line 2539: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

2535: l_revised_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type;
2536: l_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := p_unexp_rev_item_rec;
2537: l_old_rev_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type := NULL;
2538: l_old_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := NULL;
2539: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2540: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2541: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
2542: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2543: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

Line 2540: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

2536: l_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := p_unexp_rev_item_rec;
2537: l_old_rev_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type := NULL;
2538: l_old_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := NULL;
2539: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2540: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2541: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
2542: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2543: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2544: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

Line 2541: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;

2537: l_old_rev_item_Rec Eng_Eco_Pub.Revised_Item_Rec_Type := NULL;
2538: l_old_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := NULL;
2539: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2540: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2541: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
2542: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2543: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2544: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2545: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add

Line 3009: ( p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type

3005:
3006: -- Eco_Rev
3007:
3008: PROCEDURE Eco_Rev
3009: ( p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3010: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3011: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3012: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3013: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 3010: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type

3006: -- Eco_Rev
3007:
3008: PROCEDURE Eco_Rev
3009: ( p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3010: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3011: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3012: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3013: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3014: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

Line 3011: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type

3007:
3008: PROCEDURE Eco_Rev
3009: ( p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3010: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3011: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3012: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3013: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3014: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3015: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add

Line 3018: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

3014: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3015: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3016: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3017: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3018: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3019: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3020: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3021: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3022: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 3019: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type

3015: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3016: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3017: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3018: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3019: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3020: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3021: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3022: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3023: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 3020: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

3016: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3017: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3018: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3019: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3020: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3021: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3022: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3023: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3024: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 3021: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

3017: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3018: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3019: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3020: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3021: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3022: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3023: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3024: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3025: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

Line 3040: l_eco_rev_unexp_Rec Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type := p_unexp_eco_rev_rec;

3036: l_err_text VARCHAR2(2000);
3037: l_valid BOOLEAN := TRUE;
3038: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3039: l_bo_return_status VARCHAR2(1) := 'S';
3040: l_eco_rev_unexp_Rec Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type := p_unexp_eco_rev_rec;
3041: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
3042: l_eco_revision_rec ENG_ECO_PUB.Eco_Revision_Rec_Type;
3043: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3044: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;

Line 3041: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

3037: l_valid BOOLEAN := TRUE;
3038: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3039: l_bo_return_status VARCHAR2(1) := 'S';
3040: l_eco_rev_unexp_Rec Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type := p_unexp_eco_rev_rec;
3041: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
3042: l_eco_revision_rec ENG_ECO_PUB.Eco_Revision_Rec_Type;
3043: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3044: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3045: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

Line 3042: l_eco_revision_rec ENG_ECO_PUB.Eco_Revision_Rec_Type;

3038: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3039: l_bo_return_status VARCHAR2(1) := 'S';
3040: l_eco_rev_unexp_Rec Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type := p_unexp_eco_rev_rec;
3041: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
3042: l_eco_revision_rec ENG_ECO_PUB.Eco_Revision_Rec_Type;
3043: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3044: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3045: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3046: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

Line 3043: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;

3039: l_bo_return_status VARCHAR2(1) := 'S';
3040: l_eco_rev_unexp_Rec Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type := p_unexp_eco_rev_rec;
3041: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
3042: l_eco_revision_rec ENG_ECO_PUB.Eco_Revision_Rec_Type;
3043: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3044: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3045: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3046: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3047: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

Line 3044: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;

3040: l_eco_rev_unexp_Rec Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type := p_unexp_eco_rev_rec;
3041: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
3042: l_eco_revision_rec ENG_ECO_PUB.Eco_Revision_Rec_Type;
3043: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3044: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3045: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3046: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3047: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3048: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add

Line 3298: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type

3294:
3295: -- Eco_Header
3296:
3297: PROCEDURE Eco_Header
3298: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
3299: , p_unexp_ECO_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3300: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3301: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3302: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type

Line 3299: , p_unexp_ECO_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type

3295: -- Eco_Header
3296:
3297: PROCEDURE Eco_Header
3298: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
3299: , p_unexp_ECO_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3300: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3301: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3302: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3303: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 3300: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type

3296:
3297: PROCEDURE Eco_Header
3298: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
3299: , p_unexp_ECO_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3300: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3301: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3302: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3303: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3304: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

Line 3301: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type

3297: PROCEDURE Eco_Header
3298: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
3299: , p_unexp_ECO_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3300: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3301: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3302: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3303: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3304: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3305: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add

Line 3308: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

3304: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3305: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3306: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3307: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3308: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3309: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3310: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3311: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3312: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 3309: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type

3305: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3306: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3307: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3308: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3309: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3310: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3311: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3312: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3313: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 3310: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

3306: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3307: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3308: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3309: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3310: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3311: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3312: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3313: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3314: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 3311: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

3307: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3308: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3309: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3310: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3311: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3312: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3313: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3314: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3315: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 3330: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;

3326: l_err_text VARCHAR2(2000);
3327: l_valid BOOLEAN := TRUE;
3328: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3329: l_bo_return_status VARCHAR2(1) := 'S';
3330: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
3331: l_eco_unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3332: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;
3333: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
3334: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;

Line 3331: l_eco_unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;

3327: l_valid BOOLEAN := TRUE;
3328: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3329: l_bo_return_status VARCHAR2(1) := 'S';
3330: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
3331: l_eco_unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3332: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;
3333: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
3334: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3335: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;

Line 3332: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;

3328: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3329: l_bo_return_status VARCHAR2(1) := 'S';
3330: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
3331: l_eco_unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3332: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;
3333: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
3334: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3335: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3336: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

Line 3333: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;

3329: l_bo_return_status VARCHAR2(1) := 'S';
3330: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
3331: l_eco_unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3332: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;
3333: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
3334: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3335: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3336: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3337: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

Line 3334: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;

3330: l_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type;
3331: l_eco_unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3332: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;
3333: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
3334: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3335: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3336: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3337: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3338: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

Line 3335: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;

3331: l_eco_unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3332: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;
3333: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
3334: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3335: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3336: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3337: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3338: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3339: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;

Line 3346: l_ECO_Rec_1 Eng_Eco_Pub.ECO_Rec_Type := p_ECO_rec;

3342: l_return_value NUMBER;
3343: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3344:
3345: --10dec
3346: l_ECO_Rec_1 Eng_Eco_Pub.ECO_Rec_Type := p_ECO_rec;
3347: l_eco_unexp_Rec_1 Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3348:
3349:
3350: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 3347: l_eco_unexp_Rec_1 Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;

3343: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3344:
3345: --10dec
3346: l_ECO_Rec_1 Eng_Eco_Pub.ECO_Rec_Type := p_ECO_rec;
3347: l_eco_unexp_Rec_1 Eng_Eco_Pub.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3348:
3349:
3350: EXC_SEV_QUIT_RECORD EXCEPTION;
3351: EXC_UNEXP_SKIP_OBJECT EXCEPTION;

Line 3843: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=

3839: PROCEDURE Process_Eco
3840: ( x_return_status IN OUT NOCOPY VARCHAR2
3841: , x_msg_count IN OUT NOCOPY NUMBER
3842: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
3843: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
3844: ENG_Eco_PUB.G_MISS_ECO_REC
3845: , p_unexp_eco_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type := NULL
3846: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type := NULL
3847: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL

Line 3844: ENG_Eco_PUB.G_MISS_ECO_REC

3840: ( x_return_status IN OUT NOCOPY VARCHAR2
3841: , x_msg_count IN OUT NOCOPY NUMBER
3842: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
3843: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
3844: ENG_Eco_PUB.G_MISS_ECO_REC
3845: , p_unexp_eco_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type := NULL
3846: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type := NULL
3847: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL
3848: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL

Line 3845: , p_unexp_eco_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type := NULL

3841: , x_msg_count IN OUT NOCOPY NUMBER
3842: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
3843: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
3844: ENG_Eco_PUB.G_MISS_ECO_REC
3845: , p_unexp_eco_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type := NULL
3846: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type := NULL
3847: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL
3848: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL
3849: , p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL

Line 3846: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type := NULL

3842: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
3843: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
3844: ENG_Eco_PUB.G_MISS_ECO_REC
3845: , p_unexp_eco_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type := NULL
3846: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type := NULL
3847: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL
3848: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL
3849: , p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL
3850: , p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL

Line 3848: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL

3844: ENG_Eco_PUB.G_MISS_ECO_REC
3845: , p_unexp_eco_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type := NULL
3846: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type := NULL
3847: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL
3848: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL
3849: , p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL
3850: , p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL
3851: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL
3852: , p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL

Line 3854: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=

3850: , p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL
3851: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL
3852: , p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL
3853: , p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL
3854: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
3855: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3856: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
3857: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3858: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=

Line 3855: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL

3851: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL
3852: , p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL
3853: , p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL
3854: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
3855: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3856: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
3857: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3858: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
3859: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL

Line 3856: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=

3852: , p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL
3853: , p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL
3854: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
3855: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3856: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
3857: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3858: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
3859: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
3860: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=

Line 3857: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL

3853: , p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL
3854: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
3855: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3856: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
3857: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3858: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
3859: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
3860: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
3861: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL

Line 3870: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec

3866: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=
3867: BOM_RTG_PUB.G_MISS_REV_OP_RESOURCE_TBL
3868: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3869: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3870: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
3871: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3872: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3873: , x_unexp_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
3874: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type

Line 3871: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type

3867: BOM_RTG_PUB.G_MISS_REV_OP_RESOURCE_TBL
3868: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3869: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3870: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
3871: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3872: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3873: , x_unexp_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
3874: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
3875: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type

Line 3872: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type

3868: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3869: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3870: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
3871: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3872: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3873: , x_unexp_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
3874: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
3875: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
3876: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type

Line 3873: , x_unexp_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type

3869: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3870: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
3871: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3872: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3873: , x_unexp_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
3874: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
3875: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
3876: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
3877: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type

Line 3880: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

3876: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
3877: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
3878: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
3879: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
3880: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3881: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3882: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3883: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3884: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 3881: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

3877: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
3878: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
3879: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
3880: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3881: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3882: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3883: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3884: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3885: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Operation_Tbl_Type

Line 3898: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;

3894: l_bo_return_status VARCHAR2(1);
3895:
3896: l_control_rec BOM_BO_PUB.Control_Rec_Type;
3897:
3898: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
3899: l_unexp_eco_rec ENG_Eco_PUB.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3900: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
3901: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
3902: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

Line 3899: l_unexp_eco_rec ENG_Eco_PUB.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;

3895:
3896: l_control_rec BOM_BO_PUB.Control_Rec_Type;
3897:
3898: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
3899: l_unexp_eco_rec ENG_Eco_PUB.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3900: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
3901: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
3902: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
3903: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 3900: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;

3896: l_control_rec BOM_BO_PUB.Control_Rec_Type;
3897:
3898: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
3899: l_unexp_eco_rec ENG_Eco_PUB.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3900: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
3901: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
3902: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
3903: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
3904: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;

Line 3901: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

3897:
3898: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
3899: l_unexp_eco_rec ENG_Eco_PUB.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3900: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
3901: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
3902: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
3903: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
3904: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
3905: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 3902: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

3898: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
3899: l_unexp_eco_rec ENG_Eco_PUB.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3900: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
3901: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
3902: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
3903: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
3904: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
3905: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
3906: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;

Line 3903: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

3899: l_unexp_eco_rec ENG_Eco_PUB.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3900: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
3901: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
3902: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
3903: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
3904: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
3905: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
3906: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
3907: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 4656: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=

4652: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4653: , x_return_status IN OUT NOCOPY VARCHAR2
4654: , x_msg_count IN OUT NOCOPY NUMBER
4655: , x_msg_data IN OUT NOCOPY VARCHAR2
4656: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
4657: ENG_Eco_PUB.G_MISS_ECO_REC
4658: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
4659: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
4660: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=

Line 4657: ENG_Eco_PUB.G_MISS_ECO_REC

4653: , x_return_status IN OUT NOCOPY VARCHAR2
4654: , x_msg_count IN OUT NOCOPY NUMBER
4655: , x_msg_data IN OUT NOCOPY VARCHAR2
4656: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
4657: ENG_Eco_PUB.G_MISS_ECO_REC
4658: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
4659: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
4660: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
4661: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL

Line 4658: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=

4654: , x_msg_count IN OUT NOCOPY NUMBER
4655: , x_msg_data IN OUT NOCOPY VARCHAR2
4656: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
4657: ENG_Eco_PUB.G_MISS_ECO_REC
4658: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
4659: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
4660: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
4661: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
4662: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=

Line 4659: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL

4655: , x_msg_data IN OUT NOCOPY VARCHAR2
4656: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
4657: ENG_Eco_PUB.G_MISS_ECO_REC
4658: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
4659: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
4660: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
4661: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
4662: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
4663: ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL

Line 4660: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=

4656: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
4657: ENG_Eco_PUB.G_MISS_ECO_REC
4658: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
4659: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
4660: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
4661: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
4662: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
4663: ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
4664: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=

Line 4661: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL

4657: ENG_Eco_PUB.G_MISS_ECO_REC
4658: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
4659: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
4660: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
4661: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
4662: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
4663: ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
4664: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
4665: ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL

Line 4663: ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL

4659: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
4660: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
4661: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
4662: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
4663: ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
4664: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
4665: ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
4666: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
4667: ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL

Line 4665: ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL

4661: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
4662: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
4663: ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
4664: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
4665: ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
4666: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
4667: ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
4668: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
4669: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

Line 4667: ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL

4663: ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
4664: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
4665: ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
4666: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
4667: ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
4668: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
4669: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
4670: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
4671: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 4668: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

4664: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
4665: ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
4666: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
4667: ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
4668: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
4669: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
4670: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
4671: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
4672: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 4669: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

4665: ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
4666: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
4667: ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
4668: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
4669: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
4670: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
4671: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
4672: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
4673: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 4670: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

4666: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
4667: ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
4668: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
4669: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
4670: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
4671: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
4672: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
4673: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
4674: , x_err_text IN OUT NOCOPY VARCHAR2

Line 4680: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;

4676: IS
4677: l_api_version_number CONSTANT NUMBER := 1.0;
4678: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Eco';
4679: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4680: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
4681: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
4682: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
4683: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
4684: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;

Line 4681: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

4677: l_api_version_number CONSTANT NUMBER := 1.0;
4678: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Eco';
4679: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4680: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
4681: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
4682: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
4683: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
4684: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4685: BEGIN