APPS.BIX_CAMP_PERF_REPORT dependencies on FND_PROFILE

Line 101: v_user_currency := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');

97: , '1500'
98: , '500,000'
99: );
100: */
101: v_user_currency := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
102: v_global_currency := fnd_profile.value('BIX_DM_PREFERRED_CURRENCY');
103: v_conversion_type := fnd_profile.value( 'BIX_DM_CONVERSION_TYPE' );
104: v_user_def_curr := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
105: v_format_mask := fnd_currency.get_format_mask(v_user_currency, 30 );

Line 102: v_global_currency := fnd_profile.value('BIX_DM_PREFERRED_CURRENCY');

98: , '500,000'
99: );
100: */
101: v_user_currency := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
102: v_global_currency := fnd_profile.value('BIX_DM_PREFERRED_CURRENCY');
103: v_conversion_type := fnd_profile.value( 'BIX_DM_CONVERSION_TYPE' );
104: v_user_def_curr := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
105: v_format_mask := fnd_currency.get_format_mask(v_user_currency, 30 );
106: --to_char( amt, l_format_mask)

Line 103: v_conversion_type := fnd_profile.value( 'BIX_DM_CONVERSION_TYPE' );

99: );
100: */
101: v_user_currency := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
102: v_global_currency := fnd_profile.value('BIX_DM_PREFERRED_CURRENCY');
103: v_conversion_type := fnd_profile.value( 'BIX_DM_CONVERSION_TYPE' );
104: v_user_def_curr := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
105: v_format_mask := fnd_currency.get_format_mask(v_user_currency, 30 );
106: --to_char( amt, l_format_mask)
107: bix_util_pkg.get_conversion_rate(v_global_currency, v_user_currency, sysdate, v_conversion_type, l_denom_rate, l_num_rate, l_status );

Line 104: v_user_def_curr := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');

100: */
101: v_user_currency := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
102: v_global_currency := fnd_profile.value('BIX_DM_PREFERRED_CURRENCY');
103: v_conversion_type := fnd_profile.value( 'BIX_DM_CONVERSION_TYPE' );
104: v_user_def_curr := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
105: v_format_mask := fnd_currency.get_format_mask(v_user_currency, 30 );
106: --to_char( amt, l_format_mask)
107: bix_util_pkg.get_conversion_rate(v_global_currency, v_user_currency, sysdate, v_conversion_type, l_denom_rate, l_num_rate, l_status );
108: if (l_denom_rate = 0 or l_denom_rate is null) then

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

309: v_end_period DATE;
310:
311: BEGIN
312: v_time := 8;
313: SELECT fnd_profile.value('BIX_DM_RPT_TIME_RANGE')
314: INTO g_time_range
315: FROM dual;
316:
317: IF g_time_range IS NULL THEN