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 535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';

531: FETCH csr_get_bg_name INTO l_bg_name;
532: CLOSE csr_get_bg_name;
533: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);
534:
535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
536: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
537: vCtr := vCtr + 1;
538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
539: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));

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

532: CLOSE csr_get_bg_name;
533: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);
534:
535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
536: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
537: vCtr := vCtr + 1;
538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
539: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
540: vCtr := vCtr + 1;

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

534:
535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
536: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
537: vCtr := vCtr + 1;
538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
539: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
540: vCtr := vCtr + 1;
541: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
542: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;

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

535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
536: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
537: vCtr := vCtr + 1;
538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
539: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
540: vCtr := vCtr + 1;
541: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
542: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
543: vCtr := vCtr + 1;

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

537: vCtr := vCtr + 1;
538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
539: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
540: vCtr := vCtr + 1;
541: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
542: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
543: vCtr := vCtr + 1;
544: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
545: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;

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

538: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
539: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
540: vCtr := vCtr + 1;
541: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
542: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
543: vCtr := vCtr + 1;
544: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
545: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
546: IF p_inc_sub_emp = 'N' THEN

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

540: vCtr := vCtr + 1;
541: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
542: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
543: vCtr := vCtr + 1;
544: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
545: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
546: IF p_inc_sub_emp = 'N' THEN
547: l_sub_employers := 'No';
548:

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

541: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
542: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
543: vCtr := vCtr + 1;
544: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
545: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
546: IF p_inc_sub_emp = 'N' THEN
547: l_sub_employers := 'No';
548:
549: ELSIF p_inc_sub_emp = 'Y' THEN

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

551: END IF;
552:
553:
554: vCtr := vCtr + 1;
555: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
556: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
557: vCtr := vCtr + 1;
558: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
559: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');

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

552:
553:
554: vCtr := vCtr + 1;
555: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
556: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
557: vCtr := vCtr + 1;
558: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
559: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
560: vCtr := vCtr + 1;

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

554: vCtr := vCtr + 1;
555: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
556: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
557: vCtr := vCtr + 1;
558: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
559: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
560: vCtr := vCtr + 1;
561: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
562: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');

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

555: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
556: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
557: vCtr := vCtr + 1;
558: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
559: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
560: vCtr := vCtr + 1;
561: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
562: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
563: vCtr := vCtr + 1;

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

557: vCtr := vCtr + 1;
558: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
559: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
560: vCtr := vCtr + 1;
561: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
562: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
563: vCtr := vCtr + 1;
564: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
565: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;

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

558: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
559: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
560: vCtr := vCtr + 1;
561: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
562: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
563: vCtr := vCtr + 1;
564: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
565: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
566: l_rp_tot_ed_subsidy := 0;

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

560: vCtr := vCtr + 1;
561: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
562: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
563: vCtr := vCtr + 1;
564: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
565: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
566: l_rp_tot_ed_subsidy := 0;
567: l_rp_tot_lw_subsidy := 0;
568: l_rp_tot_ltu_subsidy:= 0;

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

561: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
562: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
563: vCtr := vCtr + 1;
564: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
565: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
566: l_rp_tot_ed_subsidy := 0;
567: l_rp_tot_lw_subsidy := 0;
568: l_rp_tot_ltu_subsidy:= 0;
569: l_rp_tot_ppl_subsidy:= 0;

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

577: AND l_payroll_id IS NOT NULL )
578: OR (NVL(l_person_id,-1)<> v_csr_get_record_details.person_id
579: AND l_person_id IS NOT NULL)) AND l_flag = FALSE THEN
580: vCtr := vCtr + 1;
581: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
582: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
583: l_emp_total_subsidy:=0;
584: vCtr := vCtr + 1;
585: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

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

578: OR (NVL(l_person_id,-1)<> v_csr_get_record_details.person_id
579: AND l_person_id IS NOT NULL)) AND l_flag = FALSE THEN
580: vCtr := vCtr + 1;
581: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
582: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
583: l_emp_total_subsidy:=0;
584: vCtr := vCtr + 1;
585: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
586: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

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

581: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
582: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
583: l_emp_total_subsidy:=0;
584: vCtr := vCtr + 1;
585: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
586: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
587: l_emp := ' ';
588: l_payroll := ' ';
589: l_period := ' ';

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

582: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
583: l_emp_total_subsidy:=0;
584: vCtr := vCtr + 1;
585: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
586: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
587: l_emp := ' ';
588: l_payroll := ' ';
589: l_period := ' ';
590: END IF;

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

590: END IF;
591:
592: IF v_csr_get_record_details.employer_name <> l_employer_name AND l_flag = FALSE THEN
593: vCtr := vCtr + 1;
594: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
595: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
596: END IF;
597: l_flag := FALSE;
598: IF v_csr_get_record_details.employer_name <> l_employer_name THEN

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

591:
592: IF v_csr_get_record_details.employer_name <> l_employer_name AND l_flag = FALSE THEN
593: vCtr := vCtr + 1;
594: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
595: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
596: END IF;
597: l_flag := FALSE;
598: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
599: vCtr := vCtr + 1;

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

596: END IF;
597: l_flag := FALSE;
598: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
599: vCtr := vCtr + 1;
600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
602: vCtr := vCtr + 1;
603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;

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

597: l_flag := FALSE;
598: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
599: vCtr := vCtr + 1;
600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
602: vCtr := vCtr + 1;
603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
605: vCtr := vCtr + 1;

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

599: vCtr := vCtr + 1;
600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
602: vCtr := vCtr + 1;
603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
605: vCtr := vCtr + 1;
606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;

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

600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
602: vCtr := vCtr + 1;
603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
605: vCtr := vCtr + 1;
606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
608: vCtr := vCtr + 1;

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

602: vCtr := vCtr + 1;
603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
605: vCtr := vCtr + 1;
606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
608: vCtr := vCtr + 1;
609: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
610: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;

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

603: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
604: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
605: vCtr := vCtr + 1;
606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
608: vCtr := vCtr + 1;
609: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
610: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
611: END IF;

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

605: vCtr := vCtr + 1;
606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
608: vCtr := vCtr + 1;
609: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
610: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
611: END IF;
612: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
613: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN

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

606: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
607: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
608: vCtr := vCtr + 1;
609: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
610: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
611: END IF;
612: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
613: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
614: vCtr := vCtr + 1;

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

611: END IF;
612: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
613: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
614: vCtr := vCtr + 1;
615: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
616: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
617: END IF;
618: 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);
619:

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

612: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
613: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
614: vCtr := vCtr + 1;
615: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
616: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
617: END IF;
618: 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);
619:
620: FOR v_csr_get_wts_elements

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

622: LOOP
623: -- IF v_csr_get_wts_elements.Wage_Tax_Subsidy <> 0 THEN
624: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_wts_elements.Subsidy_Element_Type_ID);
625: vCtr := vCtr + 1;
626: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
627: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
628:
629: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
630: vCtr := vCtr + 1;

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

623: -- IF v_csr_get_wts_elements.Wage_Tax_Subsidy <> 0 THEN
624: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_wts_elements.Subsidy_Element_Type_ID);
625: vCtr := vCtr + 1;
626: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
627: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
628:
629: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
630: vCtr := vCtr + 1;
631: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

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

627: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
628:
629: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
630: vCtr := vCtr + 1;
631: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
632: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.employee_name;
633: l_emp := v_csr_get_wts_elements.employee_name;
634: ELSE
635: vCtr := vCtr + 1;

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

628:
629: IF l_emp <> v_csr_get_wts_elements.employee_name THEN
630: vCtr := vCtr + 1;
631: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
632: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.employee_name;
633: l_emp := v_csr_get_wts_elements.employee_name;
634: ELSE
635: vCtr := vCtr + 1;
636: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

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

632: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.employee_name;
633: l_emp := v_csr_get_wts_elements.employee_name;
634: ELSE
635: vCtr := vCtr + 1;
636: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
637: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
638: END IF;
639:
640: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN

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

633: l_emp := v_csr_get_wts_elements.employee_name;
634: ELSE
635: vCtr := vCtr + 1;
636: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
637: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
638: END IF;
639:
640: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN
641: vCtr := vCtr + 1;

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

638: END IF;
639:
640: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN
641: vCtr := vCtr + 1;
642: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
643: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.payroll_name;
644: l_payroll := v_csr_get_wts_elements.payroll_name ;
645: ELSE
646: vCtr := vCtr + 1;

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

639:
640: IF l_payroll <> v_csr_get_wts_elements.payroll_name THEN
641: vCtr := vCtr + 1;
642: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
643: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.payroll_name;
644: l_payroll := v_csr_get_wts_elements.payroll_name ;
645: ELSE
646: vCtr := vCtr + 1;
647: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

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

643: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.payroll_name;
644: l_payroll := v_csr_get_wts_elements.payroll_name ;
645: ELSE
646: vCtr := vCtr + 1;
647: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
648: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
649: END IF;
650:
651: IF l_period <> v_csr_get_wts_elements.current_period THEN

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

644: l_payroll := v_csr_get_wts_elements.payroll_name ;
645: ELSE
646: vCtr := vCtr + 1;
647: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
648: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
649: END IF;
650:
651: IF l_period <> v_csr_get_wts_elements.current_period THEN
652: vCtr := vCtr + 1;

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

649: END IF;
650:
651: IF l_period <> v_csr_get_wts_elements.current_period THEN
652: vCtr := vCtr + 1;
653: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
654: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.current_period;
655: l_period := v_csr_get_wts_elements.current_period;
656: ELSE
657: vCtr := vCtr + 1;

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

650:
651: IF l_period <> v_csr_get_wts_elements.current_period THEN
652: vCtr := vCtr + 1;
653: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
654: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.current_period;
655: l_period := v_csr_get_wts_elements.current_period;
656: ELSE
657: vCtr := vCtr + 1;
658: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

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

654: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_wts_elements.current_period;
655: l_period := v_csr_get_wts_elements.current_period;
656: ELSE
657: vCtr := vCtr + 1;
658: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
659: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
660: END IF;
661:
662: vCtr := vCtr + 1;

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

655: l_period := v_csr_get_wts_elements.current_period;
656: ELSE
657: vCtr := vCtr + 1;
658: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
659: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
660: END IF;
661:
662: vCtr := vCtr + 1;
663: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';

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

659: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
660: END IF;
661:
662: vCtr := vCtr + 1;
663: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
664: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
665: vCtr := vCtr + 1;
666: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
667: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');

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

660: END IF;
661:
662: vCtr := vCtr + 1;
663: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
664: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
665: vCtr := vCtr + 1;
666: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
667: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
668: vCtr := vCtr + 1;

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

662: vCtr := vCtr + 1;
663: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
664: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
665: vCtr := vCtr + 1;
666: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
667: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
668: vCtr := vCtr + 1;
669: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
670: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');

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

663: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
664: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
665: vCtr := vCtr + 1;
666: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
667: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
668: vCtr := vCtr + 1;
669: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
670: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
671: vCtr := vCtr + 1;

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

665: vCtr := vCtr + 1;
666: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
667: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
668: vCtr := vCtr + 1;
669: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
670: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
671: vCtr := vCtr + 1;
672: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
673: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');

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

666: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
667: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Basis_Salary,2),'99G999G999D90MI');
668: vCtr := vCtr + 1;
669: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
670: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
671: vCtr := vCtr + 1;
672: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
673: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
674: vCtr := vCtr + 1;

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

668: vCtr := vCtr + 1;
669: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
670: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
671: vCtr := vCtr + 1;
672: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
673: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
674: vCtr := vCtr + 1;
675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
676: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');

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

669: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
670: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Part_Time_Percentage,4),'999D9990MI');
671: vCtr := vCtr + 1;
672: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
673: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
674: vCtr := vCtr + 1;
675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
676: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
677: vCtr := vCtr + 1;

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

671: vCtr := vCtr + 1;
672: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
673: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
674: vCtr := vCtr + 1;
675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
676: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
677: vCtr := vCtr + 1;
678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
679: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');

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

672: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
673: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Working_Hours,2),'999D90MI');
674: vCtr := vCtr + 1;
675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
676: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
677: vCtr := vCtr + 1;
678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
679: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
680: vCtr := vCtr + 1;

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

674: vCtr := vCtr + 1;
675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
676: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
677: vCtr := vCtr + 1;
678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
679: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
680: vCtr := vCtr + 1;
681: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
682: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

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

675: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
676: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
677: vCtr := vCtr + 1;
678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
679: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
680: vCtr := vCtr + 1;
681: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
682: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
683: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN

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

677: vCtr := vCtr + 1;
678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
679: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
680: vCtr := vCtr + 1;
681: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
682: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
683: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
684: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2);
685: END IF;

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

678: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
679: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
680: vCtr := vCtr + 1;
681: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
682: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
683: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
684: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2);
685: END IF;
686: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','EDUCATION') THEN

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

699: IN csr_get_retro_wts_elements(l_asg_act_id)
700: LOOP
701: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID); /* Bug 4517173*/
702: vCtr := vCtr + 1;
703: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
704: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
705:
706: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
707: vCtr := vCtr + 1;

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

700: LOOP
701: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID); /* Bug 4517173*/
702: vCtr := vCtr + 1;
703: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
704: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
705:
706: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
707: vCtr := vCtr + 1;
708: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

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

704: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
705:
706: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
707: vCtr := vCtr + 1;
708: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
709: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
710: l_emp := v_csr_get_retro_wts_elements.employee_name;
711: ELSE
712: vCtr := vCtr + 1;

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

705:
706: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
707: vCtr := vCtr + 1;
708: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
709: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
710: l_emp := v_csr_get_retro_wts_elements.employee_name;
711: ELSE
712: vCtr := vCtr + 1;
713: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

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

709: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
710: l_emp := v_csr_get_retro_wts_elements.employee_name;
711: ELSE
712: vCtr := vCtr + 1;
713: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
714: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
715: END IF;
716:
717: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN

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

710: l_emp := v_csr_get_retro_wts_elements.employee_name;
711: ELSE
712: vCtr := vCtr + 1;
713: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
714: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
715: END IF;
716:
717: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
718: vCtr := vCtr + 1;

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

715: END IF;
716:
717: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
718: vCtr := vCtr + 1;
719: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
720: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
721: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
722: ELSE
723: vCtr := vCtr + 1;

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

716:
717: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
718: vCtr := vCtr + 1;
719: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
720: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
721: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
722: ELSE
723: vCtr := vCtr + 1;
724: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

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

720: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
721: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
722: ELSE
723: vCtr := vCtr + 1;
724: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
725: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
726: END IF;
727:
728: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN

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

721: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
722: ELSE
723: vCtr := vCtr + 1;
724: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
725: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
726: END IF;
727:
728: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
729: vCtr := vCtr + 1;

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

726: END IF;
727:
728: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
729: vCtr := vCtr + 1;
730: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
731: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
732: l_period := v_csr_get_retro_wts_elements.Retro_Period;
733: ELSE
734: vCtr := vCtr + 1;

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

727:
728: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
729: vCtr := vCtr + 1;
730: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
731: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
732: l_period := v_csr_get_retro_wts_elements.Retro_Period;
733: ELSE
734: vCtr := vCtr + 1;
735: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

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

731: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
732: l_period := v_csr_get_retro_wts_elements.Retro_Period;
733: ELSE
734: vCtr := vCtr + 1;
735: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
736: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
737: END IF;
738:
739: vCtr := vCtr + 1;

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

732: l_period := v_csr_get_retro_wts_elements.Retro_Period;
733: ELSE
734: vCtr := vCtr + 1;
735: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
736: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
737: END IF;
738:
739: vCtr := vCtr + 1;
740: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';

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

736: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
737: END IF;
738:
739: vCtr := vCtr + 1;
740: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
741: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
742: vCtr := vCtr + 1;
743: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
744: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');

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

737: END IF;
738:
739: vCtr := vCtr + 1;
740: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
741: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
742: vCtr := vCtr + 1;
743: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
744: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
745: vCtr := vCtr + 1;

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

739: vCtr := vCtr + 1;
740: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
741: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
742: vCtr := vCtr + 1;
743: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
744: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
745: vCtr := vCtr + 1;
746: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
747: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');

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

740: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
741: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
742: vCtr := vCtr + 1;
743: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
744: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
745: vCtr := vCtr + 1;
746: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
747: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
748: vCtr := vCtr + 1;

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

742: vCtr := vCtr + 1;
743: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
744: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
745: vCtr := vCtr + 1;
746: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
747: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
748: vCtr := vCtr + 1;
749: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
750: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');

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

743: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
744: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
745: vCtr := vCtr + 1;
746: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
747: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
748: vCtr := vCtr + 1;
749: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
750: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
751: vCtr := vCtr + 1;

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

745: vCtr := vCtr + 1;
746: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
747: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
748: vCtr := vCtr + 1;
749: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
750: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
751: vCtr := vCtr + 1;
752: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
753: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');

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

746: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
747: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
748: vCtr := vCtr + 1;
749: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
750: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
751: vCtr := vCtr + 1;
752: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
753: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
754: vCtr := vCtr + 1;

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

748: vCtr := vCtr + 1;
749: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
750: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
751: vCtr := vCtr + 1;
752: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
753: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
754: vCtr := vCtr + 1;
755: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
756: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');

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

749: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
750: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
751: vCtr := vCtr + 1;
752: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
753: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
754: vCtr := vCtr + 1;
755: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
756: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
757: vCtr := vCtr + 1;

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

751: vCtr := vCtr + 1;
752: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
753: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
754: vCtr := vCtr + 1;
755: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
756: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
757: vCtr := vCtr + 1;
758: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
759: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

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

752: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
753: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
754: vCtr := vCtr + 1;
755: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
756: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
757: vCtr := vCtr + 1;
758: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
759: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
760: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN

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

754: vCtr := vCtr + 1;
755: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
756: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
757: vCtr := vCtr + 1;
758: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
759: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
760: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
761: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2);
762: END IF;

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

755: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
756: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
757: vCtr := vCtr + 1;
758: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
759: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
760: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
761: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2);
762: END IF;
763: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','EDUCATION') THEN

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

778: END LOOP;
779:
780: IF l_flag = FALSE THEN
781: vCtr := vCtr + 1;
782: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
783: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
784: l_emp_total_subsidy:=0;
785: vCtr := vCtr + 1;
786: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

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

779:
780: IF l_flag = FALSE THEN
781: vCtr := vCtr + 1;
782: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
783: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
784: l_emp_total_subsidy:=0;
785: vCtr := vCtr + 1;
786: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
787: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

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

782: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
783: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
784: l_emp_total_subsidy:=0;
785: vCtr := vCtr + 1;
786: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
787: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
788:
789: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
790: vCtr := vCtr + 1;

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

783: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
784: l_emp_total_subsidy:=0;
785: vCtr := vCtr + 1;
786: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
787: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
788:
789: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
790: vCtr := vCtr + 1;
791: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';

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

787: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
788:
789: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
790: vCtr := vCtr + 1;
791: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
792: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
793: END IF;
794: vCtr := vCtr + 1;
795: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';

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

788:
789: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
790: vCtr := vCtr + 1;
791: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
792: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
793: END IF;
794: vCtr := vCtr + 1;
795: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
796: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');

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

791: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
792: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
793: END IF;
794: vCtr := vCtr + 1;
795: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
796: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
797: vCtr := vCtr + 1;
798: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
799: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');

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

792: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
793: END IF;
794: vCtr := vCtr + 1;
795: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
796: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
797: vCtr := vCtr + 1;
798: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
799: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
800: vCtr := vCtr + 1;

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

794: vCtr := vCtr + 1;
795: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
796: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
797: vCtr := vCtr + 1;
798: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
799: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
800: vCtr := vCtr + 1;
801: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
802: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');

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

795: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
796: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
797: vCtr := vCtr + 1;
798: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
799: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
800: vCtr := vCtr + 1;
801: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
802: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
803: vCtr := vCtr + 1;

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

797: vCtr := vCtr + 1;
798: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
799: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
800: vCtr := vCtr + 1;
801: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
802: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
803: vCtr := vCtr + 1;
804: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
805: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');

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

798: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
799: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
800: vCtr := vCtr + 1;
801: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
802: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
803: vCtr := vCtr + 1;
804: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
805: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
806:

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

800: vCtr := vCtr + 1;
801: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
802: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
803: vCtr := vCtr + 1;
804: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
805: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
806:
807: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
808: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );

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

801: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
802: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
803: vCtr := vCtr + 1;
804: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
805: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
806:
807: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
808: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );
809:

Line 808: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );

804: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
805: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
806:
807: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
808: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );
809:
810: END populate_wts_report_data;
811:
812:

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

1146: FETCH csr_get_bg_name INTO l_bg_name;
1147: CLOSE csr_get_bg_name;
1148: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);
1149:
1150: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
1151: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
1152: vCtr := vCtr + 1;
1153: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1154: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));

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

1147: CLOSE csr_get_bg_name;
1148: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);
1149:
1150: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
1151: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
1152: vCtr := vCtr + 1;
1153: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1154: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
1155: vCtr := vCtr + 1;

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

1149:
1150: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
1151: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
1152: vCtr := vCtr + 1;
1153: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1154: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
1155: vCtr := vCtr + 1;
1156: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;

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

1150: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
1151: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
1152: vCtr := vCtr + 1;
1153: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1154: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
1155: vCtr := vCtr + 1;
1156: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
1158: vCtr := vCtr + 1;

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

1152: vCtr := vCtr + 1;
1153: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1154: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
1155: vCtr := vCtr + 1;
1156: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
1158: vCtr := vCtr + 1;
1159: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
1160: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;

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

1153: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
1154: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(fnd_date.canonical_to_date(p_eff_date));
1155: vCtr := vCtr + 1;
1156: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
1158: vCtr := vCtr + 1;
1159: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
1160: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
1161: IF p_inc_sub_emp = 'N' THEN

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

1155: vCtr := vCtr + 1;
1156: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
1158: vCtr := vCtr + 1;
1159: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
1160: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
1161: IF p_inc_sub_emp = 'N' THEN
1162: l_sub_employers := 'No';
1163:

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

1156: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
1157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
1158: vCtr := vCtr + 1;
1159: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
1160: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_top_org;
1161: IF p_inc_sub_emp = 'N' THEN
1162: l_sub_employers := 'No';
1163:
1164: ELSIF p_inc_sub_emp = 'Y' THEN

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

1166: END IF;
1167:
1168:
1169: vCtr := vCtr + 1;
1170: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
1171: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
1172: vCtr := vCtr + 1;
1173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');

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

1167:
1168:
1169: vCtr := vCtr + 1;
1170: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
1171: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
1172: vCtr := vCtr + 1;
1173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
1175: vCtr := vCtr + 1;

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

1169: vCtr := vCtr + 1;
1170: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
1171: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
1172: vCtr := vCtr + 1;
1173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
1175: vCtr := vCtr + 1;
1176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');

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

1170: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYERS';
1171: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_sub_employers;
1172: vCtr := vCtr + 1;
1173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
1175: vCtr := vCtr + 1;
1176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
1178: vCtr := vCtr + 1;

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

1172: vCtr := vCtr + 1;
1173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
1175: vCtr := vCtr + 1;
1176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
1178: vCtr := vCtr + 1;
1179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1180: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;

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

1173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_FROM';
1174: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_month_from,'MMYYYY'),'Month YYYY');
1175: vCtr := vCtr + 1;
1176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
1178: vCtr := vCtr + 1;
1179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1180: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
1181: l_rp_tot_ed_subsidy := 0;

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

1175: vCtr := vCtr + 1;
1176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
1178: vCtr := vCtr + 1;
1179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1180: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
1181: l_rp_tot_ed_subsidy := 0;
1182: l_rp_tot_lw_subsidy := 0;
1183: l_rp_tot_ltu_subsidy:= 0;

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

1176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MONTH_TO';
1177: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')),'Month YYYY');
1178: vCtr := vCtr + 1;
1179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1180: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employee;
1181: l_rp_tot_ed_subsidy := 0;
1182: l_rp_tot_lw_subsidy := 0;
1183: l_rp_tot_ltu_subsidy:= 0;
1184: l_rp_tot_ppl_subsidy:= 0;

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

1192: AND l_payroll_id IS NOT NULL )
1193: OR (NVL(l_person_id,-1)<> v_csr_get_record_details.person_id
1194: AND l_person_id IS NOT NULL)) AND l_flag = FALSE THEN
1195: vCtr := vCtr + 1;
1196: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1197: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
1198: l_emp_total_subsidy:=0;
1199: vCtr := vCtr + 1;
1200: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

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

1193: OR (NVL(l_person_id,-1)<> v_csr_get_record_details.person_id
1194: AND l_person_id IS NOT NULL)) AND l_flag = FALSE THEN
1195: vCtr := vCtr + 1;
1196: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1197: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
1198: l_emp_total_subsidy:=0;
1199: vCtr := vCtr + 1;
1200: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1201: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

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

1196: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1197: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
1198: l_emp_total_subsidy:=0;
1199: vCtr := vCtr + 1;
1200: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1201: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1202: l_emp := ' ';
1203: l_payroll := ' ';
1204: l_period := ' ';

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

1197: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'99G999G999D90MI'); /*Bug 4506936*/
1198: l_emp_total_subsidy:=0;
1199: vCtr := vCtr + 1;
1200: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1201: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1202: l_emp := ' ';
1203: l_payroll := ' ';
1204: l_period := ' ';
1205: END IF;

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

1205: END IF;
1206:
1207: IF v_csr_get_record_details.employer_name <> l_employer_name AND l_flag = FALSE THEN
1208: vCtr := vCtr + 1;
1209: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1210: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1211: END IF;
1212: l_flag := FALSE;
1213: IF v_csr_get_record_details.employer_name <> l_employer_name THEN

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

1206:
1207: IF v_csr_get_record_details.employer_name <> l_employer_name AND l_flag = FALSE THEN
1208: vCtr := vCtr + 1;
1209: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1210: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1211: END IF;
1212: l_flag := FALSE;
1213: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
1214: vCtr := vCtr + 1;

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

1211: END IF;
1212: l_flag := FALSE;
1213: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
1214: vCtr := vCtr + 1;
1215: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1216: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1217: vCtr := vCtr + 1;
1218: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;

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

1212: l_flag := FALSE;
1213: IF v_csr_get_record_details.employer_name <> l_employer_name THEN
1214: vCtr := vCtr + 1;
1215: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1216: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1217: vCtr := vCtr + 1;
1218: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
1220: vCtr := vCtr + 1;

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

1214: vCtr := vCtr + 1;
1215: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1216: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1217: vCtr := vCtr + 1;
1218: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
1220: vCtr := vCtr + 1;
1221: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1222: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;

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

1215: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1216: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1217: vCtr := vCtr + 1;
1218: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
1220: vCtr := vCtr + 1;
1221: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1222: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
1223: vCtr := vCtr + 1;

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

1217: vCtr := vCtr + 1;
1218: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
1220: vCtr := vCtr + 1;
1221: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1222: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
1223: vCtr := vCtr + 1;
1224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
1225: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;

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

1218: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER1';
1219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.employer_name;
1220: vCtr := vCtr + 1;
1221: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1222: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
1223: vCtr := vCtr + 1;
1224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
1225: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
1226: END IF;

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

1220: vCtr := vCtr + 1;
1221: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1222: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
1223: vCtr := vCtr + 1;
1224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
1225: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
1226: END IF;
1227: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
1228: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN

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

1221: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_OFFICE1';
1222: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.name;
1223: vCtr := vCtr + 1;
1224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_REG_NUM1';
1225: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_record_details.tax_reg;
1226: END IF;
1227: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
1228: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
1229: vCtr := vCtr + 1;

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

1226: END IF;
1227: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
1228: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
1229: vCtr := vCtr + 1;
1230: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1231: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1232: END IF;
1233: 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);
1234:

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

1227: IF NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
1228: OR NVL(l_person_id,-1) <>v_csr_get_record_details.person_id THEN
1229: vCtr := vCtr + 1;
1230: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1231: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1232: END IF;
1233: 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);
1234:
1235: FOR v_csr_get_wts_elements

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

1237: LOOP
1238: -- IF v_csr_get_wts_elements.Wage_Tax_Subsidy <> 0 THEN
1239: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_wts_elements.Subsidy_Element_Type_ID);
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_wts_elements.employee_name THEN
1245: vCtr := vCtr + 1;

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

1238: -- IF v_csr_get_wts_elements.Wage_Tax_Subsidy <> 0 THEN
1239: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_wts_elements.Subsidy_Element_Type_ID);
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_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_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_wts_elements.employee_name;
1248: l_emp := v_csr_get_wts_elements.employee_name;
1249: ELSE
1250: vCtr := vCtr + 1;

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

1243:
1244: IF l_emp <> v_csr_get_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_wts_elements.employee_name;
1248: l_emp := v_csr_get_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_wts_elements.employee_name;
1248: l_emp := v_csr_get_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_wts_elements.payroll_name THEN

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

1248: l_emp := v_csr_get_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_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_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_wts_elements.payroll_name;
1259: l_payroll := v_csr_get_wts_elements.payroll_name ;
1260: ELSE
1261: vCtr := vCtr + 1;

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

1254:
1255: IF l_payroll <> v_csr_get_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_wts_elements.payroll_name;
1259: l_payroll := v_csr_get_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_wts_elements.payroll_name;
1259: l_payroll := v_csr_get_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_wts_elements.current_period THEN

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

1259: l_payroll := v_csr_get_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_wts_elements.current_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_wts_elements.current_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_wts_elements.current_period;
1270: l_period := v_csr_get_wts_elements.current_period;
1271: ELSE
1272: vCtr := vCtr + 1;

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

1265:
1266: IF l_period <> v_csr_get_wts_elements.current_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_wts_elements.current_period;
1270: l_period := v_csr_get_wts_elements.current_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_wts_elements.current_period;
1270: l_period := v_csr_get_wts_elements.current_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_wts_elements.current_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 := l_subsidy_name;
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_wts_elements.Basis_Salary,2),'99G999G999D90MI');

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

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 := l_subsidy_name;
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_wts_elements.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 := l_subsidy_name;
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_wts_elements.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_wts_elements.Part_Time_Percentage,4),'999D9990MI');

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

1278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_subsidy_name;
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_wts_elements.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_wts_elements.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_wts_elements.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_wts_elements.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_wts_elements.Working_Hours,2),'999D90MI');

Line 1285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.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_wts_elements.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_wts_elements.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_wts_elements.Working_Hours,2),'999D90MI');
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_wts_elements.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_wts_elements.Working_Hours,2),'999D90MI');
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_wts_elements.Wage_Limit,2),'99G999D90MI');

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

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_wts_elements.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_wts_elements.Working_Hours,2),'999D90MI');
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_wts_elements.Wage_Limit,2),'99G999D90MI');
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_wts_elements.Working_Hours,2),'999D90MI');
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_wts_elements.Wage_Limit,2),'99G999D90MI');
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_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');

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

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_wts_elements.Working_Hours,2),'999D90MI');
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_wts_elements.Wage_Limit,2),'99G999D90MI');
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_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
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_wts_elements.Wage_Limit,2),'99G999D90MI');
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_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
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_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');

1290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_wts_elements.Wage_Limit,2),'99G999D90MI');
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_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
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:

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_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
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:
1299: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
1300: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2);

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_wts_elements.Wage_Tax_Subsidy,2),'99G999D90MI');
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:
1299: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
1300: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_wts_elements.Wage_Tax_Subsidy,2);
1301: END IF;

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

1315: IN csr_get_retro_wts_elements(l_asg_act_id)
1316: LOOP
1317: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID); /* Bug 4517173*/
1318: vCtr := vCtr + 1;
1319: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1320: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1321:
1322: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
1323: vCtr := vCtr + 1;

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

1316: LOOP
1317: l_subsidy_name := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID); /* Bug 4517173*/
1318: vCtr := vCtr + 1;
1319: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1320: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1321:
1322: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
1323: vCtr := vCtr + 1;
1324: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

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

1320: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
1321:
1322: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
1323: vCtr := vCtr + 1;
1324: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1325: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
1326: l_emp := v_csr_get_retro_wts_elements.employee_name;
1327: ELSE
1328: vCtr := vCtr + 1;

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

1321:
1322: IF l_emp <> v_csr_get_retro_wts_elements.employee_name THEN
1323: vCtr := vCtr + 1;
1324: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1325: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
1326: l_emp := v_csr_get_retro_wts_elements.employee_name;
1327: ELSE
1328: vCtr := vCtr + 1;
1329: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';

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

1325: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.employee_name;
1326: l_emp := v_csr_get_retro_wts_elements.employee_name;
1327: ELSE
1328: vCtr := vCtr + 1;
1329: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1330: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1331: END IF;
1332:
1333: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN

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

1326: l_emp := v_csr_get_retro_wts_elements.employee_name;
1327: ELSE
1328: vCtr := vCtr + 1;
1329: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_NAME';
1330: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1331: END IF;
1332:
1333: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
1334: vCtr := vCtr + 1;

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

1331: END IF;
1332:
1333: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
1334: vCtr := vCtr + 1;
1335: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1336: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
1337: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
1338: ELSE
1339: vCtr := vCtr + 1;

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

1332:
1333: IF l_payroll <> v_csr_get_retro_wts_elements.payroll_name THEN
1334: vCtr := vCtr + 1;
1335: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1336: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
1337: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
1338: ELSE
1339: vCtr := vCtr + 1;
1340: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';

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

1336: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.payroll_name;
1337: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
1338: ELSE
1339: vCtr := vCtr + 1;
1340: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1341: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1342: END IF;
1343:
1344: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN

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

1337: l_payroll := v_csr_get_retro_wts_elements.payroll_name;
1338: ELSE
1339: vCtr := vCtr + 1;
1340: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL';
1341: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1342: END IF;
1343:
1344: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
1345: vCtr := vCtr + 1;

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

1342: END IF;
1343:
1344: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
1345: vCtr := vCtr + 1;
1346: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1347: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
1348: l_period := v_csr_get_retro_wts_elements.Retro_Period;
1349: ELSE
1350: vCtr := vCtr + 1;

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

1343:
1344: IF l_period <> v_csr_get_retro_wts_elements.Retro_Period THEN
1345: vCtr := vCtr + 1;
1346: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1347: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
1348: l_period := v_csr_get_retro_wts_elements.Retro_Period;
1349: ELSE
1350: vCtr := vCtr + 1;
1351: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';

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

1347: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_csr_get_retro_wts_elements.Retro_Period;
1348: l_period := v_csr_get_retro_wts_elements.Retro_Period;
1349: ELSE
1350: vCtr := vCtr + 1;
1351: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1352: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1353: END IF;
1354:
1355: vCtr := vCtr + 1;

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

1348: l_period := v_csr_get_retro_wts_elements.Retro_Period;
1349: ELSE
1350: vCtr := vCtr + 1;
1351: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PERIOD';
1352: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1353: END IF;
1354:
1355: vCtr := vCtr + 1;
1356: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';

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

1352: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := NULL;
1353: END IF;
1354:
1355: vCtr := vCtr + 1;
1356: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1357: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
1358: vCtr := vCtr + 1;
1359: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1360: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');

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

1353: END IF;
1354:
1355: vCtr := vCtr + 1;
1356: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1357: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
1358: vCtr := vCtr + 1;
1359: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1360: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
1361: vCtr := vCtr + 1;

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

1355: vCtr := vCtr + 1;
1356: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1357: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
1358: vCtr := vCtr + 1;
1359: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1360: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
1361: vCtr := vCtr + 1;
1362: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1363: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');

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

1356: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY_TYPE';
1357: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := GET_SUBSIDY_TYPE_NAME(v_csr_get_retro_wts_elements.Retro_Subsidy_Element_Type_ID);
1358: vCtr := vCtr + 1;
1359: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1360: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
1361: vCtr := vCtr + 1;
1362: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1363: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
1364: vCtr := vCtr + 1;

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

1358: vCtr := vCtr + 1;
1359: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1360: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
1361: vCtr := vCtr + 1;
1362: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1363: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
1364: vCtr := vCtr + 1;
1365: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1366: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');

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

1359: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAX_SALARY';
1360: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Basis_Salary,2),'99G999G999D90MI');
1361: vCtr := vCtr + 1;
1362: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1363: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
1364: vCtr := vCtr + 1;
1365: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1366: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
1367: vCtr := vCtr + 1;

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

1361: vCtr := vCtr + 1;
1362: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1363: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
1364: vCtr := vCtr + 1;
1365: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1366: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
1367: vCtr := vCtr + 1;
1368: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1369: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');

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

1362: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PART_TIME_PERC';
1363: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Part_Time_Percentage,4),'999D9990MI');
1364: vCtr := vCtr + 1;
1365: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1366: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
1367: vCtr := vCtr + 1;
1368: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1369: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
1370: vCtr := vCtr + 1;

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

1364: vCtr := vCtr + 1;
1365: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1366: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
1367: vCtr := vCtr + 1;
1368: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1369: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
1370: vCtr := vCtr + 1;
1371: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1372: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');

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

1365: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WORKING_LEAVE_HRS';
1366: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Working_Hours,2),'999G999D90MI');
1367: vCtr := vCtr + 1;
1368: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1369: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
1370: vCtr := vCtr + 1;
1371: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1372: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
1373: vCtr := vCtr + 1;

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

1367: vCtr := vCtr + 1;
1368: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1369: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
1370: vCtr := vCtr + 1;
1371: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1372: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
1373: vCtr := vCtr + 1;
1374: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1375: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

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

1368: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'WAGE_LIMIT';
1369: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_Wage_Limit,2),'999G999D90MI');
1370: vCtr := vCtr + 1;
1371: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1372: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
1373: vCtr := vCtr + 1;
1374: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1375: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1376: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN

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

1370: vCtr := vCtr + 1;
1371: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1372: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
1373: vCtr := vCtr + 1;
1374: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1375: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1376: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
1377: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2);
1378: END IF;

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

1371: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUBSIDY';
1372: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2),'999G999D90');
1373: vCtr := vCtr + 1;
1374: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMP_REC';
1375: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1376: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','LOW_WAGES') THEN
1377: l_rp_tot_lw_subsidy := l_rp_tot_lw_subsidy + ROUND(v_csr_get_retro_wts_elements.Retro_WTS,2);
1378: END IF;
1379: IF l_subsidy_name = hr_general.decode_lookup('NL_FORM_LABELS','EDUCATION') THEN

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

1394: END LOOP;
1395:
1396: IF l_flag = FALSE THEN
1397: vCtr := vCtr + 1;
1398: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1399: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
1400: l_emp_total_subsidy:=0;
1401: vCtr := vCtr + 1;
1402: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

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

1395:
1396: IF l_flag = FALSE THEN
1397: vCtr := vCtr + 1;
1398: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1399: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
1400: l_emp_total_subsidy:=0;
1401: vCtr := vCtr + 1;
1402: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1403: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

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

1398: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMP_TOTAL';
1399: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
1400: l_emp_total_subsidy:=0;
1401: vCtr := vCtr + 1;
1402: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1403: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1404:
1405: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
1406: vCtr := vCtr + 1;

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

1399: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_emp_total_subsidy,2),'999G999D90MI');
1400: l_emp_total_subsidy:=0;
1401: vCtr := vCtr + 1;
1402: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1403: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1404:
1405: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
1406: vCtr := vCtr + 1;
1407: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';

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

1403: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1404:
1405: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
1406: vCtr := vCtr + 1;
1407: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1408: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1409: END IF;
1410: vCtr := vCtr + 1;
1411: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';

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

1404:
1405: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
1406: vCtr := vCtr + 1;
1407: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1408: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1409: END IF;
1410: vCtr := vCtr + 1;
1411: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
1412: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');

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

1407: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1408: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1409: END IF;
1410: vCtr := vCtr + 1;
1411: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
1412: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
1413: vCtr := vCtr + 1;
1414: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1415: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');

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

1408: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1409: END IF;
1410: vCtr := vCtr + 1;
1411: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
1412: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
1413: vCtr := vCtr + 1;
1414: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1415: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
1416: vCtr := vCtr + 1;

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

1410: vCtr := vCtr + 1;
1411: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
1412: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
1413: vCtr := vCtr + 1;
1414: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1415: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
1416: vCtr := vCtr + 1;
1417: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1418: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');

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

1411: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LOW_WAGES';
1412: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_lw_subsidy,2),'99G999G999G999D90MI');
1413: vCtr := vCtr + 1;
1414: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1415: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
1416: vCtr := vCtr + 1;
1417: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1418: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
1419: vCtr := vCtr + 1;

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

1413: vCtr := vCtr + 1;
1414: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1415: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
1416: vCtr := vCtr + 1;
1417: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1418: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
1419: vCtr := vCtr + 1;
1420: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
1421: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');

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

1414: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_EDUCATION';
1415: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ed_subsidy,2),'99G999G999G999D90MI');
1416: vCtr := vCtr + 1;
1417: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1418: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
1419: vCtr := vCtr + 1;
1420: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
1421: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
1422:

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

1416: vCtr := vCtr + 1;
1417: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1418: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
1419: vCtr := vCtr + 1;
1420: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
1421: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
1422:
1423: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
1424: pay_nl_xdo_Report.WritetoCLOB_rtf_1(p_xml);

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

1417: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_LONG_TERM';
1418: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ltu_subsidy,2),'99G999G999G999D90MI');
1419: vCtr := vCtr + 1;
1420: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
1421: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
1422:
1423: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
1424: pay_nl_xdo_Report.WritetoCLOB_rtf_1(p_xml);
1425:

Line 1424: pay_nl_xdo_Report.WritetoCLOB_rtf_1(p_xml);

1420: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
1421: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
1422:
1423: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
1424: pay_nl_xdo_Report.WritetoCLOB_rtf_1(p_xml);
1425:
1426: END populate_wts_report_data_1;
1427:
1428: