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.MTH_CALENDAR_PKG dependencies on MTH_445_PERIOD_CALENDAR

Line 544: FROM mth_445_period_calendar

540: FROM mth_gregorian_calendar
541: WHERE day IS NOT NULL
542: UNION
543: SELECT day
544: FROM mth_445_period_calendar
545: WHERE day IS NOT NULL
546: UNION
547: SELECT report_date day
548: FROM mth_day_d) days,

Line 665: -- 1. Populate yearly data into MTH_445_PERIOD_CALENDAR

661: mth_util_pkg.log_msg('P_YEAR_END_VARIATION = ' || P_YEAR_END_VARIATION , mth_util_pkg.G_DBG_MAIN_PARAM);
662:
663:
664:
665: -- 1. Populate yearly data into MTH_445_PERIOD_CALENDAR
666: -- 1.1 Find the start date of the year by finding the year end of last year plus one day
667: v_year_end_date := get_445_544_year_end(P_START_YEAR - 1, P_START_MONTH, P_START_DAY, P_YEAR_END_VARIATION);
668: --P_START_MONTH IN NUMBER, P_START_WEEK_DAY IN NUMBER , P_YEAR_END_VARIATION IN NUMBER
669: v_num:= 0;

Line 678: INSERT INTO MTH_445_PERIOD_CALENDAR

674: v_year_start_date := v_year_end_date + 1;
675: v_year_end_date := get_445_544_year_end( v_year, P_START_MONTH, P_START_DAY, P_YEAR_END_VARIATION);
676:
677: -- 1.3. Populate yearly
678: INSERT INTO MTH_445_PERIOD_CALENDAR
679: (DIMENSION_KEY,
680: FISCAL_YEAR_ID,
681: FISCAL_YEAR_NAME,
682: FIS_YEAR_NUMBER,

Line 691: (MTH_445_PERIOD_CALENDAR_S.NEXTVAL * (-1),

687: FISCAL_YEAR_END_DATE,
688: CREATION_DATE,
689: LAST_UPDATE_DATE)
690: values
691: (MTH_445_PERIOD_CALENDAR_S.NEXTVAL * (-1),
692: MTH_445_PERIOD_CALENDAR_S.CURRVAL * (-1),
693: v_year,
694: v_year,
695: v_year_start_date,

Line 692: MTH_445_PERIOD_CALENDAR_S.CURRVAL * (-1),

688: CREATION_DATE,
689: LAST_UPDATE_DATE)
690: values
691: (MTH_445_PERIOD_CALENDAR_S.NEXTVAL * (-1),
692: MTH_445_PERIOD_CALENDAR_S.CURRVAL * (-1),
693: v_year,
694: v_year,
695: v_year_start_date,
696: (v_year_end_date - v_year_start_date + 1),

Line 711: MTH_445_PERIOD_CALENDAR that has the newly created year level information

707: mth_util_pkg.log_msg('Inserted ' || v_num || ' rows.',mth_util_pkg.G_DBG_ROW_CNT);
708: mth_util_pkg.log_msg('Inserting Year level Complete',mth_util_pkg.G_DBG_OTH);
709: /*
710: 2. Insert quarter entries at the quarter level by joinning
711: MTH_445_PERIOD_CALENDAR that has the newly created year level information
712: with a SELECT subquery with four rows for each quarter in a year, then selecting year
713: level information from MTH_445_PERIOD_CALENDAR and constructing quarter
714: level information, and lastly inserting quarter entries into
715: MTH_445_PERIOD_CALENDAR.

Line 713: level information from MTH_445_PERIOD_CALENDAR and constructing quarter

709: /*
710: 2. Insert quarter entries at the quarter level by joinning
711: MTH_445_PERIOD_CALENDAR that has the newly created year level information
712: with a SELECT subquery with four rows for each quarter in a year, then selecting year
713: level information from MTH_445_PERIOD_CALENDAR and constructing quarter
714: level information, and lastly inserting quarter entries into
715: MTH_445_PERIOD_CALENDAR.
716: */
717: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,

Line 715: MTH_445_PERIOD_CALENDAR.

711: MTH_445_PERIOD_CALENDAR that has the newly created year level information
712: with a SELECT subquery with four rows for each quarter in a year, then selecting year
713: level information from MTH_445_PERIOD_CALENDAR and constructing quarter
714: level information, and lastly inserting quarter entries into
715: MTH_445_PERIOD_CALENDAR.
716: */
717: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,
718: --,
719:

Line 717: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,

713: level information from MTH_445_PERIOD_CALENDAR and constructing quarter
714: level information, and lastly inserting quarter entries into
715: MTH_445_PERIOD_CALENDAR.
716: */
717: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,
718: --,
719:
720: FISCAL_YEAR_ID,
721: FISCAL_YEAR_NAME,

Line 740: SELECT MTH_445_PERIOD_CALENDAR_S.NEXTVAL * (-1) AS DIMENSION_KEY,

736: FISCAL_QUARTER_END_DATE,
737: FISCAL_QUARTER_DESCRIPTION,
738: CREATION_DATE,
739: LAST_UPDATE_DATE)
740: SELECT MTH_445_PERIOD_CALENDAR_S.NEXTVAL * (-1) AS DIMENSION_KEY,
741: -- ,
742:
743: FISCAL_YEAR_ID,
744: FISCAL_YEAR_NAME,

Line 753: MTH_445_PERIOD_CALENDAR_S.CURRVAL * (-1)

749: FISCAL_YEAR_DESCRIPTION,
750: FISCAL_YEAR_END_DATE,
751:
752: -- Need to calculate the span for the last quarter
753: MTH_445_PERIOD_CALENDAR_S.CURRVAL * (-1)
754: AS FISCAL_QUARTER_ID,
755: 'Q' || quarter || ' ' || FISCAL_YEAR_FIS_YEAR_CODE
756: AS FISCAL_QUARTER_NAME,
757: quarter as FIS_QUARTER_NUMBER,

Line 776: FROM MTH_445_PERIOD_CALENDAR cal,

772: AS FISCAL_QUARTER_DESCRIPTION,
773:
774: SYSDATE,
775: SYSDATE
776: FROM MTH_445_PERIOD_CALENDAR cal,
777: (select LEVEL AS quarter from dual connect by LEVEL <= 4) q
778: WHERE cal.FISCAL_QUARTER_ID IS NULL
779: AND cal.FIS_YEAR_NUMBER >= P_START_YEAR;
780:

Line 783: MTH_445_PERIOD_CALENDAR that has the newly created quarter entries

779: AND cal.FIS_YEAR_NUMBER >= P_START_YEAR;
780:
781: /*
782: 3. Insert month entries at the month level by joinning
783: MTH_445_PERIOD_CALENDAR that has the newly created quarter entries
784: with a SELECT subquery with three rows for each month in a quarter, then selecting
785: year and quarter level information from MTH_445_PERIOD_CALENDAR and
786: constructing month level information, and lastly inserting month entries into
787: MTH_445_PERIOD_CALENDAR.

Line 785: year and quarter level information from MTH_445_PERIOD_CALENDAR and

781: /*
782: 3. Insert month entries at the month level by joinning
783: MTH_445_PERIOD_CALENDAR that has the newly created quarter entries
784: with a SELECT subquery with three rows for each month in a quarter, then selecting
785: year and quarter level information from MTH_445_PERIOD_CALENDAR and
786: constructing month level information, and lastly inserting month entries into
787: MTH_445_PERIOD_CALENDAR.
788: */
789: mth_util_pkg.log_msg('Inserted ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_ROW_CNT);

Line 787: MTH_445_PERIOD_CALENDAR.

783: MTH_445_PERIOD_CALENDAR that has the newly created quarter entries
784: with a SELECT subquery with three rows for each month in a quarter, then selecting
785: year and quarter level information from MTH_445_PERIOD_CALENDAR and
786: constructing month level information, and lastly inserting month entries into
787: MTH_445_PERIOD_CALENDAR.
788: */
789: mth_util_pkg.log_msg('Inserted ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_ROW_CNT);
790: mth_util_pkg.log_msg('Inserting Quarter level Complete',mth_util_pkg.G_DBG_OTH);
791:

Line 792: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,

788: */
789: mth_util_pkg.log_msg('Inserted ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_ROW_CNT);
790: mth_util_pkg.log_msg('Inserting Quarter level Complete',mth_util_pkg.G_DBG_OTH);
791:
792: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,
793: --,
794: FISCAL_YEAR_ID,
795: FISCAL_YEAR_NAME,
796: FIS_YEAR_NUMBER,

Line 826: SELECT MTH_445_PERIOD_CALENDAR_S.NEXTVAL * (-1) AS DIMENSION_KEY,

822: FISCAL_MONTH_TIME_SPAN,
823: MONTH_OF_FISCAL_YEAR,
824: CREATION_DATE,
825: LAST_UPDATE_DATE)
826: SELECT MTH_445_PERIOD_CALENDAR_S.NEXTVAL * (-1) AS DIMENSION_KEY,
827: --,
828: FISCAL_YEAR_ID,
829: FISCAL_YEAR_NAME,
830: FIS_YEAR_NUMBER,

Line 873: MTH_445_PERIOD_CALENDAR_S.CURRVAL * (-1) AS FISCAL_MONTH_ID,

869: THEN FISCAL_QUARTER_START_DATE + ((4 * 7) - 1)
870: WHEN MONTH = 1 AND P_CAL_TYPE = 544
871: THEN FISCAL_QUARTER_START_DATE + ((5 * 7) - 1) END
872: AS FISCAL_MONTH_END_DATE,
873: MTH_445_PERIOD_CALENDAR_S.CURRVAL * (-1) AS FISCAL_MONTH_ID,
874: 'Month ' || ( (FIS_QUARTER_NUMBER - 1) * 3 + MONTH) || ' ' || FISCAL_YEAR_NAME
875: AS FISCAL_MONTH_NAME,
876: ((FIS_QUARTER_NUMBER - 1) * 3 + MONTH) AS FIS_MONTH_NUMBER,
877: CASE WHEN MONTH = 1 AND P_CAL_TYPE = 445 THEN 4 * 7

Line 894: FROM MTH_445_PERIOD_CALENDAR cal,

890:
891: ((FIS_QUARTER_NUMBER - 1) * 3 + MONTH) AS MONTH_OF_FISCAL_YEAR,
892: SYSDATE AS CREATION_DATE,
893: SYSDATE AS LAST_UPDATE_DATE
894: FROM MTH_445_PERIOD_CALENDAR cal,
895: (select LEVEL AS MONTH from dual connect by LEVEL <= 3) MONTHS
896: WHERE cal.FISCAL_QUARTER_ID IS NOT NULL
897: AND cal.FISCAL_MONTH_ID IS NULL
898: AND cal.FIS_YEAR_NUMBER >= P_START_YEAR;

Line 904: MTH_445_PERIOD_CALENDAR that has the newly created month entries

900: mth_util_pkg.log_msg('Inserted ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_ROW_CNT);
901: mth_util_pkg.log_msg('Inserting Month level Complete',mth_util_pkg.G_DBG_OTH);
902:
903: /* 4. Insert day entries at the Week level by joinning
904: MTH_445_PERIOD_CALENDAR that has the newly created month entries
905: with a SELECT subquery with maximal 6 rows for each week in a month, then
906: selecting year, quarter and month level information from
907: MTH_445_PERIOD_CALENDAR
908: and constructing week level information, and lastly inserting week entries into

Line 907: MTH_445_PERIOD_CALENDAR

903: /* 4. Insert day entries at the Week level by joinning
904: MTH_445_PERIOD_CALENDAR that has the newly created month entries
905: with a SELECT subquery with maximal 6 rows for each week in a month, then
906: selecting year, quarter and month level information from
907: MTH_445_PERIOD_CALENDAR
908: and constructing week level information, and lastly inserting week entries into
909: MTH_445_PERIOD_CALENDAR.
910: */
911: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,

Line 909: MTH_445_PERIOD_CALENDAR.

905: with a SELECT subquery with maximal 6 rows for each week in a month, then
906: selecting year, quarter and month level information from
907: MTH_445_PERIOD_CALENDAR
908: and constructing week level information, and lastly inserting week entries into
909: MTH_445_PERIOD_CALENDAR.
910: */
911: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,
912:
913: FISCAL_YEAR_ID,

Line 911: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,

907: MTH_445_PERIOD_CALENDAR
908: and constructing week level information, and lastly inserting week entries into
909: MTH_445_PERIOD_CALENDAR.
910: */
911: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,
912:
913: FISCAL_YEAR_ID,
914: FISCAL_YEAR_NAME,
915: FIS_YEAR_NUMBER,

Line 961: SELECT MTH_445_PERIOD_CALENDAR_S.NEXTVAL * (-1) AS DIMENSION_KEY,

957: WEEK_OF_FISCAL_QUARTER,
958: CREATION_DATE,
959: LAST_UPDATE_DATE)
960:
961: SELECT MTH_445_PERIOD_CALENDAR_S.NEXTVAL * (-1) AS DIMENSION_KEY,
962:
963: FISCAL_YEAR_ID,
964: FISCAL_YEAR_NAME,
965: FIS_YEAR_NUMBER,

Line 1016: MTH_445_PERIOD_CALENDAR_S.CURRVAL * (-1)

1012: FISCAL_YEAR_START_DATE + 1) / 7) + WEEKS.WEEK)
1013: AS FIS_WEEK_NUMBER,
1014: (FISCAL_MONTH_START_DATE + WEEKS.WEEK * 7) - 1
1015: AS FISCAL_WEEK_END_DATE,
1016: MTH_445_PERIOD_CALENDAR_S.CURRVAL * (-1)
1017: AS FISCAL_WEEK_ID,
1018: 'Wk ' || (ROUND((FISCAL_MONTH_START_DATE -
1019: FISCAL_YEAR_START_DATE + 1) / 7) + WEEKS.WEEK) || ' ' || FISCAL_YEAR_NAME
1020: AS FISCAL_WEEK_NAME,

Line 1026: FROM MTH_445_PERIOD_CALENDAR cal,

1022: AS WEEK_OF_FISCAL_QUARTER,
1023: SYSDATE AS CREATION_DATE,
1024: SYSDATE AS LAST_UPDATE_DATE
1025:
1026: FROM MTH_445_PERIOD_CALENDAR cal,
1027: (select LEVEL AS WEEK from dual connect by LEVEL <= 6) WEEKS
1028: --at most 6 weeks in one month
1029: WHERE cal.FISCAL_MONTH_ID IS NOT NULL AND
1030: cal.FISCAL_WEEK_ID IS NULL AND

Line 1037: MTH_445_PERIOD_CALENDAR that has the newly created week level information

1033: mth_util_pkg.log_msg('Inserted ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_ROW_CNT);
1034: mth_util_pkg.log_msg('Inserting Week level Complete',mth_util_pkg.G_DBG_OTH);
1035: /*
1036: 5. Insert day entries at the Day level by joinning
1037: MTH_445_PERIOD_CALENDAR that has the newly created week level information
1038: with a SELECT subquery with 7 rows for each day in a week, then selecting
1039: year, quarter, month, and week level information from MTH_445_PERIOD_CALENDAR
1040: and constructing day level information, and lastly inserting day entries into
1041: MTH_445_PERIOD_CALENDAR.

Line 1039: year, quarter, month, and week level information from MTH_445_PERIOD_CALENDAR

1035: /*
1036: 5. Insert day entries at the Day level by joinning
1037: MTH_445_PERIOD_CALENDAR that has the newly created week level information
1038: with a SELECT subquery with 7 rows for each day in a week, then selecting
1039: year, quarter, month, and week level information from MTH_445_PERIOD_CALENDAR
1040: and constructing day level information, and lastly inserting day entries into
1041: MTH_445_PERIOD_CALENDAR.
1042: */
1043: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,

Line 1041: MTH_445_PERIOD_CALENDAR.

1037: MTH_445_PERIOD_CALENDAR that has the newly created week level information
1038: with a SELECT subquery with 7 rows for each day in a week, then selecting
1039: year, quarter, month, and week level information from MTH_445_PERIOD_CALENDAR
1040: and constructing day level information, and lastly inserting day entries into
1041: MTH_445_PERIOD_CALENDAR.
1042: */
1043: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,
1044:
1045: FISCAL_YEAR_ID,

Line 1043: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,

1039: year, quarter, month, and week level information from MTH_445_PERIOD_CALENDAR
1040: and constructing day level information, and lastly inserting day entries into
1041: MTH_445_PERIOD_CALENDAR.
1042: */
1043: INSERT INTO MTH_445_PERIOD_CALENDAR (DIMENSION_KEY,
1044:
1045: FISCAL_YEAR_ID,
1046: FISCAL_YEAR_NAME,
1047: FIS_YEAR_NUMBER,

Line 1108: SELECT MTH_445_PERIOD_CALENDAR_S.NEXTVAL AS DIMENSION_KEY,

1104: DAY_OF_FISCAL_MONTH,
1105: CREATION_DATE,
1106: LAST_UPDATE_DATE)
1107:
1108: SELECT MTH_445_PERIOD_CALENDAR_S.NEXTVAL AS DIMENSION_KEY,
1109:
1110: FISCAL_YEAR_ID,
1111: FISCAL_YEAR_NAME,
1112: FIS_YEAR_NUMBER,

Line 1164: MTH_445_PERIOD_CALENDAR_S.CURRVAL AS DAY_ID,

1160: TO_NUMBER(To_Char((FISCAL_WEEK_START_DATE + DAY_IN_WEEK - 1),'J')) AS JULIAN_DATE,
1161: DAY_IN_WEEK AS DAY_OF_FISCAL_WEEK,
1162: 1 AS DAY_TIME_SPAN,
1163: (FISCAL_WEEK_START_DATE + DAY_IN_WEEK - 1) AS DAY,
1164: MTH_445_PERIOD_CALENDAR_S.CURRVAL AS DAY_ID,
1165: TO_NUMBER (To_Char(FISCAL_WEEK_START_DATE + DAY_IN_WEEK - 1, 'YYYYMMDD')) AS DAY_DAY_CODE,
1166: To_Char(FISCAL_WEEK_START_DATE + DAY_IN_WEEK - 1, 'DD-MON-YYYY') AS DAY_DESCRIPTION,
1167: To_Char(FISCAL_WEEK_START_DATE + DAY_IN_WEEK - 1, 'DD-MON-YYYY') AS DAY_NAME,
1168: FISCAL_WEEK_START_DATE + DAY_IN_WEEK - 1 AS DAY_END_DATE,

Line 1176: FROM MTH_445_PERIOD_CALENDAR cal,

1172: AS DAY_OF_FISCAL_MONTH,
1173: SYSDATE AS CREATION_DATE,
1174: SYSDATE AS LAST_UPDATE_DATE
1175:
1176: FROM MTH_445_PERIOD_CALENDAR cal,
1177: (select LEVEL AS DAY_IN_WEEK from dual connect by LEVEL <= 7) days
1178: WHERE cal.DAY_ID IS NULL
1179: AND cal.FISCAL_WEEK_ID IS NOT NULL
1180: AND cal.FIS_YEAR_NUMBER >= P_START_YEAR;