DBA Data[Home] [Help]

APPS.CMP_CONTROLLER dependencies on BOM_RTG_PUB

Line 187: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

183: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
184: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
185: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
186: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
187: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
188: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
189: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
190: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
191: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 188: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

184: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
185: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
186: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
187: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
188: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
189: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
190: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
191: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
192: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 189: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

185: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
186: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
187: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
188: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
189: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
190: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
191: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
192: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
193: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 195: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

191: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
192: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
193: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
194: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
195: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
196: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
197: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
198: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
199: l_return_status VARCHAR2(1);

Line 196: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

192: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
193: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
194: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
195: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
196: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
197: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
198: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
199: l_return_status VARCHAR2(1);
200: l_msg_count NUMBER;

Line 197: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

193: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
194: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
195: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
196: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
197: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
198: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
199: l_return_status VARCHAR2(1);
200: l_msg_count NUMBER;
201: l_disable_revision NUMBER:=2; --BUG 3034642

Line 268: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

264: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
265: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
266: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
267: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
268: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
269: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
270: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
271: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
272: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 269: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

265: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
266: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
267: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
268: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
269: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
270: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
271: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
272: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
273: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 270: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

266: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
267: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
268: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
269: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
270: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
271: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
272: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
273: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
274: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 276: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

272: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
273: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
274: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
275: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
276: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
277: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
278: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
279:
280: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 277: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

273: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
274: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
275: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
276: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
277: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
278: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
279:
280: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
281: l_return_status VARCHAR2(1);

Line 278: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

274: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
275: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
276: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
277: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
278: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
279:
280: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
281: l_return_status VARCHAR2(1);
282: l_msg_count NUMBER;

Line 358: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

354: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
355: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
356: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
357: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
358: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
359: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
360: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
361: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
362: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 359: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

355: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
356: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
357: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
358: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
359: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
360: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
361: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
362: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
363: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 360: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

356: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
357: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
358: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
359: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
360: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
361: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
362: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
363: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
364: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 366: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

362: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
363: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
364: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
365: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
366: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
367: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
368: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
369:
370:

Line 367: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

363: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
364: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
365: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
366: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
367: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
368: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
369:
370:
371:

Line 368: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

364: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
365: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
366: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
367: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
368: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
369:
370:
371:
372: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 441: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

437: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
438: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
439: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
440: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
441: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
442: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
443: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
444: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
445: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 442: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

438: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
439: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
440: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
441: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
442: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
443: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
444: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
445: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
446: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 443: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

439: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
440: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
441: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
442: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
443: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
444: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
445: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
446: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
447: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 449: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

445: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
446: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
447: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
448: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
449: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
450: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
451: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
452:
453:

Line 450: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

446: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
447: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
448: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
449: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
450: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
451: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
452:
453:
454: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 451: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

447: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
448: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
449: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
450: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
451: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
452:
453:
454: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
455: l_return_status VARCHAR2(1);