APPS.OE_SHIP_CONFIRMATION_PUB dependencies on OE_PRICE_ADJUSTMENTS

Line 447: SELECT OE_PRICE_ADJUSTMENTS_S.nextval

443: -- Create Freight Cost Records Here
444: NULL;
445: FOR J IN 1..p_line_adj_tbl.COUNT
446: LOOP
447: SELECT OE_PRICE_ADJUSTMENTS_S.nextval
448: INTO l_price_adjustment_id
449: FROM DUAL;
450:
451: l_line_adj_rec := p_line_adj_tbl(J);

Line 5101: DELETE FROM OE_PRICE_ADJUSTMENTS

5097: END IF;
5098:
5099: --bug 4558089
5100: FORALL i IN p_line_adj_rec.line_id.FIRST..p_line_adj_rec.line_id.LAST
5101: DELETE FROM OE_PRICE_ADJUSTMENTS
5102: WHERE LINE_ID = p_line_adj_rec.line_id(i)
5103: AND CHARGE_TYPE_CODE IN ('FTEPRICE','FTECHARGE')
5104: AND p_line_adj_rec.charge_type_code(i) IN ('FTEPRICE','FTECHARGE')
5105: AND list_line_type_code = 'COST'

Line 5111: INSERT INTO OE_PRICE_ADJUSTMENTS

5107: AND ESTIMATED_FLAG = 'Y';
5108: --bug 4558089
5109:
5110: FORALL i IN p_line_adj_rec.line_id.FIRST..p_line_adj_rec.line_id.LAST
5111: INSERT INTO OE_PRICE_ADJUSTMENTS
5112: ( price_adjustment_id
5113: ,cost_id
5114: ,automatic_flag
5115: ,list_line_type_code

Line 5127: ( OE_PRICE_ADJUSTMENTS_S.nextval

5123: ,last_update_login
5124: ,creation_date
5125: ,created_by)
5126: VALUES
5127: ( OE_PRICE_ADJUSTMENTS_S.nextval
5128: ,p_line_adj_rec.cost_id(i)
5129: ,p_line_adj_rec.automatic_flag(i)
5130: ,p_line_adj_rec.list_line_type_code(i)
5131: ,p_line_adj_rec.charge_type_code(i)