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