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

Line 1678: dbms_lob.createtemporary(p_xfdf_string,FALSE,DBMS_LOB.CALL);

1674: l_str7 := '
1675:
1676:
1677: ';
1678: dbms_lob.createtemporary(p_xfdf_string,FALSE,DBMS_LOB.CALL);
1679: dbms_lob.open(p_xfdf_string,dbms_lob.lob_readwrite);
1680: IF vXMLTable.count > 0 THEN
1681: dbms_lob.writeAppend( p_xfdf_string, length(l_str1), l_str1 );
1682: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

Line 1679: dbms_lob.open(p_xfdf_string,dbms_lob.lob_readwrite);

1675:
1676:
1677: ';
1678: dbms_lob.createtemporary(p_xfdf_string,FALSE,DBMS_LOB.CALL);
1679: dbms_lob.open(p_xfdf_string,dbms_lob.lob_readwrite);
1680: IF vXMLTable.count > 0 THEN
1681: dbms_lob.writeAppend( p_xfdf_string, length(l_str1), l_str1 );
1682: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
1683: l_str8 := vXMLTable(ctr_table).TagName;

Line 1681: dbms_lob.writeAppend( p_xfdf_string, length(l_str1), l_str1 );

1677: ';
1678: dbms_lob.createtemporary(p_xfdf_string,FALSE,DBMS_LOB.CALL);
1679: dbms_lob.open(p_xfdf_string,dbms_lob.lob_readwrite);
1680: IF vXMLTable.count > 0 THEN
1681: dbms_lob.writeAppend( p_xfdf_string, length(l_str1), l_str1 );
1682: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
1683: l_str8 := vXMLTable(ctr_table).TagName;
1684: l_str9 := vXMLTable(ctr_table).TagValue;
1685: --

Line 1687: dbms_lob.writeAppend( p_xfdf_string, length(l_str2), l_str2 );

1683: l_str8 := vXMLTable(ctr_table).TagName;
1684: l_str9 := vXMLTable(ctr_table).TagValue;
1685: --
1686: IF (l_str9 is not null) THEN
1687: dbms_lob.writeAppend( p_xfdf_string, length(l_str2), l_str2 );
1688: dbms_lob.writeAppend( p_xfdf_string, length(l_str8),l_str8);
1689: dbms_lob.writeAppend( p_xfdf_string, length(l_str3), l_str3 );
1690: dbms_lob.writeAppend( p_xfdf_string, length(l_str4), l_str4 );
1691: dbms_lob.writeAppend( p_xfdf_string, length(l_str9), l_str9);

Line 1688: dbms_lob.writeAppend( p_xfdf_string, length(l_str8),l_str8);

1684: l_str9 := vXMLTable(ctr_table).TagValue;
1685: --
1686: IF (l_str9 is not null) THEN
1687: dbms_lob.writeAppend( p_xfdf_string, length(l_str2), l_str2 );
1688: dbms_lob.writeAppend( p_xfdf_string, length(l_str8),l_str8);
1689: dbms_lob.writeAppend( p_xfdf_string, length(l_str3), l_str3 );
1690: dbms_lob.writeAppend( p_xfdf_string, length(l_str4), l_str4 );
1691: dbms_lob.writeAppend( p_xfdf_string, length(l_str9), l_str9);
1692: dbms_lob.writeAppend( p_xfdf_string, length(l_str5), l_str5 );

Line 1689: dbms_lob.writeAppend( p_xfdf_string, length(l_str3), l_str3 );

1685: --
1686: IF (l_str9 is not null) THEN
1687: dbms_lob.writeAppend( p_xfdf_string, length(l_str2), l_str2 );
1688: dbms_lob.writeAppend( p_xfdf_string, length(l_str8),l_str8);
1689: dbms_lob.writeAppend( p_xfdf_string, length(l_str3), l_str3 );
1690: dbms_lob.writeAppend( p_xfdf_string, length(l_str4), l_str4 );
1691: dbms_lob.writeAppend( p_xfdf_string, length(l_str9), l_str9);
1692: dbms_lob.writeAppend( p_xfdf_string, length(l_str5), l_str5 );
1693: ELSE

Line 1690: dbms_lob.writeAppend( p_xfdf_string, length(l_str4), l_str4 );

1686: IF (l_str9 is not null) THEN
1687: dbms_lob.writeAppend( p_xfdf_string, length(l_str2), l_str2 );
1688: dbms_lob.writeAppend( p_xfdf_string, length(l_str8),l_str8);
1689: dbms_lob.writeAppend( p_xfdf_string, length(l_str3), l_str3 );
1690: dbms_lob.writeAppend( p_xfdf_string, length(l_str4), l_str4 );
1691: dbms_lob.writeAppend( p_xfdf_string, length(l_str9), l_str9);
1692: dbms_lob.writeAppend( p_xfdf_string, length(l_str5), l_str5 );
1693: ELSE
1694: null;

Line 1691: dbms_lob.writeAppend( p_xfdf_string, length(l_str9), l_str9);

1687: dbms_lob.writeAppend( p_xfdf_string, length(l_str2), l_str2 );
1688: dbms_lob.writeAppend( p_xfdf_string, length(l_str8),l_str8);
1689: dbms_lob.writeAppend( p_xfdf_string, length(l_str3), l_str3 );
1690: dbms_lob.writeAppend( p_xfdf_string, length(l_str4), l_str4 );
1691: dbms_lob.writeAppend( p_xfdf_string, length(l_str9), l_str9);
1692: dbms_lob.writeAppend( p_xfdf_string, length(l_str5), l_str5 );
1693: ELSE
1694: null;
1695: END IF;

Line 1692: dbms_lob.writeAppend( p_xfdf_string, length(l_str5), l_str5 );

1688: dbms_lob.writeAppend( p_xfdf_string, length(l_str8),l_str8);
1689: dbms_lob.writeAppend( p_xfdf_string, length(l_str3), l_str3 );
1690: dbms_lob.writeAppend( p_xfdf_string, length(l_str4), l_str4 );
1691: dbms_lob.writeAppend( p_xfdf_string, length(l_str9), l_str9);
1692: dbms_lob.writeAppend( p_xfdf_string, length(l_str5), l_str5 );
1693: ELSE
1694: null;
1695: END IF;
1696: END LOOP;

Line 1697: dbms_lob.writeAppend( p_xfdf_string, length(l_str6), l_str6 );

1693: ELSE
1694: null;
1695: END IF;
1696: END LOOP;
1697: dbms_lob.writeAppend( p_xfdf_string, length(l_str6), l_str6 );
1698: ELSE
1699: dbms_lob.writeAppend( p_xfdf_string, length(l_str7), l_str7 );
1700: END IF;
1701: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

Line 1699: dbms_lob.writeAppend( p_xfdf_string, length(l_str7), l_str7 );

1695: END IF;
1696: END LOOP;
1697: dbms_lob.writeAppend( p_xfdf_string, length(l_str6), l_str6 );
1698: ELSE
1699: dbms_lob.writeAppend( p_xfdf_string, length(l_str7), l_str7 );
1700: END IF;
1701: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1702: clob_to_blob(p_xfdf_string,p_xfdf_blob);
1703: --return p_xfdf_blob;

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

1697: dbms_lob.writeAppend( p_xfdf_string, length(l_str6), l_str6 );
1698: ELSE
1699: dbms_lob.writeAppend( p_xfdf_string, length(l_str7), l_str7 );
1700: END IF;
1701: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1702: clob_to_blob(p_xfdf_string,p_xfdf_blob);
1703: --return p_xfdf_blob;
1704: EXCEPTION
1705: WHEN OTHERS then

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

1730: --
1731: SELECT userenv('LANGUAGE') INTO g_nls_db_char FROM dual;
1732: --
1733: l_buffer_len := 20000;
1734: l_length_clob := dbms_lob.getlength(p_clob);
1735: l_offset := 1;
1736: --
1737: while l_length_clob > 0 loop
1738: --

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

1741: ELSE
1742: l_chunk_len := l_buffer_len;
1743: END IF;
1744: --
1745: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
1746: --
1747: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char);
1748: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char));
1749: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);

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

1745: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
1746: --
1747: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char);
1748: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char));
1749: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1750: --
1751: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1752: l_offset := l_offset + l_chunk_len;
1753: l_length_clob := l_length_clob - l_chunk_len;