DBA Data[Home] [Help]

APPS.HR_APPLICANT_INTERNAL dependencies on HR_PERSON_TYPE_USAGE_INFO

Line 124: p_new_person_type_id := hr_person_type_usage_info.get_default_person_type_id

120: l_new_sys_person_type := 'APL';
121:
122: end if;
123:
124: p_new_person_type_id := hr_person_type_usage_info.get_default_person_type_id
125: (p_business_group_id, l_new_sys_person_type);
126:
127: p_new_sys_person_type := l_new_sys_person_type;
128:

Line 163: p_new_person_type_id := hr_person_type_usage_info.get_default_person_type_id

159: l_new_sys_person_type := 'EX_APL';
160:
161: end if;
162:
163: p_new_person_type_id := hr_person_type_usage_info.get_default_person_type_id
164: (p_business_group_id, l_new_sys_person_type);
165:
166: p_new_sys_person_type := l_new_sys_person_type;
167:

Line 881: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(p_Business_Group_Id,'APL');

877: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
878: for apl_rec in fpt_apl loop
879: -- updating PTU with the future APL and EX-APL records
880: hr_utility.set_location('Creating APL record on '||apl_rec.date_received,70);
881: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(p_Business_Group_Id,'APL');
882:
883: open chk_ptu_exists(apl_rec.date_received);
884: fetch chk_ptu_exists into l_exists;
885: if chk_ptu_exists%found then

Line 899: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(p_Business_Group_Id,'EX_APL');

895: ,p_person_type_id => l_person_type_id1
896: ,p_datetrack_update_mode => l_datetrack_mode);
897:
898: if apl_rec.date_end is not null then
899: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(p_Business_Group_Id,'EX_APL');
900: hr_per_type_usage_internal.maintain_person_type_usage
901: (p_effective_date => apl_rec.date_end + 1
902: ,p_person_id => p_person_id
903: ,p_person_type_id => l_person_type_id1);

Line 952: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EX_EMP_APL');

948:
949: -- person type ID is modified if he's an EMP or EX-EMP
950: if hr_general2.is_person_type(p_person_id,'EX_EMP',ptu_rec.effective_start_date) then
951: if hr_general2.is_person_type(p_person_id,'APL',ptu_rec.effective_start_date) then
952: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EX_EMP_APL');
953: elsif hr_general2.is_person_type(p_person_id,'EX_APL',ptu_rec.effective_start_date) then
954: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EX_EMP');
955: end if;
956:

Line 954: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EX_EMP');

950: if hr_general2.is_person_type(p_person_id,'EX_EMP',ptu_rec.effective_start_date) then
951: if hr_general2.is_person_type(p_person_id,'APL',ptu_rec.effective_start_date) then
952: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EX_EMP_APL');
953: elsif hr_general2.is_person_type(p_person_id,'EX_APL',ptu_rec.effective_start_date) then
954: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EX_EMP');
955: end if;
956:
957: elsif hr_general2.is_person_type(p_person_id,'EMP',ptu_rec.effective_start_date) then
958: if hr_general2.is_person_type(p_person_id,'APL',ptu_rec.effective_start_date) then

Line 959: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EMP_APL');

955: end if;
956:
957: elsif hr_general2.is_person_type(p_person_id,'EMP',ptu_rec.effective_start_date) then
958: if hr_general2.is_person_type(p_person_id,'APL',ptu_rec.effective_start_date) then
959: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EMP_APL');
960: elsif hr_general2.is_person_type(p_person_id,'EX_APL',ptu_rec.effective_start_date) then
961: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EMP');
962: end if;
963: end if;

Line 961: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EMP');

957: elsif hr_general2.is_person_type(p_person_id,'EMP',ptu_rec.effective_start_date) then
958: if hr_general2.is_person_type(p_person_id,'APL',ptu_rec.effective_start_date) then
959: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EMP_APL');
960: elsif hr_general2.is_person_type(p_person_id,'EX_APL',ptu_rec.effective_start_date) then
961: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(l_person_rec.business_group_id,'EMP');
962: end if;
963: end if;
964:
965: open per_row_exists(ptu_rec.effective_start_date);

Line 1759: l_ptu_person_type_id := hr_person_type_usage_info.get_default_person_type_id

1755: hr_utility.trace(' ==> person record became EX_APL on '||
1756: to_char(l_new_effective_date));
1757: end if;
1758: --
1759: l_ptu_person_type_id := hr_person_type_usage_info.get_default_person_type_id
1760: (p_business_group_id, 'EX_APL');
1761:
1762: open csr_ptu_details(p_person_id, p_ex_apl_effective_date);
1763: fetch csr_ptu_details into l_ptu_rec;