APPS.MSC_RESOURCE_PKG dependencies on FND_PROFILE

Line 18: l_enable_num number := nvl(fnd_profile.value('MSC_APCC_ENABLE_CUM'), 1);

14: l_owning_currency_code varchar2(20) := msc_phub_util.get_owning_currency_code(p_plan_run_id);
15: l_transfer_id number := null;
16: l_constrained_plan number := null;
17: l_start_time timestamp := systimestamp;
18: l_enable_num number := nvl(fnd_profile.value('MSC_APCC_ENABLE_CUM'), 1);
19: begin
20: msc_phub_util.log('msc_resource_pkg.populate_details');
21: l_constrained_plan := msc_phub_util.is_plan_constrained(p_plan_id);
22: retcode := 0;

Line 299: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) resource_cost2,

295: t1.available_hours,
296: t1.setup_hours setup_time_hrs,
297: t1.resource_cost,
298: t1.resource_cost * decode(decode(l_plan_type, 6, l_owning_currency_code, t1.currency_code),
299: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) resource_cost2,
300: fnd_global.user_id, sysdate,
301: sysdate, fnd_global.user_id, fnd_global.login_id,
302: fnd_global.conc_program_id, fnd_global.conc_login_id,
303: fnd_global.prog_appl_id, fnd_global.conc_request_id

Line 354: where mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')

350: and mtp.partner_type(+) = 3
351: and mbid.production_cost>0
352: ) t1,
353: msc_currency_conv_mv mcc
354: where mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
355: and mcc.from_currency(+) = decode(l_plan_type, 6, l_owning_currency_code, t1.currency_code)
356: and mcc.calendar_date(+) = t1.resource_date
357: and p_plan_id <> -1;
358: