APPS.HR_PERSON_ADDRESS_BE1 dependencies on FND_DATE

Line 93: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);

89: l_text:='';
90: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
91: --
92: l_text:='';
93: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
94: l_text:=l_text||'';
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: l_text:='';
97: if(P_PRADD_OVLAPVAL_OVERRIDE) then

Line 125: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);

121: l_text:=l_text||irc_utilities_pkg.removeTags(p_style);
122: l_text:=l_text||' .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; } ';
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: l_text:='';
125: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);

Line 129: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);

125: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||irc_utilities_pkg.removeTags(p_address_type);