65: -- Initialize API return status to SUCCESS
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: SELECT IEM_KB_RESULTS_s1.nextval
68: INTO l_seq_id 69: FROM dual; 70:
71: Select count(*) into l_grp_cnt from iem_mstemail_accounts
72: where email_account_id=p_email_account_id
73: and rownum=1;