APPS.XNP_CORE dependencies on XNP_SV_SMS_FE_MAPS

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