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.OE_LINE_ADJ_ASSOCS_UTIL dependencies on OE_ORDER_PUB

Line 8: , x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Line_Adj_Assocs_util';
5:
6: PROCEDURE Query_Row
7: ( p_price_adj_Assoc_id IN NUMBER
8: , x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
9: )
10: IS
11:
12: l_Line_Adj_Assoc_Tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 12: l_Line_Adj_Assoc_Tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

8: , x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
9: )
10: IS
11:
12: l_Line_Adj_Assoc_Tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
13:
14: --
15: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
16: --

Line 33: , x_Line_Adj_Assoc_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type

29: ( p_price_adj_Assoc_id IN NUMBER :=
30: FND_API.G_MISS_NUM
31: , p_price_adjustment_id IN NUMBER :=
32: FND_API.G_MISS_NUM
33: , x_Line_Adj_Assoc_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
34: )
35: IS
36: l_count NUMBER;
37:

Line 122: ( p_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type

118:
119: END Query_Rows;
120:
121: PROCEDURE Insert_Row
122: ( p_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
123: )
124: IS
125: l_lock_control NUMBER := 1;
126:

Line 183: ( p_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type

179:
180: END Insert_Row;
181:
182: PROCEDURE Update_Row
183: ( p_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
184: )
185: IS
186: l_lock_control NUMBER;
187:

Line 275: ( p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type

271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END Delete_Row;
273:
274: PROCEDURE Complete_Record
275: ( p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
276: , p_old_Line_Adj_Assoc_Rec IN OE_Order_PUB.Line_Adj_Assoc_Rec_Type
277: )
278: IS
279:

Line 276: , p_old_Line_Adj_Assoc_Rec IN OE_Order_PUB.Line_Adj_Assoc_Rec_Type

272: END Delete_Row;
273:
274: PROCEDURE Complete_Record
275: ( p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
276: , p_old_Line_Adj_Assoc_Rec IN OE_Order_PUB.Line_Adj_Assoc_Rec_Type
277: )
278: IS
279:
280: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type := p_x_Line_Adj_Assoc_Rec;

Line 280: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type := p_x_Line_Adj_Assoc_Rec;

276: , p_old_Line_Adj_Assoc_Rec IN OE_Order_PUB.Line_Adj_Assoc_Rec_Type
277: )
278: IS
279:
280: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type := p_x_Line_Adj_Assoc_Rec;
281: --
282: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
283: --
284: BEGIN

Line 345: ( p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type

341:
342: END Complete_Record;
343:
344: PROCEDURE Convert_Miss_To_Null
345: ( p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
346: )
347: IS
348: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type := p_x_Line_Adj_Assoc_Rec;
349: --

Line 348: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type := p_x_Line_Adj_Assoc_Rec;

344: PROCEDURE Convert_Miss_To_Null
345: ( p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
346: )
347: IS
348: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type := p_x_Line_Adj_Assoc_Rec;
349: --
350: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
351: --
352: BEGIN

Line 412: ( p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type

408:
409: END Convert_Miss_To_Null;
410:
411: PROCEDURE Apply_Attribute_Changes
412: ( p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
413: , p_old_Line_Adj_Assoc_Rec IN OE_Order_PUB.Line_Adj_Assoc_Rec_Type := OE_Order_PUB.G_MISS_Line_Adj_Assoc_Rec
414: -- , x_Line_Adj_Assoc_Rec OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type
415: )
416: IS

Line 413: , p_old_Line_Adj_Assoc_Rec IN OE_Order_PUB.Line_Adj_Assoc_Rec_Type := OE_Order_PUB.G_MISS_Line_Adj_Assoc_Rec

409: END Convert_Miss_To_Null;
410:
411: PROCEDURE Apply_Attribute_Changes
412: ( p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
413: , p_old_Line_Adj_Assoc_Rec IN OE_Order_PUB.Line_Adj_Assoc_Rec_Type := OE_Order_PUB.G_MISS_Line_Adj_Assoc_Rec
414: -- , x_Line_Adj_Assoc_Rec OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type
415: )
416: IS
417:

Line 414: -- , x_Line_Adj_Assoc_Rec OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type

410:
411: PROCEDURE Apply_Attribute_Changes
412: ( p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
413: , p_old_Line_Adj_Assoc_Rec IN OE_Order_PUB.Line_Adj_Assoc_Rec_Type := OE_Order_PUB.G_MISS_Line_Adj_Assoc_Rec
414: -- , x_Line_Adj_Assoc_Rec OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type
415: )
416: IS
417:
418: --

Line 430: , p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type

426:
427: PROCEDURE Lock_Row
428: ( x_return_status OUT NOCOPY VARCHAR2
429:
430: , p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
431: , p_price_adj_assoc_id IN NUMBER := FND_API.G_MISS_NUM
432: -- , x_Line_Adj_Assoc_Rec OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type
433: )
434: is

Line 432: -- , x_Line_Adj_Assoc_Rec OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type

428: ( x_return_status OUT NOCOPY VARCHAR2
429:
430: , p_x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
431: , p_price_adj_assoc_id IN NUMBER := FND_API.G_MISS_NUM
432: -- , x_Line_Adj_Assoc_Rec OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type
433: )
434: is
435: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;
436: l_lock_control NUMBER;

Line 435: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;

431: , p_price_adj_assoc_id IN NUMBER := FND_API.G_MISS_NUM
432: -- , x_Line_Adj_Assoc_Rec OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type
433: )
434: is
435: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;
436: l_lock_control NUMBER;
437: l_price_adj_assoc_id NUMBER;
438:
439: --

Line 574: , x_Line_Adj_Assoc_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type

570: ( p_price_adj_assoc_id IN NUMBER
571: := FND_API.G_MISS_NUM
572: , p_price_adjustment_id IN NUMBER
573: := FND_API.G_MISS_NUM
574: , x_Line_Adj_Assoc_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
575: , x_return_status OUT NOCOPY VARCHAR2
576:
577: )
578: IS

Line 586: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

582: FROM oe_price_adj_assocs
583: WHERE price_adjustment_id = p_price_adjustment_id
584: FOR UPDATE NOWAIT;
585:
586: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
587: l_price_adj_assoc_id NUMBER;
588: l_lock_control NUMBER;
589:
590: --

Line 701: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type:=OE_Order_PUB.G_MISS_Line_Adj_Assoc_REC;

697: ,p_assoc_list_line_id NUMBER
698: ,x_return_status out nocopy varchar2)
699: AS
700:
701: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type:=OE_Order_PUB.G_MISS_Line_Adj_Assoc_REC;
702: l_orig_pr_adjustment_id NUMBER;
703: l_or_rltd_padj_id NUMBER;
704: l_prg_list_line_id NUMBER;
705: l_assoc_list_line_id NUMBER;