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_BOM_HEADER_UTIL dependencies on BOM_BO_PUB

Line 49: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_Rec_Type

45: PROCEDURE Query_Row
46: ( p_assembly_item_id IN NUMBER
47: , p_organization_id IN NUMBER
48: , p_alternate_bom_code IN VARCHAR2 := NULL
49: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_Rec_Type
50: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_unexposed_Rec_Type
51: , x_Return_status IN OUT NOCOPY VARCHAR2
52: )
53: IS

Line 50: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_unexposed_Rec_Type

46: ( p_assembly_item_id IN NUMBER
47: , p_organization_id IN NUMBER
48: , p_alternate_bom_code IN VARCHAR2 := NULL
49: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_Rec_Type
50: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_unexposed_Rec_Type
51: , x_Return_status IN OUT NOCOPY VARCHAR2
52: )
53: IS
54: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

Line 54: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

50: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_unexposed_Rec_Type
51: , x_Return_status IN OUT NOCOPY VARCHAR2
52: )
53: IS
54: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
55: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
56: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
57: l_dummy varchar2(10);
58: BEGIN

Line 55: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;

51: , x_Return_status IN OUT NOCOPY VARCHAR2
52: )
53: IS
54: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
55: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
56: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
57: l_dummy varchar2(10);
58: BEGIN
59: SELECT decode(p_alternate_bom_code, FND_API.G_MISS_CHAR,

Line 165: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_Rec_Type

161: PROCEDURE Query_Table_Row
162: ( p_assembly_item_id IN NUMBER
163: , p_organization_id IN NUMBER
164: , p_alternate_bom_code IN VARCHAR2 := NULL
165: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_Rec_Type
166: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_unexposed_Rec_Type
167: , x_Return_status IN OUT NOCOPY VARCHAR2
168: )
169: IS

Line 166: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_unexposed_Rec_Type

162: ( p_assembly_item_id IN NUMBER
163: , p_organization_id IN NUMBER
164: , p_alternate_bom_code IN VARCHAR2 := NULL
165: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_Rec_Type
166: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_unexposed_Rec_Type
167: , x_Return_status IN OUT NOCOPY VARCHAR2
168: )
169: IS
170: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

Line 170: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;

166: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_head_unexposed_Rec_Type
167: , x_Return_status IN OUT NOCOPY VARCHAR2
168: )
169: IS
170: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
171: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
172: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
173: l_dummy varchar2(10);
174: BEGIN

Line 171: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;

167: , x_Return_status IN OUT NOCOPY VARCHAR2
168: )
169: IS
170: l_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
171: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type;
172: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
173: l_dummy varchar2(10);
174: BEGIN
175: SELECT decode(p_alternate_bom_code, FND_API.G_MISS_CHAR,

Line 271: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type

267: * Purpose : Procedure will perfrom an insert into the
268: * BOM_Bill_Of_Materials table thus creating a new bill
269: *********************************************************************/
270: PROCEDURE Insert_Row
271: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type
272: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
273: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
274: , x_return_Status IN OUT NOCOPY VARCHAR2
275: )

Line 272: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

268: * BOM_Bill_Of_Materials table thus creating a new bill
269: *********************************************************************/
270: PROCEDURE Insert_Row
271: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type
272: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
273: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
274: , x_return_Status IN OUT NOCOPY VARCHAR2
275: )
276: IS

Line 447: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type

443: * Purpose : Procedure will perfrom an Update into the
444: * BOM_Bill_Of_Materials table.
445: *********************************************************************/
446: PROCEDURE Update_Row
447: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type
448: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
449: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
450: , x_return_Status IN OUT NOCOPY VARCHAR2
451: )

Line 448: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

444: * BOM_Bill_Of_Materials table.
445: *********************************************************************/
446: PROCEDURE Update_Row
447: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type
448: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
449: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
450: , x_return_Status IN OUT NOCOPY VARCHAR2
451: )
452: IS

Line 551: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type

547: * Purpose : Procedure will perfrom an Delete from the
548: * BOM_Bill_Of_Materials by creating a delete Group.
549: *********************************************************************/
550: PROCEDURE Delete_Row
551: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type
552: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
553: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
554: , x_return_Status IN OUT NOCOPY VARCHAR2
555: )

Line 552: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

548: * BOM_Bill_Of_Materials by creating a delete Group.
549: *********************************************************************/
550: PROCEDURE Delete_Row
551: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type
552: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
553: , x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
554: , x_return_Status IN OUT NOCOPY VARCHAR2
555: )
556: IS

Line 564: l_bom_head_unexp_rec Bom_bo_Pub.Bom_Head_Unexposed_Rec_Type :=

560: delete_type
561: FROM bom_delete_groups
562: WHERE delete_group_name = p_bom_header_rec.delete_group_name
563: AND organization_id = p_bom_head_unexp_rec.organization_id;
564: l_bom_head_unexp_rec Bom_bo_Pub.Bom_Head_Unexposed_Rec_Type :=
565: p_bom_head_unexp_rec;
566: l_bom_header_rec Bom_bo_Pub.Bom_Head_Rec_Type :=
567: p_bom_header_rec;
568: l_dg_sequence_id NUMBER;

Line 566: l_bom_header_rec Bom_bo_Pub.Bom_Head_Rec_Type :=

562: WHERE delete_group_name = p_bom_header_rec.delete_group_name
563: AND organization_id = p_bom_head_unexp_rec.organization_id;
564: l_bom_head_unexp_rec Bom_bo_Pub.Bom_Head_Unexposed_Rec_Type :=
565: p_bom_head_unexp_rec;
566: l_bom_header_rec Bom_bo_Pub.Bom_Head_Rec_Type :=
567: p_bom_header_rec;
568: l_dg_sequence_id NUMBER;
569: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
570: l_assembly_type NUMBER;

Line 648: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type

644: * access to when he/she needs to perform any kind of
645: * writes to the bom_bill_of_materials table.
646: *********************************************************************/
647: PROCEDURE Perform_Writes
648: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
649: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
650: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
651: , x_return_status IN OUT NOCOPY VARCHAR2
652: )

Line 649: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

645: * writes to the bom_bill_of_materials table.
646: *********************************************************************/
647: PROCEDURE Perform_Writes
648: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
649: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
650: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
651: , x_return_status IN OUT NOCOPY VARCHAR2
652: )
653: IS