APPS.PQP_ABSVAL_PKG dependencies on FND_DATE

Line 95: pqp_utilities.debug(fnd_date.date_to_canonical(p_trace_date));

91: PROCEDURE debug
92: (p_trace_date IN DATE )
93: IS
94: BEGIN
95: pqp_utilities.debug(fnd_date.date_to_canonical(p_trace_date));
96: END debug;
97: --
98: --
99: --

Line 182: fnd_date.canonical_to_date(p_fixed_year_start_date);

178: l_scheme_start_date DATE;
179:
180: -- variable to be removed once we change p_fixed_year_start_date to DATE
181: l_fixed_year_start_date DATE:=
182: fnd_date.canonical_to_date(p_fixed_year_start_date);
183:
184: l_scheme_period_duration NUMBER(10):=
185: fnd_number.canonical_to_number(p_scheme_period_duration);
186:

Line 280: --l_start_date := fnd_date.canonical_to_date( l_temp );

276: l_scheme_start_date:=
277: add_months(l_fixed_year_start_date,floor(MONTHS_BETWEEN
278: (p_balance_effective_date,l_fixed_year_start_date)/12)*12);
279:
280: --l_start_date := fnd_date.canonical_to_date( l_temp );
281:
282: -- if the effective date was 05-FEB-2002
283: -- and the scheme start is 01-APR-YYYY
284: -- then the prev statement would set the scheme start date as

Line 2487: fnd_date.date_to_canonical(l_adjusted_scheme_start_date));

2483: END IF;
2484: CLOSE csr_adjusted_scheme_start_date;
2485: IF g_debug THEN
2486: debug('l_adjusted_scheme_start_date:'||
2487: fnd_date.date_to_canonical(l_adjusted_scheme_start_date));
2488: debug_exit(l_proc_name);
2489: END IF;
2490: RETURN l_adjusted_scheme_start_date;
2491:

Line 2616: fnd_date.date_to_canonical(p_override_scheme_start_date));

2612: debug(p_scheme_period_duration);
2613: debug(p_scheme_period_uom);
2614: debug(p_scheme_period_start);
2615: debug('p_override_scheme_start_date:'||
2616: fnd_date.date_to_canonical(p_override_scheme_start_date));
2617: debug('p_override_scheme_start_date'||p_override_scheme_start_date);
2618: debug('p_plan_types_to_extend_period'||p_plan_types_to_extend_period);
2619: debug('p_entitlement_uom'||p_entitlement_uom);
2620: debug('p_default_wp'||p_default_wp);

Line 2824: fnd_date.date_to_canonical(l_adjusted_scheme_start_date));

2820: END IF; -- IF p_scheme_period_type = 'DUALROLLING' THEN
2821:
2822:
2823: debug('l_adjusted_scheme_start_date:'||
2824: fnd_date.date_to_canonical(l_adjusted_scheme_start_date));
2825:
2826: l_proc_step := 60;
2827: IF g_debug THEN
2828: debug(l_proc_name, 60);

Line 5635: l_override_scheme_start_date := fnd_date.canonical_to_date(l_value);

5631: --,p_error_code => l_error_code
5632: --,p_message => l_error_message
5633: );
5634:
5635: l_override_scheme_start_date := fnd_date.canonical_to_date(l_value);
5636: debug('l_override_scheme_start_date:'||
5637: fnd_date.date_to_canonical(l_override_scheme_start_date));
5638:
5639: EXCEPTION

Line 5637: fnd_date.date_to_canonical(l_override_scheme_start_date));

5633: );
5634:
5635: l_override_scheme_start_date := fnd_date.canonical_to_date(l_value);
5636: debug('l_override_scheme_start_date:'||
5637: fnd_date.date_to_canonical(l_override_scheme_start_date));
5638:
5639: EXCEPTION
5640: WHEN VALUE_ERROR
5641: OR invalid_length_of_service