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
401: l_select_stmt := l_select_stmt || l_where_common || ' )'||l_where_select ; --8688432
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;