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 1510: l_system_person_type per_person_types.system_person_type%TYPE;

1506: l_person_type_id number := p_person_type_id;
1507: l_person_type_id1 number;
1508: l_unaccepted_asg_del_warning boolean;
1509: --
1510: l_system_person_type per_person_types.system_person_type%TYPE;
1511: l_business_group_id per_all_people_f.business_group_id%TYPE;
1512: l_legislation_code per_business_groups.legislation_code%TYPE;
1513: l_applicant_number per_all_people_f.applicant_number%TYPE;
1514: l_application_id per_applications.application_id%TYPE;

Line 1617: per_person_types ppt,

1613: per.npw_number,
1614: per.original_date_of_hire -- #2978566
1615: from per_all_people_f per,
1616: per_business_groups bus,
1617: per_person_types ppt,
1618: per_applications pap
1619: where per.person_type_id = ppt.person_type_id
1620: and per.business_group_id = bus.business_group_id
1621: and per.person_id = pap.person_id

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

3040: (p_validate IN BOOLEAN --DEFAULT FALSE
3041: ,p_effective_date IN DATE
3042: ,p_person_id IN per_all_people_f.person_id%TYPE
3043: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
3044: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT hr_api.g_number
3045: ,p_termination_reason IN per_applications.termination_reason%TYPE --DEFAULT NULL
3046: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
3047: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
3048: )

Line 3073: ,p_person_type_id IN per_person_types.person_type_id%TYPE

3069: (p_validate IN BOOLEAN
3070: ,p_effective_date IN DATE
3071: ,p_person_id IN per_all_people_f.person_id%TYPE
3072: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
3073: ,p_person_type_id IN per_person_types.person_type_id%TYPE
3074: ,p_termination_reason IN per_applications.termination_reason%TYPE
3075: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
3076: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
3077: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 3105: ,p_person_type_id IN per_person_types.person_type_id%TYPE

3101: (p_validate IN BOOLEAN
3102: ,p_effective_date IN DATE
3103: ,p_person_id IN per_all_people_f.person_id%TYPE
3104: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
3105: ,p_person_type_id IN per_person_types.person_type_id%TYPE
3106: ,p_termination_reason IN per_applications.termination_reason%TYPE
3107: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
3108: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
3109: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 3138: ,p_person_type_id IN per_person_types.person_type_id%TYPE

3134: (p_validate IN BOOLEAN
3135: ,p_effective_date IN DATE
3136: ,p_person_id IN per_all_people_f.person_id%TYPE
3137: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
3138: ,p_person_type_id IN per_person_types.person_type_id%TYPE
3139: ,p_termination_reason IN per_applications.termination_reason%TYPE
3140: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
3141: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
3142: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

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

3153: l_asg_status_ovn number;
3154: l_effective_date DATE;
3155: --
3156: l_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_object_version_number;
3157: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
3158: l_person_type_id1 per_person_types.person_type_id%TYPE;
3159: --
3160: l_assignment_status_id number;
3161: l_assignment_status_type_id number;

Line 3158: l_person_type_id1 per_person_types.person_type_id%TYPE;

3154: l_effective_date DATE;
3155: --
3156: l_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_object_version_number;
3157: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
3158: l_person_type_id1 per_person_types.person_type_id%TYPE;
3159: --
3160: l_assignment_status_id number;
3161: l_assignment_status_type_id number;
3162: l_validation_start_date DATE;

Line 3169: l_system_person_type per_person_types.system_person_type%TYPE;

3165: l_effective_end_date DATE;
3166: --
3167: l_business_group_id hr_all_organization_units.organization_id%TYPE;
3168: l_org_now_no_manager_warning BOOLEAN;
3169: l_system_person_type per_person_types.system_person_type%TYPE;
3170: l_comment_id hr_comments.comment_id%TYPE;
3171: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
3172: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
3173: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

Line 3210: ,per_person_types pet

3206: ,per.employee_number
3207: ,pet.system_person_type
3208: ,per.npw_number
3209: FROM per_applications apl
3210: ,per_person_types pet
3211: ,per_people_f per
3212: WHERE p_effective_date BETWEEN apl.date_received
3213: AND NVL(apl.date_end,p_effective_date)
3214: AND apl.person_id = per.person_id

Line 3266: ,per_person_types ppt

3262: --
3263: CURSOR csr_lock_ptu(cp_person_id number, cp_termination_date date) IS
3264: SELECT null
3265: FROM per_person_type_usages_f ptu
3266: ,per_person_types ppt
3267: WHERE person_id = cp_person_id
3268: AND (effective_start_date > cp_termination_date
3269: OR
3270: cp_termination_date between effective_start_date

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

3739: ,p_effective_date IN DATE
3740: ,p_person_id IN per_all_people_f.person_id%TYPE
3741: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
3742: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
3743: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
3744: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
3745: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
3746: ) IS
3747: l_warning boolean;

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

3768: ,p_effective_date IN DATE
3769: ,p_person_id IN per_all_people_f.person_id%TYPE
3770: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
3771: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
3772: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
3773: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
3774: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
3775: ,p_appl_override_warning OUT NOCOPY boolean -- 3652025
3776: )

Line 3790: l_person_type_id per_person_types.person_type_id%TYPE;

3786: l_applicant_number CONSTANT per_all_people_f.applicant_number%TYPE := p_applicant_number;
3787: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
3788: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
3789: --
3790: l_person_type_id per_person_types.person_type_id%TYPE;
3791: l_person_type_id1 per_person_types.person_type_id%TYPE;
3792: --
3793: l_future_asgs_count INTEGER;
3794: l_system_person_type per_person_types.system_person_type%TYPE;

Line 3791: l_person_type_id1 per_person_types.person_type_id%TYPE;

3787: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
3788: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
3789: --
3790: l_person_type_id per_person_types.person_type_id%TYPE;
3791: l_person_type_id1 per_person_types.person_type_id%TYPE;
3792: --
3793: l_future_asgs_count INTEGER;
3794: l_system_person_type per_person_types.system_person_type%TYPE;
3795: l_effective_start_date DATE;

Line 3794: l_system_person_type per_person_types.system_person_type%TYPE;

3790: l_person_type_id per_person_types.person_type_id%TYPE;
3791: l_person_type_id1 per_person_types.person_type_id%TYPE;
3792: --
3793: l_future_asgs_count INTEGER;
3794: l_system_person_type per_person_types.system_person_type%TYPE;
3795: l_effective_start_date DATE;
3796: l_effective_end_date DATE;
3797: l_comment_id hr_comments.comment_id%TYPE;
3798: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

Line 3839: ,per_person_types pet

3835: ,bus.business_group_id
3836: ,bus.legislation_code
3837: FROM per_people_f per
3838: ,per_business_groups bus
3839: ,per_person_types pet
3840: WHERE per.person_type_id = pet.person_type_id
3841: AND per.business_group_id+0 = bus.business_group_id
3842: AND per.person_id = csr_per_details.p_person_id
3843: AND csr_per_details.p_effective_date BETWEEN per.effective_start_date

Line 4146: l_system_person_type per_person_types.system_person_type%type;

4142: l_applicant_number per_people_f.applicant_number%TYPE;
4143: l_npw_number per_people_f.npw_number%TYPE;
4144: l_per_object_version_number per_people_f.object_version_number%TYPE;
4145: l_full_name per_people_f.full_name%type;
4146: l_system_person_type per_person_types.system_person_type%type;
4147: l_effective_date date;
4148: l_effective_start_date date;
4149: l_effective_end_date date;
4150: l_default_start_time per_business_groups.default_start_time%type;

Line 4181: from per_person_types ppt

4177: select ppf.business_group_id
4178: ,ppf.employee_number
4179: ,ppf.npw_number
4180: ,ppt.system_person_type
4181: from per_person_types ppt
4182: ,per_people_f ppf
4183: where ppf.person_id = p_person_id
4184: and ppt.person_type_id = ppf.person_type_id
4185: and ppt.business_group_id + 0 = ppf.business_group_id