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

Line 36: -- Standard Start of API savepoint

32:
33: BEGIN
34:
35:
36: -- Standard Start of API savepoint
37: SAVEPOINT createMSGStat_pvt;
38:
39: --Init values
40: l_api_name :='createMSGStat';

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

42: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
43: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
44: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
45:
46: -- Standard call to check for call compatibility.
47: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
48: 1.0,
49: l_api_name,
50: G_PKG_NAME)

Line 112: -- Standard Check Of p_commit.

108: l_last_update_login
109: );
110:
111: -------------------End Code------------------------
112: -- Standard Check Of p_commit.
113: IF FND_API.To_Boolean(p_commit) THEN
114: COMMIT WORK;
115: END IF;
116:

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

113: IF FND_API.To_Boolean(p_commit) THEN
114: COMMIT WORK;
115: END IF;
116:
117: -- Standard callto get message count and if count is 1, get message info.
118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );

Line 180: -- Standard Start of API savepoint

176: l_no VARCHAR2(1);
177:
178: BEGIN
179:
180: -- Standard Start of API savepoint
181: SAVEPOINT sendMSGStat_pvt;
182:
183: -- Init values
184: l_api_name :='sendMSGStat';

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

185: l_api_version_number :=1.0;
186: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
187: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
188:
189: -- Standard call to check for call compatibility.
190: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
191: 1.0,
192: l_api_name,
193: G_PKG_NAME)

Line 266: -- Standard Check Of p_commit.

262: LAST_UPDATE_DATE = SYSDATE,
263: LAST_UPDATE_LOGIN = l_last_update_login
264: WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;
265: -------------------End Code------------------------
266: -- Standard Check Of p_commit.
267: IF FND_API.To_Boolean(p_commit) THEN
268: COMMIT WORK;
269: END IF;
270:

Line 323: -- Standard Start of API savepoint

319: l_outbound_msg_stats_id NUMBER;
320:
321: BEGIN
322:
323: -- Standard Start of API savepoint
324: SAVEPOINT deleteMSGStat_pvt;
325:
326: -- Init values
327: l_api_name :='deleteMSGStat';

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

328: l_api_version_number :=1.0;
329: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
330: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
331:
332: -- Standard call to check for call compatibility.
333: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
334: 1.0,
335: l_api_name,
336: G_PKG_NAME)

Line 368: -- Standard Check Of p_commit.

364: DELETE FROM IEM_DOC_USAGE_STATS WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;
365: DELETE FROM IEM_OUTBOUND_MSG_STATS WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;
366:
367: -------------------End Code------------------------
368: -- Standard Check Of p_commit.
369: IF FND_API.To_Boolean(p_commit) THEN
370: COMMIT WORK;
371: END IF;
372:

Line 437: -- Standard Start of API savepoint

433: l_yes VARCHAR2(1);
434:
435: BEGIN
436:
437: -- Standard Start of API savepoint
438: SAVEPOINT cancelMSGStat_pvt;
439:
440: -- Init values
441: l_api_name :='cancelMSGStat';

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

443: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
444: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
445: l_yes := 'Y';
446:
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
449: 1.0,
450: l_api_name,
451: G_PKG_NAME)

Line 484: -- Standard Check Of p_commit.

480: DELETE FROM IEM_DOC_USAGE_STATS WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id
481: AND SAVED_Y_N <> l_yes;
482:
483: -------------------End Code------------------------
484: -- Standard Check Of p_commit.
485: IF FND_API.To_Boolean(p_commit) THEN
486: COMMIT WORK;
487: END IF;
488:

Line 540: -- Standard Start of API savepoint

536: l_outbound_msg_stats_id NUMBER;
537:
538: BEGIN
539:
540: -- Standard Start of API savepoint
541: SAVEPOINT saveMSGStat_pvt;
542:
543: -- Init values
544: l_api_name :='saveMSGStat';

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

546: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
547: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
548: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
549:
550: -- Standard call to check for call compatibility.
551: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
552: 1.0,
553: l_api_name,
554: G_PKG_NAME)

Line 591: -- Standard Check Of p_commit.

587: LAST_UPDATE_LOGIN = l_last_update_login
588: WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;
589:
590: -------------------End Code------------------------
591: -- Standard Check Of p_commit.
592: IF FND_API.To_Boolean(p_commit) THEN
593: COMMIT WORK;
594: END IF;
595:

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

592: IF FND_API.To_Boolean(p_commit) THEN
593: COMMIT WORK;
594: END IF;
595:
596: -- Standard callto get message count and if count is 1, get message info.
597: FND_MSG_PUB.Count_And_Get
598: ( p_count => x_msg_count,
599: p_data => x_msg_data
600: );

Line 677: -- Standard Start of API savepoint

673: l_no VARCHAR2(1);
674:
675: BEGIN
676:
677: -- Standard Start of API savepoint
678: SAVEPOINT insertDocUsageStat_pvt;
679: -- Init values
680: l_api_name := 'insertDocUsageStat';
681: l_api_version_number := 1.0;

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

683: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
684: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
685: l_uses_kb_docs_y_n := 'N';
686:
687: -- Standard call to check for call compatibility.
688: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
689: 1.0,
690: l_api_name,
691: G_PKG_NAME)

Line 811: -- Standard Check Of p_commit.

807: LAST_UPDATE_DATE = SYSDATE,
808: LAST_UPDATE_LOGIN = l_last_update_login
809: WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;
810: -------------------End Code------------------------
811: -- Standard Check Of p_commit.
812: IF FND_API.To_Boolean(p_commit) THEN
813: COMMIT WORK;
814: END IF;
815:

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

812: IF FND_API.To_Boolean(p_commit) THEN
813: COMMIT WORK;
814: END IF;
815:
816: -- Standard callto get message count and if count is 1, get message info.
817: FND_MSG_PUB.Count_And_Get
818: ( p_count => x_msg_count,
819: p_data => x_msg_data
820: );