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.

[Home] [Help]

APPS.PAY_MX_FF_UDFS dependencies on FND_NUMBER

Line 80: 15-Feb-2008 sivanara 115.24 6815180 Added fnd_number.canonical_to_number

76: into get_mx_historic_rate.
77: 07-Jun-2007 vpandya 115.23 6120352 Changed get_idw procedure:
78: added c_idw_factor_table_US and
79: c_idw_user_table_check cursor.
80: 15-Feb-2008 sivanara 115.24 6815180 Added fnd_number.canonical_to_number
81: in tht function get_idw.
82: 15-Apr-2008 sivanara 115.25 6969326 Added the missed out parameter call
83: while calling core package
84: pay_user_row_api.create_user_row

Line 85: 13-Jun-2008 nragavar 115.26 7047220 Added fnd_number.canonical_to_number

81: in tht function get_idw.
82: 15-Apr-2008 sivanara 115.25 6969326 Added the missed out parameter call
83: while calling core package
84: pay_user_row_api.create_user_row
85: 13-Jun-2008 nragavar 115.26 7047220 Added fnd_number.canonical_to_number
86: in tht function get_idw.
87: 09-Jul-2008 sivanara 115.27 7208623 Added fnd_number.canonical_to_number
88: in tht function get_idw.get_contract_name
89: 04-Aug-2008 nragavar 115.28 7042174 Done changes as part of 10 day

Line 87: 09-Jul-2008 sivanara 115.27 7208623 Added fnd_number.canonical_to_number

83: while calling core package
84: pay_user_row_api.create_user_row
85: 13-Jun-2008 nragavar 115.26 7047220 Added fnd_number.canonical_to_number
86: in tht function get_idw.
87: 09-Jul-2008 sivanara 115.27 7208623 Added fnd_number.canonical_to_number
88: in tht function get_idw.get_contract_name
89: 04-Aug-2008 nragavar 115.28 7042174 Done changes as part of 10 day
90: payroll frequency.
91: 20-Aug-2008 nragavar 115.29 7336646 no of days in pay period for 10 day

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

348:
349: hr_utility.trace(' Hourly employee using work schedule');
350: hr_utility.trace(' Get work schedule name');
351:
352: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
353:
354: hr_utility.trace(' v_ws_id ='||to_number(v_ws_id));
355:
356:

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

509:
510: -- Hourly emp using work schedule.
511: -- Get work schedule name:
512:
513: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
514:
515: SELECT user_column_name
516: INTO v_work_sched_name
517: FROM pay_user_columns

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

752: v_curr_date DATE;
753: v_curr_day VARCHAR2(3); -- 3 char abbrev for day of wk.
754: v_ws_name VARCHAR2(80); -- Work Schedule Name.
755: v_gtv_hours VARCHAR2(80); -- get_table_value returns varchar2
756: -- Remember to FND_NUMBER.CANONICAL_TO_NUMBER result.
757: v_fnd_sess_row VARCHAR2(1);
758: l_exists VARCHAR2(1);
759: v_day_no NUMBER;
760:

Line 886: v_unit := FND_NUMBER.CANONICAL_TO_NUMBER(

882:
883: --
884: --
885:
886: v_unit := FND_NUMBER.CANONICAL_TO_NUMBER(
887: hruserdt.get_table_value(p_bg_id
888: ,c_ws_tab_name
889: ,v_ws_name
890: ,v_curr_day));

Line 999: select nvl(FND_NUMBER.CANONICAL_TO_NUMBER(pev.SCREEN_ENTRY_VALUE),0)

995:
996: CURSOR c_get_variable_idw_value (cp_asg_id pay_element_entries_f.assignment_id%TYPE,
997: cp_eff_date DATE)
998: IS
999: select nvl(FND_NUMBER.CANONICAL_TO_NUMBER(pev.SCREEN_ENTRY_VALUE),0)
1000: from pay_element_types_f pet,
1001: pay_input_values_f piv,
1002: pay_element_entries_f pee,
1003: pay_element_entry_values_f pev

Line 1370: -- Added fnd_number.canonical_to_number for bug 6815180

1366: hr_utility.trace('ln_seniority_years = '||ln_seniority_years);
1367:
1368: -- get the FACTOR from the table
1369: -- by passing seniority years,
1370: -- Added fnd_number.canonical_to_number for bug 6815180
1371: ln_idw_factor := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
1372: p_bus_group_id => asg_rec.business_group_id,
1373: p_table_name => lv_idw_factor_tab_name,
1374: p_col_name => 'Factor',

Line 1371: ln_idw_factor := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(

1367:
1368: -- get the FACTOR from the table
1369: -- by passing seniority years,
1370: -- Added fnd_number.canonical_to_number for bug 6815180
1371: ln_idw_factor := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
1372: p_bus_group_id => asg_rec.business_group_id,
1373: p_table_name => lv_idw_factor_tab_name,
1374: p_col_name => 'Factor',
1375: p_row_value => ln_seniority_years,

Line 1461: SELECT fnd_number.canonical_to_number(result_value)

1457: AND iv.effective_end_date;
1458: BEGIN
1459:
1460: ln_variable_idw := 0;
1461: SELECT fnd_number.canonical_to_number(result_value)
1462: INTO ln_variable_idw
1463: FROM pay_run_result_values rrv,
1464: pay_run_results rr
1465: WHERE assignment_action_id = ln_last_idw_action

Line 1800: ln_contract_days := fnd_number.canonical_to_number(hruserdt.get_table_value(

1796: BEGIN
1797: --{
1798: ln_contract_days := NULL;
1799: hr_utility.trace('Getting contract days..');
1800: ln_contract_days := fnd_number.canonical_to_number(hruserdt.get_table_value(
1801: p_bus_group_id => p_business_group_id,
1802: p_table_name => 'PQP_CONTRACT_TYPES',
1803: p_col_name => 'Days Divisor',
1804: p_row_value => rv_contract_name,