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_KNOWLEDGEBASE_PUB dependencies on STANDARD

Line 35: -- Standard Start of API savepoint

31: WHERE (EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
32: AND (MESSAGE_ID = p_MESSAGE_ID)
33: AND classification_id = p_CLASSIFICATION_ID;
34: BEGIN
35: -- Standard Start of API savepoint
36: SAVEPOINT Get_SuggResponse_PUB;
37: -- Standard call to check for call compatibility.
38: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
39: p_api_version_number,

Line 37: -- Standard call to check for call compatibility.

33: AND classification_id = p_CLASSIFICATION_ID;
34: BEGIN
35: -- Standard Start of API savepoint
36: SAVEPOINT Get_SuggResponse_PUB;
37: -- Standard call to check for call compatibility.
38: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
39: p_api_version_number,
40: l_api_name,
41: G_PKG_NAME)

Line 63: -- Standard Check Of p_commit.

59: x_Email_SuggResp_tbl(l_index).url:=c_kb_rec.url;
60: x_Email_SuggResp_tbl(l_index).document_last_modified_date:=c_kb_rec.doc_last_modified_date;
61: l_index:=l_index+1;
62: END LOOP;
63: -- Standard Check Of p_commit.
64: IF FND_API.To_Boolean(p_commit) THEN
65: COMMIT WORK;
66: END IF;
67: -- Standard callto get message count and if count is 1, get message info.

Line 67: -- Standard callto get message count and if count is 1, get message info.

63: -- Standard Check Of p_commit.
64: IF FND_API.To_Boolean(p_commit) THEN
65: COMMIT WORK;
66: END IF;
67: -- Standard callto get message count and if count is 1, get message info.
68: FND_MSG_PUB.Count_And_Get
69: ( p_count => x_msg_count,
70: p_data => x_msg_data
71: );

Line 135: --Standard Start of API savepoint

131: l_api_version_number NUMBER:=1.0;
132: l_cat_index number:=1;
133:
134: BEGIN
135: --Standard Start of API savepoint
136: SAVEPOINT Get_KBCategories_PUB;
137: -- Standard call to check for call compatibility.
138: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
139: p_api_version_number,

Line 137: -- Standard call to check for call compatibility.

133:
134: BEGIN
135: --Standard Start of API savepoint
136: SAVEPOINT Get_KBCategories_PUB;
137: -- Standard call to check for call compatibility.
138: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
139: p_api_version_number,
140: l_api_name,
141: G_PKG_NAME)

Line 177: -- Standard Check Of p_commit.

173:
174: EXCEPTION
175: WHEN OTHERS THEN NULL;
176: END;
177: -- Standard Check Of p_commit.
178: IF FND_API.To_Boolean(p_commit) THEN
179: COMMIT WORK;
180: END IF;
181: -- Standard callto get message count and if count is 1, get message info.

Line 181: -- Standard callto get message count and if count is 1, get message info.

177: -- Standard Check Of p_commit.
178: IF FND_API.To_Boolean(p_commit) THEN
179: COMMIT WORK;
180: END IF;
181: -- Standard callto get message count and if count is 1, get message info.
182: FND_MSG_PUB.Count_And_Get
183: ( p_count => x_msg_count,
184: p_data => x_msg_data
185: );

Line 231: --Standard Start of API savepoint

227: l_api_name VARCHAR2(255):='Delete_ResultsCache';
228: l_api_version_number NUMBER:=1.0;
229:
230: BEGIN
231: --Standard Start of API savepoint
232: SAVEPOINT Delete_ResultsCache_PUB;
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
235: p_api_version_number,

Line 233: -- Standard call to check for call compatibility.

229:
230: BEGIN
231: --Standard Start of API savepoint
232: SAVEPOINT Delete_ResultsCache_PUB;
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
235: p_api_version_number,
236: l_api_name,
237: G_PKG_NAME)

Line 255: -- Standard Check Of p_commit.

251: DELETE FROM IEM_email_classifications
252: WHERE email_account_id=p_email_account_id
253: and message_id=p_message_id;
254:
255: -- Standard Check Of p_commit.
256: IF FND_API.To_Boolean(p_commit) THEN
257: COMMIT WORK;
258: END IF;
259: -- Standard callto get message count and if count is 1, get message info.

Line 259: -- Standard callto get message count and if count is 1, get message info.

255: -- Standard Check Of p_commit.
256: IF FND_API.To_Boolean(p_commit) THEN
257: COMMIT WORK;
258: END IF;
259: -- Standard callto get message count and if count is 1, get message info.
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count,
262: p_data => x_msg_data
263: );

Line 328: -- Standard Start of API savepoint

324: WHERE (EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
325: AND (MESSAGE_ID = p_MESSAGE_ID)
326: AND classification_id = p_CLASSIFICATION_ID;
327: BEGIN
328: -- Standard Start of API savepoint
329: SAVEPOINT Get_SuggResponse_PUB;
330: -- Standard call to check for call compatibility.
331: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
332: p_api_version_number,

Line 330: -- Standard call to check for call compatibility.

326: AND classification_id = p_CLASSIFICATION_ID;
327: BEGIN
328: -- Standard Start of API savepoint
329: SAVEPOINT Get_SuggResponse_PUB;
330: -- Standard call to check for call compatibility.
331: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
332: p_api_version_number,
333: l_api_name,
334: G_PKG_NAME)

Line 357: -- Standard Check Of p_commit.

353: x_Email_SuggResp_tbl(l_index).url:=c_kb_rec.url;
354: x_Email_SuggResp_tbl(l_index).document_last_modified_date:=c_kb_rec.doc_last_modified_date;
355: l_index:=l_index+1;
356: END LOOP;
357: -- Standard Check Of p_commit.
358: IF FND_API.To_Boolean(p_commit) THEN
359: COMMIT WORK;
360: END IF;
361: -- Standard callto get message count and if count is 1, get message info.

Line 361: -- Standard callto get message count and if count is 1, get message info.

357: -- Standard Check Of p_commit.
358: IF FND_API.To_Boolean(p_commit) THEN
359: COMMIT WORK;
360: END IF;
361: -- Standard callto get message count and if count is 1, get message info.
362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,
364: p_data => x_msg_data
365: );

Line 440: -- Standard Start of API savepoint

436: cursor c1 is select parameter1, parameter2 from iem_actions a, iem_action_dtls b
437: where a.emailproc_id=l_rule_id and a.action_id=b.action_id ;
438: l_doc_counter number;
439: BEGIN
440: -- Standard Start of API savepoint
441: SAVEPOINT Get_SuggResponse_PUB;
442: -- Standard call to check for call compatibility.
443: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
444: p_api_version_number,

Line 442: -- Standard call to check for call compatibility.

438: l_doc_counter number;
439: BEGIN
440: -- Standard Start of API savepoint
441: SAVEPOINT Get_SuggResponse_PUB;
442: -- Standard call to check for call compatibility.
443: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
444: p_api_version_number,
445: l_api_name,
446: G_PKG_NAME)

Line 514: -- Standard Check Of p_commit.

510: l_index:=l_index+1;
511: l_doc_counter:=l_doc_counter+1;
512: EXIT when l_doc_counter>10;
513: END LOOP;
514: -- Standard Check Of p_commit.
515: IF FND_API.To_Boolean(p_commit) THEN
516: COMMIT WORK;
517: END IF;
518: -- Standard callto get message count and if count is 1, get message info.

Line 518: -- Standard callto get message count and if count is 1, get message info.

514: -- Standard Check Of p_commit.
515: IF FND_API.To_Boolean(p_commit) THEN
516: COMMIT WORK;
517: END IF;
518: -- Standard callto get message count and if count is 1, get message info.
519: FND_MSG_PUB.Count_And_Get
520: ( p_count => x_msg_count,
521: p_data => x_msg_data
522: );

Line 586: -- Standard Start of API savepoint

582: WHERE (EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
583: AND (MESSAGE_ID = p_MESSAGE_ID)
584: order by score desc;
585: BEGIN
586: -- Standard Start of API savepoint
587: SAVEPOINT Get_SuggResponse_PUB;
588: -- Standard call to check for call compatibility.
589: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
590: p_api_version_number,

Line 588: -- Standard call to check for call compatibility.

584: order by score desc;
585: BEGIN
586: -- Standard Start of API savepoint
587: SAVEPOINT Get_SuggResponse_PUB;
588: -- Standard call to check for call compatibility.
589: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
590: p_api_version_number,
591: l_api_name,
592: G_PKG_NAME)

Line 614: -- Standard Check Of p_commit.

610: x_Email_SuggResp_tbl(l_index).url:=c_kb_rec.url;
611: x_Email_SuggResp_tbl(l_index).document_last_modified_date:=c_kb_rec.doc_last_modified_date;
612: l_index:=l_index+1;
613: END LOOP;
614: -- Standard Check Of p_commit.
615: IF FND_API.To_Boolean(p_commit) THEN
616: COMMIT WORK;
617: END IF;
618: -- Standard callto get message count and if count is 1, get message info.

Line 618: -- Standard callto get message count and if count is 1, get message info.

614: -- Standard Check Of p_commit.
615: IF FND_API.To_Boolean(p_commit) THEN
616: COMMIT WORK;
617: END IF;
618: -- Standard callto get message count and if count is 1, get message info.
619: FND_MSG_PUB.Count_And_Get
620: ( p_count => x_msg_count,
621: p_data => x_msg_data
622: );