APPS.FII_EA_UTIL_PKG dependencies on FND_PROFILE

Line 218: BUDGET_TIME_UNIT := NVL(FND_PROFILE.Value( 'FII_BUDGET_TIME_UNIT'),'P');

214: -- Added for P&L Analysis
215: -- Get budget/forecast levels FROM profile options
216: -- Default assume budget & forecast are loaded at period level
217: -- -----------------------------------------------------------
218: BUDGET_TIME_UNIT := NVL(FND_PROFILE.Value( 'FII_BUDGET_TIME_UNIT'),'P');
219: FORECAST_TIME_UNIT := NVL(FND_PROFILE.Value( 'FII_FORECAST_TIME_UNIT'),'P');
220:
221: SELECT nvl(min(start_date), trunc(sysdate)) INTO g_min_start_date
222: FROM fii_time_ent_period;

Line 219: FORECAST_TIME_UNIT := NVL(FND_PROFILE.Value( 'FII_FORECAST_TIME_UNIT'),'P');

215: -- Get budget/forecast levels FROM profile options
216: -- Default assume budget & forecast are loaded at period level
217: -- -----------------------------------------------------------
218: BUDGET_TIME_UNIT := NVL(FND_PROFILE.Value( 'FII_BUDGET_TIME_UNIT'),'P');
219: FORECAST_TIME_UNIT := NVL(FND_PROFILE.Value( 'FII_FORECAST_TIME_UNIT'),'P');
220:
221: SELECT nvl(min(start_date), trunc(sysdate)) INTO g_min_start_date
222: FROM fii_time_ent_period;
223:

Line 237: g_as_of_date := nvl(to_date(FND_PROFILE.value('FII_TEST_SYSDATE'), 'DD/MM/YYYY'),trunc(sysdate));

233: ELSIF g_as_of_date < trunc(sysdate) AND g_as_of_date >= l_sys_month_start THEN
234: SELECT NVL(fii_time_api.ent_pper_END(g_as_of_date),l_max_end_date) INTO g_as_of_date FROM dual;
235: g_bud_as_of_date := g_as_of_date;
236: ELSIF g_as_of_date = trunc(sysdate) THEN
237: g_as_of_date := nvl(to_date(FND_PROFILE.value('FII_TEST_SYSDATE'), 'DD/MM/YYYY'),trunc(sysdate));
238: SELECT NVL(fii_time_api.ent_cper_END(g_as_of_date),l_max_end_date) INTO g_bud_as_of_date FROM dual;
239: g_snapshot := 'Y';
240: IF l_period_count = 0 THEN --time dimension is null, so join to fii_time_structures which is null to report no data found.
241: g_snapshot := 'N';

Line 484: g_amount_type := NVL(FND_PROFILE.value('FII_PSI_AMOUNT_TYPE'), 'YTD');

480: END CASE;
481:
482: FII_GL_EXTRACTION_UTIL.get_unassigned_id(g_unassigned_id, l_unassigned_vset_id, l_retcode);
483:
484: g_amount_type := NVL(FND_PROFILE.value('FII_PSI_AMOUNT_TYPE'), 'YTD');
485: g_boundary := NVL(FND_PROFILE.value('FII_PSI_BOUNDARY'), 'Y');
486:
487: IF g_boundary = 'P' THEN
488: g_boundary_end := NVL(fii_time_api.ent_cper_end(g_as_of_date), g_min_start_date);

Line 485: g_boundary := NVL(FND_PROFILE.value('FII_PSI_BOUNDARY'), 'Y');

481:
482: FII_GL_EXTRACTION_UTIL.get_unassigned_id(g_unassigned_id, l_unassigned_vset_id, l_retcode);
483:
484: g_amount_type := NVL(FND_PROFILE.value('FII_PSI_AMOUNT_TYPE'), 'YTD');
485: g_boundary := NVL(FND_PROFILE.value('FII_PSI_BOUNDARY'), 'Y');
486:
487: IF g_boundary = 'P' THEN
488: g_boundary_end := NVL(fii_time_api.ent_cper_end(g_as_of_date), g_min_start_date);
489: g_prior_boundary_end := NVL(fii_time_api.ent_cper_end(g_previous_asof_date), g_min_start_date);

Line 1127: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');

1123: l_viewbydim VARCHAR2(10000);
1124: l_fud1_enabled_flag VARCHAR2(1); -- flag to check if fud1 is enabled
1125: l_fud2_enabled_flag VARCHAR2(1);
1126: l_schema_name VARCHAR2(10);
1127: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
1128:
1129: -- definition of company cursor
1130:
1131: CURSOR company_cursor IS

Line 2001: l_industry := fnd_profile.value('INDUSTRY');

1997: l_company_name VARCHAR2(2000);
1998:
1999: BEGIN
2000:
2001: l_industry := fnd_profile.value('INDUSTRY');
2002:
2003: IF l_industry = 'G' THEN
2004: l_company_name := fnd_message.get_string('FII','FII_DIM_FUND');
2005: ELSE