APPS.MSC_E1APS_DEMCL dependencies on MSC_CALENDARS

Line 403: /* Step 1: Deleting all rows and extracting data from MSC_CALENDARS */

399: FROM MSC_APPS_INSTANCES
400: WHERE INSTANCE_ID = p_instance_id;
401:
402: BEGIN
403: /* Step 1: Deleting all rows and extracting data from MSC_CALENDARS */
404: DELETE
405: FROM MSD_DEM_CALENDARS;
406:
407: COMMIT;

Line 436: FROM MSC_CALENDARS MC,

432: MC.LAST_UPDATED_BY ,
433: MC.CREATION_DATE ,
434: MC.CREATED_BY ,
435: MC.LAST_UPDATE_LOGIN
436: FROM MSC_CALENDARS MC,
437: MSC_APPS_INSTANCES MAI
438: WHERE MC.SR_INSTANCE_ID = p_instance_id
439: AND MAI.INSTANCE_ID = MC.SR_INSTANCE_ID;
440:

Line 444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');

440:
441: COMMIT;
442: EXCEPTION
443: WHEN OTHERS THEN
444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
445: RETCODE := MSC_UTIL.G_ERROR;
446: RETURN;
447: END;
448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');

Line 448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');

444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
445: RETCODE := MSC_UTIL.G_ERROR;
446: RETURN;
447: END;
448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
449: /*ODI Initialize*/
450: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
451: IF odi_url IS NOT NULL THEN
452: BEGIN