DBA Data[Home] [Help]

APPS.QP_ADJUST_PRICELIST_PVT dependencies on FND_PROFILE

Line 110: l_price_rounding := fnd_profile.value('QP_PRICE_ROUNDING');

106: rounding in the Adjustment module. User should be able to adjust the price
107: by any amount or percent. We will not round that amount. */
108:
109:
110: l_price_rounding := fnd_profile.value('QP_PRICE_ROUNDING');
111:
112: IF l_price_rounding IS NOT NULL THEN --Added for Enhancement 1732601
113:
114: BEGIN

Line 405: IF (NVL(l_amount,0) < 0 And (FND_PROFILE.VALUE('QP_NEGATIVE_PRICING')= 'N')) THEN

401: l_select_stmt := l_select_stmt || l_where_common || ' and m.organization_id = :org_id )'||l_where_select ;
402:
403: END IF; /* If any of the criteria about inventory_item_id is satisfied */
404:
405: IF (NVL(l_amount,0) < 0 And (FND_PROFILE.VALUE('QP_NEGATIVE_PRICING')= 'N')) THEN
406: BEGIN
407: IF l_param_set = 'N' THEN
408: EXECUTE IMMEDIATE l_select_stmt INTO dummy USING
409: p_list_header_id, l_change;