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

Line 127: I_CURSOR := dbms_sql.open_cursor;

123:
124: I_QUERY := 'SELECT count(*)' ||
125: substr(ZONE_SQL, I_FROM_POS);
126:
127: I_CURSOR := dbms_sql.open_cursor;
128: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
129: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
130: I_VOID := dbms_sql.execute(I_CURSOR);
131: I_VOID := dbms_sql.fetch_rows(I_CURSOR);

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

124: I_QUERY := 'SELECT count(*)' ||
125: substr(ZONE_SQL, I_FROM_POS);
126:
127: I_CURSOR := dbms_sql.open_cursor;
128: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
129: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
130: I_VOID := dbms_sql.execute(I_CURSOR);
131: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
132: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);

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

125: substr(ZONE_SQL, I_FROM_POS);
126:
127: I_CURSOR := dbms_sql.open_cursor;
128: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
129: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
130: I_VOID := dbms_sql.execute(I_CURSOR);
131: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
132: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
133: dbms_sql.close_cursor(I_CURSOR);

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

126:
127: I_CURSOR := dbms_sql.open_cursor;
128: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
129: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
130: I_VOID := dbms_sql.execute(I_CURSOR);
131: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
132: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
133: dbms_sql.close_cursor(I_CURSOR);
134:

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

127: I_CURSOR := dbms_sql.open_cursor;
128: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
129: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
130: I_VOID := dbms_sql.execute(I_CURSOR);
131: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
132: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
133: dbms_sql.close_cursor(I_CURSOR);
134:
135: return I_COUNT;

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

128: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
129: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
130: I_VOID := dbms_sql.execute(I_CURSOR);
131: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
132: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
133: dbms_sql.close_cursor(I_CURSOR);
134:
135: return I_COUNT;
136:

Line 133: dbms_sql.close_cursor(I_CURSOR);

129: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
130: I_VOID := dbms_sql.execute(I_CURSOR);
131: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
132: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
133: dbms_sql.close_cursor(I_CURSOR);
134:
135: return I_COUNT;
136:
137: exception

Line 310: I_CURSOR := dbms_sql.open_cursor;

306: end if;
307:
308:
309:
310: I_CURSOR := dbms_sql.open_cursor;
311: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
312: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);
313: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
314: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);

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

307:
308:
309:
310: I_CURSOR := dbms_sql.open_cursor;
311: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
312: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);
313: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
314: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);
315:

Line 312: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);

308:
309:
310: I_CURSOR := dbms_sql.open_cursor;
311: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
312: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);
313: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
314: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);
315:
316: I_VOID := dbms_sql.execute(I_CURSOR);

Line 313: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);

309:
310: I_CURSOR := dbms_sql.open_cursor;
311: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
312: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);
313: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
314: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);
315:
316: I_VOID := dbms_sql.execute(I_CURSOR);
317: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 314: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);

310: I_CURSOR := dbms_sql.open_cursor;
311: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
312: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);
313: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
314: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);
315:
316: I_VOID := dbms_sql.execute(I_CURSOR);
317: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
318: else

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

312: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);
313: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
314: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);
315:
316: I_VOID := dbms_sql.execute(I_CURSOR);
317: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
318: else
319: I_ROWS_FETCHED := 0;
320: end if;

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

313: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.ORDER_ID);
314: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);
315:
316: I_VOID := dbms_sql.execute(I_CURSOR);
317: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
318: else
319: I_ROWS_FETCHED := 0;
320: end if;
321: I_TOTAL_ROWS := I_ROWS_FETCHED;

Line 337: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);

333:
334: while I_ROWS_FETCHED <> 0 loop
335:
336: if I_TOTAL_ROWS >= I_START then
337: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);
338: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
339: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);
340: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_ORDER_MAPPING_ID));
341:

Line 338: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);

334: while I_ROWS_FETCHED <> 0 loop
335:
336: if I_TOTAL_ROWS >= I_START then
337: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);
338: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
339: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);
340: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_ORDER_MAPPING_ID));
341:
342:

Line 339: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);

335:
336: if I_TOTAL_ROWS >= I_START then
337: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);
338: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
339: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);
340: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_ORDER_MAPPING_ID));
341:
342:
343: XNP_WSGL.LayoutRowStart('TOP');

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

344: XNP_WSGL.LayoutData(CURR_VAL.ORDER_ID);
345: XNP_WSGL.LayoutData(CURR_VAL.WORKITEM_INSTANCE_ID);
346: XNP_WSGL.LayoutRowEnd;
347:
348: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
349: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
350: if I_ROWS_FETCHED <> 0 then
351: I_NEXT_BUT := TRUE;
352: end if;

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

352: end if;
353: exit;
354: end if;
355: else
356: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
357: end if;
358:
359: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
360:

Line 378: dbms_sql.close_cursor(I_CURSOR);

374: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
375: end if;
376:
377: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
378: dbms_sql.close_cursor(I_CURSOR);
379: end if;
380:
381: htp.formOpen(curl => 'xnp_sv_orders$soa_orders.querylist', cattributes => 'NAME="frmZero"');
382: XNP_WSGL.HiddenField('P_SV_SOA_ID', P_SV_SOA_ID);