DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on PA_SCHEDULE_EXCEPTIONS

Line 4796: -- deleting the records from pa_schedules,pa_schedule_exceptions and pa_schedule_except_history */

4792:
4793: -- Storing the value for error tracking
4794: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
4795:
4796: -- deleting the records from pa_schedules,pa_schedule_exceptions and pa_schedule_except_history */
4797:
4798: DELETE pa_schedules
4799: WHERE assignment_id = p_assignment_id;
4800:

Line 4801: DELETE pa_schedule_exceptions

4797:
4798: DELETE pa_schedules
4799: WHERE assignment_id = p_assignment_id;
4800:
4801: DELETE pa_schedule_exceptions
4802: WHERE assignment_id = p_assignment_id;
4803:
4804: -- Delete entire exception history if p_perm_delete
4805: -- Otherwise, just delete exceptions with change_id >= p_change_id