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_INTERNAL dependencies on PER_PEOPLE_F

Line 612: l_current_applicant_flag per_people_f.current_applicant_flag%type;

608: l_dob_null_warning boolean;
609: l_orig_hire_warning boolean;
610: l_comment_id number;
611:
612: l_current_applicant_flag per_people_f.current_applicant_flag%type;
613: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
614: l_current_employee_flag per_people_f.current_employee_flag%type;
615: l_employee_number per_people_f.employee_number%type;
616: l_applicant_number per_people_f.applicant_number%TYPE;

Line 613: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

609: l_orig_hire_warning boolean;
610: l_comment_id number;
611:
612: l_current_applicant_flag per_people_f.current_applicant_flag%type;
613: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
614: l_current_employee_flag per_people_f.current_employee_flag%type;
615: l_employee_number per_people_f.employee_number%type;
616: l_applicant_number per_people_f.applicant_number%TYPE;
617: l_npw_number per_people_f.npw_number%TYPE;

Line 614: l_current_employee_flag per_people_f.current_employee_flag%type;

610: l_comment_id number;
611:
612: l_current_applicant_flag per_people_f.current_applicant_flag%type;
613: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
614: l_current_employee_flag per_people_f.current_employee_flag%type;
615: l_employee_number per_people_f.employee_number%type;
616: l_applicant_number per_people_f.applicant_number%TYPE;
617: l_npw_number per_people_f.npw_number%TYPE;
618:

Line 615: l_employee_number per_people_f.employee_number%type;

611:
612: l_current_applicant_flag per_people_f.current_applicant_flag%type;
613: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
614: l_current_employee_flag per_people_f.current_employee_flag%type;
615: l_employee_number per_people_f.employee_number%type;
616: l_applicant_number per_people_f.applicant_number%TYPE;
617: l_npw_number per_people_f.npw_number%TYPE;
618:
619: l_full_name per_people_f.full_name%type;

Line 616: l_applicant_number per_people_f.applicant_number%TYPE;

612: l_current_applicant_flag per_people_f.current_applicant_flag%type;
613: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
614: l_current_employee_flag per_people_f.current_employee_flag%type;
615: l_employee_number per_people_f.employee_number%type;
616: l_applicant_number per_people_f.applicant_number%TYPE;
617: l_npw_number per_people_f.npw_number%TYPE;
618:
619: l_full_name per_people_f.full_name%type;
620:

Line 617: l_npw_number per_people_f.npw_number%TYPE;

613: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
614: l_current_employee_flag per_people_f.current_employee_flag%type;
615: l_employee_number per_people_f.employee_number%type;
616: l_applicant_number per_people_f.applicant_number%TYPE;
617: l_npw_number per_people_f.npw_number%TYPE;
618:
619: l_full_name per_people_f.full_name%type;
620:
621: l_person_rec csr_get_person_details%ROWTYPE;

Line 619: l_full_name per_people_f.full_name%type;

615: l_employee_number per_people_f.employee_number%type;
616: l_applicant_number per_people_f.applicant_number%TYPE;
617: l_npw_number per_people_f.npw_number%TYPE;
618:
619: l_full_name per_people_f.full_name%type;
620:
621: l_person_rec csr_get_person_details%ROWTYPE;
622: l_future_person_rec csr_get_person_details%ROWTYPE;
623: l_ptu_rec csr_ptu_details%ROWTYPE;

Line 935: l_current_applicant_flag per_people_f.current_applicant_flag%type;

931: l_dob_null_warning boolean;
932: l_orig_hire_warning boolean;
933: l_comment_id number;
934:
935: l_current_applicant_flag per_people_f.current_applicant_flag%type;
936: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
937: l_current_employee_flag per_people_f.current_employee_flag%type;
938: l_employee_number per_people_f.employee_number%type;
939: l_applicant_number per_people_f.applicant_number%TYPE;

Line 936: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

932: l_orig_hire_warning boolean;
933: l_comment_id number;
934:
935: l_current_applicant_flag per_people_f.current_applicant_flag%type;
936: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
937: l_current_employee_flag per_people_f.current_employee_flag%type;
938: l_employee_number per_people_f.employee_number%type;
939: l_applicant_number per_people_f.applicant_number%TYPE;
940: l_npw_number per_people_f.npw_number%TYPE;

Line 937: l_current_employee_flag per_people_f.current_employee_flag%type;

933: l_comment_id number;
934:
935: l_current_applicant_flag per_people_f.current_applicant_flag%type;
936: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
937: l_current_employee_flag per_people_f.current_employee_flag%type;
938: l_employee_number per_people_f.employee_number%type;
939: l_applicant_number per_people_f.applicant_number%TYPE;
940: l_npw_number per_people_f.npw_number%TYPE;
941:

Line 938: l_employee_number per_people_f.employee_number%type;

934:
935: l_current_applicant_flag per_people_f.current_applicant_flag%type;
936: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
937: l_current_employee_flag per_people_f.current_employee_flag%type;
938: l_employee_number per_people_f.employee_number%type;
939: l_applicant_number per_people_f.applicant_number%TYPE;
940: l_npw_number per_people_f.npw_number%TYPE;
941:
942: l_full_name per_people_f.full_name%type;

Line 939: l_applicant_number per_people_f.applicant_number%TYPE;

935: l_current_applicant_flag per_people_f.current_applicant_flag%type;
936: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
937: l_current_employee_flag per_people_f.current_employee_flag%type;
938: l_employee_number per_people_f.employee_number%type;
939: l_applicant_number per_people_f.applicant_number%TYPE;
940: l_npw_number per_people_f.npw_number%TYPE;
941:
942: l_full_name per_people_f.full_name%type;
943:

Line 940: l_npw_number per_people_f.npw_number%TYPE;

936: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
937: l_current_employee_flag per_people_f.current_employee_flag%type;
938: l_employee_number per_people_f.employee_number%type;
939: l_applicant_number per_people_f.applicant_number%TYPE;
940: l_npw_number per_people_f.npw_number%TYPE;
941:
942: l_full_name per_people_f.full_name%type;
943:
944: l_person_rec csr_get_person_details%ROWTYPE;

Line 942: l_full_name per_people_f.full_name%type;

938: l_employee_number per_people_f.employee_number%type;
939: l_applicant_number per_people_f.applicant_number%TYPE;
940: l_npw_number per_people_f.npw_number%TYPE;
941:
942: l_full_name per_people_f.full_name%type;
943:
944: l_person_rec csr_get_person_details%ROWTYPE;
945: l_future_person_rec csr_get_person_details%ROWTYPE;
946: l_ptu_rec csr_ptu_details%ROWTYPE;

Line 1402: l_current_applicant_flag per_people_f.current_applicant_flag%type;

1398: l_dob_null_warning boolean;
1399: l_orig_hire_warning boolean;
1400: l_comment_id number;
1401:
1402: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1403: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1404: l_current_employee_flag per_people_f.current_employee_flag%type;
1405: l_employee_number per_people_f.employee_number%type;
1406: l_applicant_number per_people_f.applicant_number%TYPE;

Line 1403: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

1399: l_orig_hire_warning boolean;
1400: l_comment_id number;
1401:
1402: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1403: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1404: l_current_employee_flag per_people_f.current_employee_flag%type;
1405: l_employee_number per_people_f.employee_number%type;
1406: l_applicant_number per_people_f.applicant_number%TYPE;
1407: l_npw_number per_people_f.npw_number%TYPE;

Line 1404: l_current_employee_flag per_people_f.current_employee_flag%type;

1400: l_comment_id number;
1401:
1402: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1403: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1404: l_current_employee_flag per_people_f.current_employee_flag%type;
1405: l_employee_number per_people_f.employee_number%type;
1406: l_applicant_number per_people_f.applicant_number%TYPE;
1407: l_npw_number per_people_f.npw_number%TYPE;
1408:

Line 1405: l_employee_number per_people_f.employee_number%type;

1401:
1402: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1403: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1404: l_current_employee_flag per_people_f.current_employee_flag%type;
1405: l_employee_number per_people_f.employee_number%type;
1406: l_applicant_number per_people_f.applicant_number%TYPE;
1407: l_npw_number per_people_f.npw_number%TYPE;
1408:
1409: l_full_name per_people_f.full_name%type;

Line 1406: l_applicant_number per_people_f.applicant_number%TYPE;

1402: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1403: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1404: l_current_employee_flag per_people_f.current_employee_flag%type;
1405: l_employee_number per_people_f.employee_number%type;
1406: l_applicant_number per_people_f.applicant_number%TYPE;
1407: l_npw_number per_people_f.npw_number%TYPE;
1408:
1409: l_full_name per_people_f.full_name%type;
1410:

Line 1407: l_npw_number per_people_f.npw_number%TYPE;

1403: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1404: l_current_employee_flag per_people_f.current_employee_flag%type;
1405: l_employee_number per_people_f.employee_number%type;
1406: l_applicant_number per_people_f.applicant_number%TYPE;
1407: l_npw_number per_people_f.npw_number%TYPE;
1408:
1409: l_full_name per_people_f.full_name%type;
1410:
1411: l_person_rec csr_get_person_details%ROWTYPE;

Line 1409: l_full_name per_people_f.full_name%type;

1405: l_employee_number per_people_f.employee_number%type;
1406: l_applicant_number per_people_f.applicant_number%TYPE;
1407: l_npw_number per_people_f.npw_number%TYPE;
1408:
1409: l_full_name per_people_f.full_name%type;
1410:
1411: l_person_rec csr_get_person_details%ROWTYPE;
1412: l_future_person_rec csr_get_person_details%ROWTYPE;
1413: l_ptu_rec csr_ptu_details%ROWTYPE;

Line 2064: l_business_group_id per_people_f.business_group_id%type;

2060: --
2061: -- declare local variables
2062: --
2063: l_proc constant varchar2(72) := g_package||'create_applicant_anytime';
2064: l_business_group_id per_people_f.business_group_id%type;
2065: l_name_combination_warning boolean;
2066: l_dob_null_warning boolean;
2067: l_orig_hire_warning boolean;
2068: l_organization_id per_business_groups.organization_id%type;

Line 2070: l_person_type_id per_people_f.person_type_id%type;

2066: l_dob_null_warning boolean;
2067: l_orig_hire_warning boolean;
2068: l_organization_id per_business_groups.organization_id%type;
2069: l_legislation_code per_business_groups.legislation_code%type;
2070: l_person_type_id per_people_f.person_type_id%type;
2071: l_application_id per_applications.application_id%type;
2072: l_comment_id per_assignments_f.comment_id%type;
2073: l_assignment_sequence per_assignments_f.assignment_sequence%type;
2074: l_assignment_id per_assignments_f.assignment_id%type;

Line 2076: l_current_applicant_flag per_people_f.current_applicant_flag%type;

2072: l_comment_id per_assignments_f.comment_id%type;
2073: l_assignment_sequence per_assignments_f.assignment_sequence%type;
2074: l_assignment_id per_assignments_f.assignment_id%type;
2075: l_object_version_number per_assignments_f.object_version_number%type;
2076: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2077: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2078: l_current_employee_flag per_people_f.current_employee_flag%type;
2079: l_employee_number per_people_f.employee_number%type;
2080: l_applicant_number per_people_f.applicant_number%TYPE;

Line 2077: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

2073: l_assignment_sequence per_assignments_f.assignment_sequence%type;
2074: l_assignment_id per_assignments_f.assignment_id%type;
2075: l_object_version_number per_assignments_f.object_version_number%type;
2076: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2077: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2078: l_current_employee_flag per_people_f.current_employee_flag%type;
2079: l_employee_number per_people_f.employee_number%type;
2080: l_applicant_number per_people_f.applicant_number%TYPE;
2081: l_npw_number per_people_f.npw_number%TYPE;

Line 2078: l_current_employee_flag per_people_f.current_employee_flag%type;

2074: l_assignment_id per_assignments_f.assignment_id%type;
2075: l_object_version_number per_assignments_f.object_version_number%type;
2076: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2077: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2078: l_current_employee_flag per_people_f.current_employee_flag%type;
2079: l_employee_number per_people_f.employee_number%type;
2080: l_applicant_number per_people_f.applicant_number%TYPE;
2081: l_npw_number per_people_f.npw_number%TYPE;
2082: l_per_object_version_number per_people_f.object_version_number%TYPE;

Line 2079: l_employee_number per_people_f.employee_number%type;

2075: l_object_version_number per_assignments_f.object_version_number%type;
2076: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2077: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2078: l_current_employee_flag per_people_f.current_employee_flag%type;
2079: l_employee_number per_people_f.employee_number%type;
2080: l_applicant_number per_people_f.applicant_number%TYPE;
2081: l_npw_number per_people_f.npw_number%TYPE;
2082: l_per_object_version_number per_people_f.object_version_number%TYPE;
2083: l_full_name per_people_f.full_name%type;

Line 2080: l_applicant_number per_people_f.applicant_number%TYPE;

2076: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2077: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2078: l_current_employee_flag per_people_f.current_employee_flag%type;
2079: l_employee_number per_people_f.employee_number%type;
2080: l_applicant_number per_people_f.applicant_number%TYPE;
2081: l_npw_number per_people_f.npw_number%TYPE;
2082: l_per_object_version_number per_people_f.object_version_number%TYPE;
2083: l_full_name per_people_f.full_name%type;
2084: l_system_person_type per_person_types.system_person_type%type;

Line 2081: l_npw_number per_people_f.npw_number%TYPE;

2077: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2078: l_current_employee_flag per_people_f.current_employee_flag%type;
2079: l_employee_number per_people_f.employee_number%type;
2080: l_applicant_number per_people_f.applicant_number%TYPE;
2081: l_npw_number per_people_f.npw_number%TYPE;
2082: l_per_object_version_number per_people_f.object_version_number%TYPE;
2083: l_full_name per_people_f.full_name%type;
2084: l_system_person_type per_person_types.system_person_type%type;
2085: l_effective_date date;

Line 2082: l_per_object_version_number per_people_f.object_version_number%TYPE;

2078: l_current_employee_flag per_people_f.current_employee_flag%type;
2079: l_employee_number per_people_f.employee_number%type;
2080: l_applicant_number per_people_f.applicant_number%TYPE;
2081: l_npw_number per_people_f.npw_number%TYPE;
2082: l_per_object_version_number per_people_f.object_version_number%TYPE;
2083: l_full_name per_people_f.full_name%type;
2084: l_system_person_type per_person_types.system_person_type%type;
2085: l_effective_date date;
2086: l_effective_start_date date;

Line 2083: l_full_name per_people_f.full_name%type;

2079: l_employee_number per_people_f.employee_number%type;
2080: l_applicant_number per_people_f.applicant_number%TYPE;
2081: l_npw_number per_people_f.npw_number%TYPE;
2082: l_per_object_version_number per_people_f.object_version_number%TYPE;
2083: l_full_name per_people_f.full_name%type;
2084: l_system_person_type per_person_types.system_person_type%type;
2085: l_effective_date date;
2086: l_effective_start_date date;
2087: l_effective_end_date date;

Line 2127: ,per_people_f ppf

2123: ,ppf.party_id
2124: ,ppf.effective_start_date
2125: ,ppt.system_person_type
2126: from per_person_types ppt
2127: ,per_people_f ppf
2128: where ppf.person_id = p_person_id
2129: and ppt.person_type_id = ppf.person_type_id
2130: and ppt.business_group_id + 0 = ppf.business_group_id
2131: and (l_effective_date

Line 2217: -- the current person type (per_people_f.person_type_id) has a

2213: hr_utility.set_location(' Leaving:'||l_proc, 10);
2214: end if;
2215: --
2216: -- Check that this person (p_person_id) exists as of l_effective_date
2217: -- the current person type (per_people_f.person_type_id) has a
2218: -- corresponding system person type.
2219: --
2220: open csr_chk_person_exists;
2221: fetch csr_chk_person_exists into