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 1884: l_vacancy_id per_all_assignments_f.vacancy_id%type;

1880: l_other_manager_warning boolean;
1881: l_no_managers_warning boolean;
1882: l_org_now_no_manager_warning boolean;
1883: l_oversubscribed_vacancy_id number;
1884: l_vacancy_id per_all_assignments_f.vacancy_id%type;
1885: l_dummy number;
1886: --
1887: l_change_reason varchar2(30);
1888: --bug no 5105005

Line 1920: from per_all_assignments_f

1916: and date_received = l_apln_date_to +1;
1917:
1918: cursor csr_fut_asg_rec is
1919: select assignment_id, effective_start_date, effective_end_date
1920: from per_all_assignments_f
1921: where person_id= p_person_id
1922: and effective_start_date > p_hire_date
1923: and assignment_type = 'A'
1924: and application_id = l_application_id

Line 1933: select 'Y' from per_all_assignments_f

1929: where person_id = p_person_id
1930: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
1931:
1932: cursor chk_future_changes(p_assignment_id number) is
1933: select 'Y' from per_all_assignments_f
1934: where person_id = p_person_id
1935: and assignment_id = p_assignment_id
1936: and effective_start_date >= p_hire_date;
1937:

Line 1961: from per_all_assignments_f asg,

1957: -- bug 14523339
1958: l_dummy_char varchar2(1);
1959: cursor chk_hire_date is
1960: select 'Y'
1961: from per_all_assignments_f asg,
1962: per_assignment_status_types pas
1963: where asg.assignment_status_type_id = pas.assignment_status_type_id
1964: and asg.person_id = p_person_id
1965: and pas.per_system_status = 'ACCEPTED'

Line 2000: from per_all_assignments_f asg

1996: -- Bug# 2273304 End Here
1997: -- ER FPT
1998: cursor csr_future_asg_changes is
1999: select 'x'
2000: from per_all_assignments_f asg
2001: where asg.person_id = p_person_id
2002: and asg.effective_start_date > p_hire_date;--bug no 5105005
2003:
2004: cursor fpt_future_asg_changes is

Line 2006: from per_all_assignments_f asg

2002: and asg.effective_start_date > p_hire_date;--bug no 5105005
2003:
2004: cursor fpt_future_asg_changes is
2005: select 'x'
2006: from per_all_assignments_f asg
2007: where asg.person_id = p_person_id
2008: and asg.effective_start_date > p_hire_date
2009: and asg.assignment_type = 'E';
2010: -- ER FPT

Line 2121: from per_all_assignments_f asg

2117: from per_all_vacancies vac
2118: where vac.vacancy_id=p_vacancy_id
2119: and vac.number_of_openings <
2120: (select count(distinct assignment_id)
2121: from per_all_assignments_f asg
2122: where asg.vacancy_id=p_vacancy_id
2123: and asg.assignment_type='E');
2124: --
2125: --start for i-rec enhancement ww bug # 2675202

Line 2225: from per_all_assignments_f asg

2221: -- Fix For Bug 5749371 Starts
2222:
2223: cursor csr_existing_SCL (crs_asg_id number) is
2224: select soft_coding_keyflex_id,payroll_id
2225: from per_all_assignments_f asg
2226: where asg.assignment_id = crs_asg_id
2227: -- and asg.primary_flag = 'Y'
2228: and trunc(sysdate) between asg.effective_start_date
2229: and asg.effective_end_date;

Line 2238: l_payroll_id per_all_assignments_f.payroll_id%type;

2234: from hr_soft_coding_keyflex
2235: where rownum=1;
2236:
2237: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
2238: l_payroll_id per_all_assignments_f.payroll_id%type;
2239: l_dummy_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
2240:
2241: -- Fix For Bug 5749371 Ends
2242:

Line 2256: from per_all_assignments_f PAAF

2252: and asg.assignment_type = 'A' ;
2253:
2254: cursor get_business_group(p_asg_id number) is
2255: select distinct PAAF.business_group_id
2256: from per_all_assignments_f PAAF
2257: where PAAF.assignment_id=p_asg_id;
2258: l_bg_id number;
2259: l_ass_id number;
2260: -- Bug 8831084 Fix Ends

Line 2265: from per_all_assignments_f

2261:
2262: -- Start changes for bug 9879782
2263: cursor csr_get_appl_id(lp_assignment_id number) is
2264: select application_id
2265: from per_all_assignments_f
2266: where assignment_id = lp_assignment_id
2267: and p_hire_date between effective_start_date and effective_end_date;
2268:
2269: l_appl_id number;

Line 2339: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE

2335:
2336:
2337: ---- Fix For Bug # 10648201 Starts ----
2338: FUNCTION get_probation_end_date(p_appl_id IN INTEGER
2339: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
2340: ,p_hire_date date
2341: ) return date is
2342: l_date_probation_end date;
2343: l_proj_hire_date date;

Line 2345: l_probation_period per_all_assignments_f.probation_period%TYPE;

2341: ) return date is
2342: l_date_probation_end date;
2343: l_proj_hire_date date;
2344: x_date_probation_end date;
2345: l_probation_period per_all_assignments_f.probation_period%TYPE;
2346: l_probation_unit per_all_assignments_f.probation_unit%TYPE;
2347:
2348: cursor appl_rec_det(l_appl_id number) is
2349: select projected_hire_date

Line 2346: l_probation_unit per_all_assignments_f.probation_unit%TYPE;

2342: l_date_probation_end date;
2343: l_proj_hire_date date;
2344: x_date_probation_end date;
2345: l_probation_period per_all_assignments_f.probation_period%TYPE;
2346: l_probation_unit per_all_assignments_f.probation_unit%TYPE;
2347:
2348: cursor appl_rec_det(l_appl_id number) is
2349: select projected_hire_date
2350: from per_applications

Line 2353: cursor c_get_pro_dates(p_assignment_id per_all_assignments_f.assignment_id%TYPE,

2349: select projected_hire_date
2350: from per_applications
2351: where application_id =l_appl_id;
2352:
2353: cursor c_get_pro_dates(p_assignment_id per_all_assignments_f.assignment_id%TYPE,
2354: p_hire_date date) is
2355: select probation_period,probation_unit,DATE_PROBATION_END from per_all_assignments_f
2356: where assignment_id = p_assignment_id and
2357: p_hire_date between effective_start_date and effective_end_date;

Line 2355: select probation_period,probation_unit,DATE_PROBATION_END from per_all_assignments_f

2351: where application_id =l_appl_id;
2352:
2353: cursor c_get_pro_dates(p_assignment_id per_all_assignments_f.assignment_id%TYPE,
2354: p_hire_date date) is
2355: select probation_period,probation_unit,DATE_PROBATION_END from per_all_assignments_f
2356: where assignment_id = p_assignment_id and
2357: p_hire_date between effective_start_date and effective_end_date;
2358:
2359: begin

Line 2864: from per_all_assignments_f

2860: l_fpt_hire_flag :='Y';
2861:
2862: -- retrieve the max end date of the ASG to update the APLN date_end
2863: select max(effective_end_date) into l_apl_end_date
2864: from per_all_assignments_f
2865: where person_id = p_person_id
2866: and assignment_id = apl.assignment_id
2867: and assignment_type = 'A';
2868:

Line 2911: update per_all_assignments_f

2907:
2908: close chk_apl_exists;
2909:
2910: -- update the ASG with the correct APLN ID
2911: update per_all_assignments_f
2912: set application_id = l_cur_apl_id
2913: where person_id = p_person_id
2914: and assignment_id = apl.assignment_id
2915: and effective_start_date = apl.effective_start_date

Line 2983: from per_all_assignments_f where assignment_id= l_assignment_id

2979: if l_change_reason is null then
2980: begin
2981:
2982: select CHANGE_REASON into l_change_reason
2983: from per_all_assignments_f where assignment_id= l_assignment_id
2984: and l_hire_date -1 between effective_start_date and effective_end_date ;
2985:
2986: exception when no_data_found then
2987: null;

Line 3986: FROM per_all_assignments_f

3982: p_hire_date);
3983:
3984: SELECT object_version_number
3985: INTO l_asg_object_Version_number
3986: FROM per_all_assignments_f
3987: WHERE business_group_id = l_business_group_id
3988: and person_id = p_person_id
3989: and assignment_id = l_assignment_id
3990: and effective_start_Date = p_hire_date;

Line 4143: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

4139: ,p_person_id IN per_all_people_f.person_id%TYPE
4140: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4141: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4142: ,p_termination_reason IN per_applications.termination_reason%TYPE
4143: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4144: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4145: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4146: )
4147: IS

Line 4175: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

4171: ,p_person_id IN per_all_people_f.person_id%TYPE
4172: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4173: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4174: ,p_termination_reason IN per_applications.termination_reason%TYPE
4175: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4176: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4177: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4178: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
4179: )

Line 4208: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

4204: ,p_person_id IN per_all_people_f.person_id%TYPE
4205: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4206: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4207: ,p_termination_reason IN per_applications.termination_reason%TYPE
4208: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4209: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
4210: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE -- 8732296
4211: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4212: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

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

4205: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4206: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4207: ,p_termination_reason IN per_applications.termination_reason%TYPE
4208: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4209: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
4210: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE -- 8732296
4211: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4212: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4213: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025

Line 4261: From per_all_assignments_f

4257: -- Local cursors
4258: --
4259: Cursor csr_vacancy_id(l_assg_id number) is
4260: Select vacancy_id
4261: From per_all_assignments_f
4262: Where assignment_id = l_assg_id
4263: And p_effective_date between effective_start_date and effective_end_date;
4264: --fix for bug 7229710 Ends here.
4265:

Line 4299: FROM per_all_assignments_f asg

4295: SELECT asg.assignment_id
4296: ,asg.object_version_number
4297: ,asg.effective_end_date -- 3652025
4298: ,asg.assignment_status_type_id --7229710
4299: FROM per_all_assignments_f asg
4300: WHERE asg.person_id = p_person_id
4301: AND p_effective_date+1 BETWEEN asg.effective_start_date
4302: AND asg.effective_end_date
4303: AND asg.assignment_type = 'A';

Line 4310: FROM per_all_assignments_f as2

4306: CURSOR csr_get_future_apl_asg(cp_person_id number
4307: , cp_effective_date date
4308: , cp_application_id number) IS
4309: SELECT as2.assignment_id, as2.effective_start_date, as2.object_version_number
4310: FROM per_all_assignments_f as2
4311: WHERE as2.person_id = cp_person_id
4312: AND as2.application_id = cp_application_id
4313: AND as2.assignment_type = 'A'
4314: AND as2.effective_start_date > cp_effective_date

Line 4317: from per_all_assignments_f as1

4313: AND as2.assignment_type = 'A'
4314: AND as2.effective_start_date > cp_effective_date
4315: AND not exists
4316: (select 'N'
4317: from per_all_assignments_f as1
4318: where as1.assignment_id = as2.assignment_id
4319: and as1.effective_start_date < as2.effective_start_date)
4320: ORDER BY as2.effective_start_date, as2.assignment_id ASC;
4321:

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

4854: l_proc VARCHAR2(72) := g_package||'convert_to_applicant';
4855: --
4856: l_effective_date DATE;
4857: --
4858: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
4859: l_applicant_number CONSTANT per_all_people_f.applicant_number%TYPE := p_applicant_number;
4860: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4861: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4862: --

Line 4880: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

4876: l_dob_null_warning BOOLEAN;
4877: l_orig_hire_warning BOOLEAN;
4878: l_application_id per_applications.application_id%TYPE;
4879: l_apl_object_version_number per_applications.object_version_number%TYPE;
4880: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4881: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4882: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4883: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4884: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;

Line 4881: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

4877: l_orig_hire_warning BOOLEAN;
4878: l_application_id per_applications.application_id%TYPE;
4879: l_apl_object_version_number per_applications.object_version_number%TYPE;
4880: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4881: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4882: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4883: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4884: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
4885: --

Line 4882: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

4878: l_application_id per_applications.application_id%TYPE;
4879: l_apl_object_version_number per_applications.object_version_number%TYPE;
4880: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4881: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4882: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4883: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4884: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
4885: --
4886: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;

Line 5242: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

5238: -- Local variable added for the before and after business process
5239: -- apply_for_job_anytime
5240: --
5241: l_apl_object_version_number per_applications.object_version_number%TYPE;
5242: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
5243: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
5244: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
5245: --
5246: --