DBA Data[Home] [Help]

APPS.HR_PREVIOUS_EMPLOYMENT_BE1 dependencies on FND_DATE

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

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

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

135: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);
136: l_text:=l_text||'';
137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138: l_text:='';
139: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
140: l_text:=l_text||'
';
141: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
142: l_text:='';
143: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);

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

139: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
140: l_text:=l_text||'';
141: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
142: l_text:='';
143: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);
144: l_text:=l_text||'
';
145: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
146: l_text:='';
147: l_text:=l_text||fnd_number.number_to_canonical(p_period_years);