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

2206: /* , per_person_types pertypes Commented for bug#2781713 */
2207: , per_assignment_status_types pastype
2208: , pa_resource_txn_attributes res
2209: , pa_all_organizations allorgs
2210: , per_all_people_f pep
2211: WHERE
2212: assn.assignment_status_type_id = pastype.assignment_status_type_id
2213: AND assn.person_id = res.person_id
2214: AND assn.primary_flag = 'Y'

Line 2261: , per_all_people_f pep

2257: /* , per_person_types pertypes Commented for bug#2781713 */
2258: , per_assignment_status_types pastype
2259: , pa_resource_txn_attributes res
2260: , pa_all_organizations allorgs
2261: , per_all_people_f pep
2262: WHERE
2263: assn.assignment_status_type_id = pastype.assignment_status_type_id
2264: AND assn.person_id = res.person_id
2265: AND assn.primary_flag = 'Y'

Line 2417: , per_all_people_f pep

2413: FROM per_all_assignments_f assn
2414: , hr_organization_information hrinf
2415: /* , per_person_types pertypes Commented for Bug#2781713 */
2416: , per_assignment_status_types pastype
2417: , per_all_people_f pep
2418: WHERE
2419: assn.assignment_status_type_id = pastype.assignment_status_type_id
2420: AND assn.primary_flag = 'Y'
2421: AND assn.assignment_type in ('E', 'C') -- CWK Changes

Line 2455: , per_all_people_f pep

2451: FROM per_all_assignments_f assn
2452: , hr_organization_information hrinf
2453: /* , per_person_types pertypes Commented for Bug#2781713 */
2454: , per_assignment_status_types pastype
2455: , per_all_people_f pep
2456: WHERE
2457: assn.assignment_status_type_id = pastype.assignment_status_type_id
2458: AND assn.primary_flag = 'Y'
2459: AND assn.assignment_type in ('E', 'C') -- CWK Changes

Line 3187: p_person_id IN per_all_people_f.person_id%TYPE,

3183: or whenever an organization is taken out from the Exp Hier. In these
3184: cases, the resource is considered no longer active in PJR.
3185: */
3186: PROCEDURE Update_EndDate(
3187: p_person_id IN per_all_people_f.person_id%TYPE,
3188: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3189: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3190: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3191: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 3450: p_person_id IN per_all_people_f.person_id%TYPE,

3446:
3447: /* 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.
3448: */
3449: PROCEDURE Update_Org(
3450: p_person_id IN per_all_people_f.person_id%TYPE,
3451: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3452: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3453: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3454: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 3768: p_person_id IN per_all_people_f.person_id%TYPE,

3764: Update_Resource_Denorm and Create_Forecast_Item to update the denorm
3765: table and regenerate forecast items for the resource respectively.
3766: */
3767: PROCEDURE Update_Job(
3768: p_person_id IN per_all_people_f.person_id%TYPE,
3769: p_old_job IN per_all_assignments_f.job_id%TYPE,
3770: p_new_job IN per_all_assignments_f.job_id%TYPE,
3771: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3772: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 3993: p_person_id IN per_all_people_f.person_id%TYPE,

3989: /* Procedure Update_Supervisor calls Update_Resource_Denorm to update
3990: the resource's supervisor in the denorm table.
3991: */
3992: PROCEDURE Update_Supervisor(
3993: p_person_id IN per_all_people_f.person_id%TYPE,
3994: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3995: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3996: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3997: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 4081: p_person_id IN per_all_people_f.person_id%TYPE,

4077: yes to no and then calls Create_Forecast_Item to regenerate
4078: the forecast items for this resource.
4079: */
4080: PROCEDURE Update_PrimaryFlag(
4081: p_person_id IN per_all_people_f.person_id%TYPE,
4082: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
4083: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
4084: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
4085: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 4145: p_person_id IN per_all_people_f.person_id%TYPE,

4141:
4142: /* Procedure Update_Name calls updates the resource's name in pa_resources.
4143: */
4144: PROCEDURE Update_Name(
4145: p_person_id IN per_all_people_f.person_id%TYPE,
4146: p_old_name IN per_all_people_f.full_name%TYPE,
4147: p_new_name IN per_all_people_f.full_name%TYPE,
4148: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4149: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 4146: p_old_name IN per_all_people_f.full_name%TYPE,

4142: /* Procedure Update_Name calls updates the resource's name in pa_resources.
4143: */
4144: PROCEDURE Update_Name(
4145: p_person_id IN per_all_people_f.person_id%TYPE,
4146: p_old_name IN per_all_people_f.full_name%TYPE,
4147: p_new_name IN per_all_people_f.full_name%TYPE,
4148: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4149: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4150: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 4147: p_new_name IN per_all_people_f.full_name%TYPE,

4143: */
4144: PROCEDURE Update_Name(
4145: p_person_id IN per_all_people_f.person_id%TYPE,
4146: p_old_name IN per_all_people_f.full_name%TYPE,
4147: p_new_name IN per_all_people_f.full_name%TYPE,
4148: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4149: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4150: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
4151:

Line 4364: p_person_id IN per_all_people_f.person_id%TYPE,

4360:
4361: -- Added for bug 3957522
4362: -- Procedure to delete records in pa_resources_denorm
4363: PROCEDURE Delete_PA_Resource_Denorm(
4364: p_person_id IN per_all_people_f.person_id%TYPE,
4365: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
4366: p_old_end_date IN per_all_assignments_f.effective_end_date%TYPE,
4367: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4368: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895