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_RTG_PUB

Line 15: G_MISS_REV_OP_REC BOM_RTG_PUB.Rev_Operation_Rec_Type; --add

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:
19: G_CONTROL_REC BOM_BO_PUB.Control_Rec_Type;

Line 16: G_MISS_REV_OP_RES_REC BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add

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:
19: G_CONTROL_REC BOM_BO_PUB.Control_Rec_Type;
20:

Line 17: G_MISS_REV_SUB_RES_REC BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add

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:
19: G_CONTROL_REC BOM_BO_PUB.Control_Rec_Type;
20:
21:

Line 106: ( p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type

102: -- Added by Masahiko Mochizuki on 09/13/00
103: -- Rev_Sub_Res
104:
105: PROCEDURE Rev_Sub_Res
106: ( p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
107: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
108: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
109: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
110: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type

Line 107: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type

103: -- Rev_Sub_Res
104:
105: PROCEDURE Rev_Sub_Res
106: ( p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
107: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
108: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
109: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
110: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
111: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

Line 108: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type

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

Line 110: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type

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

Line 116: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_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
120: , x_return_status IN OUT NOCOPY VARCHAR2

Line 117: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_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
120: , x_return_status IN OUT NOCOPY VARCHAR2
121: )

Line 118: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_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
120: , x_return_status IN OUT NOCOPY VARCHAR2
121: )
122: IS

Line 131: l_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type;

127: l_err_text VARCHAR2(2000);
128: l_valid BOOLEAN := TRUE;
129: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
130: l_bo_return_status VARCHAR2(1) := 'S';
131: l_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type;
132: l_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := p_unexp_Rev_Sub_Res_rec;
133: l_old_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type := NULL;
134: l_old_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL;
135: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

Line 132: l_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := p_unexp_Rev_Sub_Res_rec;

128: l_valid BOOLEAN := TRUE;
129: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
130: l_bo_return_status VARCHAR2(1) := 'S';
131: l_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type;
132: l_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := p_unexp_Rev_Sub_Res_rec;
133: l_old_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type := NULL;
134: l_old_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL;
135: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
136: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 133: l_old_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type := NULL;

129: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
130: l_bo_return_status VARCHAR2(1) := 'S';
131: l_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type;
132: l_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := p_unexp_Rev_Sub_Res_rec;
133: l_old_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type := NULL;
134: l_old_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL;
135: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
136: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
137: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 134: l_old_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL;

130: l_bo_return_status VARCHAR2(1) := 'S';
131: l_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type;
132: l_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := p_unexp_Rev_Sub_Res_rec;
133: l_old_rev_sub_resource_Rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type := NULL;
134: l_old_rev_sub_res_unexp_Rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL;
135: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
136: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
137: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
138: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 141: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_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;
145: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 142: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;

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;
145: l_Token_Tbl Error_Handler.Token_Tbl_Type;
146:

Line 143: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;

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;
145: l_Token_Tbl Error_Handler.Token_Tbl_Type;
146:
147: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 221: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

217: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
218: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
219: , p_old_rev_sub_resource_rec => l_old_rev_sub_resource_rec
220: , p_old_rev_sub_res_unexp_rec => l_old_rev_sub_res_unexp_rec
221: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
222: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
223: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
224: , x_return_status => l_return_status
225: , x_mesg_token_tbl => l_mesg_token_tbl

Line 274: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

270: --dbms_output.put_line('Writing to the database');
271: Bom_Sub_Op_Res_Util.Perform_Writes
272: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
273: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
274: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
275: , x_mesg_token_tbl => x_mesg_token_tbl
276: , x_return_status => x_return_status
277: );
278:

Line 416: ( p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type

412: -- Added by Masahiko Mochizuki on 09/12/00
413: -- Rev_Op_Res
414:
415: PROCEDURE Rev_Op_Res
416: ( p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
417: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
418: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
419: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
420: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type

Line 417: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type

413: -- Rev_Op_Res
414:
415: PROCEDURE Rev_Op_Res
416: ( p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
417: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
418: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
419: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
420: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
421: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

Line 418: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type

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

Line 420: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type

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

Line 426: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_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
430: , x_return_status IN OUT NOCOPY VARCHAR2

Line 427: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_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
430: , x_return_status IN OUT NOCOPY VARCHAR2
431: )

Line 428: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_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
430: , x_return_status IN OUT NOCOPY VARCHAR2
431: )
432: IS

Line 441: l_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type;

437: l_err_text VARCHAR2(2000);
438: l_valid BOOLEAN := TRUE;
439: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
440: l_bo_return_status VARCHAR2(1) := 'S';
441: l_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type;
442: l_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := p_unexp_rev_op_res_rec;
443: l_old_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type := NULL;
444: l_old_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL;
445: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

Line 442: l_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := p_unexp_rev_op_res_rec;

438: l_valid BOOLEAN := TRUE;
439: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
440: l_bo_return_status VARCHAR2(1) := 'S';
441: l_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type;
442: l_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := p_unexp_rev_op_res_rec;
443: l_old_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type := NULL;
444: l_old_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL;
445: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
446: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 443: l_old_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type := NULL;

439: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
440: l_bo_return_status VARCHAR2(1) := 'S';
441: l_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type;
442: l_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := p_unexp_rev_op_res_rec;
443: l_old_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type := NULL;
444: l_old_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL;
445: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
446: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
447: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 444: l_old_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL;

440: l_bo_return_status VARCHAR2(1) := 'S';
441: l_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type;
442: l_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := p_unexp_rev_op_res_rec;
443: l_old_rev_op_resource_Rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type := NULL;
444: l_old_rev_op_res_unexp_Rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL;
445: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
446: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
447: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
448: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 451: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_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;
455: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 452: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;

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;
455: l_Token_Tbl Error_Handler.Token_Tbl_Type;
456:

Line 453: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;

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;
455: l_Token_Tbl Error_Handler.Token_Tbl_Type;
456:
457: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 530: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

526: ( p_rev_op_resource_rec => l_rev_op_resource_rec
527: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
528: , p_old_rev_op_resource_rec => l_old_rev_op_resource_rec
529: , p_old_rev_op_res_unexp_rec => l_old_rev_op_res_unexp_rec
530: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
531: , x_rev_op_resource_rec => l_rev_op_resource_rec
532: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
533: , x_return_status => l_return_status
534: , x_mesg_token_tbl => l_mesg_token_tbl

Line 582: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

578: --dbms_output.put_line('Writing to the database');
579: Bom_Op_Res_Util.Perform_Writes
580: ( p_rev_op_resource_rec => l_rev_op_resource_rec
581: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
582: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
583: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
584: , x_return_status => l_return_status
585: );
586:

Line 724: ( p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type

720: -- Added by Masahiko Mochizuki on 09/12/00
721: -- Rev_Ops
722:
723: PROCEDURE Rev_Ops
724: ( p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type
725: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
726: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type
727: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
728: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

Line 725: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type

721: -- Rev_Ops
722:
723: PROCEDURE Rev_Ops
724: ( p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type
725: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
726: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type
727: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
728: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
729: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type

Line 726: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type

722:
723: PROCEDURE Rev_Ops
724: ( p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type
725: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
726: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type
727: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type
728: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
729: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
730: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

Line 727: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type

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

Line 729: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type

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

Line 735: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_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
739: , x_return_status IN OUT NOCOPY VARCHAR2

Line 736: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_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
739: , x_return_status IN OUT NOCOPY VARCHAR2
740: )

Line 737: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_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
739: , x_return_status IN OUT NOCOPY VARCHAR2
740: )
741: IS

Line 750: l_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type;

746: l_err_text VARCHAR2(2000);
747: l_valid BOOLEAN := TRUE;
748: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
749: l_bo_return_status VARCHAR2(1) := 'S';
750: l_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type;
751: l_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := p_unexp_rev_op_rec;
752: l_old_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type := NULL;
753: l_old_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL;
754: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;

Line 751: l_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := p_unexp_rev_op_rec;

747: l_valid BOOLEAN := TRUE;
748: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
749: l_bo_return_status VARCHAR2(1) := 'S';
750: l_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type;
751: l_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := p_unexp_rev_op_rec;
752: l_old_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type := NULL;
753: l_old_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL;
754: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
755: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 752: l_old_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type := NULL;

748: l_Return_Status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
749: l_bo_return_status VARCHAR2(1) := 'S';
750: l_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type;
751: l_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := p_unexp_rev_op_rec;
752: l_old_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type := NULL;
753: l_old_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL;
754: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
755: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
756: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 753: l_old_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL;

749: l_bo_return_status VARCHAR2(1) := 'S';
750: l_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type;
751: l_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := p_unexp_rev_op_rec;
752: l_old_rev_operation_Rec BOM_RTG_PUB.Rev_Operation_Rec_Type := NULL;
753: l_old_rev_op_unexp_Rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL;
754: l_eco_rec ENG_ECO_PUB.ECO_Rec_Type := NULL;
755: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
756: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
757: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 760: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;

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;
764: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 761: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;

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;
764: l_Token_Tbl Error_Handler.Token_Tbl_Type;
765: l_query_op_seq_num NUMBER := NULL;

Line 762: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;

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;
764: l_Token_Tbl Error_Handler.Token_Tbl_Type;
765: l_query_op_seq_num NUMBER := NULL;
766: -- Bug no:2770096

Line 849: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

845: END IF;
846: Bom_Default_Op_Seq.Attribute_Defaulting
847: ( p_rev_operation_rec => l_rev_operation_rec
848: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
849: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
850: , x_rev_operation_rec => l_rev_operation_rec
851: , x_rev_op_unexp_rec => l_rev_op_unexp_rec
852: , x_return_status => l_return_status
853: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1037: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

1033:
1034: Bom_Default_Op_Seq.Entity_Defaulting
1035: ( p_rev_operation_rec => l_rev_operation_rec
1036: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
1037: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
1038: , x_rev_operation_rec => l_rev_operation_rec
1039: , x_rev_op_unexp_rec => l_rev_op_unexp_rec
1040: , x_return_status => l_return_status
1041: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1145: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

1141: ( p_rev_operation_rec => l_rev_operation_rec
1142: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
1143: , p_old_rev_operation_rec => l_old_rev_operation_rec
1144: , p_old_rev_op_unexp_rec => l_old_rev_op_unexp_rec
1145: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
1146: , x_rev_operation_rec => l_rev_operation_rec
1147: , x_rev_op_unexp_rec => l_rev_op_unexp_rec
1148: , x_return_status => l_return_status
1149: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1256: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

1252: --dbms_output.put_line('Writing to the database');
1253: BOM_Op_Seq_Util.Perform_Writes
1254: ( p_rev_operation_rec => l_rev_operation_rec
1255: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
1256: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
1257: , x_return_status => l_return_status
1258: , x_mesg_token_tbl => l_mesg_token_tbl
1259: );
1260:

Line 1462: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

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
1466: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1463: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

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
1466: , x_return_status IN OUT NOCOPY VARCHAR2
1467: )

Line 1464: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

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
1466: , x_return_status IN OUT NOCOPY VARCHAR2
1467: )
1468: IS

Line 1487: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

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;
1491: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 1488: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

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;
1491: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1492:

Line 1489: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

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;
1491: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1492:
1493: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 1762: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

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
1766: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1763: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

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
1766: , x_return_status IN OUT NOCOPY VARCHAR2
1767: )

Line 1764: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

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
1766: , x_return_status IN OUT NOCOPY VARCHAR2
1767: )
1768: IS

Line 1787: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

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;
1791: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 1788: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

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;
1791: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1792:

Line 1789: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

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;
1791: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1792:
1793: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 2016: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

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
2020: , x_return_status IN OUT NOCOPY VARCHAR2

Line 2017: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

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
2020: , x_return_status IN OUT NOCOPY VARCHAR2
2021: )

Line 2018: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

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
2020: , x_return_status IN OUT NOCOPY VARCHAR2
2021: )
2022: IS

Line 2041: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

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;
2045: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 2042: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

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;
2045: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2046: l_query_op_seq_num NUMBER := NULL;

Line 2043: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

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;
2045: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2046: l_query_op_seq_num NUMBER := NULL;
2047: l_query_effective_date DATE := NULL;

Line 2509: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type --add

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
2513: , x_unexp_rev_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type

Line 2510: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type --add

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

Line 2511: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type --add

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

Line 2519: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

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
2523: , x_return_status IN OUT NOCOPY VARCHAR2

Line 2520: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

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
2523: , x_return_status IN OUT NOCOPY VARCHAR2
2524: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

Line 2521: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

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
2523: , x_return_status IN OUT NOCOPY VARCHAR2
2524: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
2525: )

Line 2545: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add

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;
2549: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 2546: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add

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;
2549: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2550:

Line 2547: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add

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;
2549: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2550:
2551: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 3015: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add

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
3019: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type

Line 3016: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

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

Line 3017: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

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

Line 3025: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

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
3029: , x_return_status IN OUT NOCOPY VARCHAR2

Line 3026: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

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
3029: , x_return_status IN OUT NOCOPY VARCHAR2
3030: )

Line 3027: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

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
3029: , x_return_status IN OUT NOCOPY VARCHAR2
3030: )
3031: IS

Line 3048: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add

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;
3052: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 3049: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add

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;
3052: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3053:

Line 3050: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add

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;
3052: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3053:
3054: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 3305: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add

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
3309: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type

Line 3306: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

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

Line 3307: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

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

Line 3316: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add

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
3319: , x_return_status IN OUT NOCOPY VARCHAR2
3320: )

Line 3317: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add

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
3319: , x_return_status IN OUT NOCOPY VARCHAR2
3320: )
3321: IS

Line 3318: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add

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
3319: , x_return_status IN OUT NOCOPY VARCHAR2
3320: )
3321: IS
3322:

Line 3339: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_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;
3343: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 3340: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_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;
3343: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3344:

Line 3341: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_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;
3343: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3344:
3345: --10dec

Line 3851: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_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 :=
3855: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL

Line 3852: , p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_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 :=
3855: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3856: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=

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

Line 3864: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=

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
3868: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=

Line 3865: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL

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
3868: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3869: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL

Line 3866: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=

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
3868: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3869: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3870: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec

Line 3867: BOM_RTG_PUB.G_MISS_REV_OP_RESOURCE_TBL

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
3868: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3869: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3870: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
3871: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type

Line 3868: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=

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
3868: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3869: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3870: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
3871: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3872: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type

Line 3869: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL

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
3868: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3869: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3870: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
3871: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3872: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3873: , x_unexp_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type

Line 3877: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_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
3881: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

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

Line 3879: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_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
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

Line 3885: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Operation_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
3889: )

Line 3886: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Resource_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
3889: )
3890: IS

Line 3887: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Resource_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
3889: )
3890: IS
3891: l_api_name CONSTANT VARCHAR2(30):= 'Process_Eco';

Line 3910: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

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
3914: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add

Line 3911: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

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
3914: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3915: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add

Line 3912: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

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
3914: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3915: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3916:

Line 3913: l_rev_operation_rec BOM_RTG_PUB.Rev_Operation_Rec_Type; --add

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
3914: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3915: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3916:
3917: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 3914: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add

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
3914: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3915: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3916:
3917: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3918: l_other_message VARCHAR2(2000);

Line 3915: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_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
3914: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3915: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3916:
3917: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3918: l_other_message VARCHAR2(2000);
3919: l_other_token_tbl Error_Handler.Token_Tbl_Type;