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_CORE dependencies on XNP_SV_SMS

Line 626: FROM xnp_sv_sms

622: )
623: IS
624: CURSOR c_sms_id IS
625: SELECT sv_sms_id
626: FROM xnp_sv_sms
627: WHERE subscription_tn = p_subscription_tn ;
628:
629: BEGIN
630:

Line 715: FROM xnp_sv_sms

711: l_sv_sms_id NUMBER := null;
712:
713: CURSOR c_check_sms_sv_exists (l_ph_no IN VARCHAR2) IS
714: SELECT sv_sms_id
715: FROM xnp_sv_sms
716: WHERE subscription_tn = l_ph_no
717: AND subscription_type = p_subscription_type;
718:
719: BEGIN

Line 736: -- Insert a row into XNP_SV_SMS for each TN in the range

732: IF x_error_code <> 0 THEN
733: RETURN;
734: END IF;
735:
736: -- Insert a row into XNP_SV_SMS for each TN in the range
737: FOR l_counter IN 0..l_diff
738: LOOP
739:
740: l_sv_sms_id := NULL;

Line 748: SELECT xnp_sv_sms_s.nextval

744:
745: IF c_check_sms_sv_exists%NOTFOUND THEN
746:
747: /**
748: SELECT xnp_sv_sms_s.nextval
749: INTO l_sv_sms_id
750: FROM dual;
751: **/
752:

Line 753: INSERT into xnp_sv_sms

749: INTO l_sv_sms_id
750: FROM dual;
751: **/
752:
753: INSERT into xnp_sv_sms
754: (sv_sms_id ,
755: object_reference ,
756: routing_number_id ,
757: subscription_tn ,

Line 779: (xnp_sv_sms_s.nextval ,

775: last_updated_by ,
776: last_update_date
777: )
778: VALUES
779: (xnp_sv_sms_s.nextval ,
780: p_porting_id ,
781: p_routing_number_id ,
782: to_char((l_init+l_counter)) ,
783: p_subscription_type ,

Line 806: UPDATE xnp_sv_sms

802: sysdate
803: ) RETURNING sv_sms_id INTO l_sv_sms_id ;
804:
805: ELSE
806: UPDATE xnp_sv_sms
807: SET object_reference = p_porting_id
808: ,provision_sent_date = p_porting_time
809: ,routing_number_id = p_routing_number_id
810: ,cnam_address = p_cnam_address

Line 2398: FROM xnp_sv_sms_fe_maps

2394: l_sms_fe_map_id NUMBER := null;
2395:
2396: CURSOR c_CHECK_IF_MAP_EXISTS (l_cur_sv_id IN NUMBER) IS
2397: SELECT sms_fe_map_id
2398: FROM xnp_sv_sms_fe_maps
2399: WHERE sv_sms_id = l_cur_sv_id
2400: AND fe_id = p_fe_id
2401: AND feature_type = p_feature_type;
2402:

Line 2447: SELECT xnp_sv_sms_fe_maps_s.nextval

2443: FETCH c_CHECK_IF_MAP_EXISTS INTO l_sms_fe_map_id;
2444:
2445: IF c_CHECK_IF_MAP_EXISTS%NOTFOUND THEN
2446: /***
2447: SELECT xnp_sv_sms_fe_maps_s.nextval
2448: INTO l_sms_fe_map_id
2449: FROM dual;
2450: ***/
2451:

Line 2452: INSERT INTO xnp_sv_sms_fe_maps

2448: INTO l_sms_fe_map_id
2449: FROM dual;
2450: ***/
2451:
2452: INSERT INTO xnp_sv_sms_fe_maps
2453: (SMS_FE_MAP_ID
2454: ,SV_SMS_ID
2455: ,FE_ID
2456: ,FEATURE_TYPE

Line 2464: xnp_sv_sms_fe_maps_s.nextval

2460: ,LAST_UPDATED_BY
2461: ,LAST_UPDATE_DATE
2462: )
2463: VALUES (
2464: xnp_sv_sms_fe_maps_s.nextval
2465: ,l_SV_ID
2466: ,p_FE_ID
2467: ,p_FEATURE_TYPE
2468: ,'NOT_PROVISIONED'

Line 2477: UPDATE xnp_sv_sms_fe_maps

2473: );
2474:
2475: ELSE
2476:
2477: UPDATE xnp_sv_sms_fe_maps
2478: SET provision_status = 'NOT_PROVISIONED' ,
2479: last_updated_by = fnd_global.user_id ,
2480: last_update_date = sysdate
2481: WHERE sms_fe_map_id = l_sms_fe_map_id;

Line 2706: FROM xnp_sv_sms_fe_maps

2702: l_starting_number := to_char(to_number(p_starting_number));
2703: l_ending_number := to_char(to_number(p_ending_number));
2704:
2705: DELETE
2706: FROM xnp_sv_sms_fe_maps
2707: WHERE fe_id = p_fe_id
2708: AND feature_type = p_feature_type
2709: AND sv_sms_id IN
2710: (SELECT sv_sms_id

Line 2711: FROM xnp_sv_sms

2707: WHERE fe_id = p_fe_id
2708: AND feature_type = p_feature_type
2709: AND sv_sms_id IN
2710: (SELECT sv_sms_id
2711: FROM xnp_sv_sms
2712: WHERE subscription_tn BETWEEN l_starting_number AND l_ending_number) ;
2713:
2714: EXCEPTION
2715: WHEN OTHERS THEN

Line 3109: FROM xnp_sv_sms_fe_maps

3105: l_ENDING_NUMBER VARCHAR2(80) := null;
3106:
3107: CURSOR c_sv_map_id is
3108: SELECT sms_fe_map_id
3109: FROM xnp_sv_sms_fe_maps
3110: WHERE sv_sms_id in
3111: (SELECT sv_sms_id
3112: FROM xnp_sv_sms
3113: WHERE subscription_tn BETWEEN l_starting_number AND l_ending_number

Line 3112: FROM xnp_sv_sms

3108: SELECT sms_fe_map_id
3109: FROM xnp_sv_sms_fe_maps
3110: WHERE sv_sms_id in
3111: (SELECT sv_sms_id
3112: FROM xnp_sv_sms
3113: WHERE subscription_tn BETWEEN l_starting_number AND l_ending_number
3114: );
3115:
3116: BEGIN

Line 3135: FROM xnp_sv_sms

3131: DELETE
3132: FROM xnp_sv_order_mappings
3133: WHERE sv_sms_id IN
3134: (SELECT sv_sms_id
3135: FROM xnp_sv_sms
3136: WHERE subscription_tn BETWEEN l_starting_number
3137: AND l_ending_number);
3138:
3139: DELETE

Line 3140: FROM xnp_sv_sms

3136: WHERE subscription_tn BETWEEN l_starting_number
3137: AND l_ending_number);
3138:
3139: DELETE
3140: FROM xnp_sv_sms
3141: WHERE subscription_tn BETWEEN l_starting_number
3142: AND l_ending_number ;
3143:
3144: END IF;

Line 3202: FROM xnp_sv_sms sms

3198: l_ending_number := p_ending_number;
3199:
3200: SELECT sv_sms_id BULK COLLECT
3201: INTO l_sv_sms_id
3202: FROM xnp_sv_sms sms
3203: WHERE subscription_tn BETWEEN l_starting_number AND l_ending_number ;
3204:
3205: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
3206:

Line 3207: UPDATE xnp_sv_sms_fe_maps

3203: WHERE subscription_tn BETWEEN l_starting_number AND l_ending_number ;
3204:
3205: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
3206:
3207: UPDATE xnp_sv_sms_fe_maps
3208: SET provision_status = p_prov_status ,
3209: last_updated_by = fnd_global.user_id ,
3210: last_update_date = sysdate
3211: WHERE sv_sms_id = l_sv_sms_id(i)

Line 3586: FROM xnp_sv_sms sms

3582:
3583:
3584: SELECT sv_sms_id BULK COLLECT
3585: INTO l_sv_sms_id
3586: FROM xnp_sv_sms sms
3587: WHERE object_reference = p_porting_id ;
3588:
3589: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
3590:

Line 3591: UPDATE XNP_SV_SMS SMS

3587: WHERE object_reference = p_porting_id ;
3588:
3589: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
3590:
3591: UPDATE XNP_SV_SMS SMS
3592: SET SMS.PROVISION_SENT_DATE = P_PORTING_TIME ,
3593: SMS.ROUTING_NUMBER_ID = p_ROUTING_NUMBER_ID ,
3594: SMS.CNAM_ADDRESS = p_CNAM_ADDRESS ,
3595: SMS.CNAM_SUBSYSTEM = p_CNAM_SUBSYSTEM ,

Line 4475: FROM xnp_sv_sms

4471: l_ending_number := p_ending_number;
4472:
4473: SELECT sv_sms_id BULK COLLECT
4474: INTO l_sv_sms_id
4475: FROM xnp_sv_sms
4476: WHERE subscription_tn BETWEEN l_starting_number AND l_ending_number;
4477:
4478: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
4479:

Line 4480: UPDATE xnp_sv_sms_fe_maps

4476: WHERE subscription_tn BETWEEN l_starting_number AND l_ending_number;
4477:
4478: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
4479:
4480: UPDATE xnp_sv_sms_fe_maps
4481: SET provision_status = p_deprovision_status ,
4482: last_updated_by = fnd_global.user_id ,
4483: last_update_date = sysdate
4484: WHERE feature_type = p_feature_type

Line 5146: xnp_sv_sms sms

5142:
5143: CURSOR c_RN_OWNER IS
5144: SELECT DISTINCT sp_id, rownum
5145: FROM xnp_routing_numbers rn ,
5146: xnp_sv_sms sms
5147: WHERE rn.routing_number_id = sms.routing_number_id
5148: AND sms.subscription_tn BETWEEN l_starting_number AND l_ending_number;
5149:
5150: BEGIN

Line 5711: FROM xnp_sv_sms sms

5707: BEGIN
5708:
5709: SELECT sv_sms_id BULK COLLECT
5710: INTO l_sv_sms_id
5711: FROM xnp_sv_sms sms
5712: WHERE sms.subscription_tn BETWEEN p_starting_number AND p_ending_number ;
5713:
5714: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
5715:

Line 5716: UPDATE xnp_sv_sms sms

5712: WHERE sms.subscription_tn BETWEEN p_starting_number AND p_ending_number ;
5713:
5714: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
5715:
5716: UPDATE xnp_sv_sms sms
5717: SET sms.provision_done_date = sysdate,
5718: sms.last_updated_by = fnd_global.user_id,
5719: sms.last_update_date = sysdate
5720: WHERE sms.sv_sms_id = l_sv_sms_id(i);