APPS.PER_NO_SICKLEAVEMONITORING dependencies on FND_DATE

Line 352: l_action_from := fnd_date.canonical_to_date(p_from);

348: hr_utility.trace('p_template_name: '||p_template_name);
349: END IF;
350:
351:
352: l_action_from := fnd_date.canonical_to_date(p_from);
353: l_action_to := fnd_date.canonical_to_date(p_to);
354: --Fetch Employer Details
355: OPEN csr_employer_details(p_employer);
356: FETCH csr_employer_details INTO r_employer_details;

Line 353: l_action_to := fnd_date.canonical_to_date(p_to);

349: END IF;
350:
351:
352: l_action_from := fnd_date.canonical_to_date(p_from);
353: l_action_to := fnd_date.canonical_to_date(p_to);
354: --Fetch Employer Details
355: OPEN csr_employer_details(p_employer);
356: FETCH csr_employer_details INTO r_employer_details;
357: CLOSE csr_employer_details;

Line 387: l_string := l_string || ''||fnd_date.date_to_displaydate(l_action_from)||''||EOL;

383: -- Build XML Structure --
384:
385: l_string := l_string || ''||EOL;
386: l_string := l_string || ''||r_employer_details.name||''||EOL;
387: l_string := l_string || ''||fnd_date.date_to_displaydate(l_action_from)||''||EOL;
388: l_string := l_string || ''||fnd_date.date_to_displaydate(l_action_to)||''||EOL;
389:
390: actions.delete;
391: FOR i IN data.FIRST..data.LAST LOOP

Line 388: l_string := l_string || ''||fnd_date.date_to_displaydate(l_action_to)||''||EOL;

384:
385: l_string := l_string || ''||EOL;
386: l_string := l_string || ''||r_employer_details.name||''||EOL;
387: l_string := l_string || ''||fnd_date.date_to_displaydate(l_action_from)||''||EOL;
388: l_string := l_string || ''||fnd_date.date_to_displaydate(l_action_to)||''||EOL;
389:
390: actions.delete;
391: FOR i IN data.FIRST..data.LAST LOOP
392: actions(i) := ''||EOL;

Line 427: fnd_date.date_to_displaydate(absences(i).reimb_days(followup_days(k)))

423: IF absences(i).reimb_days.EXISTS(followup_days(k)) THEN
424: IF absences(i).reimb_days(followup_days(k)) BETWEEN l_action_from AND l_action_to THEN
425: actions(k) := actions(k) || ''||EOL;
426: actions(k) := actions(k) || ''||
427: fnd_date.date_to_displaydate(absences(i).reimb_days(followup_days(k)))
428: ||''||EOL;
429: actions(k) := actions(k) || ''||fnd_date.date_to_displaydate(absences(i).start_date)||''||EOL;
430: actions(k) := actions(k) || ''||absences(i).employee_number||''||EOL;
431: actions(k) := actions(k) || ''||EOL;

Line 429: actions(k) := actions(k) || ''||fnd_date.date_to_displaydate(absences(i).start_date)||''||EOL;

425: actions(k) := actions(k) || ''||EOL;
426: actions(k) := actions(k) || ''||
427: fnd_date.date_to_displaydate(absences(i).reimb_days(followup_days(k)))
428: ||''||EOL;
429: actions(k) := actions(k) || ''||fnd_date.date_to_displaydate(absences(i).start_date)||''||EOL;
430: actions(k) := actions(k) || ''||absences(i).employee_number||''||EOL;
431: actions(k) := actions(k) || ''||EOL;
432: actions(k) := actions(k) || ''||EOL;
433: absence_count(k) := absence_count(k)+1;