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

Line 86: FND_NUMBER.CANONICAL_TO_NUMBER

82: converted to initcaps.
83: Actually, just UPPER both sides
84: of compare to remove any doubt.
85: Also needed
86: FND_NUMBER.CANONICAL_TO_NUMBER
87: on zip code for "between"
88: comparisons.
89: - not sure why this is needed,
90: - but the sql would not work

Line 100: FND_NUMBER.CANONICAL_TO_NUMBER

96: look at canada a.state_code
97: != 70. This fixes the invalid
98: number error
99: 01-MAY-95 gpaytonm 40.16 Removed prior fix and removed
100: FND_NUMBER.CANONICAL_TO_NUMBER
101: from addr_val select instead
102: 09-MAY-95 gpaytonm 40.17 Removed remaining
103: FND_NUMBER.CANONICAL_TO_NUMBER's from addr_Val
104: 15-MAY-95 hparicha 40.18 Added UPPER to PERIOD_TYPE

Line 103: FND_NUMBER.CANONICAL_TO_NUMBER's from addr_Val

99: 01-MAY-95 gpaytonm 40.16 Removed prior fix and removed
100: FND_NUMBER.CANONICAL_TO_NUMBER
101: from addr_val select instead
102: 09-MAY-95 gpaytonm 40.17 Removed remaining
103: FND_NUMBER.CANONICAL_TO_NUMBER's from addr_Val
104: 15-MAY-95 hparicha 40.18 Added UPPER to PERIOD_TYPE
105: comparison in Convert_Period_
106: Type.
107: 23-JUN-95 gpaytonm 40.19 Changed references to

Line 446: -- fnd_number.canonical_to_number when calling wshours fn.

442: v_entrange_start DATE; -- max of entry or asst range start
443: v_entrange_end DATE; -- min of entry or asst range end
444: v_work_schedule VARCHAR2(60); -- Work Schedule ID (stored as varchar2
445: -- in HR_SOFT_CODING_KEYFLEX; convert
446: -- fnd_number.canonical_to_number when calling wshours fn.
447: v_work_sched_name VARCHAR2(80);
448: v_ws_id NUMBER(9);
449:
450: b_entries_done BOOLEAN; -- flags no more entry changes in paypd

Line 569: v_ws_id := fnd_number.canonical_to_number(p_wsched);

565: hr_utility.trace('Getting WORK SCHEDULE Name');
566:
567: -- Get work schedule name:
568:
569: v_ws_id := fnd_number.canonical_to_number(p_wsched);
570:
571: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
572:
573: SELECT user_column_name

Line 866: select fnd_number.canonical_to_number(pev.screen_entry_value)

862: l_vac_hours NUMBER(10,7);
863:
864: CURSOR get_vac_hours ( v_asg_id NUMBER,
865: v_eff_date DATE) IS
866: select fnd_number.canonical_to_number(pev.screen_entry_value)
867: from per_absence_attendance_types abt,
868: pay_element_entries_f pee,
869: pay_element_entry_values_f pev
870: where pev.input_value_id = abt.input_value_id

Line 932: select fnd_number.canonical_to_number(pev.screen_entry_value)

928: l_sick_hours NUMBER(10,7);
929:
930: CURSOR get_sick_hours ( v_asg_id NUMBER,
931: v_eff_date DATE) IS
932: select fnd_number.canonical_to_number(pev.screen_entry_value)
933: from per_absence_attendance_types abt,
934: pay_element_entries_f pee,
935: pay_element_entry_values_f pev
936: where pev.input_value_id = abt.input_value_id

Line 1258: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);

1254: --
1255: hr_utility.trace('Asg has Work Schedule');
1256: hr_utility.trace('p_work_schedule ='||p_work_schedule);
1257:
1258: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
1259: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
1260: --
1261: SELECT user_column_name
1262: INTO v_work_sched_name

Line 1822: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)

1818:
1819: hr_utility.trace('BOTH ASG Get latest screen entry value for EEVMPE');
1820: hr_utility.set_location('calculate_period_earnings', 128);
1821:
1822: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
1823: INTO v_earnings_entry
1824: FROM pay_element_entry_values_f EEV
1825: WHERE EEV.element_entry_id = p_ele_entry_id
1826: AND EEV.input_value_id = v_inpval_id

Line 1896: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)

1892:
1893: hr_utility.trace('NO EEVMPE changes');
1894: hr_utility.set_location('calculate_period_earnings', 132);
1895:
1896: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
1897: INTO v_earnings_entry
1898: FROM pay_element_entry_values_f EEV
1899: WHERE EEV.element_entry_id = p_ele_entry_id
1900: AND EEV.input_value_id = v_inpval_id

Line 1998: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)

1994:
1995: -- EEV_FOR_CURR_RANGE_END
1996:
1997: hr_utility.trace('BOTH ASG - EEV false');
1998: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
1999: INTO v_earnings_entry
2000: FROM pay_element_entry_values_f EEV
2001: WHERE EEV.element_entry_id = p_ele_entry_id
2002: AND EEV.input_value_id = v_inpval_id

Line 2103: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)

2099:
2100: hr_utility.trace('BOTH ASG SPAN - SELECT EEV_FOR_CURR_RANGE_END');
2101: hr_utility.set_location('calculate_period_earnings', 165);
2102:
2103: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2104: INTO v_earnings_entry
2105: FROM pay_element_entry_values_f EEV
2106: WHERE EEV.element_entry_id = p_ele_entry_id
2107: AND EEV.input_value_id = v_inpval_id

Line 2440: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);

2436:
2437: hr_utility.trace(' Hourly employee using work schedule');
2438: hr_utility.trace(' Get work schedule name');
2439:
2440: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2441:
2442: hr_utility.trace(' v_ws_id ='||to_number(v_ws_id));
2443:
2444:

Line 2617: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);

2613:
2614: -- Hourly emp using work schedule.
2615: -- Get work schedule name:
2616:
2617: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2618:
2619: SELECT user_column_name
2620: INTO v_work_sched_name
2621: FROM pay_user_columns

Line 2846: -- Remember to FND_NUMBER.CANONICAL_TO_NUMBER result.

2842: v_curr_date DATE;
2843: v_curr_day VARCHAR2(3); -- 3 char abbrev for day of wk.
2844: v_ws_name VARCHAR2(80); -- Work Schedule Name.
2845: v_gtv_hours VARCHAR2(80); -- get_table_value returns varchar2
2846: -- Remember to FND_NUMBER.CANONICAL_TO_NUMBER result.
2847: v_fnd_sess_row VARCHAR2(1);
2848: l_exists VARCHAR2(1);
2849: v_day_no NUMBER;
2850:

Line 2966: v_total_hours := v_total_hours + FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(p_bg_id,

2962: FROM DUAL;
2963:
2964: --
2965: --
2966: v_total_hours := v_total_hours + FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(p_bg_id,
2967: c_ws_tab_name,
2968: v_ws_name,
2969: v_curr_day));
2970: v_curr_date := v_curr_date + 1;

Line 3471: SELECT /+ ORDERED / NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),

3467: --
3468: -- local cursors
3469: --
3470: CURSOR get_tew_rate IS
3471: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3472: EEV.element_entry_id
3473: FROM pay_element_entries_f ELE,
3474: pay_element_entry_values_f EEV,
3475: pay_input_values_f IPV,

Line 3550: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)

3546: --
3547: -- These cursors get ALL entries of a particular element type during
3548: -- the period:
3549: CURSOR get_flat_amounts IS
3550: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3551: FROM pay_element_links_f pel,
3552: pay_element_entries_f ele,
3553: pay_element_entry_values_f eev,
3554: pay_input_values_f ipv

Line 3568: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),

3564: AND IPV.element_type_id = pel.element_type_id --v_eletype_id
3565: AND IPV.name = 'Amount';
3566: --
3567: CURSOR get_rates IS
3568: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3569: EEV.element_entry_id
3570: FROM pay_element_links_f pel,
3571: pay_element_entries_f ele,
3572: pay_element_entry_values_f eev,

Line 3587: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)

3583: AND IPV.element_type_id = pel.element_type_id --v_eletype_id
3584: AND IPV.name = 'Rate';
3585: --
3586: CURSOR get_percentages IS
3587: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3588: FROM pay_element_links_f pel,
3589: pay_element_entries_f ele,
3590: pay_element_entry_values_f eev,
3591: pay_input_values_f ipv

Line 3605: SELECT fnd_number.canonical_to_number(RRV.result_value)

3601: AND ipv.element_type_id = pel.element_type_id --v_eletype_id
3602: AND ipv.name = 'Percentage';
3603: --
3604: CURSOR get_grosses IS
3605: SELECT fnd_number.canonical_to_number(RRV.result_value)
3606: FROM pay_run_result_values RRV,
3607: pay_run_results RRS,
3608: pay_input_values_f IPV,
3609: pay_element_types_f ELT

Line 3677: v_pay_basis_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hr_us_ff_udfs.convert_period_type(

3673: from per_time_periods
3674: where payroll_id = p_pay_id
3675: and p_date_earned between start_date and end_date;
3676:
3677: v_pay_basis_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hr_us_ff_udfs.convert_period_type(
3678: p_bus_grp_id => p_bg_id,
3679: p_payroll_id => p_pay_id,
3680: p_asst_work_schedule => p_work_sched,
3681: p_asst_std_hours => p_std_hours,

Line 3732: FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(

3728: ELSE
3729: -- Find rate from rate table.
3730: hr_utility.set_location('OT_Base_Rate', 17);
3731: v_tew_total_rate := v_tew_total_rate +
3732: FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
3733: p_bg_id,
3734: c_rate_table_name,
3735: c_rate_table_column,
3736: v_tew_rcode));

Line 3773: SELECT /+ ORDERED / NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),

3769:
3770: --
3771: IF v_use_regwage <> 0 THEN
3772: hr_utility.set_location('OT_Base_Rate', 30);
3773: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3774: EEV.element_entry_id
3775: INTO v_regwage_rate,
3776: v_entry_id
3777: FROM pay_element_entries_f ELE,

Line 3827: v_regwage_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(

3823: AND IPV.legislation_code = ELT.legislation_code;
3824:
3825: --
3826: hr_utility.set_location('OT_Base_Rate', 41);
3827: v_regwage_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
3828: p_bus_group_id => p_bg_id,
3829: p_table_name => c_rate_table_name,
3830: p_col_name => c_rate_table_column,
3831: p_row_value => v_regwage_rcode));

Line 3863: SELECT /+ ORDERED / NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)

3859:
3860: --
3861: IF v_use_regsal <> 0 THEN
3862: hr_utility.set_location('OT_Base_Rate', 51);
3863: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3864: INTO v_regsal_mosal
3865: FROM pay_element_entries_f ELE,
3866: pay_element_entry_values_f EEV,
3867: pay_input_values_f IPV,

Line 4005: v_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(

4001: AND UPPER(IPV.name) = 'RATE CODE';
4002: --
4003: IF v_rate_rcode <> 'NOT ENTERED' THEN
4004: hr_utility.set_location('OT_Base_Rate', 130);
4005: v_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
4006: p_bg_id,
4007: c_rate_table_name,
4008: c_rate_table_column,
4009: v_rate_rcode));

Line 4034: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)

4030: AND UPPER(IPV.name) = 'MULTIPLE';
4031: --
4032: IF v_rate_mult_count <> 0 THEN
4033: hr_utility.set_location('OT_Base_Rate', 140);
4034: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
4035: INTO v_rate_multiple
4036: FROM pay_element_entry_values_f EEV,
4037: pay_element_entries_f ELE,
4038: pay_element_types_f ELT,