APPS.OE_LINE_ADJ_ASSOCS_UTIL dependencies on OE_LINE_ADJ_ASSOCS_UTIL

Line 1: PACKAGE BODY Oe_Line_Adj_Assocs_util AS

1: PACKAGE BODY Oe_Line_Adj_Assocs_util AS
2: /* $Header: OEXULASB.pls 120.0.12020000.2 2013/02/13 10:55:19 nilegupt ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Line_Adj_Assocs_util';
5:

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

1: PACKAGE BODY Oe_Line_Adj_Assocs_util AS
2: /* $Header: OEXULASB.pls 120.0.12020000.2 2013/02/13 10:55:19 nilegupt ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Line_Adj_Assocs_util';
5:
6: PROCEDURE Query_Row
7: ( p_price_adj_Assoc_id IN NUMBER
8: , x_Line_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type

Line 247: oe_debug_pub.add( 'PRICE ADJ: DELETE ROW OE_LINE_ADJ_ASSOCS_UTIL' , 5 ) ;

243: --
244: BEGIN
245: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then
246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add( 'PRICE ADJ: DELETE ROW OE_LINE_ADJ_ASSOCS_UTIL' , 5 ) ;
248: END IF;
249: --Modified the below delete statement to fix bug 2626303
250: DELETE OE_PRICE_ADJ_ASSOCS opaa
251: WHERE opaa.rltd_price_adj_id in

Line 445: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_ASSOCS_UTIL.LOCK_ROW.' , 1 ) ;

441: --
442: BEGIN
443:
444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_ASSOCS_UTIL.LOCK_ROW.' , 1 ) ;
446: END IF;
447: SAVEPOINT Lock_Row;
448:
449: l_lock_control := NULL;

Line 464: OE_Line_Adj_Assocs_Util.Query_Row

460: FROM oe_price_adj_assocs
461: WHERE price_adj_assoc_id = l_price_adj_assoc_id
462: FOR UPDATE NOWAIT;
463:
464: OE_Line_Adj_Assocs_Util.Query_Row
465: (p_price_adj_assoc_id => l_price_adj_assoc_id
466: ,x_Line_Adj_Assoc_rec => p_x_Line_Adj_Assoc_rec
467: );
468:

Line 596: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;

592: --
593: BEGIN
594:
595: IF l_debug_level > 0 THEN
596: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;
597: END IF;
598:
599: IF (p_price_adj_assoc_id IS NOT NULL AND
600: p_price_adj_assoc_id <> FND_API.G_MISS_NUM) AND

Line 649: OE_Line_Adj_Assocs_Util.Query_Rows

645: RAISE;
646: END;
647:
648:
649: OE_Line_Adj_Assocs_Util.Query_Rows
650: ( p_price_adj_assoc_id => p_price_adj_assoc_id
651: , p_price_adjustment_id => p_price_adjustment_id
652: , x_Line_Adj_Assoc_tbl => x_Line_Adj_Assoc_tbl
653: );

Line 685: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;

681: );
682: END IF;
683:
684: IF l_debug_level > 0 THEN
685: oe_debug_pub.add( 'EXITING OE_LINE_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;
686: END IF;
687:
688: END lock_rows;
689:

Line 755: END Oe_Line_Adj_Assocs_util;

751: WHEN OTHERS THEN
752: oe_debug_pub.ADD('Error while building assoc',1);
753: END;
754:
755: END Oe_Line_Adj_Assocs_util;