[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);
2716:
2717: -- calling notification framework to update global picture
2718: -- check code release level first. Notification framework is at Pack H level
2719:
2720: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2721: IF l_debug_level > 0 THEN
2722: oe_debug_pub.add( 'HDR_ADJ_ID= ' || P_HEADER_ADJ_REC.PRICE_ADJUSTMENT_ID ) ;
2723: END IF;
2724: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3114: p_header_Adj_rec.lock_control := l_lock_control;
3115:
3116: -- calling notification framework to update global picture
3117: -- check code release level first. Notification framework is at Pack H level
3118: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3119: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3120: p_old_hdr_adj_rec => NULL,
3121: p_Hdr_adj_rec =>p_header_adj_rec,
3122: p_hdr_adj_id => p_header_adj_rec.price_adjustment_id,
3235: FOR l_adj IN price_adj LOOP
3236:
3237: --added for notification framework
3238: --check code release level first. Notification framework is at Pack H level
3239: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3240: IF l_debug_level > 0 THEN
3241: oe_debug_pub.add( 'JFC: IN DELETE ROW , PRICE_ADJUSTMENT_ID= '|| L_ADJ.PRICE_ADJUSTMENT_ID ) ;
3242: END IF;
3243:
3298: ELSE
3299:
3300: --added for notification framework
3301: --check code release level first. Notification framework is at Pack H level
3302: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3303: IF l_debug_level > 0 THEN
3304: oe_debug_pub.add( 'JFC:IN DELETE ROW , HEADER_ID IS G_MISS_NUM , PRICE_ADJUSTMENT_ID= '|| P_PRICE_ADJUSTMENT_ID , 1 ) ;
3305: END IF;
3306:
4475: --
4476: BEGIN
4477:
4478: --11.5.10 Versioning/Audit Trail updates
4479: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
4480: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
4481: NOT OE_GLOBALS.G_HEADER_CREATED THEN
4482: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
4483: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
4514: IF l_debug_level > 0 THEN
4515: oe_debug_pub.add( 'CALL TO RECORD HEADER PRICE ADJ HISTORY' , 5 ) ;
4516: END IF;
4517: --11.5.10 Versioning/Audit Trail updates
4518: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4519: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4520: p_entity_id => p_x_header_adj_rec.price_adjustment_id,
4521: p_hist_type_code => 'UPDATE');
4522: --log delayed request
4603: l_from_order_category := c1_rec.order_category_code;
4604: end loop;
4605:
4606: /* Header Level adjustment for FROM Header */
4607: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
4608: OE_Version_History_Util.Query_Rows
4609: ( p_header_id => p_from_header_id
4610: , p_version_number => OE_ORDER_COPY_UTIL.G_HDR_VER_NUMBER
4611: , p_phase_change_flag => OE_ORDER_COPY_UTIL.G_HDR_PHASE_CHANGE_FLAG
4792: l_from_order_category := c1_rec.order_category_code;
4793: end loop;
4794:
4795: /* Header Level Charges for FROM Header */
4796: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
4797: OE_Version_History_Util.Query_Rows
4798: ( p_header_id => p_from_header_id
4799: , p_version_number => OE_ORDER_COPY_UTIL.G_HDR_VER_NUMBER
4800: , p_phase_change_flag => OE_ORDER_COPY_UTIL.G_HDR_PHASE_CHANGE_FLAG