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

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

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

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

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

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

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

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

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

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

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

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

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

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

1304:
1305: /* labor relation info */
1306: CURSOR csr_get_lbr_info (p_assignment_id IN NUMBER
1307: , p_start_date IN DATE) IS
1308: SELECT to_char(fnd_date.canonical_to_date (paei.aei_information1),'YYYYMMDD') start_date
1309: ,to_char(fnd_date.canonical_to_date (paei.aei_information2),'YYYYMMDD') end_date
1310: ,paei.aei_information3 code_kind
1311: FROM per_assignment_extra_info paei
1312: WHERE paei.assignment_id = p_assignment_id

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

1305: /* labor relation info */
1306: CURSOR csr_get_lbr_info (p_assignment_id IN NUMBER
1307: , p_start_date IN DATE) IS
1308: SELECT to_char(fnd_date.canonical_to_date (paei.aei_information1),'YYYYMMDD') start_date
1309: ,to_char(fnd_date.canonical_to_date (paei.aei_information2),'YYYYMMDD') end_date
1310: ,paei.aei_information3 code_kind
1311: FROM per_assignment_extra_info paei
1312: WHERE paei.assignment_id = p_assignment_id
1313: AND paei.aei_information_category = 'NL_LBR'

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

1310: ,paei.aei_information3 code_kind
1311: FROM per_assignment_extra_info paei
1312: WHERE paei.assignment_id = p_assignment_id
1313: AND paei.aei_information_category = 'NL_LBR'
1314: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1315: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1316: ,hr_general.end_of_time);
1317: /**************************************************************************/
1318:

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

1311: FROM per_assignment_extra_info paei
1312: WHERE paei.assignment_id = p_assignment_id
1313: AND paei.aei_information_category = 'NL_LBR'
1314: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1315: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1316: ,hr_general.end_of_time);
1317: /**************************************************************************/
1318:
1319: CURSOR csr_already_exists(p_abs_att_id NUMBER) IS

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

1333: FROM pay_action_information pai
1334: WHERE pai.assignment_id = p_assignment_id
1335: AND pai.action_information_category = 'NL_LTSR_ABS_INFO'
1336: AND pai.action_information30 = 'N'
1337: AND fnd_date.canonical_to_date (pai.action_information2) = p_abs_start_date;
1338:
1339: /**************************************************************************/
1340:
1341: CURSOR get_archived_absence(p_assignment_id IN NUMBER

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

1362: p_type = 'R'
1363: )
1364: )
1365: AND (
1366: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)
1367: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)
1368: );
1369: /**************************************************************************/
1370: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS

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

1363: )
1364: )
1365: AND (
1366: p_start_date <= fnd_date.canonical_to_date (pai.action_information2)
1367: AND p_end_date >= fnd_date.canonical_to_date (pai.action_information3)
1368: );
1369: /**************************************************************************/
1370: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS
1371: SELECT ppa.payroll_action_id

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

1512: , p_source_id => NULL
1513: , p_source_text => NULL
1514: , p_action_information_category => 'NL_LTSRR_ABS_INFO'
1515: , p_action_information1 => l_abs_attendence_id
1516: , p_action_information2 => fnd_date.date_to_canonical(l_abs_end_date + 1)
1517: , p_action_information3 => fnd_date.date_to_canonical(l_abs_start_date)
1518: , p_action_information4 => 'LTSRR'
1519: , p_action_information5 => v_csr_get_abs_details.person_id
1520: , p_action_information6 => v_csr_get_abs_details.ass_id

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

1513: , p_source_text => NULL
1514: , p_action_information_category => 'NL_LTSRR_ABS_INFO'
1515: , p_action_information1 => l_abs_attendence_id
1516: , p_action_information2 => fnd_date.date_to_canonical(l_abs_end_date + 1)
1517: , p_action_information3 => fnd_date.date_to_canonical(l_abs_start_date)
1518: , p_action_information4 => 'LTSRR'
1519: , p_action_information5 => v_csr_get_abs_details.person_id
1520: , p_action_information6 => v_csr_get_abs_details.ass_id
1521: , p_action_information7 => v_csr_get_abs_details.sick_ref

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

1609:
1610: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1611:
1612: hr_utility.trace('Absence Start/End Date : ' ||
1613: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1614: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1615: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1616:
1617: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id

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

1610: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1611:
1612: hr_utility.trace('Absence Start/End Date : ' ||
1613: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1614: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1615: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1616:
1617: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
1618: , lockedactid => r_get_archived_absence.org_asg_act_id);

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

1703:
1704: l_string_value := get_look_up_value('HR_NL_DS_REPORT_TYPE',l_type,l_lang);
1705: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1706:
1707: l_string_value := fnd_date.date_to_chardate(l_start_date);
1708: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1709:
1710: l_string_value := fnd_date.date_to_chardate(l_end_date);
1711: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;

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

1706:
1707: l_string_value := fnd_date.date_to_chardate(l_start_date);
1708: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1709:
1710: l_string_value := fnd_date.date_to_chardate(l_end_date);
1711: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
1712:
1713: IF l_org_struct_id IS NOT NULL THEN
1714: OPEN c_get_hierarchy(l_org_struct_id);

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

1909: Tag(x,r,'SectorRisicogroep','_END_','X'); -- - risk sector grp*
1910: Tag(x,r,'NatuurlijkPersoon','_START_','B'); -- + employee data*
1911: Tag(x,r,'Burgerservicenr',l_emp_details.sofi_number,'B'); -- sofino*
1912: Tag(x,r,'Geboortedat',l_emp_details.date_of_birth,'X'); -- dob*
1913: Tag(x,r,'Geboortedat',fnd_date.date_to_chardate(
1914: to_date(l_emp_details.date_of_birth,'YYYYMMDD')),'R');
1915: Tag(x,r,'Geslacht',l_emp_details.gender,'X'); -- gender
1916: Tag(x,r,'Geslacht',get_look_up_value('HR_NL_DS_GENDER',
1917: l_emp_details.gender,l_lang),'R');

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

1924: OR l_emp_details.lbr_end_date IS NOT NULL
1925: THEN
1926: Tag(x,r,'DatB',l_emp_details.lbr_st_date,'X'); -- start dt income rel
1927: Tag(x,r,'DatE',l_emp_details.lbr_end_date,'X'); -- end dt income rel
1928: Tag(x,r,'DatB',fnd_date.date_to_chardate(
1929: to_date(l_emp_details.lbr_st_date,'YYYYMMDD')),'R');
1930: Tag(x,r,'DatE',fnd_date.date_to_chardate(
1931: to_date(l_emp_details.lbr_end_date,'YYYYMMDD')),'R');
1932: ELSE

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

1926: Tag(x,r,'DatB',l_emp_details.lbr_st_date,'X'); -- start dt income rel
1927: Tag(x,r,'DatE',l_emp_details.lbr_end_date,'X'); -- end dt income rel
1928: Tag(x,r,'DatB',fnd_date.date_to_chardate(
1929: to_date(l_emp_details.lbr_st_date,'YYYYMMDD')),'R');
1930: Tag(x,r,'DatE',fnd_date.date_to_chardate(
1931: to_date(l_emp_details.lbr_end_date,'YYYYMMDD')),'R');
1932: ELSE
1933: Tag(x,r,'DatB',l_emp_details.ass_start_date,'X'); -- start dt assignment
1934: Tag(x,r,'DatE',l_emp_details.ass_end_date,'X'); -- end dt assignment

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

1931: to_date(l_emp_details.lbr_end_date,'YYYYMMDD')),'R');
1932: ELSE
1933: Tag(x,r,'DatB',l_emp_details.ass_start_date,'X'); -- start dt assignment
1934: Tag(x,r,'DatE',l_emp_details.ass_end_date,'X'); -- end dt assignment
1935: Tag(x,r,'DatB',fnd_date.date_to_chardate(
1936: to_date(l_emp_details.ass_start_date,'YYYYMMDD')),'R');
1937: Tag(x,r,'DatE',fnd_date.date_to_chardate(
1938: to_date(l_emp_details.ass_end_date,'YYYYMMDD')),'R');
1939: END IF;

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

1933: Tag(x,r,'DatB',l_emp_details.ass_start_date,'X'); -- start dt assignment
1934: Tag(x,r,'DatE',l_emp_details.ass_end_date,'X'); -- end dt assignment
1935: Tag(x,r,'DatB',fnd_date.date_to_chardate(
1936: to_date(l_emp_details.ass_start_date,'YYYYMMDD')),'R');
1937: Tag(x,r,'DatE',fnd_date.date_to_chardate(
1938: to_date(l_emp_details.ass_end_date,'YYYYMMDD')),'R');
1939: END IF;
1940: Tag(x,r,'MeldingHersteldLangdurigAO','_START_','B'); -- + LT sickness recovery details
1941: IF (p_type = 'R' AND l_withdrawl_flag.flag = 'Y') OR p_type = 'W' THEN

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

1943: Tag(x,r,'IndVerzoekTotIntrekken',get_look_up_value('HR_NL_YES_NO','Y',l_lang),'R');
1944: END IF;
1945: Tag(x,r,'ReferentieMelding',nvl(l_abs_info.sick_ref,l_emp_details.emp_num),'B'); -- sickness reference
1946: Tag(x,r,'DatHersteld',l_abs_info.lts_rec_dt,'X'); -- first day of full recovery
1947: Tag(x,r,'DatHersteld',fnd_date.date_to_chardate(
1948: to_date(l_abs_info.lts_rec_dt,'YYYYMMDD')),'R');
1949: Tag(x,r,'DatEersteAoDag',l_abs_info.lts_st_dt,'X'); -- start date sickness
1950: Tag(x,r,'DatEersteAoDag',fnd_date.date_to_chardate(
1951: to_date(l_abs_info.lts_st_dt,'YYYYMMDD')),'R');

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

1946: Tag(x,r,'DatHersteld',l_abs_info.lts_rec_dt,'X'); -- first day of full recovery
1947: Tag(x,r,'DatHersteld',fnd_date.date_to_chardate(
1948: to_date(l_abs_info.lts_rec_dt,'YYYYMMDD')),'R');
1949: Tag(x,r,'DatEersteAoDag',l_abs_info.lts_st_dt,'X'); -- start date sickness
1950: Tag(x,r,'DatEersteAoDag',fnd_date.date_to_chardate(
1951: to_date(l_abs_info.lts_st_dt,'YYYYMMDD')),'R');
1952: IF l_abs_info.contact_name IS NOT NULL
1953: OR l_abs_info.est_name IS NOT NULL
1954: OR l_abs_info.contact_gender IS NOT NULL