APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on FND_DATE

Line 122: p_inputs(2).value := fnd_date.date_to_canonical(p_effective_date);

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;

Line 140: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));

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

Line 463: v_eff_start_date := fnd_date.canonical_to_date(p_effective_start_dt);

459: WHEN others THEN
460: hr_utility.trace('SESSION ALREADY EXISTS :'|| sqlerrm);
461: Raise;
462: END;
463: v_eff_start_date := fnd_date.canonical_to_date(p_effective_start_dt);
464: --calculation of pension end date for the year
465: N_start_year := TO_NUMBER(TO_CHAR(v_eff_start_date,'YYYY'));
466: IF trunc(v_eff_start_date) > TO_DATE('31-03-'||N_start_year,'DD-MM-YYYY')
467: THEN

Line 474: v_given_end_date := fnd_date.canonical_to_date(p_effective_end_dt);

470: v_eff_end_date := TO_DATE('31-03-'||N_start_year,'DD-MM-YYYY');
471: v_given_end_date := v_eff_end_date;
472: IF p_effective_end_dt IS not NULL --to date entered by the user.
473: THEN
474: v_given_end_date := fnd_date.canonical_to_date(p_effective_end_dt);
475: --To check the given dates falls in the same pension year
476: IF ((v_eff_start_date BETWEEN to_date('01/04/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')
477: AND to_date('31/12/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy'))
478: AND (v_eff_end_date BETWEEN to_date('01/04/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')