DBA Data[Home] [Help]

APPS.MSC_E1_APS_PDP dependencies on MSC_ST_CALENDARS

Line 646: DELETE FROM MSC_ST_CALENDARS

642: RETURN;
643: END;
644:
645: BEGIN
646: DELETE FROM MSC_ST_CALENDARS
647: WHERE SR_INSTANCE_CODE like parInstanceCode AND PROCESS_FLAG =1;
648:
649: EXCEPTION
650: WHEN OTHERS THEN

Line 651: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows deleted from MSC_ST_CALENDARS');

647: WHERE SR_INSTANCE_CODE like parInstanceCode AND PROCESS_FLAG =1;
648:
649: EXCEPTION
650: WHEN OTHERS THEN
651: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows deleted from MSC_ST_CALENDARS');
652: RETCODE := MSC_UTIL.G_ERROR;
653: RETURN;
654: END;
655: END IF;