APPS.IEM_RULES_ENGINE_PUB dependencies on IEM_EMAILPROCS

Line 211: booleanTypeCode iem_emailprocs.boolean_type_code%type;

207: ruleHold Rules_tbl_type;
208: satisfied Boolean := false;
209: l_action VARCHAR2(30);
210: enabledFlag varchar(1):= 'Y';
211: booleanTypeCode iem_emailprocs.boolean_type_code%type;
212:
213: l_module VARCHAR2(30);
214: l_emailproc_id NUMBER;
215: L_SERVICE_REQUEST_ID VARCHAR2(30);

Line 232: p_rule_type iem_emailprocs.rule_type%type)

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
235: a.emailproc_id,
236: a.boolean_type_code,

Line 239: iem_emailprocs a,

235: a.emailproc_id,
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

Line 254: cursor c_rules (p_emailproc_id iem_emailprocs.emailproc_id%type)

250: -- a.emailproc_id <> 0
251: order by b.priority;
252:
253: --All the rules for a classification
254: cursor c_rules (p_emailproc_id iem_emailprocs.emailproc_id%type)
255: is
256: select
257: key_type_code,
258: operator_type_code,

Line 266: cursor c_params(p_emailproc_id iem_emailprocs.emailproc_id%type)

262: where
263: emailproc_id = p_emailproc_id;
264:
265: --Get parameter(s)
266: cursor c_params(p_emailproc_id iem_emailprocs.emailproc_id%type)
267: is
268: select b.parameter1, b.parameter2, b.parameter_tag
269: from iem_actions a, iem_action_dtls b
270: where a.action_id = b.action_id and a.emailproc_id = p_emailproc_id;