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:
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: --
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:
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;
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:
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:
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;
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
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: --
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
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
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:
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: --
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;
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: --
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
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: --