1054:
1055: hr_utility.set_location('cancel_hire_or_apl.pre_cancel_checks',1);
1056: --
1057: -- Start Bug 3285486. commented the call to hr_person.chk_future_person_type
1058: -- added the new call to hr_person_type_usage_info.FutSysPerTypeChgExists
1059: /* if hr_person.chk_future_person_type(p_system_person_type
1060: ,p_person_id
1061: ,p_business_group_id
1062: ,p_primary_date) then*/
1059: /* if hr_person.chk_future_person_type(p_system_person_type
1060: ,p_person_id
1061: ,p_business_group_id
1062: ,p_primary_date) then*/
1063: IF hr_person_type_usage_info.FutSysPerTypeChgExists
1064: (p_person_type_usage_id => l_person_type_usage_id
1065: ,p_effective_date => p_primary_date
1066: ,p_person_id => p_person_id ) THEN
1067: -- End Bug 3285486.
1322: hr_utility.set_location('APP1.B_PRE_DEL_CHECK',1);
1323: hr_utility.set_location('cancel_hire_or_apl.pre_cancel_checks',13);
1324: --
1325: -- Start Bug 3285486. commented the call to hr_person.chk_future_person_type
1326: -- added the new call to hr_person_type_usage_info.FutSysPerTypeChgExists
1327: --
1328: /* if hr_person.chk_future_person_type(p_system_person_type
1329: ,p_person_id
1330: ,p_business_group_id
1328: /* if hr_person.chk_future_person_type(p_system_person_type
1329: ,p_person_id
1330: ,p_business_group_id
1331: ,p_primary_date) then*/
1332: IF hr_person_type_usage_info.FutSysPerTypeChgExists
1333: (p_person_type_usage_id => l_person_type_usage_id
1334: ,p_effective_date => p_primary_date
1335: ,p_person_id => p_person_id ) THEN
1336: --
1666: CLOSE csr_get_ptu_id;
1667:
1668: hr_utility.set_location('cancel_emp_apl_hire ',11);
1669:
1670: IF hr_person_type_usage_info.FutSysPerTypeChgExists
1671: (p_person_type_usage_id => l_person_type_usage_id
1672: ,p_effective_date => p_date_start
1673: ,p_person_id => p_person_id ) THEN
1674: -- End Bug 3285486.
2863:
2864: if l_person_end_date = hr_general.end_of_time then --#1998140
2865:
2866: -- 3848352 start
2867: if hr_person_type_usage_info.is_person_of_type
2868: ( p_effective_date => p_date_start
2869: ,p_person_id => p_person_id
2870: ,p_system_person_type => 'EX_APL'
2871: )
2882: p_effective_date => p_date_start,
2883: p_current_person_type => 'EMP',
2884: p_system_person_type => l_system_person_type);
2885:
2886: l_person_type_id := hr_person_type_usage_info.get_default_person_type_id
2887: (p_business_group_id, l_system_person_type);
2888: /*select person_type_id into l_person_type_id
2889: from per_person_types
2890: where business_group_id = p_business_group_id
3719: p_effective_date => p_date_received,
3720: p_current_person_type => 'APL',
3721: p_system_person_type => l_system_person_type);
3722:
3723: l_person_type_id := hr_person_type_usage_info.get_default_person_type_id
3724: (p_business_group_id, l_system_person_type);
3725:
3726: open chk_action_perform_date;
3727: fetch chk_action_perform_date into l_action_perform_date;
3904:
3905: -- When the person became B2B Applicant on his hired Day then
3906: -- system will convert the APL record to EX_APL type.
3907: update per_person_type_usages_f ptu
3908: set person_type_id = hr_person_type_usage_info.get_default_person_type_id
3909: (p_business_group_id, 'EX_APL')
3910: where ptu.person_id = p_person_id
3911: and ptu.effective_start_date = p_date_received
3912: and person_type_id in (
4235: hr_utility.set_location(l_proc,30);
4236: --
4237: -- Check that the CWK has no future person type changes.
4238: --
4239: IF hr_person_type_usage_info.FutSysPerTypeChgExists -- 3194314: adding person id
4240: (p_person_type_usage_id => l_person_type_usage_id
4241: ,p_effective_date => p_date_start
4242: ,p_person_id => p_person_id ) THEN
4243: -- #3684683 modified the application id to 800