DBA Data[Home] [Help]

APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_CALENDAR_MONTHS

Line 3919: MSC_CL_COLLECTION.DELETE_MSC_TABLE ('MSC_CALENDAR_MONTHS', MSC_CL_COLLECTION.v_instance_id, NULL);

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: (
3923: CALENDAR_CODE,

Line 4000: UPDATE MSC_CALENDAR_MONTHS

3996: BEGIN
3997:
3998: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
3999:
4000: UPDATE MSC_CALENDAR_MONTHS
4001: SET
4002: YEAR = c_rec.YEAR,
4003: YEAR_DESCRIPTION = c_rec.YEAR_DESCRIPTION,
4004: YEAR_START_DATE = c_rec.YEAR_START_DATE,

Line 4029: INSERT INTO MSC_CALENDAR_MONTHS (

4025:
4026:
4027: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) OR (MSC_CL_COLLECTION.v_is_legacy_refresh AND SQL%NOTFOUND) THEN
4028:
4029: INSERT INTO MSC_CALENDAR_MONTHS (
4030: CALENDAR_CODE,
4031: CALENDAR_TYPE,
4032: YEAR,
4033: YEAR_DESCRIPTION,