[Home] [Help]
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
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
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
335:
336: hr_utility.trace(' Hourly employee using work schedule');
337: hr_utility.trace(' Get work schedule name');
338:
339: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
340:
341: hr_utility.trace(' v_ws_id ='||to_number(v_ws_id));
342:
343:
496:
497: -- Hourly emp using work schedule.
498: -- Get work schedule name:
499:
500: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
501:
502: SELECT user_column_name
503: INTO v_work_sched_name
504: FROM pay_user_columns
739: v_curr_date DATE;
740: v_curr_day VARCHAR2(3); -- 3 char abbrev for day of wk.
741: v_ws_name VARCHAR2(80); -- Work Schedule Name.
742: v_gtv_hours VARCHAR2(80); -- get_table_value returns varchar2
743: -- Remember to FND_NUMBER.CANONICAL_TO_NUMBER result.
744: v_fnd_sess_row VARCHAR2(1);
745: l_exists VARCHAR2(1);
746: v_day_no NUMBER;
747:
869:
870: --
871: --
872:
873: v_unit := FND_NUMBER.CANONICAL_TO_NUMBER(
874: hruserdt.get_table_value(p_bg_id
875: ,c_ws_tab_name
876: ,v_ws_name
877: ,v_curr_day));
1214: hr_utility.trace('ln_seniority_years = '||ln_seniority_years);
1215:
1216: -- get the FACTOR from the table
1217: -- by passing seniority years,
1218: -- Added fnd_number.canonical_to_number for bug 6815180
1219: ln_idw_factor := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
1220: p_bus_group_id => asg_rec.business_group_id,
1221: p_table_name => lv_idw_factor_tab_name,
1222: p_col_name => 'Factor',
1215:
1216: -- get the FACTOR from the table
1217: -- by passing seniority years,
1218: -- Added fnd_number.canonical_to_number for bug 6815180
1219: ln_idw_factor := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
1220: p_bus_group_id => asg_rec.business_group_id,
1221: p_table_name => lv_idw_factor_tab_name,
1222: p_col_name => 'Factor',
1223: p_row_value => ln_seniority_years,
1302: AND iv.effective_end_date;
1303: BEGIN
1304:
1305: ln_variable_idw := 0;
1306: SELECT fnd_number.canonical_to_number(result_value)
1307: INTO ln_variable_idw
1308: FROM pay_run_result_values rrv,
1309: pay_run_results rr
1310: WHERE assignment_action_id = ln_last_idw_action
1641: BEGIN
1642: --{
1643: ln_contract_days := NULL;
1644: hr_utility.trace('Getting contract days..');
1645: ln_contract_days := fnd_number.canonical_to_number(hruserdt.get_table_value(
1646: p_bus_group_id => p_business_group_id,
1647: p_table_name => 'PQP_CONTRACT_TYPES',
1648: p_col_name => 'Days Divisor',
1649: p_row_value => rv_contract_name,