DBA Data[Home] [Help]

APPS.FND_LOGVIEW dependencies on FND_LOG_ADMIN

Line 524: nrows := FND_LOG_ADMIN.DELETE_BY_USER_SESSION(FND_GLOBAL.USER_ID,

520: elsif (find_sysadmin is not null) then
521: f_buttonname := 'FIND_SYSADMIN';
522: f_user_id := NULL;
523: elsif (clearsessionlog is not null) then /* if user pressed... */
524: nrows := FND_LOG_ADMIN.DELETE_BY_USER_SESSION(FND_GLOBAL.USER_ID,
525: icx_sec.getsessioncookie());
526: commit;
527: htp.p(
528: 'Cleared '|| nrows||

Line 532: nrows := FND_LOG_ADMIN.DELETE_BY_USER(FND_GLOBAL.USER_ID);

528: 'Cleared '|| nrows||
529: ' rows of log data for this session. Use back arrow to get back.
');
530: return;
531: elsif (clearuserlog is not null) then /* if user pressed... */
532: nrows := FND_LOG_ADMIN.DELETE_BY_USER(FND_GLOBAL.USER_ID);
533: commit;
534: htp.p(
535: 'Cleared '|| nrows ||
536: ' rows of log data for this user. Use back arrow to get back.
');

Line 1162: nrows := FND_LOG_ADMIN.DELETE_BY_SESSION(to_number(SESSION_TO_PURGE));

1158: commit;
1159: fnd_log_repository.init;
1160: htp.p('Cleared user level information.');
1161: elsif (sysclearsessionlog is not null) then /* if user pressed... */
1162: nrows := FND_LOG_ADMIN.DELETE_BY_SESSION(to_number(SESSION_TO_PURGE));
1163: commit;
1164: htp.p('Purged '|| nrows ||' rows of log data for session '
1165: ||SESSION_TO_PURGE||'.
');
1166: purged := TRUE;

Line 1173: nrows := FND_LOG_ADMIN.DELETE_BY_USER_SESSION(user_id_x,

1169: user_id_x := user_id;
1170: else
1171: user_id_x := FND_GLOBAL.USER_ID;
1172: end if;
1173: nrows := FND_LOG_ADMIN.DELETE_BY_USER_SESSION(user_id_x,
1174: icx_sec.getsessioncookie());
1175: commit;
1176: htp.p('Purged '|| nrows || ' rows of log data for this session.');
1177: purged := TRUE;

Line 1189: nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);

1185: htp.p('Invalid username entered. Enter a valid username.');
1186: user_id_x := NULL;
1187: end;
1188: if(user_id_x is not NULL) then
1189: nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);
1190: commit;
1191: htp.p('

Purged '|| nrows|| ' rows of log data for user '
1192: ||USER_TO_PURGE||'.

');
1193: purged := TRUE;

Line 1198: nrows := FND_LOG_ADMIN.DELETE_ALL;

1194: else
1195: made_changes := FALSE;
1196: end if;
1197: elsif (syspurgeallusers is not null) then /* if user pressed... */
1198: nrows := FND_LOG_ADMIN.DELETE_ALL;
1199: commit;
1200: htp.p('Purged '|| nrows||
1201: ' rows of log data for all users, all sessions.
');
1202: purged := TRUE;

Line 1224: nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);

1220: user_id_x := user_id;
1221: else
1222: user_id_x := FND_GLOBAL.USER_ID;
1223: end if;
1224: nrows := FND_LOG_ADMIN.DELETE_BY_USER(user_id_x);
1225: commit;
1226: purged := TRUE;
1227: htp.p('

Purged '|| nrows ||
1228: ' rows of log data for this user.

');