eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_RTG_HEADER_UTIL dependencies on BOM_RTG_PUB

Line 41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type

37: PROCEDURE Query_Row
38: ( p_assembly_item_id IN NUMBER
39: , p_organization_id IN NUMBER
40: , p_alternate_routing_code IN VARCHAR2
41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type
42: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_unexposed_Rec_Type
43: , x_Return_status IN OUT NOCOPY VARCHAR2
44: )
45: IS

Line 42: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_unexposed_Rec_Type

38: ( p_assembly_item_id IN NUMBER
39: , p_organization_id IN NUMBER
40: , p_alternate_routing_code IN VARCHAR2
41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_Rec_Type
42: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_unexposed_Rec_Type
43: , x_Return_status IN OUT NOCOPY VARCHAR2
44: )
45: IS
46: l_rtg_header_rec Bom_Rtg_Pub.Rtg_header_Rec_Type;

Line 46: l_rtg_header_rec Bom_Rtg_Pub.Rtg_header_Rec_Type;

42: , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.rtg_header_unexposed_Rec_Type
43: , x_Return_status IN OUT NOCOPY VARCHAR2
44: )
45: IS
46: l_rtg_header_rec Bom_Rtg_Pub.Rtg_header_Rec_Type;
47: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_header_Unexposed_Rec_Type;
48: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
49: l_dummy varchar2(10);
50: BEGIN

Line 47: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_header_Unexposed_Rec_Type;

43: , x_Return_status IN OUT NOCOPY VARCHAR2
44: )
45: IS
46: l_rtg_header_rec Bom_Rtg_Pub.Rtg_header_Rec_Type;
47: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_header_Unexposed_Rec_Type;
48: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
49: l_dummy varchar2(10);
50: BEGIN
51:

Line 150: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type

146: * Purpose : Procedure will perfrom an insert into the
147: * rtg_Bill_Of_Materials table thus creating a new bill
148: *********************************************************************/
149: PROCEDURE Insert_Row
150: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
151: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
152: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
153: , x_return_Status IN OUT NOCOPY VARCHAR2
154: )

Line 151: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

147: * rtg_Bill_Of_Materials table thus creating a new bill
148: *********************************************************************/
149: PROCEDURE Insert_Row
150: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
151: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
152: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
153: , x_return_Status IN OUT NOCOPY VARCHAR2
154: )
155: IS

Line 328: ( p_RTG_header_rec IN Bom_Rtg_Pub.RTG_Header_Rec_Type

324: * Purpose : Procedure will perfrom an Update into the
325: * rtg_Bill_Of_Materials table.
326: *********************************************************************/
327: PROCEDURE Update_Row
328: ( p_RTG_header_rec IN Bom_Rtg_Pub.RTG_Header_Rec_Type
329: , p_RTG_header_unexp_rec IN Bom_Rtg_Pub.RTG_Header_Unexposed_Rec_Type
330: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
331: , x_return_Status IN OUT NOCOPY VARCHAR2
332: )

Line 329: , p_RTG_header_unexp_rec IN Bom_Rtg_Pub.RTG_Header_Unexposed_Rec_Type

325: * rtg_Bill_Of_Materials table.
326: *********************************************************************/
327: PROCEDURE Update_Row
328: ( p_RTG_header_rec IN Bom_Rtg_Pub.RTG_Header_Rec_Type
329: , p_RTG_header_unexp_rec IN Bom_Rtg_Pub.RTG_Header_Unexposed_Rec_Type
330: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
331: , x_return_Status IN OUT NOCOPY VARCHAR2
332: )
333: IS

Line 410: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type

406: * Purpose : Procedure will perfrom an Delete from the
407: * rtg_Bill_Of_Materials by creating a delete Group.
408: *********************************************************************/
409: PROCEDURE Delete_Row
410: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
411: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
412: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
413: , x_return_Status IN OUT NOCOPY VARCHAR2
414: )

Line 411: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

407: * rtg_Bill_Of_Materials by creating a delete Group.
408: *********************************************************************/
409: PROCEDURE Delete_Row
410: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
411: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
412: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
413: , x_return_Status IN OUT NOCOPY VARCHAR2
414: )
415: IS

Line 424: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type

420: FROM bom_delete_groups
421: WHERE delete_group_name = p_rtg_header_rec.delete_group_name
422: AND organization_id = p_rtg_header_unexp_rec.organization_id;
423:
424: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
425: := p_rtg_header_unexp_rec;
426: l_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type
427: := p_rtg_header_rec;
428: l_dg_sequence_id NUMBER;

Line 426: l_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type

422: AND organization_id = p_rtg_header_unexp_rec.organization_id;
423:
424: l_rtg_header_unexp_rec Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
425: := p_rtg_header_unexp_rec;
426: l_rtg_header_rec Bom_Rtg_Pub.rtg_header_Rec_Type
427: := p_rtg_header_rec;
428: l_dg_sequence_id NUMBER;
429: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
430:

Line 514: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type

510: * access to when he/she needs to perform any kind of
511: * writes to the bom_operational_routings.
512: *********************************************************************/
513: PROCEDURE Perform_Writes
514: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
515: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
516: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
517: , x_return_status IN OUT NOCOPY VARCHAR2
518: )

Line 515: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type

511: * writes to the bom_operational_routings.
512: *********************************************************************/
513: PROCEDURE Perform_Writes
514: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
515: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type
516: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
517: , x_return_status IN OUT NOCOPY VARCHAR2
518: )
519: IS