[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
445: WHEN others THEN
446: hr_utility.trace('SESSION ALREADY EXISTS :'|| sqlerrm);
447: Raise;
448: END;
449: v_eff_start_date := fnd_date.canonical_to_date(p_effective_start_dt);
450: --calculation of pension end date for the year
451: N_start_year := TO_NUMBER(TO_CHAR(v_eff_start_date,'YYYY'));
452: IF trunc(v_eff_start_date) > TO_DATE('31-03-'||N_start_year,'DD-MM-YYYY')
453: THEN
456: v_eff_end_date := TO_DATE('31-03-'||N_start_year,'DD-MM-YYYY');
457: v_given_end_date := v_eff_end_date;
458: IF p_effective_end_dt IS not NULL --to date entered by the user.
459: THEN
460: v_given_end_date := fnd_date.canonical_to_date(p_effective_end_dt);
461: --To check the given dates falls in the same pension year
462: IF ((v_eff_start_date BETWEEN to_date('01/04/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')
463: AND to_date('31/12/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy'))
464: AND (v_eff_end_date BETWEEN to_date('01/04/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')