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.FII_GL_UTIL_PKG dependencies on FII_TIME_API

Line 265: g_ent_pyr_start := fii_time_api.ent_pyr_start(g_as_of_date);

261: -- Set time related global variables
262: -- -------------------------------------------------
263: /* Commented out for bug 3893359 AND replaced with SELECT
264: IF (g_as_of_date IS NOT NULL) THEN
265: g_ent_pyr_start := fii_time_api.ent_pyr_start(g_as_of_date);
266: g_ent_pyr_end:= fii_time_api.ent_pyr_end(g_as_of_date);
267: g_ent_cyr_start := fii_time_api.ent_cyr_start(g_as_of_date);
268: g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);
269: g_p_period_end := fii_time_api.ent_sd_lysper_end(g_as_of_date);

Line 266: g_ent_pyr_end:= fii_time_api.ent_pyr_end(g_as_of_date);

262: -- -------------------------------------------------
263: /* Commented out for bug 3893359 AND replaced with SELECT
264: IF (g_as_of_date IS NOT NULL) THEN
265: g_ent_pyr_start := fii_time_api.ent_pyr_start(g_as_of_date);
266: g_ent_pyr_end:= fii_time_api.ent_pyr_end(g_as_of_date);
267: g_ent_cyr_start := fii_time_api.ent_cyr_start(g_as_of_date);
268: g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);
269: g_p_period_end := fii_time_api.ent_sd_lysper_end(g_as_of_date);
270: g_p_p_period_end := fii_time_api.ent_sd_lysper_end(g_p_period_end);

Line 267: g_ent_cyr_start := fii_time_api.ent_cyr_start(g_as_of_date);

263: /* Commented out for bug 3893359 AND replaced with SELECT
264: IF (g_as_of_date IS NOT NULL) THEN
265: g_ent_pyr_start := fii_time_api.ent_pyr_start(g_as_of_date);
266: g_ent_pyr_end:= fii_time_api.ent_pyr_end(g_as_of_date);
267: g_ent_cyr_start := fii_time_api.ent_cyr_start(g_as_of_date);
268: g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);
269: g_p_period_end := fii_time_api.ent_sd_lysper_end(g_as_of_date);
270: g_p_p_period_end := fii_time_api.ent_sd_lysper_end(g_p_period_end);
271:

Line 268: g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);

264: IF (g_as_of_date IS NOT NULL) THEN
265: g_ent_pyr_start := fii_time_api.ent_pyr_start(g_as_of_date);
266: g_ent_pyr_end:= fii_time_api.ent_pyr_end(g_as_of_date);
267: g_ent_cyr_start := fii_time_api.ent_cyr_start(g_as_of_date);
268: g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);
269: g_p_period_end := fii_time_api.ent_sd_lysper_end(g_as_of_date);
270: g_p_p_period_end := fii_time_api.ent_sd_lysper_end(g_p_period_end);
271:
272: END IF;

Line 269: g_p_period_end := fii_time_api.ent_sd_lysper_end(g_as_of_date);

265: g_ent_pyr_start := fii_time_api.ent_pyr_start(g_as_of_date);
266: g_ent_pyr_end:= fii_time_api.ent_pyr_end(g_as_of_date);
267: g_ent_cyr_start := fii_time_api.ent_cyr_start(g_as_of_date);
268: g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);
269: g_p_period_end := fii_time_api.ent_sd_lysper_end(g_as_of_date);
270: g_p_p_period_end := fii_time_api.ent_sd_lysper_end(g_p_period_end);
271:
272: END IF;
273: */

Line 270: g_p_p_period_end := fii_time_api.ent_sd_lysper_end(g_p_period_end);

266: g_ent_pyr_end:= fii_time_api.ent_pyr_end(g_as_of_date);
267: g_ent_cyr_start := fii_time_api.ent_cyr_start(g_as_of_date);
268: g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);
269: g_p_period_end := fii_time_api.ent_sd_lysper_end(g_as_of_date);
270: g_p_p_period_end := fii_time_api.ent_sd_lysper_end(g_p_period_end);
271:
272: END IF;
273: */
274:

Line 277: --g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);

273: */
274:
275:
276: IF (g_as_of_date IS NOT NULL) THEN
277: --g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);
278: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_ent_cyr_end from dual;
279: SELECT NVL(fii_time_api.ent_pyr_start(g_as_of_date),g_min_start_date),
280: NVL(fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
281: NVL(fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),

Line 278: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_ent_cyr_end from dual;

274:
275:
276: IF (g_as_of_date IS NOT NULL) THEN
277: --g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);
278: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_ent_cyr_end from dual;
279: SELECT NVL(fii_time_api.ent_pyr_start(g_as_of_date),g_min_start_date),
280: NVL(fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
281: NVL(fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
282: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)

Line 279: SELECT NVL(fii_time_api.ent_pyr_start(g_as_of_date),g_min_start_date),

275:
276: IF (g_as_of_date IS NOT NULL) THEN
277: --g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);
278: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_ent_cyr_end from dual;
279: SELECT NVL(fii_time_api.ent_pyr_start(g_as_of_date),g_min_start_date),
280: NVL(fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
281: NVL(fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
282: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)
283: INTO g_ent_pyr_start,

Line 280: NVL(fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),

276: IF (g_as_of_date IS NOT NULL) THEN
277: --g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);
278: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_ent_cyr_end from dual;
279: SELECT NVL(fii_time_api.ent_pyr_start(g_as_of_date),g_min_start_date),
280: NVL(fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
281: NVL(fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
282: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)
283: INTO g_ent_pyr_start,
284: g_ent_pyr_end,

Line 281: NVL(fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),

277: --g_ent_cyr_end := fii_time_api.ent_cyr_end(g_as_of_date);
278: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_ent_cyr_end from dual;
279: SELECT NVL(fii_time_api.ent_pyr_start(g_as_of_date),g_min_start_date),
280: NVL(fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
281: NVL(fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
282: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)
283: INTO g_ent_pyr_start,
284: g_ent_pyr_end,
285: g_ent_cyr_start,

Line 282: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)

278: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_ent_cyr_end from dual;
279: SELECT NVL(fii_time_api.ent_pyr_start(g_as_of_date),g_min_start_date),
280: NVL(fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
281: NVL(fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
282: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)
283: INTO g_ent_pyr_start,
284: g_ent_pyr_end,
285: g_ent_cyr_start,
286: g_p_period_end

Line 289: SELECT NVL(fii_time_api.ent_sd_lysper_end(g_p_period_end),g_min_start_date)

285: g_ent_cyr_start,
286: g_p_period_end
287: FROM dual;
288:
289: SELECT NVL(fii_time_api.ent_sd_lysper_end(g_p_period_end),g_min_start_date)
290: INTO g_p_p_period_end
291: FROM dual;
292: End IF;
293:

Line 510: SELECT NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date) INTO g_sd_lyr FROM dual;

506: -- Most of the following global variables are specific to the
507: -- Exp. per head AND T & E Trend reports. So the some of the bind names
508: -- AND global variable names are not intuitive
509:
510: SELECT NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date) INTO g_sd_lyr FROM dual;
511:
512: CASE g_page_period_type
513:
514: WHEN 'FII_TIME_WEEK' THEN

Line 516: --g_curr_end := fii_time_api.cwk_end(g_as_of_date);

512: CASE g_page_period_type
513:
514: WHEN 'FII_TIME_WEEK' THEN
515:
516: --g_curr_end := fii_time_api.cwk_end(g_as_of_date);
517: SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
518:
519: SELECT NVL(fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),
520: NVL( fii_time_api.pwk_end(g_as_of_date),g_min_start_date),

Line 517: SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;

513:
514: WHEN 'FII_TIME_WEEK' THEN
515:
516: --g_curr_end := fii_time_api.cwk_end(g_as_of_date);
517: SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
518:
519: SELECT NVL(fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),
520: NVL( fii_time_api.pwk_end(g_as_of_date),g_min_start_date),
521: NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date),

Line 519: SELECT NVL(fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),

515:
516: --g_curr_end := fii_time_api.cwk_end(g_as_of_date);
517: SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
518:
519: SELECT NVL(fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),
520: NVL( fii_time_api.pwk_end(g_as_of_date),g_min_start_date),
521: NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date),
522: NVL(DECODE(fii_time_api.cwk_start(g_as_of_date),g_min_week_start_date,g_min_start_date,fii_time_api.cwk_start(g_as_of_date)),g_min_start_date)
523: INTO g_py_sper_end,

Line 520: NVL( fii_time_api.pwk_end(g_as_of_date),g_min_start_date),

516: --g_curr_end := fii_time_api.cwk_end(g_as_of_date);
517: SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
518:
519: SELECT NVL(fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),
520: NVL( fii_time_api.pwk_end(g_as_of_date),g_min_start_date),
521: NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date),
522: NVL(DECODE(fii_time_api.cwk_start(g_as_of_date),g_min_week_start_date,g_min_start_date,fii_time_api.cwk_start(g_as_of_date)),g_min_start_date)
523: INTO g_py_sper_end,
524: g_cy_period_end,

Line 521: NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date),

517: SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
518:
519: SELECT NVL(fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),
520: NVL( fii_time_api.pwk_end(g_as_of_date),g_min_start_date),
521: NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date),
522: NVL(DECODE(fii_time_api.cwk_start(g_as_of_date),g_min_week_start_date,g_min_start_date,fii_time_api.cwk_start(g_as_of_date)),g_min_start_date)
523: INTO g_py_sper_end,
524: g_cy_period_end,
525: g_py_sday,

Line 522: NVL(DECODE(fii_time_api.cwk_start(g_as_of_date),g_min_week_start_date,g_min_start_date,fii_time_api.cwk_start(g_as_of_date)),g_min_start_date)

518:
519: SELECT NVL(fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),
520: NVL( fii_time_api.pwk_end(g_as_of_date),g_min_start_date),
521: NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date),
522: NVL(DECODE(fii_time_api.cwk_start(g_as_of_date),g_min_week_start_date,g_min_start_date,fii_time_api.cwk_start(g_as_of_date)),g_min_start_date)
523: INTO g_py_sper_end,
524: g_cy_period_end,
525: g_py_sday,
526: g_curr_start

Line 534: SELECT NVL(DECODE(fii_time_api.cwk_start(g_previous_asof_date),g_min_week_start_date,g_min_start_date,fii_time_api.cwk_start(g_previous_asof_date)),g_min_start_date),

530: SELECT report_date_julian INTO g_curr_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;
531:
532: g_temp := NULL;
533:
534: SELECT NVL(DECODE(fii_time_api.cwk_start(g_previous_asof_date),g_min_week_start_date,g_min_start_date,fii_time_api.cwk_start(g_previous_asof_date)),g_min_start_date),
535: NVL( fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),
536: NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date)
537: INTO g_prior_start,
538: g_prior_end,

Line 535: NVL( fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),

531:
532: g_temp := NULL;
533:
534: SELECT NVL(DECODE(fii_time_api.cwk_start(g_previous_asof_date),g_min_week_start_date,g_min_start_date,fii_time_api.cwk_start(g_previous_asof_date)),g_min_start_date),
535: NVL( fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),
536: NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date)
537: INTO g_prior_start,
538: g_prior_end,
539: g_exp_asof_date

Line 536: NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date)

532: g_temp := NULL;
533:
534: SELECT NVL(DECODE(fii_time_api.cwk_start(g_previous_asof_date),g_min_week_start_date,g_min_start_date,fii_time_api.cwk_start(g_previous_asof_date)),g_min_start_date),
535: NVL( fii_time_api.cwk_end(g_previous_asof_date),g_min_start_date),
536: NVL( fii_time_api.sd_lyswk(g_as_of_date),g_min_start_date)
537: INTO g_prior_start,
538: g_prior_end,
539: g_exp_asof_date
540: FROM dual;

Line 542: SELECT NVL(fii_time_api.sd_lyswk(g_exp_asof_date),g_min_start_date)

538: g_prior_end,
539: g_exp_asof_date
540: FROM dual;
541:
542: SELECT NVL(fii_time_api.sd_lyswk(g_exp_asof_date),g_min_start_date)
543: INTO g_exp_start
544: FROM dual;
545:
546: g_exp_begin_date := g_as_of_date - 91;

Line 561: SELECT NVL( fii_time_api.cwk_start(g_as_of_date),g_min_start_date)

557: WHERE g_as_of_date BETWEEN start_date AND end_date);
558:
559: CASE g_time_comp
560: WHEN 'BUDGET' THEN
561: SELECT NVL( fii_time_api.cwk_start(g_as_of_date),g_min_start_date)
562: INTO g_prior_start
563: FROM dual;
564:
565: --g_prior_end := fii_time_api.cwk_end(g_as_of_date);

Line 565: --g_prior_end := fii_time_api.cwk_end(g_as_of_date);

561: SELECT NVL( fii_time_api.cwk_start(g_as_of_date),g_min_start_date)
562: INTO g_prior_start
563: FROM dual;
564:
565: --g_prior_end := fii_time_api.cwk_end(g_as_of_date);
566: SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_prior_end FROM DUAL;
567:
568: SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;
569: SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line 566: SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_prior_end FROM DUAL;

562: INTO g_prior_start
563: FROM dual;
564:
565: --g_prior_end := fii_time_api.cwk_end(g_as_of_date);
566: SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_prior_end FROM DUAL;
567:
568: SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;
569: SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;
570: ELSE

Line 575: SELECT NVL(fii_time_api.sd_lyswk(g_py_sday),g_min_start_date)

571: SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_prior_start;
572: SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_prior_end;
573: END CASE;
574:
575: SELECT NVL(fii_time_api.sd_lyswk(g_py_sday),g_min_start_date)
576: INTO g_rpt_begin_date
577: FROM dual;
578:
579: g_begin_date := g_as_of_date - 91;

Line 587: SELECT NVL(fii_time_api.ent_sd_lysper_beg(g_as_of_date),g_min_start_date)

583: WHERE g_as_of_date BETWEEN a.START_DATE AND a.END_DATE;
584:
585: WHEN 'FII_TIME_ENT_PERIOD' THEN
586: IF (g_previous_asof_date IS NULL) THEN
587: SELECT NVL(fii_time_api.ent_sd_lysper_beg(g_as_of_date),g_min_start_date)
588: INTO g_previous_asof_date
589: FROM dual;
590: END IF;
591:

Line 592: SELECT NVL( fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),

588: INTO g_previous_asof_date
589: FROM dual;
590: END IF;
591:
592: SELECT NVL( fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
593: NVL(fii_time_api.ent_pper_end(g_as_of_date),g_min_start_date),
594: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date),
595: NVL( fii_time_api.ent_sd_lysper_end(g_sd_lyr),g_min_start_date),
596: NVL(fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),

Line 593: NVL(fii_time_api.ent_pper_end(g_as_of_date),g_min_start_date),

589: FROM dual;
590: END IF;
591:
592: SELECT NVL( fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
593: NVL(fii_time_api.ent_pper_end(g_as_of_date),g_min_start_date),
594: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date),
595: NVL( fii_time_api.ent_sd_lysper_end(g_sd_lyr),g_min_start_date),
596: NVL(fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
597: NVL(fii_time_api.ent_cper_start(g_previous_asof_date),g_min_start_date),

Line 594: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date),

590: END IF;
591:
592: SELECT NVL( fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
593: NVL(fii_time_api.ent_pper_end(g_as_of_date),g_min_start_date),
594: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date),
595: NVL( fii_time_api.ent_sd_lysper_end(g_sd_lyr),g_min_start_date),
596: NVL(fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
597: NVL(fii_time_api.ent_cper_start(g_previous_asof_date),g_min_start_date),
598: NVL(fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),

Line 595: NVL( fii_time_api.ent_sd_lysper_end(g_sd_lyr),g_min_start_date),

591:
592: SELECT NVL( fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
593: NVL(fii_time_api.ent_pper_end(g_as_of_date),g_min_start_date),
594: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date),
595: NVL( fii_time_api.ent_sd_lysper_end(g_sd_lyr),g_min_start_date),
596: NVL(fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
597: NVL(fii_time_api.ent_cper_start(g_previous_asof_date),g_min_start_date),
598: NVL(fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
599: NVL(fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)

Line 596: NVL(fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),

592: SELECT NVL( fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
593: NVL(fii_time_api.ent_pper_end(g_as_of_date),g_min_start_date),
594: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date),
595: NVL( fii_time_api.ent_sd_lysper_end(g_sd_lyr),g_min_start_date),
596: NVL(fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
597: NVL(fii_time_api.ent_cper_start(g_previous_asof_date),g_min_start_date),
598: NVL(fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
599: NVL(fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)
600: INTO g_py_sper_end,

Line 597: NVL(fii_time_api.ent_cper_start(g_previous_asof_date),g_min_start_date),

593: NVL(fii_time_api.ent_pper_end(g_as_of_date),g_min_start_date),
594: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date),
595: NVL( fii_time_api.ent_sd_lysper_end(g_sd_lyr),g_min_start_date),
596: NVL(fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
597: NVL(fii_time_api.ent_cper_start(g_previous_asof_date),g_min_start_date),
598: NVL(fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
599: NVL(fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)
600: INTO g_py_sper_end,
601: g_cy_period_end,

Line 598: NVL(fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),

594: NVL( fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date),
595: NVL( fii_time_api.ent_sd_lysper_end(g_sd_lyr),g_min_start_date),
596: NVL(fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
597: NVL(fii_time_api.ent_cper_start(g_previous_asof_date),g_min_start_date),
598: NVL(fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
599: NVL(fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)
600: INTO g_py_sper_end,
601: g_cy_period_end,
602: g_py_sday,

Line 599: NVL(fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)

595: NVL( fii_time_api.ent_sd_lysper_end(g_sd_lyr),g_min_start_date),
596: NVL(fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
597: NVL(fii_time_api.ent_cper_start(g_previous_asof_date),g_min_start_date),
598: NVL(fii_time_api.ent_cper_end(g_previous_asof_date),g_min_start_date),
599: NVL(fii_time_api.ent_sd_lysper_end(g_as_of_date),g_min_start_date)
600: INTO g_py_sper_end,
601: g_cy_period_end,
602: g_py_sday,
603: g_ppy_sday,

Line 610: SELECT NVL(fii_time_api.ent_sd_lysper_end(g_exp_asof_date),g_min_start_date)

606: g_prior_end,
607: g_exp_asof_date
608: FROM dual;
609:
610: SELECT NVL(fii_time_api.ent_sd_lysper_end(g_exp_asof_date),g_min_start_date)
611: INTO g_exp_start
612: FROM dual;
613:
614: --g_curr_end := fii_time_api.ent_cper_end(g_as_of_date);

Line 614: --g_curr_end := fii_time_api.ent_cper_end(g_as_of_date);

610: SELECT NVL(fii_time_api.ent_sd_lysper_end(g_exp_asof_date),g_min_start_date)
611: INTO g_exp_start
612: FROM dual;
613:
614: --g_curr_end := fii_time_api.ent_cper_end(g_as_of_date);
615: SELECT NVL(fii_time_api.ent_cper_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
616:
617: SELECT ent_period_id INTO g_curr_start_period_id FROM fii_time_ent_period WHERE start_date = g_curr_start;
618: SELECT ent_period_id INTO g_curr_end_period_id FROM fii_time_ent_period WHERE end_date = g_curr_end;

Line 615: SELECT NVL(fii_time_api.ent_cper_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;

611: INTO g_exp_start
612: FROM dual;
613:
614: --g_curr_end := fii_time_api.ent_cper_end(g_as_of_date);
615: SELECT NVL(fii_time_api.ent_cper_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
616:
617: SELECT ent_period_id INTO g_curr_start_period_id FROM fii_time_ent_period WHERE start_date = g_curr_start;
618: SELECT ent_period_id INTO g_curr_end_period_id FROM fii_time_ent_period WHERE end_date = g_curr_end;
619: SELECT report_date_julian INTO g_curr_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;

Line 640: SELECT NVL( fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date)

636: WHERE g_as_of_date BETWEEN start_date AND end_date);
637:
638: CASE g_time_comp
639: WHEN 'BUDGET' THEN
640: SELECT NVL( fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date)
641: INTO g_prior_start
642: FROM dual;
643:
644: --g_prior_end := fii_time_api.ent_cper_end(g_as_of_date);

Line 644: --g_prior_end := fii_time_api.ent_cper_end(g_as_of_date);

640: SELECT NVL( fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date)
641: INTO g_prior_start
642: FROM dual;
643:
644: --g_prior_end := fii_time_api.ent_cper_end(g_as_of_date);
645: SELECT NVL(fii_time_api.ent_cper_end(g_as_of_date),g_min_start_date) INTO g_prior_end FROM DUAL;
646:
647: SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;
648: SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line 645: SELECT NVL(fii_time_api.ent_cper_end(g_as_of_date),g_min_start_date) INTO g_prior_end FROM DUAL;

641: INTO g_prior_start
642: FROM dual;
643:
644: --g_prior_end := fii_time_api.ent_cper_end(g_as_of_date);
645: SELECT NVL(fii_time_api.ent_cper_end(g_as_of_date),g_min_start_date) INTO g_prior_end FROM DUAL;
646:
647: SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;
648: SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;
649: ELSE

Line 654: SELECT NVL( fii_time_api.ent_sd_lysper_end(g_py_sday),g_min_start_date)

650: SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_prior_start;
651: SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_prior_end;
652: END CASE;
653:
654: SELECT NVL( fii_time_api.ent_sd_lysper_end(g_py_sday),g_min_start_date)
655: INTO g_rpt_begin_date
656: FROM dual;
657:
658: g_begin_date := g_py_sday;

Line 666: SELECT NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date),

662: WHERE g_as_of_date BETWEEN a.START_DATE AND a.END_DATE;
663:
664: WHEN 'FII_TIME_ENT_QTR' THEN
665:
666: SELECT NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date),
667: NVL( fii_time_api.ent_pqtr_end(g_as_of_date),g_min_start_date),
668: NVL( fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date),
669: NVL(fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date),
670: NVL(fii_time_api.ent_cqtr_start(g_previous_asof_date),g_min_start_date),

Line 667: NVL( fii_time_api.ent_pqtr_end(g_as_of_date),g_min_start_date),

663:
664: WHEN 'FII_TIME_ENT_QTR' THEN
665:
666: SELECT NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date),
667: NVL( fii_time_api.ent_pqtr_end(g_as_of_date),g_min_start_date),
668: NVL( fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date),
669: NVL(fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date),
670: NVL(fii_time_api.ent_cqtr_start(g_previous_asof_date),g_min_start_date),
671: NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date)

Line 668: NVL( fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date),

664: WHEN 'FII_TIME_ENT_QTR' THEN
665:
666: SELECT NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date),
667: NVL( fii_time_api.ent_pqtr_end(g_as_of_date),g_min_start_date),
668: NVL( fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date),
669: NVL(fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date),
670: NVL(fii_time_api.ent_cqtr_start(g_previous_asof_date),g_min_start_date),
671: NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date)
672: INTO g_py_sper_end,

Line 669: NVL(fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date),

665:
666: SELECT NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date),
667: NVL( fii_time_api.ent_pqtr_end(g_as_of_date),g_min_start_date),
668: NVL( fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date),
669: NVL(fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date),
670: NVL(fii_time_api.ent_cqtr_start(g_previous_asof_date),g_min_start_date),
671: NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date)
672: INTO g_py_sper_end,
673: g_cy_period_end,

Line 670: NVL(fii_time_api.ent_cqtr_start(g_previous_asof_date),g_min_start_date),

666: SELECT NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date),
667: NVL( fii_time_api.ent_pqtr_end(g_as_of_date),g_min_start_date),
668: NVL( fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date),
669: NVL(fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date),
670: NVL(fii_time_api.ent_cqtr_start(g_previous_asof_date),g_min_start_date),
671: NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date)
672: INTO g_py_sper_end,
673: g_cy_period_end,
674: g_py_sday,

Line 671: NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date)

667: NVL( fii_time_api.ent_pqtr_end(g_as_of_date),g_min_start_date),
668: NVL( fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date),
669: NVL(fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date),
670: NVL(fii_time_api.ent_cqtr_start(g_previous_asof_date),g_min_start_date),
671: NVL(fii_time_api.ent_cqtr_end(g_previous_asof_date),g_min_start_date)
672: INTO g_py_sper_end,
673: g_cy_period_end,
674: g_py_sday,
675: g_curr_start,

Line 680: --g_curr_end := fii_time_api.ent_cqtr_end(g_as_of_date);

676: g_prior_start,
677: g_prior_end
678: FROM dual;
679:
680: --g_curr_end := fii_time_api.ent_cqtr_end(g_as_of_date);
681: SELECT NVL(fii_time_api.ent_cqtr_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
682:
683: SELECT ent_period_id INTO g_curr_start_period_id FROM fii_time_ent_period WHERE start_date = g_curr_start;
684: SELECT ent_period_id INTO g_curr_end_period_id FROM fii_time_ent_period WHERE end_date = g_curr_end;

Line 681: SELECT NVL(fii_time_api.ent_cqtr_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;

677: g_prior_end
678: FROM dual;
679:
680: --g_curr_end := fii_time_api.ent_cqtr_end(g_as_of_date);
681: SELECT NVL(fii_time_api.ent_cqtr_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
682:
683: SELECT ent_period_id INTO g_curr_start_period_id FROM fii_time_ent_period WHERE start_date = g_curr_start;
684: SELECT ent_period_id INTO g_curr_end_period_id FROM fii_time_ent_period WHERE end_date = g_curr_end;
685: SELECT report_date_julian INTO g_curr_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;

Line 702: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_py_sday),g_min_start_date)

698: WHERE ent_qtr_id =( SELECT ent_qtr_id
699: FROM fii_time_ent_period
700: WHERE g_as_of_date BETWEEN start_date AND end_date);
701:
702: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_py_sday),g_min_start_date)
703: INTO g_rpt_begin_date
704: FROM dual;
705:
706: IF (g_time_comp = 'SEQUENTIAL') THEN

Line 708: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_rpt_begin_date),g_min_start_date)

704: FROM dual;
705:
706: IF (g_time_comp = 'SEQUENTIAL') THEN
707:
708: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_rpt_begin_date),g_min_start_date)
709: INTO g_begin_date
710: FROM dual;
711:
712: SELECT DISTINCT a.ent_qtr_id INTO g_curr_per_sequence

Line 716: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date)

712: SELECT DISTINCT a.ent_qtr_id INTO g_curr_per_sequence
713: FROM fii_time_ent_qtr a
714: WHERE g_as_of_date BETWEEN a.START_DATE AND a.END_DATE;
715:
716: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date)
717: INTO g_exp_asof_date
718: FROM dual;
719:
720: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(fii_time_api.ent_sd_lysqtr_end(g_exp_asof_date)),g_min_start_date)

Line 720: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(fii_time_api.ent_sd_lysqtr_end(g_exp_asof_date)),g_min_start_date)

716: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date)
717: INTO g_exp_asof_date
718: FROM dual;
719:
720: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(fii_time_api.ent_sd_lysqtr_end(g_exp_asof_date)),g_min_start_date)
721: INTO g_exp_begin_date
722: FROM dual;
723: ELSE
724: g_begin_date := g_py_sday;

Line 730: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date)

726: SELECT DISTINCT a.sequence INTO g_curr_per_sequence
727: FROM fii_time_ent_qtr a
728: WHERE g_as_of_date BETWEEN a.START_DATE AND a.END_DATE;
729:
730: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_as_of_date),g_min_start_date)
731: INTO g_exp_asof_date
732: FROM dual;
733:
734: g_exp_begin_date := g_exp_asof_date;

Line 738: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_exp_asof_date),g_min_start_date)

734: g_exp_begin_date := g_exp_asof_date;
735:
736: END IF;
737:
738: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_exp_asof_date),g_min_start_date)
739: INTO g_exp_start
740: FROM dual;
741:
742: CASE g_time_comp

Line 744: SELECT NVL( fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date)

740: FROM dual;
741:
742: CASE g_time_comp
743: WHEN 'BUDGET' THEN
744: SELECT NVL( fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date)
745: INTO g_prior_start
746: FROM dual;
747:
748: --g_prior_end := fii_time_api.ent_cqtr_end(g_as_of_date);

Line 748: --g_prior_end := fii_time_api.ent_cqtr_end(g_as_of_date);

744: SELECT NVL( fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date)
745: INTO g_prior_start
746: FROM dual;
747:
748: --g_prior_end := fii_time_api.ent_cqtr_end(g_as_of_date);
749: SELECT NVL(fii_time_api.ent_cqtr_end(g_as_of_date),g_min_start_date) INTO g_prior_end from dual;
750:
751: SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;
752: SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line 749: SELECT NVL(fii_time_api.ent_cqtr_end(g_as_of_date),g_min_start_date) INTO g_prior_end from dual;

745: INTO g_prior_start
746: FROM dual;
747:
748: --g_prior_end := fii_time_api.ent_cqtr_end(g_as_of_date);
749: SELECT NVL(fii_time_api.ent_cqtr_end(g_as_of_date),g_min_start_date) INTO g_prior_end from dual;
750:
751: SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;
752: SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;
753: ELSE

Line 763: SELECT NVL( fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),

759:
760: g_cy_period_end := NULL;
761: g_py_sday := NULL;
762:
763: SELECT NVL( fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
764: NVL( fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
765: NVL( fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
766: NVL( fii_time_api.ent_cyr_start(g_previous_asof_date),g_min_start_date),
767: NVL( fii_time_api.ent_cyr_end(g_previous_asof_date),g_min_start_date)

Line 764: NVL( fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),

760: g_cy_period_end := NULL;
761: g_py_sday := NULL;
762:
763: SELECT NVL( fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
764: NVL( fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
765: NVL( fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
766: NVL( fii_time_api.ent_cyr_start(g_previous_asof_date),g_min_start_date),
767: NVL( fii_time_api.ent_cyr_end(g_previous_asof_date),g_min_start_date)
768: INTO g_py_sper_end,

Line 765: NVL( fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),

761: g_py_sday := NULL;
762:
763: SELECT NVL( fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
764: NVL( fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
765: NVL( fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
766: NVL( fii_time_api.ent_cyr_start(g_previous_asof_date),g_min_start_date),
767: NVL( fii_time_api.ent_cyr_end(g_previous_asof_date),g_min_start_date)
768: INTO g_py_sper_end,
769: g_curr_start,

Line 766: NVL( fii_time_api.ent_cyr_start(g_previous_asof_date),g_min_start_date),

762:
763: SELECT NVL( fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
764: NVL( fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
765: NVL( fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
766: NVL( fii_time_api.ent_cyr_start(g_previous_asof_date),g_min_start_date),
767: NVL( fii_time_api.ent_cyr_end(g_previous_asof_date),g_min_start_date)
768: INTO g_py_sper_end,
769: g_curr_start,
770: g_temp,

Line 767: NVL( fii_time_api.ent_cyr_end(g_previous_asof_date),g_min_start_date)

763: SELECT NVL( fii_time_api.ent_pyr_end(g_as_of_date),g_min_start_date),
764: NVL( fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date),
765: NVL( fii_time_api.ent_cper_start(g_as_of_date),g_min_start_date),
766: NVL( fii_time_api.ent_cyr_start(g_previous_asof_date),g_min_start_date),
767: NVL( fii_time_api.ent_cyr_end(g_previous_asof_date),g_min_start_date)
768: INTO g_py_sper_end,
769: g_curr_start,
770: g_temp,
771: g_prior_start,

Line 775: --g_curr_end := fii_time_api.ent_cyr_end(g_as_of_date);

771: g_prior_start,
772: g_prior_end
773: FROM dual;
774:
775: --g_curr_end := fii_time_api.ent_cyr_end(g_as_of_date);
776: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
777:
778: SELECT ent_period_id INTO g_curr_start_period_id FROM fii_time_ent_period WHERE start_date = g_curr_start;
779: SELECT ent_period_id INTO g_curr_end_period_id FROM fii_time_ent_period WHERE end_date = g_curr_end;

Line 776: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;

772: g_prior_end
773: FROM dual;
774:
775: --g_curr_end := fii_time_api.ent_cyr_end(g_as_of_date);
776: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
777:
778: SELECT ent_period_id INTO g_curr_start_period_id FROM fii_time_ent_period WHERE start_date = g_curr_start;
779: SELECT ent_period_id INTO g_curr_end_period_id FROM fii_time_ent_period WHERE end_date = g_curr_end;
780: SELECT report_date_julian INTO g_curr_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;

Line 800: SELECT NVL( fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date)

796: WHERE g_as_of_date BETWEEN start_date AND end_date);
797:
798: CASE g_time_comp
799: WHEN 'BUDGET' THEN
800: SELECT NVL( fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date)
801: INTO g_prior_start
802: FROM dual;
803:
804: --g_prior_end := fii_time_api.ent_cyr_end(g_as_of_date);

Line 804: --g_prior_end := fii_time_api.ent_cyr_end(g_as_of_date);

800: SELECT NVL( fii_time_api.ent_cyr_start(g_as_of_date),g_min_start_date)
801: INTO g_prior_start
802: FROM dual;
803:
804: --g_prior_end := fii_time_api.ent_cyr_end(g_as_of_date);
805: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_prior_end from dual;
806:
807: SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;
808: SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;

Line 805: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_prior_end from dual;

801: INTO g_prior_start
802: FROM dual;
803:
804: --g_prior_end := fii_time_api.ent_cyr_end(g_as_of_date);
805: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_prior_end from dual;
806:
807: SELECT report_date_julian INTO g_prior_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;
808: SELECT report_date_julian INTO g_prior_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;
809:

Line 842: SELECT NVL(fii_time_api.ent_sd_lysper_end(g_new_date),g_min_start_date)

838: INTO g_new_date
839: FROM fii_time_ent_period
840: WHERE ent_period_id = g_month_id;
841:
842: SELECT NVL(fii_time_api.ent_sd_lysper_end(g_new_date),g_min_start_date)
843: INTO g_new_date2
844: FROM dual;
845: ELSE
846: g_bitmask := 23;

Line 850: SELECT NVL(fii_time_api.ent_sd_lyr_end(g_as_of_date),g_min_start_date)

846: g_bitmask := 23;
847:
848: g_new_date := g_as_of_date;
849:
850: SELECT NVL(fii_time_api.ent_sd_lyr_end(g_as_of_date),g_min_start_date)
851: INTO g_new_date2
852: FROM dual;
853:
854: END IF;