APPS.IEM_TAG_KEY_PVT dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 14: -- Liang Xia 12/04/2004 changed to iem_mstemail_accounts for 115.11 schema compliance

10: -- Liang Xia 3/20/2002 Created
11: -- Liang Xia 5/14/2002 added more validation on Key ID
12: -- Liang Xia 12/05/2002 Fixed plsql GSCC warning: NOCOPY, No G_MISS..
13: -- Liang Xia 01/21/2003 Adding additional check to email processing rule when deleting tag
14: -- Liang Xia 12/04/2004 changed to iem_mstemail_accounts for 115.11 schema compliance
15: -- --------- ------ ------------------------------------------
16:
17: -- Enter procedure, function bodies as shown below
18: G_PKG_NAME CONSTANT varchar2(30) :='IEM_TAG_KEY_PVT ';

Line 178: p_email_acct_id IN iem_mstemail_accounts.email_account_id%type,

174: PROCEDURE delete_acct_tag_on_acct_ID
175: (p_api_version_number IN NUMBER,
176: P_init_msg_list IN VARCHAR2 := null,
177: p_commit IN VARCHAR2 := null,
178: p_email_acct_id IN iem_mstemail_accounts.email_account_id%type,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2)
182: IS

Line 623: select count(*) into l_count from iem_mstemail_accounts where email_account_id = p_email_account_id;

619: raise IEM_TAG_KEY_ID_NOT_EXIST;
620: end if;
621:
622: --valid account_id
623: select count(*) into l_count from iem_mstemail_accounts where email_account_id = p_email_account_id;
624: if l_count < 1 then
625: raise IEM_TAG_ACCT_ID_NOT_EXIST;
626: end if;
627: