DBA Data[Home] [Help]

APPS.HR_PREVIOUS_EMPLOYMENT_BE4 dependencies on FND_NUMBER

Line 118: l_text:=l_text||fnd_number.number_to_canonical(p_previous_job_id);

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);
119: l_text:=l_text||'
';
120: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
121: l_text:='';
122: l_text:=l_text||fnd_number.number_to_canonical(p_previous_employer_id);

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

118: l_text:=l_text||fnd_number.number_to_canonical(p_previous_job_id);
119: l_text:=l_text||'';
120: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
121: l_text:='';
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);

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

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

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

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

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

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

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

406: l_text:=l_text||irc_utilities_pkg.removeTags(p_pjo_information30);
407: l_text:=l_text||'';
408: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
409: l_text:='';
410: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
411: l_text:=l_text||'
';
412: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
413: l_text:='';
414: --