DBA Data[Home] [Help]

APPS.HR_CONTINGENT_WORKER_API dependencies on HR_PERSON_TYPE_USAGE_INFO

Line 636: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id

632: l_applicant_number := null;
633: l_employee_number := null;
634: l_npw_number := p_npw_number;
635: l_current_npw_flag := 'Y';
636: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
637: (p_business_group_id,
638: 'OTHER');
639: --
640: -- Process Logic

Line 1284: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id

1280: ,l_effective_date) then
1281: fnd_message.set_name('PER','PER_289603_CWK_INV_PERSON_TYPE');
1282: fnd_message.raise_error;
1283: elsif l_per_details_rec.system_person_type = 'OTHER' then
1284: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
1285: (l_per_details_rec.business_group_id,
1286: 'OTHER');
1287: else
1288: l_person_type_id1 := l_per_details_rec.person_type_id;

Line 1422: if hr_person_type_usage_info.is_person_of_type(ptu_rec.effective_start_date,p_person_id,'EX_EMP') then

1418: and ptu_rec.effective_start_date between effective_start_date and effective_end_date;
1419:
1420:
1421: l_person_type_id2 := ptu_rec.person_type_id;
1422: if hr_person_type_usage_info.is_person_of_type(ptu_rec.effective_start_date,p_person_id,'EX_EMP') then
1423: if hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'APL' then
1424: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP_APL');
1425: elsif hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'EX_APL' then
1426: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP');

Line 1423: if hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'APL' then

1419:
1420:
1421: l_person_type_id2 := ptu_rec.person_type_id;
1422: if hr_person_type_usage_info.is_person_of_type(ptu_rec.effective_start_date,p_person_id,'EX_EMP') then
1423: if hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'APL' then
1424: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP_APL');
1425: elsif hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'EX_APL' then
1426: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP');
1427: end if;

Line 1424: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP_APL');

1420:
1421: l_person_type_id2 := ptu_rec.person_type_id;
1422: if hr_person_type_usage_info.is_person_of_type(ptu_rec.effective_start_date,p_person_id,'EX_EMP') then
1423: if hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'APL' then
1424: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP_APL');
1425: elsif hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'EX_APL' then
1426: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP');
1427: end if;
1428: end if;

Line 1425: elsif hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'EX_APL' then

1421: l_person_type_id2 := ptu_rec.person_type_id;
1422: if hr_person_type_usage_info.is_person_of_type(ptu_rec.effective_start_date,p_person_id,'EX_EMP') then
1423: if hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'APL' then
1424: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP_APL');
1425: elsif hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'EX_APL' then
1426: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP');
1427: end if;
1428: end if;
1429:

Line 1426: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP');

1422: if hr_person_type_usage_info.is_person_of_type(ptu_rec.effective_start_date,p_person_id,'EX_EMP') then
1423: if hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'APL' then
1424: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP_APL');
1425: elsif hr_person_type_usage_info.GetSystemPersonType(ptu_rec.person_type_id) = 'EX_APL' then
1426: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id(l_per_details_rec.business_group_id,'EX_EMP');
1427: end if;
1428: end if;
1429:
1430: if l_effective_start_date = ptu_rec.effective_start_date then

Line 1743: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id

1739: END IF;
1740: --
1741: /* Added for bug 9026035 */
1742: if l_per_details_rec.system_person_type = 'EX_EMP' then
1743: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
1744: (l_per_details_rec.business_group_id,
1745: 'EX_EMP_APL');
1746: else
1747: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id

Line 1747: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id

1743: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
1744: (l_per_details_rec.business_group_id,
1745: 'EX_EMP_APL');
1746: else
1747: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
1748: (l_per_details_rec.business_group_id,
1749: 'APL');
1750: end if;
1751: --