[Home] [Help]
1169: /*
1170: select booked_flag into l_booked_flag from oe_order_headers_all
1171: where header_id = p_header_id;
1172: */
1173: If OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1174: If l_booked_flag = 'Y' Then
1175: IF nvl(Oe_Sys_Parameters.Value('COMPUTE_MARGIN'),'N') <> 'N' Then
1176: IF l_debug_level > 0 THEN
1177: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR MARGIN HOLD FOR BOOKED HEADER ID : '||p_header_id);
2773:
2774: -- calling notification framework to update global picture
2775: -- check code release level first. Notification framework is at Pack H level
2776:
2777: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2778: IF l_debug_level > 0 THEN
2779: oe_debug_pub.add( 'HDR_ADJ_ID= ' || P_HEADER_ADJ_REC.PRICE_ADJUSTMENT_ID ) ;
2780: END IF;
2781: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3173: p_header_Adj_rec.lock_control := l_lock_control;
3174:
3175: -- calling notification framework to update global picture
3176: -- check code release level first. Notification framework is at Pack H level
3177: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3178: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3179: p_old_hdr_adj_rec => NULL,
3180: p_Hdr_adj_rec =>p_header_adj_rec,
3181: p_hdr_adj_id => p_header_adj_rec.price_adjustment_id,
3294: FOR l_adj IN price_adj LOOP
3295:
3296: --added for notification framework
3297: --check code release level first. Notification framework is at Pack H level
3298: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3299: IF l_debug_level > 0 THEN
3300: oe_debug_pub.add( 'JFC: IN DELETE ROW , PRICE_ADJUSTMENT_ID= '|| L_ADJ.PRICE_ADJUSTMENT_ID ) ;
3301: END IF;
3302:
3357: ELSE
3358:
3359: --added for notification framework
3360: --check code release level first. Notification framework is at Pack H level
3361: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3362: IF l_debug_level > 0 THEN
3363: oe_debug_pub.add( 'JFC:IN DELETE ROW , HEADER_ID IS G_MISS_NUM , PRICE_ADJUSTMENT_ID= '|| P_PRICE_ADJUSTMENT_ID , 1 ) ;
3364: END IF;
3365:
4538: l_header_rec OE_Order_PUB.Header_Rec_Type; --TaxER
4539: BEGIN
4540:
4541: --11.5.10 Versioning/Audit Trail updates
4542: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
4543: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
4544: NOT OE_GLOBALS.G_HEADER_CREATED THEN
4545: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
4546: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
4577: IF l_debug_level > 0 THEN
4578: oe_debug_pub.add( 'CALL TO RECORD HEADER PRICE ADJ HISTORY' , 5 ) ;
4579: END IF;
4580: --11.5.10 Versioning/Audit Trail updates
4581: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4582: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4583: p_entity_id => p_x_header_adj_rec.price_adjustment_id,
4584: p_hist_type_code => 'UPDATE');
4585: --log delayed request
4759: l_from_order_category := c1_rec.order_category_code;
4760: end loop;
4761:
4762: /* Header Level adjustment for FROM Header */
4763: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
4764: OE_Version_History_Util.Query_Rows
4765: ( p_header_id => p_from_header_id
4766: , p_version_number => OE_ORDER_COPY_UTIL.G_HDR_VER_NUMBER
4767: , p_phase_change_flag => OE_ORDER_COPY_UTIL.G_HDR_PHASE_CHANGE_FLAG
4948: l_from_order_category := c1_rec.order_category_code;
4949: end loop;
4950:
4951: /* Header Level Charges for FROM Header */
4952: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
4953: OE_Version_History_Util.Query_Rows
4954: ( p_header_id => p_from_header_id
4955: , p_version_number => OE_ORDER_COPY_UTIL.G_HDR_VER_NUMBER
4956: , p_phase_change_flag => OE_ORDER_COPY_UTIL.G_HDR_PHASE_CHANGE_FLAG