APPS.IEM_TAGPROCESS_PUB dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 36: p_email_account_id IN iem_mstemail_accounts.email_account_id%type,

32: PROCEDURE getEncryptId(
33: P_Api_Version_Number IN NUMBER,
34: P_Init_Msg_List IN VARCHAR2 := null,
35: P_Commit IN VARCHAR2 := null,
36: p_email_account_id IN iem_mstemail_accounts.email_account_id%type,
37: p_agent_id IN NUMBER,
38: p_interaction_id IN NUMBER,
39: p_biz_keyVal_tab IN keyVals_tbl_type,
40: x_encrypted_id OUT NOCOPY VARCHAR2,

Line 79: cursor c_tags ( p_account_id iem_mstemail_accounts.email_account_id%type)

75: l_exception_log BOOLEAN :=false;
76:
77: IEM_CREATE_ENCRYPTEDTAG_FAILED EXCEPTION;
78:
79: cursor c_tags ( p_account_id iem_mstemail_accounts.email_account_id%type)
80: is
81: select a.tag_id, a.tag_type_code, a.value
82: from iem_tag_keys a, iem_account_tag_keys b
83: where a.tag_key_id = b.tag_key_id and b.email_account_id = p_account_id;