[Home] [Help]
209: ruleHold Rules_tbl_type;
210: satisfied Boolean := false;
211: l_action VARCHAR2(30);
212: enabledFlag varchar(1):= 'Y';
213: booleanTypeCode iem_emailprocs.boolean_type_code%type;
214:
215: l_module VARCHAR2(30);
216: l_emailproc_id NUMBER;
217: L_SERVICE_REQUEST_ID VARCHAR2(30);
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
237: a.emailproc_id,
238: a.boolean_type_code,
237: a.emailproc_id,
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
252: -- a.emailproc_id <> 0
253: order by b.priority;
254:
255: --All the rules for a classification
256: cursor c_rules (p_emailproc_id iem_emailprocs.emailproc_id%type)
257: is
258: select
259: key_type_code,
260: operator_type_code,
264: where
265: emailproc_id = p_emailproc_id;
266:
267: --Get parameter(s)
268: cursor c_params(p_emailproc_id iem_emailprocs.emailproc_id%type)
269: is
270: select b.parameter1, b.parameter2,b.parameter3, b.parameter_tag
271: from iem_actions a, iem_action_dtls b
272: where a.action_id = b.action_id and a.emailproc_id = p_emailproc_id;