APPS.MSC_EXCEPTION_PKG dependencies on FND_PROFILE

Line 91: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1, nvl(mcc.CONV_RATE,0))

87: exception_tbl.exception_count,
88: exception_tbl.exception_value,
89: exception_tbl.exception_value
90: * decode(exception_tbl.currency_code,
91: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1, nvl(mcc.CONV_RATE,0))
92: exception_value2,
93: exception_tbl.exception_days,
94: exception_tbl.exception_quantity,
95: exception_tbl.exception_ratio,

Line 590: and mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')

586: t.exception_type
587: ) exception_tbl,
588: msc_currency_conv_mv mcc
589: where mcc.from_currency(+) = exception_tbl.currency_code
590: and mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
591: and mcc.calendar_date(+) = exception_tbl.analysis_date;
592:
593: msc_phub_util.log('msc_exceptions_f, insert='||sql%rowcount);
594: commit;

Line 611: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');

607:
608: procedure summarize_exceptions_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
609: p_plan_id number, p_plan_run_id number)
610: is
611: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
612: begin
613: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f');
614: retcode := 0;
615: errbuf := '';