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
183: G_TRACE_ON := TRUE;
184: ELSE
Line 641: FROM dual;
637: --
638: BEGIN
639: SELECT NVL(fnd_profile.value('PO_VMI_ENABLED'),'N')
640: INTO l_vmi_enabled 641: FROM dual; 642:
643: EXCEPTION
644: WHEN OTHERS THEN
645: l_vmi_enabled := 'N';