DBA Data[Home] [Help]

APPS.CSI_MIGRATE_POPULATE dependencies on DBMS_SQL

Line 6: v_cursor_handle PLS_INTEGER := dbms_sql.open_cursor;

2: /* $Header: csipopdb.pls 115.5 2003/08/25 17:36:32 epajaril ship $ */
3:
4: PROCEDURE Build_Parse(p_values in varchar) IS
5: v_num_of_rows number;
6: v_cursor_handle PLS_INTEGER := dbms_sql.open_cursor;
7: v_statement varchar2(240);
8: BEGIN
9: v_statement := p_values;
10:

Line 11: dbms_sql.parse(v_cursor_handle, v_statement, dbms_sql.native);

7: v_statement varchar2(240);
8: BEGIN
9: v_statement := p_values;
10:
11: dbms_sql.parse(v_cursor_handle, v_statement, dbms_sql.native);
12:
13: v_num_of_rows := dbms_sql.execute(v_cursor_handle);
14: dbms_sql.close_cursor(v_cursor_handle);
15: END;

Line 13: v_num_of_rows := dbms_sql.execute(v_cursor_handle);

9: v_statement := p_values;
10:
11: dbms_sql.parse(v_cursor_handle, v_statement, dbms_sql.native);
12:
13: v_num_of_rows := dbms_sql.execute(v_cursor_handle);
14: dbms_sql.close_cursor(v_cursor_handle);
15: END;
16: END CSI_MIGRATE_POPULATE;

Line 14: dbms_sql.close_cursor(v_cursor_handle);

10:
11: dbms_sql.parse(v_cursor_handle, v_statement, dbms_sql.native);
12:
13: v_num_of_rows := dbms_sql.execute(v_cursor_handle);
14: dbms_sql.close_cursor(v_cursor_handle);
15: END;
16: END CSI_MIGRATE_POPULATE;