DBA Data[Home] [Help]

APPS.HR_PREVIOUS_EMPLOYMENT_BE4 dependencies on FND_DATE

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

110: l_text:='';
111: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
112: --
113: l_text:='';
114: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
115: l_text:=l_text||'
';
116: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
117: l_text:='';
118: l_text:=l_text||fnd_number.number_to_canonical(p_previous_job_id);

Line 126: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);

122: l_text:=l_text||fnd_number.number_to_canonical(p_previous_employer_id);
123: l_text:=l_text||'';
124: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
125: l_text:='';
126: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
127: l_text:=l_text||'
';
128: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
129: l_text:='';
130: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);

Line 130: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);

126: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
127: l_text:=l_text||'';
128: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
129: l_text:='';
130: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);
131: l_text:=l_text||'
';
132: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
133: l_text:='';
134: l_text:=l_text||fnd_number.number_to_canonical(p_period_years);