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

Line 912: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)

908: p_type = 'R'
909: )
910: )
911: AND (
912: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)
913: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)
914: )
915: AND paa.assignment_id = pai.assignment_id
916: AND pap.person_id = p_person_id

Line 913: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)

909: )
910: )
911: AND (
912: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)
913: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)
914: )
915: AND paa.assignment_id = pai.assignment_id
916: AND pap.person_id = p_person_id
917: AND p_person_id BETWEEN p_start_person_id

Line 980: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)

976: p_type = 'R'
977: )
978: )
979: AND (
980: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)
981: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)
982: )
983: AND paa.assignment_id = pai.assignment_id
984: AND pap.business_group_id = ppa.business_group_id

Line 981: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)

977: )
978: )
979: AND (
980: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)
981: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)
982: )
983: AND paa.assignment_id = pai.assignment_id
984: AND pap.business_group_id = ppa.business_group_id
985: AND ppa.payroll_action_id = p_payroll_action_id;

Line 1020: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)

1016: p_type = 'R'
1017: )
1018: )
1019: AND (
1020: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)
1021: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)
1022: )
1023: AND paa.assignment_id = pai.assignment_id
1024: AND pap.person_id = paa.person_id

Line 1021: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)

1017: )
1018: )
1019: AND (
1020: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)
1021: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)
1022: )
1023: AND paa.assignment_id = pai.assignment_id
1024: AND pap.person_id = paa.person_id
1025: AND (

Line 1205: ,nvl (fnd_date.canonical_to_date (pab.abs_information9)

1201: SELECT paa.assignment_id assignment_id
1202: ,pas.person_id person_id
1203: ,pab.absence_attendance_id abs_att_id
1204: ,pab.date_end end_date
1205: ,nvl (fnd_date.canonical_to_date (pab.abs_information9)
1206: ,pab.date_start) start_date
1207: ,paat.absence_category abs_cat
1208: ,pab.abs_information_category info_cat
1209: ,pab.abs_information4 report_type

Line 1214: ,to_char (nvl (fnd_date.canonical_to_date (pab.abs_information9)

1210: ,pab.abs_information5 ass_id
1211: ,pab.abs_information6 sick_ref
1212: ,to_char (pab.date_notification
1213: ,'YYYYMMDD') noti_date
1214: ,to_char (nvl (fnd_date.canonical_to_date (pab.abs_information9)
1215: ,pab.date_start)
1216: ,'YYYYMMDD') st_dt
1217: ,to_char ((pab.date_end + 1)
1218: ,'YYYYMMDD') full_rec_dt

Line 1219: ,to_char (fnd_date.canonical_to_date (pab.abs_information18)

1215: ,pab.date_start)
1216: ,'YYYYMMDD') st_dt
1217: ,to_char ((pab.date_end + 1)
1218: ,'YYYYMMDD') full_rec_dt
1219: ,to_char (fnd_date.canonical_to_date (pab.abs_information18)
1220: ,'YYYYMMDD') partial_rec_dt
1221: ,pab.abs_information13 daily_si
1222: FROM per_absence_attendance_types paat
1223: ,per_absence_attendances pab

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

1246: FROM pay_action_information pai
1247: WHERE pai.assignment_id = p_assignment_id
1248: AND pai.action_information_category = 'NL_DSR_ABS_INFO'
1249: AND pai.action_information30 = 'N'
1250: AND fnd_date.canonical_to_date (pai.action_information2) = p_abs_start_date;
1251: /**************************************************************************/
1252:
1253: /* sender and contact data */
1254: CURSOR csr_get_org_contact_info(p_assignment_id IN NUMBER

Line 1355: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)

1351: p_type = 'R'
1352: )
1353: )
1354: AND (
1355: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)
1356: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)
1357: ); --abraghun - to check this date condition.
1358: /**************************************************************************/
1359: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS

Line 1356: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)

1352: )
1353: )
1354: AND (
1355: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)
1356: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)
1357: ); --abraghun - to check this date condition.
1358: /**************************************************************************/
1359: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS
1360: SELECT ppa.payroll_action_id

Line 1497: , p_action_information2 => fnd_date.date_to_canonical(l_abs_end_date + 1)

1493: , p_source_id => NULL
1494: , p_source_text => NULL
1495: , p_action_information_category => 'NL_DSRR_ABS_INFO'
1496: , p_action_information1 => l_abs_attendence_id
1497: , p_action_information2 => fnd_date.date_to_canonical(l_abs_end_date + 1)
1498: , p_action_information3 => fnd_date.date_to_canonical(l_abs_start_date)
1499: , p_action_information4 => 'SRR'
1500: , p_action_information5 => v_csr_get_abs_details.person_id
1501: , p_action_information6 => v_csr_get_abs_details.ass_id

Line 1498: , p_action_information3 => fnd_date.date_to_canonical(l_abs_start_date)

1494: , p_source_text => NULL
1495: , p_action_information_category => 'NL_DSRR_ABS_INFO'
1496: , p_action_information1 => l_abs_attendence_id
1497: , p_action_information2 => fnd_date.date_to_canonical(l_abs_end_date + 1)
1498: , p_action_information3 => fnd_date.date_to_canonical(l_abs_start_date)
1499: , p_action_information4 => 'SRR'
1500: , p_action_information5 => v_csr_get_abs_details.person_id
1501: , p_action_information6 => v_csr_get_abs_details.ass_id
1502: , p_action_information7 => v_csr_get_abs_details.sick_ref

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

1581:
1582: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1583:
1584: hr_utility.trace('Absence Start/End Date : ' ||
1585: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1586: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1587: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1588:
1589: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id

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

1582: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1583:
1584: hr_utility.trace('Absence Start/End Date : ' ||
1585: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1586: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1587: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1588:
1589: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
1590: , lockedactid => r_get_archived_absence.org_asg_act_id);

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

1680:
1681: l_string_value := get_look_up_value('HR_NL_DS_REPORT_TYPE',l_type,l_lang);
1682: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1683:
1684: l_string_value := fnd_date.date_to_chardate(l_start_date);
1685: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1686:
1687: l_string_value := fnd_date.date_to_chardate(l_end_date);
1688: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;

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

1683:
1684: l_string_value := fnd_date.date_to_chardate(l_start_date);
1685: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1686:
1687: l_string_value := fnd_date.date_to_chardate(l_end_date);
1688: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1689:
1690: IF l_org_struct_id IS NOT NULL THEN
1691: OPEN c_get_hierarchy(l_org_struct_id);

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

1884: Tag(x,r,'SectorRisicogroep','_END_','X'); -- - risk sector grp*
1885: Tag(x,r,'NatuurlijkPersoon','_START_','B'); -- + employee data*
1886: Tag(x,r,'Burgerservicenr',l_emp_details.sofi_number,'B'); -- sofino*
1887: Tag(x,r,'Geboortedat',l_emp_details.date_of_birth,'X'); -- dob*
1888: Tag(x,r,'Geboortedat',fnd_date.date_to_chardate(
1889: to_date(l_emp_details.date_of_birth,'YYYYMMDD')),'R');
1890: Tag(x,r,'Geslacht',l_emp_details.gender,'X'); -- gender
1891: Tag(x,r,'Geslacht',get_look_up_value('HR_NL_DS_GENDER',
1892: l_emp_details.gender,l_lang),'R');

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

1901: Tag(x,r,'IndVerzoekTotIntrekken',get_look_up_value('HR_NL_YES_NO','Y',l_lang),'R');
1902: END IF;
1903: Tag(x,r,'ReferentieMelding',NVL(l_abs_info.sick_ref,l_emp_details.emp_num),'B'); -- sickness reference
1904: Tag(x,r,'DatTijdAanbiedenKetenpartij',to_char(SYSDATE, 'YYYYMMDDHH24MISS'),'X');-- time stamp
1905: Tag(x,r,'DatTijdAanbiedenKetenpartij',fnd_date.date_to_charDT(sysdate),'R');
1906: Tag(x,r,'DatOntvangstMeldingWerkgever',l_abs_info.noti_date,'X'); -- date of reporting
1907: Tag(x,r,'DatOntvangstMeldingWerkgever',fnd_date.date_to_chardate(
1908: to_date(l_abs_info.noti_date,'YYYYMMDD')),'R');
1909: Tag(x,r,'DatEersteAoDag',l_abs_info.lt_st_dt,'X'); -- start date sickness

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

1903: Tag(x,r,'ReferentieMelding',NVL(l_abs_info.sick_ref,l_emp_details.emp_num),'B'); -- sickness reference
1904: Tag(x,r,'DatTijdAanbiedenKetenpartij',to_char(SYSDATE, 'YYYYMMDDHH24MISS'),'X');-- time stamp
1905: Tag(x,r,'DatTijdAanbiedenKetenpartij',fnd_date.date_to_charDT(sysdate),'R');
1906: Tag(x,r,'DatOntvangstMeldingWerkgever',l_abs_info.noti_date,'X'); -- date of reporting
1907: Tag(x,r,'DatOntvangstMeldingWerkgever',fnd_date.date_to_chardate(
1908: to_date(l_abs_info.noti_date,'YYYYMMDD')),'R');
1909: Tag(x,r,'DatEersteAoDag',l_abs_info.lt_st_dt,'X'); -- start date sickness
1910: Tag(x,r,'DatEersteAoDag',fnd_date.date_to_chardate(
1911: to_date(l_abs_info.lt_st_dt,'YYYYMMDD')),'R');

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

1906: Tag(x,r,'DatOntvangstMeldingWerkgever',l_abs_info.noti_date,'X'); -- date of reporting
1907: Tag(x,r,'DatOntvangstMeldingWerkgever',fnd_date.date_to_chardate(
1908: to_date(l_abs_info.noti_date,'YYYYMMDD')),'R');
1909: Tag(x,r,'DatEersteAoDag',l_abs_info.lt_st_dt,'X'); -- start date sickness
1910: Tag(x,r,'DatEersteAoDag',fnd_date.date_to_chardate(
1911: to_date(l_abs_info.lt_st_dt,'YYYYMMDD')),'R');
1912: IF l_abs_info.partial_rec_dt IS NULL THEN
1913: Tag(x,r,'WerkhervattingVolledig','_START_','B'); -- + full recovery details
1914: Tag(x,r,'DatHersteld',l_abs_info.full_rec_dt,'X'); -- full recovery date

Line 1915: Tag(x,r,'DatHersteld',fnd_date.date_to_chardate(

1911: to_date(l_abs_info.lt_st_dt,'YYYYMMDD')),'R');
1912: IF l_abs_info.partial_rec_dt IS NULL THEN
1913: Tag(x,r,'WerkhervattingVolledig','_START_','B'); -- + full recovery details
1914: Tag(x,r,'DatHersteld',l_abs_info.full_rec_dt,'X'); -- full recovery date
1915: Tag(x,r,'DatHersteld',fnd_date.date_to_chardate(
1916: to_date(l_abs_info.full_rec_dt,'YYYYMMDD')),'R');
1917: Tag(x,r,'WerkhervattingVolledig','_END_','B'); -- - full recovery details
1918: ELSE
1919: Tag(x,r,'WerkhervattingGedeeltelijk','_START_','B'); -- + partial recovery details

Line 1921: Tag(x,r,'DatWerkhervatting',fnd_date.date_to_chardate(

1917: Tag(x,r,'WerkhervattingVolledig','_END_','B'); -- - full recovery details
1918: ELSE
1919: Tag(x,r,'WerkhervattingGedeeltelijk','_START_','B'); -- + partial recovery details
1920: Tag(x,r,'DatWerkhervatting',l_abs_info.partial_rec_dt,'X'); -- partial recovery date
1921: Tag(x,r,'DatWerkhervatting',fnd_date.date_to_chardate(
1922: to_date(l_abs_info.partial_rec_dt,'YYYYMMDD')),'R');
1923: Tag(x,r,'BedrSvLoonGedeeltelijkWerkTijdensAo',l_abs_info.daily_si,'B'); -- Daily SI wage
1924: Tag(x,r,'WerkhervattingGedeeltelijk','_END_','B'); -- - partial recovery details
1925: END IF;