APPS.CSI_INV_DISCREPANCY_PKG dependencies on DBMS_SQL

Line 57: l_truncate_handle PLS_INTEGER := dbms_sql.open_cursor;

53: Procedure Truncate_table(
54: p_table_name IN VARCHAR2)
55: Is
56: l_num_of_rows NUMBER;
57: l_truncate_handle PLS_INTEGER := dbms_sql.open_cursor;
58: l_statement VARCHAR2(200);
59: Begin
60: l_statement := 'truncate table '||p_table_name;
61: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);

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

57: l_truncate_handle PLS_INTEGER := dbms_sql.open_cursor;
58: l_statement VARCHAR2(200);
59: Begin
60: l_statement := 'truncate table '||p_table_name;
61: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
62: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
63: dbms_sql.close_cursor(l_truncate_handle);
64: Exception
65: When Others Then

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

58: l_statement VARCHAR2(200);
59: Begin
60: l_statement := 'truncate table '||p_table_name;
61: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
62: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
63: dbms_sql.close_cursor(l_truncate_handle);
64: Exception
65: When Others Then
66: Null;

Line 63: dbms_sql.close_cursor(l_truncate_handle);

59: Begin
60: l_statement := 'truncate table '||p_table_name;
61: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
62: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
63: dbms_sql.close_cursor(l_truncate_handle);
64: Exception
65: When Others Then
66: Null;
67: End truncate_table;