eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_HR_UPDATE_API dependencies on PER_ALL_PEOPLE_F

Line 234: PROCEDURE Update_EndDate(p_person_id IN per_all_people_f.person_id%TYPE,

230: ,x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
231: ,x_msg_data IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
232: ,x_msg_count IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
233: );
234: PROCEDURE Update_EndDate(p_person_id IN per_all_people_f.person_id%TYPE,
235: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
236: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
237: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
238: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 243: PROCEDURE Update_Org(p_person_id IN per_all_people_f.person_id%TYPE,

239: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
240: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
241: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
242:
243: PROCEDURE Update_Org(p_person_id IN per_all_people_f.person_id%TYPE,
244: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
245: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
246: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
247: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 264: PROCEDURE Update_Job(p_person_id IN per_all_people_f.person_id%TYPE,

260:
261: FUNCTION Get_DefaultOU(p_org_id IN per_all_assignments_f.organization_id%TYPE) RETURN NUMBER ;
262: pragma RESTRICT_REFERENCES (Get_DefaultOU, WNDS, WNPS);
263:
264: PROCEDURE Update_Job(p_person_id IN per_all_people_f.person_id%TYPE,
265: p_old_job IN per_all_assignments_f.job_id%TYPE,
266: p_new_job IN per_all_assignments_f.job_id%TYPE,
267: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
268: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 273: PROCEDURE Update_Supervisor(p_person_id IN per_all_people_f.person_id%TYPE,

269: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
270: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
271: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
272:
273: PROCEDURE Update_Supervisor(p_person_id IN per_all_people_f.person_id%TYPE,
274: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
275: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
276: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
277: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 282: PROCEDURE Update_PrimaryFlag(p_person_id IN per_all_people_f.person_id%TYPE,

278: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
279: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
280: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
281:
282: PROCEDURE Update_PrimaryFlag(p_person_id IN per_all_people_f.person_id%TYPE,
283: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
284: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
285: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
286: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 292: p_person_id IN per_all_people_f.person_id%TYPE,

288: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
289: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
290:
291: PROCEDURE Update_Name(
292: p_person_id IN per_all_people_f.person_id%TYPE,
293: p_old_name IN per_all_people_f.full_name%TYPE,
294: p_new_name IN per_all_people_f.full_name%TYPE,
295: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
296: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 293: p_old_name IN per_all_people_f.full_name%TYPE,

289: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
290:
291: PROCEDURE Update_Name(
292: p_person_id IN per_all_people_f.person_id%TYPE,
293: p_old_name IN per_all_people_f.full_name%TYPE,
294: p_new_name IN per_all_people_f.full_name%TYPE,
295: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
296: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
297: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895

Line 294: p_new_name IN per_all_people_f.full_name%TYPE,

290:
291: PROCEDURE Update_Name(
292: p_person_id IN per_all_people_f.person_id%TYPE,
293: p_old_name IN per_all_people_f.full_name%TYPE,
294: p_new_name IN per_all_people_f.full_name%TYPE,
295: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
296: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
297: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
298:

Line 327: p_person_id IN per_all_people_f.person_id%TYPE,

323:
324: -- Procedure to delete the records in pa_resources_denorm when the corresponding records
325: -- in per_all_assignments_f are deleted.
326: PROCEDURE Delete_PA_Resource_Denorm(
327: p_person_id IN per_all_people_f.person_id%TYPE,
328: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
329: p_old_end_date IN per_all_assignments_f.effective_end_date%TYPE,
330: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
331: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895