APPS.OE_LINE_PATTR_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 3215: oe_price_adjustments

3211: l_lst_type_code varchar2(10);
3212: l_lineid1 number;
3213: CURSOR get_price_adj_ids(l_lineid1 IN NUMBER,l_list_hdr_id1 IN NUMBER)
3214: is select price_adjustment_id,list_line_type_code from
3215: oe_price_adjustments
3216: where line_id = l_lineid1 and list_header_id = l_list_hdr_id1;
3217:
3218: FUNCTION delete_price_adj(l_prc_adj_id IN number,l_lst_code IN varchar2)
3219: RETURN BOOLEAN is

Line 3224: delete from oe_price_adjustments where price_adjustment_id in

3220: begin
3221: if l_lst_code in ('PRG','IUE','OID') then
3222: null; --do not expect these cases to be overriden
3223: elsif l_lst_code = 'PBH' then
3224: delete from oe_price_adjustments where price_adjustment_id in
3225: (select rltd_price_adj_id from oe_price_adj_assocs where
3226: price_adjustment_id = l_prc_adj_id
3227: union
3228: select price_adjustment_id from oe_price_adj_assocs where

Line 3237: from oe_price_adj_assocs opaa,oe_price_adjustments opa

3233: elsif l_lst_code in ('DIS','SUR') then
3234: begin
3235: --check if this is a freegoods lines adjustment if so, do not delete it
3236: select 1 into l_tmp1
3237: from oe_price_adj_assocs opaa,oe_price_adjustments opa
3238: where opaa.rltd_price_adj_id = l_prc_adj_id and
3239: opaa.price_adjustment_id = opa.price_adjustment_id and
3240: opa.list_line_type_code = 'PRG';
3241: exception

Line 3245: delete from oe_price_adjustments where

3241: exception
3242: when no_data_found then
3243: --indicates not a free goods adjustment, so delete it
3244: oe_debug_pub.add('in free goods line no data found');
3245: delete from oe_price_adjustments where
3246: price_adjustment_id = l_prc_adj_id;
3247: when others then
3248: null;
3249: end;

Line 3995: from oe_price_adjustments

3991: IF (p_x_line_price_att_rec.pricing_attribute2 is not null) THEN
3992: begin
3993: select price_adjustment_id,list_line_type_code
3994: into l_price_adj_id1,l_lst_type_code
3995: from oe_price_adjustments
3996: where line_id = p_x_line_price_att_rec.line_id
3997: and list_line_id = p_x_line_price_att_rec.pricing_attribute2
3998: and updated_flag = 'Y';
3999: l_price_flag := delete_price_adj(l_price_adj_id1,l_lst_type_code);

Line 4009: (select 1 from oe_price_adjustments where

4005: elsif p_x_line_price_att_rec.pricing_attribute2 is null THEN
4006: begin
4007: select 1 into l_tmp1 from dual
4008: where exists
4009: (select 1 from oe_price_adjustments where
4010: list_header_id = p_x_line_price_att_rec.pricing_attribute1
4011: and updated_flag = 'Y');
4012: for l_prj_adj_cur in
4013: get_price_adj_ids(p_x_line_price_att_rec.line_id,