DBA Data[Home] [Help]

APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on OE_PRICE_ADJUSTMENTS_S

Line 3180: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL

3176: LOOP
3177: --
3178: BEGIN
3179: --
3180: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3181: INTO l_header_adj_tbl(I).price_adjustment_id
3182: FROM DUAL;
3183: --
3184: l_header_adj_tbl(I).header_id := l_header_rec.header_id;

Line 3448: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL

3444: LOOP
3445: --
3446: IF l_adj_line_ref_tbl(K) = l_line_tbl(I).orig_sys_line_ref THEN
3447: --
3448: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3449: INTO l_line_adj_tbl(K).price_adjustment_id
3450: FROM DUAL;
3451: --
3452: l_line_adj_tbl(K).header_id := l_header_rec.header_id;

Line 3630: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL

3626: BEGIN
3627: --
3628: IF l_adj_line_ref_tbl(K) = l_line_tbl(L).orig_sys_line_ref THEN
3629: --
3630: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3631: INTO l_line_adj_tbl(K).price_adjustment_id
3632: FROM DUAL;
3633: --
3634: l_line_adj_tbl(K).header_id := l_header_rec.header_id;