APPS.IGS_UC_RELEASE_TRANS_PKG dependencies on DBMS_SQL

Line 36: jchakrab 04-May-2006 Bug 5203018 - closed cursor created using DBMS_SQL

32: --
33: --Change History:
34: WHO WHEN WHAT
35: anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
36: jchakrab 04-May-2006 Bug 5203018 - closed cursor created using DBMS_SQL
37: -----------------------------------------------------------------------*/
38:
39: --variables for WHO columns
40: l_last_update_date DATE ;

Line 209: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

205: IF (fnd_log.level_statement >= l_debug_level ) THEN
206: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.release_transactions.update_dml', l_update_stmt);
207: END IF;
208:
209: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
210: fnd_dsql.set_cursor(l_cursor_id);
211:
212: DBMS_SQL.parse(l_cursor_id, l_update_stmt, dbms_sql.native);
213: fnd_dsql.do_binds;

Line 212: DBMS_SQL.parse(l_cursor_id, l_update_stmt, dbms_sql.native);

208:
209: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
210: fnd_dsql.set_cursor(l_cursor_id);
211:
212: DBMS_SQL.parse(l_cursor_id, l_update_stmt, dbms_sql.native);
213: fnd_dsql.do_binds;
214:
215: l_updated_rows := dbms_sql.EXECUTE(l_cursor_id);
216:

Line 215: l_updated_rows := dbms_sql.EXECUTE(l_cursor_id);

211:
212: DBMS_SQL.parse(l_cursor_id, l_update_stmt, dbms_sql.native);
213: fnd_dsql.do_binds;
214:
215: l_updated_rows := dbms_sql.EXECUTE(l_cursor_id);
216:
217: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
218:
219: COMMIT;

Line 217: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

213: fnd_dsql.do_binds;
214:
215: l_updated_rows := dbms_sql.EXECUTE(l_cursor_id);
216:
217: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
218:
219: COMMIT;
220:
221: IF (l_updated_rows > 0) THEN

Line 237: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

233: EXCEPTION
234: WHEN OTHERS THEN
235:
236: IF l_cursor_id IS NOT NULL THEN
237: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
238: END IF;
239:
240: ROLLBACK;
241: