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_CONTINGENT_WORKER_BE1 dependencies on FND_DATE

Line 169: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);

165: l_text:='';
166: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
167: --
168: l_text:='';
169: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
170: l_text:=l_text||'';
171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
172: l_text:='';
173: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

Line 193: l_text:=l_text||fnd_date.date_to_canonical(p_background_date_check);

189: l_text:=l_text||irc_utilities_pkg.removeTags(p_background_check_status);
190: l_text:=l_text||'';
191: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
192: l_text:='';
193: l_text:=l_text||fnd_date.date_to_canonical(p_background_date_check);
194: l_text:=l_text||'';
195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
196: l_text:='';
197: l_text:=l_text||irc_utilities_pkg.removeTags(p_blood_type);

Line 213: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);

209: l_text:=l_text||irc_utilities_pkg.removeTags(p_country_of_birth);
210: l_text:=l_text||'';
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
212: l_text:='';
213: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);
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_date.date_to_canonical(p_date_of_death);

Line 217: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_death);

213: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);
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_date.date_to_canonical(p_date_of_death);
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_date.date_to_canonical(p_dpdnt_adoption_date);

Line 221: l_text:=l_text||fnd_date.date_to_canonical(p_dpdnt_adoption_date);

217: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_death);
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_date.date_to_canonical(p_dpdnt_adoption_date);
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||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);

Line 257: l_text:=l_text||fnd_date.date_to_canonical(p_last_medical_test_date);

253: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_medical_test_by);
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_date.date_to_canonical(p_last_medical_test_date);
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_mailstop);

Line 301: l_text:=l_text||fnd_date.date_to_canonical(p_projected_placement_end);

297: l_text:=l_text||irc_utilities_pkg.removeTags(p_previous_last_name);
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_date.date_to_canonical(p_projected_placement_end);
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||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);

Line 305: l_text:=l_text||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);

301: l_text:=l_text||fnd_date.date_to_canonical(p_projected_placement_end);
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||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);
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||irc_utilities_pkg.removeTags(p_region_of_birth);

Line 321: l_text:=l_text||fnd_date.date_to_canonical(p_resume_last_updated);

317: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_exists);
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||fnd_date.date_to_canonical(p_resume_last_updated);
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||irc_utilities_pkg.removeTags(p_second_passport_exists);

Line 369: l_text:=l_text||fnd_date.date_to_canonical(p_hold_applicant_date_until);

365: l_text:=l_text||irc_utilities_pkg.removeTags(p_exp_check_send_to_address);
366: l_text:=l_text||'';
367: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
368: l_text:='';
369: l_text:=l_text||fnd_date.date_to_canonical(p_hold_applicant_date_until);
370: l_text:=l_text||'';
371: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
372: l_text:='';
373: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);

Line 373: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);

369: l_text:=l_text||fnd_date.date_to_canonical(p_hold_applicant_date_until);
370: l_text:=l_text||'';
371: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
372: l_text:='';
373: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);
374: l_text:=l_text||'';
375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
376: l_text:='';
377: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);

Line 389: l_text:=l_text||fnd_date.date_to_canonical(p_original_date_of_hire);

385: l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_no_cvg_flag);
386: l_text:=l_text||'';
387: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
388: l_text:='';
389: l_text:=l_text||fnd_date.date_to_canonical(p_original_date_of_hire);
390: l_text:=l_text||'';
391: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
392: l_text:='';
393: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);

Line 649: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);

645: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
646: l_text:=l_text||'';
647: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
648: l_text:='';
649: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);
650: l_text:=l_text||'';
651: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
652: l_text:='';
653: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);

Line 653: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);

649: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);
650: l_text:=l_text||'';
651: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
652: l_text:='';
653: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);
654: l_text:=l_text||'';
655: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
656: l_text:='';
657: l_text:=l_text||fnd_number.number_to_canonical(p_pdp_object_version_number);