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 1095: l_current_applicant_flag per_people_f.current_applicant_flag%type;

1091: l_dob_null_warning boolean;
1092: l_orig_hire_warning boolean;
1093: l_comment_id number;
1094:
1095: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1096: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1097: l_current_employee_flag per_people_f.current_employee_flag%type;
1098: l_employee_number per_people_f.employee_number%type;
1099: l_applicant_number per_people_f.applicant_number%TYPE;

Line 1096: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

1092: l_orig_hire_warning boolean;
1093: l_comment_id number;
1094:
1095: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1096: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1097: l_current_employee_flag per_people_f.current_employee_flag%type;
1098: l_employee_number per_people_f.employee_number%type;
1099: l_applicant_number per_people_f.applicant_number%TYPE;
1100: l_npw_number per_people_f.npw_number%TYPE;

Line 1097: l_current_employee_flag per_people_f.current_employee_flag%type;

1093: l_comment_id number;
1094:
1095: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1096: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1097: l_current_employee_flag per_people_f.current_employee_flag%type;
1098: l_employee_number per_people_f.employee_number%type;
1099: l_applicant_number per_people_f.applicant_number%TYPE;
1100: l_npw_number per_people_f.npw_number%TYPE;
1101:

Line 1098: l_employee_number per_people_f.employee_number%type;

1094:
1095: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1096: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1097: l_current_employee_flag per_people_f.current_employee_flag%type;
1098: l_employee_number per_people_f.employee_number%type;
1099: l_applicant_number per_people_f.applicant_number%TYPE;
1100: l_npw_number per_people_f.npw_number%TYPE;
1101:
1102: l_full_name per_people_f.full_name%type;

Line 1099: l_applicant_number per_people_f.applicant_number%TYPE;

1095: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1096: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1097: l_current_employee_flag per_people_f.current_employee_flag%type;
1098: l_employee_number per_people_f.employee_number%type;
1099: l_applicant_number per_people_f.applicant_number%TYPE;
1100: l_npw_number per_people_f.npw_number%TYPE;
1101:
1102: l_full_name per_people_f.full_name%type;
1103:

Line 1100: l_npw_number per_people_f.npw_number%TYPE;

1096: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1097: l_current_employee_flag per_people_f.current_employee_flag%type;
1098: l_employee_number per_people_f.employee_number%type;
1099: l_applicant_number per_people_f.applicant_number%TYPE;
1100: l_npw_number per_people_f.npw_number%TYPE;
1101:
1102: l_full_name per_people_f.full_name%type;
1103:
1104: l_person_rec csr_get_person_details%ROWTYPE;

Line 1102: l_full_name per_people_f.full_name%type;

1098: l_employee_number per_people_f.employee_number%type;
1099: l_applicant_number per_people_f.applicant_number%TYPE;
1100: l_npw_number per_people_f.npw_number%TYPE;
1101:
1102: l_full_name per_people_f.full_name%type;
1103:
1104: l_person_rec csr_get_person_details%ROWTYPE;
1105: l_future_person_rec csr_get_person_details%ROWTYPE;
1106: l_ptu_rec csr_ptu_details%ROWTYPE;

Line 1562: l_current_applicant_flag per_people_f.current_applicant_flag%type;

1558: l_dob_null_warning boolean;
1559: l_orig_hire_warning boolean;
1560: l_comment_id number;
1561:
1562: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1563: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1564: l_current_employee_flag per_people_f.current_employee_flag%type;
1565: l_employee_number per_people_f.employee_number%type;
1566: l_applicant_number per_people_f.applicant_number%TYPE;

Line 1563: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

1559: l_orig_hire_warning boolean;
1560: l_comment_id number;
1561:
1562: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1563: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1564: l_current_employee_flag per_people_f.current_employee_flag%type;
1565: l_employee_number per_people_f.employee_number%type;
1566: l_applicant_number per_people_f.applicant_number%TYPE;
1567: l_npw_number per_people_f.npw_number%TYPE;

Line 1564: l_current_employee_flag per_people_f.current_employee_flag%type;

1560: l_comment_id number;
1561:
1562: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1563: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1564: l_current_employee_flag per_people_f.current_employee_flag%type;
1565: l_employee_number per_people_f.employee_number%type;
1566: l_applicant_number per_people_f.applicant_number%TYPE;
1567: l_npw_number per_people_f.npw_number%TYPE;
1568:

Line 1565: l_employee_number per_people_f.employee_number%type;

1561:
1562: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1563: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1564: l_current_employee_flag per_people_f.current_employee_flag%type;
1565: l_employee_number per_people_f.employee_number%type;
1566: l_applicant_number per_people_f.applicant_number%TYPE;
1567: l_npw_number per_people_f.npw_number%TYPE;
1568:
1569: l_full_name per_people_f.full_name%type;

Line 1566: l_applicant_number per_people_f.applicant_number%TYPE;

1562: l_current_applicant_flag per_people_f.current_applicant_flag%type;
1563: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1564: l_current_employee_flag per_people_f.current_employee_flag%type;
1565: l_employee_number per_people_f.employee_number%type;
1566: l_applicant_number per_people_f.applicant_number%TYPE;
1567: l_npw_number per_people_f.npw_number%TYPE;
1568:
1569: l_full_name per_people_f.full_name%type;
1570:

Line 1567: l_npw_number per_people_f.npw_number%TYPE;

1563: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
1564: l_current_employee_flag per_people_f.current_employee_flag%type;
1565: l_employee_number per_people_f.employee_number%type;
1566: l_applicant_number per_people_f.applicant_number%TYPE;
1567: l_npw_number per_people_f.npw_number%TYPE;
1568:
1569: l_full_name per_people_f.full_name%type;
1570:
1571: l_person_rec csr_get_person_details%ROWTYPE;

Line 1569: l_full_name per_people_f.full_name%type;

1565: l_employee_number per_people_f.employee_number%type;
1566: l_applicant_number per_people_f.applicant_number%TYPE;
1567: l_npw_number per_people_f.npw_number%TYPE;
1568:
1569: l_full_name per_people_f.full_name%type;
1570:
1571: l_person_rec csr_get_person_details%ROWTYPE;
1572: l_future_person_rec csr_get_person_details%ROWTYPE;
1573: l_ptu_rec csr_ptu_details%ROWTYPE;

Line 2281: l_business_group_id per_people_f.business_group_id%type;

2277: --
2278: -- declare local variables
2279: --
2280: l_proc constant varchar2(72) := g_package||'create_applicant_anytime';
2281: l_business_group_id per_people_f.business_group_id%type;
2282: l_name_combination_warning boolean;
2283: l_dob_null_warning boolean;
2284: l_orig_hire_warning boolean;
2285: l_organization_id per_business_groups.organization_id%type;

Line 2287: l_person_type_id per_people_f.person_type_id%type;

2283: l_dob_null_warning boolean;
2284: l_orig_hire_warning boolean;
2285: l_organization_id per_business_groups.organization_id%type;
2286: l_legislation_code per_business_groups.legislation_code%type;
2287: l_person_type_id per_people_f.person_type_id%type;
2288: l_application_id per_applications.application_id%type;
2289: l_comment_id per_assignments_f.comment_id%type;
2290: l_assignment_sequence per_assignments_f.assignment_sequence%type;
2291: l_assignment_id per_assignments_f.assignment_id%type;

Line 2293: l_current_applicant_flag per_people_f.current_applicant_flag%type;

2289: l_comment_id per_assignments_f.comment_id%type;
2290: l_assignment_sequence per_assignments_f.assignment_sequence%type;
2291: l_assignment_id per_assignments_f.assignment_id%type;
2292: l_object_version_number per_assignments_f.object_version_number%type;
2293: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2294: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2295: l_current_employee_flag per_people_f.current_employee_flag%type;
2296: l_employee_number per_people_f.employee_number%type;
2297: l_applicant_number per_people_f.applicant_number%TYPE;

Line 2294: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

2290: l_assignment_sequence per_assignments_f.assignment_sequence%type;
2291: l_assignment_id per_assignments_f.assignment_id%type;
2292: l_object_version_number per_assignments_f.object_version_number%type;
2293: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2294: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2295: l_current_employee_flag per_people_f.current_employee_flag%type;
2296: l_employee_number per_people_f.employee_number%type;
2297: l_applicant_number per_people_f.applicant_number%TYPE;
2298: l_npw_number per_people_f.npw_number%TYPE;

Line 2295: l_current_employee_flag per_people_f.current_employee_flag%type;

2291: l_assignment_id per_assignments_f.assignment_id%type;
2292: l_object_version_number per_assignments_f.object_version_number%type;
2293: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2294: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2295: l_current_employee_flag per_people_f.current_employee_flag%type;
2296: l_employee_number per_people_f.employee_number%type;
2297: l_applicant_number per_people_f.applicant_number%TYPE;
2298: l_npw_number per_people_f.npw_number%TYPE;
2299: l_per_object_version_number per_people_f.object_version_number%TYPE;

Line 2296: l_employee_number per_people_f.employee_number%type;

2292: l_object_version_number per_assignments_f.object_version_number%type;
2293: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2294: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2295: l_current_employee_flag per_people_f.current_employee_flag%type;
2296: l_employee_number per_people_f.employee_number%type;
2297: l_applicant_number per_people_f.applicant_number%TYPE;
2298: l_npw_number per_people_f.npw_number%TYPE;
2299: l_per_object_version_number per_people_f.object_version_number%TYPE;
2300: l_full_name per_people_f.full_name%type;

Line 2297: l_applicant_number per_people_f.applicant_number%TYPE;

2293: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2294: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2295: l_current_employee_flag per_people_f.current_employee_flag%type;
2296: l_employee_number per_people_f.employee_number%type;
2297: l_applicant_number per_people_f.applicant_number%TYPE;
2298: l_npw_number per_people_f.npw_number%TYPE;
2299: l_per_object_version_number per_people_f.object_version_number%TYPE;
2300: l_full_name per_people_f.full_name%type;
2301: l_system_person_type per_person_types.system_person_type%type;

Line 2298: l_npw_number per_people_f.npw_number%TYPE;

2294: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2295: l_current_employee_flag per_people_f.current_employee_flag%type;
2296: l_employee_number per_people_f.employee_number%type;
2297: l_applicant_number per_people_f.applicant_number%TYPE;
2298: l_npw_number per_people_f.npw_number%TYPE;
2299: l_per_object_version_number per_people_f.object_version_number%TYPE;
2300: l_full_name per_people_f.full_name%type;
2301: l_system_person_type per_person_types.system_person_type%type;
2302: l_effective_date date;

Line 2299: l_per_object_version_number per_people_f.object_version_number%TYPE;

2295: l_current_employee_flag per_people_f.current_employee_flag%type;
2296: l_employee_number per_people_f.employee_number%type;
2297: l_applicant_number per_people_f.applicant_number%TYPE;
2298: l_npw_number per_people_f.npw_number%TYPE;
2299: l_per_object_version_number per_people_f.object_version_number%TYPE;
2300: l_full_name per_people_f.full_name%type;
2301: l_system_person_type per_person_types.system_person_type%type;
2302: l_effective_date date;
2303: l_effective_start_date date;

Line 2300: l_full_name per_people_f.full_name%type;

2296: l_employee_number per_people_f.employee_number%type;
2297: l_applicant_number per_people_f.applicant_number%TYPE;
2298: l_npw_number per_people_f.npw_number%TYPE;
2299: l_per_object_version_number per_people_f.object_version_number%TYPE;
2300: l_full_name per_people_f.full_name%type;
2301: l_system_person_type per_person_types.system_person_type%type;
2302: l_effective_date date;
2303: l_effective_start_date date;
2304: l_effective_end_date date;

Line 2344: ,per_people_f ppf

2340: ,ppf.party_id
2341: ,ppf.effective_start_date
2342: ,ppt.system_person_type
2343: from per_person_types ppt
2344: ,per_people_f ppf
2345: where ppf.person_id = p_person_id
2346: and ppt.person_type_id = ppf.person_type_id
2347: and ppt.business_group_id + 0 = ppf.business_group_id
2348: and (l_effective_date

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

2430: hr_utility.set_location(' Leaving:'||l_proc, 10);
2431: end if;
2432: --
2433: -- Check that this person (p_person_id) exists as of l_effective_date
2434: -- the current person type (per_people_f.person_type_id) has a
2435: -- corresponding system person type.
2436: --
2437: open csr_chk_person_exists;
2438: fetch csr_chk_person_exists into