DBA Data[Home] [Help]

APPS.OE_HEADER_PRICE_AATTR_UTIL dependencies on OE_HEADER_PRICE_AATTR_UTIL

Line 1: PACKAGE BODY Oe_Header_Price_Aattr_util AS

1: PACKAGE BODY Oe_Header_Price_Aattr_util AS
2: /* $Header: OEXUHAAB.pls 120.0 2005/06/01 01:20:19 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Header_Price_Aattr_util';
5:

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

1: PACKAGE BODY Oe_Header_Price_Aattr_util AS
2: /* $Header: OEXUHAAB.pls 120.0 2005/06/01 01:20:19 appldev noship $ */
3:
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

Line 512: oe_debug_pub.add( 'ENTERING OE_HEADER_PRICE_AATTR_UTIL.LOCK_ROW.' , 1 ) ;

508: --
509: BEGIN
510:
511: IF l_debug_level > 0 THEN
512: oe_debug_pub.add( 'ENTERING OE_HEADER_PRICE_AATTR_UTIL.LOCK_ROW.' , 1 ) ;
513: END IF;
514: SAVEPOINT Lock_Row;
515:
516: l_lock_control := NULL;

Line 531: OE_Header_Price_Aattr_Util.Query_Row

527: FROM oe_price_adj_attribs
528: WHERE price_adj_attrib_id = l_price_adj_attrib_id
529: FOR UPDATE NOWAIT;
530:
531: OE_Header_Price_Aattr_Util.Query_Row
532: (p_price_adj_attrib_id => l_price_adj_attrib_id
533: ,x_Header_Adj_Att_rec => p_x_Header_Adj_Att_rec
534: );
535:

Line 663: oe_debug_pub.add( 'ENTERING OE_HEADER_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;

659: --
660: BEGIN
661:
662: IF l_debug_level > 0 THEN
663: oe_debug_pub.add( 'ENTERING OE_HEADER_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;
664: END IF;
665:
666: IF (p_price_adj_attrib_id IS NOT NULL AND
667: p_price_adj_attrib_id <> FND_API.G_MISS_NUM) AND

Line 716: OE_Header_Price_Aattr_Util.Query_Rows

712: RAISE;
713: END;
714:
715:
716: OE_Header_Price_Aattr_Util.Query_Rows
717: ( p_price_adj_attrib_id => p_price_adj_attrib_id
718: , p_price_adjustment_id => p_price_adjustment_id
719: , x_Header_Adj_Att_tbl => x_Header_Adj_Att_tbl
720: );

Line 752: oe_debug_pub.add( 'EXITING OE_HEADER_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;

748: );
749: END IF;
750:
751: IF l_debug_level > 0 THEN
752: oe_debug_pub.add( 'EXITING OE_HEADER_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;
753: END IF;
754:
755:
756: END lock_rows;

Line 758: END Oe_Header_Price_Aattr_util;

754:
755:
756: END lock_rows;
757:
758: END Oe_Header_Price_Aattr_util;