1: PACKAGE BODY PAY_PAYRPENP_XML_PKG AS
2: /* $Header: pyxmlenp.pkb 120.1 2006/01/04 01:05 pgongada noship $ */
3:
4: g_package_name varchar2(30) := 'PAY_PAYRPENP_XML_PKG';
5: g_xml_data clob;
1: PACKAGE BODY PAY_PAYRPENP_XML_PKG AS
2: /* $Header: pyxmlenp.pkb 120.1 2006/01/04 01:05 pgongada noship $ */
3:
4: g_package_name varchar2(30) := 'PAY_PAYRPENP_XML_PKG';
5: g_xml_data clob;
6:
7: --
8: -- Private function to get the template name.
564: open csr_get_bg_name(p_business_group_id);
565: fetch csr_get_bg_name into l_business_group_name;
566: close csr_get_bg_name;
567:
568: l_location_code := payrpenp.get_location_code(p_location_id);
569:
570: l_template_name := get_template_name('PAY', p_template_name);
571:
572: --
647:
648: l_tag :='';
649: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
650:
651: l_tag := '
653:
654: l_tag := '
655: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
762: ,p_sort_option_three
763: ,l_template_name
764: );
765:
766: l_tag := '';
767: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
768:
769: p_xml := g_xml_data;
770:
771: end emp_asg_not_processed;
772:
773:
774:
775: end PAY_PAYRPENP_XML_PKG;