DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_PRICE_ADJUSTMENTS_S

Line 5695: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;

5691: /* end if condition for line level freight charge */
5692: END LOOP; --l_l_line_adj_tbl for
5693: END IF; --l_l_line_adj_tbl.COUNT > 0
5694: IF l_match_flag = 'N' THEN
5695: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;
5696: l_adj_rec.parent_adjustment_id := NULL;
5697: l_adj_rec.price_adjustment_id := l_price_adjustment_id;
5698: l_adj_rec.header_id := l_tax_rec_out_tbl(i).trx_id;
5699: l_adj_rec.last_update_date := SYSDATE;

Line 5893: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;

5889: END IF;
5890: /* end if condition for Header level freight charge */
5891: END LOOP; --l_l_header_adj_tbl for
5892: IF l_match_flag = 'N' AND l_tax_rec_out_tbl(i).line_id IS NULL THEN --TaxER
5893: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;
5894: --TaxER start
5895: l_h_adj_rec.parent_adjustment_id := NULL;
5896: l_h_adj_rec.price_adjustment_id := l_price_adjustment_id;
5897: l_h_adj_rec.header_id := l_tax_rec_out_tbl(i).trx_id;