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 1927: x_cursor := DBMS_SQL.OPEN_CURSOR;

1923: -- storgae factor for the table --
1924: ---------------------------------------------------------
1925:
1926:
1927: x_cursor := DBMS_SQL.OPEN_CURSOR;
1928: DBMS_SQL.PARSE( x_cursor,
1929: x_statement,
1930: 1,
1931: x_count+1,

Line 1928: DBMS_SQL.PARSE( x_cursor,

1924: ---------------------------------------------------------
1925:
1926:
1927: x_cursor := DBMS_SQL.OPEN_CURSOR;
1928: DBMS_SQL.PARSE( x_cursor,
1929: x_statement,
1930: 1,
1931: x_count+1,
1932: TRUE,

Line 1933: DBMS_SQL.NATIVE);

1929: x_statement,
1930: 1,
1931: x_count+1,
1932: TRUE,
1933: DBMS_SQL.NATIVE);
1934: DBMS_SQL.DEFINE_COLUMN( x_cursor, 1, x_avg_size);
1935: x_row_processed := DBMS_SQL.EXECUTE_AND_FETCH(x_cursor, TRUE);
1936: DBMS_SQL.COLUMN_VALUE(x_cursor, 1, x_avg_size);
1937: DBMS_SQL.CLOSE_CURSOR( x_cursor);

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

1930: 1,
1931: x_count+1,
1932: TRUE,
1933: DBMS_SQL.NATIVE);
1934: DBMS_SQL.DEFINE_COLUMN( x_cursor, 1, x_avg_size);
1935: x_row_processed := DBMS_SQL.EXECUTE_AND_FETCH(x_cursor, TRUE);
1936: DBMS_SQL.COLUMN_VALUE(x_cursor, 1, x_avg_size);
1937: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1938: p_storage_factor := (p_rows_to_archive * x_avg_size)/1000;

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

1931: x_count+1,
1932: TRUE,
1933: DBMS_SQL.NATIVE);
1934: DBMS_SQL.DEFINE_COLUMN( x_cursor, 1, x_avg_size);
1935: x_row_processed := DBMS_SQL.EXECUTE_AND_FETCH(x_cursor, TRUE);
1936: DBMS_SQL.COLUMN_VALUE(x_cursor, 1, x_avg_size);
1937: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1938: p_storage_factor := (p_rows_to_archive * x_avg_size)/1000;
1939:

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

1932: TRUE,
1933: DBMS_SQL.NATIVE);
1934: DBMS_SQL.DEFINE_COLUMN( x_cursor, 1, x_avg_size);
1935: x_row_processed := DBMS_SQL.EXECUTE_AND_FETCH(x_cursor, TRUE);
1936: DBMS_SQL.COLUMN_VALUE(x_cursor, 1, x_avg_size);
1937: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1938: p_storage_factor := (p_rows_to_archive * x_avg_size)/1000;
1939:
1940: RETURN TRUE;

Line 1937: DBMS_SQL.CLOSE_CURSOR( x_cursor);

1933: DBMS_SQL.NATIVE);
1934: DBMS_SQL.DEFINE_COLUMN( x_cursor, 1, x_avg_size);
1935: x_row_processed := DBMS_SQL.EXECUTE_AND_FETCH(x_cursor, TRUE);
1936: DBMS_SQL.COLUMN_VALUE(x_cursor, 1, x_avg_size);
1937: DBMS_SQL.CLOSE_CURSOR( x_cursor);
1938: p_storage_factor := (p_rows_to_archive * x_avg_size)/1000;
1939:
1940: RETURN TRUE;
1941:

Line 1945: IF DBMS_SQL.IS_OPEN(x_cursor) THEN

1941:
1942: EXCEPTION
1943: WHEN OTHERS THEN
1944:
1945: IF DBMS_SQL.IS_OPEN(x_cursor) THEN
1946: DBMS_SQL.CLOSE_CURSOR(x_cursor);
1947: END IF;
1948: RETURN (FALSE);
1949:

Line 1946: DBMS_SQL.CLOSE_CURSOR(x_cursor);

1942: EXCEPTION
1943: WHEN OTHERS THEN
1944:
1945: IF DBMS_SQL.IS_OPEN(x_cursor) THEN
1946: DBMS_SQL.CLOSE_CURSOR(x_cursor);
1947: END IF;
1948: RETURN (FALSE);
1949:
1950: END storage_factor;