DBA Data[Home] [Help]

APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on HR_PERSON

Line 837: -- Start Bug 3285486. commented the call to hr_person.chk_future_person_type

833: --
834:
835: hr_utility.set_location('cancel_hire_or_apl.pre_cancel_checks',1);
836: --
837: -- Start Bug 3285486. commented the call to hr_person.chk_future_person_type
838: -- added the new call to hr_person_type_usage_info.FutSysPerTypeChgExists
839: /* if hr_person.chk_future_person_type(p_system_person_type
840: ,p_person_id
841: ,p_business_group_id

Line 838: -- added the new call to hr_person_type_usage_info.FutSysPerTypeChgExists

834:
835: hr_utility.set_location('cancel_hire_or_apl.pre_cancel_checks',1);
836: --
837: -- Start Bug 3285486. commented the call to hr_person.chk_future_person_type
838: -- added the new call to hr_person_type_usage_info.FutSysPerTypeChgExists
839: /* if hr_person.chk_future_person_type(p_system_person_type
840: ,p_person_id
841: ,p_business_group_id
842: ,p_primary_date) then*/

Line 839: /* if hr_person.chk_future_person_type(p_system_person_type

835: hr_utility.set_location('cancel_hire_or_apl.pre_cancel_checks',1);
836: --
837: -- Start Bug 3285486. commented the call to hr_person.chk_future_person_type
838: -- added the new call to hr_person_type_usage_info.FutSysPerTypeChgExists
839: /* if hr_person.chk_future_person_type(p_system_person_type
840: ,p_person_id
841: ,p_business_group_id
842: ,p_primary_date) then*/
843: IF hr_person_type_usage_info.FutSysPerTypeChgExists

Line 843: IF hr_person_type_usage_info.FutSysPerTypeChgExists

839: /* if hr_person.chk_future_person_type(p_system_person_type
840: ,p_person_id
841: ,p_business_group_id
842: ,p_primary_date) then*/
843: IF hr_person_type_usage_info.FutSysPerTypeChgExists
844: (p_person_type_usage_id => l_person_type_usage_id
845: ,p_effective_date => p_primary_date
846: ,p_person_id => p_person_id ) THEN
847: -- End Bug 3285486.

Line 869: if not hr_person.chk_prev_person_type(p_system_person_type

865: close csr_assign_actions_exist;
866: -- BUG 2964027 ENDS HERE.
867: --
868: hr_utility.set_location('cancel_hire_or_apl.pre_cancel_checks',2);
869: if not hr_person.chk_prev_person_type(p_system_person_type
870: ,p_person_id
871: ,p_business_group_id
872: ,p_primary_date) then
873: --

Line 1063: -- Start Bug 3285486. commented the call to hr_person.chk_future_person_type

1059: --
1060: hr_utility.set_location('APP1.B_PRE_DEL_CHECK',1);
1061: hr_utility.set_location('cancel_hire_or_apl.pre_cancel_checks',13);
1062: --
1063: -- Start Bug 3285486. commented the call to hr_person.chk_future_person_type
1064: -- added the new call to hr_person_type_usage_info.FutSysPerTypeChgExists
1065: --
1066: /* if hr_person.chk_future_person_type(p_system_person_type
1067: ,p_person_id

Line 1064: -- added the new call to hr_person_type_usage_info.FutSysPerTypeChgExists

1060: hr_utility.set_location('APP1.B_PRE_DEL_CHECK',1);
1061: hr_utility.set_location('cancel_hire_or_apl.pre_cancel_checks',13);
1062: --
1063: -- Start Bug 3285486. commented the call to hr_person.chk_future_person_type
1064: -- added the new call to hr_person_type_usage_info.FutSysPerTypeChgExists
1065: --
1066: /* if hr_person.chk_future_person_type(p_system_person_type
1067: ,p_person_id
1068: ,p_business_group_id

Line 1066: /* if hr_person.chk_future_person_type(p_system_person_type

1062: --
1063: -- Start Bug 3285486. commented the call to hr_person.chk_future_person_type
1064: -- added the new call to hr_person_type_usage_info.FutSysPerTypeChgExists
1065: --
1066: /* if hr_person.chk_future_person_type(p_system_person_type
1067: ,p_person_id
1068: ,p_business_group_id
1069: ,p_primary_date) then*/
1070: IF hr_person_type_usage_info.FutSysPerTypeChgExists

Line 1070: IF hr_person_type_usage_info.FutSysPerTypeChgExists

1066: /* if hr_person.chk_future_person_type(p_system_person_type
1067: ,p_person_id
1068: ,p_business_group_id
1069: ,p_primary_date) then*/
1070: IF hr_person_type_usage_info.FutSysPerTypeChgExists
1071: (p_person_type_usage_id => l_person_type_usage_id
1072: ,p_effective_date => p_primary_date
1073: ,p_person_id => p_person_id ) THEN
1074: --

Line 1085: if not hr_person.chk_prev_person_type(p_system_person_type

1081: --
1082: hr_utility.set_location('APP1.B_PRE_DEL_CHECK',2);
1083: hr_utility.set_location('cancel_hire_or_apl.pre_cancel_checks',14);
1084: --
1085: if not hr_person.chk_prev_person_type(p_system_person_type
1086: ,p_person_id
1087: ,p_business_group_id
1088: ,p_primary_date) then
1089: --

Line 1882: if hr_person_type_usage_info.is_person_of_type

1878:
1879: if l_person_end_date = hr_general.end_of_time then --#1998140
1880:
1881: -- 3848352 start
1882: if hr_person_type_usage_info.is_person_of_type
1883: ( p_effective_date => p_date_start
1884: ,p_person_id => p_person_id
1885: ,p_system_person_type => 'EX_APL'
1886: )

Line 3027: IF hr_person_type_usage_info.FutSysPerTypeChgExists -- 3194314: adding person id

3023: hr_utility.set_location(l_proc,30);
3024: --
3025: -- Check that the CWK has no future person type changes.
3026: --
3027: IF hr_person_type_usage_info.FutSysPerTypeChgExists -- 3194314: adding person id
3028: (p_person_type_usage_id => l_person_type_usage_id
3029: ,p_effective_date => p_date_start
3030: ,p_person_id => p_person_id ) THEN
3031: -- #3684683 modified the application id to 800

Line 3041: IF NOT hr_person.chk_prev_person_type

3037: hr_utility.set_location(l_proc,40);
3038: --
3039: -- Check that the CWK has at least one previous person type.
3040: --
3041: IF NOT hr_person.chk_prev_person_type
3042: (p_system_person_type => 'CWK'
3043: ,p_person_id => p_person_id
3044: ,p_business_group_id => p_business_group_id
3045: ,p_effective_start_date => l_effective_start_date) THEN