APPS.PER_NL_DSR_ARCHIVE dependencies on FND_DATE

Line 344: AND c_effective_date BETWEEN fnd_date.canonical_to_date (pei_information1)

340: ,pei_information20 temporary_contracts
341: FROM per_people_extra_info
342: WHERE information_type = 'NL_DS_SICK_INFO'
343: AND person_id = c_person_id
344: AND c_effective_date BETWEEN fnd_date.canonical_to_date (pei_information1)
345: AND nvl (fnd_date.canonical_to_date (pei_information2),hr_general.end_of_time);
346: /**************************************************************************/
347: CURSOR cur_get_tml_info(c_assignment_id IN NUMBER
348: , c_effective_date IN DATE) IS

Line 345: AND nvl (fnd_date.canonical_to_date (pei_information2),hr_general.end_of_time);

341: FROM per_people_extra_info
342: WHERE information_type = 'NL_DS_SICK_INFO'
343: AND person_id = c_person_id
344: AND c_effective_date BETWEEN fnd_date.canonical_to_date (pei_information1)
345: AND nvl (fnd_date.canonical_to_date (pei_information2),hr_general.end_of_time);
346: /**************************************************************************/
347: CURSOR cur_get_tml_info(c_assignment_id IN NUMBER
348: , c_effective_date IN DATE) IS
349: SELECT aei.aei_information3 temp_worker

Line 353: AND c_effective_date BETWEEN fnd_date.canonical_to_date (aei_information1)

349: SELECT aei.aei_information3 temp_worker
350: FROM per_assignment_extra_info aei
351: WHERE aei.assignment_id = c_assignment_id
352: AND aei_information_category = 'NL_TML'
353: AND c_effective_date BETWEEN fnd_date.canonical_to_date (aei_information1)
354: AND nvl (fnd_date.canonical_to_date (aei_information2)
355: ,hr_general.end_of_time);
356: /**************************************************************************/
357: CURSOR cur_get_person_id(c_assignment_id IN NUMBER) IS

Line 354: AND nvl (fnd_date.canonical_to_date (aei_information2)

350: FROM per_assignment_extra_info aei
351: WHERE aei.assignment_id = c_assignment_id
352: AND aei_information_category = 'NL_TML'
353: AND c_effective_date BETWEEN fnd_date.canonical_to_date (aei_information1)
354: AND nvl (fnd_date.canonical_to_date (aei_information2)
355: ,hr_general.end_of_time);
356: /**************************************************************************/
357: CURSOR cur_get_person_id(c_assignment_id IN NUMBER) IS
358: SELECT pas.person_id

Line 413: RETURN fnd_date.canonical_to_date (r_get_person_eit_details.partial_recovery_date);

409: RETURN get_look_up_value('HR_NL_DS_ACCIDENT',r_get_person_eit_details.accident,p_language);
410: WHEN 'work_hours' THEN
411: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.work_hours);
412: WHEN 'partial_recovery_date' THEN
413: RETURN fnd_date.canonical_to_date (r_get_person_eit_details.partial_recovery_date);
414: WHEN 'termination_notice_date' THEN
415: RETURN fnd_date.canonical_to_date (r_get_person_eit_details.termination_notice_date);
416: WHEN 'immediate_termination' THEN
417: RETURN get_look_up_value('HR_NL_YES_NO',r_get_person_eit_details.immediate_termination,p_language);

Line 415: RETURN fnd_date.canonical_to_date (r_get_person_eit_details.termination_notice_date);

411: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.work_hours);
412: WHEN 'partial_recovery_date' THEN
413: RETURN fnd_date.canonical_to_date (r_get_person_eit_details.partial_recovery_date);
414: WHEN 'termination_notice_date' THEN
415: RETURN fnd_date.canonical_to_date (r_get_person_eit_details.termination_notice_date);
416: WHEN 'immediate_termination' THEN
417: RETURN get_look_up_value('HR_NL_YES_NO',r_get_person_eit_details.immediate_termination,p_language);
418: WHEN 'period_lt_3_months' THEN
419: RETURN get_look_up_value('HR_NL_YES_NO',r_get_person_eit_details.period_lt_3_months,p_language);

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

1038: p_type = 'R'
1039: )
1040: )
1041: AND (
1042: fnd_date.canonical_to_date(pai.action_information2) BETWEEN p_start_date
1043: AND p_end_date
1044: )
1045: AND paa.assignment_id = pai.assignment_id
1046: AND pap.person_id = p_person_id

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

1106: p_type = 'R'
1107: )
1108: )
1109: AND (
1110: fnd_date.canonical_to_date(pai.action_information2) BETWEEN p_start_date
1111: AND p_end_date
1112: )
1113: AND paa.assignment_id = pai.assignment_id
1114: AND pap.business_group_id = ppa.business_group_id

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

1146: p_type = 'R'
1147: )
1148: )
1149: AND (
1150: fnd_date.canonical_to_date(pai.action_information2) BETWEEN p_start_date
1151: AND p_end_date
1152: )
1153: AND paa.assignment_id = pai.assignment_id
1154: AND ppa.payroll_action_id = p_payroll_action_id

Line 1338: ,nvl(fnd_date.canonical_to_date(pab.abs_information9),pab.date_start) start_date

1334: ,pab.absence_attendance_type_id abs_att_type_id
1335: ,pab.business_group_id busi_group_id
1336: ,pab.absence_attendance_id abs_att_id
1337: ,pab.date_end end_date
1338: ,nvl(fnd_date.canonical_to_date(pab.abs_information9),pab.date_start) start_date
1339: ,pab.abs_information4 report_type
1340: ,pab.abs_information5 ass_id
1341: ,pab.abs_information6 sick_ref
1342: ,to_char (pab.date_notification,'YYYYMMDD') noti_date

Line 1343: ,to_char (nvl(fnd_date.canonical_to_date(pab.abs_information9),pab.date_start),'YYYYMMDD') dsr_st_dt

1339: ,pab.abs_information4 report_type
1340: ,pab.abs_information5 ass_id
1341: ,pab.abs_information6 sick_ref
1342: ,to_char (pab.date_notification,'YYYYMMDD') noti_date
1343: ,to_char (nvl(fnd_date.canonical_to_date(pab.abs_information9),pab.date_start),'YYYYMMDD') dsr_st_dt
1344: ,decode (pab.abs_information7,'Y','1','N','2') code_pymt
1345: ,pab.abs_information8 reason
1346: ,to_char (pab.abs_information9,'YYYYMMDD') overall_start_date
1347: ,decode (pab.abs_information10,'Y','1','N','2') work_sat

Line 1356: ,to_char (fnd_date.canonical_to_date (pab.abs_information19)

1352: ,pab.abs_information15 acc_reason
1353: ,pab.abs_information16 reason_late
1354: ,pab.abs_information17 avg_hr
1355: ,pab.abs_information18 partial_rec
1356: ,to_char (fnd_date.canonical_to_date (pab.abs_information19)
1357: ,'YYYYMMDD') dt_ter_notice
1358: ,pab.abs_information20 term_init
1359: ,decode (pab.abs_information21,'Y','1','N','2') imme_term
1360: ,pab.abs_information22 no_of_calls

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

1387: FROM pay_action_information pai
1388: WHERE pai.action_context_type = 'AAP'
1389: AND pai.action_information_category = 'NL_DSR_ABS_INFO'
1390: AND pai.ASSIGNMENT_ID = p_assignment_id
1391: AND fnd_date.canonical_to_date(pai.action_information2) = p_abs_start_date
1392: AND pai.action_information30 = 'N';
1393: /**************************************************************************/
1394:
1395: CURSOR get_archived_absence(p_assignment_id IN NUMBER

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

1405: WHERE pai.assignment_id = p_assignment_id
1406: AND pai.action_context_type = 'AAP'
1407: AND pai.action_information_category = 'NL_DSR_ABS_INFO'
1408: AND pai.action_information29 = 'NL_SR'
1409: AND fnd_date.canonical_to_date (pai.action_information2) BETWEEN p_start_date
1410: AND p_end_date
1411: AND (
1412: (
1413: pai.action_information30 = 'N'

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

1550: SELECT paei.aei_information3 fzcode
1551: FROM per_assignment_extra_info paei
1552: WHERE paei.assignment_id = p_assignment_id
1553: AND paei.aei_information_category = 'NL_TML'
1554: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1555: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1556: ,hr_general.end_of_time);
1557: /**************************************************************************/
1558: /* labor relation info */

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

1551: FROM per_assignment_extra_info paei
1552: WHERE paei.assignment_id = p_assignment_id
1553: AND paei.aei_information_category = 'NL_TML'
1554: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1555: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1556: ,hr_general.end_of_time);
1557: /**************************************************************************/
1558: /* labor relation info */
1559: CURSOR csr_get_lbr_info (p_assignment_id IN NUMBER

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

1557: /**************************************************************************/
1558: /* labor relation info */
1559: CURSOR csr_get_lbr_info (p_assignment_id IN NUMBER
1560: , p_start_date IN DATE) IS
1561: SELECT to_char(fnd_date.canonical_to_date (paei.aei_information1),'YYYYMMDD') start_date
1562: ,to_char(fnd_date.canonical_to_date (paei.aei_information2),'YYYYMMDD') end_date
1563: ,paei.aei_information3 code_kind
1564: FROM per_assignment_extra_info paei
1565: WHERE paei.assignment_id = p_assignment_id

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

1558: /* labor relation info */
1559: CURSOR csr_get_lbr_info (p_assignment_id IN NUMBER
1560: , p_start_date IN DATE) IS
1561: SELECT to_char(fnd_date.canonical_to_date (paei.aei_information1),'YYYYMMDD') start_date
1562: ,to_char(fnd_date.canonical_to_date (paei.aei_information2),'YYYYMMDD') end_date
1563: ,paei.aei_information3 code_kind
1564: FROM per_assignment_extra_info paei
1565: WHERE paei.assignment_id = p_assignment_id
1566: AND paei.aei_information_category = 'NL_LBR'

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

1563: ,paei.aei_information3 code_kind
1564: FROM per_assignment_extra_info paei
1565: WHERE paei.assignment_id = p_assignment_id
1566: AND paei.aei_information_category = 'NL_LBR'
1567: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1568: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1569: ,hr_general.end_of_time);
1570: /**************************************************************************/
1571: /* per_phones */

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

1564: FROM per_assignment_extra_info paei
1565: WHERE paei.assignment_id = p_assignment_id
1566: AND paei.aei_information_category = 'NL_LBR'
1567: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1568: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1569: ,hr_general.end_of_time);
1570: /**************************************************************************/
1571: /* per_phones */
1572: CURSOR csr_get_phone_no(p_assignment_id IN NUMBER

Line 1693: ,nvl(fnd_date.canonical_to_date(abs_information9),date_start) date_start

1689: ,date_start
1690: ,date_end
1691: FROM (
1692: SELECT absence_attendance_id
1693: ,nvl(fnd_date.canonical_to_date(abs_information9),date_start) date_start
1694: ,date_end
1695: FROM per_absence_attendances
1696: START WITH absence_attendance_id = c_current_absence
1697: CONNECT BY PRIOR abs_information27 = absence_attendance_id

Line 1704: SELECT nvl(fnd_date.canonical_to_date(abs_information9),date_start) date_start

1700: AND date_start IS NOT NULL
1701: AND date_end IS NOT NULL
1702: AND date_end <
1703: (
1704: SELECT nvl(fnd_date.canonical_to_date(abs_information9),date_start) date_start
1705: FROM per_absence_attendances
1706: WHERE absence_attendance_id = c_current_absence
1707: );
1708: /**************************************************************************/

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

1874: , p_source_id => NULL
1875: , p_source_text => NULL
1876: , p_action_information_category => 'NL_DSR_ABS_INFO'
1877: , p_action_information1 => l_abs_attendence_id
1878: , p_action_information2 => fnd_date.date_to_canonical(l_abs_start_date)
1879: , p_action_information3 => fnd_date.date_to_canonical(l_abs_end_date)
1880: , p_action_information4 => 'SR'
1881: , p_action_information5 => v_csr_get_abs_details.person_id
1882: , p_action_information6 => l_org_contact_info.test_msg

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

1875: , p_source_text => NULL
1876: , p_action_information_category => 'NL_DSR_ABS_INFO'
1877: , p_action_information1 => l_abs_attendence_id
1878: , p_action_information2 => fnd_date.date_to_canonical(l_abs_start_date)
1879: , p_action_information3 => fnd_date.date_to_canonical(l_abs_end_date)
1880: , p_action_information4 => 'SR'
1881: , p_action_information5 => v_csr_get_abs_details.person_id
1882: , p_action_information6 => l_org_contact_info.test_msg
1883: , p_action_information7 => l_org_contact_info.tax_no_sender

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

2195:
2196: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
2197:
2198: hr_utility.trace('Absence Start/End Date : ' ||
2199: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
2200: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
2201: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
2202:
2203: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id

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

2196: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
2197:
2198: hr_utility.trace('Absence Start/End Date : ' ||
2199: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
2200: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
2201: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
2202:
2203: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
2204: , lockedactid => r_get_archived_absence.org_asg_act_id);

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

2294:
2295: l_string_value := get_look_up_value('HR_NL_DS_REPORT_TYPE',l_type,l_lang);
2296: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
2297:
2298: l_string_value := fnd_date.date_to_chardate(l_start_date);
2299: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
2300:
2301: l_string_value := fnd_date.date_to_chardate(l_end_date);
2302: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;

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

2297:
2298: l_string_value := fnd_date.date_to_chardate(l_start_date);
2299: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
2300:
2301: l_string_value := fnd_date.date_to_chardate(l_end_date);
2302: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
2303:
2304: IF l_org_struct_id IS NOT NULL THEN
2305: OPEN c_get_hierarchy(l_org_struct_id);

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

2676: END IF;
2677: Tag(x,r,'NatuurlijkPersoon','_START_','B'); -- + employee data*
2678: Tag(x,r,'Burgerservicenr',l_emp_details.sofi_number,'B'); -- sofino*
2679: Tag(x,r,'Geboortedat',l_emp_details.date_of_birth,'X'); -- dob*
2680: Tag(x,r,'Geboortedat',fnd_date.date_to_chardate(
2681: to_date(l_emp_details.date_of_birth,'YYYYMMDD')),'R');
2682: Tag(x,r,'Geslacht',l_emp_details.gender,'X'); -- gender
2683: Tag(x,r,'Geslacht',get_look_up_value('HR_NL_DS_GENDER',
2684: l_emp_details.gender,l_lang),'R');

Line 2731: Tag(x,r,'DatB',fnd_date.date_to_chardate(

2727: OR l_addr_details.country IS NOT NULL
2728: THEN
2729: Tag(x,r,'Adres','_START_','B'); -- + address
2730: Tag(x,r,'DatB',l_addr_details.start_date,'X'); -- start dt addr
2731: Tag(x,r,'DatB',fnd_date.date_to_chardate(
2732: to_date(l_addr_details.start_date,'YYYYMMDD')),'R');
2733: Tag(x,r,'DatE',l_addr_details.end_date,'X'); -- end dt addr
2734: Tag(x,r,'DatE',fnd_date.date_to_chardate(
2735: to_date(l_addr_details.end_date,'YYYYMMDD')),'R');

Line 2734: Tag(x,r,'DatE',fnd_date.date_to_chardate(

2730: Tag(x,r,'DatB',l_addr_details.start_date,'X'); -- start dt addr
2731: Tag(x,r,'DatB',fnd_date.date_to_chardate(
2732: to_date(l_addr_details.start_date,'YYYYMMDD')),'R');
2733: Tag(x,r,'DatE',l_addr_details.end_date,'X'); -- end dt addr
2734: Tag(x,r,'DatE',fnd_date.date_to_chardate(
2735: to_date(l_addr_details.end_date,'YYYYMMDD')),'R');
2736: IF l_addr_details.style = 'NL' THEN
2737: Tag(x,r,'StraatadresNederland','_START_','B'); -- + NL address
2738: Tag(x,r,'Straatnaam',l_addr_details.reg1,'B'); -- street name

Line 2803: Tag(x,r,'DatB',fnd_date.date_to_chardate(to_date(l_emp_details.start_date,

2799: IF l_emp_details.start_date IS NOT NULL
2800: OR l_emp_details.end_date IS NOT NULL
2801: THEN
2802: Tag(x,r,'DatB',l_emp_details.start_date,'X'); -- start date income relation
2803: Tag(x,r,'DatB',fnd_date.date_to_chardate(to_date(l_emp_details.start_date,
2804: 'YYYYMMDD')),'R');
2805: Tag(x,r,'DatE',l_emp_details.end_date,'X'); -- end date income relation
2806: Tag(x,r,'DatE',fnd_date.date_to_chardate(to_date(l_emp_details.end_date,
2807: 'YYYYMMDD')),'R');

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

2802: Tag(x,r,'DatB',l_emp_details.start_date,'X'); -- start date income relation
2803: Tag(x,r,'DatB',fnd_date.date_to_chardate(to_date(l_emp_details.start_date,
2804: 'YYYYMMDD')),'R');
2805: Tag(x,r,'DatE',l_emp_details.end_date,'X'); -- end date income relation
2806: Tag(x,r,'DatE',fnd_date.date_to_chardate(to_date(l_emp_details.end_date,
2807: 'YYYYMMDD')),'R');
2808: ELSE
2809: Tag(x,r,'DatB',l_emp_details.ass_start_date,'X'); -- start date assignment
2810: Tag(x,r,'DatB',fnd_date.date_to_chardate(to_date(l_emp_details.ass_start_date,

Line 2810: Tag(x,r,'DatB',fnd_date.date_to_chardate(to_date(l_emp_details.ass_start_date,

2806: Tag(x,r,'DatE',fnd_date.date_to_chardate(to_date(l_emp_details.end_date,
2807: 'YYYYMMDD')),'R');
2808: ELSE
2809: Tag(x,r,'DatB',l_emp_details.ass_start_date,'X'); -- start date assignment
2810: Tag(x,r,'DatB',fnd_date.date_to_chardate(to_date(l_emp_details.ass_start_date,
2811: 'YYYYMMDD')),'R');
2812: Tag(x,r,'DatE',l_emp_details.ass_end_date,'X'); -- end date assignment
2813: Tag(x,r,'DatE',fnd_date.date_to_chardate(to_date(l_emp_details.ass_end_date,
2814: 'YYYYMMDD')),'R');

Line 2813: Tag(x,r,'DatE',fnd_date.date_to_chardate(to_date(l_emp_details.ass_end_date,

2809: Tag(x,r,'DatB',l_emp_details.ass_start_date,'X'); -- start date assignment
2810: Tag(x,r,'DatB',fnd_date.date_to_chardate(to_date(l_emp_details.ass_start_date,
2811: 'YYYYMMDD')),'R');
2812: Tag(x,r,'DatE',l_emp_details.ass_end_date,'X'); -- end date assignment
2813: Tag(x,r,'DatE',fnd_date.date_to_chardate(to_date(l_emp_details.ass_end_date,
2814: 'YYYYMMDD')),'R');
2815: END IF;
2816: Tag(x,r,'OproepInvalEnZiekUitDienstArbeidsverhouding','_START_','B'); -- + temp work or end empl during sickness
2817: Tag(x,r,'CdContractOnbepaaldeTijd',l_emp_details.contract,'X'); -- code contract

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

2840: 'Y',l_lang),'R');
2841: END IF;
2842: Tag(x,r,'ReferentieMelding',NVL(l_sick_info.sick_ref,l_emp_details.emp_num),'B'); -- sickness reference
2843: Tag(x,r,'DatTijdAanbiedenKetenpartij',to_char(SYSDATE, 'YYYYMMDDHH24MISS'),'X');-- time stamp
2844: Tag(x,r,'DatTijdAanbiedenKetenpartij',fnd_date.date_to_charDT(sysdate),'R');
2845: Tag(x,r,'DatOntvangstMeldingWerkgever',l_sick_info.noti_date,'X'); -- date of reporting
2846: Tag(x,r,'DatOntvangstMeldingWerkgever',fnd_date.date_to_chardate(
2847: to_date(l_sick_info.noti_date,'YYYYMMDD')),'R');
2848: Tag(x,r,'DatEersteAoDag',l_sick_info.dsr_st_dt,'X'); -- start date sickness

Line 2846: Tag(x,r,'DatOntvangstMeldingWerkgever',fnd_date.date_to_chardate(

2842: Tag(x,r,'ReferentieMelding',NVL(l_sick_info.sick_ref,l_emp_details.emp_num),'B'); -- sickness reference
2843: Tag(x,r,'DatTijdAanbiedenKetenpartij',to_char(SYSDATE, 'YYYYMMDDHH24MISS'),'X');-- time stamp
2844: Tag(x,r,'DatTijdAanbiedenKetenpartij',fnd_date.date_to_charDT(sysdate),'R');
2845: Tag(x,r,'DatOntvangstMeldingWerkgever',l_sick_info.noti_date,'X'); -- date of reporting
2846: Tag(x,r,'DatOntvangstMeldingWerkgever',fnd_date.date_to_chardate(
2847: to_date(l_sick_info.noti_date,'YYYYMMDD')),'R');
2848: Tag(x,r,'DatEersteAoDag',l_sick_info.dsr_st_dt,'X'); -- start date sickness
2849: Tag(x,r,'DatEersteAoDag',fnd_date.date_to_chardate(
2850: to_date(l_sick_info.dsr_st_dt,'YYYYMMDD')),'R');

Line 2849: Tag(x,r,'DatEersteAoDag',fnd_date.date_to_chardate(

2845: Tag(x,r,'DatOntvangstMeldingWerkgever',l_sick_info.noti_date,'X'); -- date of reporting
2846: Tag(x,r,'DatOntvangstMeldingWerkgever',fnd_date.date_to_chardate(
2847: to_date(l_sick_info.noti_date,'YYYYMMDD')),'R');
2848: Tag(x,r,'DatEersteAoDag',l_sick_info.dsr_st_dt,'X'); -- start date sickness
2849: Tag(x,r,'DatEersteAoDag',fnd_date.date_to_chardate(
2850: to_date(l_sick_info.dsr_st_dt,'YYYYMMDD')),'R');
2851: Tag(x,r,'ToelMelding',l_add_info.text,'B'); -- additional information
2852: Tag(x,r,'IndDirecteUitkering',l_sick_info.code_pymt,'X'); -- code payment to employee
2853: Tag(x,r,'IndDirecteUitkering',get_look_up_value('HR_NL_YES_NO',

Line 2886: Tag(x,r,'DatOpzeggenArbeidsovereenkomst',fnd_date.date_to_chardate(

2882: OR l_sick_info.temp_cont IS NOT NULL
2883: THEN
2884: Tag(x,r,'OproepInvalEnZiekUitDienstMelding','_START_','B'); -- + temp work or end empl
2885: Tag(x,r,'DatOpzeggenArbeidsovereenkomst',l_sick_info.dt_ter_notice,'X'); -- dt of notice of termination
2886: Tag(x,r,'DatOpzeggenArbeidsovereenkomst',fnd_date.date_to_chardate(
2887: to_date(l_sick_info.dt_ter_notice,'YYYYMMDD')),'R');
2888: Tag(x,r,'CdInitiatiefnemerOntslag',l_sick_info.term_init,'X'); -- code term initiative
2889: Tag(x,r,'CdInitiatiefnemerOntslag',get_look_up_value('HR_NL_DS_TERM_INIT',
2890: l_sick_info.term_init,l_lang),'R');

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

2905: IF connected_absence_count>0 THEN -- Currently connected absences is limited to 14 absences
2906: FOR i in 1..LEAST(connected_absence_count,14) LOOP
2907: Tag(x,r,'AoPeriode','_START_','B'); -- + connected abs
2908: Tag(x,r,'DatBAo',start_date(i),'X'); -- first day
2909: Tag(x,r,'DatBAo',fnd_date.date_to_chardate(to_date(
2910: start_date(i),'YYYYMMDD')),'R');
2911: Tag(x,r,'DatEAo',end_date(i),'X'); -- last day
2912: Tag(x,r,'DatEAo',fnd_date.date_to_chardate(to_date(
2913: end_date(i),'YYYYMMDD')),'R');

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

2908: Tag(x,r,'DatBAo',start_date(i),'X'); -- first day
2909: Tag(x,r,'DatBAo',fnd_date.date_to_chardate(to_date(
2910: start_date(i),'YYYYMMDD')),'R');
2911: Tag(x,r,'DatEAo',end_date(i),'X'); -- last day
2912: Tag(x,r,'DatEAo',fnd_date.date_to_chardate(to_date(
2913: end_date(i),'YYYYMMDD')),'R');
2914: Tag(x,r,'AoPeriode','_END_','B'); -- - connected abs
2915: END LOOP;
2916: END IF;