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 2508: fnd_date.date_to_canonical(l_adjusted_scheme_start_date));

2504: END IF;
2505: CLOSE csr_adjusted_scheme_start_date;
2506: IF g_debug THEN
2507: debug('l_adjusted_scheme_start_date:'||
2508: fnd_date.date_to_canonical(l_adjusted_scheme_start_date));
2509: debug_exit(l_proc_name);
2510: END IF;
2511: RETURN l_adjusted_scheme_start_date;
2512:

Line 2637: fnd_date.date_to_canonical(p_override_scheme_start_date));

2633: debug(p_scheme_period_duration);
2634: debug(p_scheme_period_uom);
2635: debug(p_scheme_period_start);
2636: debug('p_override_scheme_start_date:'||
2637: fnd_date.date_to_canonical(p_override_scheme_start_date));
2638: debug('p_override_scheme_start_date'||p_override_scheme_start_date);
2639: debug('p_plan_types_to_extend_period'||p_plan_types_to_extend_period);
2640: debug('p_entitlement_uom'||p_entitlement_uom);
2641: debug('p_default_wp'||p_default_wp);

Line 2845: fnd_date.date_to_canonical(l_adjusted_scheme_start_date));

2841: END IF; -- IF p_scheme_period_type = 'DUALROLLING' THEN
2842:
2843:
2844: debug('l_adjusted_scheme_start_date:'||
2845: fnd_date.date_to_canonical(l_adjusted_scheme_start_date));
2846:
2847: l_proc_step := 60;
2848: IF g_debug THEN
2849: debug(l_proc_name, 60);

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

5659: --,p_error_code => l_error_code
5660: --,p_message => l_error_message
5661: );
5662:
5663: l_override_scheme_start_date := fnd_date.canonical_to_date(l_value);
5664: debug('l_override_scheme_start_date:'||
5665: fnd_date.date_to_canonical(l_override_scheme_start_date));
5666:
5667: EXCEPTION

Line 5665: fnd_date.date_to_canonical(l_override_scheme_start_date));

5661: );
5662:
5663: l_override_scheme_start_date := fnd_date.canonical_to_date(l_value);
5664: debug('l_override_scheme_start_date:'||
5665: fnd_date.date_to_canonical(l_override_scheme_start_date));
5666:
5667: EXCEPTION
5668: WHEN VALUE_ERROR
5669: OR invalid_length_of_service