DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on FND_PROFILE

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

5: -- Replenishment Move Order Consolidation
6: -- Initialize the Global variables to the values set in INV_MMX_WRAPPER_PVT.
7: --
8: G_USER_NAME fnd_user.user_name%TYPE := FND_GLOBAL.USER_NAME;
9: G_TRACE_ON NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),2);
10:
11:
12:
13: TYPE minmax_items_rectype IS RECORD

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

680: --
681: BEGIN
682: IF p_level = 1 THEN --only for org level; default is 'N'
683:
684: SELECT NVL(fnd_profile.value('PO_VMI_ENABLED'),'N')
685: INTO l_vmi_enabled
686: FROM dual;
687: END IF;
688:

Line 2499: l_round_reord_qty := NVL(FND_PROFILE.VALUE('INV_ROUND_REORDER_QTY'), 'Y');

2495: END if;
2496:
2497: IF l_fix_mult > 0
2498: THEN
2499: l_round_reord_qty := NVL(FND_PROFILE.VALUE('INV_ROUND_REORDER_QTY'), 'Y');
2500:
2501: IF G_TRACE_ON = 1 THEN
2502: print_debug('l_round_reord_qty: ' || l_round_reord_qty, 'get_reord_qty', 9);
2503: END IF;

Line 4160: IF(to_number(NVL(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'),0)) = 1 ) THEN

4156: END IF;
4157:
4158: /* Added for Bug 6807835 */
4159:
4160: IF(to_number(NVL(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'),0)) = 1 ) THEN
4161: l_scheduling_method := 1;
4162: ELSE
4163: l_scheduling_method := 2;
4164: END IF;

Line 4171: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval

4167: from dual;
4168:
4169: l_mode_flag := 1;
4170:
4171: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
4172: INTO l_job_name
4173: from dual;
4174:
4175: print_debug('OSFM Job Name '||l_job_name

Line 4439: fnd_profile.initialize(p_user_id);

4435: , 're_batch', 9);
4436: END IF;
4437: RAISE batch_exc;
4438: ELSE
4439: fnd_profile.initialize(p_user_id);
4440:
4441: l_gme_batch_header.organization_id := p_organization_id;
4442: l_gme_batch_header.plan_cmplt_date := p_nb_time;
4443: l_gme_batch_header.due_date := p_nb_time;