DBA Data[Home] [Help]

APPS.PER_JP_EMPDET_REPORT_PKG dependencies on PAY_CORE_FILES

Line 2001: pay_core_files.write_to_magtape_lob(lc_xml_string1);

1997: BEGIN
1998: LOOP
1999: lc_xml_string1 := NULL;
2000: dbms_lob.read(l_final_xml_string,ln_amount,ln_offset,lc_xml_string1);
2001: pay_core_files.write_to_magtape_lob(lc_xml_string1);
2002: ln_offset := ln_offset + ln_amount;
2003: END LOOP;
2004: EXCEPTION
2005: WHEN no_data_found THEN

Line 2014: pay_core_files.write_to_magtape_lob(lc_xml_string1);

2010: --
2011: IF gr_parameters.img_display = 'Y' THEN
2012: --
2013: lc_xml_string1 :='';
2014: pay_core_files.write_to_magtape_lob(lc_xml_string1);
2015: --
2016:
2017: OPEN lcu_emp_det_blob(ln_old_assact_id);
2018: FETCH lcu_emp_det_blob INTO ln_assignment_id;

Line 2039: pay_core_files.write_to_magtape_lob(lc_xml_varchar);

2035: lc_xml_raw := '';
2036: lc_xml_varchar := NULL;
2037: dbms_lob.read(lblob_image,ln_amount_blob,ln_offset_blob,lc_xml_raw);
2038: lc_xml_varchar := utl_raw.cast_to_varchar2(utl_encode.base64_encode(lc_xml_raw));
2039: pay_core_files.write_to_magtape_lob(lc_xml_varchar);
2040: ln_offset_blob := ln_offset_blob + ln_amount_blob;
2041: END LOOP;
2042: EXCEPTION
2043: WHEN no_data_found THEN

Line 2051: pay_core_files.write_to_magtape_lob(lc_xml_string1);

2047: END;
2048: END IF;
2049:
2050: lc_xml_string1 := ''||gc_eol||''||gc_eol ;
2051: pay_core_files.write_to_magtape_lob(lc_xml_string1);
2052: ELSE
2053: lc_xml_string1 :=''||gc_eol ;
2054: pay_core_files.write_to_magtape_lob(lc_xml_string1);
2055: END IF;

Line 2054: pay_core_files.write_to_magtape_lob(lc_xml_string1);

2050: lc_xml_string1 := ''||gc_eol||''||gc_eol ;
2051: pay_core_files.write_to_magtape_lob(lc_xml_string1);
2052: ELSE
2053: lc_xml_string1 :=''||gc_eol ;
2054: pay_core_files.write_to_magtape_lob(lc_xml_string1);
2055: END IF;
2056:
2057: EXCEPTION
2058: WHEN NO_DATA_FOUND THEN

Line 2110: pay_core_files.write_to_magtape_lob(lc_buf);

2106: vxmltable.DELETE; -- delete the pl/sql table
2107: --
2108: lc_buf := gc_eol ||''||gc_eol ;
2109: --
2110: pay_core_files.write_to_magtape_lob(lc_buf);
2111: --
2112: IF gb_debug THEN
2113: hr_utility.set_location ('CLOB contents after appending header information',20);
2114: hr_utility.set_location ('Leaving '||lc_proc_name,20);

Line 2154: pay_core_files.write_to_magtape_lob(lc_buf);

2150: hr_utility.set_location ('Entering '||lc_proc_name,20);
2151: END IF ;
2152: lc_buf := '' ;
2153: --
2154: pay_core_files.write_to_magtape_lob(lc_buf);
2155: --
2156: IF gb_debug THEN
2157: hr_utility.set_location ('CLOB contents after appending footer information',20);
2158: hr_utility.set_location ('Leaving '||lc_proc_name,20);