APPS.XNP_CORE dependencies on XNP_SV_SMS_S

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 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 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 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 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);