APPS.IEM_EMAIL_SERVERS_PVT dependencies on IEM_EMAIL_SERVER_TYPES

Line 85: Select count(*) into l_type_cnt from iem_email_server_types

81: FROM dual;
82:
83: /* Check For Existing Server Type Id */
84:
85: Select count(*) into l_type_cnt from iem_email_server_types
86: where email_server_type_id=p_server_type_id
87: and rownum=1;
88: IF l_type_cnt=0 THEN
89: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_TYPE');

Line 323: select email_server_type into l_email_server_type from iem_email_server_types where email_server_type_id=p_server_type_id;

319: raise EXCP_EMAIL_SERVER;
320: END IF;
321:
322: -- Update Cache Audit Trail
323: select email_server_type into l_email_server_type from iem_email_server_types where email_server_type_id=p_server_type_id;
324:
325: if (p_ip_address <> FND_API.G_MISS_CHAR) then
326: select email_server_id into l_email_server_id from iem_email_servers
327: where UPPER(dns_name)=UPPER(p_dns_name)

Line 554: Select count(*) into l_type_cnt from iem_email_server_types

550:
551: if p_server_type_id <>FND_API.G_MISS_NUM then
552: -- Check For Existing Server Type Id
553:
554: Select count(*) into l_type_cnt from iem_email_server_types
555: where email_server_type_id=p_server_type_id
556: and rownum=1;
557: IF l_type_cnt=0 THEN
558: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_TYPE');

Line 790: select email_server_type into l_email_server_type from iem_email_server_types where email_server_type_id=p_server_type_id;

786: raise EXCP_EMAIL_SERVER;
787: END IF;
788:
789: -- Update Cache Audit Trail
790: select email_server_type into l_email_server_type from iem_email_server_types where email_server_type_id=p_server_type_id;
791:
792: if p_email_server_id = FND_API.G_MISS_NUM then
793: select email_server_id into l_email_server_id from iem_email_servers
794: where UPPER(dns_name)=UPPER(p_dns_name)

Line 912: select email_server_type into l_email_server_type from iem_email_server_types where email_server_type_id=l_server_type_id;

908:
909: -- Update Cache Audit Trail
910: select server_type_id into l_server_type_id from iem_email_servers WHERE EMAIL_SERVER_ID =l_email_server_id;
911:
912: select email_server_type into l_email_server_type from iem_email_server_types where email_server_type_id=l_server_type_id;
913:
914: IEM_COMP_RT_STATS_PVT.create_item(p_api_version_number =>1.0,
915: p_init_msg_list => FND_API.G_FALSE,
916: p_commit => FND_API.G_FALSE,