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_GREGORIAN_CALENDAR

Line 34: -- 2. Populate Gregorian calendar into MTH_GREGORIAN_CALENDAR denorm table.

30: IF (v_error_string is not NULL) THEN
31: mth_util_pkg.log_msg(v_error_string, mth_util_pkg.G_DBG_USER_INFO);
32: p_retcode := 1;
33: ELSE
34: -- 2. Populate Gregorian calendar into MTH_GREGORIAN_CALENDAR denorm table.
35: POPULATE_GREGORIAN_CAL_DENORM(p_start_year, p_num_years);
36: POPULATE_HOURS;
37: COMMIT;
38: END IF;

Line 75: FROM MTH_GREGORIAN_CALENDAR

71: END IF;
72:
73: SELECT Max(CAL_YEAR_NUMBER)
74: into v_latest_year
75: FROM MTH_GREGORIAN_CALENDAR
76: WHERE calendar_quarter_id IS NULL;
77:
78: IF (v_latest_year is not null and v_latest_year <> P_START_YEAR - 1) THEN
79: FND_MESSAGE.SET_NAME('MTH','MTH_GREG_START_YEAR');

Line 122: INSERT INTO MTH_GREGORIAN_CALENDAR

118:
119: V_year_start := to_date('01/01/' || V_year, 'dd/mm/yyyy');
120: V_year_end := ADD_MONTHS(V_year_start, 12) - 1;
121:
122: INSERT INTO MTH_GREGORIAN_CALENDAR
123: (DIMENSION_KEY,
124: CALENDAR_YEAR_END_DATE,
125: CALENDAR_YEAR_ID,
126: CAL_YEAR_NUMBER,

Line 135: (MTH_GREGORIAN_CALENDAR_S.NEXTVAL * (-1),

131: CALENDAR_YEAR_START_DATE,
132: CREATION_DATE,
133: LAST_UPDATE_DATE)
134: VALUES
135: (MTH_GREGORIAN_CALENDAR_S.NEXTVAL * (-1),
136: V_year_end,
137: MTH_GREGORIAN_CALENDAR_S.CURRVAL * (-1),
138: V_YEAR,
139: V_YEAR,

Line 137: MTH_GREGORIAN_CALENDAR_S.CURRVAL * (-1),

133: LAST_UPDATE_DATE)
134: VALUES
135: (MTH_GREGORIAN_CALENDAR_S.NEXTVAL * (-1),
136: V_year_end,
137: MTH_GREGORIAN_CALENDAR_S.CURRVAL * (-1),
138: V_YEAR,
139: V_YEAR,
140: (V_year_end - V_year_start + 1),
141: V_YEAR,

Line 153: MTH_GREGORIAN_CALENDAR that has the newly created year entries

149: mth_util_pkg.log_msg('Inserting Year level Complete', mth_util_pkg.G_DBG_OTH);
150:
151: /*
152: 2. Insert quarter entries at the quarter level by joinning
153: MTH_GREGORIAN_CALENDAR that has the newly created year entries
154: with a SELECT subquery with four rows for each quarter in a year, then selecting year
155: level information from MTH_GREGORIAN_CALENDAR and constructing quarter
156: level information, and lastly inserting quarter entries into
157: MTH_GREGORIAN_CALENDAR.

Line 155: level information from MTH_GREGORIAN_CALENDAR and constructing quarter

151: /*
152: 2. Insert quarter entries at the quarter level by joinning
153: MTH_GREGORIAN_CALENDAR that has the newly created year entries
154: with a SELECT subquery with four rows for each quarter in a year, then selecting year
155: level information from MTH_GREGORIAN_CALENDAR and constructing quarter
156: level information, and lastly inserting quarter entries into
157: MTH_GREGORIAN_CALENDAR.
158:
159: */

Line 157: MTH_GREGORIAN_CALENDAR.

153: MTH_GREGORIAN_CALENDAR that has the newly created year entries
154: with a SELECT subquery with four rows for each quarter in a year, then selecting year
155: level information from MTH_GREGORIAN_CALENDAR and constructing quarter
156: level information, and lastly inserting quarter entries into
157: MTH_GREGORIAN_CALENDAR.
158:
159: */
160: mth_util_pkg.log_msg('Inserting Quarter level', mth_util_pkg.G_DBG_OTH);
161:

Line 162: INSERT INTO MTH_GREGORIAN_CALENDAR

158:
159: */
160: mth_util_pkg.log_msg('Inserting Quarter level', mth_util_pkg.G_DBG_OTH);
161:
162: INSERT INTO MTH_GREGORIAN_CALENDAR
163: (DIMENSION_KEY,
164: CALENDAR_YEAR_END_DATE,
165: CALENDAR_YEAR_ID,
166: CAL_YEAR_NUMBER,

Line 184: MTH_GREGORIAN_CALENDAR_S.NEXTVAL * (-1) AS DIMENSION_KEY,

180: QUARTER_OF_YEAR,
181: CREATION_DATE, LAST_UPDATE_DATE)
182:
183: SELECT
184: MTH_GREGORIAN_CALENDAR_S.NEXTVAL * (-1) AS DIMENSION_KEY,
185: CALENDAR_YEAR_END_DATE,
186: CALENDAR_YEAR_ID,
187: CAL_YEAR_NUMBER,
188: CALENDAR_YEAR_NAME,

Line 207: MTH_GREGORIAN_CALENDAR_S.CURRVAL * (-1)

203:
204: ADD_MONTHS(CALENDAR_YEAR_START_DATE, quarter * 3) - 1
205: AS CALENDAR_QUARTER_END_DATE,
206:
207: MTH_GREGORIAN_CALENDAR_S.CURRVAL * (-1)
208: AS CALENDAR_QUARTER_ID,
209:
210: 'Quarter ' || quarter || ' ' || CALENDAR_YEAR_CAL_YEAR_CODE
211: AS CALENDAR_QUARTER_DESCRIPTION,

Line 222: FROM MTH_GREGORIAN_CALENDAR CAL,

218: Quarter AS QUARTER_OF_YEAR,
219: SYSDATE,
220: SYSDATE
221:
222: FROM MTH_GREGORIAN_CALENDAR CAL,
223:
224: (SELECT LEVEL AS quarter FROM dual CONNECT BY LEVEL<=4) q
225:
226: WHERE CAL.CALENDAR_QUARTER_ID IS NULL AND

Line 233: MTH_GREGORIAN_CALENDAR that has the newly created quarter entries

229: mth_util_pkg.log_msg('Inserting Quarter level completed', mth_util_pkg.G_DBG_OTH);
230:
231: /*
232: 3. Insert month entries at the month level by joinning
233: MTH_GREGORIAN_CALENDAR that has the newly created quarter entries
234: with a SELECT subquery with three rows for each month in a quarter, then selecting
235: year and quarter level information from MTH_GREGORIAN_CALENDAR and
236: constructing month level information, and lastly inserting month entries into
237: MTH_GREGORIAN_CALENDAR.

Line 235: year and quarter level information from MTH_GREGORIAN_CALENDAR and

231: /*
232: 3. Insert month entries at the month level by joinning
233: MTH_GREGORIAN_CALENDAR that has the newly created quarter entries
234: with a SELECT subquery with three rows for each month in a quarter, then selecting
235: year and quarter level information from MTH_GREGORIAN_CALENDAR and
236: constructing month level information, and lastly inserting month entries into
237: MTH_GREGORIAN_CALENDAR.
238: */
239: mth_util_pkg.log_msg('Inserting Month level', mth_util_pkg.G_DBG_OTH);

Line 237: MTH_GREGORIAN_CALENDAR.

233: MTH_GREGORIAN_CALENDAR that has the newly created quarter entries
234: with a SELECT subquery with three rows for each month in a quarter, then selecting
235: year and quarter level information from MTH_GREGORIAN_CALENDAR and
236: constructing month level information, and lastly inserting month entries into
237: MTH_GREGORIAN_CALENDAR.
238: */
239: mth_util_pkg.log_msg('Inserting Month level', mth_util_pkg.G_DBG_OTH);
240:
241: INSERT INTO MTH_GREGORIAN_CALENDAR (DIMENSION_KEY,

Line 241: INSERT INTO MTH_GREGORIAN_CALENDAR (DIMENSION_KEY,

237: MTH_GREGORIAN_CALENDAR.
238: */
239: mth_util_pkg.log_msg('Inserting Month level', mth_util_pkg.G_DBG_OTH);
240:
241: INSERT INTO MTH_GREGORIAN_CALENDAR (DIMENSION_KEY,
242:
243: CALENDAR_YEAR_END_DATE,
244: CALENDAR_YEAR_ID,
245: CAL_YEAR_NUMBER,

Line 274: SELECT MTH_GREGORIAN_CALENDAR_S.NEXTVAL * (-1) AS DIMENSION_KEY,

270: CALENDAR_MONTH_END_DATE,
271: CREATION_DATE,
272: LAST_UPDATE_DATE)
273:
274: SELECT MTH_GREGORIAN_CALENDAR_S.NEXTVAL * (-1) AS DIMENSION_KEY,
275:
276: -- Year and Quarter Columns--
277: CALENDAR_YEAR_END_DATE,
278: CALENDAR_YEAR_ID,

Line 297: MTH_GREGORIAN_CALENDAR_S.CURRVAL * (-1)

293: QUARTER_OF_YEAR,
294:
295: -- Year and Quarter Columns--
296:
297: MTH_GREGORIAN_CALENDAR_S.CURRVAL * (-1)
298: AS CALENDAR_MONTH_ID,
299:
300: ((QUARTER_OF_YEAR - 1) * 3 + month)
301: AS MONTH_OF_YEAR,

Line 337: FROM MTH_GREGORIAN_CALENDAR cal,

333: AS CALENDAR_MONTH_END_DATE,
334:
335: SYSDATE AS CREATION_DATE,
336: SYSDATE AS LAST_UPDATE_DATE
337: FROM MTH_GREGORIAN_CALENDAR cal,
338:
339: (SELECT LEVEL AS MONTH FROM dual CONNECT BY LEVEL<=3) MONTH
340:
341: WHERE cal.CALENDAR_QUARTER_ID IS NOT NULL

Line 349: MTH_GREGORIAN_CALENDAR that has the newly created month level entries

345: mth_util_pkg.log_msg('Inserting Month level completed', mth_util_pkg.G_DBG_OTH);
346:
347: /*
348: 4. Insert day entries at the Day level by joinning
349: MTH_GREGORIAN_CALENDAR that has the newly created month level entries
350: with a SELECT subquery with maximal 31 rows for each day in a month, then selecting
351: year, quarter, and month level information from MTH_GREGORIAN_CALENDAR and
352: constructing day level information, and lastly inserting day entries into
353: MTH_GREGORIAN_CALENDAR.

Line 351: year, quarter, and month level information from MTH_GREGORIAN_CALENDAR and

347: /*
348: 4. Insert day entries at the Day level by joinning
349: MTH_GREGORIAN_CALENDAR that has the newly created month level entries
350: with a SELECT subquery with maximal 31 rows for each day in a month, then selecting
351: year, quarter, and month level information from MTH_GREGORIAN_CALENDAR and
352: constructing day level information, and lastly inserting day entries into
353: MTH_GREGORIAN_CALENDAR.
354: */
355: mth_util_pkg.log_msg('Inserting Day level', mth_util_pkg.G_DBG_OTH);

Line 353: MTH_GREGORIAN_CALENDAR.

349: MTH_GREGORIAN_CALENDAR that has the newly created month level entries
350: with a SELECT subquery with maximal 31 rows for each day in a month, then selecting
351: year, quarter, and month level information from MTH_GREGORIAN_CALENDAR and
352: constructing day level information, and lastly inserting day entries into
353: MTH_GREGORIAN_CALENDAR.
354: */
355: mth_util_pkg.log_msg('Inserting Day level', mth_util_pkg.G_DBG_OTH);
356:
357:

Line 358: INSERT INTO MTH_GREGORIAN_CALENDAR (DIMENSION_KEY,

354: */
355: mth_util_pkg.log_msg('Inserting Day level', mth_util_pkg.G_DBG_OTH);
356:
357:
358: INSERT INTO MTH_GREGORIAN_CALENDAR (DIMENSION_KEY,
359:
360: -- Year, Quarter and Month Columns--
361:
362: CALENDAR_YEAR_END_DATE,

Line 409: SELECT MTH_GREGORIAN_CALENDAR_S.NEXTVAL AS DIMENSION_KEY,

405: DAY_DAY_CODE,
406: CREATION_DATE,
407: LAST_UPDATE_DATE)
408:
409: SELECT MTH_GREGORIAN_CALENDAR_S.NEXTVAL AS DIMENSION_KEY,
410:
411: -- Year, Quarter and Month Columns--
412:
413: CALENDAR_YEAR_END_DATE,

Line 462: MTH_GREGORIAN_CALENDAR_S.CURRVAL

458:
459: (CALENDAR_MONTH_START_DATE - CALENDAR_YEAR_START_DATE + DAY_IN_MONTH)
460: AS DAY_OF_CAL_YEAR,
461:
462: MTH_GREGORIAN_CALENDAR_S.CURRVAL
463: AS DAY_ID,
464:
465: TO_CHAR (CALENDAR_MONTH_START_DATE + DAY_IN_MONTH - 1,'D')
466: AS DAY_OF_CAL_WEEK,

Line 490: FROM MTH_GREGORIAN_CALENDAR cal,

486:
487: SYSDATE AS CREATION_DATE,
488: SYSDATE AS LAST_UPDATE_DATE
489:
490: FROM MTH_GREGORIAN_CALENDAR cal,
491:
492: (SELECT LEVEL AS DAY_IN_MONTH FROM dual CONNECT BY LEVEL<=31) days
493:
494: WHERE cal.DAY_ID IS NULL

Line 540: FROM mth_gregorian_calendar

536: SELECT days.day + ((60*60*(hours.hour-1))/86400) from_time,
537: days.day + (((60*60*(hours.hour))-1)/86400) to_time,
538: To_Char(days.DAY,'DD-MON-YYYY')||'-'||hours.HOUR hour_pk
539: FROM (SELECT day
540: FROM mth_gregorian_calendar
541: WHERE day IS NOT NULL
542: UNION
543: SELECT day
544: FROM mth_445_period_calendar