APPS.CMP_CONTROLLER dependencies on BOM_BO_PUB

Line 8: , x_CMP_tbl OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

4: -- Procedure Create_Exp_Unexp_Rec
5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_CMP_rec IN Controller_CMP_Rec_Type
8: , x_CMP_tbl OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
9: , x_unexp_CMP_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN

Line 9: , x_unexp_CMP_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type

5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_CMP_rec IN Controller_CMP_Rec_Type
8: , x_CMP_tbl OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
9: , x_unexp_CMP_rec OUT NOCOPY BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN
13: -- Create exposed record

Line 89: ( p_CMP_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type

85:
86: END Create_Exp_Unexp_Rec;
87:
88: PROCEDURE Create_Controller_Rec
89: ( p_CMP_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
90: , p_unexp_CMP_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
91: , x_controller_CMP_rec OUT NOCOPY Controller_CMP_Rec_Type
92: )
93: IS

Line 90: , p_unexp_CMP_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type

86: END Create_Exp_Unexp_Rec;
87:
88: PROCEDURE Create_Controller_Rec
89: ( p_CMP_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
90: , p_unexp_CMP_rec IN BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type
91: , x_controller_CMP_rec OUT NOCOPY Controller_CMP_Rec_Type
92: )
93: IS
94: BEGIN

Line 172: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

168: -- Procedure Initialize_Record
169:
170: PROCEDURE Initialize_Record
171: ( p_CMP_controller_rec IN Controller_CMP_Rec_Type
172: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
173: , x_CMP_controller_rec IN OUT NOCOPY Controller_CMP_Rec_Type
174: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
175: , x_return_status OUT NOCOPY VARCHAR2
176: )

Line 178: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

174: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
175: , x_return_status OUT NOCOPY VARCHAR2
176: )
177: IS
178: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
179: l_CMP_controller_rec Controller_CMP_Rec_Type := p_CMP_controller_rec;
180: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
181: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
182: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 184: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

180: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
181: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
182: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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

Line 185: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

181: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
182: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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

Line 186: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

182: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;

Line 192: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

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

Line 193: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

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

Line 194: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

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

Line 252: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

248: -- Procedure Validate_And_Write
249:
250: PROCEDURE Validate_And_Write
251: ( p_CMP_controller_rec IN Controller_CMP_Rec_Type
252: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
253: , p_record_status IN VARCHAR2
254: , x_CMP_controller_rec IN OUT NOCOPY Controller_CMP_Rec_Type
255: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
256: , x_return_status OUT NOCOPY VARCHAR2

Line 259: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

255: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
256: , x_return_status OUT NOCOPY VARCHAR2
257: )
258: IS
259: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
260: l_CMP_controller_rec Controller_CMP_Rec_Type := p_CMP_controller_rec;
261: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
262: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
263: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 265: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

261: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
262: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
263: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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

Line 266: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

262: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
263: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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

Line 267: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

263: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;

Line 273: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

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

Line 274: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

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

Line 275: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

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

Line 344: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

340: -- Procedure Delete_Row
341:
342: PROCEDURE Delete_Row
343: ( p_CMP_controller_rec IN Controller_CMP_Rec_Type
344: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
345: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
346: , x_return_status OUT NOCOPY VARCHAR2
347: )
348: IS

Line 349: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

345: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
346: , x_return_status OUT NOCOPY VARCHAR2
347: )
348: IS
349: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
350: l_CMP_controller_rec Controller_CMP_Rec_Type := p_CMP_controller_rec;
351: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
352: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
353: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 355: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

351: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
352: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
353: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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

Line 356: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

352: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
353: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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

Line 357: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

353: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;

Line 363: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

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

Line 364: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

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

Line 365: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

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

Line 425: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

421: --Procedure Change_Attibute
422:
423: PROCEDURE Change_Attribute
424: ( p_CMP_controller_rec IN Controller_CMP_Rec_Type
425: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
426: , p_record_status IN VARCHAR2
427: , x_CMP_controller_rec IN OUT NOCOPY Controller_CMP_Rec_Type
428: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
429: , x_return_status OUT NOCOPY VARCHAR2

Line 432: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

428: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
429: , x_return_status OUT NOCOPY VARCHAR2
430: )
431: IS
432: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
433: l_CMP_controller_rec Controller_CMP_Rec_Type := p_CMP_controller_rec;
434: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
435: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
436: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 438: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

434: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
435: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
436: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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

Line 439: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

435: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
436: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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

Line 440: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

436: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;

Line 446: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

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

Line 447: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

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

Line 448: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

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