87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: SELECT DB_SERVER_ID,EMAIL_USER,DOMAIN,EMAIL_PASSWORD
90: INTO l_db_server_id,l_user,l_domain,l_pass
91: FROM IEM_EMAIL_ACCOUNTS
92: WHERE EMAIL_ACCOUNT_ID=p_email_account_id;
93:
94: IEM_DB_CONNECTIONS_PVT.select_item(
95: p_api_version_number =>1.0,
230: x_return_status := FND_API.G_RET_STS_SUCCESS;
231:
232: SELECT DB_SERVER_ID,EMAIL_USER,DOMAIN,EMAIL_PASSWORD
233: INTO l_db_server_id,l_user,l_domain,l_pass
234: FROM IEM_EMAIL_ACCOUNTS
235: WHERE EMAIL_ACCOUNT_ID=p_email_account_id;
236:
237: IEM_DB_CONNECTIONS_PVT.select_item(
238: p_api_version_number =>1.0,