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_IN_REPORTS_PKG dependencies on DBMS_LOB

Line 573: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

569: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
570:
571: fnd_file.put_line(fnd_file.log,'Creating the XML...');
572:
573: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
574: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
575: --
576: l_tag :='';
577: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 574: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

570:
571: fnd_file.put_line(fnd_file.log,'Creating the XML...');
572:
573: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
574: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
575: --
576: l_tag :='';
577: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
578: l_tag := '';

Line 577: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

573: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
574: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
575: --
576: l_tag :='';
577: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
578: l_tag := '';
579: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
580:
581: fnd_file.put_line(fnd_file.log,'Started...');

Line 579: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

575: --
576: l_tag :='';
577: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
578: l_tag := '';
579: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
580:
581: fnd_file.put_line(fnd_file.log,'Started...');
582: fnd_file.put_line(fnd_file.log,'Creating XML for PT Form III.');
583:

Line 587: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

583:
584: --System Date:
585: l_sys_date_time := to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
586: l_tag :=pay_in_xml_utils.getTag('c_sys_date_in_hh_mm_ss',l_sys_date_time);
587: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
588:
589: IF g_debug THEN
590: pay_in_utils.trace('Business Group id ',l_bg_id);
591: pay_in_utils.trace('System Date and Time ',l_sys_date_time);

Line 626: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

622: ,period_end)
623: LOOP
624: l_tag :='';
625: pay_in_utils.set_location(g_debug,l_procedure, 40);
626: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
627:
628: IF g_debug THEN
629: pay_in_utils.trace('c_rec.org_id ',c_rec.org_id);
630: END IF;

Line 659: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

655: CLOSE c_org_details;
656: pay_in_utils.set_location(g_debug,l_procedure, 60);
657: -- Registered No
658: l_tag :=pay_in_xml_utils.getTag('c_registered_no', l_registered_no);
659: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
660: --Organization Name and Address
661: l_tag :=pay_in_xml_utils.getTag('c_registered_name', l_registered_name);
662: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
663: l_tag :=pay_in_xml_utils.getTag('c_registered_address', l_reg_address);

Line 662: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

658: l_tag :=pay_in_xml_utils.getTag('c_registered_no', l_registered_no);
659: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
660: --Organization Name and Address
661: l_tag :=pay_in_xml_utils.getTag('c_registered_name', l_registered_name);
662: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
663: l_tag :=pay_in_xml_utils.getTag('c_registered_address', l_reg_address);
664: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
665: --Report Period
666: l_tag :=pay_in_xml_utils.getTag('c_period_from', to_char(period_start));

Line 664: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

660: --Organization Name and Address
661: l_tag :=pay_in_xml_utils.getTag('c_registered_name', l_registered_name);
662: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
663: l_tag :=pay_in_xml_utils.getTag('c_registered_address', l_reg_address);
664: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
665: --Report Period
666: l_tag :=pay_in_xml_utils.getTag('c_period_from', to_char(period_start));
667: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
668: l_tag :=pay_in_xml_utils.getTag('c_period_to', to_char(period_end));

Line 667: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

663: l_tag :=pay_in_xml_utils.getTag('c_registered_address', l_reg_address);
664: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
665: --Report Period
666: l_tag :=pay_in_xml_utils.getTag('c_period_from', to_char(period_start));
667: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
668: l_tag :=pay_in_xml_utils.getTag('c_period_to', to_char(period_end));
669: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
670: --Organization Rep Name and Designation
671: l_tag :=pay_in_xml_utils.getTag('c_rep_name', l_rep_name);

Line 669: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

665: --Report Period
666: l_tag :=pay_in_xml_utils.getTag('c_period_from', to_char(period_start));
667: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
668: l_tag :=pay_in_xml_utils.getTag('c_period_to', to_char(period_end));
669: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
670: --Organization Rep Name and Designation
671: l_tag :=pay_in_xml_utils.getTag('c_rep_name', l_rep_name);
672: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
673: l_tag :=pay_in_xml_utils.getTag('c_rep_desg', l_rep_desg);

Line 672: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

668: l_tag :=pay_in_xml_utils.getTag('c_period_to', to_char(period_end));
669: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
670: --Organization Rep Name and Designation
671: l_tag :=pay_in_xml_utils.getTag('c_rep_name', l_rep_name);
672: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
673: l_tag :=pay_in_xml_utils.getTag('c_rep_desg', l_rep_desg);
674: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
675: --BSRTC No
676: l_tag :=pay_in_xml_utils.getTag('c_bsrtc_no', l_bsrtc_no);

Line 674: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

670: --Organization Rep Name and Designation
671: l_tag :=pay_in_xml_utils.getTag('c_rep_name', l_rep_name);
672: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
673: l_tag :=pay_in_xml_utils.getTag('c_rep_desg', l_rep_desg);
674: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
675: --BSRTC No
676: l_tag :=pay_in_xml_utils.getTag('c_bsrtc_no', l_bsrtc_no);
677: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
678: --Date

Line 677: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

673: l_tag :=pay_in_xml_utils.getTag('c_rep_desg', l_rep_desg);
674: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
675: --BSRTC No
676: l_tag :=pay_in_xml_utils.getTag('c_bsrtc_no', l_bsrtc_no);
677: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
678: --Date
679: l_tag :=pay_in_xml_utils.getTag('c_date', substr(l_sys_date_time, 1, 11));
680: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
681: pay_in_utils.set_location(g_debug,l_procedure, 70);

Line 680: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

676: l_tag :=pay_in_xml_utils.getTag('c_bsrtc_no', l_bsrtc_no);
677: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
678: --Date
679: l_tag :=pay_in_xml_utils.getTag('c_date', substr(l_sys_date_time, 1, 11));
680: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
681: pay_in_utils.set_location(g_debug,l_procedure, 70);
682:
683: IF g_debug THEN
684: pay_in_utils.trace('Registered No ',l_registered_no);

Line 786: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);

782: -- Highest slab is written to the report once the loop is over since a sum is to be taken for 200 and 300
783: l_slab_month_tag := 'c_month' || l_period_month || '_emp_slab'|| l_slab;
784: fnd_file.put_line(fnd_file.log,'l_slab_month_tag: '|| l_slab_month_tag);
785: l_tag := pay_in_xml_utils.getTag(l_slab_month_tag, l_slab_month_count);
786: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);
787: END IF;
788:
789: END LOOP;
790:

Line 811: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);

807: IF l_slab_month_count <> 0 THEN
808: -- Writing to the file for the highest slab
809: l_slab_month_tag := 'c_month' || l_period_month || '_emp_slab6';
810: l_tag := pay_in_xml_utils.getTag(l_slab_month_tag, l_slab_month_count);
811: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);
812: END IF;
813:
814: l_date := ADD_MONTHS(l_date, 1);
815:

Line 821: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

817: pay_in_utils.set_location(g_debug,l_procedure, 120);
818:
819: -- Writing the total employees in a slab
820: l_tag := pay_in_xml_utils.getTag('c_emp_slab_1', l_count_0);
821: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
822: -- l_tag := pay_in_xml_utils.getTag('c_emp_slab_2', l_count_30);
823: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
824: l_tag := pay_in_xml_utils.getTag('c_emp_slab_3', l_count_60);
825: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 823: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

819: -- Writing the total employees in a slab
820: l_tag := pay_in_xml_utils.getTag('c_emp_slab_1', l_count_0);
821: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
822: -- l_tag := pay_in_xml_utils.getTag('c_emp_slab_2', l_count_30);
823: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
824: l_tag := pay_in_xml_utils.getTag('c_emp_slab_3', l_count_60);
825: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
826: l_tag := pay_in_xml_utils.getTag('c_emp_slab_4', l_count_120);
827: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 825: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

821: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
822: -- l_tag := pay_in_xml_utils.getTag('c_emp_slab_2', l_count_30);
823: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
824: l_tag := pay_in_xml_utils.getTag('c_emp_slab_3', l_count_60);
825: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
826: l_tag := pay_in_xml_utils.getTag('c_emp_slab_4', l_count_120);
827: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
828: l_tag := pay_in_xml_utils.getTag('c_emp_slab_5', l_count_175);
829: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 827: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

823: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
824: l_tag := pay_in_xml_utils.getTag('c_emp_slab_3', l_count_60);
825: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
826: l_tag := pay_in_xml_utils.getTag('c_emp_slab_4', l_count_120);
827: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
828: l_tag := pay_in_xml_utils.getTag('c_emp_slab_5', l_count_175);
829: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
830: l_tag := pay_in_xml_utils.getTag('c_emp_slab_6', l_count_200 + l_count_300);
831: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 829: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

825: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
826: l_tag := pay_in_xml_utils.getTag('c_emp_slab_4', l_count_120);
827: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
828: l_tag := pay_in_xml_utils.getTag('c_emp_slab_5', l_count_175);
829: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
830: l_tag := pay_in_xml_utils.getTag('c_emp_slab_6', l_count_200 + l_count_300);
831: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
832:
833: -- Calculating the PT paid in each slab

Line 831: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

827: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
828: l_tag := pay_in_xml_utils.getTag('c_emp_slab_5', l_count_175);
829: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
830: l_tag := pay_in_xml_utils.getTag('c_emp_slab_6', l_count_200 + l_count_300);
831: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
832:
833: -- Calculating the PT paid in each slab
834: -- l_tax_slab_2 := l_slab_2 * l_count_30;
835: l_tax_slab_3 := l_slab_3 * l_count_60;

Line 842: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

838: l_tax_slab_6 := l_slab_6 * l_count_200 + l_slab_6_2 * l_count_300;
839:
840: -- Writing to file the calculated PT paid in each slab
841: -- l_tag := pay_in_xml_utils.getTag('c_tax_slab_2', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_2,0)));
842: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
843: l_tag := pay_in_xml_utils.getTag('c_tax_slab_3', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_3,0)));
844: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
845: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_4,0)));
846: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 844: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

840: -- Writing to file the calculated PT paid in each slab
841: -- l_tag := pay_in_xml_utils.getTag('c_tax_slab_2', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_2,0)));
842: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
843: l_tag := pay_in_xml_utils.getTag('c_tax_slab_3', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_3,0)));
844: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
845: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_4,0)));
846: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
847: l_tag := pay_in_xml_utils.getTag('c_tax_slab_5', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_5,0)));
848: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 846: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

842: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
843: l_tag := pay_in_xml_utils.getTag('c_tax_slab_3', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_3,0)));
844: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
845: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_4,0)));
846: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
847: l_tag := pay_in_xml_utils.getTag('c_tax_slab_5', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_5,0)));
848: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
849: l_tag := pay_in_xml_utils.getTag('c_tax_slab_6', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_6,0)));
850: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 848: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

844: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
845: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_4,0)));
846: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
847: l_tag := pay_in_xml_utils.getTag('c_tax_slab_5', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_5,0)));
848: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
849: l_tag := pay_in_xml_utils.getTag('c_tax_slab_6', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_6,0)));
850: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
851:
852: pay_in_utils.set_location(g_debug,l_procedure, 130);

Line 850: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

846: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
847: l_tag := pay_in_xml_utils.getTag('c_tax_slab_5', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_5,0)));
848: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
849: l_tag := pay_in_xml_utils.getTag('c_tax_slab_6', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_6,0)));
850: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
851:
852: pay_in_utils.set_location(g_debug,l_procedure, 130);
853:
854: -- Getting the actual PT paid from the challans data

Line 871: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

867: END IF;
868:
869:
870: l_tag := pay_in_xml_utils.getTag('c_tax_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_amount,0)));
871: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
872:
873: l_tag := pay_in_xml_utils.getTag('c_interest_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_interest_amount,0)));
874: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
875:

Line 874: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

870: l_tag := pay_in_xml_utils.getTag('c_tax_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_amount,0)));
871: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
872:
873: l_tag := pay_in_xml_utils.getTag('c_interest_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_interest_amount,0)));
874: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
875:
876: l_tag := pay_in_xml_utils.getTag('c_excess_tax', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_excess_tax,0)));
877: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
878:

Line 877: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

873: l_tag := pay_in_xml_utils.getTag('c_interest_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_interest_amount,0)));
874: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
875:
876: l_tag := pay_in_xml_utils.getTag('c_excess_tax', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_excess_tax,0)));
877: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
878:
879: l_net_amount := l_tax_amount - l_excess_tax + l_interest_amount;
880:
881: l_tag := pay_in_xml_utils.getTag('c_net_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_net_amount,0)));

Line 882: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

878:
879: l_net_amount := l_tax_amount - l_excess_tax + l_interest_amount;
880:
881: l_tag := pay_in_xml_utils.getTag('c_net_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_net_amount,0)));
882: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
883:
884: l_tag := pay_in_xml_utils.getTag('c_total_amount_words', initcap(pay_in_utils.number_to_words(l_net_amount)));
885: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
886:

Line 885: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

881: l_tag := pay_in_xml_utils.getTag('c_net_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_net_amount,0)));
882: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
883:
884: l_tag := pay_in_xml_utils.getTag('c_total_amount_words', initcap(pay_in_utils.number_to_words(l_net_amount)));
885: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
886:
887: l_tag :=pay_in_xml_utils.getTag('c_year', period_start_year);
888: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
889: l_tag :=pay_in_xml_utils.getTag('c_year1', SUBSTR(p_year, 6, 4));

Line 888: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

884: l_tag := pay_in_xml_utils.getTag('c_total_amount_words', initcap(pay_in_utils.number_to_words(l_net_amount)));
885: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
886:
887: l_tag :=pay_in_xml_utils.getTag('c_year', period_start_year);
888: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
889: l_tag :=pay_in_xml_utils.getTag('c_year1', SUBSTR(p_year, 6, 4));
890: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
891:
892: l_tag :='';

Line 890: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

886:
887: l_tag :=pay_in_xml_utils.getTag('c_year', period_start_year);
888: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
889: l_tag :=pay_in_xml_utils.getTag('c_year1', SUBSTR(p_year, 6, 4));
890: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
891:
892: l_tag :='';
893: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
894: pay_in_utils.set_location(g_debug,l_procedure, 140);

Line 893: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

889: l_tag :=pay_in_xml_utils.getTag('c_year1', SUBSTR(p_year, 6, 4));
890: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
891:
892: l_tag :='';
893: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
894: pay_in_utils.set_location(g_debug,l_procedure, 140);
895: fnd_file.put_line(fnd_file.log,'Org Over');
896: END LOOP;
897: l_tag :='';

Line 898: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

894: pay_in_utils.set_location(g_debug,l_procedure, 140);
895: fnd_file.put_line(fnd_file.log,'Org Over');
896: END LOOP;
897: l_tag :='';
898: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
899: fnd_file.put_line(fnd_file.log,'XML Created.');
900: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);
901:
902: END create_pt_form3_xml;

Line 936: dbms_lob.writeAppend(g_xml_data,length(l_tag),l_tag);

932: l_tag := pay_in_xml_utils.getTag( p_tag_name => p_tag_name
933: , p_tag_value => p_tag_value
934: );
935:
936: dbms_lob.writeAppend(g_xml_data,length(l_tag),l_tag);
937: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
938: END write_tag;
939:
940: --------------------------------------------------------------------------

Line 1202: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

1198:
1199: pay_in_xml_utils.gXMLTable.DELETE;
1200: --
1201: fnd_file.put_line(fnd_file.log,'Creating the XML...');
1202: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1203: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1204: --
1205: l_tag :='';
1206: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 1203: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

1199: pay_in_xml_utils.gXMLTable.DELETE;
1200: --
1201: fnd_file.put_line(fnd_file.log,'Creating the XML...');
1202: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1203: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1204: --
1205: l_tag :='';
1206: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1207:

Line 1206: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1202: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1203: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1204: --
1205: l_tag :='';
1206: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1207:
1208: l_tag := '';
1209: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1210: fnd_file.put_line(fnd_file.log,'Started...');

Line 1209: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1205: l_tag :='';
1206: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1207:
1208: l_tag := '';
1209: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1210: fnd_file.put_line(fnd_file.log,'Started...');
1211:
1212: pay_in_utils.set_location(g_debug,l_procedure, 20);
1213: --

Line 1220: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1216: l_sys_date := TO_CHAR(SYSDATE,'DD-Mon-YYYY');
1217: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
1218: --System Date
1219: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);
1220: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1221:
1222: pay_in_utils.set_location(g_debug,l_procedure, 30);
1223:
1224: OPEN csr_org_max_action_context_id;

Line 1298: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1294: WRITE_TAG('C_REP_DESG',l_rep_desg);
1295:
1296:
1297: l_tag := '';
1298: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1299:
1300: fnd_file.put_line(fnd_file.log,'XML Created.');
1301: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 60);
1302:

Line 1724: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

1720:
1721: pay_in_xml_utils.gXMLTable.DELETE;
1722: --
1723: fnd_file.put_line(fnd_file.log,'Creating the XML...');
1724: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1725: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1726: --
1727: l_tag :='';
1728: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 1725: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

1721: pay_in_xml_utils.gXMLTable.DELETE;
1722: --
1723: fnd_file.put_line(fnd_file.log,'Creating the XML...');
1724: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1725: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1726: --
1727: l_tag :='';
1728: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1729:

Line 1728: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1724: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1725: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1726: --
1727: l_tag :='';
1728: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1729:
1730: l_tag := '';
1731: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1732: fnd_file.put_line(fnd_file.log,'Started...');

Line 1731: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1727: l_tag :='';
1728: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1729:
1730: l_tag := '';
1731: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1732: fnd_file.put_line(fnd_file.log,'Started...');
1733: --
1734: fnd_file.put_line(fnd_file.log,'Creating XML for Employer Details.');
1735: l_sys_date_time:=TO_CHAR(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');

Line 1739: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1735: l_sys_date_time:=TO_CHAR(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
1736: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
1737: --System Date
1738: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);
1739: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1740:
1741: pay_in_utils.set_location(g_debug,l_procedure, 20);
1742:
1743: FOR c_rec IN c_pf_org_id(p_pf_org_id

Line 1750: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1746: ,p_effective_end_date)
1747: LOOP
1748: pay_in_utils.set_location(g_debug,l_procedure, 30);
1749: l_tag := '';
1750: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1751:
1752: IF g_debug THEN
1753: pay_in_utils.trace('PF Organization id ',p_pf_org_id);
1754: pay_in_utils.trace('Contribution Period ',p_contribution_period);

Line 2023: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);

2019: l_count := l_count + 1;
2020: pay_in_xml_utils.multiColumnar('pf_org_sum',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
2021: /* Ending Starts here*/
2022: l_tag := '';
2023: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);
2024: pay_in_xml_utils.gXMLTable.DELETE;
2025: l_row_count:=NULL;
2026: pay_in_utils.set_location(g_debug,l_procedure, 140);
2027: END LOOP;

Line 2032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

2028:
2029: pay_in_utils.set_location(g_debug,l_procedure, 150);
2030:
2031: l_tag := '';
2032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2033:
2034: fnd_file.put_line(fnd_file.log,'XML Created.');
2035: -- INSERT INTO temp_clob VALUES (g_xml_data);
2036:

Line 2769: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

2765: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2766:
2767: --
2768: fnd_file.put_line(fnd_file.log,'Creating the XML...');
2769: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
2770: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
2771: --
2772: l_tag :='';
2773:

Line 2770: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

2766:
2767: --
2768: fnd_file.put_line(fnd_file.log,'Creating the XML...');
2769: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
2770: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
2771: --
2772: l_tag :='';
2773:
2774: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 2774: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

2770: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
2771: --
2772: l_tag :='';
2773:
2774: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2775: l_tag := '';
2776: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2777: fnd_file.put_line(fnd_file.log,'Started...');
2778: --

Line 2776: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

2772: l_tag :='';
2773:
2774: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2775: l_tag := '';
2776: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2777: fnd_file.put_line(fnd_file.log,'Started...');
2778: --
2779: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
2780: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');

Line 2784: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

2780: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
2781: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
2782: --System Date
2783: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);
2784: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2785:
2786: pay_in_utils.set_location(g_debug,l_procedure, 20);
2787:
2788: FOR c_rec IN c_pf_org_id(p_pf_org_id

Line 2800: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

2796: l_org_employee := 0 ;
2797: l_org_pension := 0 ;
2798:
2799: l_tag := '';
2800: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2801: l_count:=1;
2802: --PF Org Reg Name
2803: --PF Org Name made in BLOCK
2804: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pf_org_name';

Line 3106: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3102: l_count := l_count + 1;
3103: pay_in_xml_utils.multiColumnar('pf_org_sum',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
3104: /* Ending Starts here*/
3105: l_tag := '';
3106: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3107: pay_in_xml_utils.gXMLTable.delete;
3108: l_row_count:=null;
3109: END LOOP;
3110: pay_in_utils.set_location(g_debug,l_procedure, 240);

Line 3112: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3108: l_row_count:=null;
3109: END LOOP;
3110: pay_in_utils.set_location(g_debug,l_procedure, 240);
3111: l_tag := '';
3112: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3113: fnd_file.put_line(fnd_file.log,'XML Created.');
3114:
3115: END create_form6a_xml;
3116:

Line 3332: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

3328:
3329: pay_in_xml_utils.gXMLTable.DELETE;
3330: --
3331: fnd_file.put_line(fnd_file.log,'Creating the XML...');
3332: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
3333: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3334: --
3335: l_tag :='';
3336:

Line 3333: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

3329: pay_in_xml_utils.gXMLTable.DELETE;
3330: --
3331: fnd_file.put_line(fnd_file.log,'Creating the XML...');
3332: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
3333: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3334: --
3335: l_tag :='';
3336:
3337: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 3337: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3333: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3334: --
3335: l_tag :='';
3336:
3337: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3338: l_tag := '';
3339: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3340: fnd_file.put_line(fnd_file.log,'Started...');
3341: --

Line 3339: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3335: l_tag :='';
3336:
3337: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3338: l_tag := '';
3339: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3340: fnd_file.put_line(fnd_file.log,'Started...');
3341: --
3342: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
3343: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');

Line 3346: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3342: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
3343: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
3344: --System Date
3345: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);
3346: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3347: l_cp_pf_org_id := p_pf_org_id;
3348:
3349: pay_in_utils.set_location(g_debug,l_procedure, 20);
3350:

Line 3431: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3427: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_address';
3428: pay_in_xml_utils.gXMLTable(l_count).Value := (c_rec.action_information5);
3429: l_count := l_count + 1;
3430: l_tag := '';
3431: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3432: pay_in_xml_utils.multiColumnar('Details',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
3433: l_count:=1;
3434: l_row_count:=0;
3435: --Individual Month Record Determination

Line 3536: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3532:
3533: pay_in_utils.set_location(g_debug,l_procedure, 100);
3534: --Voluntary Higher Contr Rate
3535: l_tag :=pay_in_xml_utils.getTag('c_voluntary_rate',to_number(l_voluntary_contribution_rate,999.99));
3536: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3537: --Employer Representative name
3538: l_tag :=pay_in_xml_utils.getTag('c_rep_name',l_pf_rep_name);
3539: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3540: FOR c_sum IN c_asg_summation_details(/*c_master.assignment_id --Assignment ID

Line 3539: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3535: l_tag :=pay_in_xml_utils.getTag('c_voluntary_rate',to_number(l_voluntary_contribution_rate,999.99));
3536: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3537: --Employer Representative name
3538: l_tag :=pay_in_xml_utils.getTag('c_rep_name',l_pf_rep_name);
3539: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3540: FOR c_sum IN c_asg_summation_details(/*c_master.assignment_id --Assignment ID
3541: ,*/c_org.pf_org_id --PF Org ID
3542: ,c_org.pf_num --PF Number
3543: ,p_effective_start_date

Line 3549: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3545: ,p_contribution_period)
3546: LOOP
3547: --PF Salary Annual Value
3548: l_tag :=pay_in_xml_utils.getTag('c_pf_salary_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pf_ytd));
3549: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3550: -- Employee Total Contribution
3551: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
3552: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3553: -- Employer Total Contribution

Line 3552: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3548: l_tag :=pay_in_xml_utils.getTag('c_pf_salary_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pf_ytd));
3549: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3550: -- Employee Total Contribution
3551: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
3552: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3553: -- Employer Total Contribution
3554: l_tag :=pay_in_xml_utils.getTag('c_epf_difference_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employer));
3555: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3556: -- Pension

Line 3555: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3551: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
3552: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3553: -- Employer Total Contribution
3554: l_tag :=pay_in_xml_utils.getTag('c_epf_difference_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employer));
3555: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3556: -- Pension
3557: l_tag :=pay_in_xml_utils.getTag('c_pension_fund_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pension));
3558: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3559: --Total Employee Employer Contr

Line 3558: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3554: l_tag :=pay_in_xml_utils.getTag('c_epf_difference_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employer));
3555: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3556: -- Pension
3557: l_tag :=pay_in_xml_utils.getTag('c_pension_fund_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pension));
3558: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3559: --Total Employee Employer Contr
3560: l_tag :=pay_in_xml_utils.getTag('c_employer_employee_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.total));
3561: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3562: END LOOP;

Line 3561: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3557: l_tag :=pay_in_xml_utils.getTag('c_pension_fund_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pension));
3558: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3559: --Total Employee Employer Contr
3560: l_tag :=pay_in_xml_utils.getTag('c_employer_employee_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.total));
3561: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3562: END LOOP;
3563: pay_in_utils.set_location(g_debug,l_procedure, 110);
3564: --Current Date
3565: l_tag :=pay_in_xml_utils.getTag('c_current_date',to_char(SYSDATE,'DD-Mon-YYYY'));

Line 3566: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3562: END LOOP;
3563: pay_in_utils.set_location(g_debug,l_procedure, 110);
3564: --Current Date
3565: l_tag :=pay_in_xml_utils.getTag('c_current_date',to_char(SYSDATE,'DD-Mon-YYYY'));
3566: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3567: --Starting Year
3568: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
3569: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3570: --Ending Year

Line 3569: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3565: l_tag :=pay_in_xml_utils.getTag('c_current_date',to_char(SYSDATE,'DD-Mon-YYYY'));
3566: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3567: --Starting Year
3568: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
3569: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3570: --Ending Year
3571: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
3572: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3573: --Statuory Rate of Contribution

Line 3572: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3568: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
3569: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3570: --Ending Year
3571: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
3572: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3573: --Statuory Rate of Contribution
3574: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate
3575: FROM FF_GLOBALS_F
3576: WHERE GLOBAL_NAME ='IN_EMPLOYEE_PF_PERCENT'

Line 3581: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3577: AND LEGISLATION_CODE='IN'
3578: AND p_effective_start_date BETWEEN effective_start_date AND p_effective_end_date;
3579:
3580: l_tag :=pay_in_xml_utils.getTag('c_stat_rate',to_number(l_rate,99.99));
3581: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3582: l_tag := '';
3583: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3584: pay_in_utils.set_location(g_debug,l_procedure, 120);
3585: END LOOP;

Line 3583: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3579:
3580: l_tag :=pay_in_xml_utils.getTag('c_stat_rate',to_number(l_rate,99.99));
3581: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3582: l_tag := '';
3583: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3584: pay_in_utils.set_location(g_debug,l_procedure, 120);
3585: END LOOP;
3586: END IF;
3587: END LOOP;

Line 3591: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3587: END LOOP;
3588: --
3589: pay_in_utils.set_location(g_debug,l_procedure, 130);
3590: l_tag := '';
3591: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3592: fnd_file.put_line(fnd_file.log,'XML Created.');
3593: END create_form3a_xml;
3594:
3595:

Line 3822: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

3818: pay_in_xml_utils.gXMLTable.DELETE;
3819:
3820: --
3821: fnd_file.put_line(fnd_file.log,'Creating the XML...');
3822: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
3823: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3824: --
3825: l_tag :='';
3826: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 3823: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

3819:
3820: --
3821: fnd_file.put_line(fnd_file.log,'Creating the XML...');
3822: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
3823: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3824: --
3825: l_tag :='';
3826: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3827:

Line 3826: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3822: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
3823: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3824: --
3825: l_tag :='';
3826: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3827:
3828: l_tag := '';
3829: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3830: fnd_file.put_line(fnd_file.log,'Started...');

Line 3829: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3825: l_tag :='';
3826: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3827:
3828: l_tag := '';
3829: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3830: fnd_file.put_line(fnd_file.log,'Started...');
3831: --
3832:
3833: fnd_file.put_line(fnd_file.log,'Creating XML for Form7.');

Line 3838: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3834:
3835: --System Date
3836: l_sys_date_time := to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
3837: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);
3838: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3839:
3840:
3841: OPEN csr_global_value('IN_EPS_PERCENT');
3842: FETCH csr_global_value INTO l_eps_percent ;

Line 3919: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3915: FETCH csr_employee_details INTO l_employee_name,l_fath_husb_name,l_hire_date;
3916: CLOSE csr_employee_details;
3917:
3918: l_tag := '';
3919: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3920:
3921:
3922: -- Reset these variables for each pension number
3923: l_count :=1;

Line 4102: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4098: pay_in_xml_utils.multiColumnar('Organization',g_org_XMLTable,l_org_count,g_xml_data);
4099:
4100: --Current Date
4101: l_tag :=pay_in_xml_utils.getTag('c_current_date',to_char(sysdate,'DD-Mon-YYYY'));
4102: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4103:
4104: --Starting Year
4105: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
4106: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 4106: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4102: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4103:
4104: --Starting Year
4105: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
4106: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4107: --Ending Year
4108: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
4109: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4110:

Line 4109: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4105: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
4106: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4107: --Ending Year
4108: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
4109: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4110:
4111: l_tag := '';
4112: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4113: END IF;-- Excluded employee status end

Line 4112: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4108: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
4109: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4110:
4111: l_tag := '';
4112: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4113: END IF;-- Excluded employee status end
4114: END IF; -- Employee Type Check End
4115:
4116: END LOOP; -- End each pension number

Line 4122: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4118: fnd_file.put_line(fnd_file.log,'XML Created for a PF Org.Moving onto next');
4119: END LOOP; -- End Each Organization
4120:
4121: l_tag := '';
4122: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4123: fnd_file.put_line(fnd_file.log,'XML Created.');
4124: END create_form7_xml;
4125: --------------------------------------------------------------------------
4126: -- --

Line 4843: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

4839: pay_in_utils.trace('p_sysdate',p_sysdate);
4840:
4841: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
4842: fnd_file.put_line(fnd_file.log,'Creating the XML...');
4843: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
4844: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
4845: --
4846: l_tag :='';
4847: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 4844: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

4840:
4841: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
4842: fnd_file.put_line(fnd_file.log,'Creating the XML...');
4843: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
4844: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
4845: --
4846: l_tag :='';
4847: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4848: l_tag := '';

Line 4847: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4843: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
4844: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
4845: --
4846: l_tag :='';
4847: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4848: l_tag := '';
4849: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4850: fnd_file.put_line(fnd_file.log,'Started...');
4851: --

Line 4849: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4845: --
4846: l_tag :='';
4847: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4848: l_tag := '';
4849: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4850: fnd_file.put_line(fnd_file.log,'Started...');
4851: --
4852: fnd_file.put_line(fnd_file.log,'Creating XML for ESI Form 6.');
4853: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');

Line 4856: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4852: fnd_file.put_line(fnd_file.log,'Creating XML for ESI Form 6.');
4853: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
4854: --System Date:
4855: l_tag :=pay_in_xml_utils.getTag('c_sys_date_in_hh_mm_ss',l_sys_date_time);
4856: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4857: pay_in_utils.set_location(g_debug,l_procedure, 20);
4858:
4859: FOR c_rec IN c_distinct_org
4860: LOOP

Line 4877: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);

4873: ,l_rep_addr
4874: ,l_org_name;
4875: CLOSE c_org_details;
4876: --Starting Writing the data for this org on to the local clob varaible
4877: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
4878: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
4879: l_tag :='';
4880: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4881: l_tag :=pay_in_xml_utils.getTag('c_employer_code',l_employer_code);

Line 4878: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);

4874: ,l_org_name;
4875: CLOSE c_org_details;
4876: --Starting Writing the data for this org on to the local clob varaible
4877: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
4878: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
4879: l_tag :='';
4880: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4881: l_tag :=pay_in_xml_utils.getTag('c_employer_code',l_employer_code);
4882: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 4880: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

4876: --Starting Writing the data for this org on to the local clob varaible
4877: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
4878: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
4879: l_tag :='';
4880: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4881: l_tag :=pay_in_xml_utils.getTag('c_employer_code',l_employer_code);
4882: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4883: --Organization Name made in BLOCK
4884: l_tag :=pay_in_xml_utils.getTag('c_registered_name',upper(l_registered_name));

Line 4882: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

4878: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
4879: l_tag :='';
4880: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4881: l_tag :=pay_in_xml_utils.getTag('c_employer_code',l_employer_code);
4882: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4883: --Organization Name made in BLOCK
4884: l_tag :=pay_in_xml_utils.getTag('c_registered_name',upper(l_registered_name));
4885: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4886: l_tag :=pay_in_xml_utils.getTag('c_address',l_reg_address);

Line 4885: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

4881: l_tag :=pay_in_xml_utils.getTag('c_employer_code',l_employer_code);
4882: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4883: --Organization Name made in BLOCK
4884: l_tag :=pay_in_xml_utils.getTag('c_registered_name',upper(l_registered_name));
4885: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4886: l_tag :=pay_in_xml_utils.getTag('c_address',l_reg_address);
4887: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4888: --Organization Rep Name made in BLOCK
4889: l_tag :=pay_in_xml_utils.getTag('c_rep_name',upper(l_rep_name));

Line 4887: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

4883: --Organization Name made in BLOCK
4884: l_tag :=pay_in_xml_utils.getTag('c_registered_name',upper(l_registered_name));
4885: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4886: l_tag :=pay_in_xml_utils.getTag('c_address',l_reg_address);
4887: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4888: --Organization Rep Name made in BLOCK
4889: l_tag :=pay_in_xml_utils.getTag('c_rep_name',upper(l_rep_name));
4890: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4891: l_tag :=pay_in_xml_utils.getTag('c_rep_desg',l_rep_desg);

Line 4890: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

4886: l_tag :=pay_in_xml_utils.getTag('c_address',l_reg_address);
4887: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4888: --Organization Rep Name made in BLOCK
4889: l_tag :=pay_in_xml_utils.getTag('c_rep_name',upper(l_rep_name));
4890: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4891: l_tag :=pay_in_xml_utils.getTag('c_rep_desg',l_rep_desg);
4892: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4893: l_tag :=pay_in_xml_utils.getTag('c_rep_address',l_rep_addr);
4894: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 4892: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

4888: --Organization Rep Name made in BLOCK
4889: l_tag :=pay_in_xml_utils.getTag('c_rep_name',upper(l_rep_name));
4890: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4891: l_tag :=pay_in_xml_utils.getTag('c_rep_desg',l_rep_desg);
4892: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4893: l_tag :=pay_in_xml_utils.getTag('c_rep_address',l_rep_addr);
4894: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4895: l_tag :=pay_in_xml_utils.getTag('c_local_office',l_org_name);
4896: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 4894: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

4890: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4891: l_tag :=pay_in_xml_utils.getTag('c_rep_desg',l_rep_desg);
4892: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4893: l_tag :=pay_in_xml_utils.getTag('c_rep_address',l_rep_addr);
4894: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4895: l_tag :=pay_in_xml_utils.getTag('c_local_office',l_org_name);
4896: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4897:
4898: --Organization Specific Data written on the CLOB. Finding Contribution Periods

Line 4896: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

4892: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4893: l_tag :=pay_in_xml_utils.getTag('c_rep_address',l_rep_addr);
4894: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4895: l_tag :=pay_in_xml_utils.getTag('c_local_office',l_org_name);
4896: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4897:
4898: --Organization Specific Data written on the CLOB. Finding Contribution Periods
4899: l_contr_start := substr(p_contribution_period,1,8);
4900: l_contr_end := substr(p_contribution_period,11);

Line 4902: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

4898: --Organization Specific Data written on the CLOB. Finding Contribution Periods
4899: l_contr_start := substr(p_contribution_period,1,8);
4900: l_contr_end := substr(p_contribution_period,11);
4901: l_tag :=pay_in_xml_utils.getTag('c_contr_start',l_contr_start);
4902: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4903: l_tag :=pay_in_xml_utils.getTag('c_contr_end',l_contr_end);
4904: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4905: --Details of Contribution Period written to the CLOB.Finding Employee Details
4906: l_count := 1;

Line 4904: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

4900: l_contr_end := substr(p_contribution_period,11);
4901: l_tag :=pay_in_xml_utils.getTag('c_contr_start',l_contr_start);
4902: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4903: l_tag :=pay_in_xml_utils.getTag('c_contr_end',l_contr_end);
4904: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
4905: --Details of Contribution Period written to the CLOB.Finding Employee Details
4906: l_count := 1;
4907: l_employer_total := 0;
4908: l_employee_total := 0;

Line 5026: dbms_lob.Append(g_xml_data,l_xml_data);

5022: l_employer_total := l_employer_total + nvl(l_employer_contr,0);
5023: l_employee_total := l_employee_total + nvl(l_employee_contr,0);
5024:
5025: IF flag THEN
5026: dbms_lob.Append(g_xml_data,l_xml_data);
5027: flag := FALSE;
5028: END IF;
5029: l_tag :='';
5030: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5030: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5026: dbms_lob.Append(g_xml_data,l_xml_data);
5027: flag := FALSE;
5028: END IF;
5029: l_tag :='';
5030: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5031: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5033: l_tag :=pay_in_xml_utils.getTag('c_insurance_number',l_insurance_no);
5034: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5028: END IF;
5029: l_tag :='';
5030: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5031: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5033: l_tag :=pay_in_xml_utils.getTag('c_insurance_number',l_insurance_no);
5034: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5035: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5036: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5034: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5030: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5031: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5033: l_tag :=pay_in_xml_utils.getTag('c_insurance_number',l_insurance_no);
5034: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5035: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5036: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5037: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5036: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5033: l_tag :=pay_in_xml_utils.getTag('c_insurance_number',l_insurance_no);
5034: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5035: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5036: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5037: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5039: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5040: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5034: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5035: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5036: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5037: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5039: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5040: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5041: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5042: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5040: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5036: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5037: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5039: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5040: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5041: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5042: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5043: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5042: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5039: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5040: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5041: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5042: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5043: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5045: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5046: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5040: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5041: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5042: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5043: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5045: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5046: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5047: l_tag :=pay_in_xml_utils.getTag('c_avg_daily_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_avg_daily_wage));
5048: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5046: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5042: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5043: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5045: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5046: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5047: l_tag :=pay_in_xml_utils.getTag('c_avg_daily_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_avg_daily_wage));
5048: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5049: l_tag :='';
5050: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5048: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5045: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5046: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5047: l_tag :=pay_in_xml_utils.getTag('c_avg_daily_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_avg_daily_wage));
5048: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5049: l_tag :='';
5050: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5051: l_count := l_count + 1;
5052: l_con_tot := l_con_tot + nvl(l_employee_contr,0);

Line 5050: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5046: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5047: l_tag :=pay_in_xml_utils.getTag('c_avg_daily_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_avg_daily_wage));
5048: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5049: l_tag :='';
5050: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5051: l_count := l_count + 1;
5052: l_con_tot := l_con_tot + nvl(l_employee_contr,0);
5053: l_wages_tot := l_wages_tot + nvl(l_actual_salary,0);
5054: l_days_tot := l_days_tot + nvl(l_days,0);

Line 5059: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5055: END IF;
5056: END LOOP;
5057:
5058: l_tag :=pay_in_xml_utils.getTag('c_total_con',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_con_tot));
5059: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5060: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5061: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5062: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5063: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5061: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5057:
5058: l_tag :=pay_in_xml_utils.getTag('c_total_con',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_con_tot));
5059: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5060: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5061: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5062: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5063: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5064:
5065: dbms_lob.close(l_xml_data);

Line 5063: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5059: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5060: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5061: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5062: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5063: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5064:
5065: dbms_lob.close(l_xml_data);
5066: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5067: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);

Line 5065: dbms_lob.close(l_xml_data);

5061: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5062: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5063: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5064:
5065: dbms_lob.close(l_xml_data);
5066: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5067: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5068: --Employer Share, Employee Share and Total Contribution
5069: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));

Line 5066: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);

5062: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5063: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5064:
5065: dbms_lob.close(l_xml_data);
5066: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5067: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5068: --Employer Share, Employee Share and Total Contribution
5069: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5070: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5067: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);

5063: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5064:
5065: dbms_lob.close(l_xml_data);
5066: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5067: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5068: --Employer Share, Employee Share and Total Contribution
5069: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5070: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5071: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));

Line 5070: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5066: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5067: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5068: --Employer Share, Employee Share and Total Contribution
5069: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5070: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5071: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5072: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5073: l_tag :=pay_in_xml_utils.getTag('c_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total + l_employer_total));
5074: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5072: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5068: --Employer Share, Employee Share and Total Contribution
5069: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5070: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5071: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5072: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5073: l_tag :=pay_in_xml_utils.getTag('c_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total + l_employer_total));
5074: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5075: --Challan Details
5076: l_count := 1;

Line 5074: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5070: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5071: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5072: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5073: l_tag :=pay_in_xml_utils.getTag('c_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total + l_employer_total));
5074: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5075: --Challan Details
5076: l_count := 1;
5077: l_challan_tot := 0;
5078: pay_in_utils.set_location(g_debug,l_procedure, 100);

Line 5088: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5084: CLOSE c_branch_dtls;
5085:
5086:
5087: l_tag :='';
5088: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5089: l_tag :=pay_in_xml_utils.getTag('c_sl',l_count);
5090: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5091: l_tag :=pay_in_xml_utils.getTag('c_month',c_challan_rec.month);
5092: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5090: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5086:
5087: l_tag :='';
5088: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5089: l_tag :=pay_in_xml_utils.getTag('c_sl',l_count);
5090: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5091: l_tag :=pay_in_xml_utils.getTag('c_month',c_challan_rec.month);
5092: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5093: l_tag :=pay_in_xml_utils.getTag('c_challan_date',c_challan_rec.challan_date);
5094: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5092: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5088: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5089: l_tag :=pay_in_xml_utils.getTag('c_sl',l_count);
5090: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5091: l_tag :=pay_in_xml_utils.getTag('c_month',c_challan_rec.month);
5092: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5093: l_tag :=pay_in_xml_utils.getTag('c_challan_date',c_challan_rec.challan_date);
5094: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5095: l_tag :=pay_in_xml_utils.getTag('c_challan_paid',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_challan_rec.challan_amt));
5096: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5094: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5090: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5091: l_tag :=pay_in_xml_utils.getTag('c_month',c_challan_rec.month);
5092: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5093: l_tag :=pay_in_xml_utils.getTag('c_challan_date',c_challan_rec.challan_date);
5094: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5095: l_tag :=pay_in_xml_utils.getTag('c_challan_paid',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_challan_rec.challan_amt));
5096: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5097: l_tag :=pay_in_xml_utils.getTag('c_challan_bank',c_challan_rec.challan_bank);
5098: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5096: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5092: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5093: l_tag :=pay_in_xml_utils.getTag('c_challan_date',c_challan_rec.challan_date);
5094: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5095: l_tag :=pay_in_xml_utils.getTag('c_challan_paid',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_challan_rec.challan_amt));
5096: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5097: l_tag :=pay_in_xml_utils.getTag('c_challan_bank',c_challan_rec.challan_bank);
5098: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5099: l_tag :=pay_in_xml_utils.getTag('c_challan_branch',l_bank_branch_name);
5100: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5098: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5094: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5095: l_tag :=pay_in_xml_utils.getTag('c_challan_paid',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_challan_rec.challan_amt));
5096: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5097: l_tag :=pay_in_xml_utils.getTag('c_challan_bank',c_challan_rec.challan_bank);
5098: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5099: l_tag :=pay_in_xml_utils.getTag('c_challan_branch',l_bank_branch_name);
5100: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5101: l_challan_tot := l_challan_tot + nvl(c_challan_rec.challan_amt,0);
5102: l_count := l_count + 1;

Line 5100: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5096: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5097: l_tag :=pay_in_xml_utils.getTag('c_challan_bank',c_challan_rec.challan_bank);
5098: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5099: l_tag :=pay_in_xml_utils.getTag('c_challan_branch',l_bank_branch_name);
5100: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5101: l_challan_tot := l_challan_tot + nvl(c_challan_rec.challan_amt,0);
5102: l_count := l_count + 1;
5103: l_tag :='';
5104: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5104: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5100: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5101: l_challan_tot := l_challan_tot + nvl(c_challan_rec.challan_amt,0);
5102: l_count := l_count + 1;
5103: l_tag :='';
5104: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5105: END LOOP;
5106: l_tag :=pay_in_xml_utils.getTag('c_challan_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_challan_tot));
5107: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5108:

Line 5107: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5103: l_tag :='';
5104: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5105: END LOOP;
5106: l_tag :=pay_in_xml_utils.getTag('c_challan_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_challan_tot));
5107: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5108:
5109:
5110: --Declaration Details
5111: OPEN c_declaration(c_rec.org_id);

Line 5128: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5124: ,l_wages_immd_emplr_not_covered ;
5125: CLOSE c_declaration ;
5126:
5127: l_tag := '';
5128: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5129: l_tag :=pay_in_xml_utils.getTag('c_declaration_forms',l_declaration_forms);
5130: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5131: l_tag := pay_in_xml_utils.getTag('c_tic',l_tic);
5132: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5130: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5126:
5127: l_tag := '';
5128: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5129: l_tag :=pay_in_xml_utils.getTag('c_declaration_forms',l_declaration_forms);
5130: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5131: l_tag := pay_in_xml_utils.getTag('c_tic',l_tic);
5132: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5133: l_tag := pay_in_xml_utils.getTag('c_pic_received',l_pic_received);
5134: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5132: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5128: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5129: l_tag :=pay_in_xml_utils.getTag('c_declaration_forms',l_declaration_forms);
5130: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5131: l_tag := pay_in_xml_utils.getTag('c_tic',l_tic);
5132: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5133: l_tag := pay_in_xml_utils.getTag('c_pic_received',l_pic_received);
5134: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5135: l_tag := pay_in_xml_utils.getTag('c_pic_distributed',l_pic_distributed);
5136: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5134: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5130: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5131: l_tag := pay_in_xml_utils.getTag('c_tic',l_tic);
5132: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5133: l_tag := pay_in_xml_utils.getTag('c_pic_received',l_pic_received);
5134: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5135: l_tag := pay_in_xml_utils.getTag('c_pic_distributed',l_pic_distributed);
5136: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5137: l_tag := pay_in_xml_utils.getTag('c_accidents_reported',l_accidents_reported);
5138: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5136: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5132: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5133: l_tag := pay_in_xml_utils.getTag('c_pic_received',l_pic_received);
5134: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5135: l_tag := pay_in_xml_utils.getTag('c_pic_distributed',l_pic_distributed);
5136: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5137: l_tag := pay_in_xml_utils.getTag('c_accidents_reported',l_accidents_reported);
5138: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5139: l_tag := pay_in_xml_utils.getTag('c_direct_covered_employees',l_direct_covered_employees);
5140: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5138: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5134: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5135: l_tag := pay_in_xml_utils.getTag('c_pic_distributed',l_pic_distributed);
5136: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5137: l_tag := pay_in_xml_utils.getTag('c_accidents_reported',l_accidents_reported);
5138: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5139: l_tag := pay_in_xml_utils.getTag('c_direct_covered_employees',l_direct_covered_employees);
5140: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5141: l_tag := pay_in_xml_utils.getTag('c_direct_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_covered_wages));
5142: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5140: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5136: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5137: l_tag := pay_in_xml_utils.getTag('c_accidents_reported',l_accidents_reported);
5138: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5139: l_tag := pay_in_xml_utils.getTag('c_direct_covered_employees',l_direct_covered_employees);
5140: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5141: l_tag := pay_in_xml_utils.getTag('c_direct_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_covered_wages));
5142: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5143: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5144: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5142: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5138: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5139: l_tag := pay_in_xml_utils.getTag('c_direct_covered_employees',l_direct_covered_employees);
5140: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5141: l_tag := pay_in_xml_utils.getTag('c_direct_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_covered_wages));
5142: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5143: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5144: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5145: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));
5146: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5144: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5140: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5141: l_tag := pay_in_xml_utils.getTag('c_direct_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_covered_wages));
5142: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5143: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5144: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5145: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));
5146: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5147: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5148: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5146: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5142: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5143: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5144: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5145: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));
5146: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5147: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5148: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5149: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));
5150: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5148: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5144: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5145: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));
5146: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5147: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5148: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5149: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));
5150: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5151: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5152: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5150: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5146: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5147: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5148: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5149: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));
5150: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5151: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5152: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5153: l_tag := pay_in_xml_utils.getTag('c_wages_immd_emplr_not_covered',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immd_emplr_not_covered));
5154: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5152: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5148: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5149: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));
5150: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5151: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5152: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5153: l_tag := pay_in_xml_utils.getTag('c_wages_immd_emplr_not_covered',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immd_emplr_not_covered));
5154: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5155: l_tag := '';
5156: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5154: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5150: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5151: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5152: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5153: l_tag := pay_in_xml_utils.getTag('c_wages_immd_emplr_not_covered',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immd_emplr_not_covered));
5154: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5155: l_tag := '';
5156: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5157:
5158:

Line 5156: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5152: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5153: l_tag := pay_in_xml_utils.getTag('c_wages_immd_emplr_not_covered',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immd_emplr_not_covered));
5154: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5155: l_tag := '';
5156: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5157:
5158:
5159:
5160: --Element Details computing the Base Salary for ESI Calculation.

Line 5165: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5161: l_count := 1;
5162: FOR rec_elements IN c_elements
5163: LOOP
5164: l_tag := '';
5165: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5166: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5167: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5168: l_count := l_count + 1;
5169: l_tag := pay_in_xml_utils.getTag('c_elements',rec_elements.element_name);

Line 5167: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5163: LOOP
5164: l_tag := '';
5165: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5166: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5167: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5168: l_count := l_count + 1;
5169: l_tag := pay_in_xml_utils.getTag('c_elements',rec_elements.element_name);
5170: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5171: l_tag := '';

Line 5170: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5166: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5167: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5168: l_count := l_count + 1;
5169: l_tag := pay_in_xml_utils.getTag('c_elements',rec_elements.element_name);
5170: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5171: l_tag := '';
5172: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5173: END LOOP ;
5174:

Line 5172: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5168: l_count := l_count + 1;
5169: l_tag := pay_in_xml_utils.getTag('c_elements',rec_elements.element_name);
5170: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5171: l_tag := '';
5172: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5173: END LOOP ;
5174:
5175:
5176: l_tag :='';

Line 5177: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5173: END LOOP ;
5174:
5175:
5176: l_tag :='';
5177: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5178: IF flag = FALSE THEN
5179: dbms_lob.Append(g_xml_data,l_xml_data);
5180: END IF;
5181: dbms_lob.close(l_xml_data);

Line 5179: dbms_lob.Append(g_xml_data,l_xml_data);

5175:
5176: l_tag :='';
5177: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5178: IF flag = FALSE THEN
5179: dbms_lob.Append(g_xml_data,l_xml_data);
5180: END IF;
5181: dbms_lob.close(l_xml_data);
5182: pay_in_utils.set_location(g_debug,l_procedure, 110);
5183: END LOOP;

Line 5181: dbms_lob.close(l_xml_data);

5177: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5178: IF flag = FALSE THEN
5179: dbms_lob.Append(g_xml_data,l_xml_data);
5180: END IF;
5181: dbms_lob.close(l_xml_data);
5182: pay_in_utils.set_location(g_debug,l_procedure, 110);
5183: END LOOP;
5184: l_tag :='';
5185: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5185: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5181: dbms_lob.close(l_xml_data);
5182: pay_in_utils.set_location(g_debug,l_procedure, 110);
5183: END LOOP;
5184: l_tag :='';
5185: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5186:
5187: fnd_file.put_line(fnd_file.log,'XML Created.');
5188: END create_esi_xml;
5189: