DBA Data[Home] [Help]

APPS.IEM_KNOWLEDGEBASE_PUB dependencies on IEM_ACTIONS

Line 436: cursor c1 is select parameter1, parameter2 from iem_actions a, iem_action_dtls b

432: WHERE (a.EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
433: AND (a.MESSAGE_ID = p_MESSAGE_ID)
434: AND a.classification_id = p_CLASSIFICATION_ID
435: order by 2 desc,1 desc;
436: cursor c1 is select parameter1, parameter2 from iem_actions a, iem_action_dtls b
437: where a.emailproc_id=l_rule_id and a.action_id=b.action_id ;
438: l_doc_counter number;
439: BEGIN
440: -- Standard Start of API savepoint

Line 469: iem_actions where emailproc_id=l_rule_id;

465: into l_rule_id
466: from iem_rt_proc_emails where message_id=p_message_id;
467: BEGIN
468: select action into l_action from
469: iem_actions where emailproc_id=l_rule_id;
470: l_search_type:=substr(l_action,15,length(l_action));
471: if l_search_type='MES' THEN
472: l_repos:='MES';
473: elsif l_search_type='KM' THEN