426:
427: BEGIN
428: --
429: Fnd_file.put_line(FND_FILE.LOG,'######## IN Header');
430: -- pay_core_files.write_to_magtape_lob('');
431: -- pay_core_files.write_to_magtape_lob('
432: --
433: l_final_xml_string := NULL ;
434: l_string := NULL ;
427: BEGIN
428: --
429: Fnd_file.put_line(FND_FILE.LOG,'######## IN Header');
430: -- pay_core_files.write_to_magtape_lob('');
431: -- pay_core_files.write_to_magtape_lob('
433: l_final_xml_string := NULL ;
434: l_string := NULL ;
435:
516:
517:
518: --l_final_xml_string := '
519: --
520: pay_core_files.write_to_magtape_lob(l_final_xml_string);
521: --
522: Fnd_file.put_line(FND_FILE.LOG,'######## IN Header End');
523: END xml_header;
524: --------------------------------------------------------------------------------
528: l_final_xml_string VARCHAR2(32000) := NULL;
529: BEGIN
530: --
531: Fnd_file.put_line(FND_FILE.LOG,'######## IN Footer');
532: -- pay_core_files.write_to_magtape_lob('');
533: l_final_xml_string := NULL ;
534: --
535: l_final_xml_string := '' ;
536: --
533: l_final_xml_string := NULL ;
534: --
535: l_final_xml_string := '' ;
536: --
537: pay_core_files.write_to_magtape_lob(l_final_xml_string);
538: --
539: Fnd_file.put_line(FND_FILE.LOG,'######## IN Footer End');
540: --
541: END xml_footer;
614: --
615: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');
616: l_end_dt := TO_DATE(l_end_date,'YYYY/MM/DD');
617: --
618: --pay_core_files.write_to_magtape_lob('');
619: --pay_core_files.write_to_magtape_lob('
620: Fnd_file.put_line(FND_FILE.LOG,'######## IN Out of the Loop');
621: --
622: FOR csr_archive_act_rec in csr_archive_act(l_payroll_id
615: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');
616: l_end_dt := TO_DATE(l_end_date,'YYYY/MM/DD');
617: --
618: --pay_core_files.write_to_magtape_lob('');
619: --pay_core_files.write_to_magtape_lob('
621: --
622: FOR csr_archive_act_rec in csr_archive_act(l_payroll_id
623: ,l_consolidation_set_id
637: ,P_ROOT_TAG => 'PAYSLIP'
638: ,P_DOCUMENT_TYPE => 'PAYSLIP'
639: ,P_XML => l_xml);
640: --
641: pay_core_files.write_to_magtape_lob(l_xml);
642: --
643: END LOOP;
644: --
645: --pay_core_files.write_to_magtape_lob('');
641: pay_core_files.write_to_magtape_lob(l_xml);
642: --
643: END LOOP;
644: --
645: --pay_core_files.write_to_magtape_lob('');
646: --
647: END xml_asg;
648: --
649: END pay_se_payslip_report;