APPS.OE_HEADER_ADJ_ASSOCS_UTIL dependencies on OE_HEADER_ADJ_ASSOCS_UTIL

Line 1: PACKAGE BODY Oe_Header_Adj_Assocs_util AS

1: PACKAGE BODY Oe_Header_Adj_Assocs_util AS
2: /* $Header: OEXUHASB.pls 120.2 2006/02/21 21:52:40 jisingh noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Header_Adj_Assocs_util';
5:

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

1: PACKAGE BODY Oe_Header_Adj_Assocs_util AS
2: /* $Header: OEXUHASB.pls 120.2 2006/02/21 21:52:40 jisingh noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Header_Adj_Assocs_util';
5:
6: PROCEDURE Query_Row
7: ( p_price_adj_Assoc_id IN NUMBER
8: , x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type

Line 441: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROW.' , 1 ) ;

437: --
438: BEGIN
439:
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROW.' , 1 ) ;
442: END IF;
443: SAVEPOINT Lock_Row;
444:
445: l_lock_control := NULL;

Line 460: OE_Header_Adj_Assocs_Util.Query_Row

456: FROM oe_price_adj_assocs
457: WHERE price_adj_assoc_id = l_price_adj_assoc_id
458: FOR UPDATE NOWAIT;
459:
460: OE_Header_Adj_Assocs_Util.Query_Row
461: (p_price_adj_assoc_id => l_price_adj_assoc_id
462: ,x_Header_Adj_Assoc_rec => p_x_Header_Adj_Assoc_rec
463: );
464:

Line 592: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;

588: --
589: BEGIN
590:
591: IF l_debug_level > 0 THEN
592: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;
593: END IF;
594:
595: IF (p_price_adj_assoc_id IS NOT NULL AND
596: p_price_adj_assoc_id <> FND_API.G_MISS_NUM) AND

Line 645: OE_Header_Adj_Assocs_Util.Query_Rows

641: RAISE;
642: END;
643:
644:
645: OE_Header_Adj_Assocs_Util.Query_Rows
646: ( p_price_adj_assoc_id => p_price_adj_assoc_id
647: , p_price_adjustment_id => p_price_adjustment_id
648: , x_Header_Adj_Assoc_tbl => x_Header_Adj_Assoc_tbl
649: );

Line 681: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;

677: );
678: END IF;
679:
680: IF l_debug_level > 0 THEN
681: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;
682: END IF;
683:
684:
685: END lock_rows;

Line 687: END Oe_Header_Adj_Assocs_util;

683:
684:
685: END lock_rows;
686:
687: END Oe_Header_Adj_Assocs_util;