APPS.PA_SCHEDULE_PVT dependencies on PA_SCHEDULES_HISTORY

Line 4531: DELETE pa_schedules_history

4527: end if;
4528:
4529: -- Delete entire schedules history if p_perm_delete.
4530: if FND_API.TO_BOOLEAN(p_perm_delete) then
4531: DELETE pa_schedules_history
4532: WHERE assignment_id = p_assignment_id;
4533: end if;
4534:
4535: -- Calling the Timeline api to delete the timeline records

Line 4846: -- If records exist in pa_schedules_history with last_approved_flag

4842: CLOSE C1;
4843: /* End of code added for bug 2329948 */
4844:
4845:
4846: -- If records exist in pa_schedules_history with last_approved_flag
4847: -- set the flag to 'N'
4848: PA_SCHEDULE_UTILS.log_message(1, 'Setting last approved flag to N');
4849: update pa_schedules_history
4850: set last_approved_flag = 'N'

Line 4849: update pa_schedules_history

4845:
4846: -- If records exist in pa_schedules_history with last_approved_flag
4847: -- set the flag to 'N'
4848: PA_SCHEDULE_UTILS.log_message(1, 'Setting last approved flag to N');
4849: update pa_schedules_history
4850: set last_approved_flag = 'N'
4851: where assignment_id = p_assignment_id
4852: and last_approved_flag = 'Y';
4853:

Line 5151: from pa_schedules_history

5147: tuesday_hours, wednesday_hours, thursday_hours, friday_hours,
5148: saturday_hours, sunday_hours, change_id, last_approved_flag, request_id,
5149: program_application_id, program_id, program_update_date, creation_date,
5150: created_by, last_update_date, last_update_by, last_update_login
5151: from pa_schedules_history
5152: where assignment_id = p_assignment_id
5153: and last_approved_flag = 'Y';
5154:
5155: BEGIN

Line 5198: delete pa_schedules_history

5194:
5195: -- Call create_timeline and delete records from schedule history
5196: -- if we inserted any rows.
5197: if l_index <> 0 then
5198: delete pa_schedules_history
5199: where assignment_id = p_assignment_id
5200: and last_approved_flag = 'Y';
5201:
5202: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

Line 5240: -- Effects: Adds schedule records for p_assignment_id to pa_schedules_history

5236: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5237: p_procedure_name => 'revert_to_last_approved');
5238: END revert_to_last_approved;
5239:
5240: -- Effects: Adds schedule records for p_assignment_id to pa_schedules_history
5241: -- if they do not already exist.
5242: -- Impl Notes: If records already exist in pa_schedule_history with change_id,
5243: -- then do nothing. Otherwise, uncheck any records with last_approved_flag
5244: -- and copy schedule records there with correct change_id with

Line 5267: from pa_schedules_history

5263:
5264: -- Contains all the records with p_change_id.
5265: CURSOR C1 IS
5266: select assignment_id
5267: from pa_schedules_history
5268: where assignment_id = p_assignment_id
5269: and change_id = p_change_id;
5270:
5271: -- Contains the schedule records for assignment_id.

Line 5286: -- If there are no records in pa_schedules_history with change_id

5282: BEGIN
5283: PA_SCHEDULE_UTILS.log_message(1,'Start of the update_history_table API');
5284: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
5285:
5286: -- If there are no records in pa_schedules_history with change_id
5287: -- then update table.
5288: open c1;
5289: fetch c1 into l_assignment_id;
5290: if c1%NOTFOUND then

Line 5293: -- Copy records in pa_schedules to pa_schedules_history

5289: fetch c1 into l_assignment_id;
5290: if c1%NOTFOUND then
5291: close c1;
5292:
5293: -- Copy records in pa_schedules to pa_schedules_history
5294: for rec in c2 loop
5295: insert into pa_schedules_history
5296: ( schedule_id, calendar_id, assignment_id, project_id,
5297: schedule_type_code, status_code, start_date, end_date, monday_hours,

Line 5295: insert into pa_schedules_history

5291: close c1;
5292:
5293: -- Copy records in pa_schedules to pa_schedules_history
5294: for rec in c2 loop
5295: insert into pa_schedules_history
5296: ( schedule_id, calendar_id, assignment_id, project_id,
5297: schedule_type_code, status_code, start_date, end_date, monday_hours,
5298: tuesday_hours, wednesday_hours, thursday_hours, friday_hours,
5299: saturday_hours, sunday_hours, change_id, last_approved_flag,

Line 5314: -- If there are records in pa_schedules_history with change_id

5310: rec.request_id, rec.program_application_id, rec.program_id,
5311: rec.program_update_date);
5312: end loop;
5313:
5314: -- If there are records in pa_schedules_history with change_id
5315: -- then do nothing.
5316: else
5317: close c1;
5318: end if;

Line 8229: FROM pa_schedules_history

8225: to_char(trunc(sunday_hours,2)) sun_hours,
8226: status_code,
8227: start_date,
8228: end_date
8229: FROM pa_schedules_history
8230: WHERE assignment_id = p_assignment_id
8231: AND last_approved_flag = 'Y'
8232: AND ( (start_date <= p_start_date AND end_date >= p_end_date)
8233: OR (start_date >= p_start_date AND end_date <= p_end_date)