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 455: -- fnd_number.canonical_to_number when calling wshours fn.

451: v_entrange_start DATE; -- max of entry or asst range start
452: v_entrange_end DATE; -- min of entry or asst range end
453: v_work_schedule VARCHAR2(60); -- Work Schedule ID (stored as varchar2
454: -- in HR_SOFT_CODING_KEYFLEX; convert
455: -- fnd_number.canonical_to_number when calling wshours fn.
456: v_work_sched_name VARCHAR2(80);
457: v_ws_id NUMBER(9);
458:
459: b_entries_done BOOLEAN; -- flags no more entry changes in paypd

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

574: hr_utility.trace('Getting WORK SCHEDULE Name');
575:
576: -- Get work schedule name:
577:
578: v_ws_id := fnd_number.canonical_to_number(p_wsched);
579:
580: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
581:
582: SELECT user_column_name

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

871: l_vac_hours NUMBER(10,7);
872:
873: CURSOR get_vac_hours ( v_asg_id NUMBER,
874: v_eff_date DATE) IS
875: select fnd_number.canonical_to_number(pev.screen_entry_value)
876: from per_absence_attendance_types abt,
877: pay_element_entries_f pee,
878: pay_element_entry_values_f pev
879: where pev.input_value_id = abt.input_value_id

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

937: l_sick_hours NUMBER(10,7);
938:
939: CURSOR get_sick_hours ( v_asg_id NUMBER,
940: v_eff_date DATE) IS
941: select fnd_number.canonical_to_number(pev.screen_entry_value)
942: from per_absence_attendance_types abt,
943: pay_element_entries_f pee,
944: pay_element_entry_values_f pev
945: where pev.input_value_id = abt.input_value_id

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

1263: --
1264: hr_utility.trace('Asg has Work Schedule');
1265: hr_utility.trace('p_work_schedule ='||p_work_schedule);
1266:
1267: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
1268: hr_utility.trace('v_ws_id ='||to_char(v_ws_id));
1269: --
1270: SELECT user_column_name
1271: INTO v_work_sched_name

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

1827:
1828: hr_utility.trace('BOTH ASG Get latest screen entry value for EEVMPE');
1829: hr_utility.set_location('calculate_period_earnings', 128);
1830:
1831: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
1832: INTO v_earnings_entry
1833: FROM pay_element_entry_values_f EEV
1834: WHERE EEV.element_entry_id = p_ele_entry_id
1835: AND EEV.input_value_id = v_inpval_id

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

1901:
1902: hr_utility.trace('NO EEVMPE changes');
1903: hr_utility.set_location('calculate_period_earnings', 132);
1904:
1905: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
1906: INTO v_earnings_entry
1907: FROM pay_element_entry_values_f EEV
1908: WHERE EEV.element_entry_id = p_ele_entry_id
1909: AND EEV.input_value_id = v_inpval_id

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

2003:
2004: -- EEV_FOR_CURR_RANGE_END
2005:
2006: hr_utility.trace('BOTH ASG - EEV false');
2007: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2008: INTO v_earnings_entry
2009: FROM pay_element_entry_values_f EEV
2010: WHERE EEV.element_entry_id = p_ele_entry_id
2011: AND EEV.input_value_id = v_inpval_id

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

2108:
2109: hr_utility.trace('BOTH ASG SPAN - SELECT EEV_FOR_CURR_RANGE_END');
2110: hr_utility.set_location('calculate_period_earnings', 165);
2111:
2112: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
2113: INTO v_earnings_entry
2114: FROM pay_element_entry_values_f EEV
2115: WHERE EEV.element_entry_id = p_ele_entry_id
2116: AND EEV.input_value_id = v_inpval_id

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

2445:
2446: hr_utility.trace(' Hourly employee using work schedule');
2447: hr_utility.trace(' Get work schedule name');
2448:
2449: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2450:
2451: hr_utility.trace(' v_ws_id ='||to_number(v_ws_id));
2452:
2453:

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

2622:
2623: -- Hourly emp using work schedule.
2624: -- Get work schedule name:
2625:
2626: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2627:
2628: SELECT user_column_name
2629: INTO v_work_sched_name
2630: FROM pay_user_columns

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

2851: v_curr_date DATE;
2852: v_curr_day VARCHAR2(3); -- 3 char abbrev for day of wk.
2853: v_ws_name VARCHAR2(80); -- Work Schedule Name.
2854: v_gtv_hours VARCHAR2(80); -- get_table_value returns varchar2
2855: -- Remember to FND_NUMBER.CANONICAL_TO_NUMBER result.
2856: v_fnd_sess_row VARCHAR2(1);
2857: l_exists VARCHAR2(1);
2858: v_day_no NUMBER;
2859:

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

2971: FROM DUAL;
2972:
2973: --
2974: --
2975: v_total_hours := v_total_hours + FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(p_bg_id,
2976: c_ws_tab_name,
2977: v_ws_name,
2978: v_curr_day));
2979: v_curr_date := v_curr_date + 1;

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

3476: --
3477: -- local cursors
3478: --
3479: CURSOR get_tew_rate IS
3480: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3481: EEV.element_entry_id
3482: FROM pay_element_entries_f ELE,
3483: pay_element_entry_values_f EEV,
3484: pay_input_values_f IPV,

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

3555: --
3556: -- These cursors get ALL entries of a particular element type during
3557: -- the period:
3558: CURSOR get_flat_amounts IS
3559: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3560: FROM pay_element_links_f pel,
3561: pay_element_entries_f ele,
3562: pay_element_entry_values_f eev,
3563: pay_input_values_f ipv

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

3573: AND IPV.element_type_id = pel.element_type_id --v_eletype_id
3574: AND IPV.name = 'Amount';
3575: --
3576: CURSOR get_rates IS
3577: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3578: EEV.element_entry_id
3579: FROM pay_element_links_f pel,
3580: pay_element_entries_f ele,
3581: pay_element_entry_values_f eev,

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

3592: AND IPV.element_type_id = pel.element_type_id --v_eletype_id
3593: AND IPV.name = 'Rate';
3594: --
3595: CURSOR get_percentages IS
3596: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3597: FROM pay_element_links_f pel,
3598: pay_element_entries_f ele,
3599: pay_element_entry_values_f eev,
3600: pay_input_values_f ipv

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

3610: AND ipv.element_type_id = pel.element_type_id --v_eletype_id
3611: AND ipv.name = 'Percentage';
3612: --
3613: CURSOR get_grosses IS
3614: SELECT fnd_number.canonical_to_number(RRV.result_value)
3615: FROM pay_run_result_values RRV,
3616: pay_run_results RRS,
3617: pay_input_values_f IPV,
3618: pay_element_types_f ELT

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

3682: from per_time_periods
3683: where payroll_id = p_pay_id
3684: and p_date_earned between start_date and end_date;
3685:
3686: v_pay_basis_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hr_us_ff_udfs.convert_period_type(
3687: p_bus_grp_id => p_bg_id,
3688: p_payroll_id => p_pay_id,
3689: p_asst_work_schedule => p_work_sched,
3690: p_asst_std_hours => p_std_hours,

Line 3741: FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(

3737: ELSE
3738: -- Find rate from rate table.
3739: hr_utility.set_location('OT_Base_Rate', 17);
3740: v_tew_total_rate := v_tew_total_rate +
3741: FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
3742: p_bg_id,
3743: c_rate_table_name,
3744: c_rate_table_column,
3745: v_tew_rcode));

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

3778:
3779: --
3780: IF v_use_regwage <> 0 THEN
3781: hr_utility.set_location('OT_Base_Rate', 30);
3782: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3783: EEV.element_entry_id
3784: INTO v_regwage_rate,
3785: v_entry_id
3786: FROM pay_element_entries_f ELE,

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

3832: AND IPV.legislation_code = ELT.legislation_code;
3833:
3834: --
3835: hr_utility.set_location('OT_Base_Rate', 41);
3836: v_regwage_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
3837: p_bus_group_id => p_bg_id,
3838: p_table_name => c_rate_table_name,
3839: p_col_name => c_rate_table_column,
3840: p_row_value => v_regwage_rcode));

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

3868:
3869: --
3870: IF v_use_regsal <> 0 THEN
3871: hr_utility.set_location('OT_Base_Rate', 51);
3872: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3873: INTO v_regsal_mosal
3874: FROM pay_element_entries_f ELE,
3875: pay_element_entry_values_f EEV,
3876: pay_input_values_f IPV,

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

4010: AND UPPER(IPV.name) = 'RATE CODE';
4011: --
4012: IF v_rate_rcode <> 'NOT ENTERED' THEN
4013: hr_utility.set_location('OT_Base_Rate', 130);
4014: v_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
4015: p_bg_id,
4016: c_rate_table_name,
4017: c_rate_table_column,
4018: v_rate_rcode));

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

4039: AND UPPER(IPV.name) = 'MULTIPLE';
4040: --
4041: IF v_rate_mult_count <> 0 THEN
4042: hr_utility.set_location('OT_Base_Rate', 140);
4043: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
4044: INTO v_rate_multiple
4045: FROM pay_element_entry_values_f EEV,
4046: pay_element_entries_f ELE,
4047: pay_element_types_f ELT,