DBA Data[Home] [Help]

APPS.HR_PDT_BUS dependencies on FND_PROFILE

Line 1327: l_global_num_set fnd_profile_option_values.profile_option_value%type;

1323: l_api_updating boolean;
1324: l_dummy number;
1325: l_numgen_method per_all_people_f.employee_number%type;
1326: l_host_empnum per_all_people_f.employee_number%type;
1327: l_global_num_set fnd_profile_option_values.profile_option_value%type;
1328: --
1329: cursor csr_numgen_method is
1330: select pbg.method_of_generation_emp_num
1331: from per_business_groups pbg

Line 1376: l_global_num_set := fnd_profile.value('PER_GLOBAL_EMP_NUM');

1372: open csr_numgen_method;
1373: fetch csr_numgen_method into l_numgen_method;
1374: close csr_numgen_method;
1375: --
1376: l_global_num_set := fnd_profile.value('PER_GLOBAL_EMP_NUM');
1377: --
1378: if l_numgen_method='N'
1379: or (l_numgen_method='A' and l_global_num_set <> 'Y') then
1380: fnd_message.set_name('PER','HR_449637_PDT_NUMGENMETH');

Line 1864: if nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'N'

1860: l_api_updating := hr_pdt_shd.api_updating
1861: (p_person_deployment_id => p_person_deployment_id
1862: ,p_object_version_number => p_object_version_number);
1863: --
1864: if nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'N'
1865: and p_from_business_group_id <> p_to_business_group_id then
1866: fnd_message.set_name('PER','HR_449644_PDT_RETAIN_REPS');
1867: fnd_message.raise_error;
1868: end if;

Line 3276: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N') then

3272: fnd_message.raise_error;
3273: else
3274: close csr_check_sup;
3275: if (p_to_business_group_id <> l_sup_bg_id AND
3276: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='N') then
3277: fnd_message.set_name('PER','HR_51145_ASG_SUP_BG_NE_EMP_BG');
3278: fnd_message.raise_error;
3279: end if;
3280: end if;

Line 3388: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y')) then

3384: else
3385: close csr_check_sup_asg;
3386: if (l_sup_asg_type = 'E'
3387: or (l_sup_asg_type = 'C' and
3388: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y')) then
3389: null;
3390: else
3391: fnd_message.set_name('PER','HR_50147_SUP_ASG_WRONG_TYPE');
3392: fnd_message.raise_error;