eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ASSIGNMENT_BE8 dependencies on FND_NUMBER

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

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

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

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

Line 228: l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);

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

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

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

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

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

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

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

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

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

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

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

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

248: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
249: l_text:=l_text||'';
250: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
251: l_text:='';
252: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
253: l_text:=l_text||'';
254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
255: l_text:='';
256: l_text:=l_text||fnd_number.number_to_canonical(p_person_referred_by_id);

Line 256: l_text:=l_text||fnd_number.number_to_canonical(p_person_referred_by_id);

252: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
253: l_text:=l_text||'';
254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
255: l_text:='';
256: l_text:=l_text||fnd_number.number_to_canonical(p_person_referred_by_id);
257: l_text:=l_text||'';
258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
259: l_text:='';
260: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);

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

256: l_text:=l_text||fnd_number.number_to_canonical(p_person_referred_by_id);
257: l_text:=l_text||'';
258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
259: l_text:='';
260: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
261: l_text:=l_text||'';
262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
263: l_text:='';
264: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);

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

260: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
261: l_text:=l_text||'';
262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
263: l_text:='';
264: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
265: l_text:=l_text||'';
266: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
267: l_text:='';
268: l_text:=l_text||fnd_number.number_to_canonical(p_recruitment_activity_id);

Line 268: l_text:=l_text||fnd_number.number_to_canonical(p_recruitment_activity_id);

264: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
265: l_text:=l_text||'';
266: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
267: l_text:='';
268: l_text:=l_text||fnd_number.number_to_canonical(p_recruitment_activity_id);
269: l_text:=l_text||'';
270: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
271: l_text:='';
272: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);

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

268: l_text:=l_text||fnd_number.number_to_canonical(p_recruitment_activity_id);
269: l_text:=l_text||'';
270: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
271: l_text:='';
272: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
273: l_text:=l_text||'';
274: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
275: l_text:='';
276: l_text:=l_text||fnd_number.number_to_canonical(p_source_organization_id);

Line 276: l_text:=l_text||fnd_number.number_to_canonical(p_source_organization_id);

272: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
273: l_text:=l_text||'';
274: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
275: l_text:='';
276: l_text:=l_text||fnd_number.number_to_canonical(p_source_organization_id);
277: l_text:=l_text||'';
278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
279: l_text:='';
280: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);

Line 280: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);

276: l_text:=l_text||fnd_number.number_to_canonical(p_source_organization_id);
277: l_text:=l_text||'';
278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
279: l_text:='';
280: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
281: l_text:=l_text||'';
282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
283: l_text:='';
284: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);

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

280: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
281: l_text:=l_text||'';
282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
283: l_text:='';
284: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
285: l_text:=l_text||'';
286: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
287: l_text:='';
288: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);

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

300: l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);
301: l_text:=l_text||'';
302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
303: l_text:='';
304: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
305: l_text:=l_text||'';
306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
307: l_text:='';
308: l_text:=l_text||irc_utilities_pkg.removeTags(p_employment_category);

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

316: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
317: l_text:=l_text||'';
318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
319: l_text:='';
320: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
321: l_text:=l_text||'';
322: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
323: l_text:='';
324: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);

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

320: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
321: l_text:=l_text||'';
322: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
323: l_text:='';
324: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
325: l_text:=l_text||'';
326: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
327: l_text:='';
328: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);

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

328: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
329: l_text:=l_text||'';
330: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
331: l_text:='';
332: l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);
333: l_text:=l_text||'';
334: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
335: l_text:='';
336: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);

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

336: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);
337: l_text:=l_text||'';
338: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
339: l_text:='';
340: l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);
341: l_text:=l_text||'';
342: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
343: l_text:='';
344: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);

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

344: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
345: l_text:=l_text||'';
346: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
347: l_text:='';
348: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
349: l_text:=l_text||'';
350: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
351: l_text:='';
352: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);

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

740: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_name);
741: l_text:=l_text||'';
742: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
743: l_text:='';
744: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
745: l_text:=l_text||'';
746: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
747: l_text:='';
748: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

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

744: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
745: l_text:=l_text||'';
746: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
747: l_text:='';
748: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
749: l_text:=l_text||'';
750: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
751: l_text:='';
752: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);

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

756: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
757: l_text:=l_text||'';
758: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
759: l_text:='';
760: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
761: l_text:=l_text||'';
762: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
763: l_text:='';
764: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);

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

760: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
761: l_text:=l_text||'';
762: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
763: l_text:='';
764: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
765: l_text:=l_text||'';
766: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
767: l_text:='';
768: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);

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

764: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
765: l_text:=l_text||'';
766: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
767: l_text:='';
768: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
769: l_text:=l_text||'';
770: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
771: l_text:='';
772: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

Line 772: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

768: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
769: l_text:=l_text||'';
770: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
771: l_text:='';
772: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
773: l_text:=l_text||'';
774: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
775: l_text:='';
776: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);

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

780: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_concat_segments);
781: l_text:=l_text||'';
782: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
783: l_text:='';
784: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
785: l_text:=l_text||'';
786: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
787: l_text:='';
788: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);

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

784: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
785: l_text:=l_text||'';
786: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
787: l_text:='';
788: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
789: l_text:=l_text||'';
790: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
791: l_text:='';
792: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);

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

788: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
789: l_text:=l_text||'';
790: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
791: l_text:='';
792: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
793: l_text:=l_text||'';
794: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
795: l_text:='';
796: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);

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

792: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
793: l_text:=l_text||'';
794: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
795: l_text:='';
796: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
797: l_text:=l_text||'';
798: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
799: l_text:='';
800: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);

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

876: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);
877: l_text:=l_text||'';
878: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
879: l_text:='';
880: l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);
881: l_text:=l_text||'';
882: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
883: l_text:='';
884: l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);

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

896: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);
897: l_text:=l_text||'';
898: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
899: l_text:='';
900: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);
901: l_text:=l_text||'';
902: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
903: l_text:='';
904: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);

Line 908: l_text:=l_text||fnd_number.number_to_canonical(p_applicant_rank);

904: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);
905: l_text:=l_text||'';
906: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
907: l_text:='';
908: l_text:=l_text||fnd_number.number_to_canonical(p_applicant_rank);
909: l_text:=l_text||'';
910: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
911: l_text:='';
912: l_text:=l_text||fnd_number.number_to_canonical(p_posting_content_id);

Line 912: l_text:=l_text||fnd_number.number_to_canonical(p_posting_content_id);

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

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

912: l_text:=l_text||fnd_number.number_to_canonical(p_posting_content_id);
913: l_text:=l_text||'';
914: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
915: l_text:='';
916: l_text:=l_text||fnd_number.number_to_canonical(p_grade_ladder_pgm_id);
917: l_text:=l_text||'';
918: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
919: l_text:='';
920: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);

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

916: l_text:=l_text||fnd_number.number_to_canonical(p_grade_ladder_pgm_id);
917: l_text:=l_text||'';
918: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
919: l_text:='';
920: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
921: l_text:=l_text||'';
922: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
923: l_text:='';
924: --