APPS.BOM_SUB_OP_RES_UTIL dependencies on BOM_RTG_PUB

Line 48: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type

44: , p_replacement_group_number IN NUMBER --bug 2489765
45: , p_basis_type IN NUMBER
46: , p_schedule_flag IN NUMBER /* Added for bug 13005178 */
47: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
48: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
49: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
50: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
51: , x_return_status IN OUT NOCOPY VARCHAR2
52: )

Line 49: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

45: , p_basis_type IN NUMBER
46: , p_schedule_flag IN NUMBER /* Added for bug 13005178 */
47: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
48: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
49: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
50: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
51: , x_return_status IN OUT NOCOPY VARCHAR2
52: )
53:

Line 56: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

52: )
53:
54: IS
55:
56: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
57: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
58:
59: BEGIN
60:

Line 57: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;

53:
54: IS
55:
56: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
57: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
58:
59: BEGIN
60:
61: x_mesg_token_tbl := p_mesg_token_tbl;

Line 80: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes

76: ) ;
77:
78: -- Convert the ECO record to Routing Record
79:
80: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes
81: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
82: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
83: , x_rtg_sub_resource_rec => x_sub_resource_rec
84: , x_rtg_sub_res_unexp_rec => x_sub_res_unexp_rec

Line 112: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

108: , p_replacement_group_number IN NUMBER --bug 2489765
109: , p_basis_type IN NUMBER
110: , p_schedule_flag IN NUMBER /* Added for bug 13005178 */
111: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
112: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
113: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
114: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
115: , x_return_status IN OUT NOCOPY VARCHAR2
116: )

Line 113: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

109: , p_basis_type IN NUMBER
110: , p_schedule_flag IN NUMBER /* Added for bug 13005178 */
111: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
112: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
113: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
114: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
115: , x_return_status IN OUT NOCOPY VARCHAR2
116: )
117: IS

Line 121: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

117: IS
118:
119:
120: /* Define Variable */
121: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
122: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
123: l_err_text VARCHAR2(2000) ;
124: l_bo_id VARCHAR2(3) ;
125: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type ;

Line 122: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;

118:
119:
120: /* Define Variable */
121: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
122: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
123: l_err_text VARCHAR2(2000) ;
124: l_bo_id VARCHAR2(3) ;
125: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type ;
126:

Line 286: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type

282: * Sub Operation Resources table.
283: *********************************************************************/
284:
285: PROCEDURE Perform_Writes
286: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
287: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
288: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
289: , x_return_status IN OUT NOCOPY VARCHAR2
290: )

Line 287: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

283: *********************************************************************/
284:
285: PROCEDURE Perform_Writes
286: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
287: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
288: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
289: , x_return_status IN OUT NOCOPY VARCHAR2
290: )
291: IS

Line 292: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

288: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
289: , x_return_status IN OUT NOCOPY VARCHAR2
290: )
291: IS
292: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
293: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
294:
295: BEGIN
296: -- Convert Routing Operation to Common Operation

Line 293: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

289: , x_return_status IN OUT NOCOPY VARCHAR2
290: )
291: IS
292: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
293: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
294:
295: BEGIN
296: -- Convert Routing Operation to Common Operation
297: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

Line 297: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

293: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
294:
295: BEGIN
296: -- Convert Routing Operation to Common Operation
297: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes
298: ( p_rtg_sub_resource_rec => p_sub_resource_rec
299: , p_rtg_sub_res_unexp_rec => p_sub_res_unexp_rec
300: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
301: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec

Line 308: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC

304: -- Call Perform Writes Procedure
305: Bom_Sub_Op_Res_UTIL.Perform_Writes
306: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
307: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
308: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC
309: , x_mesg_token_tbl => x_mesg_token_tbl
310: , x_return_status => x_return_status
311: ) ;
312:

Line 328: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

324: * user has to perform any insert/update/deletes to the
325: * Operation Resources table.
326: *********************************************************************/
327: PROCEDURE Perform_Writes
328: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
329: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
330: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
331: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
332: , x_return_status IN OUT NOCOPY VARCHAR2

Line 329: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

325: * Operation Resources table.
326: *********************************************************************/
327: PROCEDURE Perform_Writes
328: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
329: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
330: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
331: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
332: , x_return_status IN OUT NOCOPY VARCHAR2
333: )

Line 330: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type

326: *********************************************************************/
327: PROCEDURE Perform_Writes
328: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
329: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
330: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
331: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
332: , x_return_status IN OUT NOCOPY VARCHAR2
333: )
334: IS

Line 336: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

332: , x_return_status IN OUT NOCOPY VARCHAR2
333: )
334: IS
335:
336: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
337: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
338:
339:
340: -- Error Handlig Variables

Line 337: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

333: )
334: IS
335:
336: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
337: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
338:
339:
340: -- Error Handlig Variables
341: l_return_status VARCHAR2(1);

Line 444: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

440: * table; BOM_SUB_OPERATION_RESOURCES
441: *
442: *****************************************************************************/
443: PROCEDURE Insert_Row
444: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
445: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
446: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
447: , x_return_status IN OUT NOCOPY VARCHAR2
448: )

Line 445: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

441: *
442: *****************************************************************************/
443: PROCEDURE Insert_Row
444: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
445: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
446: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
447: , x_return_status IN OUT NOCOPY VARCHAR2
448: )
449: IS

Line 593: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

589: * the user given values. Any errors will be returned by filling
590: * the Mesg_Token_Tbl and setting the return_status.
591: ****************************************************************************/
592: PROCEDURE Update_Row
593: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
594: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
595: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
596: , x_return_status IN OUT NOCOPY VARCHAR2
597: )

Line 594: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

590: * the Mesg_Token_Tbl and setting the return_status.
591: ****************************************************************************/
592: PROCEDURE Update_Row
593: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
594: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
595: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
596: , x_return_status IN OUT NOCOPY VARCHAR2
597: )
598: IS

Line 700: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

696: * the Mesg_Token_Tbl and setting the return_status.
697: *
698: *********************************************************************/
699: PROCEDURE Delete_Row
700: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
701: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
702: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
703: , x_return_status IN OUT NOCOPY VARCHAR2
704: )

Line 701: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

697: *
698: *********************************************************************/
699: PROCEDURE Delete_Row
700: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
701: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
702: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
703: , x_return_status IN OUT NOCOPY VARCHAR2
704: )
705: IS