eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_PMV_DBI_UTL_PKG dependencies on FII_TIME_API

Line 257: WHEN 'FII_TIME_WEEK' THEN l_date := FII_TIME_API.Cwk_Start(l_as_of_date);

253:
254: BEGIN
255:
256: CASE l_period_type
257: WHEN 'FII_TIME_WEEK' THEN l_date := FII_TIME_API.Cwk_Start(l_as_of_date);
258: WHEN 'FII_TIME_ENT_PERIOD' THEN l_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
259: WHEN 'FII_TIME_ENT_QTR' THEN l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
260: WHEN 'FII_TIME_ENT_YEAR' THEN l_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
261: ELSE l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);

Line 258: WHEN 'FII_TIME_ENT_PERIOD' THEN l_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);

254: BEGIN
255:
256: CASE l_period_type
257: WHEN 'FII_TIME_WEEK' THEN l_date := FII_TIME_API.Cwk_Start(l_as_of_date);
258: WHEN 'FII_TIME_ENT_PERIOD' THEN l_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
259: WHEN 'FII_TIME_ENT_QTR' THEN l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
260: WHEN 'FII_TIME_ENT_YEAR' THEN l_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
261: ELSE l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
262: END CASE;

Line 259: WHEN 'FII_TIME_ENT_QTR' THEN l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);

255:
256: CASE l_period_type
257: WHEN 'FII_TIME_WEEK' THEN l_date := FII_TIME_API.Cwk_Start(l_as_of_date);
258: WHEN 'FII_TIME_ENT_PERIOD' THEN l_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
259: WHEN 'FII_TIME_ENT_QTR' THEN l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
260: WHEN 'FII_TIME_ENT_YEAR' THEN l_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
261: ELSE l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
262: END CASE;
263:

Line 260: WHEN 'FII_TIME_ENT_YEAR' THEN l_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);

256: CASE l_period_type
257: WHEN 'FII_TIME_WEEK' THEN l_date := FII_TIME_API.Cwk_Start(l_as_of_date);
258: WHEN 'FII_TIME_ENT_PERIOD' THEN l_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
259: WHEN 'FII_TIME_ENT_QTR' THEN l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
260: WHEN 'FII_TIME_ENT_YEAR' THEN l_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
261: ELSE l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
262: END CASE;
263:
264: RETURN l_date;

Line 261: ELSE l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);

257: WHEN 'FII_TIME_WEEK' THEN l_date := FII_TIME_API.Cwk_Start(l_as_of_date);
258: WHEN 'FII_TIME_ENT_PERIOD' THEN l_date := FII_TIME_API.Ent_Cper_Start(l_as_of_date);
259: WHEN 'FII_TIME_ENT_QTR' THEN l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
260: WHEN 'FII_TIME_ENT_YEAR' THEN l_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
261: ELSE l_date := FII_TIME_API.Ent_Cqtr_Start(l_as_of_date);
262: END CASE;
263:
264: RETURN l_date;
265: END;

Line 321: THEN l_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);

317: FROM fii_time_ent_qtr
318: WHERE l_as_of_date BETWEEN start_date AND end_date;
319:
320: IF(l_curr_qtr = 4)
321: THEN l_date := FII_TIME_API.Ent_Cyr_Start(l_as_of_date);
322: ELSE
323: SELECT start_date
324: INTO l_date
325: FROM fii_time_ent_qtr

Line 403: l_date := FII_TIME_API.sd_lyswk(l_as_of_date);

399:
400: IF (l_comp_type = 'YEARLY') THEN
401: CASE l_period_type
402: WHEN 'FII_TIME_WEEK' THEN
403: l_date := FII_TIME_API.sd_lyswk(l_as_of_date);
404: WHEN 'FII_TIME_ENT_PERIOD' THEN
405: l_date := FII_TIME_API.ent_sd_lysper_end(l_as_of_date);
406: WHEN 'FII_TIME_ENT_QTR' THEN
407: l_date := FII_TIME_API.ent_sd_lysqtr_end(l_as_of_date);

Line 405: l_date := FII_TIME_API.ent_sd_lysper_end(l_as_of_date);

401: CASE l_period_type
402: WHEN 'FII_TIME_WEEK' THEN
403: l_date := FII_TIME_API.sd_lyswk(l_as_of_date);
404: WHEN 'FII_TIME_ENT_PERIOD' THEN
405: l_date := FII_TIME_API.ent_sd_lysper_end(l_as_of_date);
406: WHEN 'FII_TIME_ENT_QTR' THEN
407: l_date := FII_TIME_API.ent_sd_lysqtr_end(l_as_of_date);
408: WHEN 'FII_TIME_ENT_YEAR' THEN
409: l_date := FII_TIME_API.ent_sd_lyr_end(l_as_of_date);

Line 407: l_date := FII_TIME_API.ent_sd_lysqtr_end(l_as_of_date);

403: l_date := FII_TIME_API.sd_lyswk(l_as_of_date);
404: WHEN 'FII_TIME_ENT_PERIOD' THEN
405: l_date := FII_TIME_API.ent_sd_lysper_end(l_as_of_date);
406: WHEN 'FII_TIME_ENT_QTR' THEN
407: l_date := FII_TIME_API.ent_sd_lysqtr_end(l_as_of_date);
408: WHEN 'FII_TIME_ENT_YEAR' THEN
409: l_date := FII_TIME_API.ent_sd_lyr_end(l_as_of_date);
410: ELSE
411: l_date := FII_TIME_API.ent_sd_lysqtr_end(l_as_of_date);

Line 409: l_date := FII_TIME_API.ent_sd_lyr_end(l_as_of_date);

405: l_date := FII_TIME_API.ent_sd_lysper_end(l_as_of_date);
406: WHEN 'FII_TIME_ENT_QTR' THEN
407: l_date := FII_TIME_API.ent_sd_lysqtr_end(l_as_of_date);
408: WHEN 'FII_TIME_ENT_YEAR' THEN
409: l_date := FII_TIME_API.ent_sd_lyr_end(l_as_of_date);
410: ELSE
411: l_date := FII_TIME_API.ent_sd_lysqtr_end(l_as_of_date);
412: END CASE;
413: ELSIF (l_comp_type = 'SEQUENTIAL') THEN

Line 411: l_date := FII_TIME_API.ent_sd_lysqtr_end(l_as_of_date);

407: l_date := FII_TIME_API.ent_sd_lysqtr_end(l_as_of_date);
408: WHEN 'FII_TIME_ENT_YEAR' THEN
409: l_date := FII_TIME_API.ent_sd_lyr_end(l_as_of_date);
410: ELSE
411: l_date := FII_TIME_API.ent_sd_lysqtr_end(l_as_of_date);
412: END CASE;
413: ELSIF (l_comp_type = 'SEQUENTIAL') THEN
414: CASE l_period_type
415: WHEN 'FII_TIME_WEEK' THEN

Line 416: l_date := FII_TIME_API.sd_pwk(l_as_of_date);

412: END CASE;
413: ELSIF (l_comp_type = 'SEQUENTIAL') THEN
414: CASE l_period_type
415: WHEN 'FII_TIME_WEEK' THEN
416: l_date := FII_TIME_API.sd_pwk(l_as_of_date);
417: WHEN 'FII_TIME_ENT_PERIOD' THEN
418: l_date := FII_TIME_API.ent_sd_pper_end(l_as_of_date);
419: WHEN 'FII_TIME_ENT_QTR' THEN
420: l_date := FII_TIME_API.ent_sd_pqtr_end(l_as_of_date);

Line 418: l_date := FII_TIME_API.ent_sd_pper_end(l_as_of_date);

414: CASE l_period_type
415: WHEN 'FII_TIME_WEEK' THEN
416: l_date := FII_TIME_API.sd_pwk(l_as_of_date);
417: WHEN 'FII_TIME_ENT_PERIOD' THEN
418: l_date := FII_TIME_API.ent_sd_pper_end(l_as_of_date);
419: WHEN 'FII_TIME_ENT_QTR' THEN
420: l_date := FII_TIME_API.ent_sd_pqtr_end(l_as_of_date);
421: WHEN 'FII_TIME_ENT_YEAR' THEN
422: l_date := FII_TIME_API.ent_sd_lyr_end(l_as_of_date);

Line 420: l_date := FII_TIME_API.ent_sd_pqtr_end(l_as_of_date);

416: l_date := FII_TIME_API.sd_pwk(l_as_of_date);
417: WHEN 'FII_TIME_ENT_PERIOD' THEN
418: l_date := FII_TIME_API.ent_sd_pper_end(l_as_of_date);
419: WHEN 'FII_TIME_ENT_QTR' THEN
420: l_date := FII_TIME_API.ent_sd_pqtr_end(l_as_of_date);
421: WHEN 'FII_TIME_ENT_YEAR' THEN
422: l_date := FII_TIME_API.ent_sd_lyr_end(l_as_of_date);
423: ELSE
424: l_date := FII_TIME_API.ent_sd_pqtr_end(l_as_of_date);

Line 422: l_date := FII_TIME_API.ent_sd_lyr_end(l_as_of_date);

418: l_date := FII_TIME_API.ent_sd_pper_end(l_as_of_date);
419: WHEN 'FII_TIME_ENT_QTR' THEN
420: l_date := FII_TIME_API.ent_sd_pqtr_end(l_as_of_date);
421: WHEN 'FII_TIME_ENT_YEAR' THEN
422: l_date := FII_TIME_API.ent_sd_lyr_end(l_as_of_date);
423: ELSE
424: l_date := FII_TIME_API.ent_sd_pqtr_end(l_as_of_date);
425: END CASE;
426: END IF;

Line 424: l_date := FII_TIME_API.ent_sd_pqtr_end(l_as_of_date);

420: l_date := FII_TIME_API.ent_sd_pqtr_end(l_as_of_date);
421: WHEN 'FII_TIME_ENT_YEAR' THEN
422: l_date := FII_TIME_API.ent_sd_lyr_end(l_as_of_date);
423: ELSE
424: l_date := FII_TIME_API.ent_sd_pqtr_end(l_as_of_date);
425: END CASE;
426: END IF;
427:
428: RETURN l_date;

Line 542: p_curr_start_date := (fii_time_api.ent_lysqtr_end(p_curr_as_of_date)+1); -- lastDay+1 of prior's as-of-date period

538: p_time_ids := 'ent_year_id,ent_qtr_id';
539: -- p_curr_start_date := bil_pqtr_end(p_curr_as_of_date); --8 continuous quarters
540: -- p_series_name := 'FND_GLOBAL.LOCAL_CHR(81)||sequence||FND_GLOBAL.LOCAL_CHR(45)||TO_CHAR(MOD(ent_year_id,100),''FM00'')';
541: /* IF p_comp_type = 'YEARLY' then
542: p_curr_start_date := (fii_time_api.ent_lysqtr_end(p_curr_as_of_date)+1); -- lastDay+1 of prior's as-of-date period
543: p_prev_start_date := (fii_time_api.ent_lysqtr_end(p_curr_start_date)+1); -- lastDay+1 of prior''s prior as-of-date period
544: END IF; */
545:
546: WHEN p_page_period_type = 'FII_TIME_ENT_PERIOD' then

Line 543: p_prev_start_date := (fii_time_api.ent_lysqtr_end(p_curr_start_date)+1); -- lastDay+1 of prior''s prior as-of-date period

539: -- p_curr_start_date := bil_pqtr_end(p_curr_as_of_date); --8 continuous quarters
540: -- p_series_name := 'FND_GLOBAL.LOCAL_CHR(81)||sequence||FND_GLOBAL.LOCAL_CHR(45)||TO_CHAR(MOD(ent_year_id,100),''FM00'')';
541: /* IF p_comp_type = 'YEARLY' then
542: p_curr_start_date := (fii_time_api.ent_lysqtr_end(p_curr_as_of_date)+1); -- lastDay+1 of prior's as-of-date period
543: p_prev_start_date := (fii_time_api.ent_lysqtr_end(p_curr_start_date)+1); -- lastDay+1 of prior''s prior as-of-date period
544: END IF; */
545:
546: WHEN p_page_period_type = 'FII_TIME_ENT_PERIOD' then
547: p_table_name := 'fii_time_ent_period';

Line 550: --l_curr_end_date := fii_time_api.ent_cper_end(p_curr_as_of_date); -- use &BIS_CURRENT_EFFECTIVE_END_DATE

546: WHEN p_page_period_type = 'FII_TIME_ENT_PERIOD' then
547: p_table_name := 'fii_time_ent_period';
548: p_column_name := 'ent_period_id';
549: p_time_ids := 'ent_year_id,ent_period_id';
550: --l_curr_end_date := fii_time_api.ent_cper_end(p_curr_as_of_date); -- use &BIS_CURRENT_EFFECTIVE_END_DATE
551: -- p_curr_start_date := fii_time_api.ent_lysper_end(p_curr_as_of_date);
552: -- p_series_name := 'TO_CHAR(end_date,''Mon'')';
553:
554: /* IF p_comp_type = 'YEARLY' then

Line 551: -- p_curr_start_date := fii_time_api.ent_lysper_end(p_curr_as_of_date);

547: p_table_name := 'fii_time_ent_period';
548: p_column_name := 'ent_period_id';
549: p_time_ids := 'ent_year_id,ent_period_id';
550: --l_curr_end_date := fii_time_api.ent_cper_end(p_curr_as_of_date); -- use &BIS_CURRENT_EFFECTIVE_END_DATE
551: -- p_curr_start_date := fii_time_api.ent_lysper_end(p_curr_as_of_date);
552: -- p_series_name := 'TO_CHAR(end_date,''Mon'')';
553:
554: /* IF p_comp_type = 'YEARLY' then
555: p_curr_start_date := (fii_time_api.ent_lysper_end(p_curr_as_of_date)+1); --Last year same Enterprise period start date

Line 555: p_curr_start_date := (fii_time_api.ent_lysper_end(p_curr_as_of_date)+1); --Last year same Enterprise period start date

551: -- p_curr_start_date := fii_time_api.ent_lysper_end(p_curr_as_of_date);
552: -- p_series_name := 'TO_CHAR(end_date,''Mon'')';
553:
554: /* IF p_comp_type = 'YEARLY' then
555: p_curr_start_date := (fii_time_api.ent_lysper_end(p_curr_as_of_date)+1); --Last year same Enterprise period start date
556: p_prev_start_date := (bil_pper_end(p_curr_as_of_date)+1); -- lastDay+1 of prior''s prior as-of-date period
557: END IF; */
558:
559: ELSE

Line 564: -- p_curr_start_date := (fii_time_api.cwk_end(p_curr_as_of_date) - 91); -- use (as_of_date -13*7)

560: --WHEN p_page_period_type = 'FII_TIME_WEEK' then
561: p_table_name := 'fii_time_week';
562: p_column_name := 'week_id';
563: p_time_ids := 'week_id,week_id';
564: -- p_curr_start_date := (fii_time_api.cwk_end(p_curr_as_of_date) - 91); -- use (as_of_date -13*7)
565: -- p_series_name := 'TO_CHAR(end_date,''DDMon'')';
566:
567: /* IF p_comp_type = 'YEARLY' then
568: --p_curr_start_date := (fii_time_api.cwk_end(p_curr_as_of_date) - 91);

Line 568: --p_curr_start_date := (fii_time_api.cwk_end(p_curr_as_of_date) - 91);

564: -- p_curr_start_date := (fii_time_api.cwk_end(p_curr_as_of_date) - 91); -- use (as_of_date -13*7)
565: -- p_series_name := 'TO_CHAR(end_date,''DDMon'')';
566:
567: /* IF p_comp_type = 'YEARLY' then
568: --p_curr_start_date := (fii_time_api.cwk_end(p_curr_as_of_date) - 91);
569: p_prev_start_date := (fii_time_api.lyswk_end(p_curr_as_of_date)-91);
570: END IF; */
571: END CASE;
572:

Line 569: p_prev_start_date := (fii_time_api.lyswk_end(p_curr_as_of_date)-91);

565: -- p_series_name := 'TO_CHAR(end_date,''DDMon'')';
566:
567: /* IF p_comp_type = 'YEARLY' then
568: --p_curr_start_date := (fii_time_api.cwk_end(p_curr_as_of_date) - 91);
569: p_prev_start_date := (fii_time_api.lyswk_end(p_curr_as_of_date)-91);
570: END IF; */
571: END CASE;
572:
573: /* IF (p_comp_type = 'YEARLY') THEN

Line 576: p_prev_end_date := FII_TIME_API.sd_lyswk(p_curr_as_of_date);

572:
573: /* IF (p_comp_type = 'YEARLY') THEN
574: CASE p_page_period_type
575: WHEN 'FII_TIME_WEEK' THEN
576: p_prev_end_date := FII_TIME_API.sd_lyswk(p_curr_as_of_date);
577: WHEN 'FII_TIME_ENT_PERIOD' THEN
578: p_prev_end_date := FII_TIME_API.ent_sd_lysper_end(p_curr_as_of_date);
579: WHEN 'FII_TIME_ENT_QTR' THEN
580: p_prev_end_date := FII_TIME_API.ent_sd_lysqtr_end(p_curr_as_of_date);

Line 578: p_prev_end_date := FII_TIME_API.ent_sd_lysper_end(p_curr_as_of_date);

574: CASE p_page_period_type
575: WHEN 'FII_TIME_WEEK' THEN
576: p_prev_end_date := FII_TIME_API.sd_lyswk(p_curr_as_of_date);
577: WHEN 'FII_TIME_ENT_PERIOD' THEN
578: p_prev_end_date := FII_TIME_API.ent_sd_lysper_end(p_curr_as_of_date);
579: WHEN 'FII_TIME_ENT_QTR' THEN
580: p_prev_end_date := FII_TIME_API.ent_sd_lysqtr_end(p_curr_as_of_date);
581: WHEN 'FII_TIME_ENT_YEAR' THEN
582: p_prev_end_date := FII_TIME_API.ent_sd_lyr_end(p_curr_as_of_date);

Line 580: p_prev_end_date := FII_TIME_API.ent_sd_lysqtr_end(p_curr_as_of_date);

576: p_prev_end_date := FII_TIME_API.sd_lyswk(p_curr_as_of_date);
577: WHEN 'FII_TIME_ENT_PERIOD' THEN
578: p_prev_end_date := FII_TIME_API.ent_sd_lysper_end(p_curr_as_of_date);
579: WHEN 'FII_TIME_ENT_QTR' THEN
580: p_prev_end_date := FII_TIME_API.ent_sd_lysqtr_end(p_curr_as_of_date);
581: WHEN 'FII_TIME_ENT_YEAR' THEN
582: p_prev_end_date := FII_TIME_API.ent_sd_lyr_end(p_curr_as_of_date);
583: ELSE
584: p_prev_end_date := FII_TIME_API.ent_sd_lysqtr_end(p_curr_as_of_date);

Line 582: p_prev_end_date := FII_TIME_API.ent_sd_lyr_end(p_curr_as_of_date);

578: p_prev_end_date := FII_TIME_API.ent_sd_lysper_end(p_curr_as_of_date);
579: WHEN 'FII_TIME_ENT_QTR' THEN
580: p_prev_end_date := FII_TIME_API.ent_sd_lysqtr_end(p_curr_as_of_date);
581: WHEN 'FII_TIME_ENT_YEAR' THEN
582: p_prev_end_date := FII_TIME_API.ent_sd_lyr_end(p_curr_as_of_date);
583: ELSE
584: p_prev_end_date := FII_TIME_API.ent_sd_lysqtr_end(p_curr_as_of_date);
585: END CASE;
586: ELSIF (p_comp_type = 'SEQUENTIAL') THEN

Line 584: p_prev_end_date := FII_TIME_API.ent_sd_lysqtr_end(p_curr_as_of_date);

580: p_prev_end_date := FII_TIME_API.ent_sd_lysqtr_end(p_curr_as_of_date);
581: WHEN 'FII_TIME_ENT_YEAR' THEN
582: p_prev_end_date := FII_TIME_API.ent_sd_lyr_end(p_curr_as_of_date);
583: ELSE
584: p_prev_end_date := FII_TIME_API.ent_sd_lysqtr_end(p_curr_as_of_date);
585: END CASE;
586: ELSIF (p_comp_type = 'SEQUENTIAL') THEN
587: CASE p_page_period_type
588: WHEN 'FII_TIME_WEEK' THEN

Line 589: p_prev_end_date := FII_TIME_API.sd_pwk(p_curr_as_of_date);

585: END CASE;
586: ELSIF (p_comp_type = 'SEQUENTIAL') THEN
587: CASE p_page_period_type
588: WHEN 'FII_TIME_WEEK' THEN
589: p_prev_end_date := FII_TIME_API.sd_pwk(p_curr_as_of_date);
590: WHEN 'FII_TIME_ENT_PERIOD' THEN
591: p_prev_end_date := FII_TIME_API.ent_sd_pper_end(p_curr_as_of_date);
592: WHEN 'FII_TIME_ENT_QTR' THEN
593: p_prev_end_date := FII_TIME_API.ent_sd_pqtr_end(p_curr_as_of_date);

Line 591: p_prev_end_date := FII_TIME_API.ent_sd_pper_end(p_curr_as_of_date);

587: CASE p_page_period_type
588: WHEN 'FII_TIME_WEEK' THEN
589: p_prev_end_date := FII_TIME_API.sd_pwk(p_curr_as_of_date);
590: WHEN 'FII_TIME_ENT_PERIOD' THEN
591: p_prev_end_date := FII_TIME_API.ent_sd_pper_end(p_curr_as_of_date);
592: WHEN 'FII_TIME_ENT_QTR' THEN
593: p_prev_end_date := FII_TIME_API.ent_sd_pqtr_end(p_curr_as_of_date);
594: WHEN 'FII_TIME_ENT_YEAR' THEN
595: p_prev_end_date := FII_TIME_API.ent_sd_lyr_end(p_curr_as_of_date);

Line 593: p_prev_end_date := FII_TIME_API.ent_sd_pqtr_end(p_curr_as_of_date);

589: p_prev_end_date := FII_TIME_API.sd_pwk(p_curr_as_of_date);
590: WHEN 'FII_TIME_ENT_PERIOD' THEN
591: p_prev_end_date := FII_TIME_API.ent_sd_pper_end(p_curr_as_of_date);
592: WHEN 'FII_TIME_ENT_QTR' THEN
593: p_prev_end_date := FII_TIME_API.ent_sd_pqtr_end(p_curr_as_of_date);
594: WHEN 'FII_TIME_ENT_YEAR' THEN
595: p_prev_end_date := FII_TIME_API.ent_sd_lyr_end(p_curr_as_of_date);
596: ELSE
597: p_prev_end_date := FII_TIME_API.ent_sd_pqtr_end(p_curr_as_of_date);

Line 595: p_prev_end_date := FII_TIME_API.ent_sd_lyr_end(p_curr_as_of_date);

591: p_prev_end_date := FII_TIME_API.ent_sd_pper_end(p_curr_as_of_date);
592: WHEN 'FII_TIME_ENT_QTR' THEN
593: p_prev_end_date := FII_TIME_API.ent_sd_pqtr_end(p_curr_as_of_date);
594: WHEN 'FII_TIME_ENT_YEAR' THEN
595: p_prev_end_date := FII_TIME_API.ent_sd_lyr_end(p_curr_as_of_date);
596: ELSE
597: p_prev_end_date := FII_TIME_API.ent_sd_pqtr_end(p_curr_as_of_date);
598: END CASE;
599: END IF; */

Line 597: p_prev_end_date := FII_TIME_API.ent_sd_pqtr_end(p_curr_as_of_date);

593: p_prev_end_date := FII_TIME_API.ent_sd_pqtr_end(p_curr_as_of_date);
594: WHEN 'FII_TIME_ENT_YEAR' THEN
595: p_prev_end_date := FII_TIME_API.ent_sd_lyr_end(p_curr_as_of_date);
596: ELSE
597: p_prev_end_date := FII_TIME_API.ent_sd_pqtr_end(p_curr_as_of_date);
598: END CASE;
599: END IF; */
600:
601: END GET_TREND_PARAMS;