DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_BE2 dependencies on FND_NUMBER

Line 179: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);

175: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
176: l_text:=l_text||'';
177: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
178: l_text:='';
179: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
180: l_text:=l_text||'
';
181: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
182: l_text:='';
183: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

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

179: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
180: l_text:=l_text||'';
181: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
182: l_text:='';
183: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
184: l_text:=l_text||'
';
185: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
186: l_text:='';
187: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);

Line 187: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);

183: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
184: l_text:=l_text||'';
185: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
186: l_text:='';
187: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
188: l_text:=l_text||'
';
189: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
190: l_text:='';
191: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_number);

Line 199: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);

195: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);
196: l_text:=l_text||'';
197: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
198: l_text:='';
199: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
200: l_text:=l_text||'
';
201: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
202: l_text:='';
203: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);

Line 211: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);

207: l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);
208: l_text:=l_text||'';
209: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
210: l_text:='';
211: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
212: l_text:=l_text||'
';
213: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
214: l_text:='';
215: l_text:=l_text||irc_utilities_pkg.removeTags(p_frequency);

Line 227: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);

223: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
224: l_text:=l_text||'';
225: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
226: l_text:='';
227: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
228: l_text:=l_text||'
';
229: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
230: l_text:='';
231: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);

Line 231: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);

227: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
228: l_text:=l_text||'';
229: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
230: l_text:='';
231: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
232: l_text:=l_text||'
';
233: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
234: l_text:='';
235: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);

Line 239: l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);

235: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
236: l_text:=l_text||'';
237: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
238: l_text:='';
239: l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);
240: l_text:=l_text||'
';
241: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
242: l_text:='';
243: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);

Line 251: l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);

247: l_text:=l_text||irc_utilities_pkg.removeTags(p_projected_assignment_end);
248: l_text:=l_text||'';
249: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
250: l_text:='';
251: l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);
252: l_text:=l_text||'
';
253: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
254: l_text:='';
255: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);

Line 259: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);

255: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
256: l_text:=l_text||'';
257: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
258: l_text:='';
259: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
260: l_text:=l_text||'
';
261: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
262: l_text:='';
263: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);

Line 539: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);

535: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);
536: l_text:=l_text||'';
537: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
538: l_text:='';
539: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
540: l_text:=l_text||'
';
541: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
542: l_text:='';
543: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);

Line 543: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);

539: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
540: l_text:=l_text||'';
541: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
542: l_text:='';
543: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
544: l_text:=l_text||'
';
545: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
546: l_text:='';
547: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);

Line 583: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);

579: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
580: l_text:=l_text||'';
581: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
582: l_text:='';
583: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
584: l_text:=l_text||'
';
585: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
586: l_text:='';
587: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);

Line 587: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);

583: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
584: l_text:=l_text||'';
585: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
586: l_text:='';
587: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
588: l_text:=l_text||'
';
589: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
590: l_text:='';
591: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);

Line 591: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);

587: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
588: l_text:=l_text||'';
589: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
590: l_text:='';
591: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
592: l_text:=l_text||'
';
593: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
594: l_text:='';
595: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);

Line 595: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);

591: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
592: l_text:=l_text||'';
593: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
594: l_text:='';
595: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
596: l_text:=l_text||'
';
597: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
598: l_text:='';
599: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);

Line 679: l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);

675: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);
676: l_text:=l_text||'';
677: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
678: l_text:='';
679: l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);
680: l_text:=l_text||'
';
681: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
682: l_text:='';
683: l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);

Line 699: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);

695: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);
696: l_text:=l_text||'';
697: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
698: l_text:='';
699: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);
700: l_text:=l_text||'
';
701: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
702: l_text:='';
703: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);

Line 707: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);

703: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);
704: l_text:=l_text||'';
705: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
706: l_text:='';
707: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
708: l_text:=l_text||'
';
709: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
710: l_text:='';
711: --