228:
229: IEM_UNKNOWN_RULE_TYPE_EXP EXCEPTION;
230:
231: --The active emailprocs for auto_acknowledge in the system
232: cursor c_auto_processings (p_enabled_flag iem_account_emailprocs.enabled_flag%type,
233: p_account_id iem_email_accounts.email_account_id%type,
234: p_rule_type iem_emailprocs.rule_type%type)
235: is
236: select
238: a.boolean_type_code,
239: a.all_email
240: from
241: iem_emailprocs a,
242: iem_account_emailprocs b
243: where
244: a.emailproc_id = b.emailproc_id
245: and
246: a.rule_type = p_rule_type