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_CL_OTHER_ODS_LOAD dependencies on MSC_CALENDARS

Line 3918: MSC_CL_COLLECTION.DELETE_MSC_TABLE ('MSC_CALENDARS', MSC_CL_COLLECTION.v_instance_id, Null, 'AND CALENDAR_TYPE=''FISCAL''');

3914: BEGIN
3915:
3916: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
3917:
3918: MSC_CL_COLLECTION.DELETE_MSC_TABLE ('MSC_CALENDARS', MSC_CL_COLLECTION.v_instance_id, Null, 'AND CALENDAR_TYPE=''FISCAL''');
3919: MSC_CL_COLLECTION.DELETE_MSC_TABLE ('MSC_CALENDAR_MONTHS', MSC_CL_COLLECTION.v_instance_id, NULL);
3920:
3921: INSERT INTO MSC_CALENDARS
3922: (

Line 3921: INSERT INTO MSC_CALENDARS

3917:
3918: MSC_CL_COLLECTION.DELETE_MSC_TABLE ('MSC_CALENDARS', MSC_CL_COLLECTION.v_instance_id, Null, 'AND CALENDAR_TYPE=''FISCAL''');
3919: MSC_CL_COLLECTION.DELETE_MSC_TABLE ('MSC_CALENDAR_MONTHS', MSC_CL_COLLECTION.v_instance_id, NULL);
3920:
3921: INSERT INTO MSC_CALENDARS
3922: (
3923: CALENDAR_CODE,
3924: CALENDAR_TYPE,
3925: REFRESH_ID,

Line 3954: UPDATE MSC_CALENDARS

3950: BEGIN
3951:
3952: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
3953:
3954: UPDATE MSC_CALENDARS
3955: SET
3956: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
3957: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
3958: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 3966: INSERT INTO MSC_CALENDARS

3962:
3963: END IF;
3964:
3965: IF (MSC_CL_COLLECTION.v_is_legacy_refresh AND SQL%NOTFOUND) THEN
3966: INSERT INTO MSC_CALENDARS
3967: ( CALENDAR_CODE,
3968: CALENDAR_TYPE,
3969: REFRESH_NUMBER,
3970: SR_INSTANCE_ID,