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 196: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_limit),trim(to_char(0,'9')));

192: p_column_value
193: := g_pension_rec(l_pension_id).contribution_conversion_rule;
194: ELSIF p_column_name = 'ER_ANNUAL_LIMIT' THEN
195: p_column_value
196: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_limit),trim(to_char(0,'9')));
197: ELSIF p_column_name = 'EE_ANNUAL_LIMIT' THEN
198: p_column_value
199: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_limit),trim(to_char(0,'9')));
200: ELSIF p_column_name = 'MINIMUM_AGE' THEN

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

195: p_column_value
196: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_limit),trim(to_char(0,'9')));
197: ELSIF p_column_name = 'EE_ANNUAL_LIMIT' THEN
198: p_column_value
199: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_limit),trim(to_char(0,'9')));
200: ELSIF p_column_name = 'MINIMUM_AGE' THEN
201: p_column_value
202: := NVL(to_char(g_pension_rec(l_pension_id).minimum_age),trim(to_char(0,'9')));
203: ELSIF p_column_name = 'MAXIMUM_AGE' THEN

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

204: p_column_value
205: := NVL(to_char(g_pension_rec(l_pension_id).maximum_age),trim(to_char(999,'999')));
206: ELSIF p_column_name = 'EE_ANNUAL_CONTRIBUTION' THEN
207: p_column_value
208: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_contribution)
209: ,trim(to_char(0,'9')));
210: ELSIF p_column_name = 'ER_ANNUAL_CONTRIBUTION' THEN
211: p_column_value
212: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_contribution)

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

208: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_contribution)
209: ,trim(to_char(0,'9')));
210: ELSIF p_column_name = 'ER_ANNUAL_CONTRIBUTION' THEN
211: p_column_value
212: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_contribution)
213: ,trim(to_char(0,'9')));
214: ELSIF p_column_name = 'EE_CONTRIBUTION_PERCENT' THEN
215: p_column_value
216: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_contribution_percent)

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

212: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_contribution)
213: ,trim(to_char(0,'9')));
214: ELSIF p_column_name = 'EE_CONTRIBUTION_PERCENT' THEN
215: p_column_value
216: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_contribution_percent)
217: ,trim(to_char(0,'9')));
218: ELSIF p_column_name = 'ER_CONTRIBUTION_PERCENT' THEN
219: p_column_value
220: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_contribution_percent)

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

216: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_contribution_percent)
217: ,trim(to_char(0,'9')));
218: ELSIF p_column_name = 'ER_CONTRIBUTION_PERCENT' THEN
219: p_column_value
220: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_contribution_percent)
221: ,trim(to_char(0,'9')));
222: ELSIF p_column_name = 'EE_ANNUAL_SALARY_THRESHOLD' THEN
223:
224: OPEN c_get_ee_age_threshold(g_pension_rec(l_pension_id).pension_type_id);

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

290: END IF;--c_get_person_age%FOUND
291: CLOSE c_get_person_age;
292: ELSE
293: p_column_value
294: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).ee_annual_salary_threshold)
295: ,trim(to_char(0,'9')));
296:
297:
298: END IF; -- c_get_ee_age_threshold%FOUND

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

302: hr_utility.set_location(' p_error_message is '||p_error_message,45);
303:
304: ELSIF p_column_name = 'ER_ANNUAL_SALARY_THRESHOLD' THEN
305: -- p_column_value
306: -- := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_salary_threshold)
307: -- ,trim(to_char(0,'9')));
308:
309:
310: OPEN c_get_er_age_threshold(g_pension_rec(l_pension_id).pension_type_id);

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

381: END IF;--c_get_person_age%FOUND
382: CLOSE c_get_person_age;
383: ELSE
384: p_column_value
385: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).er_annual_salary_threshold)
386: ,trim(to_char(0,'9')));
387:
388:
389: END IF; -- c_get_er_age_threshold%FOUND

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

393: hr_utility.set_location(' p_error_message is '||p_error_message,45);
394:
395: ELSIF p_column_name = 'ANNUAL_PREMIUM_AMOUNT' THEN
396: p_column_value
397: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).annual_premium_amount)
398: ,trim(to_char(0,'9')));
399: ELSIF p_column_name = 'SPECIAL_PENSION_TYPE_CODE' THEN
400: p_column_value
401: := NVL(g_pension_rec(l_pension_id).special_pension_type_code

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

422: := NVL(to_char(g_pension_rec(l_pension_id).pension_salary_balance)
423: ,trim(to_char(0,'9')));
424: ELSIF p_column_name = 'RECURRING_BONUS_PERCENT' THEN
425: p_column_value
426: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).recurring_bonus_percent)
427: ,trim(to_char(0,'9')));
428: ELSIF p_column_name = 'NON_RECURRING_BONUS_PERCENT' THEN
429: p_column_value
430: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).non_recurring_bonus_percent)

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

426: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).recurring_bonus_percent)
427: ,trim(to_char(0,'9')));
428: ELSIF p_column_name = 'NON_RECURRING_BONUS_PERCENT' THEN
429: p_column_value
430: := NVL(fnd_number.number_to_canonical(g_pension_rec(l_pension_id).non_recurring_bonus_percent)
431: ,trim(to_char(0,'9')));
432: ELSIF p_column_name = 'RECURRING_BONUS_BALANCE' THEN
433: p_column_value
434: := NVL(to_char(g_pension_rec(l_pension_id).recurring_bonus_balance)

Line 498: SELECT fnd_number.canonical_to_number(global_value)

494: -- SI days ) is enabled, the same function will be called here .
495:
496: CURSOR c_get_global ( c_global_name IN VARCHAR2
497: ,c_effective_date IN DATE ) IS
498: SELECT fnd_number.canonical_to_number(global_value)
499: FROM ff_globals_f
500: WHERE global_name = c_global_name
501: AND trunc(c_effective_date) BETWEEN effective_start_date AND effective_end_date
502: AND legislation_code = 'NL';

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

2094: AND pps.business_group_id = p_business_group_id
2095: AND date_start <= p_date_earned;
2096:
2097: CURSOR c_pt_cur (c_effective_date IN DATE) IS
2098: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
2099: FROM per_assignments_f asg
2100: ,hr_soft_coding_keyflex target
2101: WHERE asg.assignment_id = p_assignment_id
2102: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 2136: SELECT fnd_number.canonical_to_number(global_value)

2132: -- =======================================================================
2133: -- Cursor to get the holiday allowance global
2134: -- =======================================================================
2135: CURSOR c_global_cur(c_global_name IN VARCHAR2) IS
2136: SELECT fnd_number.canonical_to_number(global_value)
2137: FROM ff_globals_f
2138: WHERE global_name = c_global_name
2139: AND trunc (p_date_earned) BETWEEN effective_start_date
2140: AND effective_end_date;

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

2882: ,p_row_value => l_cag_name
2883: ,p_effective_date => l_effective_date
2884: );
2885:
2886: l_min_eoy_bonus := fnd_number.canonical_to_number(NVL(l_min_eoy_bonus_char,'0'));
2887:
2888: EXCEPTION
2889: WHEN NO_DATA_FOUND THEN
2890: --l_message_flag :='e';

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

2977: );
2978: END IF;
2979: --10421413
2980:
2981: l_min_holiday_allow := fnd_number.canonical_to_number(NVL(l_min_holiday_char,'0'));
2982:
2983: EXCEPTION
2984: WHEN NO_DATA_FOUND THEN
2985: l_min_holiday_allow := 0;

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

3664: and p_date_earned between asg.effective_start_date and asg.effective_end_date;
3665:
3666: --Cursor to derive the part time percetage value
3667: CURSOR c_get_fte(c_assignment_id IN per_all_assignments_f.assignment_id%TYPE) IS
3668: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100'))
3669: FROM hr_soft_coding_keyflex target,
3670: per_all_assignments_f ASSIGN
3671: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date AND
3672: ASSIGN.effective_end_date

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

4800: (p_data_value IN OUT NOCOPY varchar2)
4801: RETURN NUMBER IS
4802: l_data_value Number;
4803: BEGIN
4804: l_data_value := Fnd_Number.Canonical_To_Number(Nvl(p_data_value,'0'));
4805: IF l_data_value >= 0 THEN
4806: RETURN 0;
4807: ELSE
4808: RETURN 1;

Line 4836: SELECT fnd_number.canonical_to_number(aei_information3)

4832: --cursor to fetch the amount from the assignment EIT
4833: --if a row exists for this savings type and the same period number
4834:
4835: CURSOR c_get_addnl_amt IS
4836: SELECT fnd_number.canonical_to_number(aei_information3)
4837: FROM per_assignment_extra_info
4838: WHERE assignment_id = p_assignment_id
4839: AND aei_information1 = to_char(p_pension_type_id)
4840: AND aei_information2 = to_char(p_payroll_period_number)

Line 5100: RETURN fnd_number.canonical_to_number(l_part_time_perc);

5096: ELSIF g_ptp_formula_exists = FALSE THEN
5097: l_part_time_perc := NULL;
5098: END IF;
5099:
5100: RETURN fnd_number.canonical_to_number(l_part_time_perc);
5101:
5102: END get_hook_part_time_perc;
5103:
5104:

Line 5187: RETURN fnd_number.canonical_to_number(l_part_time_perc);

5183: ELSIF g_ptp_formula_exists = FALSE THEN
5184: l_part_time_perc := NULL;
5185: END IF;
5186:
5187: RETURN fnd_number.canonical_to_number(l_part_time_perc);
5188:
5189: END get_reporting_part_time_perc;
5190:
5191: -- ----------------------------------------------------------------------------

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

5229: decode(asg.effective_end_date,
5230: to_date ('31/12/4712','DD/MM/YYYY'),
5231: trunc(p_period_end_date),
5232: asg.effective_end_date) End_Dt
5233: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
5234: FROM per_assignments_f asg
5235: ,per_assignment_status_types past
5236: ,hr_soft_coding_keyflex target
5237: WHERE asg.assignment_status_type_id = past.assignment_status_type_id