APPS.HZ_SEED_CLASS_CAT_PKG dependencies on DBMS_SQL

Line 148: ph := dbms_sql.open_cursor;

144: ' 0) ';
145: END IF;
146: END IF;
147:
148: ph := dbms_sql.open_cursor;
149: dbms_sql.parse(ph,l_str,dbms_sql.native);
150: rt := dbms_sql.execute(ph);
151: dbms_sql.close_cursor(ph);
152: END;

Line 149: dbms_sql.parse(ph,l_str,dbms_sql.native);

145: END IF;
146: END IF;
147:
148: ph := dbms_sql.open_cursor;
149: dbms_sql.parse(ph,l_str,dbms_sql.native);
150: rt := dbms_sql.execute(ph);
151: dbms_sql.close_cursor(ph);
152: END;
153: --Bug 15893080 - Remove direct access from all_tab_columns

Line 150: rt := dbms_sql.execute(ph);

146: END IF;
147:
148: ph := dbms_sql.open_cursor;
149: dbms_sql.parse(ph,l_str,dbms_sql.native);
150: rt := dbms_sql.execute(ph);
151: dbms_sql.close_cursor(ph);
152: END;
153: --Bug 15893080 - Remove direct access from all_tab_columns
154: PROCEDURE SEED_CLASS_CATEGORY_USE

Line 151: dbms_sql.close_cursor(ph);

147:
148: ph := dbms_sql.open_cursor;
149: dbms_sql.parse(ph,l_str,dbms_sql.native);
150: rt := dbms_sql.execute(ph);
151: dbms_sql.close_cursor(ph);
152: END;
153: --Bug 15893080 - Remove direct access from all_tab_columns
154: PROCEDURE SEED_CLASS_CATEGORY_USE
155: (p_class IN VARCHAR2,

Line 242: ph := dbms_sql.open_cursor;

238:
239: -- dbms_output.put_line(substr(l_str,1,255));
240: -- dbms_output.put_line(substr(l_str,256,255));
241:
242: ph := dbms_sql.open_cursor;
243: dbms_sql.parse(ph,l_str,dbms_sql.native);
244: rt := dbms_sql.execute(ph);
245: dbms_sql.close_cursor(ph);
246:

Line 243: dbms_sql.parse(ph,l_str,dbms_sql.native);

239: -- dbms_output.put_line(substr(l_str,1,255));
240: -- dbms_output.put_line(substr(l_str,256,255));
241:
242: ph := dbms_sql.open_cursor;
243: dbms_sql.parse(ph,l_str,dbms_sql.native);
244: rt := dbms_sql.execute(ph);
245: dbms_sql.close_cursor(ph);
246:
247: END IF;

Line 244: rt := dbms_sql.execute(ph);

240: -- dbms_output.put_line(substr(l_str,256,255));
241:
242: ph := dbms_sql.open_cursor;
243: dbms_sql.parse(ph,l_str,dbms_sql.native);
244: rt := dbms_sql.execute(ph);
245: dbms_sql.close_cursor(ph);
246:
247: END IF;
248: END;

Line 245: dbms_sql.close_cursor(ph);

241:
242: ph := dbms_sql.open_cursor;
243: dbms_sql.parse(ph,l_str,dbms_sql.native);
244: rt := dbms_sql.execute(ph);
245: dbms_sql.close_cursor(ph);
246:
247: END IF;
248: END;
249: END;