DBA Data[Home] [Help]

APPS.IEM_EMAIL_SERVERS_PVT dependencies on IEM_EMAIL_SERVERS_S1

Line 79: SELECT iem_email_servers_s1.nextval

75: -- if l_es_count > 0 then
76: -- raise IEM_DUP_EMAIL_SERVER;
77: -- end if;
78:
79: SELECT iem_email_servers_s1.nextval
80: INTO l_seq_id
81: FROM dual;
82:
83: /* Check For Existing Server Type Id */

Line 330: SELECT iem_email_servers_s1.currval

326: select email_server_id into l_email_server_id from iem_email_servers
327: where UPPER(dns_name)=UPPER(p_dns_name)
328: and ip_address=p_ip_address and port=p_port;
329: else
330: SELECT iem_email_servers_s1.currval
331: INTO l_email_server_id
332: FROM dual;
333:
334: end if;