DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on OE_PRICE_ADJUSTMENTS_S

Line 756: SELECT Oe_Price_Adjustments_S.Nextval

752: l_line_adj_tbl(i).line_id := p_line_id;
753: l_line_adj_tbl(i).header_id := p_header_id;
754: l_line_adj_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
755:
756: SELECT Oe_Price_Adjustments_S.Nextval
757: INTO l_line_adj_tbl(i).price_adjustment_id
758: FROM dual;
759:
760: OE_LINE_ADJ_UTIL.Insert_Row(l_line_adj_tbl(i));

Line 1831: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id

1827: , LOCK_CONTROL
1828: , retrobill_request_id
1829: )
1830: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
1831: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
1832: , sysdate --p_Line_Adj_rec.creation_date
1833: , fnd_global.user_id --p_Line_Adj_rec.created_by
1834: , sysdate --p_Line_Adj_rec.last_update_date
1835: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by

Line 2208: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id

2204: , LOCK_CONTROL
2205: , RETROBILL_REQUEST_ID
2206: )
2207: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2208: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2209: ldets.price_adjustment_id
2210: , sysdate --p_Line_Adj_rec.creation_date
2211: , fnd_global.user_id --p_Line_Adj_rec.created_by
2212: , sysdate --p_Line_Adj_rec.last_update_date

Line 2503: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id

2499: , LOCK_CONTROL
2500: , RETROBILL_REQUEST_ID
2501: )
2502: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2503: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2504: , sysdate --p_Line_Adj_rec.creation_date
2505: , fnd_global.user_id --p_Line_Adj_rec.created_by
2506: , sysdate --p_Line_Adj_rec.last_update_date
2507: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by