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_ROUTE_PVT dependencies on IEM_ACCOUNT_ROUTES

Line 13: -- added updating priority in IEM_ACCOUNT_ROUTES for delete_item_batch

9: -- Person Date Comments
10: -- Liang Xia 4/24/2001 Created
11: -- Liang Xia 6/7/2001 added checking duplication on IEM_ROUTES.name for PROCEDURE
12: -- create_item_routes and update_item_route
13: -- added updating priority in IEM_ACCOUNT_ROUTES for delete_item_batch
14: -- Liang Xia 6/7/2002 added validation for dynamic Route
15: -- Liang Xia 11/6/2002 release the validation for ALL_EMAILS and fixed part of "No MISS.." GSCC warning.
16: -- Liang Xia 12/2/2002 Fixed PLSQL standard: "No MISS.." "NOCOPY" GSCC warning.
17: -- Liang Xia 12/06/2004 Changed for 115.11 schema: iem_mstemail_account

Line 67: FROM IEM_ACCOUNT_ROUTES

63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64:
65: --Actual API starts here
66: DELETE
67: FROM IEM_ACCOUNT_ROUTES
68: WHERE email_account_id = p_email_account_id;
69:
70:
71: --Standard check of p_commit

Line 119: select email_account_id from iem_account_routes where route_id = l_route_id;

115: l_api_name varchar2(30):='delete_item_batch';
116: l_api_version_number number:=1.0;
117:
118: CURSOR acct_id_cursor( l_route_id IN NUMBER ) IS
119: select email_account_id from iem_account_routes where route_id = l_route_id;
120:
121: IEM_ROUTE_NOT_DELETED EXCEPTION;
122: BEGIN
123:

Line 168: Update iem_account_routes set priority=priority-1

164:
165: -- update priority after delete an account_route
166:
167: FOR acct_id IN acct_id_cursor(p_route_ids_tbl(i)) LOOP
168: Update iem_account_routes set priority=priority-1
169:
170: where email_account_id=acct_id.email_account_id and priority > (Select priority from iem_account_routes
171: where route_id=p_route_ids_tbl(i) and email_account_id = acct_id.email_account_id);
172: END LOOP;

Line 170: where email_account_id=acct_id.email_account_id and priority > (Select priority from iem_account_routes

166:
167: FOR acct_id IN acct_id_cursor(p_route_ids_tbl(i)) LOOP
168: Update iem_account_routes set priority=priority-1
169:
170: where email_account_id=acct_id.email_account_id and priority > (Select priority from iem_account_routes
171: where route_id=p_route_ids_tbl(i) and email_account_id = acct_id.email_account_id);
172: END LOOP;
173:
174: DELETE

Line 175: FROM IEM_ACCOUNT_ROUTES

171: where route_id=p_route_ids_tbl(i) and email_account_id = acct_id.email_account_id);
172: END LOOP;
173:
174: DELETE
175: FROM IEM_ACCOUNT_ROUTES
176: WHERE route_id = p_route_ids_tbl(i);
177:
178:
179: DELETE

Line 909: SELECT IEM_ACCOUNT_ROUTES_s1.nextval

905:
906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907:
908: --actual API begins here
909: SELECT IEM_ACCOUNT_ROUTES_s1.nextval
910: INTO l_seq_id
911: FROM dual;
912:
913: INSERT INTO IEM_ACCOUNT_ROUTES

Line 913: INSERT INTO IEM_ACCOUNT_ROUTES

909: SELECT IEM_ACCOUNT_ROUTES_s1.nextval
910: INTO l_seq_id
911: FROM dual;
912:
913: INSERT INTO IEM_ACCOUNT_ROUTES
914:
915: (
916: ROUTE_ID,
917: EMAIL_ACCOUNT_ID,

Line 1880: update IEM_ACCOUNT_ROUTES

1876: end if;
1877:
1878:
1879: if ((p_email_account_id <> FND_API.G_MISS_NUM) and (p_route_id <> FND_API.G_MISS_NUM)) then
1880: update IEM_ACCOUNT_ROUTES
1881: set
1882: destination_group_id = decode(p_destination_grp_id,null,destination_group_id,p_destination_grp_id),
1883: default_group_id =decode(p_default_grp_id,null,default_group_id,p_default_grp_id),
1884: enabled_flag=decode(p_enabled_flag,null,enabled_flag,p_enabled_flag),

Line 2000: Update iem_account_routes set priority=priority-1

1996:
1997:
1998:
1999: -- update priority after delete an account_route
2000: Update iem_account_routes set priority=priority-1
2001: where email_account_id=p_account_id and priority > (Select priority from iem_account_routes
2002: where route_id=p_route_ids_tbl(i) and email_account_id=p_account_id);
2003:
2004: DELETE

Line 2001: where email_account_id=p_account_id and priority > (Select priority from iem_account_routes

1997:
1998:
1999: -- update priority after delete an account_route
2000: Update iem_account_routes set priority=priority-1
2001: where email_account_id=p_account_id and priority > (Select priority from iem_account_routes
2002: where route_id=p_route_ids_tbl(i) and email_account_id=p_account_id);
2003:
2004: DELETE
2005: FROM IEM_ACCOUNT_ROUTES

Line 2005: FROM IEM_ACCOUNT_ROUTES

2001: where email_account_id=p_account_id and priority > (Select priority from iem_account_routes
2002: where route_id=p_route_ids_tbl(i) and email_account_id=p_account_id);
2003:
2004: DELETE
2005: FROM IEM_ACCOUNT_ROUTES
2006: WHERE route_id = p_route_ids_tbl(i) and email_account_id = p_account_id;
2007:
2008: END LOOP;
2009: end if;

Line 2060: -- to update and delete new tuples in iem_account_routes

2056: END delete_acct_route_batch;
2057:
2058:
2059:
2060: -- to update and delete new tuples in iem_account_routes
2061: PROCEDURE update_wrap_account_routes
2062: (p_api_version_number IN NUMBER,
2063: p_init_msg_list IN VARCHAR2 := null,
2064: p_commit IN VARCHAR2 := null,