APPS.PQP_GB_GAP_BEN_FORMULAS dependencies on FND_DATE

Line 53: debug(fnd_date.date_to_canonical(p_trace_date));

49: PROCEDURE debug
50: (p_trace_date IN DATE )
51: IS
52: BEGIN
53: debug(fnd_date.date_to_canonical(p_trace_date));
54: END debug;
55: --
56: --
57: --

Line 134: l_effective_start_date DATE:= fnd_date.canonical_to_date('1951/01/01 00:00:00');

130: l_formula_type_id ff_formula_types.formula_type_id%TYPE;
131:
132: -- this date is passed as effective start date for LER formulas only.
133: -- In the remaining formulas p_effective_date is passed
134: l_effective_start_date DATE:= fnd_date.canonical_to_date('1951/01/01 00:00:00');
135: --p_effective_date;
136: l_effective_end_date DATE:=
137: fnd_date.canonical_to_date('4712/12/31 00:00:00');
138:

Line 137: fnd_date.canonical_to_date('4712/12/31 00:00:00');

133: -- In the remaining formulas p_effective_date is passed
134: l_effective_start_date DATE:= fnd_date.canonical_to_date('1951/01/01 00:00:00');
135: --p_effective_date;
136: l_effective_end_date DATE:=
137: fnd_date.canonical_to_date('4712/12/31 00:00:00');
138:
139: l_text VARCHAR2(32767);
140:
141: l_business_group_name hr_all_organization_units.name%TYPE;--VARCHAR2(240)