[Home] [Help]
107: -- setting the contexts
108: p_inputs(1).name := 'ASSIGNMENT_ID';
109: p_inputs(1).value := p_assignment_id;
110: p_inputs(2).name := 'DATE_EARNED';
111: p_inputs(2).value := fnd_date.date_to_canonical(p_effective_date);
112: p_inputs(3).name := 'BUSINESS_GROUP_ID';
113: p_inputs(3).value := p_business_group_id;
114: p_inputs(4).name := 'PAYROLL_ID';
115: p_inputs(4).value := p_payroll_id;
125: CLOSE c_action_ids;
126: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
127: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
128: hr_utility.trace(' p_assignment_id '||p_assignment_id);
129: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
130: hr_utility.trace(' p_payroll_id '||p_payroll_id);
131:
132: -- 6666135 Begin
133: FOR I in 1..Formula_Tab.COUNT
440: WHEN others THEN
441: hr_utility.trace('SESSION ALREADY EXISTS :'|| sqlerrm);
442: Raise;
443: END;
444: v_eff_start_date := fnd_date.canonical_to_date(p_effective_start_dt);
445: --calculation of pension end date for the year
446: N_start_year := TO_NUMBER(TO_CHAR(v_eff_start_date,'YYYY'));
447: IF trunc(v_eff_start_date) > TO_DATE('31-03-'||N_start_year,'DD-MM-YYYY')
448: THEN
451: v_eff_end_date := TO_DATE('31-03-'||N_start_year,'DD-MM-YYYY');
452: v_given_end_date := v_eff_end_date;
453: IF p_effective_end_dt IS not NULL --to date entered by the user.
454: THEN
455: v_given_end_date := fnd_date.canonical_to_date(p_effective_end_dt);
456: --To check the given dates falls in the same pension year
457: IF ((v_eff_start_date BETWEEN to_date('01/04/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')
458: AND to_date('31/12/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy'))
459: AND (v_eff_end_date BETWEEN to_date('01/04/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')