[Home] [Help]
133: -- setting the contexts
134: p_inputs(1).name := 'ASSIGNMENT_ID';
135: p_inputs(1).value := p_assignment_id;
136: p_inputs(2).name := 'DATE_EARNED';
137: p_inputs(2).value := fnd_date.date_to_canonical(p_effective_date);
138: p_inputs(3).name := 'BUSINESS_GROUP_ID';
139: p_inputs(3).value := p_business_group_id;
140: p_inputs(4).name := 'PAYROLL_ID';
141: p_inputs(4).value := p_payroll_id;
154: CLOSE c_action_ids;
155: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
156: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
157: hr_utility.trace(' p_assignment_id '||p_assignment_id);
158: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
159: hr_utility.trace(' p_payroll_id '||p_payroll_id);
160:
161: -- 6666135 Begin
162: FOR I in 1..Formula_Tab.COUNT
499: WHEN others THEN
500: hr_utility.trace('SESSION ALREADY EXISTS :'|| sqlerrm);
501: Raise;
502: END;
503: v_eff_start_date := fnd_date.canonical_to_date(p_effective_start_dt);
504: --calculation of pension end date for the year
505: N_start_year := TO_NUMBER(TO_CHAR(v_eff_start_date,'YYYY'));
506: IF trunc(v_eff_start_date) > TO_DATE('31-03-'||N_start_year,'DD-MM-YYYY')
507: THEN
510: v_eff_end_date := TO_DATE('31-03-'||N_start_year,'DD-MM-YYYY');
511: v_given_end_date := v_eff_end_date;
512: IF p_effective_end_dt IS not NULL --to date entered by the user.
513: THEN
514: v_given_end_date := fnd_date.canonical_to_date(p_effective_end_dt);
515: --To check the given dates falls in the same pension year
516: IF ((v_eff_start_date BETWEEN to_date('01/04/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')
517: AND to_date('31/12/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy'))
518: AND (v_eff_end_date BETWEEN to_date('01/04/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')