APPS.HZ_SEED_CLASS_CAT_PKG dependencies on DBMS_SQL

Line 137: ph := dbms_sql.open_cursor;

133: ' 0) ';
134: END IF;
135: END IF;
136:
137: ph := dbms_sql.open_cursor;
138: dbms_sql.parse(ph,l_str,dbms_sql.native);
139: rt := dbms_sql.execute(ph);
140: dbms_sql.close_cursor(ph);
141: END;

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

134: END IF;
135: END IF;
136:
137: ph := dbms_sql.open_cursor;
138: dbms_sql.parse(ph,l_str,dbms_sql.native);
139: rt := dbms_sql.execute(ph);
140: dbms_sql.close_cursor(ph);
141: END;
142:

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

135: END IF;
136:
137: ph := dbms_sql.open_cursor;
138: dbms_sql.parse(ph,l_str,dbms_sql.native);
139: rt := dbms_sql.execute(ph);
140: dbms_sql.close_cursor(ph);
141: END;
142:
143: PROCEDURE SEED_CLASS_CATEGORY_USE

Line 140: dbms_sql.close_cursor(ph);

136:
137: ph := dbms_sql.open_cursor;
138: dbms_sql.parse(ph,l_str,dbms_sql.native);
139: rt := dbms_sql.execute(ph);
140: dbms_sql.close_cursor(ph);
141: END;
142:
143: PROCEDURE SEED_CLASS_CATEGORY_USE
144: (p_class IN VARCHAR2,

Line 220: ph := dbms_sql.open_cursor;

216:
217: -- dbms_output.put_line(substr(l_str,1,255));
218: -- dbms_output.put_line(substr(l_str,256,255));
219:
220: ph := dbms_sql.open_cursor;
221: dbms_sql.parse(ph,l_str,dbms_sql.native);
222: rt := dbms_sql.execute(ph);
223: dbms_sql.close_cursor(ph);
224:

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

217: -- dbms_output.put_line(substr(l_str,1,255));
218: -- dbms_output.put_line(substr(l_str,256,255));
219:
220: ph := dbms_sql.open_cursor;
221: dbms_sql.parse(ph,l_str,dbms_sql.native);
222: rt := dbms_sql.execute(ph);
223: dbms_sql.close_cursor(ph);
224:
225: END IF;

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

218: -- dbms_output.put_line(substr(l_str,256,255));
219:
220: ph := dbms_sql.open_cursor;
221: dbms_sql.parse(ph,l_str,dbms_sql.native);
222: rt := dbms_sql.execute(ph);
223: dbms_sql.close_cursor(ph);
224:
225: END IF;
226: END;

Line 223: dbms_sql.close_cursor(ph);

219:
220: ph := dbms_sql.open_cursor;
221: dbms_sql.parse(ph,l_str,dbms_sql.native);
222: rt := dbms_sql.execute(ph);
223: dbms_sql.close_cursor(ph);
224:
225: END IF;
226: END;
227: END;