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_NETWORK$SMS_ORDER dependencies on DBMS_SQL

Line 128: I_CURSOR := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

Line 134: dbms_sql.close_cursor(I_CURSOR);

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

Line 312: I_CURSOR := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 380: dbms_sql.close_cursor(I_CURSOR);

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