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.
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,
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,
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,
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,
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,
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,
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.
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,
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.
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,
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,
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:
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.
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,