1 package fnd_log_admin AUTHID CURRENT_USER as
2 /* $Header: AFUTLGAS.pls 115.12 2004/03/09 02:00:59 kkapur ship $ */
3
4
5 /* This routine is used as a concurrent program. */
6 /* Nobody besides the concurrent manager should call it. */
7 procedure delete_by_date_i( errbuf out NOCOPY varchar2,
8 retcode out NOCOPY varchar2,
9 last_date in varchar2 );
10
11 /* Delete all log messages for a particular user */
12 function delete_by_user(
13 X_USER_ID IN VARCHAR2 ) return NUMBER ;
14
15 /* Delete all log messages for a particular session */
16 function delete_by_session(
17 X_SESSION_ID IN VARCHAR2 ) return NUMBER ;
18
19 /* Delete all log messages for that match both user and session */
20 function delete_by_user_session(
21 X_USER_ID IN VARCHAR2,
22 X_SESSION_ID IN VARCHAR2 ) return NUMBER;
23
24 /* Delete all log messages that are "like" module */
25 function delete_by_module(
26 X_MODULE IN VARCHAR2 ) return NUMBER;
27
28 /* Delete all messages between the specified dates */
29 /* passing null means unlimited; null for both deletes all rows */
30 function delete_by_date_range(
31 X_START_DATE IN DATE ,
32 X_END_DATE IN DATE ) return NUMBER;
33
34 /* Deletes messages at level and all levels below.*/
35 function delete_by_max_level(
36 X_LEVEL IN NUMBER) return NUMBER;
37
38 /* Delete all messages */
39 function delete_all return NUMBER;
40
41 /* For AOL INTERNAL use only */
42 function self_test return varchar2;
43
44 /* Delete all log messages based on sequenceid */
45 function delete_by_sequence(
46 pLogSeqList IN VARCHAR2 ) return NUMBER ;
47
48 /*
49 function delete_by_Search(
50 pFromDate IN DATE,
51 pToDate IN DATE,
52 PUser IN VARCHAR2,
53 pNode IN VARCHAR2,
54 pModule IN VARCHAR2,
55 pMessage IN VARCHAR2,
56 pSession IN VARCHAR2,
57 pProcessid IN VARCHAR2,
58 pJvmid IN VARCHAR2,
59 pThreadid IN VARCHAR2,
60 pAudsid IN NUMBER,
61 pDbinstance IN NUMBER,
62 pMinseq IN NUMBER,
63 pMaxseq IN NUMBER) return NUMBER;
64 */
65
66 function delete_by_seqarray(numArrayList IN FND_ARRAY_OF_NUMBER_25) return NUMBER;
67
68 /* Check and Submit the Purge CP */
69 procedure start_purge_cp;
70
71 end FND_LOG_ADMIN;
[Home] [Help]