7: FUNCTION get_view_by return VARCHAR2 IS
8: BEGIN
9:
10: IF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_WEEK') THEN
11: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_WEEK');
12: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD') THEN
13: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_MONTH');
14: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR') THEN
15: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_QUARTER');
9:
10: IF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_WEEK') THEN
11: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_WEEK');
12: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD') THEN
13: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_MONTH');
14: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR') THEN
15: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_QUARTER');
16: ELSE
17: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_YEAR');
11: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_WEEK');
12: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD') THEN
13: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_MONTH');
14: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR') THEN
15: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_QUARTER');
16: ELSE
17: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_YEAR');
18: END IF;
19:
13: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_MONTH');
14: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR') THEN
15: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_QUARTER');
16: ELSE
17: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_YEAR');
18: END IF;
19:
20: END get_view_by;
21: