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

Line 181: I_CURSOR := dbms_sql.open_cursor;

177:
178: I_QUERY := 'SELECT count(*)' ||
179: substr(ZONE_SQL, I_FROM_POS);
180:
181: I_CURSOR := dbms_sql.open_cursor;
182: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
183: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
184: I_VOID := dbms_sql.execute(I_CURSOR);
185: I_VOID := dbms_sql.fetch_rows(I_CURSOR);

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

178: I_QUERY := 'SELECT count(*)' ||
179: substr(ZONE_SQL, I_FROM_POS);
180:
181: I_CURSOR := dbms_sql.open_cursor;
182: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
183: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
184: I_VOID := dbms_sql.execute(I_CURSOR);
185: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
186: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);

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

179: substr(ZONE_SQL, I_FROM_POS);
180:
181: I_CURSOR := dbms_sql.open_cursor;
182: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
183: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
184: I_VOID := dbms_sql.execute(I_CURSOR);
185: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
186: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
187: dbms_sql.close_cursor(I_CURSOR);

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

180:
181: I_CURSOR := dbms_sql.open_cursor;
182: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
183: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
184: I_VOID := dbms_sql.execute(I_CURSOR);
185: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
186: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
187: dbms_sql.close_cursor(I_CURSOR);
188:

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

181: I_CURSOR := dbms_sql.open_cursor;
182: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
183: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
184: I_VOID := dbms_sql.execute(I_CURSOR);
185: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
186: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
187: dbms_sql.close_cursor(I_CURSOR);
188:
189: return I_COUNT;

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

182: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
183: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
184: I_VOID := dbms_sql.execute(I_CURSOR);
185: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
186: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
187: dbms_sql.close_cursor(I_CURSOR);
188:
189: return I_COUNT;
190:

Line 187: dbms_sql.close_cursor(I_CURSOR);

183: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
184: I_VOID := dbms_sql.execute(I_CURSOR);
185: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
186: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
187: dbms_sql.close_cursor(I_CURSOR);
188:
189: return I_COUNT;
190:
191: exception

Line 372: I_CURSOR := dbms_sql.open_cursor;

368: InitialiseDomain('FEATURE_TYPE');
369: InitialiseDomain('PROVISION_STATUS');
370:
371:
372: I_CURSOR := dbms_sql.open_cursor;
373: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
374: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
375: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME, 40);
376: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE, 40);

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

369: InitialiseDomain('PROVISION_STATUS');
370:
371:
372: I_CURSOR := dbms_sql.open_cursor;
373: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
374: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
375: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME, 40);
376: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE, 40);
377: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE, 15);

Line 374: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);

370:
371:
372: I_CURSOR := dbms_sql.open_cursor;
373: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
374: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
375: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME, 40);
376: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE, 40);
377: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE, 15);
378: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS, 20);

Line 375: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME, 40);

371:
372: I_CURSOR := dbms_sql.open_cursor;
373: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
374: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
375: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME, 40);
376: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE, 40);
377: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE, 15);
378: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS, 20);
379:

Line 376: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE, 40);

372: I_CURSOR := dbms_sql.open_cursor;
373: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
374: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
375: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME, 40);
376: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE, 40);
377: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE, 15);
378: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS, 20);
379:
380: I_VOID := dbms_sql.execute(I_CURSOR);

Line 377: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE, 15);

373: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
374: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
375: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME, 40);
376: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE, 40);
377: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE, 15);
378: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS, 20);
379:
380: I_VOID := dbms_sql.execute(I_CURSOR);
381: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 378: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS, 20);

374: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
375: dbms_sql.define_column(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME, 40);
376: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE, 40);
377: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE, 15);
378: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS, 20);
379:
380: I_VOID := dbms_sql.execute(I_CURSOR);
381: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
382: else

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

376: dbms_sql.define_column(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE, 40);
377: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE, 15);
378: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS, 20);
379:
380: I_VOID := dbms_sql.execute(I_CURSOR);
381: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
382: else
383: I_ROWS_FETCHED := 0;
384: end if;

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

377: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE, 15);
378: dbms_sql.define_column(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS, 20);
379:
380: I_VOID := dbms_sql.execute(I_CURSOR);
381: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
382: else
383: I_ROWS_FETCHED := 0;
384: end if;
385: I_TOTAL_ROWS := I_ROWS_FETCHED;

Line 403: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);

399:
400: while I_ROWS_FETCHED <> 0 loop
401:
402: if I_TOTAL_ROWS >= I_START then
403: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
404: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME);
405: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE);
406: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE);
407: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS);

Line 404: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME);

400: while I_ROWS_FETCHED <> 0 loop
401:
402: if I_TOTAL_ROWS >= I_START then
403: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
404: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME);
405: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE);
406: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE);
407: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS);
408: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SMS_FE_MAP_ID));

Line 405: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE);

401:
402: if I_TOTAL_ROWS >= I_START then
403: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
404: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME);
405: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE);
406: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE);
407: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS);
408: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SMS_FE_MAP_ID));
409:

Line 406: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE);

402: if I_TOTAL_ROWS >= I_START then
403: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
404: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME);
405: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE);
406: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE);
407: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS);
408: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SMS_FE_MAP_ID));
409:
410:

Line 407: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS);

403: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SMS_FE_MAP_ID);
404: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME);
405: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE);
406: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE);
407: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS);
408: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SMS_FE_MAP_ID));
409:
410:
411: XNP_WSGL.LayoutRowStart('TOP');

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

414: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_FEATURE_TYPE, CURR_VAL.FEATURE_TYPE));
415: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_PROVISION_STATUS, CURR_VAL.PROVISION_STATUS));
416: XNP_WSGL.LayoutRowEnd;
417:
418: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
419: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
420: if I_ROWS_FETCHED <> 0 then
421: I_NEXT_BUT := TRUE;
422: end if;

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

422: end if;
423: exit;
424: end if;
425: else
426: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
427: end if;
428:
429: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
430:

Line 448: dbms_sql.close_cursor(I_CURSOR);

444: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
445: end if;
446:
447: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
448: dbms_sql.close_cursor(I_CURSOR);
449: end if;
450:
451: htp.formOpen(curl => 'xnp_sv_network$sms_fe_map.querylist', cattributes => 'NAME="frmZero"');
452: XNP_WSGL.HiddenField('P_SV_SMS_ID', P_SV_SMS_ID);