DBA Data[Home] [Help]

APPS.SBC_CONTROLLER dependencies on BOM_RTG_PUB

Line 119: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

115: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
116: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
117: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
118: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
119: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
120: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
121: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
122: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
123: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 120: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

116: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
117: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
118: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
119: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
120: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
121: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
122: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
123: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
124: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 121: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

117: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
118: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
119: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
120: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
121: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
122: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
123: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
124: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
125: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 127: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

123: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
124: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
125: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
126: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
127: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
128: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
129: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
130:
131: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 128: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

124: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
125: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
126: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
127: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
128: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
129: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
130:
131: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
132: l_return_status VARCHAR2(1);

Line 129: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

125: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
126: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
127: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
128: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
129: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
130:
131: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
132: l_return_status VARCHAR2(1);
133: l_msg_count NUMBER;

Line 201: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

197: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
198: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
199: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
200: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
201: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
202: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
203: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
204: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
205: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 202: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

198: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
199: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
200: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
201: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
202: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
203: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
204: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
205: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
206: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 203: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

199: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
200: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
201: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
202: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
203: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
204: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
205: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
206: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
207: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 209: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

205: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
206: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
207: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
208: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
209: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
210: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
211: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
212:
213: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 210: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

206: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
207: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
208: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
209: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
210: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
211: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
212:
213: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
214: l_return_status VARCHAR2(1);

Line 211: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

207: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
208: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
209: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
210: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
211: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
212:
213: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
214: l_return_status VARCHAR2(1);
215: l_msg_count NUMBER;

Line 291: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

287: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
288: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
289: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
290: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
291: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
292: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
293: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
294: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
295: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 292: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

288: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
289: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
290: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
291: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
292: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
293: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
294: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
295: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
296: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 293: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

289: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
290: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
291: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
292: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
293: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
294: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
295: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
296: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
297: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 299: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

295: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
296: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
297: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
298: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
299: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
300: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
301: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
302:
303: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 300: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

296: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
297: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
298: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
299: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
300: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
301: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
302:
303: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
304: l_return_status VARCHAR2(1);

Line 301: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

297: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
298: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
299: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
300: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
301: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
302:
303: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
304: l_return_status VARCHAR2(1);
305: l_msg_count NUMBER;

Line 372: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add

368: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
369: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
370: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
371: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
372: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
373: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
374: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
375: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
376: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

Line 373: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

369: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
370: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
371: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
372: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
373: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
374: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
375: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
376: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
377: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

Line 374: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

370: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
371: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
372: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
373: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
374: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
375: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
376: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
377: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
378: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

Line 380: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add

376: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
377: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
378: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
379: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
380: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
381: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
382: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
383:
384: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 381: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

377: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
378: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
379: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
380: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
381: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
382: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
383:
384: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
385: l_return_status VARCHAR2(1);

Line 382: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

378: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
379: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
380: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
381: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
382: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
383:
384: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
385: l_return_status VARCHAR2(1);
386: l_msg_count NUMBER;