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 1923: -- Runs a SQL statement using the dbms_sql package. No bind variables

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

Line 1931: l_csr_sql := dbms_sql.open_cursor;

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

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

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

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

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

Line 1934: dbms_sql.close_cursor( l_csr_sql );

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

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

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

Line 1950: l_csr_sql := dbms_sql.open_cursor;

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

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

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

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

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

Line 1956: dbms_sql.close_cursor( l_csr_sql );

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

Line 1970: ,p_text_pieces in out nocopy dbms_sql.varchar2s

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

Line 3297: p_body_pieces in out nocopy dbms_sql.varchar2s

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

Line 3572: l_body_pieces dbms_sql.varchar2s;

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