DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_BE1 dependencies on FND_NUMBER

Line 217: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

213: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
214: l_text:=l_text||'';
215: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
216: l_text:='';
217: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
218: l_text:=l_text||'
';
219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
220: l_text:='';
221: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);

Line 221: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);

217: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
218: l_text:=l_text||'';
219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
220: l_text:='';
221: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
222: l_text:=l_text||'
';
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
224: l_text:='';
225: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);

Line 225: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);

221: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
222: l_text:=l_text||'';
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
224: l_text:='';
225: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
226: l_text:=l_text||'
';
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='';
229: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);

Line 229: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);

225: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
226: l_text:=l_text||'';
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='';
229: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
230: l_text:=l_text||'
';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='';
233: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);

Line 233: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);

229: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
230: l_text:=l_text||'';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='';
233: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
234: l_text:=l_text||'
';
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='';
237: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);

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

233: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
234: l_text:=l_text||'';
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='';
237: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
238: l_text:=l_text||'
';
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='';
241: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);

Line 241: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);

237: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
238: l_text:=l_text||'';
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='';
241: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);
242: l_text:=l_text||'
';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='';
245: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);

Line 245: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);

241: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='';
245: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
246: l_text:=l_text||'
';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='';
249: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);

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

245: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
246: l_text:=l_text||'';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='';
249: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
250: l_text:=l_text||'
';
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='';
253: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);

Line 253: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);

249: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
250: l_text:=l_text||'';
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='';
253: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
254: l_text:=l_text||'
';
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
256: l_text:='';
257: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);

Line 257: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);

253: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
254: l_text:=l_text||'';
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
256: l_text:='';
257: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
258: l_text:=l_text||'
';
259: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
260: l_text:='';
261: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_number);

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

273: l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);
274: l_text:=l_text||'';
275: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
276: l_text:='';
277: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
278: l_text:=l_text||'
';
279: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
280: l_text:='';
281: l_text:=l_text||irc_utilities_pkg.removeTags(p_employment_category);

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

293: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
294: l_text:=l_text||'';
295: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
296: l_text:='';
297: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
298: l_text:=l_text||'
';
299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
300: l_text:='';
301: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);

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

297: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
298: l_text:=l_text||'';
299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
300: l_text:='';
301: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
302: l_text:=l_text||'
';
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
304: l_text:='';
305: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);

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

305: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
306: l_text:=l_text||'';
307: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
308: l_text:='';
309: l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);
310: l_text:=l_text||'
';
311: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
312: l_text:='';
313: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);

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

313: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);
314: l_text:=l_text||'';
315: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
316: l_text:='';
317: l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);
318: l_text:=l_text||'
';
319: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
320: l_text:='';
321: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);

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

321: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
322: l_text:=l_text||'';
323: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
324: l_text:='';
325: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
326: l_text:=l_text||'
';
327: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
328: l_text:='';
329: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);

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

721: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment30);
722: l_text:=l_text||'';
723: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
724: l_text:='';
725: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
726: l_text:=l_text||'
';
727: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
728: l_text:='';
729: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);

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

725: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
726: l_text:=l_text||'';
727: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
728: l_text:='';
729: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
730: l_text:=l_text||'
';
731: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
732: l_text:='';
733: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);

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

729: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
730: l_text:=l_text||'';
731: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
732: l_text:='';
733: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
734: l_text:=l_text||'
';
735: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
736: l_text:='';
737: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);

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

733: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
734: l_text:=l_text||'';
735: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
736: l_text:='';
737: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
738: l_text:=l_text||'
';
739: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
740: l_text:='';
741: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);

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

817: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);
818: l_text:=l_text||'';
819: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
820: l_text:='';
821: l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);
822: l_text:=l_text||'
';
823: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
824: l_text:='';
825: l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);

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

841: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);
842: l_text:=l_text||'';
843: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
844: l_text:='';
845: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);
846: l_text:=l_text||'
';
847: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
848: l_text:='';
849: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_name);

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

849: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_name);
850: l_text:=l_text||'';
851: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
852: l_text:='';
853: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
854: l_text:=l_text||'
';
855: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
856: l_text:='';
857: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);

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

853: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
854: l_text:=l_text||'';
855: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
856: l_text:='';
857: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
858: l_text:=l_text||'
';
859: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
860: l_text:='';
861: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);

Line 861: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);

857: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
858: l_text:=l_text||'';
859: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
860: l_text:='';
861: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
862: l_text:=l_text||'
';
863: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
864: l_text:='';
865: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

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

861: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
862: l_text:=l_text||'';
863: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
864: l_text:='';
865: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
866: l_text:=l_text||'
';
867: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
868: l_text:='';
869: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);

Line 877: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);

873: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
874: l_text:=l_text||'';
875: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
876: l_text:='';
877: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
878: l_text:=l_text||'
';
879: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
880: l_text:='';
881: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);

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

877: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
878: l_text:=l_text||'';
879: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
880: l_text:='';
881: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
882: l_text:=l_text||'
';
883: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
884: l_text:='';
885: if(P_OTHER_MANAGER_WARNING) then

Line 909: l_text:=l_text||fnd_number.number_to_canonical(p_grade_ladder_pgm_id);

905: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_concat_segments);
906: l_text:=l_text||'';
907: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
908: l_text:='';
909: l_text:=l_text||fnd_number.number_to_canonical(p_grade_ladder_pgm_id);
910: l_text:=l_text||'
';
911: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
912: l_text:='';
913: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);

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

909: l_text:=l_text||fnd_number.number_to_canonical(p_grade_ladder_pgm_id);
910: l_text:=l_text||'';
911: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
912: l_text:='';
913: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
914: l_text:=l_text||'
';
915: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
916: l_text:='';
917: --