DBA Data[Home] [Help]

APPS.HR_EX_EMPLOYEE_BE1 dependencies on FND_DATE

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

105: l_text:='';
106: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
107: --
108: l_text:='';
109: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
110: l_text:=l_text||'
';
111: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
112: l_text:='';
113: l_text:=l_text||fnd_number.number_to_canonical(p_period_of_service_id);

Line 121: l_text:=l_text||fnd_date.date_to_canonical(p_actual_termination_date);

117: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
118: l_text:=l_text||'';
119: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
120: l_text:='';
121: l_text:=l_text||fnd_date.date_to_canonical(p_actual_termination_date);
122: l_text:=l_text||'
';
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_last_standard_process_date);

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

121: l_text:=l_text||fnd_date.date_to_canonical(p_actual_termination_date);
122: l_text:=l_text||'';
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_last_standard_process_date);
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_number.number_to_canonical(p_person_type_id);

Line 345: l_text:=l_text||fnd_date.date_to_canonical(p_last_std_process_date_out);

341: l_text:=l_text||irc_utilities_pkg.removeTags(p_pds_information30);
342: l_text:=l_text||'';
343: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
344: l_text:='';
345: l_text:=l_text||fnd_date.date_to_canonical(p_last_std_process_date_out);
346: l_text:=l_text||'
';
347: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
348: l_text:='';
349: if(P_SUPERVISOR_WARNING) then