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_WAZO_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 1210: ,to_char (fnd_date.canonical_to_date(pab.abs_information6),'YYYYMMDD') est_dob

1206: ,pab.abs_information2 sick_ref
1207: ,decode (pab.abs_information3,'Y','1','N','2') code_pymt
1208: ,pab.abs_information4 reason
1209: ,decode (pab.abs_information5,'Y','1','N','2') spl_sit
1210: ,to_char (fnd_date.canonical_to_date(pab.abs_information6),'YYYYMMDD') est_dob
1211: ,to_char (pab.date_start,'YYYYMMDD') wazo_st_dt
1212: FROM per_absence_attendance_types paat
1213: ,per_absence_attendances pab
1214: ,pay_assignment_actions paa

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

1233: FROM pay_action_information pai
1234: WHERE pai.action_context_type = 'AAP'
1235: AND pai.action_information_category = 'NL_WAZO_ABS_INFO'
1236: AND pai.ASSIGNMENT_ID = p_assignment_id
1237: AND fnd_date.canonical_to_date(pai.action_information2) = p_abs_start_date
1238: AND pai.action_information30 = 'N';
1239: /**************************************************************************/
1240:
1241: CURSOR get_archived_absence(p_assignment_id IN NUMBER

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

1251: WHERE pai.assignment_id = p_assignment_id
1252: AND pai.action_context_type = 'AAP'
1253: AND pai.action_information_category = 'NL_WAZO_ABS_INFO'
1254: AND pai.action_information29 = 'NL_WAZO'
1255: AND fnd_date.canonical_to_date (pai.action_information2) BETWEEN p_start_date
1256: AND p_end_date
1257: AND (
1258: (
1259: pai.action_information30 = 'N'

Line 1362: SELECT to_char(fnd_date.canonical_to_date (paei.aei_information1),'YYYYMMDD') start_date

1358: /**************************************************************************/
1359: /* labor relation info */
1360: CURSOR csr_get_lbr_info (p_assignment_id IN NUMBER
1361: , p_start_date IN DATE) IS
1362: SELECT to_char(fnd_date.canonical_to_date (paei.aei_information1),'YYYYMMDD') start_date
1363: ,to_char(fnd_date.canonical_to_date (paei.aei_information2),'YYYYMMDD') end_date
1364: ,paei.aei_information3 code_kind
1365: FROM per_assignment_extra_info paei
1366: WHERE paei.assignment_id = p_assignment_id

Line 1363: ,to_char(fnd_date.canonical_to_date (paei.aei_information2),'YYYYMMDD') end_date

1359: /* labor relation info */
1360: CURSOR csr_get_lbr_info (p_assignment_id IN NUMBER
1361: , p_start_date IN DATE) IS
1362: SELECT to_char(fnd_date.canonical_to_date (paei.aei_information1),'YYYYMMDD') start_date
1363: ,to_char(fnd_date.canonical_to_date (paei.aei_information2),'YYYYMMDD') end_date
1364: ,paei.aei_information3 code_kind
1365: FROM per_assignment_extra_info paei
1366: WHERE paei.assignment_id = p_assignment_id
1367: AND paei.aei_information_category = 'NL_LBR'

Line 1368: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)

1364: ,paei.aei_information3 code_kind
1365: FROM per_assignment_extra_info paei
1366: WHERE paei.assignment_id = p_assignment_id
1367: AND paei.aei_information_category = 'NL_LBR'
1368: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1369: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1370: ,hr_general.end_of_time);
1371: /**************************************************************************/
1372: /* per_phones */

Line 1369: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)

1365: FROM per_assignment_extra_info paei
1366: WHERE paei.assignment_id = p_assignment_id
1367: AND paei.aei_information_category = 'NL_LBR'
1368: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1369: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1370: ,hr_general.end_of_time);
1371: /**************************************************************************/
1372: /* per_phones */
1373: CURSOR csr_get_phone_no(p_assignment_id IN NUMBER

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

1619: , p_source_id => NULL
1620: , p_source_text => NULL
1621: , p_action_information_category => 'NL_WAZO_ABS_INFO'
1622: , p_action_information1 => l_abs_attendence_id
1623: , p_action_information2 => fnd_date.date_to_canonical(l_abs_start_date)
1624: , p_action_information3 => fnd_date.date_to_canonical(l_abs_end_date)
1625: , p_action_information4 => 'WAZO'
1626: , p_action_information5 => v_csr_get_abs_details.person_id
1627: , p_action_information6 => v_csr_get_abs_details.sick_ref

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

1620: , p_source_text => NULL
1621: , p_action_information_category => 'NL_WAZO_ABS_INFO'
1622: , p_action_information1 => l_abs_attendence_id
1623: , p_action_information2 => fnd_date.date_to_canonical(l_abs_start_date)
1624: , p_action_information3 => fnd_date.date_to_canonical(l_abs_end_date)
1625: , p_action_information4 => 'WAZO'
1626: , p_action_information5 => v_csr_get_abs_details.person_id
1627: , p_action_information6 => v_csr_get_abs_details.sick_ref
1628: , p_action_information7 => v_csr_get_abs_details.code_pymt

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

1827:
1828: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1829:
1830: hr_utility.trace('Absence Start/End Date : ' ||
1831: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1832: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1833: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1834:
1835: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id

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

1828: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1829:
1830: hr_utility.trace('Absence Start/End Date : ' ||
1831: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1832: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1833: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1834:
1835: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
1836: , lockedactid => r_get_archived_absence.org_asg_act_id);

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

1928:
1929: l_string_value := get_look_up_value('HR_NL_DS_REPORT_TYPE',l_type,l_lang);
1930: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1931:
1932: l_string_value := fnd_date.date_to_chardate(l_start_date);
1933: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1934:
1935: l_string_value := fnd_date.date_to_chardate(l_end_date);
1936: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;

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

1931:
1932: l_string_value := fnd_date.date_to_chardate(l_start_date);
1933: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1934:
1935: l_string_value := fnd_date.date_to_chardate(l_end_date);
1936: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1937:
1938: IF l_org_struct_id IS NOT NULL THEN
1939: OPEN c_get_hierarchy(l_org_struct_id);

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

2209: END IF;
2210: Tag(x,r,'NatuurlijkPersoon','_START_','B'); -- + employee data*
2211: Tag(x,r,'Burgerservicenr',l_emp_details.sofi_number,'B'); -- sofino*
2212: Tag(x,r,'Geboortedat',l_emp_details.date_of_birth,'X'); -- dob*
2213: Tag(x,r,'Geboortedat',fnd_date.date_to_chardate(
2214: to_date(l_emp_details.date_of_birth,'YYYYMMDD')),'R');
2215: Tag(x,r,'Geslacht',l_emp_details.gender,'X'); -- gender
2216: Tag(x,r,'Geslacht',get_look_up_value('HR_NL_DS_GENDER',
2217: l_emp_details.gender,l_lang),'R');

Line 2294: Tag(x,r,'DatE',fnd_date.date_to_chardate(to_date(nvl(l_emp_details.end_date

2290: REPLACE(REPLACE(l_emp_details.wage_tax_discount,'1','Y'),'2','N'),l_lang),'R');
2291: Tag(x,r,'NrInkomstenverhouding',l_emp_details.asg_seq,'B'); -- NumIV override/asg seq
2292: Tag(x,r,'CdLoonbelastingtabel',l_emp_details.wage_tax_table,'B'); -- wage tax table
2293: Tag(x,r,'DatE',nvl(l_emp_details.end_date,l_emp_details.ass_end_date),'X'); -- end date income relation
2294: Tag(x,r,'DatE',fnd_date.date_to_chardate(to_date(nvl(l_emp_details.end_date
2295: ,l_emp_details.ass_end_date), 'YYYYMMDD')),'R');
2296: Tag(x,r,'MeldingWazo','_START_','B'); -- + wazo details
2297: IF (p_type = 'R' AND l_withdrawl_flag.flag = 'Y') OR p_type = 'W' THEN
2298: Tag(x,r,'IndVerzoekTotIntrekken','1','X'); -- withdrawal code

Line 2303: Tag(x,r,'DatTijdAanbiedenKetenpartij',fnd_date.date_to_charDT(sysdate),'R');

2299: Tag(x,r,'IndVerzoekTotIntrekken',get_look_up_value('HR_NL_YES_NO','Y',l_lang),'R');
2300: END IF;
2301: Tag(x,r,'ReferentieMelding',nvl(l_abs_info.sick_ref,l_emp_details.emp_num),'B'); -- sickness reference
2302: Tag(x,r,'DatTijdAanbiedenKetenpartij',to_char(SYSDATE, 'YYYYMMDDHH24MISS'),'X'); -- time stamp
2303: Tag(x,r,'DatTijdAanbiedenKetenpartij',fnd_date.date_to_charDT(sysdate),'R');
2304: Tag(x,r,'ToelMelding',l_add_info.text,'B'); -- additional details
2305: Tag(x,r,'IndDirecteUitkering',l_abs_info.code_pymt,'X'); -- code payment
2306: Tag(x,r,'IndDirecteUitkering',get_look_up_value('HR_NL_YES_NO',
2307: REPLACE(REPLACE(l_abs_info.code_pymt,'1','Y'),'2','N'),l_lang),'R');

Line 2315: Tag(x,r,'DatGewensteAanvangWazo',fnd_date.date_to_chardate(

2311: Tag(x,r,'IndSpecialeSituatie',l_abs_info.spl_sit,'X'); -- special situation
2312: Tag(x,r,'IndSpecialeSituatie',get_look_up_value('HR_NL_YES_NO',
2313: REPLACE(REPLACE(l_abs_info.spl_sit,'1','Y'),'2','N'),l_lang),'R');
2314: Tag(x,r,'DatGewensteAanvangWazo',l_abs_info.wazo_st_dt,'X'); -- WAZO date
2315: Tag(x,r,'DatGewensteAanvangWazo',fnd_date.date_to_chardate(
2316: to_date(l_abs_info.wazo_st_dt,'YYYYMMDD')),'R');
2317: IF l_abs_info.wazo_reason='01' THEN
2318: Tag(x,r,'DatVermoedelijkeBevalling',l_abs_info.est_dob,'X'); -- Estimated DOB
2319: Tag(x,r,'DatVermoedelijkeBevalling',fnd_date.date_to_chardate(

Line 2319: Tag(x,r,'DatVermoedelijkeBevalling',fnd_date.date_to_chardate(

2315: Tag(x,r,'DatGewensteAanvangWazo',fnd_date.date_to_chardate(
2316: to_date(l_abs_info.wazo_st_dt,'YYYYMMDD')),'R');
2317: IF l_abs_info.wazo_reason='01' THEN
2318: Tag(x,r,'DatVermoedelijkeBevalling',l_abs_info.est_dob,'X'); -- Estimated DOB
2319: Tag(x,r,'DatVermoedelijkeBevalling',fnd_date.date_to_chardate(
2320: to_date(l_abs_info.est_dob,'YYYYMMDD')),'R');
2321: END IF;
2322: IF l_abs_info.contact_name IS NOT NULL
2323: OR l_abs_info.est_name IS NOT NULL