APPS.CSI_DIAGNOSTICS_PKG dependencies on DBMS_SQL

Line 2883: l_truncate_handle pls_integer := dbms_sql.open_cursor;

2879: PROCEDURE truncate_table(
2880: p_table_name in varchar2)
2881: IS
2882: l_num_of_rows number;
2883: l_truncate_handle pls_integer := dbms_sql.open_cursor;
2884: l_statement varchar2(200);
2885: BEGIN
2886: l_statement := 'truncate table '||p_table_name;
2887: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);

Line 2887: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);

2883: l_truncate_handle pls_integer := dbms_sql.open_cursor;
2884: l_statement varchar2(200);
2885: BEGIN
2886: l_statement := 'truncate table '||p_table_name;
2887: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
2888: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
2889: dbms_sql.close_cursor(l_truncate_handle);
2890: EXCEPTION
2891: WHEN others THEN

Line 2888: l_num_of_rows := dbms_sql.execute(l_truncate_handle);

2884: l_statement varchar2(200);
2885: BEGIN
2886: l_statement := 'truncate table '||p_table_name;
2887: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
2888: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
2889: dbms_sql.close_cursor(l_truncate_handle);
2890: EXCEPTION
2891: WHEN others THEN
2892: null;

Line 2889: dbms_sql.close_cursor(l_truncate_handle);

2885: BEGIN
2886: l_statement := 'truncate table '||p_table_name;
2887: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
2888: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
2889: dbms_sql.close_cursor(l_truncate_handle);
2890: EXCEPTION
2891: WHEN others THEN
2892: null;
2893: END truncate_table;