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 DUAL

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 287: FROM dual;

283: INTO g_ent_pyr_start,
284: g_ent_pyr_end,
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;

Line 291: FROM dual;

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:
294: -- End of 3893359
295:

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 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 527: FROM dual;

523: INTO g_py_sper_end,
524: g_cy_period_end,
525: g_py_sday,
526: g_curr_start
527: FROM dual;
528:
529: SELECT report_date_julian INTO g_curr_start_day_id FROM fii_time_day WHERE report_date = g_curr_start;
530: SELECT report_date_julian INTO g_curr_end_day_id FROM fii_time_day WHERE report_date = g_curr_end;
531:

Line 540: FROM dual;

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;
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;

Line 544: FROM dual;

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;
547:
548: SELECT ent_period_start_date

Line 563: FROM dual;

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);
566: SELECT NVL(fii_time_api.cwk_end(g_as_of_date),g_min_start_date) INTO g_prior_end FROM DUAL;
567:

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 577: FROM dual;

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;
580:
581: SELECT DISTINCT a.sequence INTO g_curr_per_sequence

Line 589: FROM dual;

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:
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),

Line 608: FROM dual;

604: g_curr_start,
605: g_prior_start,
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;

Line 612: FROM dual;

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);
615: SELECT NVL(fii_time_api.ent_cper_end(g_as_of_date),g_min_start_date) INTO g_curr_end FROM DUAL;
616:

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 642: FROM dual;

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);
645: SELECT NVL(fii_time_api.ent_cper_end(g_as_of_date),g_min_start_date) INTO g_prior_end FROM DUAL;
646:

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 656: FROM dual;

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;
659:
660: SELECT DISTINCT a.sequence INTO g_curr_per_sequence

Line 678: FROM dual;

674: g_py_sday,
675: g_curr_start,
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:

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 704: FROM dual;

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
707:
708: SELECT NVL(fii_time_api.ent_sd_lysqtr_end(g_rpt_begin_date),g_min_start_date)

Line 710: FROM dual;

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
713: FROM fii_time_ent_qtr a
714: WHERE g_as_of_date BETWEEN a.START_DATE AND a.END_DATE;

Line 718: FROM dual;

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)
721: INTO g_exp_begin_date
722: FROM dual;

Line 722: FROM dual;

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;
725:
726: SELECT DISTINCT a.sequence INTO g_curr_per_sequence

Line 732: FROM dual;

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;
735:
736: END IF;

Line 740: FROM dual;

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
743: WHEN 'BUDGET' THEN
744: SELECT NVL( fii_time_api.ent_cqtr_start(g_as_of_date),g_min_start_date)

Line 746: FROM dual;

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);
749: SELECT NVL(fii_time_api.ent_cqtr_end(g_as_of_date),g_min_start_date) INTO g_prior_end from dual;
750:

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 773: FROM dual;

769: g_curr_start,
770: g_temp,
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:

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 802: FROM dual;

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);
805: SELECT NVL(fii_time_api.ent_cyr_end(g_as_of_date),g_min_start_date) INTO g_prior_end from dual;
806:

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 844: FROM dual;

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;
847:
848: g_new_date := g_as_of_date;

Line 852: FROM dual;

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;
855:
856: END get_bitmasks;