APPS.OE_SHIP_CONFIRMATION_PUB dependencies on OE_PRICE_ADJUSTMENTS

Line 438: SELECT OE_PRICE_ADJUSTMENTS_S.nextval

434: -- Create Freight Cost Records Here
435: NULL;
436: FOR J IN 1..p_line_adj_tbl.COUNT
437: LOOP
438: SELECT OE_PRICE_ADJUSTMENTS_S.nextval
439: INTO l_price_adjustment_id
440: FROM DUAL;
441:
442: l_line_adj_rec := p_line_adj_tbl(J);

Line 4739: DELETE FROM OE_PRICE_ADJUSTMENTS

4735: END IF;
4736:
4737: --bug 4558089
4738: FORALL i IN p_line_adj_rec.line_id.FIRST..p_line_adj_rec.line_id.LAST
4739: DELETE FROM OE_PRICE_ADJUSTMENTS
4740: WHERE LINE_ID = p_line_adj_rec.line_id(i)
4741: AND CHARGE_TYPE_CODE IN ('FTEPRICE','FTECHARGE')
4742: AND p_line_adj_rec.charge_type_code(i) IN ('FTEPRICE','FTECHARGE')
4743: AND list_line_type_code = 'COST'

Line 4749: INSERT INTO OE_PRICE_ADJUSTMENTS

4745: AND ESTIMATED_FLAG = 'Y';
4746: --bug 4558089
4747:
4748: FORALL i IN p_line_adj_rec.line_id.FIRST..p_line_adj_rec.line_id.LAST
4749: INSERT INTO OE_PRICE_ADJUSTMENTS
4750: ( price_adjustment_id
4751: ,cost_id
4752: ,automatic_flag
4753: ,list_line_type_code

Line 4765: ( OE_PRICE_ADJUSTMENTS_S.nextval

4761: ,last_update_login
4762: ,creation_date
4763: ,created_by)
4764: VALUES
4765: ( OE_PRICE_ADJUSTMENTS_S.nextval
4766: ,p_line_adj_rec.cost_id(i)
4767: ,p_line_adj_rec.automatic_flag(i)
4768: ,p_line_adj_rec.list_line_type_code(i)
4769: ,p_line_adj_rec.charge_type_code(i)