DBA Data[Home] [Help]

APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on OE_PRICE_ADJUSTMENTS_S

Line 3176: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL

3172: LOOP
3173: --
3174: BEGIN
3175: --
3176: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3177: INTO l_header_adj_tbl(I).price_adjustment_id
3178: FROM DUAL;
3179: --
3180: l_header_adj_tbl(I).header_id := l_header_rec.header_id;

Line 3394: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL

3390: LOOP
3391: --
3392: IF l_adj_line_ref_tbl(K) = l_line_tbl(I).orig_sys_line_ref THEN
3393: --
3394: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3395: INTO l_line_adj_tbl(K).price_adjustment_id
3396: FROM DUAL;
3397: --
3398: l_line_adj_tbl(K).header_id := l_header_rec.header_id;

Line 3561: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL

3557: BEGIN
3558: --
3559: IF l_adj_line_ref_tbl(K) = l_line_tbl(L).orig_sys_line_ref THEN
3560: --
3561: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3562: INTO l_line_adj_tbl(K).price_adjustment_id
3563: FROM DUAL;
3564: --
3565: l_line_adj_tbl(K).header_id := l_header_rec.header_id;