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.HR_APPLICANT_API dependencies on PER_PERSON_TYPES

Line 1837: l_system_person_type per_person_types.system_person_type%TYPE;

1833: l_person_type_id number := p_person_type_id;
1834: l_person_type_id1 number;
1835: l_unaccepted_asg_del_warning boolean;
1836: --
1837: l_system_person_type per_person_types.system_person_type%TYPE;
1838: l_business_group_id per_all_people_f.business_group_id%TYPE;
1839: l_legislation_code per_business_groups.legislation_code%TYPE;
1840: l_applicant_number per_all_people_f.applicant_number%TYPE;
1841: l_application_id per_applications.application_id%TYPE;

Line 2023: per_person_types ppt,

2019: per.npw_number,
2020: per.original_date_of_hire -- #2978566
2021: from per_all_people_f per,
2022: per_business_groups bus,
2023: per_person_types ppt,
2024: per_applications pap
2025: where per.person_type_id = ppt.person_type_id
2026: and per.business_group_id = bus.business_group_id
2027: and per.person_id = pap.person_id

Line 4112: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT hr_api.g_number

4108: (p_validate IN BOOLEAN --DEFAULT FALSE
4109: ,p_effective_date IN DATE
4110: ,p_person_id IN per_all_people_f.person_id%TYPE
4111: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4112: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT hr_api.g_number
4113: ,p_termination_reason IN per_applications.termination_reason%TYPE --DEFAULT NULL
4114: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4115: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4116: )

Line 4141: ,p_person_type_id IN per_person_types.person_type_id%TYPE

4137: (p_validate IN BOOLEAN
4138: ,p_effective_date IN DATE
4139: ,p_person_id IN per_all_people_f.person_id%TYPE
4140: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4141: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4142: ,p_termination_reason IN per_applications.termination_reason%TYPE
4143: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4144: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4145: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 4173: ,p_person_type_id IN per_person_types.person_type_id%TYPE

4169: (p_validate IN BOOLEAN
4170: ,p_effective_date IN DATE
4171: ,p_person_id IN per_all_people_f.person_id%TYPE
4172: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4173: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4174: ,p_termination_reason IN per_applications.termination_reason%TYPE
4175: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4176: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4177: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 4206: ,p_person_type_id IN per_person_types.person_type_id%TYPE

4202: (p_validate IN BOOLEAN
4203: ,p_effective_date IN DATE
4204: ,p_person_id IN per_all_people_f.person_id%TYPE
4205: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4206: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4207: ,p_termination_reason IN per_applications.termination_reason%TYPE
4208: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4209: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
4210: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE -- 8732296

Line 4226: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;

4222: l_asg_status_ovn number;
4223: l_effective_date DATE;
4224: --
4225: l_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_object_version_number;
4226: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
4227: l_person_type_id1 per_person_types.person_type_id%TYPE;
4228: --
4229: l_assignment_status_id number;
4230: l_assignment_status_type_id number;

Line 4227: l_person_type_id1 per_person_types.person_type_id%TYPE;

4223: l_effective_date DATE;
4224: --
4225: l_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_object_version_number;
4226: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
4227: l_person_type_id1 per_person_types.person_type_id%TYPE;
4228: --
4229: l_assignment_status_id number;
4230: l_assignment_status_type_id number;
4231: l_validation_start_date DATE;

Line 4238: l_system_person_type per_person_types.system_person_type%TYPE;

4234: l_effective_end_date DATE;
4235: --
4236: l_business_group_id hr_all_organization_units.organization_id%TYPE;
4237: l_org_now_no_manager_warning BOOLEAN;
4238: l_system_person_type per_person_types.system_person_type%TYPE;
4239: l_comment_id hr_comments.comment_id%TYPE;
4240: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4241: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4242: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

Line 4279: ,per_person_types pet

4275: ,per.employee_number
4276: ,pet.system_person_type
4277: ,per.npw_number
4278: FROM per_applications apl
4279: ,per_person_types pet
4280: ,per_people_f per
4281: WHERE p_effective_date BETWEEN apl.date_received
4282: AND NVL(apl.date_end,p_effective_date)
4283: AND apl.person_id = per.person_id

Line 4335: ,per_person_types ppt

4331: --
4332: CURSOR csr_lock_ptu(cp_person_id number, cp_termination_date date) IS
4333: SELECT null
4334: FROM per_person_type_usages_f ptu
4335: ,per_person_types ppt
4336: WHERE person_id = cp_person_id
4337: AND (effective_start_date > cp_termination_date
4338: OR
4339: cp_termination_date between effective_start_date

Line 4816: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL

4812: ,p_effective_date IN DATE
4813: ,p_person_id IN per_all_people_f.person_id%TYPE
4814: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4815: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4816: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4817: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4818: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4819: ) IS
4820: l_warning boolean;

Line 4845: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL

4841: ,p_effective_date IN DATE
4842: ,p_person_id IN per_all_people_f.person_id%TYPE
4843: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4844: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4845: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4846: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4847: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4848: ,p_appl_override_warning OUT NOCOPY boolean -- 3652025
4849: )

Line 4863: l_person_type_id per_person_types.person_type_id%TYPE;

4859: l_applicant_number CONSTANT per_all_people_f.applicant_number%TYPE := p_applicant_number;
4860: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4861: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4862: --
4863: l_person_type_id per_person_types.person_type_id%TYPE;
4864: l_person_type_id1 per_person_types.person_type_id%TYPE;
4865: --
4866: l_future_asgs_count INTEGER;
4867: l_system_person_type per_person_types.system_person_type%TYPE;

Line 4864: l_person_type_id1 per_person_types.person_type_id%TYPE;

4860: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4861: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4862: --
4863: l_person_type_id per_person_types.person_type_id%TYPE;
4864: l_person_type_id1 per_person_types.person_type_id%TYPE;
4865: --
4866: l_future_asgs_count INTEGER;
4867: l_system_person_type per_person_types.system_person_type%TYPE;
4868: l_effective_start_date DATE;

Line 4867: l_system_person_type per_person_types.system_person_type%TYPE;

4863: l_person_type_id per_person_types.person_type_id%TYPE;
4864: l_person_type_id1 per_person_types.person_type_id%TYPE;
4865: --
4866: l_future_asgs_count INTEGER;
4867: l_system_person_type per_person_types.system_person_type%TYPE;
4868: l_effective_start_date DATE;
4869: l_effective_end_date DATE;
4870: l_comment_id hr_comments.comment_id%TYPE;
4871: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

Line 4912: ,per_person_types pet

4908: ,bus.business_group_id
4909: ,bus.legislation_code
4910: FROM per_people_f per
4911: ,per_business_groups bus
4912: ,per_person_types pet
4913: WHERE per.person_type_id = pet.person_type_id
4914: AND per.business_group_id+0 = bus.business_group_id
4915: AND per.person_id = csr_per_details.p_person_id
4916: AND csr_per_details.p_effective_date BETWEEN per.effective_start_date

Line 5219: l_system_person_type per_person_types.system_person_type%type;

5215: l_applicant_number per_people_f.applicant_number%TYPE;
5216: l_npw_number per_people_f.npw_number%TYPE;
5217: l_per_object_version_number per_people_f.object_version_number%TYPE;
5218: l_full_name per_people_f.full_name%type;
5219: l_system_person_type per_person_types.system_person_type%type;
5220: l_effective_date date;
5221: l_effective_start_date date;
5222: l_effective_end_date date;
5223: l_default_start_time per_business_groups.default_start_time%type;

Line 5254: from per_person_types ppt

5250: select ppf.business_group_id
5251: ,ppf.employee_number
5252: ,ppf.npw_number
5253: ,ppt.system_person_type
5254: from per_person_types ppt
5255: ,per_people_f ppf
5256: where ppf.person_id = p_person_id
5257: and ppt.person_type_id = ppf.person_type_id
5258: and ppt.business_group_id + 0 = ppf.business_group_id