[Home] [Help]
118: -- setting the contexts
119: p_inputs(1).name := 'ASSIGNMENT_ID';
120: p_inputs(1).value := p_assignment_id;
121: p_inputs(2).name := 'DATE_EARNED';
122: p_inputs(2).value := fnd_date.date_to_canonical(p_effective_date);
123: p_inputs(3).name := 'BUSINESS_GROUP_ID';
124: p_inputs(3).value := p_business_group_id;
125: p_inputs(4).name := 'PAYROLL_ID';
126: p_inputs(4).value := p_payroll_id;
136: CLOSE c_action_ids;
137: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
138: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
139: hr_utility.trace(' p_assignment_id '||p_assignment_id);
140: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
141: hr_utility.trace(' p_payroll_id '||p_payroll_id);
142:
143: -- 6666135 Begin
144: FOR I in 1..Formula_Tab.COUNT
453: WHEN others THEN
454: hr_utility.trace('SESSION ALREADY EXISTS :'|| sqlerrm);
455: Raise;
456: END;
457: v_eff_start_date := fnd_date.canonical_to_date(p_effective_start_dt);
458: --calculation of pension end date for the year
459: N_start_year := TO_NUMBER(TO_CHAR(v_eff_start_date,'YYYY'));
460: IF trunc(v_eff_start_date) > TO_DATE('31-03-'||N_start_year,'DD-MM-YYYY')
461: THEN
464: v_eff_end_date := TO_DATE('31-03-'||N_start_year,'DD-MM-YYYY');
465: v_given_end_date := v_eff_end_date;
466: IF p_effective_end_dt IS not NULL --to date entered by the user.
467: THEN
468: v_given_end_date := fnd_date.canonical_to_date(p_effective_end_dt);
469: --To check the given dates falls in the same pension year
470: IF ((v_eff_start_date BETWEEN to_date('01/04/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')
471: AND to_date('31/12/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy'))
472: AND (v_eff_end_date BETWEEN to_date('01/04/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')