APPS.OE_LINE_PRICE_AATTR_UTIL dependencies on OE_ORDER_PUB

Line 8: , x_Line_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Line_Price_Aattr_util';
5:
6: PROCEDURE Query_Row
7: ( p_price_adj_attrib_id IN NUMBER
8: , x_Line_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
9: )
10: IS
11:
12: l_Line_Adj_Att_Tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 12: l_Line_Adj_Att_Tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

8: , x_Line_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
9: )
10: IS
11:
12: l_Line_Adj_Att_Tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
13:
14: --
15: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
16: --

Line 34: , x_Line_Adj_Att_Tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Adj_Att_Tbl_Type

30: ( p_price_adj_attrib_id IN NUMBER :=
31: FND_API.G_MISS_NUM
32: , p_price_adjustment_id IN NUMBER :=
33: FND_API.G_MISS_NUM
34: , x_Line_Adj_Att_Tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Adj_Att_Tbl_Type
35: )
36: IS
37: l_count NUMBER;
38:

Line 150: ( p_Line_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type

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

Line 231: ( p_Line_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type

227:
228: END Insert_Row;
229:
230: PROCEDURE Update_Row
231: ( p_Line_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
232: )
233: IS
234: l_lock_control NUMBER;
235:

Line 338: ( p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type

334:
335: END Delete_Row;
336:
337: PROCEDURE Complete_Record
338: ( p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
339: , p_old_Line_Adj_Att_rec IN OE_Order_PUB.Line_Adj_Att_Rec_Type
340: )
341: IS
342:

Line 339: , p_old_Line_Adj_Att_rec IN OE_Order_PUB.Line_Adj_Att_Rec_Type

335: END Delete_Row;
336:
337: PROCEDURE Complete_Record
338: ( p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
339: , p_old_Line_Adj_Att_rec IN OE_Order_PUB.Line_Adj_Att_Rec_Type
340: )
341: IS
342:
343: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type := p_x_Line_Adj_Att_rec;

Line 343: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type := p_x_Line_Adj_Att_rec;

339: , p_old_Line_Adj_Att_rec IN OE_Order_PUB.Line_Adj_Att_Rec_Type
340: )
341: IS
342:
343: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type := p_x_Line_Adj_Att_rec;
344: --
345: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
346: --
347: BEGIN

Line 423: ( p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type

419:
420: END Complete_Record;
421:
422: PROCEDURE Convert_Miss_To_Null
423: ( p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
424: )
425: IS
426: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type := p_x_Line_Adj_Att_rec;
427: --

Line 426: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type := p_x_Line_Adj_Att_rec;

422: PROCEDURE Convert_Miss_To_Null
423: ( p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
424: )
425: IS
426: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type := p_x_Line_Adj_Att_rec;
427: --
428: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
429: --
430: BEGIN

Line 506: ( p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type

502:
503: END Convert_Miss_To_Null;
504:
505: PROCEDURE Apply_Attribute_Changes
506: ( p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
507: , p_old_Line_Adj_Att_rec IN OE_Order_PUB.Line_Adj_Att_Rec_Type := OE_Order_PUB.G_MISS_Line_Adj_Att_REC
508: -- , x_Line_Adj_Att_rec OUT OE_Order_PUB.Line_Adj_Att_Rec_Type
509: )
510: IS

Line 507: , p_old_Line_Adj_Att_rec IN OE_Order_PUB.Line_Adj_Att_Rec_Type := OE_Order_PUB.G_MISS_Line_Adj_Att_REC

503: END Convert_Miss_To_Null;
504:
505: PROCEDURE Apply_Attribute_Changes
506: ( p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
507: , p_old_Line_Adj_Att_rec IN OE_Order_PUB.Line_Adj_Att_Rec_Type := OE_Order_PUB.G_MISS_Line_Adj_Att_REC
508: -- , x_Line_Adj_Att_rec OUT OE_Order_PUB.Line_Adj_Att_Rec_Type
509: )
510: IS
511:

Line 508: -- , x_Line_Adj_Att_rec OUT OE_Order_PUB.Line_Adj_Att_Rec_Type

504:
505: PROCEDURE Apply_Attribute_Changes
506: ( p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
507: , p_old_Line_Adj_Att_rec IN OE_Order_PUB.Line_Adj_Att_Rec_Type := OE_Order_PUB.G_MISS_Line_Adj_Att_REC
508: -- , x_Line_Adj_Att_rec OUT OE_Order_PUB.Line_Adj_Att_Rec_Type
509: )
510: IS
511:
512: --

Line 525: , p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type

521:
522: PROCEDURE Lock_Row
523: ( x_return_status OUT NOCOPY VARCHAR2
524:
525: , p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
526: , p_price_adj_attrib_id IN NUMBER := FND_API.G_MISS_NUM
527: )
528: is
529: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;

Line 529: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;

525: , p_x_Line_Adj_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
526: , p_price_adj_attrib_id IN NUMBER := FND_API.G_MISS_NUM
527: )
528: is
529: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;
530: l_lock_control NUMBER;
531: l_price_adj_attrib_id NUMBER;
532:
533: --

Line 667: , x_Line_Adj_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type

663: ( p_price_adj_attrib_id IN NUMBER
664: := FND_API.G_MISS_NUM
665: , p_price_adjustment_id IN NUMBER
666: := FND_API.G_MISS_NUM
667: , x_Line_Adj_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
668: , x_return_status OUT NOCOPY VARCHAR2
669:
670: )
671: IS

Line 679: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

675: FROM oe_price_adj_attribs
676: WHERE price_adjustment_id = p_price_adjustment_id
677: FOR UPDATE NOWAIT;
678:
679: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
680: l_price_adj_attrib_id NUMBER;
681: l_lock_control NUMBER;
682:
683: --