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 2509: l_round_reord_qty := NVL(FND_PROFILE.VALUE('INV_ROUND_REORDER_QTY'), 'Y');

2505: END if;
2506:
2507: IF l_fix_mult > 0
2508: THEN
2509: l_round_reord_qty := NVL(FND_PROFILE.VALUE('INV_ROUND_REORDER_QTY'), 'Y');
2510:
2511: IF G_TRACE_ON = 1 THEN
2512: print_debug('l_round_reord_qty: ' || l_round_reord_qty, 'get_reord_qty', 9);
2513: END IF;

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

4163: END IF;
4164:
4165: /* Added for Bug 6807835 */
4166:
4167: IF(to_number(NVL(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'),0)) = 1 ) THEN
4168: l_scheduling_method := 1;
4169: ELSE
4170: l_scheduling_method := 2;
4171: END IF;

Line 4179: /* select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval

4175:
4176: l_mode_flag := 1;
4177:
4178: /*Bug 15837698 Moved this part just before inserting into wsm_lot_job_interface*/
4179: /* select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
4180: INTO l_job_name
4181: from dual;
4182:
4183: print_debug('OSFM Job Name '||l_job_name

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

4263: IF l_is_lot_control = 'Y' THEN
4264:
4265: /*Bug 15837698 If it is a lot controlled item, only then use wip_job_number_s.nextval
4266: before inserting data into WSM_LOT_JOB_INTERFACE */
4267: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
4268: INTO l_job_name
4269: from dual;
4270:
4271: print_debug('OSFM Job Name '||l_job_name , 're_wip', 9);

Line 4459: fnd_profile.initialize(p_user_id);

4455: , 're_batch', 9);
4456: END IF;
4457: RAISE batch_exc;
4458: ELSE
4459: fnd_profile.initialize(p_user_id);
4460:
4461: l_gme_batch_header.organization_id := p_organization_id;
4462: l_gme_batch_header.plan_cmplt_date := p_nb_time;
4463: l_gme_batch_header.due_date := p_nb_time;