DBA Data[Home] [Help]

APPS.INV_MMX_WRAPPER_PVT dependencies on FND_PROFILE

Line 19: G_TRACE_ON NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),2);

15: -- Find the user name, INV debug profile setting
16: --
17:
18: G_USER_NAME fnd_user.user_name%TYPE := FND_GLOBAL.USER_NAME;
19: G_TRACE_ON NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),2);
20:
21:
22: PROCEDURE print_debug
23: ( p_message IN VARCHAR2

Line 342: -- l_pur_revision := NVL(P_PUR_REVISION,NVL(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)) ;

338:
339: --
340: -- If the value of P_PUR_REVISION has not been initialized, set it to 'No'.
341: --
342: -- l_pur_revision := NVL(P_PUR_REVISION,NVL(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)) ;
343: /* Commented NVL for bug 11695871 */
344:
345: l_pur_revision := NVL(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2) ;
346:

Line 345: l_pur_revision := NVL(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2) ;

341: --
342: -- l_pur_revision := NVL(P_PUR_REVISION,NVL(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2)) ;
343: /* Commented NVL for bug 11695871 */
344:
345: l_pur_revision := NVL(fnd_profile.value('INV_PURCHASING_BY_REVISION'),2) ;
346:
347: IF G_TRACE_ON = 1 THEN
348: print_debug('Profile PUR_REVISION is: ' || l_pur_revision
349: ,l_proc

Line 481: l_approval := to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'2'));

477: -- 1- Pre-approve d
478: -- 2- Pre-approve move orders only
479: -- 3- Approval Required
480: --
481: l_approval := to_number(nvl(FND_PROFILE.VALUE('INV_MINMAX_REORDER_APPROVED'),'2'));
482: IF G_TRACE_ON = 1 THEN
483: print_debug('APPROVAL STATUS is: ' || l_approval
484: ,l_proc
485: , 9);