APPS.BOM_OP_RES_UTIL dependencies on BOM_RTG_PUB

Line 45: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type

41: ( p_resource_sequence_number IN NUMBER
42: , p_operation_sequence_id IN NUMBER
43: , p_acd_type IN NUMBER
44: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
45: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
46: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
47: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
48: , x_return_status IN OUT NOCOPY VARCHAR2
49: )

Line 46: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

42: , p_operation_sequence_id IN NUMBER
43: , p_acd_type IN NUMBER
44: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
45: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
46: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
47: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
48: , x_return_status IN OUT NOCOPY VARCHAR2
49: )
50:

Line 53: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

49: )
50:
51: IS
52:
53: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
54: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type;
55:
56: BEGIN
57:

Line 54: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type;

50:
51: IS
52:
53: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
54: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type;
55:
56: BEGIN
57:
58: x_mesg_token_tbl := p_mesg_token_tbl;

Line 73: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes

69: ) ;
70:
71: -- Convert the ECO record to Routing Record
72:
73: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes
74: ( p_rev_op_resource_rec => l_rev_op_resource_rec
75: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
76: , x_rtg_op_resource_rec => x_op_resource_rec
77: , x_rtg_op_res_unexp_rec => x_op_res_unexp_rec

Line 101: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

97: ( p_resource_sequence_number IN NUMBER
98: , p_operation_sequence_id IN NUMBER
99: , p_acd_type IN NUMBER
100: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
101: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
102: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
103: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
104: , x_return_status IN OUT NOCOPY VARCHAR2
105: )

Line 102: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

98: , p_operation_sequence_id IN NUMBER
99: , p_acd_type IN NUMBER
100: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
101: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
102: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
103: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
104: , x_return_status IN OUT NOCOPY VARCHAR2
105: )
106: IS

Line 110: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

106: IS
107:
108:
109: /* Define Variable */
110: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
111: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type;
112: l_err_text VARCHAR2(2000) ;
113: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type ;
114: l_bo_id VARCHAR2(3) ;

Line 111: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type;

107:
108:
109: /* Define Variable */
110: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
111: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type;
112: l_err_text VARCHAR2(2000) ;
113: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type ;
114: l_bo_id VARCHAR2(3) ;
115: l_operation_sequence_id NUMBER := p_operation_sequence_id ;

Line 280: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type

276: * Operation Resources table.
277: *********************************************************************/
278:
279: PROCEDURE Perform_Writes
280: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
281: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_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_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

277: *********************************************************************/
278:
279: PROCEDURE Perform_Writes
280: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
281: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_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_op_resource_rec Bom_Rtg_Pub.Rev_Op_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_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
287: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
288:
289: BEGIN
290: -- Convert Routing Operation to Common Operation

Line 287: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

283: , x_return_status IN OUT NOCOPY VARCHAR2
284: )
285: IS
286: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
287: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
288:
289: BEGIN
290: -- Convert Routing Operation to Common Operation
291: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes

Line 291: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes

287: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
288:
289: BEGIN
290: -- Convert Routing Operation to Common Operation
291: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes
292: ( p_rtg_op_resource_rec => p_op_resource_rec
293: , p_rtg_op_res_unexp_rec => p_op_res_unexp_rec
294: , x_rev_op_resource_rec => l_rev_op_resource_rec
295: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec

Line 302: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC

298: -- Call Perform Writes Procedure
299: Bom_Op_Res_UTIL.Perform_Writes
300: ( p_rev_op_resource_rec => l_rev_op_resource_rec
301: , p_rev_op_res_unexp_rec => l_rev_op_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_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_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_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
323: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_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_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

319: * Operation Resources table.
320: *********************************************************************/
321: PROCEDURE Perform_Writes
322: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
323: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_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_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
323: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_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_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

326: , x_return_status IN OUT NOCOPY VARCHAR2
327: )
328: IS
329:
330: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
331: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
332:
333:
334: -- Error Handlig Variables

Line 331: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

327: )
328: IS
329:
330: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
331: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
332:
333:
334: -- Error Handlig Variables
335: l_return_status VARCHAR2(1);

Line 438: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

434: * table; BOM_OPERATION_RESOURCES
435: *
436: *****************************************************************************/
437: PROCEDURE Insert_Row
438: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
439: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_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_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

435: *
436: *****************************************************************************/
437: PROCEDURE Insert_Row
438: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
439: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_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_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_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_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
588: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_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_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

584: * the Mesg_Token_Tbl and setting the return_status.
585: ****************************************************************************/
586: PROCEDURE Update_Row
587: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
588: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_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 689: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

685: * the Mesg_Token_Tbl and setting the return_status.
686: *
687: *********************************************************************/
688: PROCEDURE Delete_Row
689: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
690: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
691: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
692: , x_return_status IN OUT NOCOPY VARCHAR2
693: )

Line 690: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

686: *
687: *********************************************************************/
688: PROCEDURE Delete_Row
689: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
690: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
691: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
692: , x_return_status IN OUT NOCOPY VARCHAR2
693: )
694: IS