APPS.PA_SCHEDULE_PUB dependencies on PA_SCHEDULES

Line 3038: l_change_id PA_SCHEDULES_HISTORY.change_id%type;

3034: l_I NUMBER;
3035: l_p_start_id NUMBER;
3036: l_p_end_id NUMBER;
3037: l_apply_schedule_changes BOOLEAN;
3038: l_change_id PA_SCHEDULES_HISTORY.change_id%type;
3039: l_temp_status_code PA_PROJECT_ASSIGNMENTS.status_code%type;
3040:
3041: l_save_to_hist VARCHAR2(1); -- Unilog
3042: l_record_version_number_wo_chg NUMBER; -- Unilog

Line 3247: delete pa_schedules where assignment_id = p_assignment_id;

3243:
3244: IF ( l_apply_schedule_changes ) THEN
3245: /* Added below for 7663765 */
3246: if (l_exception_type_code = 'DURATION_PATTERN_SHIFT') then
3247: delete pa_schedules where assignment_id = p_assignment_id;
3248: end if;
3249:
3250: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API apply_schedule_change ....');
3251:

Line 3457: -- Inserting the records in PA_SCHEDULES table

3453:
3454: END IF;
3455:
3456: IF ( l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3457: -- Inserting the records in PA_SCHEDULES table
3458: PA_SCHEDULE_PKG.insert_rows(l_x_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
3459:
3460: END IF;
3461: /** Added call to update_wp_calendar for all projects **/

Line 3790: DELETE FROM PA_SCHEDULES

3786: WHERE calendar_id=v_c1.calendar_id
3787: FOR UPDATE ;
3788:
3789: -- Deleting the existing schedule of the calendar and creating the new one
3790: DELETE FROM PA_SCHEDULES
3791: WHERE calendar_id = v_c1.calendar_id
3792: AND schedule_type_code = 'CALENDAR';
3793:
3794: -- Creating new schedule for the Calendar Id */