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 740: from iem_account_emailprocs

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

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

1639: l_api_name varchar2(30):='delete_item_batch';
1640: l_api_version_number number:=1.0;
1641:
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;

Line 1689: Update iem_account_emailprocs set priority=priority-1

1685:
1686: -- update priority after delete an account_route
1687: --Fixme for account rule type association
1688: FOR acct_id IN acct_id_cursor(p_emailproc_id) LOOP
1689: Update iem_account_emailprocs set priority=priority-1
1690:
1691: where email_account_id=acct_id.email_account_id
1692: and emailproc_id in
1693: ( select emailproc_id

Line 1696: and priority > (Select priority from iem_account_emailprocs

1692: and emailproc_id in
1693: ( select emailproc_id
1694: from iem_emailprocs
1695: where rule_type=p_rule_type )
1696: and priority > (Select priority from iem_account_emailprocs
1697: where emailproc_id=p_emailproc_id and email_account_id = acct_id.email_account_id);
1698: END LOOP;
1699:
1700: --remove association

Line 1702: FROM iem_account_emailprocs

1698: END LOOP;
1699:
1700: --remove association
1701: DELETE
1702: FROM iem_account_emailprocs
1703: WHERE emailproc_id = p_emailproc_id;
1704:
1705: --remove iem_emailproc_rules
1706: DELETE

Line 1799: FROM IEM_ACCOUNT_EMAILPROCS

1795: x_return_status := FND_API.G_RET_STS_SUCCESS;
1796:
1797: --Actual API starts here
1798: DELETE
1799: FROM IEM_ACCOUNT_EMAILPROCS
1800: WHERE email_account_id = p_email_account_id;
1801:
1802:
1803: --Standard check of p_commit