DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on PA_SCHEDULE_EXCEPTIONS

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

4506:
4507: -- Storing the value for error tracking
4508: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
4509:
4510: -- deleting the records from pa_schedules,pa_schedule_exceptions and pa_schedule_except_history */
4511:
4512: DELETE pa_schedules
4513: WHERE assignment_id = p_assignment_id;
4514:

Line 4515: DELETE pa_schedule_exceptions

4511:
4512: DELETE pa_schedules
4513: WHERE assignment_id = p_assignment_id;
4514:
4515: DELETE pa_schedule_exceptions
4516: WHERE assignment_id = p_assignment_id;
4517:
4518: -- Delete entire exception history if p_perm_delete
4519: -- Otherwise, just delete exceptions with change_id >= p_change_id