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

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

3815: l_str7 := '
3816:
3817:
3818: ';
3819: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
3820: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
3821: if vXMLTable.count > 0 then
3822: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
3823: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

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

3816:
3817:
3818: ';
3819: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
3820: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
3821: if vXMLTable.count > 0 then
3822: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
3823: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
3824: l_str8 := vXMLTable(ctr_table).TagName;

Line 3822: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

3818: ';
3819: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
3820: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
3821: if vXMLTable.count > 0 then
3822: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
3823: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
3824: l_str8 := vXMLTable(ctr_table).TagName;
3825: l_str9 := vXMLTable(ctr_table).TagValue;
3826: if (l_str9 is not null) then

Line 3829: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );

3825: l_str9 := vXMLTable(ctr_table).TagValue;
3826: if (l_str9 is not null) then
3827: /* Added CDATA to handle special characters Bug No:8741752 */
3828: l_str9 := '';
3829: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
3830: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
3831: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
3832: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
3833: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

Line 3830: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);

3826: if (l_str9 is not null) then
3827: /* Added CDATA to handle special characters Bug No:8741752 */
3828: l_str9 := '';
3829: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
3830: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
3831: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
3832: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
3833: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
3834: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

Line 3831: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );

3827: /* Added CDATA to handle special characters Bug No:8741752 */
3828: l_str9 := '';
3829: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
3830: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
3831: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
3832: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
3833: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
3834: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
3835: elsif (l_str9 is null and l_str8 is not null) then

Line 3832: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );

3828: l_str9 := '';
3829: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
3830: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
3831: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
3832: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
3833: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
3834: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
3835: elsif (l_str9 is null and l_str8 is not null) then
3836: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

Line 3833: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

3829: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
3830: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
3831: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
3832: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
3833: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
3834: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
3835: elsif (l_str9 is null and l_str8 is not null) then
3836: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
3837: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

Line 3834: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

3830: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
3831: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
3832: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
3833: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
3834: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
3835: elsif (l_str9 is null and l_str8 is not null) then
3836: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
3837: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
3838: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

Line 3836: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

3832: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
3833: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
3834: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
3835: elsif (l_str9 is null and l_str8 is not null) then
3836: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
3837: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
3838: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
3839: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
3840: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

Line 3837: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

3833: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
3834: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
3835: elsif (l_str9 is null and l_str8 is not null) then
3836: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
3837: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
3838: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
3839: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
3840: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
3841: else

Line 3838: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

3834: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
3835: elsif (l_str9 is null and l_str8 is not null) then
3836: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
3837: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
3838: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
3839: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
3840: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
3841: else
3842: null;

Line 3839: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);

3835: elsif (l_str9 is null and l_str8 is not null) then
3836: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
3837: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
3838: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
3839: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
3840: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
3841: else
3842: null;
3843: end if;

Line 3840: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

3836: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
3837: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
3838: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
3839: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
3840: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
3841: else
3842: null;
3843: end if;
3844: END LOOP;

Line 3845: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );

3841: else
3842: null;
3843: end if;
3844: END LOOP;
3845: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
3846: else
3847: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
3848: end if;
3849: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

Line 3847: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );

3843: end if;
3844: END LOOP;
3845: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
3846: else
3847: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
3848: end if;
3849: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
3850: clob_to_blob(l_xfdf_string,p_xfdf_blob);
3851: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

Line 3849: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

3845: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
3846: else
3847: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
3848: end if;
3849: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
3850: clob_to_blob(l_xfdf_string,p_xfdf_blob);
3851: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
3852: --return p_xfdf_blob;
3853: EXCEPTION

Line 3875: l_length_clob := dbms_lob.getlength(p_clob);

3871: l_blob_offset pls_integer := 1;
3872: begin
3873: hr_utility.set_location('Entered Procedure clob to blob',120);
3874: select userenv('LANGUAGE') into g_nls_db_char from dual;
3875: l_length_clob := dbms_lob.getlength(p_clob);
3876: l_offset := 1;
3877: while l_length_clob > 0 loop
3878: hr_utility.trace('l_length_clob '|| l_length_clob);
3879: if l_length_clob < l_buffer_len then

Line 3884: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);

3880: l_chunk_len := l_length_clob;
3881: else
3882: l_chunk_len := l_buffer_len;
3883: end if;
3884: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
3885: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
3886: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
3887: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
3888: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);

Line 3889: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);

3885: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
3886: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
3887: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
3888: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
3889: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
3890: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
3891: l_blob_offset := l_blob_offset + l_raw_buffer_len;
3892: l_offset := l_offset + l_chunk_len;
3893: l_length_clob := l_length_clob - l_chunk_len;

Line 3890: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);

3886: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
3887: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
3888: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
3889: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
3890: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
3891: l_blob_offset := l_blob_offset + l_raw_buffer_len;
3892: l_offset := l_offset + l_chunk_len;
3893: l_length_clob := l_length_clob - l_chunk_len;
3894: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

Line 3894: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

3890: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
3891: l_blob_offset := l_blob_offset + l_raw_buffer_len;
3892: l_offset := l_offset + l_chunk_len;
3893: l_length_clob := l_length_clob - l_chunk_len;
3894: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
3895: end loop;
3896: hr_utility.set_location('Finished Procedure clob to blob ',130);
3897: end;
3898: ------------------------------------------------------------------