APPS.IEM_EMAILPROC_PVT dependencies on IEM_ACCOUNT_EMAILPROCS

Line 288: from iem_emailprocs r, iem_account_emailprocs a

284:
285: cursor c_emailProcs( v_acct_Id number, v_rule_type varchar2) is
286: select a.account_emailProc_id, a.priority, r.emailproc_id, r.name,r.description,
287: a.enabled_flag
288: from iem_emailprocs r, iem_account_emailprocs a
289: where r.emailproc_id = a.emailproc_id and a.email_account_id = v_acct_Id
290: and r.rule_type = v_rule_type order by a.priority asc;
291:
292: --used to retrieve rule types with different actions

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 558: Update iem_account_emailprocs set priority=priority-1

554: WHERE route_id = p_emailProc_id and email_account_id = p_acct_id;
555:
556: ELSE
557: -- update priority before delete an account_emailprocs
558: Update iem_account_emailprocs set priority=priority-1
559: where email_account_id=p_acct_id
560: and priority >
561: ( Select priority from iem_account_emailprocs
562: where emailproc_id=p_emailProc_id

Line 561: ( Select priority from iem_account_emailprocs

557: -- update priority before delete an account_emailprocs
558: Update iem_account_emailprocs set priority=priority-1
559: where email_account_id=p_acct_id
560: and priority >
561: ( Select priority from iem_account_emailprocs
562: where emailproc_id=p_emailProc_id
563: and email_account_id=p_acct_id)
564: and emailproc_id in
565: ( select emailproc_id from iem_emailprocs

Line 568: FROM iem_account_emailprocs

564: and emailproc_id in
565: ( select emailproc_id from iem_emailprocs
566: where rule_type = p_rule_type );
567: DELETE
568: FROM iem_account_emailprocs
569: WHERE emailproc_id = p_emailProc_id and email_account_id = p_acct_id;
570:
571: END IF;
572:

Line 737: from iem_account_emailprocs

733: elsif ( ( p_parameter1_tbl(1) is null) or (p_parameter1_tbl(1) ='')) then
734: raise IEM_ADM_AUTOPRC_NO_PARAMETERS;
735: else
736: select count(*) into l_redirect_same_acct
737: from iem_account_emailprocs
738: where email_account_id=p_parameter1_tbl(1) and emailproc_id=p_emailproc_id;
739:
740: if ( l_redirect_same_acct > 0 ) then
741: raise IEM_PROC_REDIRECT_SAME_ACCT;

Line 1610: select email_account_id from iem_account_emailprocs where emailproc_id = l_emailproc_id;

1606: l_api_name varchar2(30):='delete_item_batch';
1607: l_api_version_number number:=1.0;
1608:
1609: CURSOR acct_id_cursor( l_emailproc_id IN NUMBER ) IS
1610: select email_account_id from iem_account_emailprocs where emailproc_id = l_emailproc_id;
1611:
1612: CURSOR action_id_cursor( l_emailproc_id IN NUMBER ) IS
1613: select action_id from iem_actions where emailproc_id = l_emailproc_id;
1614: IEM_ROUTE_NOT_DELETED EXCEPTION;

Line 1656: Update iem_account_emailprocs set priority=priority-1

1652:
1653: -- update priority after delete an account_route
1654: --Fixme for account rule type association
1655: FOR acct_id IN acct_id_cursor(p_emailproc_id) LOOP
1656: Update iem_account_emailprocs set priority=priority-1
1657:
1658: where email_account_id=acct_id.email_account_id
1659: and emailproc_id in
1660: ( select emailproc_id

Line 1663: and priority > (Select priority from iem_account_emailprocs

1659: and emailproc_id in
1660: ( select emailproc_id
1661: from iem_emailprocs
1662: where rule_type=p_rule_type )
1663: and priority > (Select priority from iem_account_emailprocs
1664: where emailproc_id=p_emailproc_id and email_account_id = acct_id.email_account_id);
1665: END LOOP;
1666:
1667: --remove association

Line 1669: FROM iem_account_emailprocs

1665: END LOOP;
1666:
1667: --remove association
1668: DELETE
1669: FROM iem_account_emailprocs
1670: WHERE emailproc_id = p_emailproc_id;
1671:
1672: --remove iem_emailproc_rules
1673: DELETE

Line 1766: FROM IEM_ACCOUNT_EMAILPROCS

1762: x_return_status := FND_API.G_RET_STS_SUCCESS;
1763:
1764: --Actual API starts here
1765: DELETE
1766: FROM IEM_ACCOUNT_EMAILPROCS
1767: WHERE email_account_id = p_email_account_id;
1768:
1769:
1770: --Standard check of p_commit