APPS.IEM_EMAIL_SERVER_TYPES_PVT dependencies on IEM_EMAIL_SERVERS

Line 187: DELETE FROM IEM_EMAIL_SERVERS

183: END IF;
184: -- Initialize API return status to SUCCESS
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186: if p_server_type_id is null then
187: DELETE FROM IEM_EMAIL_SERVERS
188: WHERE SERVER_TYPE_ID IN
189: (SELECT EMAIL_SERVER_TYPE_ID FROM
190: IEM_EMAIL_SERVER_TYPES
191: WHERE EMAIL_SERVER_TYPE=p_server_type);

Line 195: DELETE FROM IEM_EMAIL_SERVERS

191: WHERE EMAIL_SERVER_TYPE=p_server_type);
192: DELETE FROM IEM_EMAIL_SERVER_TYPES
193: WHERE EMAIL_SERVER_TYPE=p_server_type;
194: else
195: DELETE FROM IEM_EMAIL_SERVERS
196: WHERE SERVER_TYPE_ID=p_server_type_id;
197: DELETE FROM IEM_EMAIL_SERVER_TYPES
198: WHERE EMAIL_SERVER_TYPE_ID=p_server_type_id;
199: end if;