APPS.CSP_NOTIFICATIONS_PVT dependencies on DBMS_SQL

Line 290: l_cursor := dbms_sql.open_cursor;

286: l_oracle_schema varchar2(30);
287: BEGIN
288: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
289: l_ddl_string := 'truncate table '||l_oracle_schema||'.csp_notifications';
290: l_cursor := dbms_sql.open_cursor;
291: dbms_sql.parse(l_cursor,l_ddl_string,dbms_sql.native);
292: dbms_sql.close_cursor(l_cursor);
293:
294: -- Standard Start of API savepoint

Line 291: dbms_sql.parse(l_cursor,l_ddl_string,dbms_sql.native);

287: BEGIN
288: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
289: l_ddl_string := 'truncate table '||l_oracle_schema||'.csp_notifications';
290: l_cursor := dbms_sql.open_cursor;
291: dbms_sql.parse(l_cursor,l_ddl_string,dbms_sql.native);
292: dbms_sql.close_cursor(l_cursor);
293:
294: -- Standard Start of API savepoint
295: SAVEPOINT create_notifications_pvt;

Line 292: dbms_sql.close_cursor(l_cursor);

288: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
289: l_ddl_string := 'truncate table '||l_oracle_schema||'.csp_notifications';
290: l_cursor := dbms_sql.open_cursor;
291: dbms_sql.parse(l_cursor,l_ddl_string,dbms_sql.native);
292: dbms_sql.close_cursor(l_cursor);
293:
294: -- Standard Start of API savepoint
295: SAVEPOINT create_notifications_pvt;
296: -- Standard call to check for call compatibility.