[Home] [Help]
270:
271: --amy: revert to original item if the IUE is deleted
272: Cursor revert_back_items IS
273: SELECT adj.line_id, adj.modified_from,adj.price_adjustment_id
274: FROM OE_PRICE_ADJUSTMENTS adj
275: WHERE HEADER_ID = oe_order_cache.g_header_rec.header_id
276: AND list_line_Type_code = 'IUE'
277: AND PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
278: where instr(p_pricing_events||',', pricing_event_code||',') >0)
320: px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).change_reason := 'SYSTEM';
321: px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).change_comments := 'REPRICING';
322:
323: --bug 2858712
324: DELETE FROM OE_PRICE_ADJUSTMENTS
325: WHERE PRICE_ADJUSTMENT_ID = i.price_adjustment_id;
326: delete_attribs_for_iue(i.price_adjustment_id);
327: END IF;
328: END LOOP;
340: --bug 2795409
341: px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).change_reason := 'SYSTEM';
342: px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).change_comments := 'REPRICING';
343:
344: INSERT INTO OE_PRICE_ADJUSTMENTS
345: ( PRICE_ADJUSTMENT_ID
346: , CREATION_DATE
347: , CREATED_BY
348: , LAST_UPDATE_DATE
443: , ADJUSTED_AMOUNT_PER_PQTY
444: , LOCK_CONTROL
445: )
446: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
447: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
448: ldets.price_adjustment_id
449: , sysdate --p_Line_Adj_rec.creation_date
450: , fnd_global.user_id --p_Line_Adj_rec.created_by
451: , sysdate --p_Line_Adj_rec.last_update_date
576: Is
577: cursor oe_price_adj_cur(p_line_id number) is
578: select price_adjustment_id,LIST_LINE_ID,PRICING_PHASE_ID ,
579: MODIFIER_LEVEL_CODE
580: from oe_price_adjustments where
581: line_id = p_line_id and LIST_LINE_TYPE_CODE = 'TSN';
582:
583: Cursor ldets_cur is
584: select line_index,LINE_DETAIL_INDEX,LINE_DETAIL_TYPE_CODE,
711: if( nvl(px_line_tbl(j).cancelled_flag,'N') <> 'Y' and nvl(px_line_tbl(j).open_flag,'Y') <> 'N' ) THEN
712: if (l_debug_level > 0) then
713: oe_debug_pub.add( 'Lalit As the line in not closed/cancelled updating LINE ID = '||PX_LINE_TBL ( J ) .LINE_ID , 1 ) ;
714: end if;
715: select count(*) into vcount from oe_price_adjustments where
716: line_id = px_line_tbl(j).line_id and
717: LIST_LINE_TYPE_CODE = 'TSN' and MODIFIER_LEVEL_CODE = 'LINE';
718: If vcount = 0 then
719: If i.Substitution_Attribute ='QUALIFIER_ATTRIBUTE1' Then
758: px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).change_reason := 'SYSTEM';
759: px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).change_comments := 'REPRICING';
760: End If;
761: --bug 4190357
762: INSERT INTO OE_PRICE_ADJUSTMENTS
763: ( PRICE_ADJUSTMENT_ID
764: , CREATION_DATE
765: , CREATED_BY
766: , LAST_UPDATE_DATE
861: , ADJUSTED_AMOUNT_PER_PQTY
862: , LOCK_CONTROL
863: )
864: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
865: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
866: ldets.price_adjustment_id
867: , sysdate --p_Line_Adj_rec.creation_date
868: , fnd_global.user_id --p_Line_Adj_rec.created_by
869: , sysdate --p_Line_Adj_rec.last_update_date
2206: BEGIN
2207: IF l_debug_level > 0 THEN
2208: oe_debug_pub.add( 'INSIDE OE_ADV_PRICE_PVT.INSERT_ADJ' ) ;
2209: END IF;
2210: INSERT INTO OE_PRICE_ADJUSTMENTS
2211: ( PRICE_ADJUSTMENT_ID
2212: , CREATION_DATE
2213: , CREATED_BY
2214: , LAST_UPDATE_DATE
2309: , ADJUSTED_AMOUNT_PER_PQTY
2310: , LOCK_CONTROL
2311: )
2312: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2313: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2314: ldets.price_adjustment_id
2315: , sysdate --p_Line_Adj_rec.creation_date
2316: , fnd_global.user_id --p_Line_Adj_rec.created_by
2317: , sysdate --p_Line_Adj_rec.last_update_date
2343: , NULL --p_Line_Adj_rec.attribute13
2344: , NULL --p_Line_Adj_rec.attribute14
2345: , NULL --p_Line_Adj_rec.attribute15
2346: -- Bug 7523118
2347: , 'OE_PRICE_ADJUSTMENTS'||ldets.price_adjustment_id --p_Line_Adj_rec.orig_sys_discount_ref
2348: , ldets.LIST_HEADER_ID
2349: , ldets.LIST_LINE_ID
2350: , ldets.LIST_LINE_TYPE_CODE
2351: , NULL --p_Line_Adj_rec.MODIFIER_MECHANISM_TYPE_CODE