eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PENSION_FUNCTIONS dependencies on FND_NUMBER

Line 154: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_limit),trim(to_char(0,'9')));

150: p_column_value
151: := g_pension_rec(l_pension_id).contribution_conversion_rule;
152: ELSIF p_column_name = 'ER_ANNUAL_LIMIT' THEN
153: p_column_value
154: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_limit),trim(to_char(0,'9')));
155: ELSIF p_column_name = 'EE_ANNUAL_LIMIT' THEN
156: p_column_value
157: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_limit),trim(to_char(0,'9')));
158: ELSIF p_column_name = 'MINIMUM_AGE' THEN

Line 157: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_limit),trim(to_char(0,'9')));

153: p_column_value
154: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_limit),trim(to_char(0,'9')));
155: ELSIF p_column_name = 'EE_ANNUAL_LIMIT' THEN
156: p_column_value
157: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_limit),trim(to_char(0,'9')));
158: ELSIF p_column_name = 'MINIMUM_AGE' THEN
159: p_column_value
160: := NVL(to_char(g_pension_rec(l_pension_id).minimum_age),trim(to_char(0,'9')));
161: ELSIF p_column_name = 'MAXIMUM_AGE' THEN

Line 166: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_contribution)

162: p_column_value
163: := NVL(to_char(g_pension_rec(l_pension_id).maximum_age),trim(to_char(999,'999')));
164: ELSIF p_column_name = 'EE_ANNUAL_CONTRIBUTION' THEN
165: p_column_value
166: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_contribution)
167: ,trim(to_char(0,'9')));
168: ELSIF p_column_name = 'ER_ANNUAL_CONTRIBUTION' THEN
169: p_column_value
170: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_contribution)

Line 170: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_contribution)

166: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_contribution)
167: ,trim(to_char(0,'9')));
168: ELSIF p_column_name = 'ER_ANNUAL_CONTRIBUTION' THEN
169: p_column_value
170: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_contribution)
171: ,trim(to_char(0,'9')));
172: ELSIF p_column_name = 'EE_CONTRIBUTION_PERCENT' THEN
173: p_column_value
174: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_contribution_percent)

Line 174: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_contribution_percent)

170: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_contribution)
171: ,trim(to_char(0,'9')));
172: ELSIF p_column_name = 'EE_CONTRIBUTION_PERCENT' THEN
173: p_column_value
174: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_contribution_percent)
175: ,trim(to_char(0,'9')));
176: ELSIF p_column_name = 'ER_CONTRIBUTION_PERCENT' THEN
177: p_column_value
178: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_contribution_percent)

Line 178: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_contribution_percent)

174: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_contribution_percent)
175: ,trim(to_char(0,'9')));
176: ELSIF p_column_name = 'ER_CONTRIBUTION_PERCENT' THEN
177: p_column_value
178: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_contribution_percent)
179: ,trim(to_char(0,'9')));
180: ELSIF p_column_name = 'EE_ANNUAL_SALARY_THRESHOLD' THEN
181:
182: OPEN c_get_ee_age_threshold(g_pension_rec(l_pension_id).pension_type_id);

Line 252: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_salary_threshold)

248: END IF;--c_get_person_age%FOUND
249: CLOSE c_get_person_age;
250: ELSE
251: p_column_value
252: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_salary_threshold)
253: ,trim(to_char(0,'9')));
254:
255:
256: END IF; -- c_get_ee_age_threshold%FOUND

Line 264: -- := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_salary_threshold)

260: hr_utility.set_location(' p_error_message is '||p_error_message,45);
261:
262: ELSIF p_column_name = 'ER_ANNUAL_SALARY_THRESHOLD' THEN
263: -- p_column_value
264: -- := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_salary_threshold)
265: -- ,trim(to_char(0,'9')));
266:
267:
268: OPEN c_get_er_age_threshold(g_pension_rec(l_pension_id).pension_type_id);

Line 343: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_salary_threshold)

339: END IF;--c_get_person_age%FOUND
340: CLOSE c_get_person_age;
341: ELSE
342: p_column_value
343: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_salary_threshold)
344: ,trim(to_char(0,'9')));
345:
346:
347: END IF; -- c_get_er_age_threshold%FOUND

Line 355: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).annual_premium_amount)

351: hr_utility.set_location(' p_error_message is '||p_error_message,45);
352:
353: ELSIF p_column_name = 'ANNUAL_PREMIUM_AMOUNT' THEN
354: p_column_value
355: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).annual_premium_amount)
356: ,trim(to_char(0,'9')));
357: ELSIF p_column_name = 'SPECIAL_PENSION_TYPE_CODE' THEN
358: p_column_value
359: := NVL(g_pension_rec(l_pension_id).special_pension_type_code

Line 384: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).recurring_bonus_percent)

380: := NVL(to_char(g_pension_rec(l_pension_id).pension_salary_balance)
381: ,trim(to_char(0,'9')));
382: ELSIF p_column_name = 'RECURRING_BONUS_PERCENT' THEN
383: p_column_value
384: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).recurring_bonus_percent)
385: ,trim(to_char(0,'9')));
386: ELSIF p_column_name = 'NON_RECURRING_BONUS_PERCENT' THEN
387: p_column_value
388: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).non_recurring_bonus_percent)

Line 388: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).non_recurring_bonus_percent)

384: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).recurring_bonus_percent)
385: ,trim(to_char(0,'9')));
386: ELSIF p_column_name = 'NON_RECURRING_BONUS_PERCENT' THEN
387: p_column_value
388: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).non_recurring_bonus_percent)
389: ,trim(to_char(0,'9')));
390: ELSIF p_column_name = 'RECURRING_BONUS_BALANCE' THEN
391: p_column_value
392: := NVL(to_char(g_pension_rec(l_pension_id).recurring_bonus_balance)

Line 456: SELECT fnd_number.canonical_to_number(global_value)

452: -- SI days ) is enabled, the same function will be called here .
453:
454: CURSOR c_get_global ( c_global_name IN VARCHAR2
455: ,c_effective_date IN DATE ) IS
456: SELECT fnd_number.canonical_to_number(global_value)
457: FROM ff_globals_f
458: WHERE global_name = c_global_name
459: AND trunc(c_effective_date) BETWEEN effective_start_date AND effective_end_date
460: AND legislation_code = 'NL';

Line 2033: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc

2029: AND pps.business_group_id = p_business_group_id
2030: AND date_start <= p_date_earned;
2031:
2032: CURSOR c_pt_cur (c_effective_date IN DATE) IS
2033: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
2034: FROM per_assignments_f asg
2035: ,hr_soft_coding_keyflex target
2036: WHERE asg.assignment_id = p_assignment_id
2037: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 2071: SELECT fnd_number.canonical_to_number(global_value)

2067: -- =======================================================================
2068: -- Cursor to get the holiday allowance global
2069: -- =======================================================================
2070: CURSOR c_global_cur(c_global_name IN VARCHAR2) IS
2071: SELECT fnd_number.canonical_to_number(global_value)
2072: FROM ff_globals_f
2073: WHERE global_name = c_global_name
2074: AND trunc (p_date_earned) BETWEEN effective_start_date
2075: AND effective_end_date;

Line 2811: l_min_eoy_bonus := fnd_number.canonical_to_number(NVL(l_min_eoy_bonus_char,'0'));

2807: ,p_row_value => l_cag_name
2808: ,p_effective_date => l_effective_date
2809: );
2810:
2811: l_min_eoy_bonus := fnd_number.canonical_to_number(NVL(l_min_eoy_bonus_char,'0'));
2812:
2813: EXCEPTION
2814: WHEN NO_DATA_FOUND THEN
2815: --l_message_flag :='e';

Line 2884: l_min_holiday_allow := fnd_number.canonical_to_number(NVL(l_min_holiday_char,'0'));

2880: ,p_row_value => l_cag_name
2881: ,p_effective_date => l_effective_date
2882: );
2883:
2884: l_min_holiday_allow := fnd_number.canonical_to_number(NVL(l_min_holiday_char,'0'));
2885:
2886: EXCEPTION
2887: WHEN NO_DATA_FOUND THEN
2888: l_min_holiday_allow := 0;

Line 3571: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100'))

3567: and p_date_earned between asg.effective_start_date and asg.effective_end_date;
3568:
3569: --Cursor to derive the part time percetage value
3570: CURSOR c_get_fte(c_assignment_id IN per_all_assignments_f.assignment_id%TYPE) IS
3571: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100'))
3572: FROM hr_soft_coding_keyflex target,
3573: per_all_assignments_f ASSIGN
3574: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date AND
3575: ASSIGN.effective_end_date

Line 4707: l_data_value := Fnd_Number.Canonical_To_Number(Nvl(p_data_value,'0'));

4703: (p_data_value IN OUT NOCOPY varchar2)
4704: RETURN NUMBER IS
4705: l_data_value Number;
4706: BEGIN
4707: l_data_value := Fnd_Number.Canonical_To_Number(Nvl(p_data_value,'0'));
4708: IF l_data_value >= 0 THEN
4709: RETURN 0;
4710: ELSE
4711: RETURN 1;

Line 4739: SELECT fnd_number.canonical_to_number(aei_information3)

4735: --cursor to fetch the amount from the assignment EIT
4736: --if a row exists for this savings type and the same period number
4737:
4738: CURSOR c_get_addnl_amt IS
4739: SELECT fnd_number.canonical_to_number(aei_information3)
4740: FROM per_assignment_extra_info
4741: WHERE assignment_id = p_assignment_id
4742: AND aei_information1 = to_char(p_pension_type_id)
4743: AND aei_information2 = to_char(p_payroll_period_number)

Line 5003: RETURN fnd_number.canonical_to_number(l_part_time_perc);

4999: ELSIF g_ptp_formula_exists = FALSE THEN
5000: l_part_time_perc := NULL;
5001: END IF;
5002:
5003: RETURN fnd_number.canonical_to_number(l_part_time_perc);
5004:
5005: END get_hook_part_time_perc;
5006:
5007:

Line 5090: RETURN fnd_number.canonical_to_number(l_part_time_perc);

5086: ELSIF g_ptp_formula_exists = FALSE THEN
5087: l_part_time_perc := NULL;
5088: END IF;
5089:
5090: RETURN fnd_number.canonical_to_number(l_part_time_perc);
5091:
5092: END get_reporting_part_time_perc;
5093:
5094: -- ----------------------------------------------------------------------------

Line 5136: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc

5132: decode(asg.effective_end_date,
5133: to_date ('31/12/4712','DD/MM/YYYY'),
5134: trunc(p_period_end_date),
5135: asg.effective_end_date) End_Dt
5136: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
5137: FROM per_assignments_f asg
5138: ,per_assignment_status_types past
5139: ,hr_soft_coding_keyflex target
5140: WHERE asg.assignment_status_type_id = past.assignment_status_type_id