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.PER_FR_D2_PKG dependencies on FND_NUMBER

Line 6: max(fnd_number.canonical_to_number(decode(

2: /* $Header: pefrd2rp.pkb 120.1 2005/12/20 13:34:05 aparkes noship $ */
3:
4: cursor csr_get_extra_units(p_effective_date date) is
5: select
6: max(fnd_number.canonical_to_number(decode(
7: R.row_low_range_or_name,'BASE_UNIT',CINST.value))) base_unit
8: ,max(fnd_number.canonical_to_number(decode(
9: R.row_low_range_or_name,'X_COT_A',CINST.value))) x_cot_a
10: ,max(fnd_number.canonical_to_number(decode(

Line 8: ,max(fnd_number.canonical_to_number(decode(

4: cursor csr_get_extra_units(p_effective_date date) is
5: select
6: max(fnd_number.canonical_to_number(decode(
7: R.row_low_range_or_name,'BASE_UNIT',CINST.value))) base_unit
8: ,max(fnd_number.canonical_to_number(decode(
9: R.row_low_range_or_name,'X_COT_A',CINST.value))) x_cot_a
10: ,max(fnd_number.canonical_to_number(decode(
11: R.row_low_range_or_name,'X_COT_B',CINST.value))) x_cot_b
12: ,max(fnd_number.canonical_to_number(decode(

Line 10: ,max(fnd_number.canonical_to_number(decode(

6: max(fnd_number.canonical_to_number(decode(
7: R.row_low_range_or_name,'BASE_UNIT',CINST.value))) base_unit
8: ,max(fnd_number.canonical_to_number(decode(
9: R.row_low_range_or_name,'X_COT_A',CINST.value))) x_cot_a
10: ,max(fnd_number.canonical_to_number(decode(
11: R.row_low_range_or_name,'X_COT_B',CINST.value))) x_cot_b
12: ,max(fnd_number.canonical_to_number(decode(
13: R.row_low_range_or_name,'X_COT_C',CINST.value))) x_cot_c
14: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

Line 12: ,max(fnd_number.canonical_to_number(decode(

8: ,max(fnd_number.canonical_to_number(decode(
9: R.row_low_range_or_name,'X_COT_A',CINST.value))) x_cot_a
10: ,max(fnd_number.canonical_to_number(decode(
11: R.row_low_range_or_name,'X_COT_B',CINST.value))) x_cot_b
12: ,max(fnd_number.canonical_to_number(decode(
13: R.row_low_range_or_name,'X_COT_C',CINST.value))) x_cot_c
14: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
15: 'X_COT_YOUNG_AGE',CINST.value))) x_cot_young_age
16: ,max(fnd_number.canonical_to_number(decode(

Line 14: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

10: ,max(fnd_number.canonical_to_number(decode(
11: R.row_low_range_or_name,'X_COT_B',CINST.value))) x_cot_b
12: ,max(fnd_number.canonical_to_number(decode(
13: R.row_low_range_or_name,'X_COT_C',CINST.value))) x_cot_c
14: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
15: 'X_COT_YOUNG_AGE',CINST.value))) x_cot_young_age
16: ,max(fnd_number.canonical_to_number(decode(
17: R.row_low_range_or_name,'X_COT_OLD_AGE',CINST.value))) x_cot_old_age
18: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

Line 16: ,max(fnd_number.canonical_to_number(decode(

12: ,max(fnd_number.canonical_to_number(decode(
13: R.row_low_range_or_name,'X_COT_C',CINST.value))) x_cot_c
14: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
15: 'X_COT_YOUNG_AGE',CINST.value))) x_cot_young_age
16: ,max(fnd_number.canonical_to_number(decode(
17: R.row_low_range_or_name,'X_COT_OLD_AGE',CINST.value))) x_cot_old_age
18: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
19: 'X_COT_AGE_UNITS',CINST.value))) x_cot_age_units
20: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

Line 18: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

14: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
15: 'X_COT_YOUNG_AGE',CINST.value))) x_cot_young_age
16: ,max(fnd_number.canonical_to_number(decode(
17: R.row_low_range_or_name,'X_COT_OLD_AGE',CINST.value))) x_cot_old_age
18: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
19: 'X_COT_AGE_UNITS',CINST.value))) x_cot_age_units
20: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
21: 'X_COT_TRAINING_HOURS',CINST.value))) x_cot_training_hours
22: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

Line 20: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

16: ,max(fnd_number.canonical_to_number(decode(
17: R.row_low_range_or_name,'X_COT_OLD_AGE',CINST.value))) x_cot_old_age
18: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
19: 'X_COT_AGE_UNITS',CINST.value))) x_cot_age_units
20: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
21: 'X_COT_TRAINING_HOURS',CINST.value))) x_cot_training_hours
22: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
23: 'X_COT_TRAINING_UNITS',CINST.value))) x_cot_training_units
24: ,max(fnd_number.canonical_to_number(decode(

Line 22: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

18: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
19: 'X_COT_AGE_UNITS',CINST.value))) x_cot_age_units
20: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
21: 'X_COT_TRAINING_HOURS',CINST.value))) x_cot_training_hours
22: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
23: 'X_COT_TRAINING_UNITS',CINST.value))) x_cot_training_units
24: ,max(fnd_number.canonical_to_number(decode(
25: R.row_low_range_or_name,'X_COT_AP',CINST.value))) x_cot_ap
26: ,max(fnd_number.canonical_to_number(decode(

Line 24: ,max(fnd_number.canonical_to_number(decode(

20: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
21: 'X_COT_TRAINING_HOURS',CINST.value))) x_cot_training_hours
22: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
23: 'X_COT_TRAINING_UNITS',CINST.value))) x_cot_training_units
24: ,max(fnd_number.canonical_to_number(decode(
25: R.row_low_range_or_name,'X_COT_AP',CINST.value))) x_cot_ap
26: ,max(fnd_number.canonical_to_number(decode(
27: R.row_low_range_or_name,'X_COT_IMPRO',CINST.value))) x_cot_impro
28: ,max(fnd_number.canonical_to_number(decode(

Line 26: ,max(fnd_number.canonical_to_number(decode(

22: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
23: 'X_COT_TRAINING_UNITS',CINST.value))) x_cot_training_units
24: ,max(fnd_number.canonical_to_number(decode(
25: R.row_low_range_or_name,'X_COT_AP',CINST.value))) x_cot_ap
26: ,max(fnd_number.canonical_to_number(decode(
27: R.row_low_range_or_name,'X_COT_IMPRO',CINST.value))) x_cot_impro
28: ,max(fnd_number.canonical_to_number(decode(
29: R.row_low_range_or_name,'X_COT_CAT',CINST.value))) x_cot_cat
30: ,max(fnd_number.canonical_to_number(decode(

Line 28: ,max(fnd_number.canonical_to_number(decode(

24: ,max(fnd_number.canonical_to_number(decode(
25: R.row_low_range_or_name,'X_COT_AP',CINST.value))) x_cot_ap
26: ,max(fnd_number.canonical_to_number(decode(
27: R.row_low_range_or_name,'X_COT_IMPRO',CINST.value))) x_cot_impro
28: ,max(fnd_number.canonical_to_number(decode(
29: R.row_low_range_or_name,'X_COT_CAT',CINST.value))) x_cot_cat
30: ,max(fnd_number.canonical_to_number(decode(
31: R.row_low_range_or_name,'X_COT_CDTD',CINST.value))) x_cot_cdtd
32: ,max(fnd_number.canonical_to_number(decode(

Line 30: ,max(fnd_number.canonical_to_number(decode(

26: ,max(fnd_number.canonical_to_number(decode(
27: R.row_low_range_or_name,'X_COT_IMPRO',CINST.value))) x_cot_impro
28: ,max(fnd_number.canonical_to_number(decode(
29: R.row_low_range_or_name,'X_COT_CAT',CINST.value))) x_cot_cat
30: ,max(fnd_number.canonical_to_number(decode(
31: R.row_low_range_or_name,'X_COT_CDTD',CINST.value))) x_cot_cdtd
32: ,max(fnd_number.canonical_to_number(decode(
33: R.row_low_range_or_name,'X_COT_CFP',CINST.value))) x_cot_cfp
34: ,max(fnd_number.canonical_to_number(decode(

Line 32: ,max(fnd_number.canonical_to_number(decode(

28: ,max(fnd_number.canonical_to_number(decode(
29: R.row_low_range_or_name,'X_COT_CAT',CINST.value))) x_cot_cat
30: ,max(fnd_number.canonical_to_number(decode(
31: R.row_low_range_or_name,'X_COT_CDTD',CINST.value))) x_cot_cdtd
32: ,max(fnd_number.canonical_to_number(decode(
33: R.row_low_range_or_name,'X_COT_CFP',CINST.value))) x_cot_cfp
34: ,max(fnd_number.canonical_to_number(decode(
35: R.row_low_range_or_name,'X_IPP_LOW_RATE',CINST.value))) x_ipp_low_rate
36: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

Line 34: ,max(fnd_number.canonical_to_number(decode(

30: ,max(fnd_number.canonical_to_number(decode(
31: R.row_low_range_or_name,'X_COT_CDTD',CINST.value))) x_cot_cdtd
32: ,max(fnd_number.canonical_to_number(decode(
33: R.row_low_range_or_name,'X_COT_CFP',CINST.value))) x_cot_cfp
34: ,max(fnd_number.canonical_to_number(decode(
35: R.row_low_range_or_name,'X_IPP_LOW_RATE',CINST.value))) x_ipp_low_rate
36: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
37: 'X_IPP_MEDIUM_RATE',CINST.value))) x_ipp_medium_rate
38: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

Line 36: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

32: ,max(fnd_number.canonical_to_number(decode(
33: R.row_low_range_or_name,'X_COT_CFP',CINST.value))) x_cot_cfp
34: ,max(fnd_number.canonical_to_number(decode(
35: R.row_low_range_or_name,'X_IPP_LOW_RATE',CINST.value))) x_ipp_low_rate
36: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
37: 'X_IPP_MEDIUM_RATE',CINST.value))) x_ipp_medium_rate
38: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
39: 'X_IPP_HIGH_RATE',CINST.value))) x_ipp_high_rate
40: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

Line 38: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

34: ,max(fnd_number.canonical_to_number(decode(
35: R.row_low_range_or_name,'X_IPP_LOW_RATE',CINST.value))) x_ipp_low_rate
36: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
37: 'X_IPP_MEDIUM_RATE',CINST.value))) x_ipp_medium_rate
38: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
39: 'X_IPP_HIGH_RATE',CINST.value))) x_ipp_high_rate
40: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
41: 'X_IPP_LOW_UNITS',CINST.value))) x_ipp_low_units
42: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

Line 40: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

36: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
37: 'X_IPP_MEDIUM_RATE',CINST.value))) x_ipp_medium_rate
38: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
39: 'X_IPP_HIGH_RATE',CINST.value))) x_ipp_high_rate
40: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
41: 'X_IPP_LOW_UNITS',CINST.value))) x_ipp_low_units
42: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
43: 'X_IPP_MEDIUM_UNITS',CINST.value))) x_ipp_medium_units
44: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

Line 42: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

38: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
39: 'X_IPP_HIGH_RATE',CINST.value))) x_ipp_high_rate
40: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
41: 'X_IPP_LOW_UNITS',CINST.value))) x_ipp_low_units
42: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
43: 'X_IPP_MEDIUM_UNITS',CINST.value))) x_ipp_medium_units
44: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
45: 'X_IPP_HIGH_UNITS',CINST.value))) x_ipp_high_units
46: ,max(fnd_number.canonical_to_number(decode(

Line 44: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,

40: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
41: 'X_IPP_LOW_UNITS',CINST.value))) x_ipp_low_units
42: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
43: 'X_IPP_MEDIUM_UNITS',CINST.value))) x_ipp_medium_units
44: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
45: 'X_IPP_HIGH_UNITS',CINST.value))) x_ipp_high_units
46: ,max(fnd_number.canonical_to_number(decode(
47: R.row_low_range_or_name,'X_HIRE_UNITS',CINST.value))) x_hire_units
48: from pay_user_tables TAB

Line 46: ,max(fnd_number.canonical_to_number(decode(

42: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
43: 'X_IPP_MEDIUM_UNITS',CINST.value))) x_ipp_medium_units
44: ,max(fnd_number.canonical_to_number(decode(R.row_low_range_or_name,
45: 'X_IPP_HIGH_UNITS',CINST.value))) x_ipp_high_units
46: ,max(fnd_number.canonical_to_number(decode(
47: R.row_low_range_or_name,'X_HIRE_UNITS',CINST.value))) x_hire_units
48: from pay_user_tables TAB
49: , pay_user_rows_f R
50: , pay_user_columns C

Line 131: fnd_number.canonical_to_number(hruserdt.get_table_value

127: from hr_all_organization_units
128: where organization_id = p_establishment_id;
129: --
130: percent_disabled_obligation :=
131: fnd_number.canonical_to_number(hruserdt.get_table_value
132: (l_business_group_id,
133: 'FR_D2_RATES',
134: 'VALUE',
135: 'PERCENT_OBLIGATION'

Line 359: fnd_number.number_to_canonical(p_estab_hours);

355: fnd_date.date_to_canonical(p_block.block_end_date);
356: end if;
357: if l_inputs(l_in_cnt).name='ESTABLISHMENT_MONTHLY_HOURS' then
358: l_inputs(l_in_cnt).value :=
359: fnd_number.number_to_canonical(p_estab_hours);
360: end if;
361: if l_inputs(l_in_cnt).name='RUNNING_TOTAL' then
362: l_inputs(l_in_cnt).value :=
363: fnd_number.number_to_canonical(p_tmp_total);

Line 363: fnd_number.number_to_canonical(p_tmp_total);

359: fnd_number.number_to_canonical(p_estab_hours);
360: end if;
361: if l_inputs(l_in_cnt).name='RUNNING_TOTAL' then
362: l_inputs(l_in_cnt).value :=
363: fnd_number.number_to_canonical(p_tmp_total);
364: end if;
365: if l_inputs(l_in_cnt).name='END_OF_YEAR' then
366: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(p_31dec);
367: end if;

Line 394: fnd_number.canonical_to_number(l_outputs(l_out_cnt).value);

390: l_outputs.first..l_outputs.last
391: loop
392: if l_outputs(l_out_cnt).name = 'NEW_TOTAL' then
393: p_tmp_total :=
394: fnd_number.canonical_to_number(l_outputs(l_out_cnt).value);
395: end if;
396: if l_outputs(l_out_cnt).name = 'CONTINUE_FLAG' then
397: l_flag := l_outputs(l_out_cnt).value;
398: end if;

Line 430: l_hours := fnd_number.canonical_to_number(l_hours_text);

426: from hr_organization_information
427: where organization_id = p_establishment_id
428: and org_information_context = 'FR_ESTAB_INFO';
429: --
430: l_hours := fnd_number.canonical_to_number(l_hours_text);
431: --
432: return l_hours;
433: exception
434: when others then

Line 603: select nvl(max(fnd_number.canonical_to_number(pei_information2)),0)

599: p_pcs_code,
600: p_job_title);
601: -- get hours training
602: --
603: select nvl(max(fnd_number.canonical_to_number(pei_information2)),0)
604: into p_hours_training
605: from per_people_extra_info
606: where person_id = p_person_id
607: and nvl(pei_information_category,' ') = 'FR_PROF_TRAIN'

Line 1253: fnd_number.canonical_to_number(nvl(org.ORG_INFORMATION3,

1249: ctr.status,
1250: scl.segment2,
1251: nvl(pos.frequency,nvl(org.ORG_INFORMATION4,bus.ORG_INFORMATION4)),
1252: nvl(pos.working_hours,
1253: fnd_number.canonical_to_number(nvl(org.ORG_INFORMATION3,
1254: bus.ORG_INFORMATION3))),
1255: bud.value,
1256: asg.assignment_type,
1257: asg.person_id