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

Line 24: -- Standard Start of API savepoint

20: l_LAST_UPDATE_DATE DATE:=SYSDATE;
21:
22:
23: BEGIN
24: -- Standard Start of API savepoint
25: SAVEPOINT create_item_PVT;
26: -- Standard call to check for call compatibility.
27: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
28: p_api_version_number,

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

22:
23: BEGIN
24: -- Standard Start of API savepoint
25: SAVEPOINT create_item_PVT;
26: -- Standard call to check for call compatibility.
27: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
28: p_api_version_number,
29: l_api_name,
30: G_PKG_NAME)

Line 66: -- Standard Check Of p_commit.

62: decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
63: l_LAST_UPDATE_DATE
64: );
65:
66: -- Standard Check Of p_commit.
67: IF FND_API.To_Boolean(p_commit) THEN
68: COMMIT WORK;
69: END IF;
70: -- Standard callto get message count and if count is 1, get message info.

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

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

Line 130: -- Standard Start of API savepoint

126: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
127: l_LAST_UPDATE_DATE DATE:=SYSDATE;
128:
129: BEGIN
130: -- Standard Start of API savepoint
131: SAVEPOINT update_item_PVT;
132: -- Standard call to check for call compatibility.
133: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
134: p_api_version_number,

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

128:
129: BEGIN
130: -- Standard Start of API savepoint
131: SAVEPOINT update_item_PVT;
132: -- Standard call to check for call compatibility.
133: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
134: p_api_version_number,
135: l_api_name,
136: G_PKG_NAME)

Line 157: -- Standard Check Of p_commit.

153: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY)
154: where comp_rt_stats_id=p_comp_rt_stats_id;
155:
156:
157: -- Standard Check Of p_commit.
158: IF FND_API.To_Boolean(p_commit) THEN
159: COMMIT WORK;
160: END IF;
161: -- Standard callto get message count and if count is 1, get message info.

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

157: -- Standard Check Of p_commit.
158: IF FND_API.To_Boolean(p_commit) THEN
159: COMMIT WORK;
160: END IF;
161: -- Standard callto get message count and if count is 1, get message info.
162: FND_MSG_PUB.Count_And_Get
163: ( p_count => x_msg_count,
164: p_data => x_msg_data
165: );

Line 212: -- Standard Start of API savepoint

208: l_api_name VARCHAR2(255):='delete_item';
209: l_api_version_number NUMBER:=1.0;
210:
211: BEGIN
212: -- Standard Start of API savepoint
213: SAVEPOINT delete_item_PVT;
214: -- Standard call to check for call compatibility.
215: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
216: p_api_version_number,

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

210:
211: BEGIN
212: -- Standard Start of API savepoint
213: SAVEPOINT delete_item_PVT;
214: -- Standard call to check for call compatibility.
215: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
216: p_api_version_number,
217: l_api_name,
218: G_PKG_NAME)

Line 233: -- Standard Check Of p_commit.

229:
230: delete from IEM_COMP_RT_STATS
231: where comp_rt_stats_id=p_comp_rt_stats_id;
232:
233: -- Standard Check Of p_commit.
234: IF FND_API.To_Boolean(p_commit) THEN
235: COMMIT WORK;
236: END IF;
237: -- Standard callto get message count and if count is 1, get message info.

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

233: -- Standard Check Of p_commit.
234: IF FND_API.To_Boolean(p_commit) THEN
235: COMMIT WORK;
236: END IF;
237: -- Standard callto get message count and if count is 1, get message info.
238: FND_MSG_PUB.Count_And_Get
239: ( p_count => x_msg_count,
240: p_data => x_msg_data
241: );

Line 286: -- Standard Start of API savepoint

282: l_api_name VARCHAR2(255):='delete_item_for_cache';
283: l_api_version_number NUMBER:=1.0;
284:
285: BEGIN
286: -- Standard Start of API savepoint
287: SAVEPOINT delete_item_PVT;
288: -- Standard call to check for call compatibility.
289: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
290: p_api_version_number,

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

284:
285: BEGIN
286: -- Standard Start of API savepoint
287: SAVEPOINT delete_item_PVT;
288: -- Standard call to check for call compatibility.
289: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
290: p_api_version_number,
291: l_api_name,
292: G_PKG_NAME)

Line 307: -- Standard Check Of p_commit.

303:
304: delete from iem_comp_rt_stats where type IN ('EMAIL_ACCOUNT', 'AGENT_ACCOUNT',
305: 'AGENT', 'IMAP', 'SMTP', 'OES') and sysdate - last_update_date >1;
306:
307: -- Standard Check Of p_commit.
308: IF FND_API.To_Boolean(p_commit) THEN
309: COMMIT WORK;
310: END IF;
311: -- Standard callto get message count and if count is 1, get message info.

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

307: -- Standard Check Of p_commit.
308: IF FND_API.To_Boolean(p_commit) THEN
309: COMMIT WORK;
310: END IF;
311: -- Standard callto get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get
313: ( p_count => x_msg_count,
314: p_data => x_msg_data
315: );