DBA Data[Home] [Help]

APPS.IEM_MSG_STAT_PUB dependencies on FND_PROFILE

Line 42: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

38:
39: --Init values
40: l_api_name :='createMSGStat';
41: l_api_version_number :=1.0;
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.

Line 43: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

39: --Init values
40: l_api_name :='createMSGStat';
41: l_api_version_number :=1.0;
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,

Line 44: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

40: l_api_name :='createMSGStat';
41: l_api_version_number :=1.0;
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,

Line 186: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

182:
183: -- Init values
184: l_api_name :='sendMSGStat';
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,

Line 187: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

183: -- Init values
184: l_api_name :='sendMSGStat';
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,

Line 329: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

325:
326: -- Init values
327: l_api_name :='deleteMSGStat';
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,

Line 330: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

326: -- Init values
327: l_api_name :='deleteMSGStat';
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,

Line 443: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

439:
440: -- Init values
441: l_api_name :='cancelMSGStat';
442: l_api_version_number :=1.0;
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.

Line 444: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

440: -- Init values
441: l_api_name :='cancelMSGStat';
442: l_api_version_number :=1.0;
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,

Line 546: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

542:
543: -- Init values
544: l_api_name :='saveMSGStat';
545: l_api_version_number :=1.0;
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.

Line 547: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

543: -- Init values
544: l_api_name :='saveMSGStat';
545: l_api_version_number :=1.0;
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,

Line 548: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

544: l_api_name :='saveMSGStat';
545: l_api_version_number :=1.0;
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,

Line 682: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

678: SAVEPOINT insertDocUsageStat_pvt;
679: -- Init values
680: l_api_name := 'insertDocUsageStat';
681: l_api_version_number := 1.0;
682: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
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:

Line 683: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);

679: -- Init values
680: l_api_name := 'insertDocUsageStat';
681: l_api_version_number := 1.0;
682: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
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.

Line 684: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);

680: l_api_name := 'insertDocUsageStat';
681: l_api_version_number := 1.0;
682: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
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,