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

Line 397: I_CURSOR := dbms_sql.open_cursor;

393:
394: I_QUERY := 'SELECT count(*)' ||
395: substr(ZONE_SQL, I_FROM_POS);
396:
397: I_CURSOR := dbms_sql.open_cursor;
398: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
399: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
400: I_VOID := dbms_sql.execute(I_CURSOR);
401: I_VOID := dbms_sql.fetch_rows(I_CURSOR);

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

394: I_QUERY := 'SELECT count(*)' ||
395: substr(ZONE_SQL, I_FROM_POS);
396:
397: I_CURSOR := dbms_sql.open_cursor;
398: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
399: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
400: I_VOID := dbms_sql.execute(I_CURSOR);
401: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
402: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);

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

395: substr(ZONE_SQL, I_FROM_POS);
396:
397: I_CURSOR := dbms_sql.open_cursor;
398: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
399: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
400: I_VOID := dbms_sql.execute(I_CURSOR);
401: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
402: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
403: dbms_sql.close_cursor(I_CURSOR);

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

396:
397: I_CURSOR := dbms_sql.open_cursor;
398: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
399: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
400: I_VOID := dbms_sql.execute(I_CURSOR);
401: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
402: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
403: dbms_sql.close_cursor(I_CURSOR);
404:

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

397: I_CURSOR := dbms_sql.open_cursor;
398: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
399: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
400: I_VOID := dbms_sql.execute(I_CURSOR);
401: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
402: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
403: dbms_sql.close_cursor(I_CURSOR);
404:
405: return I_COUNT;

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

398: dbms_sql.parse(I_CURSOR, I_QUERY, dbms_sql.v7);
399: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
400: I_VOID := dbms_sql.execute(I_CURSOR);
401: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
402: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
403: dbms_sql.close_cursor(I_CURSOR);
404:
405: return I_COUNT;
406:

Line 403: dbms_sql.close_cursor(I_CURSOR);

399: dbms_sql.define_column(I_CURSOR, 1, I_COUNT);
400: I_VOID := dbms_sql.execute(I_CURSOR);
401: I_VOID := dbms_sql.fetch_rows(I_CURSOR);
402: dbms_sql.column_value(I_CURSOR, 1, I_COUNT);
403: dbms_sql.close_cursor(I_CURSOR);
404:
405: return I_COUNT;
406:
407: exception

Line 1052: I_CURSOR := dbms_sql.open_cursor;

1048: end if;
1049:
1050:
1051:
1052: I_CURSOR := dbms_sql.open_cursor;
1053: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1054: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1055: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1056: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);

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

1049:
1050:
1051:
1052: I_CURSOR := dbms_sql.open_cursor;
1053: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1054: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1055: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1056: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1057: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);

Line 1054: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);

1050:
1051:
1052: I_CURSOR := dbms_sql.open_cursor;
1053: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1054: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1055: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1056: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1057: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1058:

Line 1055: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);

1051:
1052: I_CURSOR := dbms_sql.open_cursor;
1053: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1054: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1055: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1056: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1057: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1058:
1059: I_VOID := dbms_sql.execute(I_CURSOR);

Line 1056: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);

1052: I_CURSOR := dbms_sql.open_cursor;
1053: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1054: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1055: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1056: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1057: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1058:
1059: I_VOID := dbms_sql.execute(I_CURSOR);
1060: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 1057: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);

1053: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1054: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1055: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1056: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1057: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1058:
1059: I_VOID := dbms_sql.execute(I_CURSOR);
1060: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1061: else

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

1055: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1056: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1057: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1058:
1059: I_VOID := dbms_sql.execute(I_CURSOR);
1060: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1061: else
1062: I_ROWS_FETCHED := 0;
1063: end if;

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

1056: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1057: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1058:
1059: I_VOID := dbms_sql.execute(I_CURSOR);
1060: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1061: else
1062: I_ROWS_FETCHED := 0;
1063: end if;
1064: I_TOTAL_ROWS := I_ROWS_FETCHED;

Line 1081: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);

1077:
1078: while I_ROWS_FETCHED <> 0 loop
1079:
1080: if I_TOTAL_ROWS >= I_START then
1081: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1082: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);
1083: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);
1084: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1085: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SMS_ID));

Line 1082: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);

1078: while I_ROWS_FETCHED <> 0 loop
1079:
1080: if I_TOTAL_ROWS >= I_START then
1081: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1082: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);
1083: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);
1084: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1085: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SMS_ID));
1086:

Line 1083: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);

1079:
1080: if I_TOTAL_ROWS >= I_START then
1081: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1082: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);
1083: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);
1084: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1085: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SMS_ID));
1086:
1087:

Line 1084: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);

1080: if I_TOTAL_ROWS >= I_START then
1081: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1082: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);
1083: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);
1084: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1085: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SMS_ID));
1086:
1087:
1088: XNP_WSGL.LayoutRowStart('TOP');

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

1090: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1091: XNP_WSGL.LayoutData(CURR_VAL.ROUTING_NUMBER);
1092: XNP_WSGL.LayoutRowEnd;
1093:
1094: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1095: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1096: if I_ROWS_FETCHED <> 0 then
1097: I_NEXT_BUT := TRUE;
1098: end if;

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

1098: end if;
1099: exit;
1100: end if;
1101: else
1102: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1103: end if;
1104:
1105: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
1106:

Line 1124: dbms_sql.close_cursor(I_CURSOR);

1120: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
1121: end if;
1122:
1123: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1124: dbms_sql.close_cursor(I_CURSOR);
1125: end if;
1126:
1127: htp.formOpen(curl => 'xnp_sv_network$sms_sv.querylist', cattributes => 'NAME="frmZero"');
1128: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);

Line 1250: I_CURSOR := dbms_sql.open_cursor;

1246: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
1247: return;
1248: end if;
1249:
1250: I_CURSOR := dbms_sql.open_cursor;
1251: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1252: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1253: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1254: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);

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

1247: return;
1248: end if;
1249:
1250: I_CURSOR := dbms_sql.open_cursor;
1251: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1252: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1253: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1254: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1255: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);

Line 1252: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);

1248: end if;
1249:
1250: I_CURSOR := dbms_sql.open_cursor;
1251: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1252: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1253: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1254: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1255: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1256:

Line 1253: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);

1249:
1250: I_CURSOR := dbms_sql.open_cursor;
1251: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1252: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1253: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1254: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1255: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1256:
1257: I_VOID := dbms_sql.execute(I_CURSOR);

Line 1254: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);

1250: I_CURSOR := dbms_sql.open_cursor;
1251: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1252: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1253: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1254: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1255: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1256:
1257: I_VOID := dbms_sql.execute(I_CURSOR);
1258:

Line 1255: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);

1251: dbms_sql.parse(I_CURSOR, ZONE_SQL, dbms_sql.v7);
1252: dbms_sql.define_column(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1253: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1254: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1255: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1256:
1257: I_VOID := dbms_sql.execute(I_CURSOR);
1258:
1259: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

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

1253: dbms_sql.define_column(I_CURSOR, 2, CURR_VAL.PORTING_ID, 80);
1254: dbms_sql.define_column(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN, 20);
1255: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1256:
1257: I_VOID := dbms_sql.execute(I_CURSOR);
1258:
1259: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1260:
1261: if I_ROWS_FETCHED = 0 then

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

1255: dbms_sql.define_column(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER, 20);
1256:
1257: I_VOID := dbms_sql.execute(I_CURSOR);
1258:
1259: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1260:
1261: if I_ROWS_FETCHED = 0 then
1262: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1263: else

Line 1264: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);

1260:
1261: if I_ROWS_FETCHED = 0 then
1262: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1263: else
1264: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1265: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);
1266: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);
1267: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1268: xnp_sv_network$sms_sv.QueryView(Z_DIRECT_CALL=>TRUE);

Line 1265: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);

1261: if I_ROWS_FETCHED = 0 then
1262: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1263: else
1264: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1265: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);
1266: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);
1267: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1268: xnp_sv_network$sms_sv.QueryView(Z_DIRECT_CALL=>TRUE);
1269: end if;

Line 1266: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);

1262: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1263: else
1264: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1265: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);
1266: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);
1267: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1268: xnp_sv_network$sms_sv.QueryView(Z_DIRECT_CALL=>TRUE);
1269: end if;
1270:

Line 1267: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);

1263: else
1264: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1265: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);
1266: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);
1267: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1268: xnp_sv_network$sms_sv.QueryView(Z_DIRECT_CALL=>TRUE);
1269: end if;
1270:
1271: dbms_sql.close_cursor(I_CURSOR);

Line 1271: dbms_sql.close_cursor(I_CURSOR);

1267: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1268: xnp_sv_network$sms_sv.QueryView(Z_DIRECT_CALL=>TRUE);
1269: end if;
1270:
1271: dbms_sql.close_cursor(I_CURSOR);
1272:
1273: exception
1274: when others then
1275: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',