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 XNP_SV_SMS_V

Line 66: CURR_VAL XNP_SV_SMS_V%ROWTYPE;

62: LOV_FRAME constant varchar2(20) := null;
63: TF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
64: DEF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
65:
66: CURR_VAL XNP_SV_SMS_V%ROWTYPE;
67:
68: TYPE FORM_REC IS RECORD
69: (SV_SMS_ID VARCHAR2(8)
70: ,PORTING_ID VARCHAR2(80)

Line 435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);

431: InitialiseDomain('SUBSCRIPTION_TYPE');
432:
433: -- Build up the Where clause
434:
435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);

432:
433: -- Build up the Where clause
434:
435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
440:

Line 437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);

433: -- Build up the Where clause
434:
435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
440:
441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,

Line 438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

434:
435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
440:
441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,
442: XNP_SV_SMS_V.PORTING_ID,

Line 439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
440:
441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,
442: XNP_SV_SMS_V.PORTING_ID,
443: XNP_SV_SMS_V.SUBSCRIPTION_TN,

Line 441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,

437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
440:
441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,
442: XNP_SV_SMS_V.PORTING_ID,
443: XNP_SV_SMS_V.SUBSCRIPTION_TN,
444: XNP_SV_SMS_V.ROUTING_NUMBER
445: FROM XNP_SV_SMS_V XNP_SV_SMS_V';

Line 442: XNP_SV_SMS_V.PORTING_ID,

438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
440:
441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,
442: XNP_SV_SMS_V.PORTING_ID,
443: XNP_SV_SMS_V.SUBSCRIPTION_TN,
444: XNP_SV_SMS_V.ROUTING_NUMBER
445: FROM XNP_SV_SMS_V XNP_SV_SMS_V';
446:

Line 443: XNP_SV_SMS_V.SUBSCRIPTION_TN,

439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
440:
441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,
442: XNP_SV_SMS_V.PORTING_ID,
443: XNP_SV_SMS_V.SUBSCRIPTION_TN,
444: XNP_SV_SMS_V.ROUTING_NUMBER
445: FROM XNP_SV_SMS_V XNP_SV_SMS_V';
446:
447: ZONE_SQL := ZONE_SQL || I_WHERE;

Line 444: XNP_SV_SMS_V.ROUTING_NUMBER

440:
441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,
442: XNP_SV_SMS_V.PORTING_ID,
443: XNP_SV_SMS_V.SUBSCRIPTION_TN,
444: XNP_SV_SMS_V.ROUTING_NUMBER
445: FROM XNP_SV_SMS_V XNP_SV_SMS_V';
446:
447: ZONE_SQL := ZONE_SQL || I_WHERE;
448: ZONE_SQL := ZONE_SQL || ' ORDER BY XNP_SV_SMS_V.PORTING_ID Desc ';

Line 445: FROM XNP_SV_SMS_V XNP_SV_SMS_V';

441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,
442: XNP_SV_SMS_V.PORTING_ID,
443: XNP_SV_SMS_V.SUBSCRIPTION_TN,
444: XNP_SV_SMS_V.ROUTING_NUMBER
445: FROM XNP_SV_SMS_V XNP_SV_SMS_V';
446:
447: ZONE_SQL := ZONE_SQL || I_WHERE;
448: ZONE_SQL := ZONE_SQL || ' ORDER BY XNP_SV_SMS_V.PORTING_ID Desc ';
449: return true;

Line 448: ZONE_SQL := ZONE_SQL || ' ORDER BY XNP_SV_SMS_V.PORTING_ID Desc ';

444: XNP_SV_SMS_V.ROUTING_NUMBER
445: FROM XNP_SV_SMS_V XNP_SV_SMS_V';
446:
447: ZONE_SQL := ZONE_SQL || I_WHERE;
448: ZONE_SQL := ZONE_SQL || ' ORDER BY XNP_SV_SMS_V.PORTING_ID Desc ';
449: return true;
450:
451: exception
452: when others then

Line 801: SELECT XNP_SV_SMS_V.SV_SMS_ID,

797: null;
798:
799: else
800:
801: SELECT XNP_SV_SMS_V.SV_SMS_ID,
802: XNP_SV_SMS_V.PORTING_ID,
803: XNP_SV_SMS_V.ROUTING_NUMBER_ID,
804: XNP_SV_SMS_V.SUBSCRIPTION_TYPE,
805: XNP_SV_SMS_V.SUBSCRIPTION_TN,

Line 802: XNP_SV_SMS_V.PORTING_ID,

798:
799: else
800:
801: SELECT XNP_SV_SMS_V.SV_SMS_ID,
802: XNP_SV_SMS_V.PORTING_ID,
803: XNP_SV_SMS_V.ROUTING_NUMBER_ID,
804: XNP_SV_SMS_V.SUBSCRIPTION_TYPE,
805: XNP_SV_SMS_V.SUBSCRIPTION_TN,
806: XNP_SV_SMS_V.MEDIATOR_SP_ID,

Line 803: XNP_SV_SMS_V.ROUTING_NUMBER_ID,

799: else
800:
801: SELECT XNP_SV_SMS_V.SV_SMS_ID,
802: XNP_SV_SMS_V.PORTING_ID,
803: XNP_SV_SMS_V.ROUTING_NUMBER_ID,
804: XNP_SV_SMS_V.SUBSCRIPTION_TYPE,
805: XNP_SV_SMS_V.SUBSCRIPTION_TN,
806: XNP_SV_SMS_V.MEDIATOR_SP_ID,
807: XNP_SV_SMS_V.ROUTING_NUMBER,

Line 804: XNP_SV_SMS_V.SUBSCRIPTION_TYPE,

800:
801: SELECT XNP_SV_SMS_V.SV_SMS_ID,
802: XNP_SV_SMS_V.PORTING_ID,
803: XNP_SV_SMS_V.ROUTING_NUMBER_ID,
804: XNP_SV_SMS_V.SUBSCRIPTION_TYPE,
805: XNP_SV_SMS_V.SUBSCRIPTION_TN,
806: XNP_SV_SMS_V.MEDIATOR_SP_ID,
807: XNP_SV_SMS_V.ROUTING_NUMBER,
808: XNP_SV_SMS_V.PROVISION_SENT_DATE,

Line 805: XNP_SV_SMS_V.SUBSCRIPTION_TN,

801: SELECT XNP_SV_SMS_V.SV_SMS_ID,
802: XNP_SV_SMS_V.PORTING_ID,
803: XNP_SV_SMS_V.ROUTING_NUMBER_ID,
804: XNP_SV_SMS_V.SUBSCRIPTION_TYPE,
805: XNP_SV_SMS_V.SUBSCRIPTION_TN,
806: XNP_SV_SMS_V.MEDIATOR_SP_ID,
807: XNP_SV_SMS_V.ROUTING_NUMBER,
808: XNP_SV_SMS_V.PROVISION_SENT_DATE,
809: XNP_SV_SMS_V.CNAM_ADDRESS,

Line 806: XNP_SV_SMS_V.MEDIATOR_SP_ID,

802: XNP_SV_SMS_V.PORTING_ID,
803: XNP_SV_SMS_V.ROUTING_NUMBER_ID,
804: XNP_SV_SMS_V.SUBSCRIPTION_TYPE,
805: XNP_SV_SMS_V.SUBSCRIPTION_TN,
806: XNP_SV_SMS_V.MEDIATOR_SP_ID,
807: XNP_SV_SMS_V.ROUTING_NUMBER,
808: XNP_SV_SMS_V.PROVISION_SENT_DATE,
809: XNP_SV_SMS_V.CNAM_ADDRESS,
810: XNP_SV_SMS_V.CNAM_SUBSYSTEM,

Line 807: XNP_SV_SMS_V.ROUTING_NUMBER,

803: XNP_SV_SMS_V.ROUTING_NUMBER_ID,
804: XNP_SV_SMS_V.SUBSCRIPTION_TYPE,
805: XNP_SV_SMS_V.SUBSCRIPTION_TN,
806: XNP_SV_SMS_V.MEDIATOR_SP_ID,
807: XNP_SV_SMS_V.ROUTING_NUMBER,
808: XNP_SV_SMS_V.PROVISION_SENT_DATE,
809: XNP_SV_SMS_V.CNAM_ADDRESS,
810: XNP_SV_SMS_V.CNAM_SUBSYSTEM,
811: XNP_SV_SMS_V.ISVM_ADDRESS,

Line 808: XNP_SV_SMS_V.PROVISION_SENT_DATE,

804: XNP_SV_SMS_V.SUBSCRIPTION_TYPE,
805: XNP_SV_SMS_V.SUBSCRIPTION_TN,
806: XNP_SV_SMS_V.MEDIATOR_SP_ID,
807: XNP_SV_SMS_V.ROUTING_NUMBER,
808: XNP_SV_SMS_V.PROVISION_SENT_DATE,
809: XNP_SV_SMS_V.CNAM_ADDRESS,
810: XNP_SV_SMS_V.CNAM_SUBSYSTEM,
811: XNP_SV_SMS_V.ISVM_ADDRESS,
812: XNP_SV_SMS_V.ISVM_SUBSYSTEM,

Line 809: XNP_SV_SMS_V.CNAM_ADDRESS,

805: XNP_SV_SMS_V.SUBSCRIPTION_TN,
806: XNP_SV_SMS_V.MEDIATOR_SP_ID,
807: XNP_SV_SMS_V.ROUTING_NUMBER,
808: XNP_SV_SMS_V.PROVISION_SENT_DATE,
809: XNP_SV_SMS_V.CNAM_ADDRESS,
810: XNP_SV_SMS_V.CNAM_SUBSYSTEM,
811: XNP_SV_SMS_V.ISVM_ADDRESS,
812: XNP_SV_SMS_V.ISVM_SUBSYSTEM,
813: XNP_SV_SMS_V.LIDB_ADDRESS,

Line 810: XNP_SV_SMS_V.CNAM_SUBSYSTEM,

806: XNP_SV_SMS_V.MEDIATOR_SP_ID,
807: XNP_SV_SMS_V.ROUTING_NUMBER,
808: XNP_SV_SMS_V.PROVISION_SENT_DATE,
809: XNP_SV_SMS_V.CNAM_ADDRESS,
810: XNP_SV_SMS_V.CNAM_SUBSYSTEM,
811: XNP_SV_SMS_V.ISVM_ADDRESS,
812: XNP_SV_SMS_V.ISVM_SUBSYSTEM,
813: XNP_SV_SMS_V.LIDB_ADDRESS,
814: XNP_SV_SMS_V.LIDB_SUBSYSTEM,

Line 811: XNP_SV_SMS_V.ISVM_ADDRESS,

807: XNP_SV_SMS_V.ROUTING_NUMBER,
808: XNP_SV_SMS_V.PROVISION_SENT_DATE,
809: XNP_SV_SMS_V.CNAM_ADDRESS,
810: XNP_SV_SMS_V.CNAM_SUBSYSTEM,
811: XNP_SV_SMS_V.ISVM_ADDRESS,
812: XNP_SV_SMS_V.ISVM_SUBSYSTEM,
813: XNP_SV_SMS_V.LIDB_ADDRESS,
814: XNP_SV_SMS_V.LIDB_SUBSYSTEM,
815: XNP_SV_SMS_V.CLASS_ADDRESS,

Line 812: XNP_SV_SMS_V.ISVM_SUBSYSTEM,

808: XNP_SV_SMS_V.PROVISION_SENT_DATE,
809: XNP_SV_SMS_V.CNAM_ADDRESS,
810: XNP_SV_SMS_V.CNAM_SUBSYSTEM,
811: XNP_SV_SMS_V.ISVM_ADDRESS,
812: XNP_SV_SMS_V.ISVM_SUBSYSTEM,
813: XNP_SV_SMS_V.LIDB_ADDRESS,
814: XNP_SV_SMS_V.LIDB_SUBSYSTEM,
815: XNP_SV_SMS_V.CLASS_ADDRESS,
816: XNP_SV_SMS_V.CLASS_SUBSYSTEM,

Line 813: XNP_SV_SMS_V.LIDB_ADDRESS,

809: XNP_SV_SMS_V.CNAM_ADDRESS,
810: XNP_SV_SMS_V.CNAM_SUBSYSTEM,
811: XNP_SV_SMS_V.ISVM_ADDRESS,
812: XNP_SV_SMS_V.ISVM_SUBSYSTEM,
813: XNP_SV_SMS_V.LIDB_ADDRESS,
814: XNP_SV_SMS_V.LIDB_SUBSYSTEM,
815: XNP_SV_SMS_V.CLASS_ADDRESS,
816: XNP_SV_SMS_V.CLASS_SUBSYSTEM,
817: XNP_SV_SMS_V.WSMSC_ADDRESS,

Line 814: XNP_SV_SMS_V.LIDB_SUBSYSTEM,

810: XNP_SV_SMS_V.CNAM_SUBSYSTEM,
811: XNP_SV_SMS_V.ISVM_ADDRESS,
812: XNP_SV_SMS_V.ISVM_SUBSYSTEM,
813: XNP_SV_SMS_V.LIDB_ADDRESS,
814: XNP_SV_SMS_V.LIDB_SUBSYSTEM,
815: XNP_SV_SMS_V.CLASS_ADDRESS,
816: XNP_SV_SMS_V.CLASS_SUBSYSTEM,
817: XNP_SV_SMS_V.WSMSC_ADDRESS,
818: XNP_SV_SMS_V.WSMSC_SUBSYSTEM,

Line 815: XNP_SV_SMS_V.CLASS_ADDRESS,

811: XNP_SV_SMS_V.ISVM_ADDRESS,
812: XNP_SV_SMS_V.ISVM_SUBSYSTEM,
813: XNP_SV_SMS_V.LIDB_ADDRESS,
814: XNP_SV_SMS_V.LIDB_SUBSYSTEM,
815: XNP_SV_SMS_V.CLASS_ADDRESS,
816: XNP_SV_SMS_V.CLASS_SUBSYSTEM,
817: XNP_SV_SMS_V.WSMSC_ADDRESS,
818: XNP_SV_SMS_V.WSMSC_SUBSYSTEM,
819: XNP_SV_SMS_V.RN_ADDRESS,

Line 816: XNP_SV_SMS_V.CLASS_SUBSYSTEM,

812: XNP_SV_SMS_V.ISVM_SUBSYSTEM,
813: XNP_SV_SMS_V.LIDB_ADDRESS,
814: XNP_SV_SMS_V.LIDB_SUBSYSTEM,
815: XNP_SV_SMS_V.CLASS_ADDRESS,
816: XNP_SV_SMS_V.CLASS_SUBSYSTEM,
817: XNP_SV_SMS_V.WSMSC_ADDRESS,
818: XNP_SV_SMS_V.WSMSC_SUBSYSTEM,
819: XNP_SV_SMS_V.RN_ADDRESS,
820: XNP_SV_SMS_V.RN_SUBSYSTEM,

Line 817: XNP_SV_SMS_V.WSMSC_ADDRESS,

813: XNP_SV_SMS_V.LIDB_ADDRESS,
814: XNP_SV_SMS_V.LIDB_SUBSYSTEM,
815: XNP_SV_SMS_V.CLASS_ADDRESS,
816: XNP_SV_SMS_V.CLASS_SUBSYSTEM,
817: XNP_SV_SMS_V.WSMSC_ADDRESS,
818: XNP_SV_SMS_V.WSMSC_SUBSYSTEM,
819: XNP_SV_SMS_V.RN_ADDRESS,
820: XNP_SV_SMS_V.RN_SUBSYSTEM,
821: XNP_SV_SMS_V.PROVISION_DONE_DATE,

Line 818: XNP_SV_SMS_V.WSMSC_SUBSYSTEM,

814: XNP_SV_SMS_V.LIDB_SUBSYSTEM,
815: XNP_SV_SMS_V.CLASS_ADDRESS,
816: XNP_SV_SMS_V.CLASS_SUBSYSTEM,
817: XNP_SV_SMS_V.WSMSC_ADDRESS,
818: XNP_SV_SMS_V.WSMSC_SUBSYSTEM,
819: XNP_SV_SMS_V.RN_ADDRESS,
820: XNP_SV_SMS_V.RN_SUBSYSTEM,
821: XNP_SV_SMS_V.PROVISION_DONE_DATE,
822: XNP_SV_SMS_V.NRC_CODE,

Line 819: XNP_SV_SMS_V.RN_ADDRESS,

815: XNP_SV_SMS_V.CLASS_ADDRESS,
816: XNP_SV_SMS_V.CLASS_SUBSYSTEM,
817: XNP_SV_SMS_V.WSMSC_ADDRESS,
818: XNP_SV_SMS_V.WSMSC_SUBSYSTEM,
819: XNP_SV_SMS_V.RN_ADDRESS,
820: XNP_SV_SMS_V.RN_SUBSYSTEM,
821: XNP_SV_SMS_V.PROVISION_DONE_DATE,
822: XNP_SV_SMS_V.NRC_CODE,
823: XNP_SV_SMS_V.NRC_NAME,

Line 820: XNP_SV_SMS_V.RN_SUBSYSTEM,

816: XNP_SV_SMS_V.CLASS_SUBSYSTEM,
817: XNP_SV_SMS_V.WSMSC_ADDRESS,
818: XNP_SV_SMS_V.WSMSC_SUBSYSTEM,
819: XNP_SV_SMS_V.RN_ADDRESS,
820: XNP_SV_SMS_V.RN_SUBSYSTEM,
821: XNP_SV_SMS_V.PROVISION_DONE_DATE,
822: XNP_SV_SMS_V.NRC_CODE,
823: XNP_SV_SMS_V.NRC_NAME,
824: XNP_SV_SMS_V.NRC_INTERNET,

Line 821: XNP_SV_SMS_V.PROVISION_DONE_DATE,

817: XNP_SV_SMS_V.WSMSC_ADDRESS,
818: XNP_SV_SMS_V.WSMSC_SUBSYSTEM,
819: XNP_SV_SMS_V.RN_ADDRESS,
820: XNP_SV_SMS_V.RN_SUBSYSTEM,
821: XNP_SV_SMS_V.PROVISION_DONE_DATE,
822: XNP_SV_SMS_V.NRC_CODE,
823: XNP_SV_SMS_V.NRC_NAME,
824: XNP_SV_SMS_V.NRC_INTERNET,
825: XNP_SV_SMS_V.ROUTING_REF,

Line 822: XNP_SV_SMS_V.NRC_CODE,

818: XNP_SV_SMS_V.WSMSC_SUBSYSTEM,
819: XNP_SV_SMS_V.RN_ADDRESS,
820: XNP_SV_SMS_V.RN_SUBSYSTEM,
821: XNP_SV_SMS_V.PROVISION_DONE_DATE,
822: XNP_SV_SMS_V.NRC_CODE,
823: XNP_SV_SMS_V.NRC_NAME,
824: XNP_SV_SMS_V.NRC_INTERNET,
825: XNP_SV_SMS_V.ROUTING_REF,
826: XNP_SV_SMS_V.ROUTING_SP_ID,

Line 823: XNP_SV_SMS_V.NRC_NAME,

819: XNP_SV_SMS_V.RN_ADDRESS,
820: XNP_SV_SMS_V.RN_SUBSYSTEM,
821: XNP_SV_SMS_V.PROVISION_DONE_DATE,
822: XNP_SV_SMS_V.NRC_CODE,
823: XNP_SV_SMS_V.NRC_NAME,
824: XNP_SV_SMS_V.NRC_INTERNET,
825: XNP_SV_SMS_V.ROUTING_REF,
826: XNP_SV_SMS_V.ROUTING_SP_ID,
827: XNP_SV_SMS_V.REC_SP_ID,

Line 824: XNP_SV_SMS_V.NRC_INTERNET,

820: XNP_SV_SMS_V.RN_SUBSYSTEM,
821: XNP_SV_SMS_V.PROVISION_DONE_DATE,
822: XNP_SV_SMS_V.NRC_CODE,
823: XNP_SV_SMS_V.NRC_NAME,
824: XNP_SV_SMS_V.NRC_INTERNET,
825: XNP_SV_SMS_V.ROUTING_REF,
826: XNP_SV_SMS_V.ROUTING_SP_ID,
827: XNP_SV_SMS_V.REC_SP_ID,
828: XNP_SV_SMS_V.REC_CODE,

Line 825: XNP_SV_SMS_V.ROUTING_REF,

821: XNP_SV_SMS_V.PROVISION_DONE_DATE,
822: XNP_SV_SMS_V.NRC_CODE,
823: XNP_SV_SMS_V.NRC_NAME,
824: XNP_SV_SMS_V.NRC_INTERNET,
825: XNP_SV_SMS_V.ROUTING_REF,
826: XNP_SV_SMS_V.ROUTING_SP_ID,
827: XNP_SV_SMS_V.REC_SP_ID,
828: XNP_SV_SMS_V.REC_CODE,
829: XNP_SV_SMS_V.REC_NAME,

Line 826: XNP_SV_SMS_V.ROUTING_SP_ID,

822: XNP_SV_SMS_V.NRC_CODE,
823: XNP_SV_SMS_V.NRC_NAME,
824: XNP_SV_SMS_V.NRC_INTERNET,
825: XNP_SV_SMS_V.ROUTING_REF,
826: XNP_SV_SMS_V.ROUTING_SP_ID,
827: XNP_SV_SMS_V.REC_SP_ID,
828: XNP_SV_SMS_V.REC_CODE,
829: XNP_SV_SMS_V.REC_NAME,
830: XNP_SV_SMS_V.REC_INTERNET,

Line 827: XNP_SV_SMS_V.REC_SP_ID,

823: XNP_SV_SMS_V.NRC_NAME,
824: XNP_SV_SMS_V.NRC_INTERNET,
825: XNP_SV_SMS_V.ROUTING_REF,
826: XNP_SV_SMS_V.ROUTING_SP_ID,
827: XNP_SV_SMS_V.REC_SP_ID,
828: XNP_SV_SMS_V.REC_CODE,
829: XNP_SV_SMS_V.REC_NAME,
830: XNP_SV_SMS_V.REC_INTERNET,
831: XNP_SV_SMS_V.REC_EMAIL,

Line 828: XNP_SV_SMS_V.REC_CODE,

824: XNP_SV_SMS_V.NRC_INTERNET,
825: XNP_SV_SMS_V.ROUTING_REF,
826: XNP_SV_SMS_V.ROUTING_SP_ID,
827: XNP_SV_SMS_V.REC_SP_ID,
828: XNP_SV_SMS_V.REC_CODE,
829: XNP_SV_SMS_V.REC_NAME,
830: XNP_SV_SMS_V.REC_INTERNET,
831: XNP_SV_SMS_V.REC_EMAIL,
832: XNP_SV_SMS_V.NRC_EMAIL,

Line 829: XNP_SV_SMS_V.REC_NAME,

825: XNP_SV_SMS_V.ROUTING_REF,
826: XNP_SV_SMS_V.ROUTING_SP_ID,
827: XNP_SV_SMS_V.REC_SP_ID,
828: XNP_SV_SMS_V.REC_CODE,
829: XNP_SV_SMS_V.REC_NAME,
830: XNP_SV_SMS_V.REC_INTERNET,
831: XNP_SV_SMS_V.REC_EMAIL,
832: XNP_SV_SMS_V.NRC_EMAIL,
833: XNP_SV_SMS_V.INTERCONNECT_TYPE

Line 830: XNP_SV_SMS_V.REC_INTERNET,

826: XNP_SV_SMS_V.ROUTING_SP_ID,
827: XNP_SV_SMS_V.REC_SP_ID,
828: XNP_SV_SMS_V.REC_CODE,
829: XNP_SV_SMS_V.REC_NAME,
830: XNP_SV_SMS_V.REC_INTERNET,
831: XNP_SV_SMS_V.REC_EMAIL,
832: XNP_SV_SMS_V.NRC_EMAIL,
833: XNP_SV_SMS_V.INTERCONNECT_TYPE
834: INTO CURR_VAL.SV_SMS_ID,

Line 831: XNP_SV_SMS_V.REC_EMAIL,

827: XNP_SV_SMS_V.REC_SP_ID,
828: XNP_SV_SMS_V.REC_CODE,
829: XNP_SV_SMS_V.REC_NAME,
830: XNP_SV_SMS_V.REC_INTERNET,
831: XNP_SV_SMS_V.REC_EMAIL,
832: XNP_SV_SMS_V.NRC_EMAIL,
833: XNP_SV_SMS_V.INTERCONNECT_TYPE
834: INTO CURR_VAL.SV_SMS_ID,
835: CURR_VAL.PORTING_ID,

Line 832: XNP_SV_SMS_V.NRC_EMAIL,

828: XNP_SV_SMS_V.REC_CODE,
829: XNP_SV_SMS_V.REC_NAME,
830: XNP_SV_SMS_V.REC_INTERNET,
831: XNP_SV_SMS_V.REC_EMAIL,
832: XNP_SV_SMS_V.NRC_EMAIL,
833: XNP_SV_SMS_V.INTERCONNECT_TYPE
834: INTO CURR_VAL.SV_SMS_ID,
835: CURR_VAL.PORTING_ID,
836: CURR_VAL.ROUTING_NUMBER_ID,

Line 833: XNP_SV_SMS_V.INTERCONNECT_TYPE

829: XNP_SV_SMS_V.REC_NAME,
830: XNP_SV_SMS_V.REC_INTERNET,
831: XNP_SV_SMS_V.REC_EMAIL,
832: XNP_SV_SMS_V.NRC_EMAIL,
833: XNP_SV_SMS_V.INTERCONNECT_TYPE
834: INTO CURR_VAL.SV_SMS_ID,
835: CURR_VAL.PORTING_ID,
836: CURR_VAL.ROUTING_NUMBER_ID,
837: CURR_VAL.SUBSCRIPTION_TYPE,

Line 867: FROM XNP_SV_SMS_V XNP_SV_SMS_V

863: CURR_VAL.REC_INTERNET,
864: CURR_VAL.REC_EMAIL,
865: CURR_VAL.NRC_EMAIL,
866: CURR_VAL.INTERCONNECT_TYPE
867: FROM XNP_SV_SMS_V XNP_SV_SMS_V
868: WHERE XNP_SV_SMS_V.SV_SMS_ID = CURR_VAL.SV_SMS_ID
869: ;
870:
871: end if;

Line 868: WHERE XNP_SV_SMS_V.SV_SMS_ID = CURR_VAL.SV_SMS_ID

864: CURR_VAL.REC_EMAIL,
865: CURR_VAL.NRC_EMAIL,
866: CURR_VAL.INTERCONNECT_TYPE
867: FROM XNP_SV_SMS_V XNP_SV_SMS_V
868: WHERE XNP_SV_SMS_V.SV_SMS_ID = CURR_VAL.SV_SMS_ID
869: ;
870:
871: end if;
872: