APPS.AD_UTIL dependencies on DBMS_SQL

Line 87: p_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 91: dbms_sql.close_cursor(p_cursor);

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

Line 95: dbms_sql.close_cursor(p_cursor);

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