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 1246: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

1242: --dbms_output.put_line('Writing to the database');
1243: BOM_Op_Seq_Util.Perform_Writes
1244: ( p_rev_operation_rec => l_rev_operation_rec
1245: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
1246: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
1247: , x_return_status => l_return_status
1248: , x_mesg_token_tbl => l_mesg_token_tbl
1249: );
1250:

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

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

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

1449: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1450: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1451: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1452: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1453: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1454: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1455: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1456: , x_return_status IN OUT NOCOPY VARCHAR2
1457: )

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

1450: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1451: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1452: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1453: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1454: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1455: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1456: , x_return_status IN OUT NOCOPY VARCHAR2
1457: )
1458: IS

Line 1477: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

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

Line 1478: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

1474: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1475: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1476: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1477: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1478: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1479: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1480: l_return_value NUMBER;
1481: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1482:

Line 1479: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

1475: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1476: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1477: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1478: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1479: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1480: l_return_value NUMBER;
1481: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1482:
1483: EXC_SEV_QUIT_RECORD EXCEPTION;

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

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

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

1749: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1750: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1751: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1752: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1753: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1754: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1755: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1756: , x_return_status IN OUT NOCOPY VARCHAR2
1757: )

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

1750: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1751: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1752: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
1753: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
1754: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
1755: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1756: , x_return_status IN OUT NOCOPY VARCHAR2
1757: )
1758: IS

Line 1777: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

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

Line 1778: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

1774: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1775: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1776: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1777: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1778: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1779: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1780: l_return_value NUMBER;
1781: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1782:

Line 1779: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

1775: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
1776: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
1777: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
1778: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
1779: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
1780: l_return_value NUMBER;
1781: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1782:
1783: EXC_SEV_QUIT_RECORD EXCEPTION;

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

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

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

2003: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2004: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2005: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2006: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2007: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2008: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2009: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2010: , x_return_status IN OUT NOCOPY VARCHAR2
2011: )

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

2004: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2005: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2006: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2007: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2008: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2009: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2010: , x_return_status IN OUT NOCOPY VARCHAR2
2011: )
2012: IS

Line 2031: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

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

Line 2032: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

2028: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2029: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2030: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2031: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
2032: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
2033: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
2034: l_return_value NUMBER;
2035: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2036: l_query_op_seq_num NUMBER := NULL;

Line 2033: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

2029: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2030: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2031: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
2032: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
2033: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
2034: l_return_value NUMBER;
2035: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2036: l_query_op_seq_num NUMBER := NULL;
2037: l_query_effective_date DATE := NULL;

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

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

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

2496: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
2497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
2498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
2499: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type --add
2500: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type --add
2501: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type --add
2502: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2503: , x_unexp_rev_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2504: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

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

2497: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
2498: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
2499: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type --add
2500: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type --add
2501: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type --add
2502: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
2503: , x_unexp_rev_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
2504: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
2505: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

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

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

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

2506: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
2507: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2508: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2509: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2510: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2511: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2512: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2513: , x_return_status IN OUT NOCOPY VARCHAR2
2514: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

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

2507: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
2508: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
2509: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
2510: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
2511: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
2512: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2513: , x_return_status IN OUT NOCOPY VARCHAR2
2514: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
2515: )

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

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

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

2532: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
2533: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2534: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2535: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
2536: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
2537: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
2538: l_return_value NUMBER;
2539: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2540:

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

2533: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
2534: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
2535: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
2536: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
2537: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
2538: l_return_value NUMBER;
2539: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2540:
2541: EXC_SEV_QUIT_RECORD EXCEPTION;

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

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

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

3002: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3003: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3004: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3005: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3006: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3007: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3008: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3009: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3010: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

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

3003: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3004: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3005: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3006: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3007: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3008: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3009: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3010: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3011: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

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

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

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

3012: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3013: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3014: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3015: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3016: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3017: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3018: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3019: , x_return_status IN OUT NOCOPY VARCHAR2
3020: )

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

3013: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3014: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3015: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3016: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3017: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3018: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3019: , x_return_status IN OUT NOCOPY VARCHAR2
3020: )
3021: IS

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

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

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

3035: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3036: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3037: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3038: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
3039: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
3040: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
3041: l_return_value NUMBER;
3042: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3043:

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

3036: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3037: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3038: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --add
3039: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl; --add
3040: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl; --add
3041: l_return_value NUMBER;
3042: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3043:
3044: EXC_SEV_QUIT_RECORD EXCEPTION;

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

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

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

3292: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
3293: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3294: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3295: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3296: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3297: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3298: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3299: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3300: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

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

3293: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
3294: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
3295: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3296: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3297: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3298: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
3299: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3300: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3301: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

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

3302: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3303: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3304: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3305: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3306: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3307: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3308: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3309: , x_return_status IN OUT NOCOPY VARCHAR2
3310: )

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

3303: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3304: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3305: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3306: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3307: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3308: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3309: , x_return_status IN OUT NOCOPY VARCHAR2
3310: )
3311: IS

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

3304: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3305: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3306: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_operation_Tbl_Type --add
3307: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_op_resource_Tbl_Type --add
3308: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_sub_resource_Tbl_Type --add
3309: , x_return_status IN OUT NOCOPY VARCHAR2
3310: )
3311: IS
3312:

Line 3329: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;

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

Line 3330: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;

3326: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
3327: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3328: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3329: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;
3330: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
3331: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
3332: l_return_value NUMBER;
3333: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3334:

Line 3331: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;

3327: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
3328: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
3329: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type := p_rev_operation_tbl;
3330: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl;
3331: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
3332: l_return_value NUMBER;
3333: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3334:
3335: --10dec

Line 3841: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL

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

Line 3842: , p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL

3838: , p_unexp_eco_rev_rec IN ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type := NULL
3839: , p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL
3840: , p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL
3841: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL
3842: , p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL
3843: , p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL
3844: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
3845: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3846: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=

Line 3843: , p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL

3839: , p_unexp_sub_comp_rec IN BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type := NULL
3840: , p_unexp_ref_desg_rec IN BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type := NULL
3841: , p_unexp_rev_op_rec IN BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type := NULL
3842: , p_unexp_rev_op_res_rec IN BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type := NULL
3843: , p_unexp_rev_sub_res_rec IN BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type := NULL
3844: , p_eco_revision_tbl IN ENG_Eco_PUB.Eco_Revision_Tbl_Type :=
3845: ENG_Eco_PUB.G_MISS_ECO_REVISION_TBL
3846: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type :=
3847: ENG_Eco_PUB.G_MISS_REVISED_ITEM_TBL

Line 3854: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=

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

Line 3855: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL

3851: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
3852: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3853: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
3854: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=
3855: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL
3856: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=
3857: BOM_RTG_PUB.G_MISS_REV_OP_RESOURCE_TBL
3858: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3859: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL

Line 3856: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=

3852: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
3853: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
3854: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=
3855: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL
3856: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=
3857: BOM_RTG_PUB.G_MISS_REV_OP_RESOURCE_TBL
3858: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3859: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3860: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec

Line 3857: BOM_RTG_PUB.G_MISS_REV_OP_RESOURCE_TBL

3853: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
3854: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=
3855: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL
3856: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=
3857: BOM_RTG_PUB.G_MISS_REV_OP_RESOURCE_TBL
3858: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3859: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3860: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
3861: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type

Line 3858: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=

3854: , p_rev_operation_tbl IN BOM_RTG_PUB.Rev_Operation_Tbl_Type:=
3855: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL
3856: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=
3857: BOM_RTG_PUB.G_MISS_REV_OP_RESOURCE_TBL
3858: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3859: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3860: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
3861: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3862: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type

Line 3859: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL

3855: BOM_RTG_PUB.G_MISS_REV_OPERATION_TBL
3856: , p_rev_op_resource_tbl IN BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type :=
3857: BOM_RTG_PUB.G_MISS_REV_OP_RESOURCE_TBL
3858: , p_rev_sub_resource_tbl IN BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type:=
3859: BOM_RTG_PUB.G_MISS_REV_SUB_RESOURCE_TBL
3860: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type --ECO 10dec
3861: , x_unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.ECO_Unexposed_Rec_Type
3862: , x_unexp_eco_rev_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rev_Unexposed_Rec_Type
3863: , x_unexp_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type

Line 3867: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type

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

Line 3868: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type

3864: , x_unexp_rev_comp_rec IN OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
3865: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
3866: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
3867: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
3868: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
3869: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
3870: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3871: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3872: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 3869: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type

3865: , x_unexp_sub_comp_rec IN OUT NOCOPY BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type
3866: , x_unexp_ref_desg_rec IN OUT NOCOPY BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type
3867: , x_unexp_rev_op_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type
3868: , x_unexp_rev_op_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type
3869: , x_unexp_rev_sub_res_rec IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type
3870: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
3871: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
3872: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3873: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 3875: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Operation_Tbl_Type

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

Line 3876: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type

3872: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
3873: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3874: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3875: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Operation_Tbl_Type
3876: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
3877: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
3878: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
3879: )
3880: IS

Line 3877: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type

3873: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
3874: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
3875: , x_rev_operation_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Operation_Tbl_Type
3876: , x_rev_op_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type
3877: , x_rev_sub_resource_tbl IN OUT NOCOPY BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type
3878: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
3879: )
3880: IS
3881: l_api_name CONSTANT VARCHAR2(30):= 'Process_Eco';

Line 3900: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

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

Line 3901: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

3897: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
3898: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3899: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
3900: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
3901: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
3902: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
3903: l_rev_operation_rec BOM_RTG_PUB.Rev_Operation_Rec_Type; --add
3904: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3905: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add

Line 3902: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

3898: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
3899: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
3900: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
3901: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
3902: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
3903: l_rev_operation_rec BOM_RTG_PUB.Rev_Operation_Rec_Type; --add
3904: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3905: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3906:

Line 3903: l_rev_operation_rec BOM_RTG_PUB.Rev_Operation_Rec_Type; --add

3899: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
3900: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
3901: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
3902: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
3903: l_rev_operation_rec BOM_RTG_PUB.Rev_Operation_Rec_Type; --add
3904: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3905: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3906:
3907: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 3904: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add

3900: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
3901: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
3902: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
3903: l_rev_operation_rec BOM_RTG_PUB.Rev_Operation_Rec_Type; --add
3904: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3905: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3906:
3907: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3908: l_other_message VARCHAR2(2000);

Line 3905: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add

3901: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
3902: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
3903: l_rev_operation_rec BOM_RTG_PUB.Rev_Operation_Rec_Type; --add
3904: l_rev_op_resource_rec BOM_RTG_PUB.Rev_Op_Resource_Rec_Type; --add
3905: l_rev_sub_resource_rec BOM_RTG_PUB.Rev_Sub_Resource_Rec_Type; --add
3906:
3907: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3908: l_other_message VARCHAR2(2000);
3909: l_other_token_tbl Error_Handler.Token_Tbl_Type;