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_SEQNUM dependencies on DBMS_SQL

Line 92: * Fix Bug 1073084 - changed to use EXECUTE IMMEDIATE instead of dbms_sql.

88: end get_seq_name;
89:
90: /*
91: * This function gets the nextval for a db sequence given the seq name.
92: * Fix Bug 1073084 - changed to use EXECUTE IMMEDIATE instead of dbms_sql.
93: */
94: function get_next_auto_seq (dbseqnm in varchar2) return number
95: is
96: v_proc_stmt varchar2(100);

Line 167: c := dbms_sql.open_cursor;

163: 10,'DD-MM-YYYY',
164: 11,'DD-MON-YYYY',
165: 'YYYY/MM/DD')) +.9999);
166:
167: c := dbms_sql.open_cursor;
168:
169: proc_stmt := 'begin select ' || dbseqnm || '.nextval ' ||
170: 'into :next_val from sys.dual; end;';
171:

Line 172: dbms_sql.parse(c, proc_stmt, dbms_sql.native);

168:
169: proc_stmt := 'begin select ' || dbseqnm || '.nextval ' ||
170: 'into :next_val from sys.dual; end;';
171:
172: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
173: dbms_sql.bind_variable(c, 'next_val', next_val);
174:
175: row_processed := dbms_sql.execute(c);
176: dbms_sql.variable_value(c,'next_val', val);

Line 173: dbms_sql.bind_variable(c, 'next_val', next_val);

169: proc_stmt := 'begin select ' || dbseqnm || '.nextval ' ||
170: 'into :next_val from sys.dual; end;';
171:
172: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
173: dbms_sql.bind_variable(c, 'next_val', next_val);
174:
175: row_processed := dbms_sql.execute(c);
176: dbms_sql.variable_value(c,'next_val', val);
177:

Line 175: row_processed := dbms_sql.execute(c);

171:
172: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
173: dbms_sql.bind_variable(c, 'next_val', next_val);
174:
175: row_processed := dbms_sql.execute(c);
176: dbms_sql.variable_value(c,'next_val', val);
177:
178: dbms_sql.close_cursor(c);
179: return (val);

Line 176: dbms_sql.variable_value(c,'next_val', val);

172: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
173: dbms_sql.bind_variable(c, 'next_val', next_val);
174:
175: row_processed := dbms_sql.execute(c);
176: dbms_sql.variable_value(c,'next_val', val);
177:
178: dbms_sql.close_cursor(c);
179: return (val);
180:

Line 178: dbms_sql.close_cursor(c);

174:
175: row_processed := dbms_sql.execute(c);
176: dbms_sql.variable_value(c,'next_val', val);
177:
178: dbms_sql.close_cursor(c);
179: return (val);
180:
181: exception
182: when NO_DATA_FOUND then

Line 217: c := dbms_sql.open_cursor;

213: /* bug 1019289, 1295363 - change between to add .9999 to end date also removed trunc
214: and date coversion routines not needed since this trx_date is a date */
215: AND trx_date between sa.start_date and nvl(sa.end_date + .9999, trx_date + .9999);
216:
217: c := dbms_sql.open_cursor;
218:
219: proc_stmt := 'begin select ' || dbseqnm || '.nextval ' ||
220: 'into :next_val from sys.dual; end;';
221:

Line 222: dbms_sql.parse(c, proc_stmt, dbms_sql.native);

218:
219: proc_stmt := 'begin select ' || dbseqnm || '.nextval ' ||
220: 'into :next_val from sys.dual; end;';
221:
222: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
223: dbms_sql.bind_variable(c, 'next_val', next_val);
224:
225: row_processed := dbms_sql.execute(c);
226: dbms_sql.variable_value(c,'next_val', val);

Line 223: dbms_sql.bind_variable(c, 'next_val', next_val);

219: proc_stmt := 'begin select ' || dbseqnm || '.nextval ' ||
220: 'into :next_val from sys.dual; end;';
221:
222: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
223: dbms_sql.bind_variable(c, 'next_val', next_val);
224:
225: row_processed := dbms_sql.execute(c);
226: dbms_sql.variable_value(c,'next_val', val);
227:

Line 225: row_processed := dbms_sql.execute(c);

221:
222: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
223: dbms_sql.bind_variable(c, 'next_val', next_val);
224:
225: row_processed := dbms_sql.execute(c);
226: dbms_sql.variable_value(c,'next_val', val);
227:
228: dbms_sql.close_cursor(c);
229: return (val);

Line 226: dbms_sql.variable_value(c,'next_val', val);

222: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
223: dbms_sql.bind_variable(c, 'next_val', next_val);
224:
225: row_processed := dbms_sql.execute(c);
226: dbms_sql.variable_value(c,'next_val', val);
227:
228: dbms_sql.close_cursor(c);
229: return (val);
230:

Line 228: dbms_sql.close_cursor(c);

224:
225: row_processed := dbms_sql.execute(c);
226: dbms_sql.variable_value(c,'next_val', val);
227:
228: dbms_sql.close_cursor(c);
229: return (val);
230:
231: exception
232: when NO_DATA_FOUND then

Line 588: * Fix Bug 1073084 - changed to use EXECUTE IMMEDIATE instead of dbms_sql.

584: end get_seq_info;
585:
586: /*
587: * This finction creates an audit record in the audit table for the current DocSeq
588: * Fix Bug 1073084 - changed to use EXECUTE IMMEDIATE instead of dbms_sql.
589: */
590: function create_audit_rec ( aud_tab_name in varchar2,
591: docseq_id in number,
592: seq_val in number,