APPS.OE_LINE_PRICE_AATTR_UTIL dependencies on OE_LINE_PRICE_AATTR_UTIL

Line 1: PACKAGE BODY Oe_Line_Price_Aattr_util AS

1: PACKAGE BODY Oe_Line_Price_Aattr_util AS
2: /* $Header: OEXULAAB.pls 120.0 2005/06/01 02:26:30 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Line_Price_Aattr_util';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Line_Price_Aattr_util';

1: PACKAGE BODY Oe_Line_Price_Aattr_util AS
2: /* $Header: OEXULAAB.pls 120.0 2005/06/01 02:26:30 appldev noship $ */
3:
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

Line 160: oe_debug_pub.add('Entering Oe_Line_Price_Aattr_util.insert_row');

156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
157: --
158: BEGIN
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add('Entering Oe_Line_Price_Aattr_util.insert_row');
161: END IF;
162:
163: INSERT INTO OE_PRICE_ADJ_ATTRIBS
164: ( PRICE_ADJUSTMENT_ID

Line 207: oe_debug_pub.add('Leaving Oe_Line_Price_Aattr_util.insert_row');

203:
204: p_Line_Adj_Att_Rec.lock_control := l_lock_control;
205:
206: IF l_debug_level > 0 THEN
207: oe_debug_pub.add('Leaving Oe_Line_Price_Aattr_util.insert_row');
208: END IF;
209:
210: EXCEPTION
211:

Line 223: oe_debug_pub.add('Exceptions in Oe_Line_Price_Aattr_util.insert_row:'||SQLERRM);

219: );
220: END IF;
221:
222: IF l_debug_level > 0 THEN
223: oe_debug_pub.add('Exceptions in Oe_Line_Price_Aattr_util.insert_row:'||SQLERRM);
224: END IF;
225:
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227:

Line 558: OE_Line_Price_Aattr_Util.Query_Row

554: FROM oe_price_adj_attribs
555: WHERE price_adj_attrib_id = l_price_adj_attrib_id
556: FOR UPDATE NOWAIT;
557:
558: OE_Line_Price_Aattr_Util.Query_Row
559: (p_price_adj_attrib_id => l_price_adj_attrib_id
560: ,x_Line_Adj_Att_rec => p_x_Line_Adj_Att_rec
561: );
562:

Line 689: oe_debug_pub.add( 'ENTERING OE_LINE_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;

685: --
686: BEGIN
687:
688: IF l_debug_level > 0 THEN
689: oe_debug_pub.add( 'ENTERING OE_LINE_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;
690: END IF;
691:
692: IF (p_price_adj_attrib_id IS NOT NULL AND
693: p_price_adj_attrib_id <> FND_API.G_MISS_NUM) AND

Line 742: OE_Line_Price_Aattr_Util.Query_Rows

738: RAISE;
739: END;
740:
741:
742: OE_Line_Price_Aattr_Util.Query_Rows
743: ( p_price_adj_attrib_id => p_price_adj_attrib_id
744: , p_price_adjustment_id => p_price_adjustment_id
745: , x_Line_Adj_Att_tbl => x_Line_Adj_Att_tbl
746: );

Line 778: oe_debug_pub.add( 'EXITING OE_LINE_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;

774: );
775: END IF;
776:
777: IF l_debug_level > 0 THEN
778: oe_debug_pub.add( 'EXITING OE_LINE_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;
779: END IF;
780:
781:
782: END lock_rows;

Line 784: END Oe_Line_Price_Aattr_util;

780:
781:
782: END lock_rows;
783:
784: END Oe_Line_Price_Aattr_util;