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

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

65: IS
66: pos PLS_INTEGER := 1;
67: buffer RAW(32767);
68: res BLOB;
69: lob_len PLS_INTEGER := dbms_lob.getlength(c);
70: BEGIN
71: -- hr_utility.trace('+====c2b===================================================+');
72: dbms_lob.createtemporary(res,TRUE);
73: dbms_lob.open(res,dbms_lob.lob_readwrite);

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

68: res BLOB;
69: lob_len PLS_INTEGER := dbms_lob.getlength(c);
70: BEGIN
71: -- hr_utility.trace('+====c2b===================================================+');
72: dbms_lob.createtemporary(res,TRUE);
73: dbms_lob.open(res,dbms_lob.lob_readwrite);
74: LOOP
75: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
76: IF utl_raw.length( buffer ) > 0 THEN

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

69: lob_len PLS_INTEGER := dbms_lob.getlength(c);
70: BEGIN
71: -- hr_utility.trace('+====c2b===================================================+');
72: dbms_lob.createtemporary(res,TRUE);
73: dbms_lob.open(res,dbms_lob.lob_readwrite);
74: LOOP
75: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
76: IF utl_raw.length( buffer ) > 0 THEN
77: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);

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

71: -- hr_utility.trace('+====c2b===================================================+');
72: dbms_lob.createtemporary(res,TRUE);
73: dbms_lob.open(res,dbms_lob.lob_readwrite);
74: LOOP
75: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
76: IF utl_raw.length( buffer ) > 0 THEN
77: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);
78: END IF;
79: pos := pos + 16000;

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

73: dbms_lob.open(res,dbms_lob.lob_readwrite);
74: LOOP
75: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
76: IF utl_raw.length( buffer ) > 0 THEN
77: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);
78: END IF;
79: pos := pos + 16000;
80: EXIT WHEN pos > lob_len;
81: END LOOP;

Line 212: dbms_lob.createtemporary(p_clob, FALSE, DBMS_LOB.CALL);

208:
209: fnd_file.put_line(fnd_file.log,'+====write_to_clob==========================================+');
210:
211: l_str := ''||EOL;
212: dbms_lob.createtemporary(p_clob, FALSE, DBMS_LOB.CALL);
213: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);
214:
215: IF p_abp_output_type IN ('NLABP_PDF','NLABP_CSV') THEN
216: l_string := report_header_xml(p_payroll_action_id);

Line 213: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);

209: fnd_file.put_line(fnd_file.log,'+====write_to_clob==========================================+');
210:
211: l_str := ''||EOL;
212: dbms_lob.createtemporary(p_clob, FALSE, DBMS_LOB.CALL);
213: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);
214:
215: IF p_abp_output_type IN ('NLABP_PDF','NLABP_CSV') THEN
216: l_string := report_header_xml(p_payroll_action_id);
217: dbms_lob.writeAppend(p_clob, length(l_string), l_string);

Line 217: dbms_lob.writeAppend(p_clob, length(l_string), l_string);

213: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);
214:
215: IF p_abp_output_type IN ('NLABP_PDF','NLABP_CSV') THEN
216: l_string := report_header_xml(p_payroll_action_id);
217: dbms_lob.writeAppend(p_clob, length(l_string), l_string);
218: END IF;
219:
220: IF p_XMLTable.COUNT > 0 THEN
221: FOR table_counter IN p_XMLTable.FIRST .. p_XMLTable.LAST

Line 232: dbms_lob.writeappend(p_clob, length(l_xml_element), l_xml_element);

228: l_xml_element := '<' || p_XMLTable(table_counter).tagname ||
229: '>'|| clean_XML(p_XMLTable(table_counter).tagvalue) ||
230: ''||EOL;
231: END IF;
232: dbms_lob.writeappend(p_clob, length(l_xml_element), l_xml_element);
233: END LOOP;
234: ELSE
235: dbms_lob.writeAppend(p_clob, length(l_str), l_str );
236: END IF;

Line 235: dbms_lob.writeAppend(p_clob, length(l_str), l_str );

231: END IF;
232: dbms_lob.writeappend(p_clob, length(l_xml_element), l_xml_element);
233: END LOOP;
234: ELSE
235: dbms_lob.writeAppend(p_clob, length(l_str), l_str );
236: END IF;
237:
238: IF p_abp_output_type IN ('NLABP_PDF','NLABP_CSV') THEN
239: l_string1 := ''||EOL ;

Line 240: dbms_lob.writeAppend(p_clob, length(l_string1), l_string1);

236: END IF;
237:
238: IF p_abp_output_type IN ('NLABP_PDF','NLABP_CSV') THEN
239: l_string1 := ''||EOL ;
240: dbms_lob.writeAppend(p_clob, length(l_string1), l_string1);
241: END IF;
242:
243: fnd_file.put_line(fnd_file.log,'X====WRITE_to_clob==========================================X');
244:

Line 1027: dbms_lob.freeTemporary(l_xml);

1023: ,p_abp_output_type => p_abp_output_type
1024: ,p_payroll_action_id => p_action_context_id);
1025:
1026: p_xml := l_xml;
1027: dbms_lob.freeTemporary(l_xml);
1028:
1029: fnd_file.put_line(fnd_file.log,'X====Generate====================X '|| p_action_context_id);
1030:
1031: /* 14832638 - Set CP Output type to XML for XML report */