[Home] [Help]
2864: l_lock_control := l_lock_control + 1;
2865:
2866: --calling notification framework to update global picture
2867: --check code release level first. Notification framework is at Pack H level
2868: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2869: IF l_debug_level > 0 THEN
2870: oe_debug_pub.add( 'JFC: LINE_PRICE_ADJ_ID=' || P_LINE_ADJ_REC.PRICE_ADJUSTMENT_ID ) ;
2871: END IF;
2872: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3298: p_Line_Adj_rec.lock_control := l_lock_control;
3299:
3300: --calling notification framework to update_global picture
3301: --check code release level first. Notification framework is at Pack H level
3302: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3303: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3304: p_old_line_adj_rec => NULL,
3305: p_line_adj_rec =>p_line_adj_rec,
3306: p_line_adj_id => p_line_adj_rec.price_adjustment_id,
3402: FOR l_adj IN price_adj LOOP
3403:
3404: --added for notification framework
3405: --check code release level first. Notification framework is at Pack H level
3406: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3407: IF l_debug_level > 0 THEN
3408: oe_debug_pub.add( 'JFC: IN DELETE ROW , PRICE_ADJUSTMENT_ID'||L_ADJ.PRICE_ADJUSTMENT_ID , 1 ) ;
3409: END IF;
3410: /* Set the operation on the record so that globals are updated as well */
3458: END IF;
3459:
3460: --added for notification framework
3461: --check code release level first. Notification framework is at Pack H level
3462: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3463: IF l_debug_level > 0 THEN
3464: oe_debug_pub.add( 'JFC: IN DELETE ROW , LINE_ID IS G_MISS_NUM , PRICE_ADJUSTMENT_ID'||P_PRICE_ADJUSTMENT_ID , 1 ) ;
3465: END IF;
3466: /* Set the operation on the record so that globals are updated as well */
4981:
4982: -- Manish Changes
4983: if p_line_id is not null then
4984:
4985: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' and
4986: p_operation <> OE_GLOBALS.G_OPR_DELETE THEN
4987: --RT{
4988: --we need to retrieve the latest adjustments if it is a retrobilled line
4989: --call retrobill api to get the retrobill line id, if none l_line_id will
5019: END IF;
5020:
5021: else
5022: -- l_Line_Adj_Tbl := OE_Line_Adj_Util.Query_Rows(p_header_Id => p_header_id);
5023: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' and
5024: p_operation <> OE_GLOBALS.G_OPR_DELETE THEN
5025: --RT{
5026: Oe_Retrobill_Pvt.Get_Last_Retro_HdrID(p_header_id=>p_header_id,
5027: x_header_id=>l_header_id);
5532: --
5533: BEGIN
5534:
5535: --11.5.10 Versioning/Audit Trail updates
5536: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
5537: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
5538: NOT OE_GLOBALS.G_HEADER_CREATED THEN
5539: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5540: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5573:
5574: IF l_debug_level > 0 THEN
5575: oe_debug_pub.add( 'CALL TO RECORD LINE PRICE ADJ HISTORY' , 5 ) ;
5576: END IF;
5577: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
5578: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5579: p_entity_id => p_x_line_adj_rec.price_adjustment_id,
5580: p_hist_type_code => 'UPDATE');
5581: --log delayed request
5661: p_new_line_rec.original_list_price <> FND_API.G_MISS_NUM AND
5662: p_new_line_rec.Ordered_Quantity <> fnd_api.g_miss_num and
5663: p_new_line_rec.order_quantity_uom is not null and
5664: p_new_line_rec.order_quantity_uom <> fnd_api.g_miss_char
5665: AND oe_code_control.code_release_level >= '110510'
5666: AND nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE') = 'UNLIMITED'
5667: AND OE_GLOBALS.G_UI_FLAG
5668: AND OE_Globals.G_PRICING_RECURSION = 'N'
5669: )
5953: oe_debug_pub.add('G_GROUP_PRICING_DSP = '||G_GROUP_PRICING_DSP);
5954: End If;
5955:
5956: If G_CODE_RELEASE_LEVEL IS NULL THEN
5957: G_CODE_RELEASE_LEVEL := OE_CODE_CONTROL.CODE_RELEASE_LEVEL;
5958: End If;
5959:
5960: If l_debug_level > 0 Then
5961: oe_debug_pub.add('G_CODE_RELEASE_LEVEL = '||G_CODE_RELEASE_LEVEL);