DBA Data[Home] [Help]

APPS.FII_EA_UTIL_PKG dependencies on FII_EA_UTIL_PKG

Line 1: PACKAGE BODY fii_ea_util_pkg AS

1: PACKAGE BODY fii_ea_util_pkg AS
2: /* $Header: FIIEAUTILB.pls 120.12 2006/07/27 09:27:39 wywong noship $ */
3:
4: g_min_start_date date;
5:

Line 1786: -- IF fii_ea_util_pkg.g_time_comp = 'BUDGET' THEN

1782:
1783: FUNCTION change_label RETURN VARCHAR2 IS
1784: stmt VARCHAR2(240);
1785: BEGIN
1786: -- IF fii_ea_util_pkg.g_time_comp = 'BUDGET' THEN
1787: -- stmt := fnd_message.get_string('FII', 'FII_GL_PCNT_BUDGET');
1788: -- ELSIF fii_ea_util_pkg.g_time_comp = 'FORECAST' THEN
1789: -- stmt := fnd_message.get_string('FII', 'FII_GL_PCNT_FORECAST');
1790: -- ELSE

Line 1788: -- ELSIF fii_ea_util_pkg.g_time_comp = 'FORECAST' THEN

1784: stmt VARCHAR2(240);
1785: BEGIN
1786: -- IF fii_ea_util_pkg.g_time_comp = 'BUDGET' THEN
1787: -- stmt := fnd_message.get_string('FII', 'FII_GL_PCNT_BUDGET');
1788: -- ELSIF fii_ea_util_pkg.g_time_comp = 'FORECAST' THEN
1789: -- stmt := fnd_message.get_string('FII', 'FII_GL_PCNT_FORECAST');
1790: -- ELSE
1791: stmt := fnd_message.get_string('FII', 'FII_GL_CHANGE');
1792: --END IF;

Line 1916: IF fii_ea_util_pkg.g_time_comp = 'BUDGET' THEN

1912: stmt VARCHAR2(240);
1913:
1914: BEGIN
1915:
1916: IF fii_ea_util_pkg.g_time_comp = 'BUDGET' THEN
1917: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
1918: ELSIF fii_ea_util_pkg.g_time_comp = 'FORECAST' THEN
1919: stmt := fnd_message.get_string('FII', 'FII_GL_FORECAST');
1920: ELSIF fii_ea_util_pkg.g_region_code = 'FII_PL_GROSS_MARGIN_SUMM' OR fii_ea_util_pkg.g_region_code = 'FII_PL_OPER_MARGIN_SUMM' THEN

Line 1918: ELSIF fii_ea_util_pkg.g_time_comp = 'FORECAST' THEN

1914: BEGIN
1915:
1916: IF fii_ea_util_pkg.g_time_comp = 'BUDGET' THEN
1917: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
1918: ELSIF fii_ea_util_pkg.g_time_comp = 'FORECAST' THEN
1919: stmt := fnd_message.get_string('FII', 'FII_GL_FORECAST');
1920: ELSIF fii_ea_util_pkg.g_region_code = 'FII_PL_GROSS_MARGIN_SUMM' OR fii_ea_util_pkg.g_region_code = 'FII_PL_OPER_MARGIN_SUMM' THEN
1921: stmt := fnd_message.get_string('FII', 'FII_PL_INCOME');
1922: ELSE

Line 1920: ELSIF fii_ea_util_pkg.g_region_code = 'FII_PL_GROSS_MARGIN_SUMM' OR fii_ea_util_pkg.g_region_code = 'FII_PL_OPER_MARGIN_SUMM' THEN

1916: IF fii_ea_util_pkg.g_time_comp = 'BUDGET' THEN
1917: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
1918: ELSIF fii_ea_util_pkg.g_time_comp = 'FORECAST' THEN
1919: stmt := fnd_message.get_string('FII', 'FII_GL_FORECAST');
1920: ELSIF fii_ea_util_pkg.g_region_code = 'FII_PL_GROSS_MARGIN_SUMM' OR fii_ea_util_pkg.g_region_code = 'FII_PL_OPER_MARGIN_SUMM' THEN
1921: stmt := fnd_message.get_string('FII', 'FII_PL_INCOME');
1922: ELSE
1923: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' ' ||BIS_PMV_PORTAL_UTIL_PUB.getTimeLevelLabel(p_page_id, p_user_id, p_session_id, p_function_name);
1924: END IF;

Line 1934: l_asof_date DATE := fii_ea_util_pkg.g_as_of_date;

1930:
1931: FUNCTION get_rolling_period_label(p_sequence IN VARCHAR2) RETURN VARCHAR2 IS
1932:
1933: stmt VARCHAR2(240);
1934: l_asof_date DATE := fii_ea_util_pkg.g_as_of_date;
1935: l_temp_date DATE := NULL;
1936:
1937: BEGIN
1938:

Line 1939: IF fii_ea_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN

1935: l_temp_date DATE := NULL;
1936:
1937: BEGIN
1938:
1939: IF fii_ea_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
1940:
1941: CASE p_sequence
1942:
1943: WHEN '1' THEN

Line 1963: ELSIF fii_ea_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN

1959: WHERE l_temp_date = END_date;
1960:
1961:
1962:
1963: ELSIF fii_ea_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
1964:
1965: CASE p_sequence
1966:
1967: WHEN '1' THEN

Line 2580: END fii_ea_util_pkg;

2576: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2577:
2578: END bind_variable;
2579:
2580: END fii_ea_util_pkg;