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_DM_LIBRARY dependencies on DBMS_SQL

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

2859: raise;
2860: end chk_row_in_dt_delete_4_pkcol;
2861: -- ------------------------ run_sql ---------------------------------------
2862: -- Description:
2863: -- Runs a SQL statement using the dbms_sql package. No bind variables
2864: -- allowed. The SQL command is passed to this procedure as a atrring of
2865: -- varchar2.
2866: --
2867: -- ------------------------------------------------------------------------

Line 2875: l_csr_sql := dbms_sql.open_cursor;

2871: l_rows number;
2872: begin
2873: hr_dm_utility.message('ROUT','entry:hr_dm_library.run_sql', 5);
2874: hr_dm_utility.message('PARA','(p_sql - varchar2)', 10);
2875: l_csr_sql := dbms_sql.open_cursor;
2876: dbms_sql.parse( l_csr_sql, p_sql, dbms_sql.native );
2877: l_rows := dbms_sql.execute( l_csr_sql );
2878: dbms_sql.close_cursor( l_csr_sql );
2879: hr_dm_utility.message('INFO','HR_DM_LIBARARY - run SQL command - 1',15);

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

2872: begin
2873: hr_dm_utility.message('ROUT','entry:hr_dm_library.run_sql', 5);
2874: hr_dm_utility.message('PARA','(p_sql - varchar2)', 10);
2875: l_csr_sql := dbms_sql.open_cursor;
2876: dbms_sql.parse( l_csr_sql, p_sql, dbms_sql.native );
2877: l_rows := dbms_sql.execute( l_csr_sql );
2878: dbms_sql.close_cursor( l_csr_sql );
2879: hr_dm_utility.message('INFO','HR_DM_LIBARARY - run SQL command - 1',15);
2880: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - run SQL command - 1',20);

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

2873: hr_dm_utility.message('ROUT','entry:hr_dm_library.run_sql', 5);
2874: hr_dm_utility.message('PARA','(p_sql - varchar2)', 10);
2875: l_csr_sql := dbms_sql.open_cursor;
2876: dbms_sql.parse( l_csr_sql, p_sql, dbms_sql.native );
2877: l_rows := dbms_sql.execute( l_csr_sql );
2878: dbms_sql.close_cursor( l_csr_sql );
2879: hr_dm_utility.message('INFO','HR_DM_LIBARARY - run SQL command - 1',15);
2880: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - run SQL command - 1',20);
2881: hr_dm_utility.message('ROUT','exit:hr_dm_library.run_sql',

Line 2878: dbms_sql.close_cursor( l_csr_sql );

2874: hr_dm_utility.message('PARA','(p_sql - varchar2)', 10);
2875: l_csr_sql := dbms_sql.open_cursor;
2876: dbms_sql.parse( l_csr_sql, p_sql, dbms_sql.native );
2877: l_rows := dbms_sql.execute( l_csr_sql );
2878: dbms_sql.close_cursor( l_csr_sql );
2879: hr_dm_utility.message('INFO','HR_DM_LIBARARY - run SQL command - 1',15);
2880: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - run SQL command - 1',20);
2881: hr_dm_utility.message('ROUT','exit:hr_dm_library.run_sql',
2882: 25);

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

2887: raise;
2888: end run_sql;
2889: -- ------------------------ run_sql ---------------------------------------
2890: -- Description:
2891: -- Runs a SQL statement using the dbms_sql package. No bind variables
2892: -- allowed. This procedure uses pl/sql table of varchar2 as an input
2893: -- and hence is suitable to compile very large packages i.e more than
2894: -- 32767 char.
2895: -- ------------------------------------------------------------------------

Line 2896: procedure run_sql(p_package_body dbms_sql.varchar2s,

2892: -- allowed. This procedure uses pl/sql table of varchar2 as an input
2893: -- and hence is suitable to compile very large packages i.e more than
2894: -- 32767 char.
2895: -- ------------------------------------------------------------------------
2896: procedure run_sql(p_package_body dbms_sql.varchar2s,
2897: p_package_index number )
2898: is
2899: l_csr_sql integer;
2900: l_rows number;

Line 2905: ')' || '(p_package_index - dbms_sql.varchar2s)'

2901:
2902: begin
2903: hr_dm_utility.message('ROUT','entry:hr_dm_library.run_sql', 5);
2904: hr_dm_utility.message('PARA','(p_package_index - ' || p_package_index ||
2905: ')' || '(p_package_index - dbms_sql.varchar2s)'
2906: , 10);
2907: l_csr_sql := dbms_sql.open_cursor;
2908: dbms_sql.parse( l_csr_sql, p_package_body,1,p_package_index,FALSE, dbms_sql.v7 );
2909: l_rows := dbms_sql.execute( l_csr_sql );

Line 2907: l_csr_sql := dbms_sql.open_cursor;

2903: hr_dm_utility.message('ROUT','entry:hr_dm_library.run_sql', 5);
2904: hr_dm_utility.message('PARA','(p_package_index - ' || p_package_index ||
2905: ')' || '(p_package_index - dbms_sql.varchar2s)'
2906: , 10);
2907: l_csr_sql := dbms_sql.open_cursor;
2908: dbms_sql.parse( l_csr_sql, p_package_body,1,p_package_index,FALSE, dbms_sql.v7 );
2909: l_rows := dbms_sql.execute( l_csr_sql );
2910: dbms_sql.close_cursor( l_csr_sql );
2911: hr_dm_utility.message('INFO','HR_DM_LIBARARY - run SQL command - 2',15);

Line 2908: dbms_sql.parse( l_csr_sql, p_package_body,1,p_package_index,FALSE, dbms_sql.v7 );

2904: hr_dm_utility.message('PARA','(p_package_index - ' || p_package_index ||
2905: ')' || '(p_package_index - dbms_sql.varchar2s)'
2906: , 10);
2907: l_csr_sql := dbms_sql.open_cursor;
2908: dbms_sql.parse( l_csr_sql, p_package_body,1,p_package_index,FALSE, dbms_sql.v7 );
2909: l_rows := dbms_sql.execute( l_csr_sql );
2910: dbms_sql.close_cursor( l_csr_sql );
2911: hr_dm_utility.message('INFO','HR_DM_LIBARARY - run SQL command - 2',15);
2912: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - run SQL command - 2',20);

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

2905: ')' || '(p_package_index - dbms_sql.varchar2s)'
2906: , 10);
2907: l_csr_sql := dbms_sql.open_cursor;
2908: dbms_sql.parse( l_csr_sql, p_package_body,1,p_package_index,FALSE, dbms_sql.v7 );
2909: l_rows := dbms_sql.execute( l_csr_sql );
2910: dbms_sql.close_cursor( l_csr_sql );
2911: hr_dm_utility.message('INFO','HR_DM_LIBARARY - run SQL command - 2',15);
2912: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - run SQL command - 2',20);
2913: hr_dm_utility.message('ROUT','exit:hr_dm_library.run_sql',

Line 2910: dbms_sql.close_cursor( l_csr_sql );

2906: , 10);
2907: l_csr_sql := dbms_sql.open_cursor;
2908: dbms_sql.parse( l_csr_sql, p_package_body,1,p_package_index,FALSE, dbms_sql.v7 );
2909: l_rows := dbms_sql.execute( l_csr_sql );
2910: dbms_sql.close_cursor( l_csr_sql );
2911: hr_dm_utility.message('INFO','HR_DM_LIBARARY - run SQL command - 2',15);
2912: --hr_dm_utility.message('SUMM','HR_DM_LIBARARY - run SQL command - 2',20);
2913: hr_dm_utility.message('ROUT','exit:hr_dm_library.run_sql',
2914: 25);

Line 2917: hr_dm_utility.error(SQLCODE,'hr_dm_library.run_sql - dbms_sql.varchar2s',

2913: hr_dm_utility.message('ROUT','exit:hr_dm_library.run_sql',
2914: 25);
2915: exception
2916: when others then
2917: hr_dm_utility.error(SQLCODE,'hr_dm_library.run_sql - dbms_sql.varchar2s',
2918: '(none)','R');
2919: raise;
2920: end run_sql;
2921: