APPS.ENI_DBI_UTIL_PKG dependencies on FII_TIME_ENT_YEAR

Line 46: WHEN 'FII_TIME_ENT_YEAR' THEN

42: END LOOP;
43:
44: IF l_time_level_value IS NOT NULL THEN
45: CASE (l_time_level_value)
46: WHEN 'FII_TIME_ENT_YEAR' THEN
47: l_Label:=G_YTD_Label;
48: WHEN 'FII_TIME_ENT_QTR' THEN
49: l_Label:=G_QTD_Label;
50: WHEN 'FII_TIME_ENT_PERIOD' THEN

Line 208: ELSIF p_period_type = 'FII_TIME_ENT_YEAR' THEN

204: ELSIF p_period_type = 'FII_TIME_ENT_PERIOD' THEN
205: l_comp_where := 'AND c.ent_period_id = p.ent_period_id + 1000';
206: ELSIF p_period_type = 'FII_TIME_ENT_QTR' THEN
207: l_comp_where := 'AND c.ent_qtr_id = p.ent_qtr_id + 10';
208: ELSIF p_period_type = 'FII_TIME_ENT_YEAR' THEN
209: l_comp_where := 'AND c.ent_year_id = p.ent_year_id + 1';
210: END IF;
211:
212: -- aggregate measures

Line 370: ELSIF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_YEAR_FROM' THEN

366: ELSIF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_QTR_FROM' THEN
367: p_cur_period := p_page_parameter_tbl(i).parameter_id;
368: p_id_column := 'ent_qtr_id';
369: l_rolling := 'ENTERPRISE';
370: ELSIF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_YEAR_FROM' THEN
371: p_cur_period := p_page_parameter_tbl(i).parameter_id;
372: p_id_column := 'ent_year_id';
373: l_rolling := 'ENTERPRISE';
374: ELSIF p_page_parameter_tbl(i).parameter_name = 'ORDERBY' THEN

Line 452: WHEN 'FII_TIME_ENT_YEAR' THEN

448: select (p_as_of_date - start_date) into p_days_into_period from fii_time_ent_period where ent_period_id = p_cur_period;
449: WHEN 'FII_TIME_ENT_QTR' THEN
450: p_period_bitand := 55;
451: select (p_as_of_date - start_date) into p_days_into_period from fii_time_ent_qtr where ent_qtr_id = p_cur_period;
452: WHEN 'FII_TIME_ENT_YEAR' THEN
453: p_period_bitand := 119;
454: select (p_as_of_date - start_date) into p_days_into_period from fii_time_ent_year where ent_year_id = p_cur_period;
455: WHEN 'FII_ROLLING_WEEK' THEN
456: p_period_bitand := 1024;

Line 454: select (p_as_of_date - start_date) into p_days_into_period from fii_time_ent_year where ent_year_id = p_cur_period;

450: p_period_bitand := 55;
451: select (p_as_of_date - start_date) into p_days_into_period from fii_time_ent_qtr where ent_qtr_id = p_cur_period;
452: WHEN 'FII_TIME_ENT_YEAR' THEN
453: p_period_bitand := 119;
454: select (p_as_of_date - start_date) into p_days_into_period from fii_time_ent_year where ent_year_id = p_cur_period;
455: WHEN 'FII_ROLLING_WEEK' THEN
456: p_period_bitand := 1024;
457: p_days_into_period := 7; -- Added to fix Bug # 3472006
458: WHEN 'FII_ROLLING_MONTH' THEN