APPS.BOM_SUB_OP_RES_UTIL dependencies on BOM_RTG_PUB

Line 47: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type

43: , p_acd_type IN NUMBER
44: , p_replacement_group_number IN NUMBER --bug 2489765
45: , p_basis_type IN NUMBER
46: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
47: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
48: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
49: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
50: , x_return_status IN OUT NOCOPY VARCHAR2
51: )

Line 48: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

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

Line 55: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

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

Line 56: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;

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

Line 78: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes

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

Line 109: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

105: , p_acd_type IN NUMBER
106: , p_replacement_group_number IN NUMBER --bug 2489765
107: , p_basis_type IN NUMBER
108: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
109: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
110: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
111: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
112: , x_return_status IN OUT NOCOPY VARCHAR2
113: )

Line 110: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

106: , p_replacement_group_number IN NUMBER --bug 2489765
107: , p_basis_type IN NUMBER
108: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
109: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
110: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
111: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
112: , x_return_status IN OUT NOCOPY VARCHAR2
113: )
114: IS

Line 118: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

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

Line 119: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;

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

Line 280: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type

276: * Sub Operation Resources table.
277: *********************************************************************/
278:
279: PROCEDURE Perform_Writes
280: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
281: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
282: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
283: , x_return_status IN OUT NOCOPY VARCHAR2
284: )

Line 281: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

277: *********************************************************************/
278:
279: PROCEDURE Perform_Writes
280: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
281: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
282: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
283: , x_return_status IN OUT NOCOPY VARCHAR2
284: )
285: IS

Line 286: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

282: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
283: , x_return_status IN OUT NOCOPY VARCHAR2
284: )
285: IS
286: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
287: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
288:
289: BEGIN
290: -- Convert Routing Operation to Common Operation

Line 287: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

283: , x_return_status IN OUT NOCOPY VARCHAR2
284: )
285: IS
286: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
287: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
288:
289: BEGIN
290: -- Convert Routing Operation to Common Operation
291: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

Line 291: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

287: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
288:
289: BEGIN
290: -- Convert Routing Operation to Common Operation
291: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes
292: ( p_rtg_sub_resource_rec => p_sub_resource_rec
293: , p_rtg_sub_res_unexp_rec => p_sub_res_unexp_rec
294: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
295: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec

Line 302: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC

298: -- Call Perform Writes Procedure
299: Bom_Sub_Op_Res_UTIL.Perform_Writes
300: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
301: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
302: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC
303: , x_mesg_token_tbl => x_mesg_token_tbl
304: , x_return_status => x_return_status
305: ) ;
306:

Line 322: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

318: * user has to perform any insert/update/deletes to the
319: * Operation Resources table.
320: *********************************************************************/
321: PROCEDURE Perform_Writes
322: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
323: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
324: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
325: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
326: , x_return_status IN OUT NOCOPY VARCHAR2

Line 323: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

319: * Operation Resources table.
320: *********************************************************************/
321: PROCEDURE Perform_Writes
322: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
323: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
324: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
325: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
326: , x_return_status IN OUT NOCOPY VARCHAR2
327: )

Line 324: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type

320: *********************************************************************/
321: PROCEDURE Perform_Writes
322: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
323: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
324: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
325: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
326: , x_return_status IN OUT NOCOPY VARCHAR2
327: )
328: IS

Line 330: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

326: , x_return_status IN OUT NOCOPY VARCHAR2
327: )
328: IS
329:
330: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
331: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
332:
333:
334: -- Error Handlig Variables

Line 331: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

327: )
328: IS
329:
330: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
331: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
332:
333:
334: -- Error Handlig Variables
335: l_return_status VARCHAR2(1);

Line 438: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

434: * table; BOM_SUB_OPERATION_RESOURCES
435: *
436: *****************************************************************************/
437: PROCEDURE Insert_Row
438: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
439: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
440: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
441: , x_return_status IN OUT NOCOPY VARCHAR2
442: )

Line 439: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

435: *
436: *****************************************************************************/
437: PROCEDURE Insert_Row
438: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
439: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
440: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
441: , x_return_status IN OUT NOCOPY VARCHAR2
442: )
443: IS

Line 587: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

583: * the user given values. Any errors will be returned by filling
584: * the Mesg_Token_Tbl and setting the return_status.
585: ****************************************************************************/
586: PROCEDURE Update_Row
587: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
588: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
589: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
590: , x_return_status IN OUT NOCOPY VARCHAR2
591: )

Line 588: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

584: * the Mesg_Token_Tbl and setting the return_status.
585: ****************************************************************************/
586: PROCEDURE Update_Row
587: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
588: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
589: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
590: , x_return_status IN OUT NOCOPY VARCHAR2
591: )
592: IS

Line 693: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

689: * the Mesg_Token_Tbl and setting the return_status.
690: *
691: *********************************************************************/
692: PROCEDURE Delete_Row
693: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
694: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
695: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
696: , x_return_status IN OUT NOCOPY VARCHAR2
697: )

Line 694: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

690: *
691: *********************************************************************/
692: PROCEDURE Delete_Row
693: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
694: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
695: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
696: , x_return_status IN OUT NOCOPY VARCHAR2
697: )
698: IS