eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_EMAILPROC_PVT dependencies on IEM_ACTIONS

Line 151: select action into l_action from iem_actions

147: l_3Rs(x).rule_type := 'RRRS';
148: l_3Rs(x).created_by := v_emailProcs.user_name;
149: l_3Rs(x).creation_date := v_emailProcs.creation_date;
150:
151: select action into l_action from iem_actions
152: where emailproc_id = v_emailProcs.emailproc_id;
153: l_3Rs(x).action := l_action;
154:
155: x := x + 1;

Line 168: select action into l_action from iem_actions

164: l_documents(x).rule_type := 'DOCUMENTRETRIEVAL';
165: l_documents(x).created_by := v_emailProcs.user_name;
166: l_documents(x).creation_date := v_emailProcs.creation_date;
167:
168: select action into l_action from iem_actions
169: where emailproc_id = v_emailProcs.emailproc_id;
170: l_documents(x).action := l_action;
171:
172: x := x + 1;

Line 196: select action into l_action from iem_actions

192: l_redirects(x).rule_type := 'AUTOREDIRECT';
193: l_redirects(x).created_by := v_emailProcs.user_name;
194: l_redirects(x).creation_date := v_emailProcs.creation_date;
195:
196: select action into l_action from iem_actions
197: where emailproc_id = v_emailProcs.emailproc_id;
198: l_redirects(x).action := l_action;
199:
200: x := x + 1;

Line 296: from iem_emailprocs r, iem_account_emailprocs a, iem_actions b

292: --used to retrieve rule types with different actions
293: cursor c_emailProc_rrr( v_acct_Id number, v_rule_type varchar2) is
294: select a.account_emailProc_id, a.priority, r.emailproc_id, r.name, r.description,
295: b.action, a.enabled_flag
296: from iem_emailprocs r, iem_account_emailprocs a, iem_actions b
297: where r.emailproc_id = a.emailproc_id and a.email_account_id = v_acct_Id
298: and r.rule_type = v_rule_type and a.emailproc_id = b.emailproc_id order by a.priority asc;
299:
300: cursor c_routes(v_acct_Id number) is

Line 497: select action_id from iem_actions where emailproc_id = v_emailProc_id;

493: IEM_EMAILPROC_NOT_DELETED EXCEPTION;
494: MY_EXCEPTION EXCEPTION;
495:
496: cursor c_actions(v_emailProc_id number) is
497: select action_id from iem_actions where emailproc_id = v_emailProc_id;
498:
499: BEGIN
500:
501: --Standard Savepoint

Line 649: l_action_id IEM_ACTIONS.ACTION_ID%type;

645: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
646: l_msg_count NUMBER := 0;
647: l_msg_data VARCHAR2(2000);
648:
649: l_action_id IEM_ACTIONS.ACTION_ID%type;
650: l_param2_count NUMBER := 0;
651: l_param3_count NUMBER := 0;
652: l_param_tag_count NUMBER := 0;
653:

Line 840: select action_id into l_action_id from iem_actions where emailproc_id = p_emailproc_id;

836: end if;
837: end if;
838:
839: -- updating action
840: select action_id into l_action_id from iem_actions where emailproc_id = p_emailproc_id;
841:
842: if ( p_action <> FND_API.G_MISS_CHAR ) or ( p_action is not null ) then
843: update iem_actions set action=p_action where action_id = l_action_id;
844: end if;

Line 843: update iem_actions set action=p_action where action_id = l_action_id;

839: -- updating action
840: select action_id into l_action_id from iem_actions where emailproc_id = p_emailproc_id;
841:
842: if ( p_action <> FND_API.G_MISS_CHAR ) or ( p_action is not null ) then
843: update iem_actions set action=p_action where action_id = l_action_id;
844: end if;
845:
846: -- updating action dtls
847: delete from iem_action_dtls where action_id = l_action_id;

Line 1038: l_action_id IEM_ACTIONS.ACTION_ID%type;

1034: l_api_version_number NUMBER:=1.0;
1035:
1036: l_emailproc_id IEM_EMAILPROCS.EMAILPROC_ID%TYPE;
1037: l_route_rule_id IEM_EMAILPROC_RULES.EMAILPROC_RULE_ID%TYPE;
1038: l_action_id IEM_ACTIONS.ACTION_ID%type;
1039: l_param2_count NUMBER := 0;
1040: l_param3_count NUMBER := 0;
1041: l_param_tag_count NUMBER := 0;
1042:

Line 1150: -- create iem_actions

1146: end if;
1147: end loop;
1148: end if;
1149:
1150: -- create iem_actions
1151: -- IF ( p_rule_type = 'AUTOACKNOWLEDGE' or p_rule_type = 'AUTOPROCESSING' or p_rule_type = 'AUTORRRS' ) then
1152: iem_emailproc_hdl_pvt.create_item_actions (
1153: p_api_version_number=>p_api_version_number,
1154: p_init_msg_list => p_init_msg_list,

Line 1368: from iem_emailprocs a, iem_actions b, iem_action_dtls c

1364: raise IEM_ADMIN_ACCOUNT_NOT_EXIST;
1365: end if;
1366:
1367: select count(*) into l_redirect_same_acct
1368: from iem_emailprocs a, iem_actions b, iem_action_dtls c
1369: where a.emailproc_id = p_emailproc_id and a.emailproc_id=b.emailproc_id
1370: and a.rule_type='AUTOREDIRECT' and b.action='AUTOREDIRECT_INTERNAL'
1371: and b.action_id=c.action_id and c.parameter1=to_char(p_email_account_id);
1372:

Line 1646: select action_id from iem_actions where emailproc_id = l_emailproc_id;

1642: CURSOR acct_id_cursor( l_emailproc_id IN NUMBER ) IS
1643: select email_account_id from iem_account_emailprocs where emailproc_id = l_emailproc_id;
1644:
1645: CURSOR action_id_cursor( l_emailproc_id IN NUMBER ) IS
1646: select action_id from iem_actions where emailproc_id = l_emailproc_id;
1647: IEM_ROUTE_NOT_DELETED EXCEPTION;
1648: BEGIN
1649:
1650:

Line 1716: delete from iem_actions where emailproc_id = p_emailproc_id;

1712: delete from iem_action_dtls where action_id = v_action_id.action_id;
1713: END LOOP;
1714:
1715: --remove iem_email_actions
1716: delete from iem_actions where emailproc_id = p_emailproc_id;
1717:
1718:
1719: --Standard check of p_commit
1720: IF FND_API.to_Boolean(p_commit) THEN