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

Line 1926: -- Runs a SQL statement using the dbms_sql package. No bind variables

1922: end setup_parameter_data;
1923:
1924: -- ------------------------ run_sql ---------------------------------------
1925: -- Description:
1926: -- Runs a SQL statement using the dbms_sql package. No bind variables
1927: -- allowed.
1928: -- ------------------------------------------------------------------------
1929: procedure run_sql( p_sql in varchar2 )
1930: is

Line 1934: l_csr_sql := dbms_sql.open_cursor;

1930: is
1931: l_csr_sql integer;
1932: l_rows number;
1933: begin
1934: l_csr_sql := dbms_sql.open_cursor;
1935: dbms_sql.parse( l_csr_sql, p_sql, dbms_sql.native );
1936: l_rows := dbms_sql.execute( l_csr_sql );
1937: dbms_sql.close_cursor( l_csr_sql );
1938: exception

Line 1935: dbms_sql.parse( l_csr_sql, p_sql, dbms_sql.native );

1931: l_csr_sql integer;
1932: l_rows number;
1933: begin
1934: l_csr_sql := dbms_sql.open_cursor;
1935: dbms_sql.parse( l_csr_sql, p_sql, dbms_sql.native );
1936: l_rows := dbms_sql.execute( l_csr_sql );
1937: dbms_sql.close_cursor( l_csr_sql );
1938: exception
1939: when others then

Line 1936: l_rows := dbms_sql.execute( l_csr_sql );

1932: l_rows number;
1933: begin
1934: l_csr_sql := dbms_sql.open_cursor;
1935: dbms_sql.parse( l_csr_sql, p_sql, dbms_sql.native );
1936: l_rows := dbms_sql.execute( l_csr_sql );
1937: dbms_sql.close_cursor( l_csr_sql );
1938: exception
1939: when others then
1940: raise;

Line 1937: dbms_sql.close_cursor( l_csr_sql );

1933: begin
1934: l_csr_sql := dbms_sql.open_cursor;
1935: dbms_sql.parse( l_csr_sql, p_sql, dbms_sql.native );
1936: l_rows := dbms_sql.execute( l_csr_sql );
1937: dbms_sql.close_cursor( l_csr_sql );
1938: exception
1939: when others then
1940: raise;
1941: end run_sql;

Line 1948: procedure run_sql( p_sql in dbms_sql.varchar2s )

1944: -- Description:
1945: -- Alternative interface for generating the large PLSQL packages.
1946: -- Table index must begin at 1.
1947: -- ------------------------------------------------------------------------
1948: procedure run_sql( p_sql in dbms_sql.varchar2s )
1949: is
1950: l_csr_sql integer;
1951: l_rows number;
1952: begin

Line 1953: l_csr_sql := dbms_sql.open_cursor;

1949: is
1950: l_csr_sql integer;
1951: l_rows number;
1952: begin
1953: l_csr_sql := dbms_sql.open_cursor;
1954: --
1955: -- Do the parse without inserting linefeeds between each element.
1956: --
1957: dbms_sql.parse( l_csr_sql, p_sql, 1, p_sql.count, false, dbms_sql.native );

Line 1957: dbms_sql.parse( l_csr_sql, p_sql, 1, p_sql.count, false, dbms_sql.native );

1953: l_csr_sql := dbms_sql.open_cursor;
1954: --
1955: -- Do the parse without inserting linefeeds between each element.
1956: --
1957: dbms_sql.parse( l_csr_sql, p_sql, 1, p_sql.count, false, dbms_sql.native );
1958: l_rows := dbms_sql.execute( l_csr_sql );
1959: dbms_sql.close_cursor( l_csr_sql );
1960: exception
1961: when others then

Line 1958: l_rows := dbms_sql.execute( l_csr_sql );

1954: --
1955: -- Do the parse without inserting linefeeds between each element.
1956: --
1957: dbms_sql.parse( l_csr_sql, p_sql, 1, p_sql.count, false, dbms_sql.native );
1958: l_rows := dbms_sql.execute( l_csr_sql );
1959: dbms_sql.close_cursor( l_csr_sql );
1960: exception
1961: when others then
1962: raise;

Line 1959: dbms_sql.close_cursor( l_csr_sql );

1955: -- Do the parse without inserting linefeeds between each element.
1956: --
1957: dbms_sql.parse( l_csr_sql, p_sql, 1, p_sql.count, false, dbms_sql.native );
1958: l_rows := dbms_sql.execute( l_csr_sql );
1959: dbms_sql.close_cursor( l_csr_sql );
1960: exception
1961: when others then
1962: raise;
1963: end run_sql;

Line 1973: ,p_text_pieces in out nocopy dbms_sql.varchar2s

1969: -- -----------------------------------------------------------------------
1970: procedure split_sql_text
1971: (p_last in boolean
1972: ,p_text in out nocopy varchar2
1973: ,p_text_pieces in out nocopy dbms_sql.varchar2s
1974:
1975: ) is
1976: l_start binary_integer;
1977: j binary_integer;

Line 3300: p_body_pieces in out nocopy dbms_sql.varchar2s

3296: p_function_call_tbl in t_function_parameter_tbl,
3297: p_parameter_counts in t_parameter_counts,
3298: p_header in out nocopy varchar2,
3299: p_body in out nocopy varchar2,
3300: p_body_pieces in out nocopy dbms_sql.varchar2s
3301: )
3302: is
3303: l_locals varchar2(32767); -- Local variables for call procedure.
3304: l_locals1 varchar2(32767); -- Local variables for call procedure.

Line 3575: l_body_pieces dbms_sql.varchar2s;

3571: is
3572: l_header varchar2(32767);
3573: l_body varchar2(32767);
3574: l_header_comment varchar2(2048);
3575: l_body_pieces dbms_sql.varchar2s;
3576: begin
3577: -- Start the package header and body.
3578: begin
3579: --