[Home] [Help]
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:
4803:
4804: -- Delete entire exception history if p_perm_delete
4805: -- Otherwise, just delete exceptions with change_id >= p_change_id
4806: if FND_API.TO_BOOLEAN(p_perm_delete) then
4807: DELETE pa_schedule_except_history
4808: WHERE assignment_id = p_assignment_id;
4809: else
4810: DELETE pa_schedule_except_history
4811: WHERE assignment_id = p_assignment_id
4806: if FND_API.TO_BOOLEAN(p_perm_delete) then
4807: DELETE pa_schedule_except_history
4808: WHERE assignment_id = p_assignment_id;
4809: else
4810: DELETE pa_schedule_except_history
4811: WHERE assignment_id = p_assignment_id
4812: and change_id >= p_change_id;
4813: end if;
4814:
5694: status_code, resource_calendar_percent, non_working_day_flag,
5695: change_hours_type_code, nvl(monday_hours,0) monday_hours , nvl(tuesday_hours,0) tuesday_hours,
5696: nvl(wednesday_hours,0) wednesday_hours, nvl(thursday_hours,0) thursday_hours, nvl(friday_hours,0) friday_hours, nvl(saturday_hours,0) saturday_hours,
5697: nvl(sunday_hours,0) sunday_hours, change_calendar_type_code, change_calendar_id
5698: FROM pa_schedule_except_history
5699: WHERE assignment_id = p_assignment_id
5700: AND change_id = p_change_id;
5701:
5702: CURSOR get_start_end_date IS
5724: FETCH get_apprvl_status_code INTO l_apprvl_status_code;
5725: CLOSE get_apprvl_status_code;
5726:
5727: ------------------------------------------------------------------------
5728: -- Populate the temp table from pa_schedule_except_history
5729: ------------------------------------------------------------------------
5730: -- If there is last approved data in history table and approval status is not 'approve',
5731: -- populate temp table from history table first. Because we need to consider mass update submit case.
5732: IF (p_change_id <> -1 AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN