55: IF fii_gl_util_pkg.g_mgr_id = -99999 THEN
56:
57:
58: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
59: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
60: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
61: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
62: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
63: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
57:
58: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
59: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
60: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
61: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
62: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
63: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
64: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
65: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' WTD';
59: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
60: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
61: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
62: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
63: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
64: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
65: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' WTD';
66: END IF;
67:
61: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
62: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
63: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
64: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
65: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' WTD';
66: END IF;
67:
68: ELSE
69:
66: END IF;
67:
68: ELSE
69:
70: 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);
71: END IF;
72:
73: RETURN stmt;
74:
84: stmt VARCHAR2(240);
85: BEGIN
86:
87: IF fii_gl_util_pkg.g_time_comp = 'BUDGET' THEN
88: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
89: ELSIF fii_gl_util_pkg.g_mgr_id = -99999 THEN
90:
91:
92: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
89: ELSIF fii_gl_util_pkg.g_mgr_id = -99999 THEN
90:
91:
92: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
93: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
94: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
95: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
96: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
97: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
91:
92: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
93: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
94: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
95: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
96: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
97: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
98: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
99: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' WTD';
93: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' YTD';
94: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR' THEN
95: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
96: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
97: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
98: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
99: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' WTD';
100: END IF;
101:
95: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' QTD';
96: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
97: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' MTD';
98: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_WEEK' THEN
99: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' WTD';
100: END IF;
101:
102: ELSE
103: 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);
99: stmt := fnd_message.get_string('FII', 'FII_GL_PMV')||' WTD';
100: END IF;
101:
102: ELSE
103: 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);
104: END IF;
105:
106: RETURN stmt;
107:
140: l_asof_date:=fii_gl_util_pkg.g_previous_asof_date;
141: END IF;
142:
143: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET' AND p_current = 'N') THEN
144: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
145: ELSE
146: IF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
147: select name into stmt
148: from fii_time_ent_year
163: select substr(week_id,3,2) into l_year
164: from fii_time_week
165: where l_asof_date between start_date and end_date;
166:
167: stmt := fnd_message.get_string('FII', 'FII_AR_WEEK')||' '||l_week||' '||l_year;
168: END IF;
169: END IF;
170: RETURN stmt;
171:
222: stmt VARCHAR2(240);
223: BEGIN
224:
225: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET') THEN
226: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
227: ELSE
228: stmt := fnd_message.get_string('FII', 'FII_GL_PRIOR_MARGIN');
229: END IF;
230:
224:
225: IF (fii_gl_util_pkg.g_time_comp = 'BUDGET') THEN
226: stmt := fnd_message.get_string('FII', 'FII_GL_BUDGET');
227: ELSE
228: stmt := fnd_message.get_string('FII', 'FII_GL_PRIOR_MARGIN');
229: END IF;
230:
231: RETURN stmt;
232: