DBA Data[Home] [Help]

APPS.CSP_MINMAX_PVT dependencies on FND_PROFILE

Line 178: SELECT NVL(fnd_profile.value('INV_DEBUG_TRACE'),'2')

174: INTO G_USER_NAME
175: FROM fnd_user
176: WHERE user_id = p_user_id;
177:
178: SELECT NVL(fnd_profile.value('INV_DEBUG_TRACE'),'2')
179: INTO l_inv_debug
180: FROM dual;
181:
182: IF l_inv_debug = 1 THEN

Line 639: SELECT NVL(fnd_profile.value('PO_VMI_ENABLED'),'N')

635: --
636: -- Determine if we need to account for VMI
637: --
638: BEGIN
639: SELECT NVL(fnd_profile.value('PO_VMI_ENABLED'),'N')
640: INTO l_vmi_enabled
641: FROM dual;
642:
643: EXCEPTION

Line 2204: round_reord_qty := NVL(FND_PROFILE.VALUE('INV_ROUND_REORDER_QTY'), 'Y');

2200: END if;
2201:
2202: IF l_fix_mult > 0
2203: THEN
2204: round_reord_qty := NVL(FND_PROFILE.VALUE('INV_ROUND_REORDER_QTY'), 'Y');
2205: print_debug('round_reord_qty: ' || round_reord_qty, 'get_reord_qty', 9);
2206:
2207: IF round_reord_qty = 'N'
2208: THEN