eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIX_PMV_DBI_UTL_PKG dependencies on FII_TIME_DAY

Line 1768: FROM fii_time_day WHERE report_date = l_as_of_date;

1764: BEGIN
1765: CASE l_period_type
1766: WHEN 'FII_TIME_WEEK' THEN
1767: SELECT week_start_date INTO l_period_start_date
1768: FROM fii_time_day WHERE report_date = l_as_of_date;
1769: WHEN 'FII_TIME_ENT_PERIOD' THEN
1770: SELECT ent_period_start_date INTO l_period_start_date
1771: FROM fii_time_day WHERE report_date = l_as_of_date;
1772: WHEN 'FII_TIME_ENT_QTR' THEN

Line 1771: FROM fii_time_day WHERE report_date = l_as_of_date;

1767: SELECT week_start_date INTO l_period_start_date
1768: FROM fii_time_day WHERE report_date = l_as_of_date;
1769: WHEN 'FII_TIME_ENT_PERIOD' THEN
1770: SELECT ent_period_start_date INTO l_period_start_date
1771: FROM fii_time_day WHERE report_date = l_as_of_date;
1772: WHEN 'FII_TIME_ENT_QTR' THEN
1773: SELECT ent_qtr_start_date INTO l_period_start_date
1774: FROM fii_time_day WHERE report_date = l_as_of_date;
1775: WHEN 'FII_TIME_ENT_YEAR' THEN

Line 1774: FROM fii_time_day WHERE report_date = l_as_of_date;

1770: SELECT ent_period_start_date INTO l_period_start_date
1771: FROM fii_time_day WHERE report_date = l_as_of_date;
1772: WHEN 'FII_TIME_ENT_QTR' THEN
1773: SELECT ent_qtr_start_date INTO l_period_start_date
1774: FROM fii_time_day WHERE report_date = l_as_of_date;
1775: WHEN 'FII_TIME_ENT_YEAR' THEN
1776: SELECT ent_year_start_date INTO l_period_start_date
1777: FROM fii_time_day WHERE report_date = l_as_of_date;
1778: ELSE l_period_start_date := null;

Line 1777: FROM fii_time_day WHERE report_date = l_as_of_date;

1773: SELECT ent_qtr_start_date INTO l_period_start_date
1774: FROM fii_time_day WHERE report_date = l_as_of_date;
1775: WHEN 'FII_TIME_ENT_YEAR' THEN
1776: SELECT ent_year_start_date INTO l_period_start_date
1777: FROM fii_time_day WHERE report_date = l_as_of_date;
1778: ELSE l_period_start_date := null;
1779: END CASE;
1780: RETURN l_period_start_date;
1781: EXCEPTION

Line 1958: AND l_period_type <> 'FII_TIME_DAY'

1954: --the following values. If it is not, then we will fail the SQL.
1955: --
1956:
1957: IF l_period_type <> 'FII_TIME_WEEK'
1958: AND l_period_type <> 'FII_TIME_DAY'
1959: AND l_period_type <> 'FII_TIME_ENT_PERIOD'
1960: AND l_period_type <> 'FII_TIME_ENT_QTR'
1961: AND l_period_type <> 'FII_TIME_ENT_YEAR'
1962: THEN

Line 1970: -- WHEN 'FII_TIME_DAY' THEN l_record_type_id := 119;

1966: WHEN 'FII_TIME_WEEK' THEN l_record_type_id := 11;
1967: WHEN 'FII_TIME_ENT_PERIOD' THEN l_record_type_id := 23;
1968: WHEN 'FII_TIME_ENT_QTR' THEN l_record_type_id := 55;
1969: WHEN 'FII_TIME_ENT_YEAR' THEN l_record_type_id := 119;
1970: -- WHEN 'FII_TIME_DAY' THEN l_record_type_id := 119;
1971: ELSE l_record_type_id := null;
1972: END CASE;
1973: EXCEPTION
1974: WHEN OTHERS THEN