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_ALL_ASSIGNMENTS_F

Line 240: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

236: l_hold_applicant_date_until per_all_people_f.hold_applicant_date_until%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;

Line 243: l_asg_object_version_number per_all_assignments_f.object_version_number%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;
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;

Line 251: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

247: l_full_name per_all_people_f.full_name%TYPE;
248: l_per_comment_id per_all_people_f.comment_id%TYPE;
249: l_employee_number per_all_people_f.employee_number%TYPE;
250: l_npw_number per_all_people_f.npw_number%TYPE;
251: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
252: l_name_combination_warning boolean;
253: l_orig_hire_warning boolean;
254: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
255: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;

Line 1557: l_vacancy_id per_all_assignments_f.vacancy_id%type;

1553: l_other_manager_warning boolean;
1554: l_no_managers_warning boolean;
1555: l_org_now_no_manager_warning boolean;
1556: l_oversubscribed_vacancy_id number;
1557: l_vacancy_id per_all_assignments_f.vacancy_id%type;
1558: l_dummy number;
1559: --
1560: --bug no 5105005
1561: l_datetrack_mode varchar2(10):='UPDATE';

Line 1715: from per_all_assignments_f asg

1711: from per_all_vacancies vac
1712: where vac.vacancy_id=p_vacancy_id
1713: and vac.number_of_openings <
1714: (select count(distinct assignment_id)
1715: from per_all_assignments_f asg
1716: where asg.vacancy_id=p_vacancy_id
1717: and asg.assignment_type='E');
1718: --
1719: --start for i-rec enhancement ww bug # 2675202

Line 1817: from per_all_assignments_f asg

1813: -- Fix For Bug 5749371 Starts
1814:
1815: cursor csr_existing_SCL (crs_asg_id number) is
1816: select soft_coding_keyflex_id,payroll_id
1817: from per_all_assignments_f asg
1818: where asg.assignment_id = crs_asg_id
1819: -- and asg.primary_flag = 'Y'
1820: and trunc(sysdate) between asg.effective_start_date
1821: and asg.effective_end_date;

Line 1830: l_payroll_id per_all_assignments_f.payroll_id%type;

1826: from hr_soft_coding_keyflex
1827: where rownum=1;
1828:
1829: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
1830: l_payroll_id per_all_assignments_f.payroll_id%type;
1831: l_dummy_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
1832:
1833: -- Fix For Bug 5749371 Ends
1834:

Line 2933: FROM per_all_assignments_f

2929: p_hire_date);
2930:
2931: SELECT object_version_number
2932: INTO l_asg_object_Version_number
2933: FROM per_all_assignments_f
2934: WHERE business_group_id = l_business_group_id
2935: and person_id = p_person_id
2936: and assignment_id = l_assignment_id
2937: and effective_start_Date = p_hire_date;

Line 3075: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

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

Line 3107: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

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

Line 3140: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

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

Line 3141: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579

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
3144: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
3145: )

Line 3192: From per_all_assignments_f

3188: -- Local cursors
3189: --
3190: Cursor csr_vacancy_id(l_assg_id number) is
3191: Select vacancy_id
3192: From per_all_assignments_f
3193: Where assignment_id = l_assg_id
3194: And p_effective_date between effective_start_date and effective_end_date;
3195: --fix for bug 7229710 Ends here.
3196:

Line 3230: FROM per_all_assignments_f asg

3226: SELECT asg.assignment_id
3227: ,asg.object_version_number
3228: ,asg.effective_end_date -- 3652025
3229: ,asg.assignment_status_type_id --7229710
3230: FROM per_all_assignments_f asg
3231: WHERE asg.person_id = p_person_id
3232: AND p_effective_date+1 BETWEEN asg.effective_start_date
3233: AND asg.effective_end_date
3234: AND asg.assignment_type = 'A';

Line 3241: FROM per_all_assignments_f as2

3237: CURSOR csr_get_future_apl_asg(cp_person_id number
3238: , cp_effective_date date
3239: , cp_application_id number) IS
3240: SELECT as2.assignment_id, as2.effective_start_date, as2.object_version_number
3241: FROM per_all_assignments_f as2
3242: WHERE as2.person_id = cp_person_id
3243: AND as2.application_id = cp_application_id
3244: AND as2.assignment_type = 'A'
3245: AND as2.effective_start_date > cp_effective_date

Line 3248: from per_all_assignments_f as1

3244: AND as2.assignment_type = 'A'
3245: AND as2.effective_start_date > cp_effective_date
3246: AND not exists
3247: (select 'N'
3248: from per_all_assignments_f as1
3249: where as1.assignment_id = as2.assignment_id
3250: and as1.effective_start_date < as2.effective_start_date)
3251: ORDER BY as2.effective_start_date, as2.assignment_id ASC;
3252:

Line 3785: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;

3781: l_proc VARCHAR2(72) := g_package||'convert_to_applicant';
3782: --
3783: l_effective_date DATE;
3784: --
3785: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
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: --

Line 3807: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

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;
3811: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;

Line 3808: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

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;
3811: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
3812: --

Line 3809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

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;
3811: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
3812: --
3813: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;

Line 4169: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

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: --
4173: --