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

Line 8: , x_Header_Adj_Att_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Adj_Att_Rec_Type

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Header_Price_Aattr_util';
5:
6: PROCEDURE Query_Row
7: ( p_price_adj_attrib_id IN NUMBER
8: , x_Header_Adj_Att_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Adj_Att_Rec_Type
9: )
10: IS
11: l_Header_Adj_Att_Tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
12:

Line 11: l_Header_Adj_Att_Tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

7: ( p_price_adj_attrib_id IN NUMBER
8: , x_Header_Adj_Att_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Adj_Att_Rec_Type
9: )
10: IS
11: l_Header_Adj_Att_Tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
12:
13: --
14: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
15: --

Line 32: , x_Header_Adj_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type)

28: ( p_price_adj_attrib_id IN NUMBER :=
29: FND_API.G_MISS_NUM
30: , p_price_adjustment_id IN NUMBER :=
31: FND_API.G_MISS_NUM
32: , x_Header_Adj_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type)
33: IS
34: l_count NUMBER;
35:
36:

Line 150: ( p_Header_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type

146:
147: END Query_Rows;
148:
149: PROCEDURE Insert_Row
150: ( p_Header_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
151: )
152: IS
153:
154: l_lock_control NUMBER := 1;

Line 219: ( p_Header_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type

215:
216: END Insert_Row;
217:
218: PROCEDURE Update_Row
219: ( p_Header_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
220: )
221: IS
222: l_lock_control NUMBER;
223:

Line 311: ( p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type

307:
308: END Delete_Row;
309:
310: PROCEDURE Complete_Record
311: ( p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
312: , p_old_Header_Adj_Att_rec IN OE_Order_PUB.Header_Adj_Att_Rec_Type
313: )
314: IS
315:

Line 312: , p_old_Header_Adj_Att_rec IN OE_Order_PUB.Header_Adj_Att_Rec_Type

308: END Delete_Row;
309:
310: PROCEDURE Complete_Record
311: ( p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
312: , p_old_Header_Adj_Att_rec IN OE_Order_PUB.Header_Adj_Att_Rec_Type
313: )
314: IS
315:
316: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type := p_x_Header_Adj_Att_rec;

Line 316: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type := p_x_Header_Adj_Att_rec;

312: , p_old_Header_Adj_Att_rec IN OE_Order_PUB.Header_Adj_Att_Rec_Type
313: )
314: IS
315:
316: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type := p_x_Header_Adj_Att_rec;
317: --
318: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
319: --
320: BEGIN

Line 396: ( p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type

392:
393: END Complete_Record;
394:
395: PROCEDURE Convert_Miss_To_Null
396: ( p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
397: )
398: IS
399: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type := p_x_Header_Adj_Att_rec;
400: --

Line 399: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type := p_x_Header_Adj_Att_rec;

395: PROCEDURE Convert_Miss_To_Null
396: ( p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
397: )
398: IS
399: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type := p_x_Header_Adj_Att_rec;
400: --
401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
402: --
403: BEGIN

Line 479: ( p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type

475:
476: END Convert_Miss_To_Null;
477:
478: PROCEDURE Apply_Attribute_Changes
479: ( p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
480: , p_old_Header_Adj_Att_rec IN OE_Order_PUB.Header_Adj_Att_Rec_Type := OE_Order_PUB.G_MISS_Header_Adj_Att_REC
481: -- , x_Header_Adj_Att_rec OUT OE_Order_PUB.Header_Adj_Att_Rec_Type
482: )
483: IS

Line 480: , p_old_Header_Adj_Att_rec IN OE_Order_PUB.Header_Adj_Att_Rec_Type := OE_Order_PUB.G_MISS_Header_Adj_Att_REC

476: END Convert_Miss_To_Null;
477:
478: PROCEDURE Apply_Attribute_Changes
479: ( p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
480: , p_old_Header_Adj_Att_rec IN OE_Order_PUB.Header_Adj_Att_Rec_Type := OE_Order_PUB.G_MISS_Header_Adj_Att_REC
481: -- , x_Header_Adj_Att_rec OUT OE_Order_PUB.Header_Adj_Att_Rec_Type
482: )
483: IS
484:

Line 481: -- , x_Header_Adj_Att_rec OUT OE_Order_PUB.Header_Adj_Att_Rec_Type

477:
478: PROCEDURE Apply_Attribute_Changes
479: ( p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
480: , p_old_Header_Adj_Att_rec IN OE_Order_PUB.Header_Adj_Att_Rec_Type := OE_Order_PUB.G_MISS_Header_Adj_Att_REC
481: -- , x_Header_Adj_Att_rec OUT OE_Order_PUB.Header_Adj_Att_Rec_Type
482: )
483: IS
484:
485: --

Line 498: , p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type

494:
495: PROCEDURE Lock_Row
496: ( x_return_status OUT NOCOPY VARCHAR2
497:
498: , p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
499: , p_price_adj_attrib_id IN NUMBER := FND_API.G_MISS_NUM
500: )
501: is
502: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type;

Line 502: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type;

498: , p_x_Header_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
499: , p_price_adj_attrib_id IN NUMBER := FND_API.G_MISS_NUM
500: )
501: is
502: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type;
503: l_lock_control NUMBER;
504: l_price_adj_attrib_id NUMBER;
505:
506: --

Line 641: , x_Header_Adj_Att_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type

637: ( p_price_adj_attrib_id IN NUMBER
638: := FND_API.G_MISS_NUM
639: , p_price_adjustment_id IN NUMBER
640: := FND_API.G_MISS_NUM
641: , x_Header_Adj_Att_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
642: , x_return_status OUT NOCOPY VARCHAR2
643:
644: )
645: IS

Line 653: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

649: FROM oe_price_adj_attribs
650: WHERE price_adjustment_id = p_price_adjustment_id
651: FOR UPDATE NOWAIT;
652:
653: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
654: l_price_adj_attrib_id NUMBER;
655: l_lock_control NUMBER;
656:
657: --