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_CLASS_PVT dependencies on IEM_ACCOUNT_ROUTE_CLASS

Line 38: TYPE t_AcctIdTable is TABLE of iem_account_route_class.email_account_id%TYPE INDEX BY BINARY_INTEGER;

34: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
35:
36: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID') ) ;
37:
38: TYPE t_AcctIdTable is TABLE of iem_account_route_class.email_account_id%TYPE INDEX BY BINARY_INTEGER;
39:
40:
41: PROCEDURE getRouteClassifications(
42: p_api_version_number IN NUMBER,

Line 146: select unique email_account_id from iem_account_route_class where route_classification_id = l_classification_id;

142:
143: logMessage varchar2(200);
144:
145: CURSOR acct_id_cursor( l_classification_id IN NUMBER ) IS
146: select unique email_account_id from iem_account_route_class where route_classification_id = l_classification_id;
147:
148:
149: IEM_RT_CLASS_NOT_DELETED EXCEPTION;
150: --IEM_UNEXPT_ERR_DELETE_FOLDER EXCEPTION;

Line 213: -- then update priority in iem_account_route_class before deleting an account_route

209: --elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
210: -- raise IEM_UNEXPT_ERR_DELETE_FOLDER;
211:
212: --else
213: -- then update priority in iem_account_route_class before deleting an account_route
214: FOR acct_id IN acct_id_cursor(p_class_ids_tbl(i)) LOOP
215: /*
216: if fnd_log.test(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.START') then
217:

Line 224: Update iem_account_route_class ac set ac.priority=ac.priority-1

220:
221: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PVT.delete_item_batch.START', logMessage);
222: end if;
223: */
224: Update iem_account_route_class ac set ac.priority=ac.priority-1
225: where ac.email_account_id=acct_id.email_account_id and ac.priority > (Select be.priority from iem_account_route_class be
226: where be.route_classification_id=p_class_ids_tbl(i) and be.email_account_id = acct_id.email_account_id);
227: commit;
228: END LOOP;

Line 225: where ac.email_account_id=acct_id.email_account_id and ac.priority > (Select be.priority from iem_account_route_class be

221: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PVT.delete_item_batch.START', logMessage);
222: end if;
223: */
224: Update iem_account_route_class ac set ac.priority=ac.priority-1
225: where ac.email_account_id=acct_id.email_account_id and ac.priority > (Select be.priority from iem_account_route_class be
226: where be.route_classification_id=p_class_ids_tbl(i) and be.email_account_id = acct_id.email_account_id);
227: commit;
228: END LOOP;
229:

Line 230: --finially delete from IEM_ROUTE_CLASSIFICATIONS, IEM_ACCOUNT_ROUTE_CLASS and IEM_ROUTE_CLASSIFICATIONS

226: where be.route_classification_id=p_class_ids_tbl(i) and be.email_account_id = acct_id.email_account_id);
227: commit;
228: END LOOP;
229:
230: --finially delete from IEM_ROUTE_CLASSIFICATIONS, IEM_ACCOUNT_ROUTE_CLASS and IEM_ROUTE_CLASSIFICATIONS
231: UPDATE IEM_ROUTE_CLASSIFICATIONS
232: SET DELETED_FLAG='Y'
233: WHERE route_classification_id = p_class_ids_tbl(i);
234:

Line 240: FROM IEM_ACCOUNT_ROUTE_CLASS

236: FROM IEM_ROUTE_CLASS_RULES
237: WHERE route_classification_id = p_class_ids_tbl(i);
238:
239: DELETE
240: FROM IEM_ACCOUNT_ROUTE_CLASS
241: WHERE route_classification_id = p_class_ids_tbl(i);
242: commit;
243:
244: --end if;

Line 1853: SELECT IEM_ACCOUNT_ROUTE_CLASS_s1.nextval

1849:
1850: x_return_status := FND_API.G_RET_STS_SUCCESS;
1851:
1852: --actual API begins here
1853: SELECT IEM_ACCOUNT_ROUTE_CLASS_s1.nextval
1854: INTO l_seq_id
1855: FROM dual;
1856:
1857: INSERT INTO IEM_ACCOUNT_ROUTE_CLASS

Line 1857: INSERT INTO IEM_ACCOUNT_ROUTE_CLASS

1853: SELECT IEM_ACCOUNT_ROUTE_CLASS_s1.nextval
1854: INTO l_seq_id
1855: FROM dual;
1856:
1857: INSERT INTO IEM_ACCOUNT_ROUTE_CLASS
1858:
1859: (
1860: ROUTE_CLASSIFICATION_ID,
1861:

Line 2241: update IEM_ACCOUNT_ROUTE_CLASS

2237: END IF;
2238:
2239: if ((p_email_account_id <> FND_API.G_MISS_NUM) and (p_class_id <> FND_API.G_MISS_NUM)) then
2240:
2241: update IEM_ACCOUNT_ROUTE_CLASS
2242: set
2243: enabled_flag=decode(p_enabled_flag,FND_API.G_MISS_CHAR,enabled_flag,p_enabled_flag),
2244: priority=decode(p_priority,null,priority,p_priority),
2245: LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),

Line 2406: Update iem_account_route_class set priority=priority-1

2402: -- l_undeleted_class_name := l_undeleted_class_name||l_undeleted_class_name_1||', ';
2403: --else
2404:
2405: -- update priority before delete an account_classification association
2406: Update iem_account_route_class set priority=priority-1
2407: where email_account_id = p_account_id and priority > (Select priority from iem_account_route_class
2408: where route_classification_id=p_class_ids_tbl(i) and email_account_id=p_account_id);
2409:
2410: DELETE

Line 2407: where email_account_id = p_account_id and priority > (Select priority from iem_account_route_class

2403: --else
2404:
2405: -- update priority before delete an account_classification association
2406: Update iem_account_route_class set priority=priority-1
2407: where email_account_id = p_account_id and priority > (Select priority from iem_account_route_class
2408: where route_classification_id=p_class_ids_tbl(i) and email_account_id=p_account_id);
2409:
2410: DELETE
2411: FROM IEM_ACCOUNT_ROUTE_CLASS

Line 2411: FROM IEM_ACCOUNT_ROUTE_CLASS

2407: where email_account_id = p_account_id and priority > (Select priority from iem_account_route_class
2408: where route_classification_id=p_class_ids_tbl(i) and email_account_id=p_account_id);
2409:
2410: DELETE
2411: FROM IEM_ACCOUNT_ROUTE_CLASS
2412: WHERE route_classification_id = p_class_ids_tbl(i) and email_account_id = p_account_id;
2413:
2414: if SQL%NOTFOUND then
2415: raise IEM_ACCOUNT_CLASS_NOT_DELETED;

Line 2501: select unique email_account_id from iem_account_route_class where route_classification_id = l_classification_id;

2497:
2498:
2499:
2500: CURSOR acct_id_cursor( l_classification_id IN NUMBER ) IS
2501: select unique email_account_id from iem_account_route_class where route_classification_id = l_classification_id;
2502:
2503: MY_EXCP_MSG_IN_FOLDER EXCEPTION;
2504: IEM_UNEXPT_ERR_DELETE_FOLDER EXCEPTION;
2505:

Line 3083: select unique route_classification_id from iem_account_route_class where email_account_id = l_account_id;

3079: l_return_status varchar2(30);
3080:
3081:
3082: CURSOR class_id_cursor( l_account_id IN NUMBER ) IS
3083: select unique route_classification_id from iem_account_route_class where email_account_id = l_account_id;
3084:
3085: MY_EXCP_MSG_IN_FOLDER EXCEPTION;
3086: IEM_UNEXPT_ERR_DELETE_FOLDER EXCEPTION;
3087: l_count_msg_postmdt number := 0;

Line 3141: delete from iem_account_route_class where email_account_id = p_email_account_id;

3137: --END LOOP;
3138:
3139: --finially delete association of classifcations with this email account
3140:
3141: delete from iem_account_route_class where email_account_id = p_email_account_id;
3142:
3143:
3144: --Standard check of p_commit
3145: IF FND_API.to_Boolean(p_commit) THEN