[Home] [Help]
285: END IF;
286:
287:
288: CASE l_page_period_type
289: WHEN 'FII_TIME_WEEK' THEN l_actual_period_type := 32;
290: WHEN 'FII_TIME_ENT_PERIOD' THEN l_actual_period_type := 64;
291: WHEN 'FII_TIME_ENT_QTR' THEN l_actual_period_type := 128;
292: WHEN 'FII_TIME_ENT_YEAR' THEN l_actual_period_type := 256;
293: END CASE;
303: (fii_time_api.ent_pyr_start(l_as_of_date))),l_start_date-1)
304: into l_ent_pyr_start from dual; /* Bug 3325387 */
305:
306: CASE l_page_period_type
307: WHEN 'FII_TIME_WEEK' THEN
308: l_period_type := 16;
309: l_pk := 'week_id';
310: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
311: inv_graph_rec.attribute_value := 'TIME+FII_TIME_WEEK';
307: WHEN 'FII_TIME_WEEK' THEN
308: l_period_type := 16;
309: l_pk := 'week_id';
310: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
311: inv_graph_rec.attribute_value := 'TIME+FII_TIME_WEEK';
312: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
313: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),''&WEEK_NUMBER'',t.sequence)';
314: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
315: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
315: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
316: select nvl(fii_time_api.sd_lyswk(l_p_as_of_date), l_start_date) into l_start from dual;
317: l_begin_date := l_as_of_date - 91;
318: SELECT sequence into l_curr_effective_num
319: FROM fii_time_week
320: WHERE l_as_of_date between start_date AND END_date;
321:
322: WHEN 'FII_TIME_ENT_PERIOD' THEN
323: l_period_type := 32;
773: END LOOP;
774: END IF;
775:
776: CASE l_page_period_type
777: WHEN 'FII_TIME_WEEK' THEN l_actual_period_type := 32;
778: WHEN 'FII_TIME_ENT_PERIOD' THEN l_actual_period_type := 64;
779: WHEN 'FII_TIME_ENT_QTR' THEN l_actual_period_type := 128;
780: WHEN 'FII_TIME_ENT_YEAR' THEN l_actual_period_type := 256;
781: END CASE;
793: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_ent_cyr_start))),l_start_date-1)
794: into l_ent_year_st2 from dual;
795:
796: CASE l_page_period_type
797: WHEN 'FII_TIME_WEEK' THEN
798: l_period_type := 16;
799: l_pk := 'week_id';
800: ltd := '_WTD';
801: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
798: l_period_type := 16;
799: l_pk := 'week_id';
800: ltd := '_WTD';
801: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
802: elec_late_payment_rec.attribute_value := 'TIME+FII_TIME_WEEK';
803: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
804: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),
805: ''&WEEK_NUMBER'',t.sequence)';
806: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
808: select nvl(fii_time_api.sd_lyswk(l_p_as_of_date), l_start_date) into l_start from dual;
809: l_begin_date := l_as_of_date - 91;
810:
811: SELECT sequence into l_curr_effective_num
812: FROM fii_time_week
813: WHERE l_as_of_date between start_date AND END_date;
814:
815: WHEN 'FII_TIME_ENT_PERIOD' THEN
816: l_period_type := 32;