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.PER_NL_LTSR_ARCHIVE dependencies on FND_DATE

Line 907: fnd_date.canonical_to_date(pai.action_information2) BETWEEN p_start_date

903: p_type = 'R'
904: )
905: )
906: AND (
907: fnd_date.canonical_to_date(pai.action_information2) BETWEEN p_start_date
908: AND p_end_date
909: )
910: AND paa.assignment_id = pai.assignment_id
911: AND pap.person_id = p_person_id

Line 975: fnd_date.canonical_to_date(pai.action_information2) BETWEEN p_start_date

971: p_type = 'R'
972: )
973: )
974: AND (
975: fnd_date.canonical_to_date(pai.action_information2) BETWEEN p_start_date
976: AND p_end_date
977: )
978: AND paa.assignment_id = pai.assignment_id
979: AND pap.business_group_id = ppa.business_group_id

Line 1015: fnd_date.canonical_to_date(pai.action_information2) BETWEEN p_start_date

1011: p_type = 'R'
1012: )
1013: )
1014: AND (
1015: fnd_date.canonical_to_date(pai.action_information2) BETWEEN p_start_date
1016: AND p_end_date
1017: )
1018: AND paa.assignment_id = pai.assignment_id
1019: AND ppa.payroll_action_id = p_payroll_action_id

Line 1238: AND fnd_date.canonical_to_date(pai.action_information2) = p_abs_start_date

1234: FROM pay_action_information pai
1235: WHERE pai.action_context_type = 'AAP'
1236: AND pai.action_information_category = 'NL_LTSR_ABS_INFO'
1237: AND pai.ASSIGNMENT_ID = p_assignment_id
1238: AND fnd_date.canonical_to_date(pai.action_information2) = p_abs_start_date
1239: AND pai.action_information30 = 'N';
1240: /**************************************************************************/
1241: /* sender and contact data */
1242: CURSOR csr_get_org_contact_info(p_assignment_id IN NUMBER

Line 1303: AND fnd_date.canonical_to_date (pai.action_information2) BETWEEN p_start_date

1299: WHERE pai.assignment_id = p_assignment_id
1300: AND pai.action_context_type = 'AAP'
1301: AND pai.action_information_category = 'NL_LTSR_ABS_INFO'
1302: AND pai.action_information29 = 'NL_LTSR'
1303: AND fnd_date.canonical_to_date (pai.action_information2) BETWEEN p_start_date
1304: AND p_end_date
1305: AND (
1306: (
1307: pai.action_information30 = 'N'

Line 1454: , p_action_information2 => fnd_date.date_to_canonical(l_abs_start_date)

1450: , p_source_id => NULL
1451: , p_source_text => NULL
1452: , p_action_information_category => 'NL_LTSR_ABS_INFO'
1453: , p_action_information1 => l_abs_attendence_id
1454: , p_action_information2 => fnd_date.date_to_canonical(l_abs_start_date)
1455: , p_action_information3 => fnd_date.date_to_canonical(l_abs_end_date)
1456: , p_action_information4 => 'LTSR'
1457: , p_action_information5 => v_csr_get_abs_details.person_id
1458: , p_action_information6 => v_csr_get_abs_details.ass_id

Line 1455: , p_action_information3 => fnd_date.date_to_canonical(l_abs_end_date)

1451: , p_source_text => NULL
1452: , p_action_information_category => 'NL_LTSR_ABS_INFO'
1453: , p_action_information1 => l_abs_attendence_id
1454: , p_action_information2 => fnd_date.date_to_canonical(l_abs_start_date)
1455: , p_action_information3 => fnd_date.date_to_canonical(l_abs_end_date)
1456: , p_action_information4 => 'LTSR'
1457: , p_action_information5 => v_csr_get_abs_details.person_id
1458: , p_action_information6 => v_csr_get_abs_details.ass_id
1459: , p_action_information7 => v_csr_get_abs_details.sick_ref

Line 1538: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||

1534:
1535: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1536:
1537: hr_utility.trace('Absence Start/End Date : ' ||
1538: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1539: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1540: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1541:
1542: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id

Line 1539: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));

1535: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1536:
1537: hr_utility.trace('Absence Start/End Date : ' ||
1538: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1539: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1540: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1541:
1542: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
1543: , lockedactid => r_get_archived_absence.org_asg_act_id);

Line 1637: l_string_value := fnd_date.date_to_chardate(l_start_date);

1633:
1634: l_string_value := get_look_up_value('HR_NL_DS_REPORT_TYPE',l_type,l_lang);
1635: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1636:
1637: l_string_value := fnd_date.date_to_chardate(l_start_date);
1638: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1639:
1640: l_string_value := fnd_date.date_to_chardate(l_end_date);
1641: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;

Line 1640: l_string_value := fnd_date.date_to_chardate(l_end_date);

1636:
1637: l_string_value := fnd_date.date_to_chardate(l_start_date);
1638: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1639:
1640: l_string_value := fnd_date.date_to_chardate(l_end_date);
1641: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1642:
1643: IF l_org_struct_id IS NOT NULL THEN
1644: OPEN c_get_hierarchy(l_org_struct_id);

Line 1842: Tag(x,r,'Geboortedat',fnd_date.date_to_chardate(

1838: Tag(x,r,'SectorRisicogroep','_END_','X'); -- - risk sector grp*
1839: Tag(x,r,'NatuurlijkPersoon','_START_','B'); -- + employee data*
1840: Tag(x,r,'Burgerservicenr',l_emp_details.sofi_number,'B'); -- sofino*
1841: Tag(x,r,'Geboortedat',l_emp_details.date_of_birth,'X'); -- dob*
1842: Tag(x,r,'Geboortedat',fnd_date.date_to_chardate(
1843: to_date(l_emp_details.date_of_birth,'YYYYMMDD')),'R');
1844: Tag(x,r,'Geslacht',l_emp_details.gender,'X'); -- gender
1845: Tag(x,r,'Geslacht',get_look_up_value('HR_NL_DS_GENDER',
1846: l_emp_details.gender,l_lang),'R');

Line 1859: Tag(x,r,'DatBAo',fnd_date.date_to_chardate(to_date(

1855: Tag(x,r,'IndVerzoekTotIntrekken',get_look_up_value('HR_NL_YES_NO','Y',l_lang),'R');
1856: END IF;
1857: Tag(x,r,'AoPeriode','_START_','B'); -- + period
1858: Tag(x,r,'DatBAo',l_abs_info.lts_st_dt,'X'); -- start day
1859: Tag(x,r,'DatBAo',fnd_date.date_to_chardate(to_date(
1860: l_abs_info.lts_st_dt,'YYYYMMDD')),'R');
1861: Tag(x,r,'DatEAo',l_abs_info.lts_end_dt,'X'); -- end day
1862: Tag(x,r,'DatEAo',fnd_date.date_to_chardate(to_date(
1863: l_abs_info.lts_end_dt,'YYYYMMDD')),'R');

Line 1862: Tag(x,r,'DatEAo',fnd_date.date_to_chardate(to_date(

1858: Tag(x,r,'DatBAo',l_abs_info.lts_st_dt,'X'); -- start day
1859: Tag(x,r,'DatBAo',fnd_date.date_to_chardate(to_date(
1860: l_abs_info.lts_st_dt,'YYYYMMDD')),'R');
1861: Tag(x,r,'DatEAo',l_abs_info.lts_end_dt,'X'); -- end day
1862: Tag(x,r,'DatEAo',fnd_date.date_to_chardate(to_date(
1863: l_abs_info.lts_end_dt,'YYYYMMDD')),'R');
1864: Tag(x,r,'AoPeriode','_END_','B'); -- - period
1865: IF l_abs_info.contact_name IS NOT NULL
1866: OR l_abs_info.est_name IS NOT NULL