DBA Data[Home] [Help]

APPS.HR_PAY_RATE_SS dependencies on FND_PROFILE

Line 343: IF (fnd_profile.value('CURRENCY:THOUSANDS_SEPARATOR') = 'Y' AND

339: l_proc varchar2(200) := g_package || 'format_number';
340:
341: BEGIN
342: hr_utility.set_location(' Entering:' || l_proc,5);
343: IF (fnd_profile.value('CURRENCY:THOUSANDS_SEPARATOR') = 'Y' AND
344: p_number is not null) THEN
345:
346: declare
347: p_input varchar2(200);

Line 371: p_decimalSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),1,1);

367: hr_utility.set_location( l_proc,15);
368: p_negative := true;
369: p_input := substr(p_input, 2, length(p_input));
370: END IF;
371: p_decimalSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),1,1);
372: p_groupSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),2,1);
373: if(p_decimalSep = ',') then
374: hr_utility.set_location( l_proc,20);
375: p_input := replace(p_input,p_decimalSep,p_groupSep);

Line 372: p_groupSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),2,1);

368: p_negative := true;
369: p_input := substr(p_input, 2, length(p_input));
370: END IF;
371: p_decimalSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),1,1);
372: p_groupSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),2,1);
373: if(p_decimalSep = ',') then
374: hr_utility.set_location( l_proc,20);
375: p_input := replace(p_input,p_decimalSep,p_groupSep);
376: end if;

Line 1661: elsif ((fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') is null OR

1657: if ( p_midpoint_salary = 0) then
1658: p_comparatio := 0;
1659: elsif (p_grade_basis = 'HOURLY' and p_pay_basis = 'HOURLY') then
1660: p_comparatio := round(( (100*p_prev_salary)/p_midpoint_salary), 3 );
1661: elsif ((fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') is null OR
1662: fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') = 'Y') AND p_pay_basis <> 'HOURLY') then
1663: p_comparatio := round(( (100*p_prev_salary *p_pay_annualization_factor)/
1664: (p_midpoint_salary*p_fte_factor)), 3 );
1665: else

Line 1662: fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') = 'Y') AND p_pay_basis <> 'HOURLY') then

1658: p_comparatio := 0;
1659: elsif (p_grade_basis = 'HOURLY' and p_pay_basis = 'HOURLY') then
1660: p_comparatio := round(( (100*p_prev_salary)/p_midpoint_salary), 3 );
1661: elsif ((fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') is null OR
1662: fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') = 'Y') AND p_pay_basis <> 'HOURLY') then
1663: p_comparatio := round(( (100*p_prev_salary *p_pay_annualization_factor)/
1664: (p_midpoint_salary*p_fte_factor)), 3 );
1665: else
1666: p_comparatio :=round(( (100*p_prev_salary *

Line 1673: elsif ((fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') is null OR

1669: end if;
1670:
1671: if (p_grade_basis = 'HOURLY' and p_pay_basis = 'HOURLY') then
1672: ln_ann_sal := p_prev_salary;
1673: elsif ((fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') is null OR
1674: fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') = 'Y') AND p_pay_basis <> 'HOURLY') then
1675: ln_ann_sal := (p_prev_salary * p_pay_annualization_factor)/p_fte_factor;
1676: else
1677: ln_ann_sal := p_prev_salary * p_pay_annualization_factor;

Line 1674: fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') = 'Y') AND p_pay_basis <> 'HOURLY') then

1670:
1671: if (p_grade_basis = 'HOURLY' and p_pay_basis = 'HOURLY') then
1672: ln_ann_sal := p_prev_salary;
1673: elsif ((fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') is null OR
1674: fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') = 'Y') AND p_pay_basis <> 'HOURLY') then
1675: ln_ann_sal := (p_prev_salary * p_pay_annualization_factor)/p_fte_factor;
1676: else
1677: ln_ann_sal := p_prev_salary * p_pay_annualization_factor;
1678: end if;

Line 5699: if ((fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') is null OR

5695: p_transaction_step_id => ln_transaction_step_id,
5696: p_name => 'p_default_pay_annual_factor'
5697: );
5698:
5699: if ((fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') is null OR
5700: fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') = 'Y') and
5701: p_ltt_salary_data(1).default_pay_basis = 'HOURLY') then
5702: l_factor := p_ltt_salary_data(1).default_pay_annual_factor*lv_old_fte_factor;
5703: else

Line 5700: fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') = 'Y') and

5696: p_name => 'p_default_pay_annual_factor'
5697: );
5698:
5699: if ((fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') is null OR
5700: fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') = 'Y') and
5701: p_ltt_salary_data(1).default_pay_basis = 'HOURLY') then
5702: l_factor := p_ltt_salary_data(1).default_pay_annual_factor*lv_old_fte_factor;
5703: else
5704: l_factor := p_ltt_salary_data(1).default_pay_annual_factor;