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.PER_PEOPLE12_PKG dependencies on HR_API

Line 329: l_first_apl_date date := hr_api.g_eot;

325: l_orig_hire_warning boolean;
326: l_comment_id number;
327: l_effective_start_date date;
328: l_exists varchar2(1);
329: l_first_apl_date date := hr_api.g_eot;
330:
331: cursor person_record(p_effective_date date) is
332: select * from per_all_people_f
333: where person_id = p_person_id

Line 373: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);

369:
370: cursor chk_apl_exists(p_asg_start_date date) is
371: select application_id, date_end from per_applications
372: where person_id = p_person_id
373: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
374:
375: cursor get_apln_id is
376: select distinct application_id
377: from per_all_assignments_f

Line 721: ,p_effective_end_date => hr_api.g_eot -- ER FPT

717: --
718: -- VT 08/13/96
719: per_people9_pkg.insert_employee_rows(p_person_id => p_person_id
720: ,p_effective_start_date => p_effective_start_date
721: ,p_effective_end_date => hr_api.g_eot -- ER FPT
722: ,p_business_group_id =>p_business_group_id
723: ,p_emp_ass_status_type_id => p_emp_ass_status_type_id
724: ,p_employee_number => p_employee_number
725: ,p_request_id => p_request_id

Line 982: if l_apl_end_date = hr_api.g_eot then

978: where person_id = p_person_id
979: and assignment_id = apl.assignment_id
980: and assignment_type = 'A';
981:
982: if l_apl_end_date = hr_api.g_eot then
983: l_apl_end_date := null;
984: end if;
985:
986: -- check whether an application exists on the start date of the assignment

Line 1015: if nvl(l_current_apl_end_date,hr_api.g_eot) < nvl(l_apl_end_date,hr_api.g_eot) then

1011:
1012: -- if application is found, then extend the applciation till the end of the asgt's end date
1013: else
1014:
1015: if nvl(l_current_apl_end_date,hr_api.g_eot) < nvl(l_apl_end_date,hr_api.g_eot) then
1016: update per_applications
1017: set date_end = l_apl_end_date
1018: where person_id = p_person_id
1019: and application_id = l_cur_apl_id;

Line 1100: l_datetrack_mode := hr_api.g_update_change_insert;

1096: -- date track mode is set to UPDATE_CHANGE_INSERT when future EX_APL records exist
1097: open chk_fut_ex_apl(greatest(p_hire_date,p_session_date));
1098: fetch chk_fut_ex_apl into l_fut_ex_apl_exists;
1099: if chk_fut_ex_apl%found then
1100: l_datetrack_mode := hr_api.g_update_change_insert;
1101: else
1102: l_datetrack_mode := hr_api.g_update;
1103: end if;
1104:

Line 1102: l_datetrack_mode := hr_api.g_update;

1098: fetch chk_fut_ex_apl into l_fut_ex_apl_exists;
1099: if chk_fut_ex_apl%found then
1100: l_datetrack_mode := hr_api.g_update_change_insert;
1101: else
1102: l_datetrack_mode := hr_api.g_update;
1103: end if;
1104:
1105: hr_per_type_usage_internal.maintain_person_type_usage
1106: (p_effective_date => p_effective_start_date

Line 1128: if hr_api.return_legislation_code (l_bgid) ='US' and

1124: hr_utility.set_location('l_bgid call enthn pkg :'||l_bgid,262);
1125: hr_utility.set_location('p_s_system_person_type enthn pkg :'||p_s_system_person_type,262);
1126: hr_utility.set_location('l_perinfo1 enthn pkg :'||l_per_info1,262);
1127:
1128: if hr_api.return_legislation_code (l_bgid) ='US' and
1129: p_s_system_person_type in ('APL','EX_EMP_APL') and l_per_info1 is not null then
1130:
1131: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 call enthn pkg',262);
1132:

Line 1399: IF p_effective_end_date <> hr_api.g_eot and l_create_apl <> 'Y' THEN

1395: --End of Fix
1396: -- ER FPT
1397: -- correct per table data
1398:
1399: IF p_effective_end_date <> hr_api.g_eot and l_create_apl <> 'Y' THEN
1400:
1401: SELECT ppt.system_person_type
1402: INTO l_next_person_type
1403: FROM per_all_people_f per, per_person_types ppt

Line 1456: if l_first_apl_date <> hr_api.g_eot then

1452: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',276);
1453:
1454: if nvl(l_fpt_hire_flag,'N') = 'Y' then
1455:
1456: if l_first_apl_date <> hr_api.g_eot then
1457:
1458: update per_all_people_f
1459: set person_type_id = hr_person_type_usage_info.get_default_person_type_id(p_business_group_id,'EMP')
1460: ,current_applicant_flag = null

Line 1651: if nvl(apl.date_end,hr_api.g_eot) <> hr_api.g_eot then

1647: ,p_dob_null_warning => l_assign_payroll_warning
1648: ,p_orig_hire_warning => l_orig_hire_warning
1649: );
1650:
1651: if nvl(apl.date_end,hr_api.g_eot) <> hr_api.g_eot then
1652:
1653: -- check whether back-to-back application exists
1654:
1655: open csr_back_toback_apln(apl.date_end) ;

Line 1848: elsif p_status = 'HIRE' and p_effective_end_date <> hr_api.g_eot then

1844:
1845: end if;
1846:
1847: end loop;
1848: elsif p_status = 'HIRE' and p_effective_end_date <> hr_api.g_eot then
1849:
1850: UPDATE per_all_people_f
1851: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EMP')
1852: ,current_applicant_flag = NULL

Line 3595: if hr_api.return_legislation_code (l_bgid) ='US' and

3591: hr_utility.set_location('l_bgid call enthn pkg :'||l_bgid,262);
3592: hr_utility.set_location('p_s_system_person_type enthn pkg :'||p_s_system_person_type,262);
3593: hr_utility.set_location('l_perinfo1 enthn pkg :'||l_per_info1,262);
3594:
3595: if hr_api.return_legislation_code (l_bgid) ='US' and
3596: p_s_system_person_type in ('APL','EX_EMP_APL') and l_per_info1 is not null then
3597:
3598: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 call enthn pkg',262);
3599:

Line 4710: select contact_person_id, min(nvl(date_start,hr_api.g_sot)) date_start

4706: (p_person_id in number
4707: ,p_type in varchar2) is
4708: --
4709: cursor csr_get_contacts(c_person_id number) is
4710: select contact_person_id, min(nvl(date_start,hr_api.g_sot)) date_start
4711: from per_contact_relationships
4712: where person_id = c_person_id
4713: group by contact_person_id;
4714: --

Line 4716: select ctr.person_id, min(nvl(ctr.date_start,hr_api.g_sot)) date_start

4712: where person_id = c_person_id
4713: group by contact_person_id;
4714: --
4715: cursor csr_get_person(c_contact_person_id number) is
4716: select ctr.person_id, min(nvl(ctr.date_start,hr_api.g_sot)) date_start
4717: from per_contact_relationships ctr
4718: ,per_person_type_usages_f ptu
4719: ,per_person_types ppt
4720: where ctr.contact_person_id = c_contact_person_id