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_PERSON_TYPE_USAGE_INFO

Line 357: and person_type_id = hr_person_type_usage_info.get_default_person_type_id(p_business_group_id,'EX_APL')

353:
354: cursor chk_fut_ex_apl(p_hire_date date) is
355: select 'Y' from per_person_type_usages_f
356: where person_id = p_person_id
357: and person_type_id = hr_person_type_usage_info.get_default_person_type_id(p_business_group_id,'EX_APL')
358: and effective_start_date > p_hire_date;
359:
360: cursor csr_fut_asg_rec(p_application_id number) is
361: select assignment_id, effective_start_date, effective_end_date

Line 1108: ,p_person_type_id => hr_person_type_usage_info.get_default_person_type_id

1104:
1105: hr_per_type_usage_internal.maintain_person_type_usage
1106: (p_effective_date => p_effective_start_date
1107: ,p_person_id => p_person_id
1108: ,p_person_type_id => hr_person_type_usage_info.get_default_person_type_id
1109: (p_business_group_id
1110: ,'EX_APL')
1111: ,p_datetrack_update_mode => l_datetrack_mode
1112: );

Line 1228: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||hr_person_type_usage_info.get_default_person_type_id(

1224: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',272);
1225: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_person_type_id,272);
1226: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_s_system_person_type,272);
1227: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||p_system_person_type,272);
1228: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||hr_person_type_usage_info.get_default_person_type_id(
1229: p_business_group_id,p_system_person_type),272);
1230:
1231: -- Bug 6196362 Starts.
1232: -- update per_people_f ppf

Line 1240: --,ppf.person_type_id =hr_person_type_usage_info.get_default_person_type_id( p_business_group_id ,p_system_person_type) bug 6848958

1236: ,ppf.effective_start_date = p_effective_start_date
1237: ,ppf.effective_end_date = p_effective_end_date
1238: ,ppf.business_group_id = p_business_group_id
1239: -- ,ppf.person_type_id = p_person_type_id
1240: --,ppf.person_type_id =hr_person_type_usage_info.get_default_person_type_id( p_business_group_id ,p_system_person_type) bug 6848958
1241: ,ppf.person_type_id =decode( p_system_person_type,'CWK',
1242: hr_person_type_usage_info.get_default_person_type_id(
1243: p_business_group_id,'OTHER'),
1244: hr_person_type_usage_info.get_default_person_type_id(

Line 1242: hr_person_type_usage_info.get_default_person_type_id(

1238: ,ppf.business_group_id = p_business_group_id
1239: -- ,ppf.person_type_id = p_person_type_id
1240: --,ppf.person_type_id =hr_person_type_usage_info.get_default_person_type_id( p_business_group_id ,p_system_person_type) bug 6848958
1241: ,ppf.person_type_id =decode( p_system_person_type,'CWK',
1242: hr_person_type_usage_info.get_default_person_type_id(
1243: p_business_group_id,'OTHER'),
1244: hr_person_type_usage_info.get_default_person_type_id(
1245: p_business_group_id,p_system_person_type)) -- fix for bug6848958
1246: ,ppf.last_name = p_last_name

Line 1244: hr_person_type_usage_info.get_default_person_type_id(

1240: --,ppf.person_type_id =hr_person_type_usage_info.get_default_person_type_id( p_business_group_id ,p_system_person_type) bug 6848958
1241: ,ppf.person_type_id =decode( p_system_person_type,'CWK',
1242: hr_person_type_usage_info.get_default_person_type_id(
1243: p_business_group_id,'OTHER'),
1244: hr_person_type_usage_info.get_default_person_type_id(
1245: p_business_group_id,p_system_person_type)) -- fix for bug6848958
1246: ,ppf.last_name = p_last_name
1247: ,ppf.start_date = p_start_date
1248: ,ppf.applicant_number = p_applicant_number

Line 1429: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EMP_APL')

1425: END IF;
1426:
1427: -- All the future APL & EX_EMP_APL records will be converted to EMP_APL
1428: UPDATE per_all_people_f
1429: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EMP_APL')
1430: ,current_employee_flag = 'Y'
1431: ,employee_number = p_employee_number
1432: ,original_date_of_hire = p_original_date_of_hire
1433: WHERE person_id = p_person_id

Line 1435: AND (person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'APL')

1431: ,employee_number = p_employee_number
1432: ,original_date_of_hire = p_original_date_of_hire
1433: WHERE person_id = p_person_id
1434: AND effective_start_date > p_effective_end_date
1435: AND (person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'APL')
1436: OR person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_EMP_APL'));
1437:
1438: -- All the future EX_APL & EX_EMP records will be converted to EMP
1439: UPDATE per_all_people_f

Line 1436: OR person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_EMP_APL'));

1432: ,original_date_of_hire = p_original_date_of_hire
1433: WHERE person_id = p_person_id
1434: AND effective_start_date > p_effective_end_date
1435: AND (person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'APL')
1436: OR person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_EMP_APL'));
1437:
1438: -- All the future EX_APL & EX_EMP records will be converted to EMP
1439: UPDATE per_all_people_f
1440: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EMP')

Line 1440: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EMP')

1436: OR person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_EMP_APL'));
1437:
1438: -- All the future EX_APL & EX_EMP records will be converted to EMP
1439: UPDATE per_all_people_f
1440: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EMP')
1441: ,current_employee_flag = 'Y'
1442: ,current_emp_or_apl_flag = 'Y'
1443: ,employee_number = p_employee_number
1444: ,original_date_of_hire = p_original_date_of_hire

Line 1447: AND (person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_APL')

1443: ,employee_number = p_employee_number
1444: ,original_date_of_hire = p_original_date_of_hire
1445: WHERE person_id = p_person_id
1446: AND effective_start_date > p_effective_end_date
1447: AND (person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_APL')
1448: OR person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_EMP'));
1449:
1450: END IF;
1451:

Line 1448: OR person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_EMP'));

1444: ,original_date_of_hire = p_original_date_of_hire
1445: WHERE person_id = p_person_id
1446: AND effective_start_date > p_effective_end_date
1447: AND (person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_APL')
1448: OR person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_EMP'));
1449:
1450: END IF;
1451:
1452: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',276);

Line 1459: set person_type_id = hr_person_type_usage_info.get_default_person_type_id(p_business_group_id,'EMP')

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
1461: where person_id = p_person_id
1462: and effective_start_date between p_effective_end_date and l_first_apl_date;
1463:

Line 1472: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id

1468: -- loop through the future applications > hire date
1469: for apl in csr_get_apln_details(greatest(p_hire_date,p_session_date))
1470: loop
1471:
1472: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
1473: (p_business_group_id,'APL');
1474:
1475: -- creating APL records in PTU table
1476: hr_per_type_usage_internal.maintain_person_type_usage

Line 1481: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id

1477: (p_effective_date => apl.date_received
1478: ,p_person_id => p_person_id
1479: ,p_person_type_id => l_person_type_id1);
1480:
1481: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
1482: (p_business_group_id,'EMP_APL');
1483:
1484: select object_version_number,effective_start_date into l_per_latest_ovn,l_effective_start_date
1485: from per_all_people_f

Line 1661: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id

1657: close csr_back_toback_apln;
1658:
1659: if l_yes_backtoback ='N' then
1660:
1661: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
1662: (p_business_group_id,'EX_APL');
1663:
1664: -- creating EX_APL records in PTU table
1665: hr_per_type_usage_internal.maintain_person_type_usage

Line 1689: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id

1685: end if;
1686: close per_future_rows;
1687: end if;
1688:
1689: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
1690: (p_business_group_id,'EMP');
1691:
1692:
1693: -- creating EMP records in PER table

Line 1851: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EMP')

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
1853: WHERE person_id = p_person_id
1854: AND effective_start_date > p_effective_end_date;
1855: end if;

Line 3576: ,p_person_type_id => hr_person_type_usage_info.get_default_person_type_id

3572: -- **** End new code for bug 2264569 **********************************
3573: hr_per_type_usage_internal.maintain_person_type_usage
3574: (p_effective_date => p_effective_start_date
3575: ,p_person_id => p_person_id
3576: ,p_person_type_id => hr_person_type_usage_info.get_default_person_type_id
3577: (p_business_group_id
3578: ,'EX_APL')
3579: );
3580: -- **** Start new code for bug 2264569 **********************************

Line 3695: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(

3691: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',272);
3692: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_person_type_id,272);
3693: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_s_system_person_type,272);
3694: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||p_system_person_type,272);
3695: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(
3696: p_business_group_id,p_system_person_type),272);
3697:
3698: -- Bug 6196362 Starts.
3699: -- update per_people_f ppf

Line 3707: --,ppf.person_type_id =hr_person_type_usage_info.get_default_person_type_id( p_business_group_id ,p_system_person_type) bug 6848958

3703: ,ppf.effective_start_date = p_effective_start_date
3704: ,ppf.effective_end_date = p_effective_end_date
3705: ,ppf.business_group_id = p_business_group_id
3706: -- ,ppf.person_type_id = p_person_type_id
3707: --,ppf.person_type_id =hr_person_type_usage_info.get_default_person_type_id( p_business_group_id ,p_system_person_type) bug 6848958
3708: ,ppf.person_type_id =decode( p_system_person_type,'CWK',
3709: hr_person_type_usage_info.get_default_person_type_id(
3710: p_business_group_id,'OTHER'),
3711: hr_person_type_usage_info.get_default_person_type_id(

Line 3709: hr_person_type_usage_info.get_default_person_type_id(

3705: ,ppf.business_group_id = p_business_group_id
3706: -- ,ppf.person_type_id = p_person_type_id
3707: --,ppf.person_type_id =hr_person_type_usage_info.get_default_person_type_id( p_business_group_id ,p_system_person_type) bug 6848958
3708: ,ppf.person_type_id =decode( p_system_person_type,'CWK',
3709: hr_person_type_usage_info.get_default_person_type_id(
3710: p_business_group_id,'OTHER'),
3711: hr_person_type_usage_info.get_default_person_type_id(
3712: p_business_group_id,p_system_person_type)) -- fix for bug6848958
3713: ,ppf.last_name = p_last_name

Line 3711: hr_person_type_usage_info.get_default_person_type_id(

3707: --,ppf.person_type_id =hr_person_type_usage_info.get_default_person_type_id( p_business_group_id ,p_system_person_type) bug 6848958
3708: ,ppf.person_type_id =decode( p_system_person_type,'CWK',
3709: hr_person_type_usage_info.get_default_person_type_id(
3710: p_business_group_id,'OTHER'),
3711: hr_person_type_usage_info.get_default_person_type_id(
3712: p_business_group_id,p_system_person_type)) -- fix for bug6848958
3713: ,ppf.last_name = p_last_name
3714: ,ppf.start_date = p_start_date
3715: ,ppf.applicant_number = p_applicant_number