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_ASSIGNMENTS_F

Line 235: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

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,
239: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 236: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

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,
239: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
240: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 237: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,

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,
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

Line 238: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

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,
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:

Line 244: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,

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,
248: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,

Line 245: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,

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,
248: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
249: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 246: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

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,
248: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
249: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
250: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 247: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

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,
248: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
249: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
250: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
251: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 248: p_old_end_date IN per_all_assignments_f.effective_start_date%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,
248: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
249: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
250: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
251: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
252: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895

Line 249: p_new_end_date IN per_all_assignments_f.effective_end_date%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,
248: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
249: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
250: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
251: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
252: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
253:

Line 258: FUNCTION Belongs_ExpOrg(p_org_id IN per_all_assignments_f.organization_id%TYPE) RETURN VARCHAR2;

254: FUNCTION check_pjr_default_ou(P_Organization_id IN Hr_Organization_Information.Organization_id%type,
255: P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type) RETURN VARCHAR2; -- Bug 4656855
256: pragma RESTRICT_REFERENCES (check_pjr_default_ou, WNDS, WNPS);
257:
258: FUNCTION Belongs_ExpOrg(p_org_id IN per_all_assignments_f.organization_id%TYPE) RETURN VARCHAR2;
259: pragma RESTRICT_REFERENCES (Belongs_ExpOrg, WNDS, WNPS);
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);

Line 261: FUNCTION Get_DefaultOU(p_org_id IN per_all_assignments_f.organization_id%TYPE) RETURN NUMBER ;

257:
258: FUNCTION Belongs_ExpOrg(p_org_id IN per_all_assignments_f.organization_id%TYPE) RETURN VARCHAR2;
259: pragma RESTRICT_REFERENCES (Belongs_ExpOrg, WNDS, WNPS);
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,

Line 265: p_old_job IN per_all_assignments_f.job_id%TYPE,

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,
269: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 266: p_new_job IN per_all_assignments_f.job_id%TYPE,

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,
269: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
270: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 267: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,

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,
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

Line 268: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

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,
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:

Line 274: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,

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,
278: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 275: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,

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,
278: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
279: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 276: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,

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,
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

Line 277: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

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,
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:

Line 283: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

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,
287: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 284: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

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,
287: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
288: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 285: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,

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,
287: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
288: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
289: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895

Line 286: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

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,
287: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
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:

Line 325: -- in per_all_assignments_f are deleted.

321:
322: FUNCTION Get_Country_name(p_country_code VARCHAR2) RETURN VARCHAR2 ;
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,

Line 328: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

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
332: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895

Line 329: p_old_end_date IN per_all_assignments_f.effective_end_date%TYPE,

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
332: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
333: