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

Line 216: dbms_lob.read(

212: ln_chars := 240;
213: ln_offset := 1;
214: LOOP
215: lv_buf := null;
216: dbms_lob.read(
217: p_clob,
218: ln_chars,
219: ln_offset,
220: lv_buf

Line 1853: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);

1849: l_xfdf_string CLOB;
1850: ctr_table NUMBER;
1851: tempclob clob;
1852: BEGIN
1853: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1854: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1855: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1856: LOOP
1857: dbms_lob.writeAppend(l_xfdf_string,

Line 1854: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

1850: ctr_table NUMBER;
1851: tempclob clob;
1852: BEGIN
1853: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1854: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1855: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1856: LOOP
1857: dbms_lob.writeAppend(l_xfdf_string,
1858: length(vXMLTable(ctr_table).xmlstring),

Line 1857: dbms_lob.writeAppend(l_xfdf_string,

1853: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1854: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1855: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST
1856: LOOP
1857: dbms_lob.writeAppend(l_xfdf_string,
1858: length(vXMLTable(ctr_table).xmlstring),
1859: vXMLTable(ctr_table).xmlstring );
1860: END LOOP;
1861: p_write_xml := l_xfdf_string;

Line 1863: dbms_lob.close(l_xfdf_string);

1859: vXMLTable(ctr_table).xmlstring );
1860: END LOOP;
1861: p_write_xml := l_xfdf_string;
1862: hr_utility.set_location('Out of loop ', 99);
1863: dbms_lob.close(l_xfdf_string);
1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1867: HR_UTILITY.RAISE_ERROR;

Line 1903: dbms_lob.createtemporary(l_xml,TRUE) ;

1899: l_header := '' || EOL ||'';
1900: l_footer := '';
1901: assact_xml(p_assignment_action_id);
1902: WritetoCLOB(p_ss_xml);
1903: dbms_lob.createtemporary(l_xml,TRUE) ;
1904: dbms_lob.writeAppend(l_xml,
1905: length(l_header),
1906: l_header);
1907: dbms_lob.append(l_xml, p_ss_xml);

Line 1904: dbms_lob.writeAppend(l_xml,

1900: l_footer := '';
1901: assact_xml(p_assignment_action_id);
1902: WritetoCLOB(p_ss_xml);
1903: dbms_lob.createtemporary(l_xml,TRUE) ;
1904: dbms_lob.writeAppend(l_xml,
1905: length(l_header),
1906: l_header);
1907: dbms_lob.append(l_xml, p_ss_xml);
1908: dbms_lob.writeAppend(l_xml,

Line 1907: dbms_lob.append(l_xml, p_ss_xml);

1903: dbms_lob.createtemporary(l_xml,TRUE) ;
1904: dbms_lob.writeAppend(l_xml,
1905: length(l_header),
1906: l_header);
1907: dbms_lob.append(l_xml, p_ss_xml);
1908: dbms_lob.writeAppend(l_xml,
1909: length(l_footer),
1910: l_footer);
1911: p_xml := l_xml ;

Line 1908: dbms_lob.writeAppend(l_xml,

1904: dbms_lob.writeAppend(l_xml,
1905: length(l_header),
1906: l_header);
1907: dbms_lob.append(l_xml, p_ss_xml);
1908: dbms_lob.writeAppend(l_xml,
1909: length(l_footer),
1910: l_footer);
1911: p_xml := l_xml ;
1912: END get_ss_xml;

Line 1964: dbms_lob.read(l_final_xml_string,l_amount,l_offset,xml_string1);

1960: l_amount := 500;
1961: --
1962: LOOP
1963: xml_string1 := null;
1964: dbms_lob.read(l_final_xml_string,l_amount,l_offset,xml_string1);
1965: pay_core_files.write_to_magtape_lob(xml_string1);
1966: l_offset := l_offset + l_amount ;
1967: END LOOP;
1968: EXCEPTION