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

Line 35: l_from_date := fnd_date.canonical_to_date(p_from_date);

31: /*Msg in the temorary table*/
32: -- To clear the PL/SQL Table values.
33: vXMLTable.DELETE;
34: vCtr := 1;
35: l_from_date := fnd_date.canonical_to_date(p_from_date);
36: l_to_date := fnd_date.canonical_to_date(p_to_date);
37: -- Changing the date parameters from canonical format to date format.
38: --l_from_date:= fnd_date.canonical_to_date(p_from_date);
39: --l_to_date := fnd_date.canonical_to_date(p_to_date);

Line 36: l_to_date := fnd_date.canonical_to_date(p_to_date);

32: -- To clear the PL/SQL Table values.
33: vXMLTable.DELETE;
34: vCtr := 1;
35: l_from_date := fnd_date.canonical_to_date(p_from_date);
36: l_to_date := fnd_date.canonical_to_date(p_to_date);
37: -- Changing the date parameters from canonical format to date format.
38: --l_from_date:= fnd_date.canonical_to_date(p_from_date);
39: --l_to_date := fnd_date.canonical_to_date(p_to_date);
40: -- Populate the Part 1 of 462 Report

Line 38: --l_from_date:= fnd_date.canonical_to_date(p_from_date);

34: vCtr := 1;
35: l_from_date := fnd_date.canonical_to_date(p_from_date);
36: l_to_date := fnd_date.canonical_to_date(p_to_date);
37: -- Changing the date parameters from canonical format to date format.
38: --l_from_date:= fnd_date.canonical_to_date(p_from_date);
39: --l_to_date := fnd_date.canonical_to_date(p_to_date);
40: -- Populate the Part 1 of 462 Report
41: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate New and Terminated Report');
42: /*Write message in temporary table*/

Line 39: --l_to_date := fnd_date.canonical_to_date(p_to_date);

35: l_from_date := fnd_date.canonical_to_date(p_from_date);
36: l_to_date := fnd_date.canonical_to_date(p_to_date);
37: -- Changing the date parameters from canonical format to date format.
38: --l_from_date:= fnd_date.canonical_to_date(p_from_date);
39: --l_to_date := fnd_date.canonical_to_date(p_to_date);
40: -- Populate the Part 1 of 462 Report
41: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate New and Terminated Report');
42: /*Write message in temporary table*/
43: /* Hardcode The values for the call to report5*/

Line 403: AND p_date between trunc(fnd_date.canonical_to_date(pei.pei_information3),'MM') and fnd_date.canonical_to_date(pei.pei_information4);

399: cursor get_passport_number (pn_person_id number,p_date date) is
400: SELECT pei.pei_information1 FROM per_people_extra_info pei
401: WHERE pei.person_id = pn_person_id
402: AND pei.information_type = 'SA_PASSPORT' AND pei.pei_information_category = 'SA_PASSPORT'
403: AND p_date between trunc(fnd_date.canonical_to_date(pei.pei_information3),'MM') and fnd_date.canonical_to_date(pei.pei_information4);
404: --cursor to get the Civil ID
405: cursor get_civil_id (p_person_id number,p_date date) is
406: SELECT NATIONAL_IDENTIFIER from per_all_people_f pap WHERE pap.person_id = p_person_id
407: and trunc(p_date,'MM') between trunc(pap.effective_start_date,'MM') and pap.effective_end_date;

Line 1576: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));

1572: vXMLTable(vCtr).TagName := 'G4-A-05-9';
1573: vXMLTable(vCtr).TagValue := SUBSTR(l_employer_gosi_number,1,1);
1574: vctr := vctr + 1;
1575: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1576: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));
1577: /***To fetch for pprevious months, using existing emp + new + terminated after 28th *****/
1578: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1579: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1580: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

Line 1627: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_effective_date));

1623: l_tot_prev_ann_saudi := l_prev_ann_saudi + l_prev_ann_saudi_new + l_prev_ann_saudi_ter + l_prev_ann_saudi_new_ter;
1624: l_tot_prev_haz_all := l_prev_haz_all + l_prev_haz_new_all + l_prev_haz_ter_all + l_prev_haz_new_ter_all;
1625: l_tot_prev_haz_ann_saudi := l_prev_haz_ann_saudi + l_prev_haz_ann_saudi_new + l_prev_haz_ann_saudi_ter + l_prev_haz_ann_saudi_new_ter;
1626: /*******************************************************/
1627: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_effective_date));
1628: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1629: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1630: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1631: l_curr_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);

Line 2085: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));

2081: and u.legislation_code = 'SA'
2082: and u.business_group_id is null
2083: and u.creator_type = 'B';
2084: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2085: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));
2086: /*Fetch contribution of employees who got terminated after 28th of previous month*/
2087: open csr_get_leav_assact;
2088: loop
2089: fetch csr_get_leav_assact into rec_leav_assact;

Line 2788: SELECT pei.pei_information1 , fnd_date.canonical_to_date(pei.pei_information3) , pei.pei_information5

2784: where ppf.person_id = l_person_id
2785: and l_date between ppf.effective_start_date and ppf.effective_end_date;
2786: --cursor to get the passport number and other details
2787: cursor get_passport_number (l_person_id number,l_date date) is
2788: SELECT pei.pei_information1 , fnd_date.canonical_to_date(pei.pei_information3) , pei.pei_information5
2789: FROM per_people_extra_info pei
2790: WHERE pei.person_id = l_person_id
2791: AND pei.information_type = 'SA_PASSPORT' AND pei.pei_information_category = 'SA_PASSPORT'
2792: AND l_date between trunc(fnd_date.canonical_to_date(pei.pei_information3),'MM') and fnd_date.canonical_to_date(pei.pei_information4);

Line 2792: AND l_date between trunc(fnd_date.canonical_to_date(pei.pei_information3),'MM') and fnd_date.canonical_to_date(pei.pei_information4);

2788: SELECT pei.pei_information1 , fnd_date.canonical_to_date(pei.pei_information3) , pei.pei_information5
2789: FROM per_people_extra_info pei
2790: WHERE pei.person_id = l_person_id
2791: AND pei.information_type = 'SA_PASSPORT' AND pei.pei_information_category = 'SA_PASSPORT'
2792: AND l_date between trunc(fnd_date.canonical_to_date(pei.pei_information3),'MM') and fnd_date.canonical_to_date(pei.pei_information4);
2793: --cursor to get the hafiza number
2794: cursor get_hafiza_number (l_person_id number) is
2795: SELECT pei.pei_information1,fnd_date.canonical_to_date(pei.pei_information2),pei.pei_information3
2796: FROM per_people_extra_info pei

Line 2795: SELECT pei.pei_information1,fnd_date.canonical_to_date(pei.pei_information2),pei.pei_information3

2791: AND pei.information_type = 'SA_PASSPORT' AND pei.pei_information_category = 'SA_PASSPORT'
2792: AND l_date between trunc(fnd_date.canonical_to_date(pei.pei_information3),'MM') and fnd_date.canonical_to_date(pei.pei_information4);
2793: --cursor to get the hafiza number
2794: cursor get_hafiza_number (l_person_id number) is
2795: SELECT pei.pei_information1,fnd_date.canonical_to_date(pei.pei_information2),pei.pei_information3
2796: FROM per_people_extra_info pei
2797: WHERE pei.person_id = l_person_id
2798: AND pei.information_type = 'SA_HAFIZA' AND pei.pei_information_category = 'SA_HAFIZA'
2799: AND rowid = (select max(rowid) from per_people_extra_info where person_id = l_person_id ) ;

Line 2934: --l_effective_date := last_day(fnd_date.canonical_to_date(p_effective_date));

2930: t_form_type(2) := 'TM';
2931: end if;
2932: vXMLTable.DELETE;
2933: vCtr := 1;
2934: --l_effective_date := last_day(fnd_date.canonical_to_date(p_effective_date));
2935: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
2936: insert into fnd_sessions(session_id,effective_date) values (userenv('sessionid'), l_effective_date);
2937: for m in t_form_type.first .. t_form_type.last
2938: loop

Line 2935: l_effective_date := fnd_date.canonical_to_date(p_effective_date);

2931: end if;
2932: vXMLTable.DELETE;
2933: vCtr := 1;
2934: --l_effective_date := last_day(fnd_date.canonical_to_date(p_effective_date));
2935: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
2936: insert into fnd_sessions(session_id,effective_date) values (userenv('sessionid'), l_effective_date);
2937: for m in t_form_type.first .. t_form_type.last
2938: loop
2939: l_form := t_form_type(m);

Line 3413: l_day := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'DD');

3409: vCtr := vCtr + 1;
3410: vXMLTable(vCtr).TagName := 'G3-C-06-8';
3411: vXMLTable(vCtr).TagValue := substr(to_char(l_employee_joining_date,'DD-MM-YYYY'),2,1);
3412: vCtr := vCtr + 1;
3413: l_day := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'DD');
3414: l_month := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'MM');
3415: l_year := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'YYYY');
3416: /** Added as per the GOSI Report 3+4 enhancement */
3417: vXMLTable(vCtr).TagName := 'G3-N-08';

Line 3414: l_month := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'MM');

3410: vXMLTable(vCtr).TagName := 'G3-C-06-8';
3411: vXMLTable(vCtr).TagValue := substr(to_char(l_employee_joining_date,'DD-MM-YYYY'),2,1);
3412: vCtr := vCtr + 1;
3413: l_day := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'DD');
3414: l_month := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'MM');
3415: l_year := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'YYYY');
3416: /** Added as per the GOSI Report 3+4 enhancement */
3417: vXMLTable(vCtr).TagName := 'G3-N-08';
3418: vXMLTable(vCtr).TagValue := l_street;

Line 3415: l_year := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'YYYY');

3411: vXMLTable(vCtr).TagValue := substr(to_char(l_employee_joining_date,'DD-MM-YYYY'),2,1);
3412: vCtr := vCtr + 1;
3413: l_day := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'DD');
3414: l_month := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'MM');
3415: l_year := to_char(fnd_date.canonical_to_date(l_annuities_join_date),'YYYY');
3416: /** Added as per the GOSI Report 3+4 enhancement */
3417: vXMLTable(vCtr).TagName := 'G3-N-08';
3418: vXMLTable(vCtr).TagValue := l_street;
3419: vCtr := vCtr + 1;

Line 3652: l_day := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'DD');

3648: vXMLTable(vCtr).TagName := 'G3-C-07-3';
3649: vXMLTable(vCtr).TagValue := l_day;
3650: vCtr := vCtr + 1;
3651: */
3652: l_day := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'DD');
3653: l_month := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'MM');
3654: l_year := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'YYYY');
3655: /* Cancelled as per the GOSI Report 3+4 enhancement.
3656: vXMLTable(vCtr).TagName := 'G3-C-08-1';

Line 3653: l_month := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'MM');

3649: vXMLTable(vCtr).TagValue := l_day;
3650: vCtr := vCtr + 1;
3651: */
3652: l_day := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'DD');
3653: l_month := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'MM');
3654: l_year := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'YYYY');
3655: /* Cancelled as per the GOSI Report 3+4 enhancement.
3656: vXMLTable(vCtr).TagName := 'G3-C-08-1';
3657: vXMLTable(vCtr).TagValue := l_year;

Line 3654: l_year := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'YYYY');

3650: vCtr := vCtr + 1;
3651: */
3652: l_day := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'DD');
3653: l_month := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'MM');
3654: l_year := to_char(fnd_date.canonical_to_date(l_hazards_join_date),'YYYY');
3655: /* Cancelled as per the GOSI Report 3+4 enhancement.
3656: vXMLTable(vCtr).TagName := 'G3-C-08-1';
3657: vXMLTable(vCtr).TagValue := l_year;
3658: vCtr := vCtr + 1;