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.PAY_FR_SICKNESS_CALC dependencies on FND_DATE

Line 678: , fnd_date.date_to_canonical(p_absence_arch.date_earned));

674: , p_asg.assignment_id);
675: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID'
676: , p_asg.assignment_action_id);
677: pay_balance_pkg.set_context('DATE_EARNED'
678: , fnd_date.date_to_canonical(p_absence_arch.date_earned));
679: pay_balance_pkg.set_context('BUSINESS_GROUP_ID'
680: , p_asg.business_group_id);
681: pay_balance_pkg.set_context('PAYROLL_ID'
682: , p_asg.payroll_id);

Line 695: l_inputs(i).value := fnd_date.date_to_canonical(p_absence_start_date);

691: , l_outputs);
692:
693: For i in 1..l_inputs.count Loop
694: IF l_inputs(i).name = 'DEDUCTION_START_DATE' THEN
695: l_inputs(i).value := fnd_date.date_to_canonical(p_absence_start_date);
696: ELSIF l_inputs(i).name = 'DEDUCTION_END_DATE' THEN
697: l_inputs(i).value:= fnd_date.date_to_canonical(p_absence_end_date);
698: ELSIF l_inputs(i).name = 'ASG_ACTION_START_DATE' THEN
699: -- condition added for CPAM payment process

Line 697: l_inputs(i).value:= fnd_date.date_to_canonical(p_absence_end_date);

693: For i in 1..l_inputs.count Loop
694: IF l_inputs(i).name = 'DEDUCTION_START_DATE' THEN
695: l_inputs(i).value := fnd_date.date_to_canonical(p_absence_start_date);
696: ELSIF l_inputs(i).name = 'DEDUCTION_END_DATE' THEN
697: l_inputs(i).value:= fnd_date.date_to_canonical(p_absence_end_date);
698: ELSIF l_inputs(i).name = 'ASG_ACTION_START_DATE' THEN
699: -- condition added for CPAM payment process
700: IF g_absence_calc.initiator = 'CPAM' THEN
701: l_inputs(i).value:= fnd_date.date_to_canonical(g_absence_calc.abs_ptd_start_date);

Line 701: l_inputs(i).value:= fnd_date.date_to_canonical(g_absence_calc.abs_ptd_start_date);

697: l_inputs(i).value:= fnd_date.date_to_canonical(p_absence_end_date);
698: ELSIF l_inputs(i).name = 'ASG_ACTION_START_DATE' THEN
699: -- condition added for CPAM payment process
700: IF g_absence_calc.initiator = 'CPAM' THEN
701: l_inputs(i).value:= fnd_date.date_to_canonical(g_absence_calc.abs_ptd_start_date);
702: ELSE
703: l_inputs(i).value:= fnd_date.date_to_canonical(p_asg.action_start_date);
704: END IF;
705: --

Line 703: l_inputs(i).value:= fnd_date.date_to_canonical(p_asg.action_start_date);

699: -- condition added for CPAM payment process
700: IF g_absence_calc.initiator = 'CPAM' THEN
701: l_inputs(i).value:= fnd_date.date_to_canonical(g_absence_calc.abs_ptd_start_date);
702: ELSE
703: l_inputs(i).value:= fnd_date.date_to_canonical(p_asg.action_start_date);
704: END IF;
705: --
706: ELSIF l_inputs(i).name = 'ASG_ACTION_END_DATE' THEN
707: -- condition added for CPAM payment process

Line 709: l_inputs(i).value:= fnd_date.date_to_canonical(g_absence_calc.abs_ptd_end_date);

705: --
706: ELSIF l_inputs(i).name = 'ASG_ACTION_END_DATE' THEN
707: -- condition added for CPAM payment process
708: IF g_absence_calc.initiator = 'CPAM' THEN
709: l_inputs(i).value:= fnd_date.date_to_canonical(g_absence_calc.abs_ptd_end_date);
710: ELSE
711: l_inputs(i).value:= fnd_date.date_to_canonical(p_asg.action_end_date);
712: END IF;
713: --

Line 711: l_inputs(i).value:= fnd_date.date_to_canonical(p_asg.action_end_date);

707: -- condition added for CPAM payment process
708: IF g_absence_calc.initiator = 'CPAM' THEN
709: l_inputs(i).value:= fnd_date.date_to_canonical(g_absence_calc.abs_ptd_end_date);
710: ELSE
711: l_inputs(i).value:= fnd_date.date_to_canonical(p_asg.action_end_date);
712: END IF;
713: --
714: ELSIF l_inputs(i).name = 'REFERENCE_SALARY' THEN
715: l_inputs(i).value:= p_asg.ded_ref_salary;

Line 719: l_inputs(i).value:= fnd_date.date_to_canonical(p_absence_arch.date_earned);

715: l_inputs(i).value:= p_asg.ded_ref_salary;
716: ELSIF l_inputs(i).name = 'ASSIGNMENT_ID' THEN
717: l_inputs(i).value:= p_asg.assignment_id;
718: ELSIF l_inputs(i).name = 'DATE_EARNED' THEN
719: l_inputs(i).value:= fnd_date.date_to_canonical(p_absence_arch.date_earned);
720: ELSIF l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' THEN
721: l_inputs(i).value:= p_asg.assignment_action_id;
722: ELSIF l_inputs(i).name = 'BUSINESS_GROUP_ID' THEN
723: l_inputs(i).value:= p_asg.business_group_id;

Line 847: nvl(fnd_date.canonical_to_date(pabs.abs_information7),hr_general.end_of_time) elig_dt

843: -- cursor for finding absence details
844: Cursor csr_abs_detail(c_absence_id NUMBER) IS
845: SELECT pabs.date_start abs_start_date,
846: pabs.abs_information8 ijss_cal,
847: nvl(fnd_date.canonical_to_date(pabs.abs_information7),hr_general.end_of_time) elig_dt
848: FROM per_absence_attendances pabs
849: WHERE pabs.absence_attendance_id = c_absence_id
850: AND pabs.business_group_id = p_business_group_id
851: AND pabs.abs_information_category ='FR_S';

Line 2118: Select min(fnd_date.canonical_to_date(prrv_pst.result_value)) Pmt_start_dt,

2114:
2115: -- Cursor for getting CPAM element run results
2116: Cursor csr_get_CPAM_results(c_abs_start_date DATE,
2117: c_abs_end_date DATE) is
2118: Select min(fnd_date.canonical_to_date(prrv_pst.result_value)) Pmt_start_dt,
2119: max(fnd_date.canonical_to_date(prrv_pet.result_value)) Pmt_end_dt,
2120: piv_pst.input_value_id pmt_start_input_id,
2121: piv_pet.input_value_id pmt_end_input_id
2122: --

Line 2119: max(fnd_date.canonical_to_date(prrv_pet.result_value)) Pmt_end_dt,

2115: -- Cursor for getting CPAM element run results
2116: Cursor csr_get_CPAM_results(c_abs_start_date DATE,
2117: c_abs_end_date DATE) is
2118: Select min(fnd_date.canonical_to_date(prrv_pst.result_value)) Pmt_start_dt,
2119: max(fnd_date.canonical_to_date(prrv_pet.result_value)) Pmt_end_dt,
2120: piv_pst.input_value_id pmt_start_input_id,
2121: piv_pet.input_value_id pmt_end_input_id
2122: --
2123: From pay_run_result_values prrv_pst,

Line 2133: Where prrv_pst.result_value between fnd_date.date_to_canonical(c_abs_start_date) and fnd_date.date_to_canonical(c_abs_end_date)

2129: pay_element_types_f peltf,
2130: pay_assignment_actions pact,
2131: pay_payroll_actions ppac
2132: --
2133: Where prrv_pst.result_value between fnd_date.date_to_canonical(c_abs_start_date) and fnd_date.date_to_canonical(c_abs_end_date)
2134: and prrv_pet.result_value between fnd_date.date_to_canonical(c_abs_start_date) and fnd_date.date_to_canonical(c_abs_end_date)
2135: --
2136: and prrv_pst.input_value_id = piv_pst.input_value_id
2137: and prrv_pst.run_result_id = prr_pst.run_result_id

Line 2134: and prrv_pet.result_value between fnd_date.date_to_canonical(c_abs_start_date) and fnd_date.date_to_canonical(c_abs_end_date)

2130: pay_assignment_actions pact,
2131: pay_payroll_actions ppac
2132: --
2133: Where prrv_pst.result_value between fnd_date.date_to_canonical(c_abs_start_date) and fnd_date.date_to_canonical(c_abs_end_date)
2134: and prrv_pet.result_value between fnd_date.date_to_canonical(c_abs_start_date) and fnd_date.date_to_canonical(c_abs_end_date)
2135: --
2136: and prrv_pst.input_value_id = piv_pst.input_value_id
2137: and prrv_pst.run_result_id = prr_pst.run_result_id
2138: --

Line 2194: and peval_pst.screen_entry_value > fnd_date.date_to_canonical(c_prev_pmt_end_dt)

2190: and peval_pst.element_entry_id = pentf.element_entry_id
2191: and peval_pst.input_value_id = c_pst_input_value_id
2192: and peval_pet.element_entry_id = pentf.element_entry_id
2193: and peval_pet.input_value_id = c_pet_input_value_id
2194: and peval_pst.screen_entry_value > fnd_date.date_to_canonical(c_prev_pmt_end_dt)
2195: and peval_pet.screen_entry_value <= fnd_date.date_to_canonical(c_abs_end_date)
2196: and p_asg.action_end_date between peval_pst.effective_start_date and peval_pst.effective_end_date
2197: and p_asg.action_end_date between peval_pet.effective_start_date and peval_pet.effective_end_date;
2198: --

Line 2195: and peval_pet.screen_entry_value <= fnd_date.date_to_canonical(c_abs_end_date)

2191: and peval_pst.input_value_id = c_pst_input_value_id
2192: and peval_pet.element_entry_id = pentf.element_entry_id
2193: and peval_pet.input_value_id = c_pet_input_value_id
2194: and peval_pst.screen_entry_value > fnd_date.date_to_canonical(c_prev_pmt_end_dt)
2195: and peval_pet.screen_entry_value <= fnd_date.date_to_canonical(c_abs_end_date)
2196: and p_asg.action_end_date between peval_pst.effective_start_date and peval_pst.effective_end_date
2197: and p_asg.action_end_date between peval_pet.effective_start_date and peval_pet.effective_end_date;
2198: --
2199: l_entry_rec csr_get_sickness_entries%RowType;

Line 2257: IF fnd_date.canonical_to_date(cpam_entry_rec.pmt_start_date) = l_prev_pmt_end_dt +1

2253: l_pmt_end_id,
2254: l_prev_pmt_end_dt,
2255: l_entry_rec.Abs_end_date) LOOP
2256: --
2257: IF fnd_date.canonical_to_date(cpam_entry_rec.pmt_start_date) = l_prev_pmt_end_dt +1
2258: OR fnd_date.canonical_to_date(cpam_entry_rec.pmt_start_date) = l_entry_rec.Abs_start_date THEN
2259: --
2260: IF fnd_date.canonical_to_date(cpam_entry_rec.pmt_end_date) = l_entry_rec.Abs_end_date THEN
2261: EXIT;

Line 2258: OR fnd_date.canonical_to_date(cpam_entry_rec.pmt_start_date) = l_entry_rec.Abs_start_date THEN

2254: l_prev_pmt_end_dt,
2255: l_entry_rec.Abs_end_date) LOOP
2256: --
2257: IF fnd_date.canonical_to_date(cpam_entry_rec.pmt_start_date) = l_prev_pmt_end_dt +1
2258: OR fnd_date.canonical_to_date(cpam_entry_rec.pmt_start_date) = l_entry_rec.Abs_start_date THEN
2259: --
2260: IF fnd_date.canonical_to_date(cpam_entry_rec.pmt_end_date) = l_entry_rec.Abs_end_date THEN
2261: EXIT;
2262: END IF;

Line 2260: IF fnd_date.canonical_to_date(cpam_entry_rec.pmt_end_date) = l_entry_rec.Abs_end_date THEN

2256: --
2257: IF fnd_date.canonical_to_date(cpam_entry_rec.pmt_start_date) = l_prev_pmt_end_dt +1
2258: OR fnd_date.canonical_to_date(cpam_entry_rec.pmt_start_date) = l_entry_rec.Abs_start_date THEN
2259: --
2260: IF fnd_date.canonical_to_date(cpam_entry_rec.pmt_end_date) = l_entry_rec.Abs_end_date THEN
2261: EXIT;
2262: END IF;
2263: l_prev_pmt_end_dt := fnd_date.canonical_to_date(cpam_entry_rec.pmt_end_date);
2264: ELSE

Line 2263: l_prev_pmt_end_dt := fnd_date.canonical_to_date(cpam_entry_rec.pmt_end_date);

2259: --
2260: IF fnd_date.canonical_to_date(cpam_entry_rec.pmt_end_date) = l_entry_rec.Abs_end_date THEN
2261: EXIT;
2262: END IF;
2263: l_prev_pmt_end_dt := fnd_date.canonical_to_date(cpam_entry_rec.pmt_end_date);
2264: ELSE
2265: fnd_message.set_name('PAY', 'PAY_75043_SICK_NOT_PROCESSED');
2266: fnd_message.set_token('START_DATE',to_char(l_entry_rec.Abs_start_date,'DD/MM/YYYY'));
2267: fnd_message.set_token('END_DATE',to_char(l_entry_rec.Abs_end_date,'DD/MM/YYYY'));

Line 2675: fnd_date.canonical_to_date(target.result_value),

2671: fnd_number.canonical_to_number(target.result_value),
2672: 0)),0) previous_IJSS_gross,
2673: max(decode(target.input_value_id,
2674: g_gi_info_end_date_iv_id,
2675: fnd_date.canonical_to_date(target.result_value),
2676: g_gi_i_r_end_date_iv_id,
2677: fnd_date.canonical_to_date(target.result_value),
2678: null)) payment_end_date,
2679: max(decode(target.input_value_id,

Line 2677: fnd_date.canonical_to_date(target.result_value),

2673: max(decode(target.input_value_id,
2674: g_gi_info_end_date_iv_id,
2675: fnd_date.canonical_to_date(target.result_value),
2676: g_gi_i_r_end_date_iv_id,
2677: fnd_date.canonical_to_date(target.result_value),
2678: null)) payment_end_date,
2679: max(decode(target.input_value_id,
2680: g_gi_info_best_method_iv_id,target.result_value,
2681: g_gi_i_r_best_method_iv_id, target.result_value,null)) best_method,

Line 2802: l_date_from_chr varchar2(20) := fnd_date.date_to_canonical(p_date_from);

2798: IS
2799:
2800: l_proc varchar2(72) := g_package||'Band_Overlaps';
2801: l_ov_gi_id_chr varchar2(100) := to_char(p_ov_gi_id);
2802: l_date_from_chr varchar2(20) := fnd_date.date_to_canonical(p_date_from);
2803:
2804: l_overlap_band1_days number := 0;
2805: l_overlap_band2_days number := 0;
2806: l_overlap_band3_days number := 0;

Line 2832: fnd_date.canonical_to_date(rrv_end.result_value) payment_end_date

2828: --
2829: BEGIN
2830: hr_utility.set_location('Entering:'|| l_proc,10);
2831: select /*+ORDERED*/
2832: fnd_date.canonical_to_date(rrv_end.result_value) payment_end_date
2833: ,nvl(sum(decode(target.input_value_id,
2834: g_gi_info_band1_iv_id,target.result_value,
2835: g_gi_i_r_band1_iv_id, target.result_value,0)),0)
2836: ,nvl(sum(decode(target.input_value_id,

Line 2887: group by fnd_date.canonical_to_date(rrv_end.result_value);

2883: g_gi_i_r_band2_iv_id,
2884: g_gi_i_r_band3_iv_id,
2885: g_gi_i_r_band4_iv_id)
2886: and target.result_value is not null
2887: group by fnd_date.canonical_to_date(rrv_end.result_value);
2888:
2889: p_ov_band1_days := p_ov_band1_days - l_overlap_band1_days;
2890: p_ov_band2_days := p_ov_band2_days - l_overlap_band2_days;
2891: p_ov_band3_days := p_ov_band3_days - l_overlap_band3_days;

Line 3062: fnd_date.date_to_canonical(l_date_from),

3058: set_global_ids(p_effective_date => l_date_to);
3059: end if;
3060: -- Now get the Band usage over the period
3061: open csr_get_band_usage(fnd_number.number_to_canonical(p_gi_id),
3062: fnd_date.date_to_canonical(l_date_from),
3063: fnd_date.date_to_canonical(l_date_to));
3064: fetch csr_get_band_usage into
3065: l_total_band1_days
3066: ,l_total_band2_days

Line 3063: fnd_date.date_to_canonical(l_date_to));

3059: end if;
3060: -- Now get the Band usage over the period
3061: open csr_get_band_usage(fnd_number.number_to_canonical(p_gi_id),
3062: fnd_date.date_to_canonical(l_date_from),
3063: fnd_date.date_to_canonical(l_date_to));
3064: fetch csr_get_band_usage into
3065: l_total_band1_days
3066: ,l_total_band2_days
3067: ,l_total_band3_days