DBA Data[Home] [Help]

APPS.HR_PREVIOUS_EMPLOYMENT_BE2 dependencies on FND_DATE

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

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

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

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

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

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