[Home] [Help]
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: --
16: BEGIN
17: Query_Rows
18: ( p_price_adj_attrib_id => p_price_adj_attrib_id
79: from oe_price_adj_attribs where
80: price_adjustment_id = p_price_adjustment_id;
81:
82: --
83: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
84: --
85: BEGIN
86:
87: l_count := 1;
152: IS
153:
154: l_lock_control NUMBER := 1;
155: --
156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
157: --
158: BEGIN
159:
160: INSERT INTO OE_PRICE_ADJ_ATTRIBS
221: IS
222: l_lock_control NUMBER;
223:
224: --
225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
226: --
227: BEGIN
228: SELECT lock_control
229: INTO l_lock_control
279: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
280: )
281: IS
282: --
283: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
284: --
285: BEGIN
286:
287: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then
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
321:
322: IF l_Header_Adj_Att_rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN
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
404:
405: IF l_Header_Adj_Att_rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN
482: )
483: IS
484:
485: --
486: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
487: --
488: BEGIN
489:
490: -- x_Header_Adj_Att_rec := p_Header_Adj_Att_rec;
503: l_lock_control NUMBER;
504: l_price_adj_attrib_id NUMBER;
505:
506: --
507: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
508: --
509: BEGIN
510:
511: IF l_debug_level > 0 THEN
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;
534: );
535:
536:
537: IF l_debug_level > 0 THEN
538: oe_debug_pub.add( 'QUERIED LOCK_CONTROL: '|| P_X_HEADER_ADJ_ATT_REC.LOCK_CONTROL , 1 ) ;
539: END IF;
540:
541: -- If lock_control is not passed(is null or missing), then return the locked record.
542:
556: -- Row locked. If the whole record is passed, then
557: -- Compare lock_control.
558:
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.add( 'COMPARE ' , 1 ) ;
561: END IF;
562:
563: IF OE_GLOBALS.Equal(p_x_Header_Adj_Att_rec.lock_control,
564: l_lock_control)
566:
567: -- Row has not changed. Set out parameter.
568:
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add( 'LOCKED ROW' , 1 ) ;
571: END IF;
572:
573: -- Set return status
574:
578: ELSE
579:
580: -- Row has changed by another user.
581: IF l_debug_level > 0 THEN
582: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
583: END IF;
584:
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: p_x_Header_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
654: l_price_adj_attrib_id NUMBER;
655: l_lock_control NUMBER;
656:
657: --
658: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
659: --
660: BEGIN
661:
662: IF l_debug_level > 0 THEN
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
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;