APPS.PER_ZA_ABS_DURATION dependencies on FND_DATE

Line 49: l_hol_date := fnd_date.CANONICAL_TO_DATE(rec_hol_dt.value);

45: -- close c1;
46: for rec_hol_dt in c1
47: loop
48: begin
49: l_hol_date := fnd_date.CANONICAL_TO_DATE(rec_hol_dt.value);
50: if l_hol_date >= p_DateFrom and l_hol_date <= p_DateTo -- holiday falls within period
51: and l_hol_date >= rec_hol_dt.effective_start_date
52: and l_hol_date <= rec_hol_dt.effective_end_date then
53: v_index := v_index + 1;

Line 93: l_format := FND_DATE.canonical_DT_mask;

89: function get_canonical_Dt_format
90: return varchar2 is
91: l_format varchar2(100);
92: begin
93: l_format := FND_DATE.canonical_DT_mask;
94:
95: return l_format;
96: end get_canonical_Dt_format;
97:

Line 111: l_date := fnd_date.canonical_to_date(p_date);

107: l_year_dlmt number(2);
108: l_month_dlmt number(2);
109: l_date_dlmt number(2);
110: begin
111: l_date := fnd_date.canonical_to_date(p_date);
112: l_space := instr(p_date,' ',1,1);
113: if l_space<>0 then
114: l_datewo_time:=substr(p_date,1,l_space-1);
115: else