SYS.OWA_OPT_LOCK dependencies on DBMS_SYS_SQL

Line 19: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

15: p_schema varchar2(30) := upper(p_owner);
16: p_obj varchar2(30) := upper(p_object);
17: begin
18: stmt_cursor := dbms_sql.open_cursor;
19: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
20: 'begin
21: select count(*)
22: into :found
23: from all_objects

Line 125: sys.dbms_sys_sql.parse_as_user(

121:
122: l_cursor := dbms_sql.open_cursor;
123:
124: -- Fix 789868 - Common schema may not have access to this info.
125: sys.dbms_sys_sql.parse_as_user(
126: l_cursor,
127: 'select column_name, data_type
128: from all_tab_columns
129: where owner = :p_schema

Line 168: sys.dbms_sys_sql.parse_as_user( l_cursor, l_theQuery, dbms_sql.v7);

164: l_theQuery := l_theQuery || ') from ' || DBMS_ASSERT.ENQUOTE_NAME(p_schema) || '.' || DBMS_ASSERT.ENQUOTE_NAME(p_obj) ||
165: ' where rowid = :x1 for update';
166:
167: l_cursor := dbms_sql.open_cursor;
168: sys.dbms_sys_sql.parse_as_user( l_cursor, l_theQuery, dbms_sql.v7);
169: dbms_sql.bind_variable( l_cursor, ':x1', p_rowid );
170: dbms_sql.define_column( l_cursor, 1, l_variable );
171:
172: l_status := dbms_sql.execute(l_cursor);

Line 203: sys.dbms_sys_sql.parse_as_user( l_cursor, l_theQuery, dbms_sql.v7 );

199: ' a where rowid = :x1';
200:
201: l_cursor := dbms_sql.open_cursor;
202:
203: sys.dbms_sys_sql.parse_as_user( l_cursor, l_theQuery, dbms_sql.v7 );
204: dbms_sql.bind_variable( l_cursor, ':x1', p_rowid );
205: for i in 1 .. 255 loop
206: begin
207: dbms_sql.define_column( l_cursor, i, l_variable, 2000 );

Line 249: sys.dbms_sys_sql.parse_as_user( l_cursor, l_theQuery, dbms_sql.v7 );

245: ' where rowid = :x1 for update';
246:
247: l_cursor := dbms_sql.open_cursor;
248:
249: sys.dbms_sys_sql.parse_as_user( l_cursor, l_theQuery, dbms_sql.v7 );
250: dbms_sql.bind_variable( l_cursor, ':x1', p_old_values(3) );
251: for i in 1 .. 255 loop
252: begin
253: dbms_sql.define_column( l_cursor, i, l_variable, 2000 );