DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on FND_PROFILE

Line 1743: l_fte_profile_value VARCHAR2(240) := fnd_profile.VALUE('BEN_CWB_FTE_FACTOR');

1739: l_rgeflg varchar2(1) := 'S';
1740: l_grade_annualization_factor NUMBER;
1741: l_pay_annualization_factor NUMBER;
1742: l_dummy VARCHAR2(200);
1743: l_fte_profile_value VARCHAR2(240) := fnd_profile.VALUE('BEN_CWB_FTE_FACTOR');
1744: --
1745: --
1746: -- define cursor to get ele/link min/max values
1747: --

Line 1987: if NVL(fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE'),'Y') = 'Y' then

1983: *nvl(l_pay_annualization_factor,1);
1984:
1985: if l_pay_basis <> 'HOURLY' then
1986: --FTE ANNUAL SALARY WILL BE USED FOR COMPARISION WHEN PROFILE IS Y
1987: if NVL(fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE'),'Y') = 'Y' then
1988: l_annual_salary := l_annual_salary / l_fte_factor;
1989: end if;
1990: end if;
1991:

Line 2373: l_autoApprove:=fnd_profile.value('HR_AUTO_APPROVE_FIRST_PROPOSAL');

2369: hr_utility.set_location(l_proc, 55);
2370: if p_approved = 'N' then
2371: --vkodedal 05-Oct-2007 ER to satisfy satutory requirement
2372: --Retain auto approve first proposal functionality if profile is null or set to Yes
2373: l_autoApprove:=fnd_profile.value('HR_AUTO_APPROVE_FIRST_PROPOSAL');
2374: if(l_autoApprove is null or l_autoApprove ='Y') then
2375: hr_utility.set_location(l_proc, 60);
2376: hr_utility.set_message (800,'HR_52513_PYP_FIRST_EMP_NOT_APR');
2377: hr_utility.raise_error;

Line 2917: if nvl(fnd_profile.value('FLEXFIELDS:VALIDATE_ON_SERVER'),'N') = 'Y'

2913: -- a) During update, the structure column value or any
2914: -- of the attribute values have actually changed.
2915: -- b) During insert.
2916: --
2917: if nvl(fnd_profile.value('FLEXFIELDS:VALIDATE_ON_SERVER'),'N') = 'Y'
2918: then
2919: hr_dflex_utility.ins_or_upd_descflex_attribs
2920: (p_appl_short_name => 'PER'
2921: ,p_descflex_name => 'PER_PAY_PROPOSALS'