502: ELSIF g_amount_type ='YTD' THEN
503: g_amount_type_bitand := 256;
504: END IF;
505:
506: g_dir_msg := FND_MESSAGE.get_string('FII', 'FII_GL_DIR');
507:
508: END get_parameters;
509:
510:
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
1791: stmt := fnd_message.get_string('FII', 'FII_GL_CHANGE');
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;
1793:
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;
1793:
1794: return stmt;
1795:
1896:
1897: stmt VARCHAR2(240);
1898:
1899: BEGIN
1900: 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);
1901:
1902: RETURN stmt;
1903:
1904: END prior_xtd;
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
1921: stmt := fnd_message.get_string('FII', 'FII_PL_INCOME');
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
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);
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;
1925:
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;
1925:
1926: RETURN stmt;
1927:
1946: l_temp_date := fii_time_api.ent_pqtr_END(fii_time_api.ent_pqtr_END(l_asof_date));
1947: WHEN '3' THEN
1948: l_temp_date := fii_time_api.ent_pqtr_END(l_asof_date);
1949: WHEN '4' THEN
1950: stmt := FND_Message.get_string('FII', 'FII_QTD');
1951: RETURN stmt;
1952: ELSE
1953: RETURN NULL;
1954:
1970: l_temp_date := fii_time_api.ent_pper_END(fii_time_api.ent_pper_END(l_asof_date));
1971: WHEN '3' THEN
1972: l_temp_date := fii_time_api.ent_pper_END(l_asof_date);
1973: WHEN '4' THEN
1974: stmt := FND_Message.get_string('FII', 'FII_MTD');
1975: RETURN stmt;
1976: ELSE
1977: RETURN NULL;
1978:
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
2006: l_company_name := fnd_message.get_string('FII','FII_DIM_COMPANY');
2007: END IF;
2008:
2002:
2003: IF l_industry = 'G' THEN
2004: l_company_name := fnd_message.get_string('FII','FII_DIM_FUND');
2005: ELSE
2006: l_company_name := fnd_message.get_string('FII','FII_DIM_COMPANY');
2007: END IF;
2008:
2009: RETURN l_company_name;
2010: