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_NL_WTS_REPORT dependencies on PAY_NL_XDO_REPORT

Line 466: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';

462: FETCH csr_get_bg_name INTO l_bg_name;
463: CLOSE csr_get_bg_name;
464: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);
465:
466: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
467: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
468: vCtr := vCtr + 1;
469: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
470: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));

Line 467: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;

463: CLOSE csr_get_bg_name;
464: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);
465:
466: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
467: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
468: vCtr := vCtr + 1;
469: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
470: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
471: vCtr := vCtr + 1;

Line 469: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';

465:
466: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
467: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
468: vCtr := vCtr + 1;
469: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
470: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
471: vCtr := vCtr + 1;
472: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
473: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;

Line 470: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));

466: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
467: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
468: vCtr := vCtr + 1;
469: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
470: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
471: vCtr := vCtr + 1;
472: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
473: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
474: vCtr := vCtr + 1;

Line 472: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';

468: vCtr := vCtr + 1;
469: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
470: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
471: vCtr := vCtr + 1;
472: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
473: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
474: vCtr := vCtr + 1;
475: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
476: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;

Line 473: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;

469: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
470: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
471: vCtr := vCtr + 1;
472: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
473: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
474: vCtr := vCtr + 1;
475: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
476: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
477: IF p_inc_sub_emp = 'N' THEN

Line 475: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';

471: vCtr := vCtr + 1;
472: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
473: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
474: vCtr := vCtr + 1;
475: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
476: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
477: IF p_inc_sub_emp = 'N' THEN
478: l_sub_employers := 'No';
479:

Line 476: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;

472: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
473: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
474: vCtr := vCtr + 1;
475: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
476: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
477: IF p_inc_sub_emp = 'N' THEN
478: l_sub_employers := 'No';
479:
480: ELSIF p_inc_sub_emp = 'Y' THEN

Line 486: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';

482: END IF;
483:
484:
485: vCtr := vCtr + 1;
486: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
487: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
488: vCtr := vCtr + 1;
489: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
490: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');

Line 487: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;

483:
484:
485: vCtr := vCtr + 1;
486: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
487: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
488: vCtr := vCtr + 1;
489: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
490: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
491: vCtr := vCtr + 1;

Line 489: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';

485: vCtr := vCtr + 1;
486: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
487: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
488: vCtr := vCtr + 1;
489: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
490: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
491: vCtr := vCtr + 1;
492: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
493: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');

Line 490: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');

486: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
487: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
488: vCtr := vCtr + 1;
489: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
490: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
491: vCtr := vCtr + 1;
492: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
493: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
494: vCtr := vCtr + 1;

Line 492: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';

488: vCtr := vCtr + 1;
489: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
490: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
491: vCtr := vCtr + 1;
492: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
493: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
494: vCtr := vCtr + 1;
495: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
496: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;

Line 493: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');

489: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
490: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
491: vCtr := vCtr + 1;
492: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
493: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
494: vCtr := vCtr + 1;
495: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
496: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
497: l_rp_tot_ed_subsidy := 0;

Line 495: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

491: vCtr := vCtr + 1;
492: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
493: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
494: vCtr := vCtr + 1;
495: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
496: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
497: l_rp_tot_ed_subsidy := 0;
498: l_rp_tot_lw_subsidy := 0;
499: l_rp_tot_ltu_subsidy:= 0;

Line 496: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;

492: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
493: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
494: vCtr := vCtr + 1;
495: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
496: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
497: l_rp_tot_ed_subsidy := 0;
498: l_rp_tot_lw_subsidy := 0;
499: l_rp_tot_ltu_subsidy:= 0;
500: l_rp_tot_ppl_subsidy:= 0;

Line 512: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';

508: AND l_payroll_id IS NOT NULL )
509: OR (NVL(l_person_id,-1)<> v_csr_get_record_details.person_id
510: AND l_person_id IS NOT NULL)) AND l_flag = FALSE THEN
511: vCtr := vCtr + 1;
512: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
513: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
514: l_emp_total_subsidy:=0;
515: vCtr := vCtr + 1;
516: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

Line 513: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /Bug 4506936/

509: OR (NVL(l_person_id,-1)<> v_csr_get_record_details.person_id
510: AND l_person_id IS NOT NULL)) AND l_flag = FALSE THEN
511: vCtr := vCtr + 1;
512: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
513: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
514: l_emp_total_subsidy:=0;
515: vCtr := vCtr + 1;
516: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
517: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

Line 516: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

512: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
513: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
514: l_emp_total_subsidy:=0;
515: vCtr := vCtr + 1;
516: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
517: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
518: l_emp := ' ';
519: l_payroll := ' ';
520: l_period := ' ';

Line 517: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

513: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
514: l_emp_total_subsidy:=0;
515: vCtr := vCtr + 1;
516: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
517: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
518: l_emp := ' ';
519: l_payroll := ' ';
520: l_period := ' ';
521: END IF;

Line 525: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';

521: END IF;
522:
523: IF v_csr_get_record_details.employer_name <> l_employer_name AND l_flag = FALSE THEN
524: vCtr := vCtr + 1;
525: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
526: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
527: END IF;
528: l_flag := FALSE;
529: IF v_csr_get_record_details.employer_name <> l_employer_name THEN

Line 526: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

522:
523: IF v_csr_get_record_details.employer_name <> l_employer_name AND l_flag = FALSE THEN
524: vCtr := vCtr + 1;
525: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
526: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
527: END IF;
528: l_flag := FALSE;
529: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
530: vCtr := vCtr + 1;

Line 531: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';

527: END IF;
528: l_flag := FALSE;
529: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
530: vCtr := vCtr + 1;
531: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
532: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
533: vCtr := vCtr + 1;
534: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;

Line 532: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;

528: l_flag := FALSE;
529: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
530: vCtr := vCtr + 1;
531: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
532: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
533: vCtr := vCtr + 1;
534: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
536: vCtr := vCtr + 1;

Line 534: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';

530: vCtr := vCtr + 1;
531: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
532: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
533: vCtr := vCtr + 1;
534: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
536: vCtr := vCtr + 1;
537: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;

Line 535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;

531: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
532: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
533: vCtr := vCtr + 1;
534: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
536: vCtr := vCtr + 1;
537: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
539: vCtr := vCtr + 1;

Line 537: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';

533: vCtr := vCtr + 1;
534: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
536: vCtr := vCtr + 1;
537: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
539: vCtr := vCtr + 1;
540: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
541: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;

Line 538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;

534: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
536: vCtr := vCtr + 1;
537: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
539: vCtr := vCtr + 1;
540: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
541: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
542: END IF;

Line 540: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';

536: vCtr := vCtr + 1;
537: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
539: vCtr := vCtr + 1;
540: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
541: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
542: END IF;
543: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
544: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN

Line 541: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;

537: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
539: vCtr := vCtr + 1;
540: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
541: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
542: END IF;
543: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
544: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
545: vCtr := vCtr + 1;

Line 546: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

542: END IF;
543: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
544: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
545: vCtr := vCtr + 1;
546: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
547: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
548: END IF;
549: l_asg_act_id := GET_LAST_ASG_ACT_ID(v_csr_get_record_details.person_id,v_csr_get_record_details.payroll_id,v_csr_get_record_details.date_earned);
550:

Line 547: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;

543: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
544: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
545: vCtr := vCtr + 1;
546: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
547: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
548: END IF;
549: l_asg_act_id := GET_LAST_ASG_ACT_ID(v_csr_get_record_details.person_id,v_csr_get_record_details.payroll_id,v_csr_get_record_details.date_earned);
550:
551: FOR v_csr_get_wts_elements

Line 557: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';

553: LOOP
554: -- IF v_csr_get_wts_elements.Wage_Tax_Subsidy <> 0 THEN
555: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_wts_elements.Subsidy_Element_Type_ID);
556: vCtr := vCtr + 1;
557: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
558: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
559:
560: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
561: vCtr := vCtr + 1;

Line 558: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;

554: -- IF v_csr_get_wts_elements.Wage_Tax_Subsidy <> 0 THEN
555: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_wts_elements.Subsidy_Element_Type_ID);
556: vCtr := vCtr + 1;
557: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
558: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
559:
560: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
561: vCtr := vCtr + 1;
562: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

Line 562: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

558: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
559:
560: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
561: vCtr := vCtr + 1;
562: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
563: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.employee_name;
564: l_emp := v_csr_get_wts_elements.employee_name;
565: ELSE
566: vCtr := vCtr + 1;

Line 563: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.employee_name;

559:
560: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
561: vCtr := vCtr + 1;
562: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
563: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.employee_name;
564: l_emp := v_csr_get_wts_elements.employee_name;
565: ELSE
566: vCtr := vCtr + 1;
567: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

Line 567: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

563: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.employee_name;
564: l_emp := v_csr_get_wts_elements.employee_name;
565: ELSE
566: vCtr := vCtr + 1;
567: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
568: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
569: END IF;
570:
571: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN

Line 568: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

564: l_emp := v_csr_get_wts_elements.employee_name;
565: ELSE
566: vCtr := vCtr + 1;
567: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
568: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
569: END IF;
570:
571: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN
572: vCtr := vCtr + 1;

Line 573: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

569: END IF;
570:
571: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN
572: vCtr := vCtr + 1;
573: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
574: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.payroll_name;
575: l_payroll := v_csr_get_wts_elements.payroll_name ;
576: ELSE
577: vCtr := vCtr + 1;

Line 574: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.payroll_name;

570:
571: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN
572: vCtr := vCtr + 1;
573: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
574: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.payroll_name;
575: l_payroll := v_csr_get_wts_elements.payroll_name ;
576: ELSE
577: vCtr := vCtr + 1;
578: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

Line 578: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

574: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.payroll_name;
575: l_payroll := v_csr_get_wts_elements.payroll_name ;
576: ELSE
577: vCtr := vCtr + 1;
578: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
579: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
580: END IF;
581:
582: IF l_period <> v_csr_get_wts_elements.current_period THEN

Line 579: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

575: l_payroll := v_csr_get_wts_elements.payroll_name ;
576: ELSE
577: vCtr := vCtr + 1;
578: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
579: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
580: END IF;
581:
582: IF l_period <> v_csr_get_wts_elements.current_period THEN
583: vCtr := vCtr + 1;

Line 584: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

580: END IF;
581:
582: IF l_period <> v_csr_get_wts_elements.current_period THEN
583: vCtr := vCtr + 1;
584: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
585: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.current_period;
586: l_period := v_csr_get_wts_elements.current_period;
587: ELSE
588: vCtr := vCtr + 1;

Line 585: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.current_period;

581:
582: IF l_period <> v_csr_get_wts_elements.current_period THEN
583: vCtr := vCtr + 1;
584: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
585: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.current_period;
586: l_period := v_csr_get_wts_elements.current_period;
587: ELSE
588: vCtr := vCtr + 1;
589: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

Line 589: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

585: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.current_period;
586: l_period := v_csr_get_wts_elements.current_period;
587: ELSE
588: vCtr := vCtr + 1;
589: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
590: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
591: END IF;
592:
593: vCtr := vCtr + 1;

Line 590: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

586: l_period := v_csr_get_wts_elements.current_period;
587: ELSE
588: vCtr := vCtr + 1;
589: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
590: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
591: END IF;
592:
593: vCtr := vCtr + 1;
594: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';

Line 594: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';

590: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
591: END IF;
592:
593: vCtr := vCtr + 1;
594: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
595: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
596: vCtr := vCtr + 1;
597: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
598: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');

Line 595: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;

591: END IF;
592:
593: vCtr := vCtr + 1;
594: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
595: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
596: vCtr := vCtr + 1;
597: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
598: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
599: vCtr := vCtr + 1;

Line 597: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';

593: vCtr := vCtr + 1;
594: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
595: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
596: vCtr := vCtr + 1;
597: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
598: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
599: vCtr := vCtr + 1;
600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');

Line 598: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');

594: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
595: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
596: vCtr := vCtr + 1;
597: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
598: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
599: vCtr := vCtr + 1;
600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
602: vCtr := vCtr + 1;

Line 600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';

596: vCtr := vCtr + 1;
597: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
598: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
599: vCtr := vCtr + 1;
600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
602: vCtr := vCtr + 1;
603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');

Line 601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');

597: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
598: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
599: vCtr := vCtr + 1;
600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
602: vCtr := vCtr + 1;
603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
605: vCtr := vCtr + 1;

Line 603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';

599: vCtr := vCtr + 1;
600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
602: vCtr := vCtr + 1;
603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
605: vCtr := vCtr + 1;
606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');

Line 604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');

600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
602: vCtr := vCtr + 1;
603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
605: vCtr := vCtr + 1;
606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
608: vCtr := vCtr + 1;

Line 606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';

602: vCtr := vCtr + 1;
603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
605: vCtr := vCtr + 1;
606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
608: vCtr := vCtr + 1;
609: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
610: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');

Line 607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');

603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
605: vCtr := vCtr + 1;
606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
608: vCtr := vCtr + 1;
609: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
610: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
611: vCtr := vCtr + 1;

Line 609: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';

605: vCtr := vCtr + 1;
606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
608: vCtr := vCtr + 1;
609: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
610: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
611: vCtr := vCtr + 1;
612: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
613: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

Line 610: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');

606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
608: vCtr := vCtr + 1;
609: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
610: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
611: vCtr := vCtr + 1;
612: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
613: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
614: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN

Line 612: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';

608: vCtr := vCtr + 1;
609: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
610: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
611: vCtr := vCtr + 1;
612: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
613: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
614: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
615: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2);
616: END IF;

Line 613: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

609: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
610: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
611: vCtr := vCtr + 1;
612: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
613: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
614: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
615: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2);
616: END IF;
617: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','EDUCATION') THEN

Line 634: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';

630: IN csr_get_retro_wts_elements(l_asg_act_id)
631: LOOP
632: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID); /* Bug 4517173*/
633: vCtr := vCtr + 1;
634: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
635: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
636:
637: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
638: vCtr := vCtr + 1;

Line 635: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;

631: LOOP
632: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID); /* Bug 4517173*/
633: vCtr := vCtr + 1;
634: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
635: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
636:
637: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
638: vCtr := vCtr + 1;
639: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

Line 639: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

635: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
636:
637: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
638: vCtr := vCtr + 1;
639: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
640: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
641: l_emp := v_csr_get_retro_wts_elements.employee_name;
642: ELSE
643: vCtr := vCtr + 1;

Line 640: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;

636:
637: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
638: vCtr := vCtr + 1;
639: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
640: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
641: l_emp := v_csr_get_retro_wts_elements.employee_name;
642: ELSE
643: vCtr := vCtr + 1;
644: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

Line 644: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

640: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
641: l_emp := v_csr_get_retro_wts_elements.employee_name;
642: ELSE
643: vCtr := vCtr + 1;
644: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
645: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
646: END IF;
647:
648: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN

Line 645: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

641: l_emp := v_csr_get_retro_wts_elements.employee_name;
642: ELSE
643: vCtr := vCtr + 1;
644: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
645: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
646: END IF;
647:
648: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
649: vCtr := vCtr + 1;

Line 650: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

646: END IF;
647:
648: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
649: vCtr := vCtr + 1;
650: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
651: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
652: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
653: ELSE
654: vCtr := vCtr + 1;

Line 651: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;

647:
648: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
649: vCtr := vCtr + 1;
650: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
651: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
652: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
653: ELSE
654: vCtr := vCtr + 1;
655: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

Line 655: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

651: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
652: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
653: ELSE
654: vCtr := vCtr + 1;
655: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
656: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
657: END IF;
658:
659: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN

Line 656: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

652: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
653: ELSE
654: vCtr := vCtr + 1;
655: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
656: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
657: END IF;
658:
659: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
660: vCtr := vCtr + 1;

Line 661: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

657: END IF;
658:
659: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
660: vCtr := vCtr + 1;
661: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
662: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
663: l_period := v_csr_get_retro_wts_elements.Retro_Period;
664: ELSE
665: vCtr := vCtr + 1;

Line 662: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;

658:
659: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
660: vCtr := vCtr + 1;
661: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
662: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
663: l_period := v_csr_get_retro_wts_elements.Retro_Period;
664: ELSE
665: vCtr := vCtr + 1;
666: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

Line 666: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

662: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
663: l_period := v_csr_get_retro_wts_elements.Retro_Period;
664: ELSE
665: vCtr := vCtr + 1;
666: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
667: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
668: END IF;
669:
670: vCtr := vCtr + 1;

Line 667: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

663: l_period := v_csr_get_retro_wts_elements.Retro_Period;
664: ELSE
665: vCtr := vCtr + 1;
666: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
667: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
668: END IF;
669:
670: vCtr := vCtr + 1;
671: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';

Line 671: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';

667: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
668: END IF;
669:
670: vCtr := vCtr + 1;
671: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
672: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
673: vCtr := vCtr + 1;
674: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');

Line 672: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);

668: END IF;
669:
670: vCtr := vCtr + 1;
671: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
672: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
673: vCtr := vCtr + 1;
674: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
676: vCtr := vCtr + 1;

Line 674: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';

670: vCtr := vCtr + 1;
671: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
672: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
673: vCtr := vCtr + 1;
674: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
676: vCtr := vCtr + 1;
677: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');

Line 675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');

671: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
672: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
673: vCtr := vCtr + 1;
674: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
676: vCtr := vCtr + 1;
677: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
679: vCtr := vCtr + 1;

Line 677: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';

673: vCtr := vCtr + 1;
674: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
676: vCtr := vCtr + 1;
677: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
679: vCtr := vCtr + 1;
680: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
681: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');

Line 678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');

674: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
676: vCtr := vCtr + 1;
677: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
679: vCtr := vCtr + 1;
680: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
681: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
682: vCtr := vCtr + 1;

Line 680: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';

676: vCtr := vCtr + 1;
677: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
679: vCtr := vCtr + 1;
680: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
681: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
682: vCtr := vCtr + 1;
683: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
684: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');

Line 681: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');

677: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
679: vCtr := vCtr + 1;
680: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
681: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
682: vCtr := vCtr + 1;
683: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
684: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
685: vCtr := vCtr + 1;

Line 683: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';

679: vCtr := vCtr + 1;
680: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
681: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
682: vCtr := vCtr + 1;
683: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
684: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
685: vCtr := vCtr + 1;
686: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
687: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');

Line 684: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');

680: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
681: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
682: vCtr := vCtr + 1;
683: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
684: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
685: vCtr := vCtr + 1;
686: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
687: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
688: vCtr := vCtr + 1;

Line 686: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';

682: vCtr := vCtr + 1;
683: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
684: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
685: vCtr := vCtr + 1;
686: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
687: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
688: vCtr := vCtr + 1;
689: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
690: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

Line 687: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');

683: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
684: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
685: vCtr := vCtr + 1;
686: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
687: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
688: vCtr := vCtr + 1;
689: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
690: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
691: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN

Line 689: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';

685: vCtr := vCtr + 1;
686: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
687: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
688: vCtr := vCtr + 1;
689: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
690: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
691: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
692: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2);
693: END IF;

Line 690: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

686: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
687: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
688: vCtr := vCtr + 1;
689: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
690: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
691: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
692: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2);
693: END IF;
694: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','EDUCATION') THEN

Line 713: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';

709: END LOOP;
710:
711: IF l_flag = FALSE THEN
712: vCtr := vCtr + 1;
713: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
714: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
715: l_emp_total_subsidy:=0;
716: vCtr := vCtr + 1;
717: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

Line 714: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');

710:
711: IF l_flag = FALSE THEN
712: vCtr := vCtr + 1;
713: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
714: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
715: l_emp_total_subsidy:=0;
716: vCtr := vCtr + 1;
717: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
718: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

Line 717: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

713: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
714: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
715: l_emp_total_subsidy:=0;
716: vCtr := vCtr + 1;
717: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
718: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
719:
720: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
721: vCtr := vCtr + 1;

Line 718: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

714: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
715: l_emp_total_subsidy:=0;
716: vCtr := vCtr + 1;
717: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
718: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
719:
720: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
721: vCtr := vCtr + 1;
722: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';

Line 722: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';

718: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
719:
720: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
721: vCtr := vCtr + 1;
722: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
723: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
724: END IF;
725: vCtr := vCtr + 1;
726: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';

Line 723: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

719:
720: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
721: vCtr := vCtr + 1;
722: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
723: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
724: END IF;
725: vCtr := vCtr + 1;
726: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
727: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');

Line 726: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';

722: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
723: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
724: END IF;
725: vCtr := vCtr + 1;
726: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
727: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
728: vCtr := vCtr + 1;
729: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
730: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');

Line 727: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');

723: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
724: END IF;
725: vCtr := vCtr + 1;
726: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
727: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
728: vCtr := vCtr + 1;
729: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
730: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
731: vCtr := vCtr + 1;

Line 729: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';

725: vCtr := vCtr + 1;
726: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
727: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
728: vCtr := vCtr + 1;
729: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
730: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
731: vCtr := vCtr + 1;
732: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
733: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');

Line 730: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');

726: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
727: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
728: vCtr := vCtr + 1;
729: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
730: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
731: vCtr := vCtr + 1;
732: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
733: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
734: vCtr := vCtr + 1;

Line 732: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';

728: vCtr := vCtr + 1;
729: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
730: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
731: vCtr := vCtr + 1;
732: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
733: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
734: vCtr := vCtr + 1;
735: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
736: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');

Line 733: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');

729: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
730: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
731: vCtr := vCtr + 1;
732: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
733: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
734: vCtr := vCtr + 1;
735: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
736: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
737:

Line 735: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';

731: vCtr := vCtr + 1;
732: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
733: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
734: vCtr := vCtr + 1;
735: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
736: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
737:
738: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
739: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );

Line 736: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');

732: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
733: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
734: vCtr := vCtr + 1;
735: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
736: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
737:
738: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
739: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );
740:

Line 739: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );

735: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
736: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
737:
738: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
739: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );
740:
741: END populate_wts_report_data;
742:
743:

Line 1072: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';

1068: FETCH csr_get_bg_name INTO l_bg_name;
1069: CLOSE csr_get_bg_name;
1070: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);
1071:
1072: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
1073: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
1074: vCtr := vCtr + 1;
1075: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1076: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));

Line 1073: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;

1069: CLOSE csr_get_bg_name;
1070: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);
1071:
1072: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
1073: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
1074: vCtr := vCtr + 1;
1075: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1076: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
1077: vCtr := vCtr + 1;

Line 1075: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';

1071:
1072: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
1073: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
1074: vCtr := vCtr + 1;
1075: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1076: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
1077: vCtr := vCtr + 1;
1078: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1079: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;

Line 1076: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));

1072: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
1073: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
1074: vCtr := vCtr + 1;
1075: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1076: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
1077: vCtr := vCtr + 1;
1078: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1079: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
1080: vCtr := vCtr + 1;

Line 1078: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';

1074: vCtr := vCtr + 1;
1075: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1076: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
1077: vCtr := vCtr + 1;
1078: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1079: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
1080: vCtr := vCtr + 1;
1081: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
1082: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;

Line 1079: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;

1075: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1076: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
1077: vCtr := vCtr + 1;
1078: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1079: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
1080: vCtr := vCtr + 1;
1081: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
1082: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
1083: IF p_inc_sub_emp = 'N' THEN

Line 1081: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';

1077: vCtr := vCtr + 1;
1078: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1079: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
1080: vCtr := vCtr + 1;
1081: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
1082: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
1083: IF p_inc_sub_emp = 'N' THEN
1084: l_sub_employers := 'No';
1085:

Line 1082: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;

1078: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1079: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
1080: vCtr := vCtr + 1;
1081: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
1082: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
1083: IF p_inc_sub_emp = 'N' THEN
1084: l_sub_employers := 'No';
1085:
1086: ELSIF p_inc_sub_emp = 'Y' THEN

Line 1092: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';

1088: END IF;
1089:
1090:
1091: vCtr := vCtr + 1;
1092: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
1093: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
1094: vCtr := vCtr + 1;
1095: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1096: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');

Line 1093: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;

1089:
1090:
1091: vCtr := vCtr + 1;
1092: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
1093: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
1094: vCtr := vCtr + 1;
1095: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1096: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
1097: vCtr := vCtr + 1;

Line 1095: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';

1091: vCtr := vCtr + 1;
1092: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
1093: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
1094: vCtr := vCtr + 1;
1095: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1096: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
1097: vCtr := vCtr + 1;
1098: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1099: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');

Line 1096: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');

1092: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
1093: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
1094: vCtr := vCtr + 1;
1095: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1096: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
1097: vCtr := vCtr + 1;
1098: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1099: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
1100: vCtr := vCtr + 1;

Line 1098: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';

1094: vCtr := vCtr + 1;
1095: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1096: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
1097: vCtr := vCtr + 1;
1098: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1099: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
1100: vCtr := vCtr + 1;
1101: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1102: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;

Line 1099: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');

1095: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1096: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
1097: vCtr := vCtr + 1;
1098: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1099: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
1100: vCtr := vCtr + 1;
1101: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1102: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
1103: l_rp_tot_ed_subsidy := 0;

Line 1101: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

1097: vCtr := vCtr + 1;
1098: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1099: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
1100: vCtr := vCtr + 1;
1101: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1102: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
1103: l_rp_tot_ed_subsidy := 0;
1104: l_rp_tot_lw_subsidy := 0;
1105: l_rp_tot_ltu_subsidy:= 0;

Line 1102: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;

1098: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1099: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
1100: vCtr := vCtr + 1;
1101: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1102: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
1103: l_rp_tot_ed_subsidy := 0;
1104: l_rp_tot_lw_subsidy := 0;
1105: l_rp_tot_ltu_subsidy:= 0;
1106: l_rp_tot_ppl_subsidy:= 0;

Line 1118: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';

1114: AND l_payroll_id IS NOT NULL )
1115: OR (NVL(l_person_id,-1)<> v_csr_get_record_details.person_id
1116: AND l_person_id IS NOT NULL)) AND l_flag = FALSE THEN
1117: vCtr := vCtr + 1;
1118: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1119: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
1120: l_emp_total_subsidy:=0;
1121: vCtr := vCtr + 1;
1122: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

Line 1119: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /Bug 4506936/

1115: OR (NVL(l_person_id,-1)<> v_csr_get_record_details.person_id
1116: AND l_person_id IS NOT NULL)) AND l_flag = FALSE THEN
1117: vCtr := vCtr + 1;
1118: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1119: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
1120: l_emp_total_subsidy:=0;
1121: vCtr := vCtr + 1;
1122: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1123: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

Line 1122: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

1118: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1119: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
1120: l_emp_total_subsidy:=0;
1121: vCtr := vCtr + 1;
1122: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1123: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1124: l_emp := ' ';
1125: l_payroll := ' ';
1126: l_period := ' ';

Line 1123: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

1119: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
1120: l_emp_total_subsidy:=0;
1121: vCtr := vCtr + 1;
1122: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1123: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1124: l_emp := ' ';
1125: l_payroll := ' ';
1126: l_period := ' ';
1127: END IF;

Line 1131: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';

1127: END IF;
1128:
1129: IF v_csr_get_record_details.employer_name <> l_employer_name AND l_flag = FALSE THEN
1130: vCtr := vCtr + 1;
1131: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1132: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1133: END IF;
1134: l_flag := FALSE;
1135: IF v_csr_get_record_details.employer_name <> l_employer_name THEN

Line 1132: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

1128:
1129: IF v_csr_get_record_details.employer_name <> l_employer_name AND l_flag = FALSE THEN
1130: vCtr := vCtr + 1;
1131: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1132: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1133: END IF;
1134: l_flag := FALSE;
1135: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
1136: vCtr := vCtr + 1;

Line 1137: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';

1133: END IF;
1134: l_flag := FALSE;
1135: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
1136: vCtr := vCtr + 1;
1137: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1139: vCtr := vCtr + 1;
1140: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;

Line 1138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;

1134: l_flag := FALSE;
1135: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
1136: vCtr := vCtr + 1;
1137: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1139: vCtr := vCtr + 1;
1140: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
1142: vCtr := vCtr + 1;

Line 1140: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';

1136: vCtr := vCtr + 1;
1137: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1139: vCtr := vCtr + 1;
1140: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
1142: vCtr := vCtr + 1;
1143: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;

Line 1141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;

1137: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1139: vCtr := vCtr + 1;
1140: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
1142: vCtr := vCtr + 1;
1143: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
1145: vCtr := vCtr + 1;

Line 1143: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';

1139: vCtr := vCtr + 1;
1140: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
1142: vCtr := vCtr + 1;
1143: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
1145: vCtr := vCtr + 1;
1146: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
1147: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;

Line 1144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;

1140: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
1142: vCtr := vCtr + 1;
1143: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
1145: vCtr := vCtr + 1;
1146: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
1147: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
1148: END IF;

Line 1146: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';

1142: vCtr := vCtr + 1;
1143: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
1145: vCtr := vCtr + 1;
1146: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
1147: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
1148: END IF;
1149: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
1150: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN

Line 1147: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;

1143: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
1145: vCtr := vCtr + 1;
1146: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
1147: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
1148: END IF;
1149: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
1150: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
1151: vCtr := vCtr + 1;

Line 1152: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

1148: END IF;
1149: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
1150: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
1151: vCtr := vCtr + 1;
1152: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1153: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1154: END IF;
1155: l_asg_act_id := GET_LAST_ASG_ACT_ID(v_csr_get_record_details.person_id,v_csr_get_record_details.payroll_id,v_csr_get_record_details.date_earned);
1156:

Line 1153: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;

1149: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
1150: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
1151: vCtr := vCtr + 1;
1152: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1153: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1154: END IF;
1155: l_asg_act_id := GET_LAST_ASG_ACT_ID(v_csr_get_record_details.person_id,v_csr_get_record_details.payroll_id,v_csr_get_record_details.date_earned);
1156:
1157: FOR v_csr_get_wts_elements

Line 1163: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';

1159: LOOP
1160: -- IF v_csr_get_wts_elements.Wage_Tax_Subsidy <> 0 THEN
1161: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_wts_elements.Subsidy_Element_Type_ID);
1162: vCtr := vCtr + 1;
1163: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1164: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1165:
1166: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
1167: vCtr := vCtr + 1;

Line 1164: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;

1160: -- IF v_csr_get_wts_elements.Wage_Tax_Subsidy <> 0 THEN
1161: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_wts_elements.Subsidy_Element_Type_ID);
1162: vCtr := vCtr + 1;
1163: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1164: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1165:
1166: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
1167: vCtr := vCtr + 1;
1168: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

Line 1168: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

1164: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1165:
1166: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
1167: vCtr := vCtr + 1;
1168: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1169: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.employee_name;
1170: l_emp := v_csr_get_wts_elements.employee_name;
1171: ELSE
1172: vCtr := vCtr + 1;

Line 1169: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.employee_name;

1165:
1166: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
1167: vCtr := vCtr + 1;
1168: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1169: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.employee_name;
1170: l_emp := v_csr_get_wts_elements.employee_name;
1171: ELSE
1172: vCtr := vCtr + 1;
1173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

Line 1173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

1169: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.employee_name;
1170: l_emp := v_csr_get_wts_elements.employee_name;
1171: ELSE
1172: vCtr := vCtr + 1;
1173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1175: END IF;
1176:
1177: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN

Line 1174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

1170: l_emp := v_csr_get_wts_elements.employee_name;
1171: ELSE
1172: vCtr := vCtr + 1;
1173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1175: END IF;
1176:
1177: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN
1178: vCtr := vCtr + 1;

Line 1179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

1175: END IF;
1176:
1177: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN
1178: vCtr := vCtr + 1;
1179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1180: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.payroll_name;
1181: l_payroll := v_csr_get_wts_elements.payroll_name ;
1182: ELSE
1183: vCtr := vCtr + 1;

Line 1180: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.payroll_name;

1176:
1177: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN
1178: vCtr := vCtr + 1;
1179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1180: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.payroll_name;
1181: l_payroll := v_csr_get_wts_elements.payroll_name ;
1182: ELSE
1183: vCtr := vCtr + 1;
1184: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

Line 1184: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

1180: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.payroll_name;
1181: l_payroll := v_csr_get_wts_elements.payroll_name ;
1182: ELSE
1183: vCtr := vCtr + 1;
1184: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1185: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1186: END IF;
1187:
1188: IF l_period <> v_csr_get_wts_elements.current_period THEN

Line 1185: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

1181: l_payroll := v_csr_get_wts_elements.payroll_name ;
1182: ELSE
1183: vCtr := vCtr + 1;
1184: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1185: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1186: END IF;
1187:
1188: IF l_period <> v_csr_get_wts_elements.current_period THEN
1189: vCtr := vCtr + 1;

Line 1190: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

1186: END IF;
1187:
1188: IF l_period <> v_csr_get_wts_elements.current_period THEN
1189: vCtr := vCtr + 1;
1190: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1191: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.current_period;
1192: l_period := v_csr_get_wts_elements.current_period;
1193: ELSE
1194: vCtr := vCtr + 1;

Line 1191: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.current_period;

1187:
1188: IF l_period <> v_csr_get_wts_elements.current_period THEN
1189: vCtr := vCtr + 1;
1190: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1191: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.current_period;
1192: l_period := v_csr_get_wts_elements.current_period;
1193: ELSE
1194: vCtr := vCtr + 1;
1195: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

Line 1195: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

1191: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.current_period;
1192: l_period := v_csr_get_wts_elements.current_period;
1193: ELSE
1194: vCtr := vCtr + 1;
1195: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1196: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1197: END IF;
1198:
1199: vCtr := vCtr + 1;

Line 1196: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

1192: l_period := v_csr_get_wts_elements.current_period;
1193: ELSE
1194: vCtr := vCtr + 1;
1195: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1196: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1197: END IF;
1198:
1199: vCtr := vCtr + 1;
1200: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';

Line 1200: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';

1196: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1197: END IF;
1198:
1199: vCtr := vCtr + 1;
1200: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1201: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
1202: vCtr := vCtr + 1;
1203: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1204: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');

Line 1201: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;

1197: END IF;
1198:
1199: vCtr := vCtr + 1;
1200: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1201: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
1202: vCtr := vCtr + 1;
1203: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1204: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
1205: vCtr := vCtr + 1;

Line 1203: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';

1199: vCtr := vCtr + 1;
1200: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1201: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
1202: vCtr := vCtr + 1;
1203: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1204: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
1205: vCtr := vCtr + 1;
1206: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1207: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');

Line 1204: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');

1200: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1201: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
1202: vCtr := vCtr + 1;
1203: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1204: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
1205: vCtr := vCtr + 1;
1206: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1207: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
1208: vCtr := vCtr + 1;

Line 1206: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';

1202: vCtr := vCtr + 1;
1203: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1204: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
1205: vCtr := vCtr + 1;
1206: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1207: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
1208: vCtr := vCtr + 1;
1209: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1210: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');

Line 1207: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');

1203: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1204: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
1205: vCtr := vCtr + 1;
1206: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1207: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
1208: vCtr := vCtr + 1;
1209: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1210: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
1211: vCtr := vCtr + 1;

Line 1209: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';

1205: vCtr := vCtr + 1;
1206: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1207: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
1208: vCtr := vCtr + 1;
1209: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1210: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
1211: vCtr := vCtr + 1;
1212: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1213: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');

Line 1210: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');

1206: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1207: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
1208: vCtr := vCtr + 1;
1209: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1210: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
1211: vCtr := vCtr + 1;
1212: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1213: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
1214: vCtr := vCtr + 1;

Line 1212: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';

1208: vCtr := vCtr + 1;
1209: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1210: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
1211: vCtr := vCtr + 1;
1212: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1213: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
1214: vCtr := vCtr + 1;
1215: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1216: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');

Line 1213: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');

1209: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1210: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
1211: vCtr := vCtr + 1;
1212: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1213: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
1214: vCtr := vCtr + 1;
1215: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1216: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
1217: vCtr := vCtr + 1;

Line 1215: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';

1211: vCtr := vCtr + 1;
1212: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1213: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
1214: vCtr := vCtr + 1;
1215: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1216: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
1217: vCtr := vCtr + 1;
1218: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

Line 1216: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');

1212: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1213: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
1214: vCtr := vCtr + 1;
1215: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1216: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
1217: vCtr := vCtr + 1;
1218: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1220:

Line 1218: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';

1214: vCtr := vCtr + 1;
1215: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1216: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
1217: vCtr := vCtr + 1;
1218: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1220:
1221: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
1222: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2);

Line 1219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

1215: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1216: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
1217: vCtr := vCtr + 1;
1218: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1220:
1221: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
1222: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2);
1223: END IF;

Line 1241: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';

1237: IN csr_get_retro_wts_elements(l_asg_act_id)
1238: LOOP
1239: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID); /* Bug 4517173*/
1240: vCtr := vCtr + 1;
1241: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1243:
1244: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
1245: vCtr := vCtr + 1;

Line 1242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;

1238: LOOP
1239: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID); /* Bug 4517173*/
1240: vCtr := vCtr + 1;
1241: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1243:
1244: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
1245: vCtr := vCtr + 1;
1246: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

Line 1246: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

1242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1243:
1244: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
1245: vCtr := vCtr + 1;
1246: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1247: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
1248: l_emp := v_csr_get_retro_wts_elements.employee_name;
1249: ELSE
1250: vCtr := vCtr + 1;

Line 1247: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;

1243:
1244: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
1245: vCtr := vCtr + 1;
1246: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1247: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
1248: l_emp := v_csr_get_retro_wts_elements.employee_name;
1249: ELSE
1250: vCtr := vCtr + 1;
1251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

Line 1251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

1247: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
1248: l_emp := v_csr_get_retro_wts_elements.employee_name;
1249: ELSE
1250: vCtr := vCtr + 1;
1251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1252: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1253: END IF;
1254:
1255: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN

Line 1252: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

1248: l_emp := v_csr_get_retro_wts_elements.employee_name;
1249: ELSE
1250: vCtr := vCtr + 1;
1251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1252: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1253: END IF;
1254:
1255: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
1256: vCtr := vCtr + 1;

Line 1257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

1253: END IF;
1254:
1255: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
1256: vCtr := vCtr + 1;
1257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1258: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
1259: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
1260: ELSE
1261: vCtr := vCtr + 1;

Line 1258: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;

1254:
1255: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
1256: vCtr := vCtr + 1;
1257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1258: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
1259: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
1260: ELSE
1261: vCtr := vCtr + 1;
1262: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

Line 1262: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

1258: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
1259: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
1260: ELSE
1261: vCtr := vCtr + 1;
1262: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1264: END IF;
1265:
1266: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN

Line 1263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

1259: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
1260: ELSE
1261: vCtr := vCtr + 1;
1262: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1264: END IF;
1265:
1266: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
1267: vCtr := vCtr + 1;

Line 1268: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

1264: END IF;
1265:
1266: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
1267: vCtr := vCtr + 1;
1268: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
1270: l_period := v_csr_get_retro_wts_elements.Retro_Period;
1271: ELSE
1272: vCtr := vCtr + 1;

Line 1269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;

1265:
1266: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
1267: vCtr := vCtr + 1;
1268: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
1270: l_period := v_csr_get_retro_wts_elements.Retro_Period;
1271: ELSE
1272: vCtr := vCtr + 1;
1273: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

Line 1273: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

1269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
1270: l_period := v_csr_get_retro_wts_elements.Retro_Period;
1271: ELSE
1272: vCtr := vCtr + 1;
1273: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1274: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1275: END IF;
1276:
1277: vCtr := vCtr + 1;

Line 1274: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;

1270: l_period := v_csr_get_retro_wts_elements.Retro_Period;
1271: ELSE
1272: vCtr := vCtr + 1;
1273: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1274: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1275: END IF;
1276:
1277: vCtr := vCtr + 1;
1278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';

Line 1278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';

1274: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1275: END IF;
1276:
1277: vCtr := vCtr + 1;
1278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
1280: vCtr := vCtr + 1;
1281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');

Line 1279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);

1275: END IF;
1276:
1277: vCtr := vCtr + 1;
1278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
1280: vCtr := vCtr + 1;
1281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
1283: vCtr := vCtr + 1;

Line 1281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';

1277: vCtr := vCtr + 1;
1278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
1280: vCtr := vCtr + 1;
1281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
1283: vCtr := vCtr + 1;
1284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');

Line 1282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');

1278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
1280: vCtr := vCtr + 1;
1281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
1283: vCtr := vCtr + 1;
1284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
1286: vCtr := vCtr + 1;

Line 1284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';

1280: vCtr := vCtr + 1;
1281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
1283: vCtr := vCtr + 1;
1284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
1286: vCtr := vCtr + 1;
1287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');

Line 1285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');

1281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
1283: vCtr := vCtr + 1;
1284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
1286: vCtr := vCtr + 1;
1287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
1289: vCtr := vCtr + 1;

Line 1287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';

1283: vCtr := vCtr + 1;
1284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
1286: vCtr := vCtr + 1;
1287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
1289: vCtr := vCtr + 1;
1290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');

Line 1288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');

1284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
1286: vCtr := vCtr + 1;
1287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
1289: vCtr := vCtr + 1;
1290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
1292: vCtr := vCtr + 1;

Line 1290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';

1286: vCtr := vCtr + 1;
1287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
1289: vCtr := vCtr + 1;
1290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
1292: vCtr := vCtr + 1;
1293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');

Line 1291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');

1287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
1289: vCtr := vCtr + 1;
1290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
1292: vCtr := vCtr + 1;
1293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
1295: vCtr := vCtr + 1;

Line 1293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';

1289: vCtr := vCtr + 1;
1290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
1292: vCtr := vCtr + 1;
1293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
1295: vCtr := vCtr + 1;
1296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

Line 1294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');

1290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
1292: vCtr := vCtr + 1;
1293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
1295: vCtr := vCtr + 1;
1296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1298: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN

Line 1296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';

1292: vCtr := vCtr + 1;
1293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
1295: vCtr := vCtr + 1;
1296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1298: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
1299: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2);
1300: END IF;

Line 1297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

1293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
1295: vCtr := vCtr + 1;
1296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1298: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
1299: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2);
1300: END IF;
1301: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','EDUCATION') THEN

Line 1320: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';

1316: END LOOP;
1317:
1318: IF l_flag = FALSE THEN
1319: vCtr := vCtr + 1;
1320: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1321: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
1322: l_emp_total_subsidy:=0;
1323: vCtr := vCtr + 1;
1324: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

Line 1321: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');

1317:
1318: IF l_flag = FALSE THEN
1319: vCtr := vCtr + 1;
1320: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1321: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
1322: l_emp_total_subsidy:=0;
1323: vCtr := vCtr + 1;
1324: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1325: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

Line 1324: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

1320: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1321: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
1322: l_emp_total_subsidy:=0;
1323: vCtr := vCtr + 1;
1324: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1325: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1326:
1327: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
1328: vCtr := vCtr + 1;

Line 1325: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

1321: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
1322: l_emp_total_subsidy:=0;
1323: vCtr := vCtr + 1;
1324: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1325: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1326:
1327: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
1328: vCtr := vCtr + 1;
1329: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';

Line 1329: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';

1325: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1326:
1327: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
1328: vCtr := vCtr + 1;
1329: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1330: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1331: END IF;
1332: vCtr := vCtr + 1;
1333: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';

Line 1330: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

1326:
1327: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
1328: vCtr := vCtr + 1;
1329: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1330: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1331: END IF;
1332: vCtr := vCtr + 1;
1333: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
1334: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');

Line 1333: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';

1329: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1330: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1331: END IF;
1332: vCtr := vCtr + 1;
1333: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
1334: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
1335: vCtr := vCtr + 1;
1336: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1337: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');

Line 1334: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');

1330: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1331: END IF;
1332: vCtr := vCtr + 1;
1333: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
1334: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
1335: vCtr := vCtr + 1;
1336: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1337: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
1338: vCtr := vCtr + 1;

Line 1336: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';

1332: vCtr := vCtr + 1;
1333: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
1334: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
1335: vCtr := vCtr + 1;
1336: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1337: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
1338: vCtr := vCtr + 1;
1339: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1340: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');

Line 1337: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');

1333: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
1334: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
1335: vCtr := vCtr + 1;
1336: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1337: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
1338: vCtr := vCtr + 1;
1339: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1340: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
1341: vCtr := vCtr + 1;

Line 1339: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';

1335: vCtr := vCtr + 1;
1336: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1337: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
1338: vCtr := vCtr + 1;
1339: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1340: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
1341: vCtr := vCtr + 1;
1342: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
1343: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');

Line 1340: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');

1336: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1337: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
1338: vCtr := vCtr + 1;
1339: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1340: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
1341: vCtr := vCtr + 1;
1342: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
1343: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
1344:

Line 1342: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';

1338: vCtr := vCtr + 1;
1339: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1340: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
1341: vCtr := vCtr + 1;
1342: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
1343: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
1344:
1345: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
1346: pay_nl_xdo_Report.WritetoCLOB_rtf_1(p_xml);

Line 1343: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');

1339: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1340: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
1341: vCtr := vCtr + 1;
1342: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
1343: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
1344:
1345: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
1346: pay_nl_xdo_Report.WritetoCLOB_rtf_1(p_xml);
1347:

Line 1346: pay_nl_xdo_Report.WritetoCLOB_rtf_1(p_xml);

1342: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
1343: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
1344:
1345: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
1346: pay_nl_xdo_Report.WritetoCLOB_rtf_1(p_xml);
1347:
1348: END populate_wts_report_data_1;
1349:
1350: