eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_MLS_REQUEST dependencies on DBMS_SQL

Line 164: fcursor varchar2(75); /* Cursor string for dbms_sql */

160: error boolean default FALSE;
161: req_data varchar2(240); /* State of last FNDMLSUB run. */
162: has_reqs boolean default FALSE;
163: funct varchar2(61); /* Function string */
164: fcursor varchar2(75); /* Cursor string for dbms_sql */
165: cid number; /* Cursor ID for dbms_sql */
166: dummy number;
167: printer varchar2(30);
168: copies number;

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

161: req_data varchar2(240); /* State of last FNDMLSUB run. */
162: has_reqs boolean default FALSE;
163: funct varchar2(61); /* Function string */
164: fcursor varchar2(75); /* Cursor string for dbms_sql */
165: cid number; /* Cursor ID for dbms_sql */
166: dummy number;
167: printer varchar2(30);
168: copies number;
169: parent_id number;

Line 258: cid := dbms_sql.open_cursor;

254: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
255:
256: fcursor := 'begin :r := '||funct||'; end;';
257: begin
258: cid := dbms_sql.open_cursor;
259: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
260: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
261: dummy := dbms_sql.execute(cid);
262: dbms_sql.variable_value(cid, ':r', func_outcome);

Line 259: dbms_sql.parse(cid, fcursor, dbms_sql.v7);

255:
256: fcursor := 'begin :r := '||funct||'; end;';
257: begin
258: cid := dbms_sql.open_cursor;
259: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
260: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
261: dummy := dbms_sql.execute(cid);
262: dbms_sql.variable_value(cid, ':r', func_outcome);
263: dbms_sql.close_cursor(cid);

Line 260: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);

256: fcursor := 'begin :r := '||funct||'; end;';
257: begin
258: cid := dbms_sql.open_cursor;
259: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
260: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
261: dummy := dbms_sql.execute(cid);
262: dbms_sql.variable_value(cid, ':r', func_outcome);
263: dbms_sql.close_cursor(cid);
264: exception

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

257: begin
258: cid := dbms_sql.open_cursor;
259: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
260: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
261: dummy := dbms_sql.execute(cid);
262: dbms_sql.variable_value(cid, ':r', func_outcome);
263: dbms_sql.close_cursor(cid);
264: exception
265: when others then

Line 262: dbms_sql.variable_value(cid, ':r', func_outcome);

258: cid := dbms_sql.open_cursor;
259: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
260: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
261: dummy := dbms_sql.execute(cid);
262: dbms_sql.variable_value(cid, ':r', func_outcome);
263: dbms_sql.close_cursor(cid);
264: exception
265: when others then
266: errbuf := gen_error(funct, SQLCODE, SQLERRM);

Line 263: dbms_sql.close_cursor(cid);

259: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
260: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
261: dummy := dbms_sql.execute(cid);
262: dbms_sql.variable_value(cid, ':r', func_outcome);
263: dbms_sql.close_cursor(cid);
264: exception
265: when others then
266: errbuf := gen_error(funct, SQLCODE, SQLERRM);
267: retcode := 2;