DBA Data[Home] [Help]

APPS.HR_PREVIOUS_EMPLOYMENT_BE2 dependencies on FND_NUMBER

Line 120: l_text:=l_text||fnd_number.number_to_canonical(p_previous_employer_id);

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);
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);

Line 132: l_text:=l_text||fnd_number.number_to_canonical(p_period_years);

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);
133: l_text:=l_text||'
';
134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135: l_text:='';
136: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);

Line 136: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);

132: l_text:=l_text||fnd_number.number_to_canonical(p_period_years);
133: l_text:=l_text||'';
134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135: l_text:='';
136: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);
137: l_text:=l_text||'
';
138: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
139: l_text:='';
140: l_text:=l_text||fnd_number.number_to_canonical(p_period_days);

Line 140: l_text:=l_text||fnd_number.number_to_canonical(p_period_days);

136: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);
137: l_text:=l_text||'';
138: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
139: l_text:='';
140: l_text:=l_text||fnd_number.number_to_canonical(p_period_days);
141: l_text:=l_text||'
';
142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143: l_text:='';
144: l_text:=l_text||irc_utilities_pkg.removeTags(p_employer_name);

Line 420: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

416: l_text:=l_text||irc_utilities_pkg.removeTags(p_pem_information30);
417: l_text:=l_text||'';
418: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
419: l_text:='';
420: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
421: l_text:=l_text||'
';
422: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
423: l_text:='';
424: --