APPS.OE_HEADER_PATTR_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 2698: oe_price_adjustments

2694: l_lst_type_code varchar2(10);
2695: l_lineid1 number;
2696: CURSOR get_price_adj_ids(l_hdrid1 IN NUMBER,l_list_hdr_id1 IN NUMBER)
2697: is select price_adjustment_id,list_line_type_code from
2698: oe_price_adjustments
2699: where header_id = l_hdrid1 and list_header_id = l_list_hdr_id1
2700: and updated_flag = 'Y';
2701: FUNCTION delete_price_adj(l_prc_adj_id IN number,l_lst_code IN varchar2)
2702: RETURN BOOLEAN is

Line 2707: delete from oe_price_adjustments where price_adjustment_id in

2703: begin
2704: if l_lst_code in ('PRG','IUE','OID') then
2705: null; --do not expect these cases to be overriden
2706: elsif l_lst_code = 'PBH' then
2707: delete from oe_price_adjustments where price_adjustment_id in
2708: (select rltd_price_adj_id from oe_price_adj_assocs where
2709: price_adjustment_id = l_prc_adj_id
2710: union
2711: select price_adjustment_id from oe_price_adj_assocs where

Line 2720: from oe_price_adj_assocs opaa,oe_price_adjustments opa

2716: elsif l_lst_code in ('DIS','SUR') then
2717: begin
2718: --check if this is freegoods lines adjustment if so, do not delete
2719: select 1 into l_tmp1
2720: from oe_price_adj_assocs opaa,oe_price_adjustments opa
2721: where opaa.rltd_price_adj_id = l_prc_adj_id and
2722: opaa.price_adjustment_id = opa.price_adjustment_id and
2723: opa.list_line_type_code = 'PRG';
2724: exception

Line 2728: delete from oe_price_adjustments where

2724: exception
2725: when no_data_found then
2726: --indicates not a free goods adjustment, so delete it
2727: oe_debug_pub.add('in free goods line no data found');
2728: delete from oe_price_adjustments where
2729: price_adjustment_id = l_prc_adj_id;
2730: when others then
2731: null;
2732: end;

Line 3413: from oe_price_adjustments

3409: if p_x_header_price_att_rec.pricing_attribute2 is not null then
3410: begin
3411: select price_adjustment_id,list_line_type_code
3412: into l_price_adj_id1,l_lst_type_code
3413: from oe_price_adjustments
3414: where header_id = p_x_header_price_att_rec.header_id
3415: and list_line_id = p_x_header_price_att_rec.pricing_attribute2
3416: and updated_flag = 'Y';
3417: l_price_flag := delete_price_adj(l_price_adj_id1,l_lst_type_code);