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.PER_NL_DSR_ARCHIVE dependencies on DBMS_LOB

Line 17: lob_len PLS_INTEGER := dbms_lob.getlength(c);

13: IS
14: pos PLS_INTEGER := 1;
15: buffer RAW(32767);
16: res BLOB;
17: lob_len PLS_INTEGER := dbms_lob.getlength(c);
18: BEGIN
19: -- hr_utility.trace('+====c2b===================================================+');
20: dbms_lob.createtemporary(res,TRUE);
21: dbms_lob.open(res,dbms_lob.lob_readwrite);

Line 20: dbms_lob.createtemporary(res,TRUE);

16: res BLOB;
17: lob_len PLS_INTEGER := dbms_lob.getlength(c);
18: BEGIN
19: -- hr_utility.trace('+====c2b===================================================+');
20: dbms_lob.createtemporary(res,TRUE);
21: dbms_lob.open(res,dbms_lob.lob_readwrite);
22: LOOP
23: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
24: IF utl_raw.length( buffer ) > 0 THEN

Line 21: dbms_lob.open(res,dbms_lob.lob_readwrite);

17: lob_len PLS_INTEGER := dbms_lob.getlength(c);
18: BEGIN
19: -- hr_utility.trace('+====c2b===================================================+');
20: dbms_lob.createtemporary(res,TRUE);
21: dbms_lob.open(res,dbms_lob.lob_readwrite);
22: LOOP
23: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
24: IF utl_raw.length( buffer ) > 0 THEN
25: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);

Line 23: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );

19: -- hr_utility.trace('+====c2b===================================================+');
20: dbms_lob.createtemporary(res,TRUE);
21: dbms_lob.open(res,dbms_lob.lob_readwrite);
22: LOOP
23: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
24: IF utl_raw.length( buffer ) > 0 THEN
25: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);
26: END IF;
27: pos := pos + 16000;

Line 25: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);

21: dbms_lob.open(res,dbms_lob.lob_readwrite);
22: LOOP
23: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
24: IF utl_raw.length( buffer ) > 0 THEN
25: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);
26: END IF;
27: pos := pos + 16000;
28: EXIT WHEN pos > lob_len;
29: END LOOP;

Line 148: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

144: l_xml_element VARCHAR2(800);
145: l_clob CLOB;
146: BEGIN
147: hr_utility.trace('+====write_report==========================================+');
148: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
149: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
150:
151: IF p_XMLTable.COUNT > 0 THEN
152:

Line 149: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);

145: l_clob CLOB;
146: BEGIN
147: hr_utility.trace('+====write_report==========================================+');
148: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
149: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
150:
151: IF p_XMLTable.COUNT > 0 THEN
152:
153: FOR table_counter IN p_XMLTable.FIRST .. p_XMLTable.LAST

Line 165: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);

161: '>'|| clean_XML(p_XMLTable(table_counter).tagvalue) ||
162: ''||EOL;
163: END IF;
164: -- IF p_XMLTable(table_counter).tagvalue IS NOT NULL THEN
165: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);
166: -- END IF;
167: END LOOP;
168: END IF;
169: IF l_clob IS NOT NULL THEN