APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on BIX_DM_DNIS

Line 270: select DNIS_ID into l_dnis from bix_dm_dnis where dnis = p_dnis;

266: l_dnis number;
267:
268: BEGIN
269: if p_dnis is not null then
270: select DNIS_ID into l_dnis from bix_dm_dnis where dnis = p_dnis;
271: return l_dnis;
272: else
273: return null;
274: end if;

Line 278: select bix.bix_dm_dnis_s.nextval into l_dnis from dual;

274: end if;
275:
276: EXCEPTION
277: WHEN NO_DATA_FOUND THEN
278: select bix.bix_dm_dnis_s.nextval into l_dnis from dual;
279: insert into bix_dm_dnis (dnis_id,dnis,last_update_date,last_updated_by,
280: creation_date) values (l_dnis,p_dnis,sysdate,g_user_id,
281: sysdate);
282: commit;

Line 279: insert into bix_dm_dnis (dnis_id,dnis,last_update_date,last_updated_by,

275:
276: EXCEPTION
277: WHEN NO_DATA_FOUND THEN
278: select bix.bix_dm_dnis_s.nextval into l_dnis from dual;
279: insert into bix_dm_dnis (dnis_id,dnis,last_update_date,last_updated_by,
280: creation_date) values (l_dnis,p_dnis,sysdate,g_user_id,
281: sysdate);
282: commit;
283: return l_dnis;