DBA Data[Home] [Help]

APPS.ECO_CONTROLLER dependencies on BOM_RTG_PUB

Line 159: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

155: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
156: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
157: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
158: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
159: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
160: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
161: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
162: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
163: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 160: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

156: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
157: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
158: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
159: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
160: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
161: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
162: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
163: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
164: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 161: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

157: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
158: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
159: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
160: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
161: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
162: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
163: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
164: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
165: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 167: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

163: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
164: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
165: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
166: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
167: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
168: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
169: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
170:
171: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 168: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

164: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
165: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
166: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
167: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
168: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
169: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
170:
171: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
172: l_return_status VARCHAR2(1);

Line 169: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

165: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
166: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
167: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
168: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
169: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
170:
171: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
172: l_return_status VARCHAR2(1);
173: l_msg_count NUMBER;

Line 241: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

237: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
238: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
239: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
240: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
241: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
242: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
243: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
244: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
245: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 242: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

238: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
239: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
240: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
241: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
242: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
243: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
244: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
245: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
246: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 243: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

239: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
240: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
241: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
242: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
243: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
244: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
245: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
246: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
247: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 249: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

245: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
246: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
247: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
248: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
249: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
250: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
251: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
252:
253: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 250: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

246: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
247: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
248: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
249: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
250: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
251: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
252:
253: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
254: l_return_status VARCHAR2(1);

Line 251: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

247: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
248: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
249: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
250: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
251: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
252:
253: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
254: l_return_status VARCHAR2(1);
255: l_msg_count NUMBER;

Line 332: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

328: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
329: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
330: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
331: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
332: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
333: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
334: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
335: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
336: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 333: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

329: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
330: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
331: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
332: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
333: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
334: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
335: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
336: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
337: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 334: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

330: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
331: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
332: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
333: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
334: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
335: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
336: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
337: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
338: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 340: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

336: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
337: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
338: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
339: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
340: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
341: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
342: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
343:
344: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 341: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

337: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
338: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
339: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
340: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
341: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
342: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
343:
344: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
345: l_return_status VARCHAR2(1);

Line 342: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

338: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
339: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
340: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
341: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
342: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
343:
344: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
345: l_return_status VARCHAR2(1);
346: l_msg_count NUMBER;

Line 411: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

407: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
408: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
409: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
410: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
411: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
412: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
413: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
414: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
415: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 412: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

408: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
409: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
410: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
411: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
412: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
413: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
414: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
415: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
416: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 413: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

409: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
410: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
411: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
412: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
413: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
414: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
415: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
416: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
417: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 419: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

415: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
416: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
417: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
418: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
419: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
420: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
421: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
422: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
423: l_return_status VARCHAR2(1);

Line 420: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

416: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
417: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
418: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
419: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
420: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
421: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
422: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
423: l_return_status VARCHAR2(1);
424: l_msg_count NUMBER;

Line 421: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

417: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
418: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
419: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
420: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
421: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
422: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
423: l_return_status VARCHAR2(1);
424: l_msg_count NUMBER;
425: l_other_message VARCHAR2(50);