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.XNP_SV_ORDERS$SOA_EVENTS dependencies on DBMS_SQL

Line 161: I_CURSOR := dbms_sql.open_cursor;

157:
158: I_QUERY := 'SELECT count(*)' ||
159: substr(ZONE_SQL, I_FROM_POS);
160:
161: I_CURSOR := dbms_sql.open_cursor;
162: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
163: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
164: I_VOID := dbms_sql.execute(I_CURSOR);
165: I_VOID := dbms_sql.fetch_rows(I_CURSOR);

Line 162: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);

158: I_QUERY := 'SELECT count(*)' ||
159: substr(ZONE_SQL, I_FROM_POS);
160:
161: I_CURSOR := dbms_sql.open_cursor;
162: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
163: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
164: I_VOID := dbms_sql.execute(I_CURSOR);
165: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
166: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);

Line 163: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);

159: substr(ZONE_SQL, I_FROM_POS);
160:
161: I_CURSOR := dbms_sql.open_cursor;
162: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
163: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
164: I_VOID := dbms_sql.execute(I_CURSOR);
165: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
166: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
167: dbms_sql.close_cursor(I_CURSOR);

Line 164: I_VOID := dbms_sql.execute(I_CURSOR);

160:
161: I_CURSOR := dbms_sql.open_cursor;
162: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
163: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
164: I_VOID := dbms_sql.execute(I_CURSOR);
165: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
166: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
167: dbms_sql.close_cursor(I_CURSOR);
168:

Line 165: I_VOID := dbms_sql.fetch_rows(I_CURSOR);

161: I_CURSOR := dbms_sql.open_cursor;
162: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
163: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
164: I_VOID := dbms_sql.execute(I_CURSOR);
165: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
166: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
167: dbms_sql.close_cursor(I_CURSOR);
168:
169: return I_COUNT;

Line 166: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);

162: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
163: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
164: I_VOID := dbms_sql.execute(I_CURSOR);
165: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
166: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
167: dbms_sql.close_cursor(I_CURSOR);
168:
169: return I_COUNT;
170:

Line 167: dbms_sql.close_cursor(I_CURSOR);

163: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
164: I_VOID := dbms_sql.execute(I_CURSOR);
165: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
166: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
167: dbms_sql.close_cursor(I_CURSOR);
168:
169: return I_COUNT;
170:
171: exception

Line 348: I_CURSOR := dbms_sql.open_cursor;

344:
345: InitialiseDomain('EVENT_TYPE');
346:
347:
348: I_CURSOR := dbms_sql.open_cursor;
349: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
350: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
351: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.EVENT_CODE, 40);
352: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.EVENT_TYPE, 20);

Line 349: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);

345: InitialiseDomain('EVENT_TYPE');
346:
347:
348: I_CURSOR := dbms_sql.open_cursor;
349: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
350: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
351: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.EVENT_CODE, 40);
352: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.EVENT_TYPE, 20);
353: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);

Line 350: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);

346:
347:
348: I_CURSOR := dbms_sql.open_cursor;
349: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
350: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
351: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.EVENT_CODE, 40);
352: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.EVENT_TYPE, 20);
353: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
354: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE, 20);

Line 351: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.EVENT_CODE, 40);

347:
348: I_CURSOR := dbms_sql.open_cursor;
349: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
350: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
351: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.EVENT_CODE, 40);
352: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.EVENT_TYPE, 20);
353: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
354: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE, 20);
355:

Line 352: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.EVENT_TYPE, 20);

348: I_CURSOR := dbms_sql.open_cursor;
349: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
350: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
351: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.EVENT_CODE, 40);
352: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.EVENT_TYPE, 20);
353: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
354: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE, 20);
355:
356: I_VOID := dbms_sql.execute(I_CURSOR);

Line 353: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);

349: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
350: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
351: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.EVENT_CODE, 40);
352: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.EVENT_TYPE, 20);
353: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
354: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE, 20);
355:
356: I_VOID := dbms_sql.execute(I_CURSOR);
357: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 354: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE, 20);

350: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
351: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.EVENT_CODE, 40);
352: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.EVENT_TYPE, 20);
353: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
354: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE, 20);
355:
356: I_VOID := dbms_sql.execute(I_CURSOR);
357: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
358: else

Line 356: I_VOID := dbms_sql.execute(I_CURSOR);

352: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.EVENT_TYPE, 20);
353: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
354: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE, 20);
355:
356: I_VOID := dbms_sql.execute(I_CURSOR);
357: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
358: else
359: I_ROWS_FETCHED := 0;
360: end if;

Line 357: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

353: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
354: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE, 20);
355:
356: I_VOID := dbms_sql.execute(I_CURSOR);
357: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
358: else
359: I_ROWS_FETCHED := 0;
360: end if;
361: I_TOTAL_ROWS := I_ROWS_FETCHED;

Line 379: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);

375:
376: while I_ROWS_FETCHED <> 0 loop
377:
378: if I_TOTAL_ROWS >= I_START then
379: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
380: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.EVENT_CODE);
381: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.EVENT_TYPE);
382: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
383: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE);

Line 380: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.EVENT_CODE);

376: while I_ROWS_FETCHED <> 0 loop
377:
378: if I_TOTAL_ROWS >= I_START then
379: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
380: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.EVENT_CODE);
381: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.EVENT_TYPE);
382: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
383: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE);
384: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_EVENT_HISTORY_ID));

Line 381: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.EVENT_TYPE);

377:
378: if I_TOTAL_ROWS >= I_START then
379: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
380: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.EVENT_CODE);
381: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.EVENT_TYPE);
382: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
383: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE);
384: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_EVENT_HISTORY_ID));
385:

Line 382: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);

378: if I_TOTAL_ROWS >= I_START then
379: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
380: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.EVENT_CODE);
381: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.EVENT_TYPE);
382: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
383: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE);
384: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_EVENT_HISTORY_ID));
385:
386:

Line 383: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE);

379: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_EVENT_HISTORY_ID);
380: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.EVENT_CODE);
381: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.EVENT_TYPE);
382: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
383: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE);
384: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_EVENT_HISTORY_ID));
385:
386:
387: XNP_WSGL.LayoutRowStart('TOP');

Line 394: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

390: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.EVENT_TIMESTAMP, 'DD-MON-YYYY (Day) HH:MI:SS AM')));
391: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CAUSE_CODE);
392: XNP_WSGL.LayoutRowEnd;
393:
394: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
395: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
396: if I_ROWS_FETCHED <> 0 then
397: I_NEXT_BUT := TRUE;
398: end if;

Line 402: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

398: end if;
399: exit;
400: end if;
401: else
402: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
403: end if;
404:
405: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
406:

Line 424: dbms_sql.close_cursor(I_CURSOR);

420: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
421: end if;
422:
423: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
424: dbms_sql.close_cursor(I_CURSOR);
425: end if;
426:
427: htp.formOpen(curl => 'xnp_sv_orders$soa_events.querylist', cattributes => 'NAME="frmZero"');
428: XNP_WSGL.HiddenField('P_SV_SOA_ID', P_SV_SOA_ID);