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 294: g_start_date := fnd_date.canonical_to_date(l_start_date);

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

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

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

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

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

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

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

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

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

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

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

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

1006: END IF;
1007: hr_utility.set_location(' After Re Initializing the cursor record l_person_details with actual values. ',1100);
1008: -- Bug# 7005067
1009:
1010: l_per_emp_start_date := fnd_date.date_to_canonical(l_person_details.emp_start_date);
1011:
1012: i:=1;
1013: l_refund :='false';
1014: l_refund_usc :='false'; -- BUG 13359530

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

1280: --7529405
1281: --l_string := l_string || ''||EOL ;
1282: --
1283: l_string := l_string || ' 1284: l_string := l_string || ' datecommencement="'||to_char(fnd_date.canonical_to_date(l_emp_information.emp_start_dt),'DD/MM/YYYY')||'"';
1285: IF (to_number(to_char(to_date(l_start_date,'yyyy/mm/dd'),'yyyy')) >= 2012) THEN -- BUG 13359530
1286: l_string := l_string || ' works="'||substr(l_emp_information.unit,1,12)||'"';
1287: ELSE
1288: l_string := l_string || ' unit="'||substr(l_emp_information.unit,1,12)||'"';

Line 1296: IF fnd_date.canonical_to_date(l_emp_information.prv_emp_strt_dt) >= to_date ('01/01' || to_char (fnd_date.canonical_to_date(l_emp_information.prv_emp_end_dt)

1292: --
1293: IF l_emp_information.form_type = 'P45P3' THEN
1294: l_string := l_string || ' 1295: -- bug 13359530-1 added below if condition
1296: IF fnd_date.canonical_to_date(l_emp_information.prv_emp_strt_dt) >= to_date ('01/01' || to_char (fnd_date.canonical_to_date(l_emp_information.prv_emp_end_dt)
1297: ,'YYYY')
1298: ,'DD/MM/YYYY') THEN
1299: l_string := l_string || ' datecommencement="'||to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_strt_dt),'DD/MM/YYYY')||'"';
1300: END IF;

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

1295: -- bug 13359530-1 added below if condition
1296: IF fnd_date.canonical_to_date(l_emp_information.prv_emp_strt_dt) >= to_date ('01/01' || to_char (fnd_date.canonical_to_date(l_emp_information.prv_emp_end_dt)
1297: ,'YYYY')
1298: ,'DD/MM/YYYY') THEN
1299: l_string := l_string || ' datecommencement="'||to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_strt_dt),'DD/MM/YYYY')||'"';
1300: END IF;
1301: l_string := l_string || ' datecessation="'||to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_end_dt),'DD/MM/YYYY')||'"';
1302: l_string := l_string || ' paya="'||l_emp_information.paya||'"';
1303: l_string := l_string || ' taxa="'||l_emp_information.taxa||'"';

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

1297: ,'YYYY')
1298: ,'DD/MM/YYYY') THEN
1299: l_string := l_string || ' datecommencement="'||to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_strt_dt),'DD/MM/YYYY')||'"';
1300: END IF;
1301: l_string := l_string || ' datecessation="'||to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_end_dt),'DD/MM/YYYY')||'"';
1302: l_string := l_string || ' paya="'||l_emp_information.paya||'"';
1303: l_string := l_string || ' taxa="'||l_emp_information.taxa||'"';
1304: l_string := l_string || ' payb="'||l_emp_information.payb||'"';
1305: l_string := l_string || ' taxb="'||l_emp_information.taxb||'"';

Line 1309: IF to_number(to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_end_dt),'YYYY')) >= 2012 THEN

1305: l_string := l_string || ' taxb="'||l_emp_information.taxb||'"';
1306: l_string := l_string || ' refunded="'||l_emp_information.refunded||'"';
1307: l_string := l_string || ' payeregistered="'||l_emp_information.paye_regst||'"/>'||EOL ;
1308: -- bug 13359530
1309: IF to_number(to_char(fnd_date.canonical_to_date(l_emp_information.prv_emp_end_dt),'YYYY')) >= 2012 THEN
1310: l_string := l_string || ' 1311: l_string := l_string || ' totalpaytodate="'||l_emp_information.totalpaytodate||'"';
1312: l_string := l_string || ' totalusctodate="'||l_emp_information.totalusctodate||'"';
1313: l_string := l_string || ' totalpaythisemp="'||l_emp_information.totalpaythisemp||'"';