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_DK_SICKNESS_DP201 dependencies on HR_DK_UTILITY

Line 469: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(emp_rec.ename);

465: FETCH csr_le_cvr INTO le_cvr_rec;
466: CLOSE csr_le_cvr;
467: /*Bug 5049222 fix*/
468: xml_tab(xml_ctr).tagname := 'emp_name';
469: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(emp_rec.ename);
470: xml_ctr := xml_ctr +1;
471:
472: xml_tab(xml_ctr).tagname := 'address_line1';
473: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(emp_rec.address_line1,1,40));

Line 473: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(emp_rec.address_line1,1,40));

469: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(emp_rec.ename);
470: xml_ctr := xml_ctr +1;
471:
472: xml_tab(xml_ctr).tagname := 'address_line1';
473: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(emp_rec.address_line1,1,40));
474: xml_ctr := xml_ctr +1;
475:
476: xml_tab(xml_ctr).tagname := 'address_line2';
477: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(emp_rec.address_line2,1,40));

Line 477: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(emp_rec.address_line2,1,40));

473: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(emp_rec.address_line1,1,40));
474: xml_ctr := xml_ctr +1;
475:
476: xml_tab(xml_ctr).tagname := 'address_line2';
477: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(emp_rec.address_line2,1,40));
478: xml_ctr := xml_ctr +1;
479:
480: xml_tab(xml_ctr).tagname := 'postal_code';
481: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(emp_rec.postal_code,1,40));

Line 481: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(emp_rec.postal_code,1,40));

477: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(emp_rec.address_line2,1,40));
478: xml_ctr := xml_ctr +1;
479:
480: xml_tab(xml_ctr).tagname := 'postal_code';
481: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(emp_rec.postal_code,1,40));
482: xml_ctr := xml_ctr +1;
483:
484: xml_tab(xml_ctr).tagname := 'asg_num';
485: xml_tab(xml_ctr).tagvalue := asg_rec.asg_num;

Line 498: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.job_title);

494: xml_tab(xml_ctr).tagvalue := emp_rec.national_identifier;
495: xml_ctr := xml_ctr +1;
496:
497: xml_tab(xml_ctr).tagname := 'job_title';
498: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(asg_rec.job_title);
499: xml_ctr := xml_ctr +1;
500:
501: IF ((asg_rec.absence_start_date - asg_rec.asg_start_date) >= 90) THEN
502: xml_tab(xml_ctr).tagname := '13_weeks_yes';

Line 656: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_name);

652: xml_tab(xml_ctr).tagvalue := asg_rec.absence_end_date;
653: xml_ctr := xml_ctr +1;*/
654:
655: xml_tab(xml_ctr).tagname := 'le_name';
656: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_name);
657: xml_ctr := xml_ctr +1;
658:
659: xml_tab(xml_ctr).tagname := 'le_address_pcode';
660: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_address1)||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_postalcode);

Line 660: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_address1)||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_postalcode);

656: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_name);
657: xml_ctr := xml_ctr +1;
658:
659: xml_tab(xml_ctr).tagname := 'le_address_pcode';
660: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_address1)||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_postalcode);
661: xml_ctr := xml_ctr +1;
662:
663: xml_tab(xml_ctr).tagname := 'le_phone';
664: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_phone);

Line 664: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_phone);

660: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_address1)||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_postalcode);
661: xml_ctr := xml_ctr +1;
662:
663: xml_tab(xml_ctr).tagname := 'le_phone';
664: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_phone);
665: xml_ctr := xml_ctr +1;
666:
667: xml_tab(xml_ctr).tagname := 'le_email';
668: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_email);

Line 668: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_email);

664: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_phone);
665: xml_ctr := xml_ctr +1;
666:
667: xml_tab(xml_ctr).tagname := 'le_email';
668: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_email);
669: xml_ctr := xml_ctr +1;
670:
671: /*Before 8 weeks*/
672: /*IF ((asg_rec.absence_start_date - asg_rec.asg_start_date) < 57) THEN