APPS.HXC_SUPERVISOR_DASHBOARD dependencies on FND_PROFILE

Line 227: WHERE trunc (((p_start_date - 1) + ((p_year_days / p_number_per_fiscal_year) * (level - 1))) + (p_year_days / p_number_per_fiscal_year)) <= to_date (p_end_date, fnd_profile.value ('ICX_DATE_FORMAT_MASK'))

223: , p_year_days IN number) IS
224: SELECT trunc (((p_start_date - 1) + (p_year_days / p_number_per_fiscal_year) * (level - 1)) + 1)
225: , trunc (((p_start_date - 1) + ((p_year_days / p_number_per_fiscal_year) * (level - 1))) + (p_year_days / p_number_per_fiscal_year))
226: FROM dual
227: WHERE trunc (((p_start_date - 1) + ((p_year_days / p_number_per_fiscal_year) * (level - 1))) + (p_year_days / p_number_per_fiscal_year)) <= to_date (p_end_date, fnd_profile.value ('ICX_DATE_FORMAT_MASK'))
228: CONNECT BY level <= (p_number_per_fiscal_year + 1);
229:
230: CURSOR c_get_monthly_periods(p_start_date DATE, p_end_date DATE)
231: IS

Line 3176: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);

3172: WHERE location_id = p_location
3173: AND language = userenv('LANG');
3174: END IF;
3175:
3176: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_icx_date_format);
3177: l_language_code := USERENV('LANG');
3178:
3179: IF g_debug THEN
3180: l_proc := g_package||' Generating XML';