APPS.BIX_KPI_CLS_RPT_PKG dependencies on FND_PROFILE

Line 19: SELECT fnd_profile.value('BIX_DM_CURR_CONVERSION_TYPE')

15: l_conv_type VARCHAR2(30);
16: l_status NUMBER;
17: BEGIN
18: /* Get the BIX conversion type */
19: SELECT fnd_profile.value('BIX_DM_CURR_CONVERSION_TYPE')
20: INTO l_conv_type
21: FROM dual;
22:
23: /* Get the exchange rate as per sysdate */

Line 55: SELECT fnd_profile.value('BIX_DM_RPT_TIME_RANGE')

51: BEGIN
52: g_sqlstmt := NULL;
53:
54: /* Fetch the time range (1 hour or 2 hour etc. ) preference of the user */
55: SELECT fnd_profile.value('BIX_DM_RPT_TIME_RANGE')
56: INTO l_time_range
57: FROM dual;
58:
59: /* If the user has not specified any time range then

Line 300: g_date_format_mask := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');

296: FROM dual;
297:
298:
299: /* Get the JTF profile date format from the Profile */
300: g_date_format_mask := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
301:
302: /* Parse all the parameter values from the variable p_context */
303: l_classification_parent := bix_util_pkg.get_parameter_value(
304: p_context, 'pContext');

Line 390: SELECT fnd_profile.value('BIX_DM_PREFERRED_CURRENCY')

386: WHERE report_code = 'BIX_KPI_CLS_RPT'
387: AND session_id = l_session_id;
388:
389: /* Get the BIX global currency */
390: SELECT fnd_profile.value('BIX_DM_PREFERRED_CURRENCY')
391: INTO l_global_currency
392: FROM dual;
393:
394: /* Get the user currency */

Line 395: SELECT fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY')

391: INTO l_global_currency
392: FROM dual;
393:
394: /* Get the user currency */
395: SELECT fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY')
396: INTO l_user_currency
397: FROM dual;
398:
399: IF l_user_currency <> l_global_currency