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 1452: ( p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type

1448:
1449: -- Sub_Comps
1450:
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

Line 1453: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

1449: -- Sub_Comps
1450:
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

Line 1454: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

1450:
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

Line 1456: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type

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
1460: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 1459: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_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
1463: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 1460: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_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
1463: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1464: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 1461: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_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
1463: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1464: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1465: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1477: l_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type;

1473: l_err_text VARCHAR2(2000);
1474: l_valid BOOLEAN := TRUE;
1475: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1476: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 1478: l_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := p_unexp_sub_comp_rec;

1474: l_valid BOOLEAN := TRUE;
1475: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1476: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 1479: l_old_sub_component_Rec BOM_BO_PUB.Sub_Component_Rec_Type := NULL;

1475: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1476: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 1480: l_old_sub_comp_unexp_Rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL;

1476: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 1484: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

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
1488: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 1485: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

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
1488: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1489: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 1486: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

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
1488: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1489: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1490: l_return_value NUMBER;

Line 1752: ( p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type

1748:
1749: -- Ref_Desgs
1750:
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

Line 1753: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

1749: -- Ref_Desgs
1750:
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

Line 1754: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

1750:
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

Line 1756: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type

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
1760: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 1759: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_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
1763: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 1760: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_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
1763: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1764: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 1761: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_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
1763: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1764: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1765: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1777: l_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type;

1773: l_err_text VARCHAR2(2000);
1774: l_valid BOOLEAN := TRUE;
1775: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1776: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 1778: l_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := p_unexp_ref_desg_rec;

1774: l_valid BOOLEAN := TRUE;
1775: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1776: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 1779: l_old_ref_designator_Rec BOM_BO_PUB.Ref_Designator_Rec_Type := NULL;

1775: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1776: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 1780: l_old_ref_desg_unexp_Rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL;

1776: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 1784: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

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
1788: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 1785: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

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
1788: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1789: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 1786: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

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
1788: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1789: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1790: l_return_value NUMBER;

Line 2005: ( p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type

2001:
2002: -- Rev_Comps
2003:
2004: PROCEDURE Rev_Comps
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

Line 2006: , p_unexp_rev_comp_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type

2002: -- Rev_Comps
2003:
2004: PROCEDURE Rev_Comps
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

Line 2007: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

2003:
2004: PROCEDURE Rev_Comps
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

Line 2008: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

2004: PROCEDURE Rev_Comps
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

Line 2010: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_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
2014: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 2013: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_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
2017: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 2014: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_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
2017: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2018: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 2015: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_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
2017: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2018: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2019: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2031: l_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type;

2027: l_err_text VARCHAR2(2000);
2028: l_valid BOOLEAN := TRUE;
2029: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2030: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 2032: l_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := p_unexp_rev_comp_rec;

2028: l_valid BOOLEAN := TRUE;
2029: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2030: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 2033: l_old_rev_component_Rec BOM_BO_PUB.Rev_Component_Rec_Type := NULL;

2029: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2030: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 2034: l_old_rev_comp_unexp_Rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type := NULL;

2030: l_bo_return_status VARCHAR2(1) := 'S';
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;

Line 2038: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

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
2042: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 2039: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

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
2042: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
2043: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 2040: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

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
2042: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
2043: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
2044: l_return_value NUMBER;

Line 2506: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type

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
2510: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type --add

Line 2507: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

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

Line 2508: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type

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

Line 2516: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

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
2520: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 2517: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_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
2520: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2521: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 2518: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_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
2520: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2521: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2522: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2542: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

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

Line 2543: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

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
2546: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
2547: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add

Line 2544: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

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
2546: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
2547: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
2548: l_return_value NUMBER;

Line 3012: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type

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
3016: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 3013: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type

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

Line 3014: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_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
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

Line 3022: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

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
3026: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 3023: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_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
3026: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3027: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 3024: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_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
3026: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3027: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3028: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 3045: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

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

Line 3046: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

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
3049: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
3050: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add

Line 3047: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

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
3049: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
3050: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
3051: l_return_value NUMBER;

Line 3302: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type

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
3306: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 3303: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_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
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

Line 3304: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_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
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

Line 3312: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

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
3316: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

Line 3313: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_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
3316: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3317: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

Line 3314: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_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
3316: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3317: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3318: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

Line 3336: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;

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

Line 3337: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;

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

Line 3338: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;

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;
3340: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
3341: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
3342: l_return_value NUMBER;

Line 3842: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

3838:
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

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

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
3851: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL

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

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
3853: , p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL

Line 3850: , p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_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
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 :=

Line 3858: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=

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
3862: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=

Line 3859: BOM_BO_PUB.G_MISS_REV_COMPONENT_TBL

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
3862: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3863: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL

Line 3860: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=

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
3862: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3863: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
3864: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=

Line 3861: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL

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
3862: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3863: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
3864: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=
3865: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL

Line 3862: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=

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
3862: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3863: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
3864: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=
3865: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL
3866: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=

Line 3863: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL

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
3862: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3863: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
3864: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=
3865: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL
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

Line 3874: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type

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
3878: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type

Line 3875: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type

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

Line 3876: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_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
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

Line 3882: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_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
3886: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type

Line 3883: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_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
3886: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
3887: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type

Line 3884: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_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
3886: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
3887: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
3888: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

Line 3896: l_control_rec BOM_BO_PUB.Control_Rec_Type;

3892: l_err_text VARCHAR2(240);
3893: l_return_status VARCHAR2(1);
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;

Line 3904: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;

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;
3908: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;

Line 3905: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_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;
3908: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3909: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

Line 3906: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_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;
3908: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3909: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
3910: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

Line 3907: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_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;
3908: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3909: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
3910: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
3911: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 3908: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_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;
3908: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3909: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
3910: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
3911: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
3912: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 3909: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_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;
3908: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3909: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
3910: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
3911: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
3912: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
3913: l_rev_operation_rec BOM_RTG_PUB.Rev_Operation_Rec_Type; --add

Line 4662: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type :=

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
4666: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=

Line 4664: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=

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
4668: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

Line 4666: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=

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
4670: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

Line 4671: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_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
4675: )

Line 4672: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

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
4675: )
4676: IS

Line 4673: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_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
4675: )
4676: IS
4677: l_api_version_number CONSTANT NUMBER := 1.0;

Line 4682: l_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;

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
4686:

Line 4683: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;

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
4686:
4687: -- Standard call to check for call compatibility

Line 4684: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;

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
4686:
4687: -- Standard call to check for call compatibility
4688: