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 148: fcursor varchar2(75); /* Cursor string for dbms_sql */

144: error boolean default FALSE;
145: req_data varchar2(240); /* State of last FNDMLSUB run. */
146: has_reqs boolean default FALSE;
147: funct varchar2(61); /* Function string */
148: fcursor varchar2(75); /* Cursor string for dbms_sql */
149: cid number; /* Cursor ID for dbms_sql */
150: dummy number;
151: printer varchar2(30);
152: copies number;

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

145: req_data varchar2(240); /* State of last FNDMLSUB run. */
146: has_reqs boolean default FALSE;
147: funct varchar2(61); /* Function string */
148: fcursor varchar2(75); /* Cursor string for dbms_sql */
149: cid number; /* Cursor ID for dbms_sql */
150: dummy number;
151: printer varchar2(30);
152: copies number;
153: parent_id number;

Line 237: cid := dbms_sql.open_cursor;

233: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
234:
235: fcursor := 'begin :r := '||funct||'; end;';
236: begin
237: cid := dbms_sql.open_cursor;
238: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
239: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
240: dummy := dbms_sql.execute(cid);
241: dbms_sql.variable_value(cid, ':r', func_outcome);

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

234:
235: fcursor := 'begin :r := '||funct||'; end;';
236: begin
237: cid := dbms_sql.open_cursor;
238: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
239: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
240: dummy := dbms_sql.execute(cid);
241: dbms_sql.variable_value(cid, ':r', func_outcome);
242: dbms_sql.close_cursor(cid);

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

235: fcursor := 'begin :r := '||funct||'; end;';
236: begin
237: cid := dbms_sql.open_cursor;
238: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
239: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
240: dummy := dbms_sql.execute(cid);
241: dbms_sql.variable_value(cid, ':r', func_outcome);
242: dbms_sql.close_cursor(cid);
243: exception

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

236: begin
237: cid := dbms_sql.open_cursor;
238: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
239: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
240: dummy := dbms_sql.execute(cid);
241: dbms_sql.variable_value(cid, ':r', func_outcome);
242: dbms_sql.close_cursor(cid);
243: exception
244: when others then

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

237: cid := dbms_sql.open_cursor;
238: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
239: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
240: dummy := dbms_sql.execute(cid);
241: dbms_sql.variable_value(cid, ':r', func_outcome);
242: dbms_sql.close_cursor(cid);
243: exception
244: when others then
245: errbuf := gen_error(funct, SQLCODE, SQLERRM);

Line 242: dbms_sql.close_cursor(cid);

238: dbms_sql.parse(cid, fcursor, dbms_sql.v7);
239: dbms_sql.bind_variable(cid, ':r', func_outcome, 240);
240: dummy := dbms_sql.execute(cid);
241: dbms_sql.variable_value(cid, ':r', func_outcome);
242: dbms_sql.close_cursor(cid);
243: exception
244: when others then
245: errbuf := gen_error(funct, SQLCODE, SQLERRM);
246: retcode := 2;