DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on OE_PRICE_ADJUSTMENTS_S

Line 768: SELECT Oe_Price_Adjustments_S.Nextval

764: l_line_adj_tbl(i).line_id := p_line_id;
765: l_line_adj_tbl(i).header_id := p_header_id;
766: l_line_adj_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
767:
768: SELECT Oe_Price_Adjustments_S.Nextval
769: INTO l_line_adj_tbl(i).price_adjustment_id
770: FROM dual;
771:
772: OE_LINE_ADJ_UTIL.Insert_Row(l_line_adj_tbl(i));

Line 2169: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id

2165: , LOCK_CONTROL
2166: , retrobill_request_id
2167: )
2168: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2169: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2170: , sysdate --p_Line_Adj_rec.creation_date
2171: , fnd_global.user_id --p_Line_Adj_rec.created_by
2172: , sysdate --p_Line_Adj_rec.last_update_date
2173: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by

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

2542: , LOCK_CONTROL
2543: , RETROBILL_REQUEST_ID
2544: )
2545: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2546: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2547: ldets.price_adjustment_id
2548: , sysdate --p_Line_Adj_rec.creation_date
2549: , fnd_global.user_id --p_Line_Adj_rec.created_by
2550: , sysdate --p_Line_Adj_rec.last_update_date

Line 2841: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id

2837: , LOCK_CONTROL
2838: , RETROBILL_REQUEST_ID
2839: )
2840: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2841: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2842: , sysdate --p_Line_Adj_rec.creation_date
2843: , fnd_global.user_id --p_Line_Adj_rec.created_by
2844: , sysdate --p_Line_Adj_rec.last_update_date
2845: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by