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

APPS.ENG_FORM_ECO_PVT dependencies on BOM_BO_PUB

Line 12: G_MISS_REV_COMP_REC BOM_BO_PUB.Rev_Component_Rec_Type;

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
16: G_MISS_REV_OP_RES_REC BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add

Line 13: G_MISS_REF_DESG_REC BOM_BO_PUB.Ref_Designator_Rec_Type;

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
16: G_MISS_REV_OP_RES_REC BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
17: G_MISS_REV_SUB_RES_REC BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add

Line 14: G_MISS_SUB_COMP_REC BOM_BO_PUB.Sub_Component_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
16: G_MISS_REV_OP_RES_REC BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
17: G_MISS_REV_SUB_RES_REC BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
18:

Line 19: G_CONTROL_REC BOM_BO_PUB.Control_Rec_Type;

15: G_MISS_REV_OP_REC BOM_RTG_PUB.Rev_Operation_Rec_Type; --add
16: G_MISS_REV_OP_RES_REC BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
17: G_MISS_REV_SUB_RES_REC BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
18:
19: G_CONTROL_REC BOM_BO_PUB.Control_Rec_Type;
20:
21:
22: -- Added for Bug#1587263
23: -- Set Revised Item's attributes to Global_System_Information

Line 113: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_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
117: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type

Line 114: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_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
117: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type
118: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type

Line 115: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_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
117: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type
118: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
119: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 138: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

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;
142: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;

Line 139: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

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;
142: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
143: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;

Line 140: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

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;
142: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
143: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
144: l_return_value NUMBER;

Line 423: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_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
427: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type

Line 424: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_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
427: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type
428: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type

Line 425: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_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
427: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type
428: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
429: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 448: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

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;
452: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;

Line 449: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

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;
452: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
453: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;

Line 450: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

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;
452: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
453: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
454: l_return_value NUMBER;

Line 732: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_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
736: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type

Line 733: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_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
736: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type
737: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type

Line 734: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_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
736: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type
737: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
738: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 757: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

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;
761: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;

Line 758: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

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;
761: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
762: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;

Line 759: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

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;
761: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
762: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
763: l_return_value NUMBER;

Line 1442: ( p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type

1438:
1439: -- Sub_Comps
1440:
1441: PROCEDURE Sub_Comps
1442: ( p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1443: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1444: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1445: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1446: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type

Line 1443: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

1439: -- Sub_Comps
1440:
1441: PROCEDURE Sub_Comps
1442: ( p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1443: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1444: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1445: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1446: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1447: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

Line 1444: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

1440:
1441: PROCEDURE Sub_Comps
1442: ( p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1443: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1444: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1445: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1446: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1447: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1448: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

Line 1446: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type

1442: ( p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1443: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1444: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1445: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1446: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1447: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1448: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1449: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1450: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 1449: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

1445: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1446: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1447: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1448: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1449: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1450: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1451: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1452: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1453: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 1450: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

1446: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
1447: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1448: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1449: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1450: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1451: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1452: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1453: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1454: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 1451: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

1447: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1448: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1449: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1450: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1451: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1452: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1453: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1454: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1455: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1467: l_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type;

1463: l_err_text VARCHAR2(2000);
1464: l_valid BOOLEAN := TRUE;
1465: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1466: l_bo_return_status VARCHAR2(1) := 'S';
1467: l_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type;
1468: l_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := p_unexp_sub_comp_rec;
1469: l_old_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type := NULL;
1470: l_old_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL;
1471: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

Line 1468: l_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := p_unexp_sub_comp_rec;

1464: l_valid BOOLEAN := TRUE;
1465: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1466: l_bo_return_status VARCHAR2(1) := 'S';
1467: l_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type;
1468: l_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := p_unexp_sub_comp_rec;
1469: l_old_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type := NULL;
1470: l_old_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL;
1471: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1472: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 1469: l_old_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type := NULL;

1465: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1466: l_bo_return_status VARCHAR2(1) := 'S';
1467: l_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type;
1468: l_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := p_unexp_sub_comp_rec;
1469: l_old_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type := NULL;
1470: l_old_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL;
1471: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1472: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1473: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 1470: l_old_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL;

1466: l_bo_return_status VARCHAR2(1) := 'S';
1467: l_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type;
1468: l_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := p_unexp_sub_comp_rec;
1469: l_old_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type := NULL;
1470: l_old_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL;
1471: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1472: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1473: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1474: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 1474: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

1470: l_old_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL;
1471: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1472: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1473: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1474: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1475: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1476: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1477: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1478: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 1475: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

1471: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1472: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1473: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1474: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1475: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1476: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1477: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1478: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1479: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 1476: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

1472: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1473: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1474: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1475: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1476: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1477: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1478: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1479: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1480: l_return_value NUMBER;

Line 1742: ( p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type

1738:
1739: -- Ref_Desgs
1740:
1741: PROCEDURE Ref_Desgs
1742: ( p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1743: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1744: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1745: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1746: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type

Line 1743: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

1739: -- Ref_Desgs
1740:
1741: PROCEDURE Ref_Desgs
1742: ( p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1743: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1744: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1745: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1746: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1747: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

Line 1744: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

1740:
1741: PROCEDURE Ref_Desgs
1742: ( p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1743: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1744: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1745: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1746: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1747: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1748: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

Line 1746: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type

1742: ( p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1743: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1744: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1745: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1746: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1747: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1748: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1749: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1750: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 1749: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

1745: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
1746: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1747: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1748: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1749: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1750: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1751: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1752: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1753: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 1750: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

1746: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
1747: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1748: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1749: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1750: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1751: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1752: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1753: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1754: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 1751: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

1747: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
1748: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
1749: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1750: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1751: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1752: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1753: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1754: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1755: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1767: l_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type;

1763: l_err_text VARCHAR2(2000);
1764: l_valid BOOLEAN := TRUE;
1765: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1766: l_bo_return_status VARCHAR2(1) := 'S';
1767: l_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type;
1768: l_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := p_unexp_ref_desg_rec;
1769: l_old_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type := NULL;
1770: l_old_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL;
1771: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

Line 1768: l_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := p_unexp_ref_desg_rec;

1764: l_valid BOOLEAN := TRUE;
1765: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1766: l_bo_return_status VARCHAR2(1) := 'S';
1767: l_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type;
1768: l_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := p_unexp_ref_desg_rec;
1769: l_old_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type := NULL;
1770: l_old_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL;
1771: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1772: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 1769: l_old_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type := NULL;

1765: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1766: l_bo_return_status VARCHAR2(1) := 'S';
1767: l_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type;
1768: l_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := p_unexp_ref_desg_rec;
1769: l_old_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type := NULL;
1770: l_old_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL;
1771: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1772: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1773: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 1770: l_old_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL;

1766: l_bo_return_status VARCHAR2(1) := 'S';
1767: l_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type;
1768: l_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := p_unexp_ref_desg_rec;
1769: l_old_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type := NULL;
1770: l_old_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL;
1771: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1772: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1773: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1774: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 1774: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

1770: l_old_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL;
1771: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1772: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1773: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1774: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1775: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1776: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1777: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1778: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 1775: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

1771: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
1772: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1773: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1774: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1775: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1776: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1777: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1778: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1779: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 1776: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

1772: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
1773: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
1774: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1775: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1776: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1777: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1778: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1779: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1780: l_return_value NUMBER;

Line 1995: ( p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type

1991:
1992: -- Rev_Comps
1993:
1994: PROCEDURE Rev_Comps
1995: ( p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
1996: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
1997: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1998: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1999: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

Line 1996: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type

1992: -- Rev_Comps
1993:
1994: PROCEDURE Rev_Comps
1995: ( p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
1996: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
1997: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1998: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1999: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2000: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type

Line 1997: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

1993:
1994: PROCEDURE Rev_Comps
1995: ( p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
1996: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
1997: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1998: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1999: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2000: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
2001: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

Line 1998: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

1994: PROCEDURE Rev_Comps
1995: ( p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
1996: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
1997: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1998: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1999: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2000: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
2001: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2002: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

Line 2000: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type

1996: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
1997: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
1998: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
1999: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2000: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
2001: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2002: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2003: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2004: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 2003: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

1999: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2000: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
2001: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2002: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2003: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2004: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2005: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2006: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2007: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 2004: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

2000: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
2001: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2002: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2003: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2004: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2005: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2006: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2007: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2008: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 2005: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

2001: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2002: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2003: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2004: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2005: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2006: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2007: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2008: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2009: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2021: l_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type;

2017: l_err_text VARCHAR2(2000);
2018: l_valid BOOLEAN := TRUE;
2019: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2020: l_bo_return_status VARCHAR2(1) := 'S';
2021: l_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type;
2022: l_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := p_unexp_rev_comp_rec;
2023: l_old_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type := NULL;
2024: l_old_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL;
2025: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

Line 2022: l_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := p_unexp_rev_comp_rec;

2018: l_valid BOOLEAN := TRUE;
2019: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2020: l_bo_return_status VARCHAR2(1) := 'S';
2021: l_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type;
2022: l_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := p_unexp_rev_comp_rec;
2023: l_old_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type := NULL;
2024: l_old_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL;
2025: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2026: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 2023: l_old_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type := NULL;

2019: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2020: l_bo_return_status VARCHAR2(1) := 'S';
2021: l_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type;
2022: l_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := p_unexp_rev_comp_rec;
2023: l_old_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type := NULL;
2024: l_old_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL;
2025: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2026: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2027: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 2024: l_old_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL;

2020: l_bo_return_status VARCHAR2(1) := 'S';
2021: l_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type;
2022: l_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := p_unexp_rev_comp_rec;
2023: l_old_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type := NULL;
2024: l_old_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL;
2025: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2026: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2027: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2028: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

Line 2028: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

2024: l_old_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL;
2025: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2026: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2027: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2028: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2029: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2030: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2031: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
2032: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 2029: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

2025: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2026: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2027: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2028: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2029: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2030: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2031: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
2032: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
2033: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 2030: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

2026: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2027: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
2028: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2029: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2030: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2031: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
2032: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
2033: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
2034: l_return_value NUMBER;

Line 2496: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type

2492:
2493: PROCEDURE Rev_Items
2494: ( p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
2495: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2496: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
2497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
2498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
2499: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type --add
2500: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type --add

Line 2497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

2493: PROCEDURE Rev_Items
2494: ( p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
2495: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2496: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
2497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
2498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
2499: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type --add
2500: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type --add
2501: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type --add

Line 2498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

2494: ( p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
2495: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2496: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
2497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
2498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
2499: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type --add
2500: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type --add
2501: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type --add
2502: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

Line 2506: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

2502: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2503: , x_unexp_rev_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2504: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2505: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2506: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2507: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2508: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2509: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2510: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 2507: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

2503: , x_unexp_rev_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2504: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2505: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2506: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2507: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2508: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2509: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2510: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2511: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 2508: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

2504: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2505: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
2506: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2507: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2508: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2509: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2510: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2511: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2512: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2532: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

2528: l_old_rev_item_unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type := NULL;
2529: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2530: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2531: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
2532: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2533: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2534: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2535: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
2536: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add

Line 2533: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

2529: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
2530: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2531: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
2532: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2533: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2534: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2535: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
2536: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
2537: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add

Line 2534: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

2530: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
2531: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
2532: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2533: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2534: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2535: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
2536: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
2537: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
2538: l_return_value NUMBER;

Line 3002: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type

2998: PROCEDURE Eco_Rev
2999: ( p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3000: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3001: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3002: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3003: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3004: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3005: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3006: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 3003: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

2999: ( p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3000: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3001: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3002: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3003: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3004: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3005: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3006: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3007: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 3004: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

3000: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3001: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3002: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3003: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3004: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3005: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3006: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3007: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3008: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

Line 3012: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

3008: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3009: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3010: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3011: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3012: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3013: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3014: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3015: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3016: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 3013: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

3009: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3010: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3011: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3012: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3013: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3014: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3015: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3016: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3017: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 3014: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

3010: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3011: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3012: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3013: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3014: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3015: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3016: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3017: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3018: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 3035: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

3031: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
3032: l_eco_revision_rec ENG_ECO_PUB.Eco_Revision_Rec_Type;
3033: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3034: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3035: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3036: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3037: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3038: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
3039: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add

Line 3036: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

3032: l_eco_revision_rec ENG_ECO_PUB.Eco_Revision_Rec_Type;
3033: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3034: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3035: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3036: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3037: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3038: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
3039: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
3040: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add

Line 3037: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

3033: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3034: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3035: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3036: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3037: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3038: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
3039: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
3040: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
3041: l_return_value NUMBER;

Line 3292: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type

3288: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
3289: , p_unexp_ECO_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3290: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3291: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3292: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3293: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3294: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3295: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3296: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 3293: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

3289: , p_unexp_ECO_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3290: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3291: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3292: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3293: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3294: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3295: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3296: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3297: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 3294: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

3290: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type
3291: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
3292: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3293: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3294: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3295: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3296: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3297: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3298: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

Line 3302: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

3298: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3299: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3300: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3301: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3302: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3303: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3304: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3305: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3306: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

Line 3303: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

3299: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3300: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3301: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3302: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3303: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3304: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3305: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3306: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3307: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 3304: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

3300: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3301: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3302: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3303: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3304: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3305: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3306: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3307: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3308: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 3326: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

3322: l_Old_ECO_Rec Eng_Eco_Pub.ECO_Rec_Type := NULL;
3323: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
3324: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3325: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3326: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3327: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3328: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3329: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;
3330: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;

Line 3327: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

3323: l_Old_ECO_Unexp_Rec Eng_Eco_Pub.ECO_Unexposed_Rec_Type := NULL;
3324: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3325: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3326: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3327: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3328: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3329: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;
3330: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
3331: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;

Line 3328: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

3324: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type := p_eco_revision_tbl;
3325: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
3326: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3327: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3328: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3329: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;
3330: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
3331: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
3332: l_return_value NUMBER;

Line 3832: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

3828:
3829: PROCEDURE Process_Eco
3830: ( x_return_status IN OUT NOCOPY VARCHAR2
3831: , x_msg_count IN OUT NOCOPY NUMBER
3832: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
3833: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
3834: ENG_Eco_PUB.G_MISS_ECO_REC
3835: , p_unexp_eco_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type := NULL
3836: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type := NULL

Line 3837: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL

3833: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
3834: ENG_Eco_PUB.G_MISS_ECO_REC
3835: , p_unexp_eco_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type := NULL
3836: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type := NULL
3837: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL
3838: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL
3839: , p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL
3840: , p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL
3841: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL

Line 3839: , p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL

3835: , p_unexp_eco_rec IN ENG_Eco_PUB.ECO_Unexposed_Rec_Type := NULL
3836: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type := NULL
3837: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL
3838: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL
3839: , p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL
3840: , p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL
3841: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL
3842: , p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL
3843: , p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL

Line 3840: , p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL

3836: , p_unexp_rev_item_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type := NULL
3837: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL
3838: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL
3839: , p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL
3840: , p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL
3841: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL
3842: , p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL
3843: , p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL
3844: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=

Line 3848: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=

3844: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
3845: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3846: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
3847: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3848: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
3849: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
3850: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
3851: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
3852: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=

Line 3849: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL

3845: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3846: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
3847: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3848: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
3849: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
3850: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
3851: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
3852: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3853: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL

Line 3850: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=

3846: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
3847: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3848: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
3849: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
3850: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
3851: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
3852: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3853: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
3854: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=

Line 3851: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL

3847: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
3848: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
3849: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
3850: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
3851: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
3852: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3853: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
3854: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=
3855: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL

Line 3852: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=

3848: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
3849: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
3850: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
3851: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
3852: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3853: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
3854: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=
3855: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL
3856: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=

Line 3853: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL

3849: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL
3850: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
3851: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
3852: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3853: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
3854: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=
3855: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL
3856: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=
3857: BOM_RTG_PUB.G_MISS_REV_OP_RESOURCE_TBL

Line 3864: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type

3860: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
3861: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3862: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3863: , x_unexp_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
3864: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
3865: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
3866: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
3867: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
3868: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type

Line 3865: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type

3861: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3862: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3863: , x_unexp_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
3864: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
3865: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
3866: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
3867: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
3868: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
3869: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type

Line 3866: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type

3862: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3863: , x_unexp_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
3864: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
3865: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
3866: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
3867: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
3868: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
3869: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
3870: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

Line 3872: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

3868: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
3869: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
3870: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3871: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3872: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3873: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3874: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3875: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Operation_Tbl_Type
3876: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type

Line 3873: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

3869: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
3870: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3871: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3872: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3873: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3874: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3875: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Operation_Tbl_Type
3876: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
3877: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type

Line 3874: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

3870: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3871: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3872: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3873: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3874: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3875: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Operation_Tbl_Type
3876: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
3877: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
3878: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

Line 3886: l_control_rec BOM_BO_PUB.Control_Rec_Type;

3882: l_err_text VARCHAR2(240);
3883: l_return_status VARCHAR2(1);
3884: l_bo_return_status VARCHAR2(1);
3885:
3886: l_control_rec BOM_BO_PUB.Control_Rec_Type;
3887:
3888: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
3889: l_unexp_eco_rec ENG_Eco_PUB.ECO_Unexposed_Rec_Type := p_unexp_eco_rec;
3890: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;

Line 3894: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;

3890: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
3891: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
3892: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
3893: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
3894: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
3895: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
3896: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
3897: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
3898: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;

Line 3895: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

3891: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
3892: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
3893: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
3894: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
3895: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
3896: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
3897: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
3898: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3899: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

Line 3896: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;

3892: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
3893: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
3894: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
3895: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
3896: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
3897: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
3898: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3899: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
3900: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

Line 3897: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

3893: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
3894: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
3895: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
3896: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
3897: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
3898: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3899: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
3900: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
3901: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 3898: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;

3894: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
3895: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
3896: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
3897: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
3898: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3899: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
3900: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
3901: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
3902: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 3899: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

3895: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
3896: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
3897: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
3898: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3899: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
3900: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
3901: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
3902: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
3903: l_rev_operation_rec BOM_RTG_PUB.Rev_Operation_Rec_Type; --add

Line 4652: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=

4648: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
4649: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
4650: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
4651: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
4652: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
4653: ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
4654: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
4655: ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
4656: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=

Line 4654: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=

4650: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
4651: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL
4652: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
4653: ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
4654: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
4655: ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
4656: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
4657: ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
4658: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

Line 4656: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=

4652: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=
4653: ENG_Eco_PUB.G_MISS_REV_COMPONENT_TBL
4654: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
4655: ENG_Eco_PUB.G_MISS_REF_DESIGNATOR_TBL
4656: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
4657: ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
4658: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
4659: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
4660: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

Line 4661: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

4657: ENG_Eco_PUB.G_MISS_SUB_COMPONENT_TBL
4658: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
4659: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
4660: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
4661: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
4662: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
4663: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
4664: , x_err_text IN OUT NOCOPY VARCHAR2
4665: )

Line 4662: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

4658: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
4659: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
4660: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
4661: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
4662: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
4663: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
4664: , x_err_text IN OUT NOCOPY VARCHAR2
4665: )
4666: IS

Line 4663: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

4659: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
4660: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
4661: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
4662: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
4663: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
4664: , x_err_text IN OUT NOCOPY VARCHAR2
4665: )
4666: IS
4667: l_api_version_number CONSTANT NUMBER := 1.0;

Line 4672: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;

4668: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Eco';
4669: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4670: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
4671: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
4672: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
4673: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
4674: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4675: BEGIN
4676:

Line 4673: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;

4669: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4670: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
4671: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
4672: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
4673: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
4674: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4675: BEGIN
4676:
4677: -- Standard call to check for call compatibility

Line 4674: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;

4670: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
4671: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
4672: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
4673: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
4674: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
4675: BEGIN
4676:
4677: -- Standard call to check for call compatibility
4678: