APPS.AD_UTIL dependencies on DBMS_SQL

Line 88: p_cursor := dbms_sql.open_cursor;

84: if upper(p_option) = 'N' then
85: return;
86: end if;
87:
88: p_cursor := dbms_sql.open_cursor;
89: dbms_sql.parse(p_cursor, statement, dbms_sql.native);
90: rows_processed := dbms_sql.execute(p_cursor);
91: dbms_output.put_line(' '||rows_processed||' rows updated.');
92: dbms_sql.close_cursor(p_cursor);

Line 89: dbms_sql.parse(p_cursor, statement, dbms_sql.native);

85: return;
86: end if;
87:
88: p_cursor := dbms_sql.open_cursor;
89: dbms_sql.parse(p_cursor, statement, dbms_sql.native);
90: rows_processed := dbms_sql.execute(p_cursor);
91: dbms_output.put_line(' '||rows_processed||' rows updated.');
92: dbms_sql.close_cursor(p_cursor);
93:

Line 90: rows_processed := dbms_sql.execute(p_cursor);

86: end if;
87:
88: p_cursor := dbms_sql.open_cursor;
89: dbms_sql.parse(p_cursor, statement, dbms_sql.native);
90: rows_processed := dbms_sql.execute(p_cursor);
91: dbms_output.put_line(' '||rows_processed||' rows updated.');
92: dbms_sql.close_cursor(p_cursor);
93:
94: exception

Line 92: dbms_sql.close_cursor(p_cursor);

88: p_cursor := dbms_sql.open_cursor;
89: dbms_sql.parse(p_cursor, statement, dbms_sql.native);
90: rows_processed := dbms_sql.execute(p_cursor);
91: dbms_output.put_line(' '||rows_processed||' rows updated.');
92: dbms_sql.close_cursor(p_cursor);
93:
94: exception
95: when others then
96: dbms_sql.close_cursor(p_cursor);

Line 96: dbms_sql.close_cursor(p_cursor);

92: dbms_sql.close_cursor(p_cursor);
93:
94: exception
95: when others then
96: dbms_sql.close_cursor(p_cursor);
97: raise;
98:
99: end update_column;
100: