APPS.POS_USER_ADMIN_PKG dependencies on POS_SPMNTF_SUBSCRIPTION

Line 1188: from pos_spmntf_subscription

1184: ) IS
1185:
1186: cursor c1 is
1187: select count(*)
1188: from pos_spmntf_subscription
1189: where user_id = p_user_id and
1190: event_type = 'SUPP_BUS_CLASS_RECERT_NTF';
1191:
1192: l_subscr_count number;

Line 1204: insert into pos_spmntf_subscription

1200: fetch c1 into l_subscr_count;
1201: close c1;
1202:
1203: if (l_subscr_count = 0 ) then
1204: insert into pos_spmntf_subscription
1205: (subscription_id,
1206: created_by,
1207: creation_date,
1208: last_updated_by,

Line 1214: (POS_SPMNTF_SUBSCRIPTION_S.nextval,

1210: last_update_login,
1211: event_type,
1212: user_id)
1213: values
1214: (POS_SPMNTF_SUBSCRIPTION_S.nextval,
1215: fnd_global.user_id,
1216: sysdate,
1217: fnd_global.user_id,
1218: sysdate,

Line 1242: from pos_spmntf_subscription

1238: ) IS
1239:
1240: cursor c1 is
1241: select count(*)
1242: from pos_spmntf_subscription
1243: where user_id = p_user_id and
1244: event_type = 'SUPP_BUS_CLASS_RECERT_NTF';
1245:
1246: l_subscr_count number := 0;

Line 1258: delete from pos_spmntf_subscription

1254: close c1;
1255: -- Delete the Notification subscription record
1256:
1257: if (l_subscr_count > 0 ) then
1258: delete from pos_spmntf_subscription
1259: where event_type = 'SUPP_BUS_CLASS_RECERT_NTF'
1260: and user_id = p_user_id;
1261: commit;
1262: x_status := fnd_api.g_ret_sts_success;

Line 1281: from pos_spmntf_subscription

1277: BEGIN
1278:
1279: select 'Y'
1280: into x_subscr_exists
1281: from pos_spmntf_subscription
1282: where event_type = 'SUPP_BUS_CLASS_RECERT_NTF'
1283: and user_id = p_user_id;
1284:
1285: EXCEPTION