APPS.AMS_APPR_HIST_PKG dependencies on DBMS_SQL

Line 258: l_lines_csr := DBMS_SQL.open_cursor;

254: else
255: Null;
256: end if;
257:
258: l_lines_csr := DBMS_SQL.open_cursor;
259: l_lines_sql := FND_DSQL.get_text(FALSE); -- Get SQL query built above
260:
261: FND_DSQL.set_cursor(l_lines_csr);
262: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);

Line 262: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);

258: l_lines_csr := DBMS_SQL.open_cursor;
259: l_lines_sql := FND_DSQL.get_text(FALSE); -- Get SQL query built above
260:
261: FND_DSQL.set_cursor(l_lines_csr);
262: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);
263:
264: FND_DSQL.do_binds;
265:
266: l_ignore := DBMS_SQL.execute(l_lines_csr);

Line 266: l_ignore := DBMS_SQL.execute(l_lines_csr);

262: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);
263:
264: FND_DSQL.do_binds;
265:
266: l_ignore := DBMS_SQL.execute(l_lines_csr);
267:
268: DBMS_SQL.CLOSE_CURSOR(l_lines_csr);
269:
270: END Delete_Row ;

Line 268: DBMS_SQL.CLOSE_CURSOR(l_lines_csr);

264: FND_DSQL.do_binds;
265:
266: l_ignore := DBMS_SQL.execute(l_lines_csr);
267:
268: DBMS_SQL.CLOSE_CURSOR(l_lines_csr);
269:
270: END Delete_Row ;
271:
272: