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 2203: , per_all_people_f pep

2199: /* , per_person_types pertypes Commented for bug#2781713 */
2200: , per_assignment_status_types pastype
2201: , pa_resource_txn_attributes res
2202: , pa_all_organizations allorgs
2203: , per_all_people_f pep
2204: WHERE
2205: assn.assignment_status_type_id = pastype.assignment_status_type_id
2206: AND assn.person_id = res.person_id
2207: AND assn.primary_flag = 'Y'

Line 2254: , per_all_people_f pep

2250: /* , per_person_types pertypes Commented for bug#2781713 */
2251: , per_assignment_status_types pastype
2252: , pa_resource_txn_attributes res
2253: , pa_all_organizations allorgs
2254: , per_all_people_f pep
2255: WHERE
2256: assn.assignment_status_type_id = pastype.assignment_status_type_id
2257: AND assn.person_id = res.person_id
2258: AND assn.primary_flag = 'Y'

Line 2410: , per_all_people_f pep

2406: FROM per_all_assignments_f assn
2407: , hr_organization_information hrinf
2408: /* , per_person_types pertypes Commented for Bug#2781713 */
2409: , per_assignment_status_types pastype
2410: , per_all_people_f pep
2411: WHERE
2412: assn.assignment_status_type_id = pastype.assignment_status_type_id
2413: AND assn.primary_flag = 'Y'
2414: AND assn.assignment_type in ('E', 'C') -- CWK Changes

Line 2448: , per_all_people_f pep

2444: FROM per_all_assignments_f assn
2445: , hr_organization_information hrinf
2446: /* , per_person_types pertypes Commented for Bug#2781713 */
2447: , per_assignment_status_types pastype
2448: , per_all_people_f pep
2449: WHERE
2450: assn.assignment_status_type_id = pastype.assignment_status_type_id
2451: AND assn.primary_flag = 'Y'
2452: AND assn.assignment_type in ('E', 'C') -- CWK Changes

Line 3161: p_person_id IN per_all_people_f.person_id%TYPE,

3157: or whenever an organization is taken out from the Exp Hier. In these
3158: cases, the resource is considered no longer active in PJR.
3159: */
3160: PROCEDURE Update_EndDate(
3161: p_person_id IN per_all_people_f.person_id%TYPE,
3162: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3163: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3164: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3165: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 3330: p_person_id IN per_all_people_f.person_id%TYPE,

3326:
3327: /* Procedure Update_Org calls Update_Resource_Denorm and Create_Forecast_Item to update the organization and org_id for the resources in pa_resources_denorm table and regenerate forecast items for the resource respectively.
3328: */
3329: PROCEDURE Update_Org(
3330: p_person_id IN per_all_people_f.person_id%TYPE,
3331: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3332: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3333: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3334: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 3647: p_person_id IN per_all_people_f.person_id%TYPE,

3643: Update_Resource_Denorm and Create_Forecast_Item to update the denorm
3644: table and regenerate forecast items for the resource respectively.
3645: */
3646: PROCEDURE Update_Job(
3647: p_person_id IN per_all_people_f.person_id%TYPE,
3648: p_old_job IN per_all_assignments_f.job_id%TYPE,
3649: p_new_job IN per_all_assignments_f.job_id%TYPE,
3650: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3651: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 3857: p_person_id IN per_all_people_f.person_id%TYPE,

3853: /* Procedure Update_Supervisor calls Update_Resource_Denorm to update
3854: the resource's supervisor in the denorm table.
3855: */
3856: PROCEDURE Update_Supervisor(
3857: p_person_id IN per_all_people_f.person_id%TYPE,
3858: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3859: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3860: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3861: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 3945: p_person_id IN per_all_people_f.person_id%TYPE,

3941: yes to no and then calls Create_Forecast_Item to regenerate
3942: the forecast items for this resource.
3943: */
3944: PROCEDURE Update_PrimaryFlag(
3945: p_person_id IN per_all_people_f.person_id%TYPE,
3946: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3947: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3948: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3949: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 4006: p_person_id IN per_all_people_f.person_id%TYPE,

4002:
4003: /* Procedure Update_Name calls updates the resource's name in pa_resources.
4004: */
4005: PROCEDURE Update_Name(
4006: p_person_id IN per_all_people_f.person_id%TYPE,
4007: p_old_name IN per_all_people_f.full_name%TYPE,
4008: p_new_name IN per_all_people_f.full_name%TYPE,
4009: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4010: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 4007: p_old_name IN per_all_people_f.full_name%TYPE,

4003: /* Procedure Update_Name calls updates the resource's name in pa_resources.
4004: */
4005: PROCEDURE Update_Name(
4006: p_person_id IN per_all_people_f.person_id%TYPE,
4007: p_old_name IN per_all_people_f.full_name%TYPE,
4008: p_new_name IN per_all_people_f.full_name%TYPE,
4009: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4010: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4011: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 4008: p_new_name IN per_all_people_f.full_name%TYPE,

4004: */
4005: PROCEDURE Update_Name(
4006: p_person_id IN per_all_people_f.person_id%TYPE,
4007: p_old_name IN per_all_people_f.full_name%TYPE,
4008: p_new_name IN per_all_people_f.full_name%TYPE,
4009: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4010: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4011: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
4012:

Line 4225: p_person_id IN per_all_people_f.person_id%TYPE,

4221:
4222: -- Added for bug 3957522
4223: -- Procedure to delete records in pa_resources_denorm
4224: PROCEDURE Delete_PA_Resource_Denorm(
4225: p_person_id IN per_all_people_f.person_id%TYPE,
4226: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
4227: p_old_end_date IN per_all_assignments_f.effective_end_date%TYPE,
4228: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4229: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895