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.MSC_CALENDAR dependencies on MSC_CALENDAR_DATES

Line 45: FROM msc_calendar_dates

41:
42: SELECT min(calendar_date), max(calendar_date), min(seq_num),
43: max(seq_num)
44: INTO min_date, max_date, min_seq_num, max_seq_num
45: FROM msc_calendar_dates
46: WHERE calendar_code = arg_calendar_code
47: AND seq_num is not null
48: AND exception_set_id = arg_exception_set_id
49: AND sr_instance_id = arg_instance_id;

Line 165: FROM msc_calendar_dates cal

161:
162: BEGIN
163: SELECT calendar_date
164: INTO var_return_date
165: FROM msc_calendar_dates cal
166: WHERE cal.exception_set_id = var_exception_set_id
167: AND cal.calendar_code = var_calendar_code
168: AND cal.seq_num = arg_seq_num + l_arg_offset
169: --AND cal.seq_num = arg_seq_num + arg_offset

Line 255: FROM msc_calendar_dates cal

251: var_return_date := min_date;
252: ELSE
253: SELECT cal.next_date
254: INTO var_return_date
255: FROM msc_calendar_dates cal
256: WHERE cal.exception_set_id = var_exception_set_id
257: AND cal.calendar_code = var_calendar_code
258: AND cal.calendar_date = TRUNC(arg_date)
259: AND cal.sr_instance_id = arg_instance_id;

Line 323: FROM msc_calendar_dates cal

319: var_return_date := min_date;
320: ELSE
321: SELECT cal.prior_date
322: INTO var_return_date
323: FROM msc_calendar_dates cal
324: WHERE cal.exception_set_id = var_exception_set_id
325: AND cal.calendar_code = var_calendar_code
326: AND cal.calendar_date = TRUNC(arg_date)
327: AND cal.sr_instance_id = arg_instance_id;

Line 382: FROM msc_calendar_dates cal

378: var_return_number := min_seq_num;
379: ELSE
380: SELECT cal.next_seq_num
381: INTO var_return_number
382: FROM msc_calendar_dates cal
383: WHERE cal.exception_set_id = var_exception_set_id
384: AND cal.calendar_code = var_calendar_code
385: AND cal.calendar_date = TRUNC(arg_date)
386: AND cal.sr_instance_id = arg_instance_id ;

Line 428: FROM msc_calendar_dates cal

424: var_return_number := min_seq_num;
425: ELSE
426: SELECT cal.prior_seq_num
427: INTO var_return_number
428: FROM msc_calendar_dates cal
429: WHERE cal.exception_set_id = var_exception_set_id
430: AND cal.calendar_code = var_calendar_code
431: AND cal.calendar_date = TRUNC(arg_date)
432: AND cal.sr_instance_id = arg_instance_id ;

Line 627: FROM msc_calendar_dates cal

623: var_return_date := min_date;
624: ELSE
625: SELECT cal.prior_date
626: INTO var_return_date
627: FROM msc_calendar_dates cal
628: WHERE cal.exception_set_id = arg_exception_set_id
629: AND cal.calendar_code = arg_calendar_code
630: AND cal.calendar_date = TRUNC(arg_date)
631: AND cal.sr_instance_id = arg_instance_id;

Line 660: FROM msc_calendar_dates

656:
657: SELECT min(calendar_date), max(calendar_date), min(seq_num),
658: max(seq_num)
659: INTO min_date, max_date, min_seq_num, max_seq_num
660: FROM msc_calendar_dates
661: WHERE calendar_code = arg_calendar_code
662: AND seq_num is not null
663: AND exception_set_id = arg_exception_set_id;
664:

Line 729: FROM msc_calendar_dates cal

725: var_return_date := min_date;
726: ELSE
727: SELECT cal.next_date
728: INTO var_return_date
729: FROM msc_calendar_dates cal
730: WHERE cal.exception_set_id = var_exception_set_id
731: AND cal.calendar_code = arg_calendar_code
732: AND cal.calendar_date = TRUNC(arg_date);
733: END IF;

Line 797: FROM msc_calendar_dates cal

793: var_return_date := min_date;
794: ELSE
795: SELECT cal.prior_date
796: INTO var_return_date
797: FROM msc_calendar_dates cal
798: WHERE cal.exception_set_id = var_exception_set_id
799: AND cal.calendar_code = arg_calendar_code
800: AND cal.calendar_date = TRUNC(arg_date);
801: END IF;

Line 860: FROM msc_calendar_dates cal

856: var_return_number := min_seq_num;
857: ELSE
858: SELECT cal.prior_seq_num
859: INTO var_return_number
860: FROM msc_calendar_dates cal
861: WHERE cal.exception_set_id = var_exception_set_id
862: AND cal.calendar_code = arg_calendar_code
863: AND cal.calendar_date = TRUNC(arg_date);
864: END IF;

Line 907: FROM msc_calendar_dates

903: BEGIN
904:
905: SELECT COUNT(*)
906: INTO var_return_number
907: FROM msc_calendar_dates
908: WHERE sr_instance_id = arg_instance_id
909: AND calendar_code = arg_calendar_code
910: AND exception_set_id = -1
911: AND seq_num is not null

Line 1347: FROM MSC_CALENDAR_DATES

1343:
1344: BEGIN
1345: SELECT NEXT_DATE
1346: INTO l_next_work_day
1347: FROM MSC_CALENDAR_DATES
1348: WHERE SR_INSTANCE_ID = p_instance_id
1349: AND CALENDAR_CODE = p_calendar_code
1350: AND EXCEPTION_SET_ID = -1
1351: AND CALENDAR_DATE = TRUNC(p_calendar_date);

Line 1405: FROM MSC_CALENDAR_DATES

1401:
1402: BEGIN
1403: SELECT PRIOR_DATE
1404: INTO l_prev_work_day
1405: FROM MSC_CALENDAR_DATES
1406: WHERE SR_INSTANCE_ID = p_instance_id
1407: AND CALENDAR_CODE = p_calendar_code
1408: AND EXCEPTION_SET_ID = -1
1409: AND CALENDAR_DATE = TRUNC(p_calendar_date);

Line 1495: FROM MSC_CALENDAR_DATES cal1, MSC_CALENDAR_DATES cal2

1491: IF p_days_offset > 0 THEN
1492: BEGIN
1493: SELECT cal2.calendar_date
1494: INTO l_offsetted_day
1495: FROM MSC_CALENDAR_DATES cal1, MSC_CALENDAR_DATES cal2
1496: WHERE cal1.sr_instance_id = p_instance_id
1497: AND cal1.calendar_code = p_calendar_code
1498: AND cal1.exception_set_id = -1
1499: AND cal1.calendar_date = TRUNC(l_input_date) --6625744

Line 1547: FROM MSC_CALENDAR_DATES cal1, MSC_CALENDAR_DATES cal2

1543: ELSE
1544: BEGIN
1545: SELECT cal2.calendar_date
1546: INTO l_offsetted_day
1547: FROM MSC_CALENDAR_DATES cal1, MSC_CALENDAR_DATES cal2
1548: WHERE cal1.sr_instance_id = p_instance_id
1549: AND cal1.calendar_code = p_calendar_code
1550: AND cal1.exception_set_id = -1
1551: AND cal1.calendar_date = TRUNC(l_input_date) --6625744