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_HEADER_ADJ_ASSOCS_UTIL dependencies on OE_ORDER_PUB

Line 8: , x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Header_Adj_Assocs_util';
5:
6: PROCEDURE Query_Row
7: ( p_price_adj_Assoc_id IN NUMBER
8: , x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
9: )
10: IS
11:
12: l_Header_Adj_Assoc_Tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 12: l_Header_Adj_Assoc_Tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

8: , x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
9: )
10: IS
11:
12: l_Header_Adj_Assoc_Tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
13:
14: --
15: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
16: --

Line 34: , x_Header_Adj_Assoc_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type

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

Line 124: ( p_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type

120:
121: END Query_Rows;
122:
123: PROCEDURE Insert_Row
124: ( p_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
125: )
126: IS
127: l_lock_control NUMBER := 1;
128:

Line 185: ( p_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type

181:
182: END Insert_Row;
183:
184: PROCEDURE Update_Row
185: ( p_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
186: )
187: IS
188: l_lock_control NUMBER;
189:

Line 271: ( p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type

267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
268: END Delete_Row;
269:
270: PROCEDURE Complete_Record
271: ( p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
272: , p_old_Header_Adj_Assoc_Rec IN OE_Order_PUB.Header_Adj_Assoc_Rec_Type
273: )
274: IS
275:

Line 272: , p_old_Header_Adj_Assoc_Rec IN OE_Order_PUB.Header_Adj_Assoc_Rec_Type

268: END Delete_Row;
269:
270: PROCEDURE Complete_Record
271: ( p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
272: , p_old_Header_Adj_Assoc_Rec IN OE_Order_PUB.Header_Adj_Assoc_Rec_Type
273: )
274: IS
275:
276: l_Header_Adj_Assoc_Rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type := p_x_Header_Adj_Assoc_Rec;

Line 276: l_Header_Adj_Assoc_Rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type := p_x_Header_Adj_Assoc_Rec;

272: , p_old_Header_Adj_Assoc_Rec IN OE_Order_PUB.Header_Adj_Assoc_Rec_Type
273: )
274: IS
275:
276: l_Header_Adj_Assoc_Rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type := p_x_Header_Adj_Assoc_Rec;
277: --
278: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
279: --
280: BEGIN

Line 342: ( p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type

338:
339: END Complete_Record;
340:
341: PROCEDURE Convert_Miss_To_Null
342: ( p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
343: )
344: IS
345: l_Header_Adj_Assoc_Rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type := p_x_Header_Adj_Assoc_Rec;
346: --

Line 345: l_Header_Adj_Assoc_Rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type := p_x_Header_Adj_Assoc_Rec;

341: PROCEDURE Convert_Miss_To_Null
342: ( p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
343: )
344: IS
345: l_Header_Adj_Assoc_Rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type := p_x_Header_Adj_Assoc_Rec;
346: --
347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
348: --
349: BEGIN

Line 408: ( p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type

404:
405: END Convert_Miss_To_Null;
406:
407: PROCEDURE Apply_Attribute_Changes
408: ( p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
409: , p_old_Header_Adj_Assoc_Rec IN OE_Order_PUB.Header_Adj_Assoc_Rec_Type := OE_Order_PUB.G_MISS_Header_Adj_Assoc_Rec
410: -- , x_Header_Adj_Assoc_Rec OUT OE_Order_PUB.Header_Adj_Assoc_Rec_Type
411: )
412: IS

Line 409: , p_old_Header_Adj_Assoc_Rec IN OE_Order_PUB.Header_Adj_Assoc_Rec_Type := OE_Order_PUB.G_MISS_Header_Adj_Assoc_Rec

405: END Convert_Miss_To_Null;
406:
407: PROCEDURE Apply_Attribute_Changes
408: ( p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
409: , p_old_Header_Adj_Assoc_Rec IN OE_Order_PUB.Header_Adj_Assoc_Rec_Type := OE_Order_PUB.G_MISS_Header_Adj_Assoc_Rec
410: -- , x_Header_Adj_Assoc_Rec OUT OE_Order_PUB.Header_Adj_Assoc_Rec_Type
411: )
412: IS
413:

Line 410: -- , x_Header_Adj_Assoc_Rec OUT OE_Order_PUB.Header_Adj_Assoc_Rec_Type

406:
407: PROCEDURE Apply_Attribute_Changes
408: ( p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
409: , p_old_Header_Adj_Assoc_Rec IN OE_Order_PUB.Header_Adj_Assoc_Rec_Type := OE_Order_PUB.G_MISS_Header_Adj_Assoc_Rec
410: -- , x_Header_Adj_Assoc_Rec OUT OE_Order_PUB.Header_Adj_Assoc_Rec_Type
411: )
412: IS
413:
414: --

Line 426: , p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type

422:
423: PROCEDURE Lock_Row
424: ( x_return_status OUT NOCOPY VARCHAR2
425:
426: , p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
427: , p_price_adj_assoc_id IN NUMBER := FND_API.G_MISS_NUM
428: -- , x_Header_Adj_Assoc_Rec OUT OE_Order_PUB.Header_Adj_Assoc_Rec_Type
429: )
430: is

Line 428: -- , x_Header_Adj_Assoc_Rec OUT OE_Order_PUB.Header_Adj_Assoc_Rec_Type

424: ( x_return_status OUT NOCOPY VARCHAR2
425:
426: , p_x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
427: , p_price_adj_assoc_id IN NUMBER := FND_API.G_MISS_NUM
428: -- , x_Header_Adj_Assoc_Rec OUT OE_Order_PUB.Header_Adj_Assoc_Rec_Type
429: )
430: is
431: l_Header_Adj_Assoc_Rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type;
432: l_lock_control NUMBER;

Line 431: l_Header_Adj_Assoc_Rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type;

427: , p_price_adj_assoc_id IN NUMBER := FND_API.G_MISS_NUM
428: -- , x_Header_Adj_Assoc_Rec OUT OE_Order_PUB.Header_Adj_Assoc_Rec_Type
429: )
430: is
431: l_Header_Adj_Assoc_Rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type;
432: l_lock_control NUMBER;
433: l_price_adj_assoc_id NUMBER;
434:
435: --

Line 570: , x_Header_Adj_Assoc_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type

566: ( p_price_adj_assoc_id IN NUMBER
567: := FND_API.G_MISS_NUM
568: , p_price_adjustment_id IN NUMBER
569: := FND_API.G_MISS_NUM
570: , x_Header_Adj_Assoc_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
571: , x_return_status OUT NOCOPY VARCHAR2
572:
573: )
574: IS

Line 582: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

578: FROM oe_price_adj_assocs
579: WHERE price_adjustment_id = p_price_adjustment_id
580: FOR UPDATE NOWAIT;
581:
582: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
583: l_price_adj_assoc_id NUMBER;
584: l_lock_control NUMBER;
585:
586: --