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

Line 291: g_start_date := fnd_date.canonical_to_date(l_start_date);

287: ,g_business_group_id
288: ,g_person_id
289: ,g_employer_id);
290:
291: g_start_date := fnd_date.canonical_to_date(l_start_date);
292: g_end_date := fnd_date.canonical_to_date(l_end_date);
293:
294: OPEN csr_employer_details(g_employer_id, g_business_group_id);
295: FETCH csr_employer_details INTO l_employer_details;

Line 292: g_end_date := fnd_date.canonical_to_date(l_end_date);

288: ,g_person_id
289: ,g_employer_id);
290:
291: g_start_date := fnd_date.canonical_to_date(l_start_date);
292: g_end_date := fnd_date.canonical_to_date(l_end_date);
293:
294: OPEN csr_employer_details(g_employer_id, g_business_group_id);
295: FETCH csr_employer_details INTO l_employer_details;
296: CLOSE csr_employer_details;

Line 476: g_start_date := fnd_date.canonical_to_date(l_start_date);

472: ,g_business_group_id
473: ,g_person_id
474: ,g_employer_id);
475:
476: g_start_date := fnd_date.canonical_to_date(l_start_date);
477: g_end_date := fnd_date.canonical_to_date(l_end_date);
478: g_pact_id := pactid;
479:
480: hr_utility.set_location('after get_all_parameter called',225);

Line 477: g_end_date := fnd_date.canonical_to_date(l_end_date);

473: ,g_person_id
474: ,g_employer_id);
475:
476: g_start_date := fnd_date.canonical_to_date(l_start_date);
477: g_end_date := fnd_date.canonical_to_date(l_end_date);
478: g_pact_id := pactid;
479:
480: hr_utility.set_location('after get_all_parameter called',225);
481: hr_utility.set_location('report start date= '||g_start_date,300);

Line 742: g_start_date := fnd_date.canonical_to_date(l_start_date);

738: ,g_business_group_id
739: ,g_person_id
740: ,g_employer_id);
741:
742: g_start_date := fnd_date.canonical_to_date(l_start_date);
743: g_end_date := fnd_date.canonical_to_date(l_end_date);
744:
745: /*
746: OPEN csr_employer_details(g_employer_id, g_business_group_id);

Line 743: g_end_date := fnd_date.canonical_to_date(l_end_date);

739: ,g_person_id
740: ,g_employer_id);
741:
742: g_start_date := fnd_date.canonical_to_date(l_start_date);
743: g_end_date := fnd_date.canonical_to_date(l_end_date);
744:
745: /*
746: OPEN csr_employer_details(g_employer_id, g_business_group_id);
747: FETCH csr_employer_details INTO l_employer_details;

Line 1001: l_per_emp_start_date := fnd_date.date_to_canonical(l_person_details.emp_start_date);

997: END IF;
998: hr_utility.set_location(' After Re Initializing the cursor record l_person_details with actual values. ',1100);
999: -- Bug# 7005067
1000:
1001: l_per_emp_start_date := fnd_date.date_to_canonical(l_person_details.emp_start_date);
1002:
1003: i:=1;
1004: l_refund :='false';
1005: OPEN csr_get_assg_detail(p_assactid);

Line 1235: l_string := l_string || ' datecommencement="'||to_char(fnd_date.canonical_to_date(l_emp_information.emp_start_dt),'DD/MM/YYYY')||'"';

1231: l_string := l_string || ' addressline4="'||substr(l_emp_information.addr4,1,35)||'"/>'||EOL ;
1232: --l_string := l_string || ''||EOL ;
1233: --
1234: l_string := l_string || ' 1235: l_string := l_string || ' datecommencement="'||to_char(fnd_date.canonical_to_date(l_emp_information.emp_start_dt),'DD/MM/YYYY')||'"';
1236: l_string := l_string || ' unit="'||substr(l_emp_information.unit,1,12)||'"';
1237: l_string := l_string || ' freq="'||l_emp_information.frequency||'"/>'||EOL ;
1238: --l_string := l_string || ''||EOL ;
1239: --

Line 1242: l_string := l_string || ' datecommencement="'||to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_strt_dt),'DD/MM/YYYY')||'"';

1238: --l_string := l_string || ''||EOL ;
1239: --
1240: IF l_emp_information.form_type = 'P45P3' THEN
1241: l_string := l_string || ' 1242: l_string := l_string || ' datecommencement="'||to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_strt_dt),'DD/MM/YYYY')||'"';
1243: l_string := l_string || ' datecessation="'||to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_end_dt),'DD/MM/YYYY')||'"';
1244: l_string := l_string || ' paya="'||l_emp_information.paya||'"';
1245: l_string := l_string || ' taxa="'||l_emp_information.taxa||'"';
1246: l_string := l_string || ' payb="'||l_emp_information.payb||'"';

Line 1243: l_string := l_string || ' datecessation="'||to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_end_dt),'DD/MM/YYYY')||'"';

1239: --
1240: IF l_emp_information.form_type = 'P45P3' THEN
1241: l_string := l_string || ' 1242: l_string := l_string || ' datecommencement="'||to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_strt_dt),'DD/MM/YYYY')||'"';
1243: l_string := l_string || ' datecessation="'||to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_end_dt),'DD/MM/YYYY')||'"';
1244: l_string := l_string || ' paya="'||l_emp_information.paya||'"';
1245: l_string := l_string || ' taxa="'||l_emp_information.taxa||'"';
1246: l_string := l_string || ' payb="'||l_emp_information.payb||'"';
1247: l_string := l_string || ' taxb="'||l_emp_information.taxb||'"';