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.JL_CO_FA_PURGE_PKG dependencies on DBMS_SQL

Line 1851: x_cursor := DBMS_SQL.OPEN_CURSOR;

1847: x_row_processed INTEGER;
1848:
1849: BEGIN
1850:
1851: x_cursor := DBMS_SQL.OPEN_CURSOR;
1852: DBMS_SQL.PARSE( x_cursor, p_string, DBMS_SQL.V7);
1853: x_row_processed := DBMS_SQL.EXECUTE( x_cursor);
1854: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1855: RETURN (TRUE);

Line 1852: DBMS_SQL.PARSE( x_cursor, p_string, DBMS_SQL.V7);

1848:
1849: BEGIN
1850:
1851: x_cursor := DBMS_SQL.OPEN_CURSOR;
1852: DBMS_SQL.PARSE( x_cursor, p_string, DBMS_SQL.V7);
1853: x_row_processed := DBMS_SQL.EXECUTE( x_cursor);
1854: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1855: RETURN (TRUE);
1856:

Line 1853: x_row_processed := DBMS_SQL.EXECUTE( x_cursor);

1849: BEGIN
1850:
1851: x_cursor := DBMS_SQL.OPEN_CURSOR;
1852: DBMS_SQL.PARSE( x_cursor, p_string, DBMS_SQL.V7);
1853: x_row_processed := DBMS_SQL.EXECUTE( x_cursor);
1854: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1855: RETURN (TRUE);
1856:
1857:

Line 1854: DBMS_SQL.CLOSE_CURSOR( x_cursor);

1850:
1851: x_cursor := DBMS_SQL.OPEN_CURSOR;
1852: DBMS_SQL.PARSE( x_cursor, p_string, DBMS_SQL.V7);
1853: x_row_processed := DBMS_SQL.EXECUTE( x_cursor);
1854: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1855: RETURN (TRUE);
1856:
1857:
1858: EXCEPTION

Line 1861: IF DBMS_SQL.IS_OPEN(x_cursor) THEN

1857:
1858: EXCEPTION
1859: WHEN OTHERS THEN
1860:
1861: IF DBMS_SQL.IS_OPEN(x_cursor) THEN
1862: DBMS_SQL.CLOSE_CURSOR(x_cursor);
1863: END IF;
1864: RETURN (FALSE);
1865:

Line 1862: DBMS_SQL.CLOSE_CURSOR(x_cursor);

1858: EXCEPTION
1859: WHEN OTHERS THEN
1860:
1861: IF DBMS_SQL.IS_OPEN(x_cursor) THEN
1862: DBMS_SQL.CLOSE_CURSOR(x_cursor);
1863: END IF;
1864: RETURN (FALSE);
1865:
1866:

Line 1894: x_statement DBMS_SQL.VARCHAR2S;

1890:
1891:
1892: x_cursor INTEGER;
1893: x_row_processed INTEGER;
1894: x_statement DBMS_SQL.VARCHAR2S;
1895: x_count NUMBER := 1;
1896: x_avg_size NUMBER;
1897:
1898:

Line 1942: x_cursor := DBMS_SQL.OPEN_CURSOR;

1938: -- storgae factor for the table --
1939: ---------------------------------------------------------
1940:
1941:
1942: x_cursor := DBMS_SQL.OPEN_CURSOR;
1943: DBMS_SQL.PARSE( x_cursor,
1944: x_statement,
1945: 1,
1946: x_count+1,

Line 1943: DBMS_SQL.PARSE( x_cursor,

1939: ---------------------------------------------------------
1940:
1941:
1942: x_cursor := DBMS_SQL.OPEN_CURSOR;
1943: DBMS_SQL.PARSE( x_cursor,
1944: x_statement,
1945: 1,
1946: x_count+1,
1947: TRUE,

Line 1948: DBMS_SQL.NATIVE);

1944: x_statement,
1945: 1,
1946: x_count+1,
1947: TRUE,
1948: DBMS_SQL.NATIVE);
1949: DBMS_SQL.DEFINE_COLUMN( x_cursor, 1, x_avg_size);
1950: x_row_processed := DBMS_SQL.EXECUTE_AND_FETCH(x_cursor, TRUE);
1951: DBMS_SQL.COLUMN_VALUE(x_cursor, 1, x_avg_size);
1952: DBMS_SQL.CLOSE_CURSOR( x_cursor);

Line 1949: DBMS_SQL.DEFINE_COLUMN( x_cursor, 1, x_avg_size);

1945: 1,
1946: x_count+1,
1947: TRUE,
1948: DBMS_SQL.NATIVE);
1949: DBMS_SQL.DEFINE_COLUMN( x_cursor, 1, x_avg_size);
1950: x_row_processed := DBMS_SQL.EXECUTE_AND_FETCH(x_cursor, TRUE);
1951: DBMS_SQL.COLUMN_VALUE(x_cursor, 1, x_avg_size);
1952: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1953: p_storage_factor := (p_rows_to_archive * x_avg_size)/1000;

Line 1950: x_row_processed := DBMS_SQL.EXECUTE_AND_FETCH(x_cursor, TRUE);

1946: x_count+1,
1947: TRUE,
1948: DBMS_SQL.NATIVE);
1949: DBMS_SQL.DEFINE_COLUMN( x_cursor, 1, x_avg_size);
1950: x_row_processed := DBMS_SQL.EXECUTE_AND_FETCH(x_cursor, TRUE);
1951: DBMS_SQL.COLUMN_VALUE(x_cursor, 1, x_avg_size);
1952: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1953: p_storage_factor := (p_rows_to_archive * x_avg_size)/1000;
1954:

Line 1951: DBMS_SQL.COLUMN_VALUE(x_cursor, 1, x_avg_size);

1947: TRUE,
1948: DBMS_SQL.NATIVE);
1949: DBMS_SQL.DEFINE_COLUMN( x_cursor, 1, x_avg_size);
1950: x_row_processed := DBMS_SQL.EXECUTE_AND_FETCH(x_cursor, TRUE);
1951: DBMS_SQL.COLUMN_VALUE(x_cursor, 1, x_avg_size);
1952: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1953: p_storage_factor := (p_rows_to_archive * x_avg_size)/1000;
1954:
1955: RETURN TRUE;

Line 1952: DBMS_SQL.CLOSE_CURSOR( x_cursor);

1948: DBMS_SQL.NATIVE);
1949: DBMS_SQL.DEFINE_COLUMN( x_cursor, 1, x_avg_size);
1950: x_row_processed := DBMS_SQL.EXECUTE_AND_FETCH(x_cursor, TRUE);
1951: DBMS_SQL.COLUMN_VALUE(x_cursor, 1, x_avg_size);
1952: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1953: p_storage_factor := (p_rows_to_archive * x_avg_size)/1000;
1954:
1955: RETURN TRUE;
1956:

Line 1960: IF DBMS_SQL.IS_OPEN(x_cursor) THEN

1956:
1957: EXCEPTION
1958: WHEN OTHERS THEN
1959:
1960: IF DBMS_SQL.IS_OPEN(x_cursor) THEN
1961: DBMS_SQL.CLOSE_CURSOR(x_cursor);
1962: END IF;
1963: RETURN (FALSE);
1964:

Line 1961: DBMS_SQL.CLOSE_CURSOR(x_cursor);

1957: EXCEPTION
1958: WHEN OTHERS THEN
1959:
1960: IF DBMS_SQL.IS_OPEN(x_cursor) THEN
1961: DBMS_SQL.CLOSE_CURSOR(x_cursor);
1962: END IF;
1963: RETURN (FALSE);
1964:
1965: END storage_factor;