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_APPLICATIONS

Line 231: l_date_received per_applications.date_received%TYPE;

227: --
228: -- Declare cursors and local variables
229: --
230: l_proc varchar2(72) := g_package||'create_applicant';
231: l_date_received per_applications.date_received%TYPE;
232: l_applicant_number per_all_people_f.applicant_number%TYPE;
233: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
234: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
235: l_background_date_check per_all_people_f.background_date_check%TYPE;

Line 241: l_application_id per_applications.application_id%TYPE;

237: l_projected_start_date per_all_people_f.projected_start_date%TYPE;
238: l_resume_last_updated per_all_people_f.resume_last_updated%TYPE;
239: l_person_id per_all_people_f.person_id%TYPE;
240: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
241: l_application_id per_applications.application_id%TYPE;
242: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
243: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
244: l_apl_object_version_number per_applications.object_version_number%TYPE;
245: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

Line 244: l_apl_object_version_number per_applications.object_version_number%TYPE;

240: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
241: l_application_id per_applications.application_id%TYPE;
242: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
243: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
244: l_apl_object_version_number per_applications.object_version_number%TYPE;
245: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
246: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
247: l_full_name per_all_people_f.full_name%TYPE;
248: l_per_comment_id per_all_people_f.comment_id%TYPE;

Line 1514: l_application_id per_applications.application_id%TYPE;

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;
1515: l_apl_object_version_number per_applications.application_id%TYPE;
1516: --
1517: l_hire_date date;
1518: l_original_date_of_hire date;

Line 1515: l_apl_object_version_number per_applications.application_id%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;
1515: l_apl_object_version_number per_applications.application_id%TYPE;
1516: --
1517: l_hire_date date;
1518: l_original_date_of_hire date;
1519: --

Line 1618: per_applications pap

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
1622: and per.person_id = p_person_id

Line 3045: ,p_termination_reason IN per_applications.termination_reason%TYPE --DEFAULT NULL

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: )
3049: IS

Line 3074: ,p_termination_reason IN per_applications.termination_reason%TYPE

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
3078: )

Line 3106: ,p_termination_reason IN per_applications.termination_reason%TYPE

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
3110: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025

Line 3139: ,p_termination_reason IN per_applications.termination_reason%TYPE

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
3143: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 3209: FROM per_applications apl

3205: ,per.applicant_number
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)

Line 3588: UPDATE per_applications

3584: hr_utility.set_location(l_proc,90);
3585: --
3586: -- End the application
3587: --
3588: UPDATE per_applications
3589: set date_end = l_effective_date
3590: ,termination_reason = p_termination_reason
3591: WHERE application_id = l_application.application_id;
3592: /*

Line 3805: l_application_id per_applications.application_id%TYPE;

3801: l_full_name per_all_people_f.full_name%TYPE;
3802: l_name_combination_warning BOOLEAN;
3803: l_dob_null_warning BOOLEAN;
3804: l_orig_hire_warning BOOLEAN;
3805: l_application_id per_applications.application_id%TYPE;
3806: l_apl_object_version_number per_applications.object_version_number%TYPE;
3807: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3808: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 3806: l_apl_object_version_number per_applications.object_version_number%TYPE;

3802: l_name_combination_warning BOOLEAN;
3803: l_dob_null_warning BOOLEAN;
3804: l_orig_hire_warning BOOLEAN;
3805: l_application_id per_applications.application_id%TYPE;
3806: l_apl_object_version_number per_applications.object_version_number%TYPE;
3807: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3808: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3810: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;

Line 4053: from per_applications

4049: RETURN VARCHAR2 IS
4050:
4051: cursor csr_fut_apl is
4052: select application_id
4053: from per_applications
4054: where person_id = p_person_id
4055: and date_received > p_effective_date
4056: order by date_received asc;
4057:

Line 4060: from per_applications

4056: order by date_received asc;
4057:
4058: cursor csr_current_apl is
4059: select application_id
4060: from per_applications
4061: where person_id = p_person_id
4062: and date_received < p_effective_date
4063: and nvl(date_end,hr_api.g_eot) >= p_effective_date;
4064:

Line 4067: from per_applications

4063: and nvl(date_end,hr_api.g_eot) >= p_effective_date;
4064:
4065: cursor csr_apl_yesterday is
4066: select application_id
4067: from per_applications
4068: where person_id = p_person_id
4069: and date_end = p_effective_date-1;
4070:
4071: l_future_apl_id per_applications.application_id%type;

Line 4071: l_future_apl_id per_applications.application_id%type;

4067: from per_applications
4068: where person_id = p_person_id
4069: and date_end = p_effective_date-1;
4070:
4071: l_future_apl_id per_applications.application_id%type;
4072: l_current_apl_id per_applications.application_id%type;
4073: l_yesterday_apl_id per_applications.application_id%type;
4074: l_raise_warning VARCHAR2(10);
4075:

Line 4072: l_current_apl_id per_applications.application_id%type;

4068: where person_id = p_person_id
4069: and date_end = p_effective_date-1;
4070:
4071: l_future_apl_id per_applications.application_id%type;
4072: l_current_apl_id per_applications.application_id%type;
4073: l_yesterday_apl_id per_applications.application_id%type;
4074: l_raise_warning VARCHAR2(10);
4075:
4076: BEGIN

Line 4073: l_yesterday_apl_id per_applications.application_id%type;

4069: and date_end = p_effective_date-1;
4070:
4071: l_future_apl_id per_applications.application_id%type;
4072: l_current_apl_id per_applications.application_id%type;
4073: l_yesterday_apl_id per_applications.application_id%type;
4074: l_raise_warning VARCHAR2(10);
4075:
4076: BEGIN
4077: l_raise_warning := 'N';

Line 4133: l_application_id per_applications.application_id%type;

4129: l_organization_id per_business_groups.organization_id%type;
4130: l_legislation_code per_business_groups.legislation_code%type;
4131: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
4132: l_person_type_id1 per_people_f.person_type_id%type;
4133: l_application_id per_applications.application_id%type;
4134: l_comment_id per_assignments_f.comment_id%type;
4135: l_assignment_sequence per_assignments_f.assignment_sequence%type;
4136: l_assignment_id per_assignments_f.assignment_id%type;
4137: l_object_version_number per_assignments_f.object_version_number%type;

Line 4168: l_apl_object_version_number per_applications.object_version_number%TYPE;

4164: --
4165: -- Local variable added for the before and after business process
4166: -- apply_for_job_anytime
4167: --
4168: l_apl_object_version_number per_applications.object_version_number%TYPE;
4169: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4170: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4171: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4172: --