APPS.FND_AMP_PRIVATE dependencies on DBMS_SQL

Line 304: kcursor varchar2(75); /* Cursor string for dbms_sql */

300: --
301: function kill_session (audsid in number,
302: message in out NOCOPY varchar2,
303: inst_id in number default 1) return number is
304: kcursor varchar2(75); /* Cursor string for dbms_sql */
305: cid number; /* Cursor ID for dbms_sql */
306: ssid number;
307: sserial# number;
308: dummy number;

Line 305: cid number; /* Cursor ID for dbms_sql */

301: function kill_session (audsid in number,
302: message in out NOCOPY varchar2,
303: inst_id in number default 1) return number is
304: kcursor varchar2(75); /* Cursor string for dbms_sql */
305: cid number; /* Cursor ID for dbms_sql */
306: ssid number;
307: sserial# number;
308: dummy number;
309: begin

Line 337: cid := dbms_sql.open_cursor;

333:
334: kcursor := 'alter system kill session '''|| to_char(ssid) || ',' ||
335: to_char(sserial#)||'''';
336: begin
337: cid := dbms_sql.open_cursor;
338: dbms_sql.parse(cid, kcursor, dbms_sql.v7);
339: dummy := dbms_sql.execute(cid);
340: dbms_sql.close_cursor(cid);
341: exception

Line 338: dbms_sql.parse(cid, kcursor, dbms_sql.v7);

334: kcursor := 'alter system kill session '''|| to_char(ssid) || ',' ||
335: to_char(sserial#)||'''';
336: begin
337: cid := dbms_sql.open_cursor;
338: dbms_sql.parse(cid, kcursor, dbms_sql.v7);
339: dummy := dbms_sql.execute(cid);
340: dbms_sql.close_cursor(cid);
341: exception
342: when others then

Line 339: dummy := dbms_sql.execute(cid);

335: to_char(sserial#)||'''';
336: begin
337: cid := dbms_sql.open_cursor;
338: dbms_sql.parse(cid, kcursor, dbms_sql.v7);
339: dummy := dbms_sql.execute(cid);
340: dbms_sql.close_cursor(cid);
341: exception
342: when others then
343: if SQLCODE = -30 then

Line 340: dbms_sql.close_cursor(cid);

336: begin
337: cid := dbms_sql.open_cursor;
338: dbms_sql.parse(cid, kcursor, dbms_sql.v7);
339: dummy := dbms_sql.execute(cid);
340: dbms_sql.close_cursor(cid);
341: exception
342: when others then
343: if SQLCODE = -30 then
344: return 1;