289: SELECT NVL(fii_time_api.ent_sd_lysper_end(g_sd_prior), g_min_start_date) INTO g_sd_prior_prior FROM DUAL;
290: SELECT fii_time_api.ent_cper_end(g_sd_prior)+1 INTO g_sd_curr_sdate FROM DUAL;
291: END IF;
292:
293: g_self_msg := FND_MESSAGE.get_string('FII', 'FII_AR_SELF');
294:
295: CASE g_view_by
296: WHEN 'CUSTOMER+FII_CUSTOMERS' THEN
297: IF g_is_hierarchical_flag = 'Y' THEN
354: FUNCTION get_trend_viewby return VARCHAR2 IS
355: BEGIN
356:
357: IF g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
358: return(fnd_message.get_string('FII', 'FII_AR_DBI_YEAR'));
359: ELSIF g_page_period_type = 'FII_TIME_ENT_QTR' THEN
360: return(fnd_message.get_string('FII', 'FII_AR_DBI_QUARTER'));
361: ELSIF g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
362: return(fnd_message.get_string('FII', 'FII_AR_DBI_MONTH'));
356:
357: IF g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
358: return(fnd_message.get_string('FII', 'FII_AR_DBI_YEAR'));
359: ELSIF g_page_period_type = 'FII_TIME_ENT_QTR' THEN
360: return(fnd_message.get_string('FII', 'FII_AR_DBI_QUARTER'));
361: ELSIF g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
362: return(fnd_message.get_string('FII', 'FII_AR_DBI_MONTH'));
363: ELSIF g_page_period_type = 'FII_TIME_WEEK' THEN
364: return(fnd_message.get_string('FII', 'FII_AR_DBI_WEEK'));
358: return(fnd_message.get_string('FII', 'FII_AR_DBI_YEAR'));
359: ELSIF g_page_period_type = 'FII_TIME_ENT_QTR' THEN
360: return(fnd_message.get_string('FII', 'FII_AR_DBI_QUARTER'));
361: ELSIF g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
362: return(fnd_message.get_string('FII', 'FII_AR_DBI_MONTH'));
363: ELSIF g_page_period_type = 'FII_TIME_WEEK' THEN
364: return(fnd_message.get_string('FII', 'FII_AR_DBI_WEEK'));
365: END IF;
366:
360: return(fnd_message.get_string('FII', 'FII_AR_DBI_QUARTER'));
361: ELSIF g_page_period_type = 'FII_TIME_ENT_PERIOD' THEN
362: return(fnd_message.get_string('FII', 'FII_AR_DBI_MONTH'));
363: ELSIF g_page_period_type = 'FII_TIME_WEEK' THEN
364: return(fnd_message.get_string('FII', 'FII_AR_DBI_WEEK'));
365: END IF;
366:
367: END get_trend_viewby;
368:
853: l_all_org_flag VARCHAR2(30);
854: l_business_group_id NUMBER;
855: l_org_count NUMBER;
856: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
857: l_unid_message VARCHAR2(30) := FND_MESSAGE.get_string('FII', 'FII_AR_UNID_CUSTOMER');
858: l_unassigned_message VARCHAR2(30) := FND_MESSAGE.get_string('BIS', 'EDW_UNASSIGNED');
859:
860: i number;
861:
854: l_business_group_id NUMBER;
855: l_org_count NUMBER;
856: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
857: l_unid_message VARCHAR2(30) := FND_MESSAGE.get_string('FII', 'FII_AR_UNID_CUSTOMER');
858: l_unassigned_message VARCHAR2(30) := FND_MESSAGE.get_string('BIS', 'EDW_UNASSIGNED');
859:
860: i number;
861:
862: TYPE larray IS TABLE OF VARCHAR2(3000) INDEX BY BINARY_INTEGER;