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.
PACKAGE: APPS.CS_KB_ELEMENTS_AUDIT_PKG

Source


1 PACKAGE CS_KB_ELEMENTS_AUDIT_PKG AS
2 /* $Header: cskbelas.pls 120.0 2005/06/01 12:53:50 appldev noship $ */
3 
4  /* for RETURN status */
5  ERROR_STATUS      CONSTANT NUMBER      := -1;
6  OKAY_STATUS       CONSTANT NUMBER      := 0;
7 
8  /* for cs_kb_set_eles.assoc_degree  */
9  POSITIVE_ASSOC  	CONSTANT NUMBER      := 1;
10  NEGATIVE_ASSOC  	CONSTANT NUMBER      := -1;
11 
12  /* DEFAULT increment for count */
13  COUNT_INCR  	CONSTANT NUMBER      := 1;
14  COUNT_INIT  	CONSTANT NUMBER      := 1;
15 
16 
17  FUNCTION Is_Element_Created_Dup(
18    P_ELEMENT_ID IN NUMBER)
19  RETURN NUMBER;
20 
21  FUNCTION Is_Element_Dup (
22    P_ELEMENT_NUMBER  VARCHAR2,
23    P_ACCESS_LEVEL    NUMBER,
24    P_ELEMENT_TYPE_ID NUMBER,
25    P_ELEMENT_NAME    VARCHAR2,
26    P_ELEMENT_DESC    CLOB)
27  RETURN NUMBER;
28 
29 
30  FUNCTION Is_Element_Updated_Dup(
31    P_ELEMENT_ID IN NUMBER)
32  RETURN NUMBER;
33 
34 
35  FUNCTION Get_Element_Number(
36    P_ELEMENT_ID IN NUMBER)
37  RETURN VARCHAR2;
38 
39 
40  FUNCTION Get_Latest_Version_id(
41    P_ELEMENT_NUMBER IN VARCHAR2)
42  RETURN NUMBER;
43 
44  PROCEDURE Get_Who(
45    X_SYSDATE  OUT NOCOPY DATE,
46    X_USER_ID  OUT NOCOPY NUMBER,
47    X_LOGIN_ID OUT NOCOPY NUMBER);
48 
49  FUNCTION Create_Element(
50    P_ELEMENT_TYPE_ID    IN NUMBER,
51    P_DESC               IN VARCHAR2,
52    P_NAME               IN VARCHAR2,
53    P_STATUS             IN VARCHAR2 DEFAULT NULL,
54    P_ACCESS_LEVEL       IN NUMBER   DEFAULT NULL,
55    P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
56    P_ATTRIBUTE1         IN VARCHAR2 DEFAULT NULL,
57    P_ATTRIBUTE2         IN VARCHAR2 DEFAULT NULL,
58    P_ATTRIBUTE3         IN VARCHAR2 DEFAULT NULL,
59    P_ATTRIBUTE4         IN VARCHAR2 DEFAULT NULL,
60    P_ATTRIBUTE5         IN VARCHAR2 DEFAULT NULL,
61    P_ATTRIBUTE6         IN VARCHAR2 DEFAULT NULL,
62    P_ATTRIBUTE7         IN VARCHAR2 DEFAULT NULL,
63    P_ATTRIBUTE8         IN VARCHAR2 DEFAULT NULL,
64    P_ATTRIBUTE9         IN VARCHAR2 DEFAULT NULL,
65    P_ATTRIBUTE10        IN VARCHAR2 DEFAULT NULL,
66    P_ATTRIBUTE11        IN VARCHAR2 DEFAULT NULL,
67    P_ATTRIBUTE12        IN VARCHAR2 DEFAULT NULL,
68    P_ATTRIBUTE13        IN VARCHAR2 DEFAULT NULL,
69    P_ATTRIBUTE14        IN VARCHAR2 DEFAULT NULL,
70    P_ATTRIBUTE15        IN VARCHAR2 DEFAULT NULL,
71    P_START_ACTIVE_DATE  IN DATE     DEFAULT NULL,
72    P_END_ACTIVE_DATE    IN DATE     DEFAULT NULL,
73    P_CONTENT_TYPE       IN VARCHAR2 DEFAULT NULL )
74  RETURN NUMBER;
75 
76 
77  FUNCTION Create_Element_CLOB(
78    P_ELEMENT_TYPE_ID    IN NUMBER,
79    P_DESC               IN CLOB,
80    P_NAME               IN VARCHAR2,
81    P_STATUS             IN VARCHAR2 DEFAULT NULL,
82    P_ACCESS_LEVEL       IN NUMBER   DEFAULT NULL,
83    P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
84    P_ATTRIBUTE1         IN VARCHAR2 DEFAULT NULL,
85    P_ATTRIBUTE2         IN VARCHAR2 DEFAULT NULL,
86    P_ATTRIBUTE3         IN VARCHAR2 DEFAULT NULL,
87    P_ATTRIBUTE4         IN VARCHAR2 DEFAULT NULL,
88    P_ATTRIBUTE5         IN VARCHAR2 DEFAULT NULL,
89    P_ATTRIBUTE6         IN VARCHAR2 DEFAULT NULL,
90    P_ATTRIBUTE7         IN VARCHAR2 DEFAULT NULL,
91    P_ATTRIBUTE8         IN VARCHAR2 DEFAULT NULL,
92    P_ATTRIBUTE9         IN VARCHAR2 DEFAULT NULL,
93    P_ATTRIBUTE10        IN VARCHAR2 DEFAULT NULL,
94    P_ATTRIBUTE11        IN VARCHAR2 DEFAULT NULL,
95    P_ATTRIBUTE12        IN VARCHAR2 DEFAULT NULL,
96    P_ATTRIBUTE13        IN VARCHAR2 DEFAULT NULL,
97    P_ATTRIBUTE14        IN VARCHAR2 DEFAULT NULL,
98    P_ATTRIBUTE15        IN VARCHAR2 DEFAULT NULL,
99    P_START_ACTIVE_DATE  IN DATE     DEFAULT NULL,
100    P_END_ACTIVE_DATE    IN DATE     DEFAULT NULL,
101    P_CONTENT_TYPE       IN VARCHAR2 DEFAULT NULL )
102  RETURN NUMBER;
103 
104 
105  FUNCTION Update_Element(
106    P_ELEMENT_ID         IN NUMBER,
107    P_ELEMENT_NUMBER     IN VARCHAR2,
108    P_ELEMENT_TYPE_ID    IN NUMBER,
109    P_DESC               IN VARCHAR2,
110    P_NAME               IN VARCHAR2,
111    P_STATUS             IN VARCHAR2 DEFAULT NULL,
112    P_ACCESS_LEVEL       IN NUMBER   DEFAULT NULL,
113    P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
114    P_ATTRIBUTE1         IN VARCHAR2 DEFAULT NULL,
115    P_ATTRIBUTE2         IN VARCHAR2 DEFAULT NULL,
116    P_ATTRIBUTE3         IN VARCHAR2 DEFAULT NULL,
117    P_ATTRIBUTE4         IN VARCHAR2 DEFAULT NULL,
118    P_ATTRIBUTE5         IN VARCHAR2 DEFAULT NULL,
119    P_ATTRIBUTE6         IN VARCHAR2 DEFAULT NULL,
120    P_ATTRIBUTE7         IN VARCHAR2 DEFAULT NULL,
121    P_ATTRIBUTE8         IN VARCHAR2 DEFAULT NULL,
122    P_ATTRIBUTE9         IN VARCHAR2 DEFAULT NULL,
123    P_ATTRIBUTE10        IN VARCHAR2 DEFAULT NULL,
124    P_ATTRIBUTE11        IN VARCHAR2 DEFAULT NULL,
125    P_ATTRIBUTE12        IN VARCHAR2 DEFAULT NULL,
126    P_ATTRIBUTE13        IN VARCHAR2 DEFAULT NULL,
127    P_ATTRIBUTE14        IN VARCHAR2 DEFAULT NULL,
128    P_ATTRIBUTE15        IN VARCHAR2 DEFAULT NULL,
129    P_START_ACTIVE_DATE  IN DATE     DEFAULT NULL,
130    P_END_ACTIVE_DATE    IN DATE     DEFAULT NULL,
131    P_CONTENT_TYPE       IN VARCHAR2 DEFAULT NULL )
132  RETURN NUMBER;
133 
134 
135  FUNCTION Update_Element_CLOB(
136    P_ELEMENT_ID         IN NUMBER,
137    P_ELEMENT_NUMBER     IN VARCHAR2,
138    P_ELEMENT_TYPE_ID    IN NUMBER,
139    P_DESC               IN CLOB,
140    P_NAME               IN VARCHAR2,
141    P_STATUS             IN VARCHAR2 DEFAULT NULL,
142    p_access_level       IN NUMBER DEFAULT NULL,
143    P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
144    P_ATTRIBUTE1         IN VARCHAR2 DEFAULT NULL,
145    P_ATTRIBUTE2         IN VARCHAR2 DEFAULT NULL,
146    P_ATTRIBUTE3         IN VARCHAR2 DEFAULT NULL,
147    P_ATTRIBUTE4         IN VARCHAR2 DEFAULT NULL,
148    P_ATTRIBUTE5         IN VARCHAR2 DEFAULT NULL,
149    P_ATTRIBUTE6         IN VARCHAR2 DEFAULT NULL,
150    P_ATTRIBUTE7         IN VARCHAR2 DEFAULT NULL,
151    P_ATTRIBUTE8         IN VARCHAR2 DEFAULT NULL,
152    P_ATTRIBUTE9         IN VARCHAR2 DEFAULT NULL,
153    P_ATTRIBUTE10        IN VARCHAR2 DEFAULT NULL,
154    P_ATTRIBUTE11        IN VARCHAR2 DEFAULT NULL,
155    P_ATTRIBUTE12        IN VARCHAR2 DEFAULT NULL,
156    P_ATTRIBUTE13        IN VARCHAR2 DEFAULT NULL,
157    P_ATTRIBUTE14        IN VARCHAR2 DEFAULT NULL,
158    P_ATTRIBUTE15        IN VARCHAR2 DEFAULT NULL,
159    P_START_ACTIVE_DATE  IN DATE     DEFAULT NULL,
160    P_END_ACTIVE_DATE    IN DATE     DEFAULT NULL,
161    P_CONTENT_TYPE       IN VARCHAR2 DEFAULT NULL )
162  RETURN NUMBER;
163 
164  FUNCTION Delete_Element(
165    P_ELEMENT_NUMBER IN VARCHAR2)
166  RETURN NUMBER;
167 
168 
169  PROCEDURE Create_Statement(
170    X_ELEMENT_ID         IN OUT NOCOPY NUMBER,
171    P_ELEMENT_TYPE_ID    IN            NUMBER,
172    P_NAME               IN            VARCHAR2,
173    P_DESC               IN            CLOB,
174    P_STATUS             IN            VARCHAR2 DEFAULT NULL,
175    P_ACCESS_LEVEL       IN            NUMBER DEFAULT NULL,
176    P_ATTRIBUTE_CATEGORY IN            VARCHAR2 DEFAULT NULL,
177    P_ATTRIBUTE1         IN            VARCHAR2 DEFAULT NULL,
178    P_ATTRIBUTE2         IN            VARCHAR2 DEFAULT NULL,
179    P_ATTRIBUTE3         IN            VARCHAR2 DEFAULT NULL,
180    P_ATTRIBUTE4         IN            VARCHAR2 DEFAULT NULL,
181    P_ATTRIBUTE5         IN            VARCHAR2 DEFAULT NULL,
182    P_ATTRIBUTE6         IN            VARCHAR2 DEFAULT NULL,
183    P_ATTRIBUTE7         IN            VARCHAR2 DEFAULT NULL,
184    P_ATTRIBUTE8         IN            VARCHAR2 DEFAULT NULL,
185    P_ATTRIBUTE9         IN            VARCHAR2 DEFAULT NULL,
186    P_ATTRIBUTE10        IN            VARCHAR2 DEFAULT NULL,
187    P_ATTRIBUTE11        IN            VARCHAR2 DEFAULT NULL,
188    P_ATTRIBUTE12        IN            VARCHAR2 DEFAULT NULL,
189    P_ATTRIBUTE13        IN            VARCHAR2 DEFAULT NULL,
190    P_ATTRIBUTE14        IN            VARCHAR2 DEFAULT NULL,
191    P_ATTRIBUTE15        IN            VARCHAR2 DEFAULT NULL,
192    P_START_ACTIVE_DATE  IN            DATE     DEFAULT NULL,
193    P_END_ACTIVE_DATE    IN            DATE     DEFAULT NULL,
194    P_CONTENT_TYPE       IN            VARCHAR2 DEFAULT NULL,
195    X_RETURN_STATUS      OUT NOCOPY    VARCHAR2,
196    X_MSG_DATA           OUT NOCOPY    VARCHAR2,
197    X_MSG_COUNT          OUT NOCOPY    NUMBER);
198 
199 
200  FUNCTION create_clob
201  RETURN CLOB;
202 
203 
204  PROCEDURE Update_Statement(
205    P_ELEMENT_ID         IN            NUMBER,
206    P_ELEMENT_NUMBER     IN            VARCHAR2,
207    P_ELEMENT_TYPE_ID    IN            NUMBER,
208    P_DESC               IN            CLOB,
209    P_NAME               IN            VARCHAR2,
210    P_STATUS             IN            VARCHAR2 DEFAULT NULL,
211    P_ACCESS_LEVEL       IN            NUMBER DEFAULT NULL,
212    P_ATTRIBUTE_CATEGORY IN            VARCHAR2 DEFAULT NULL,
213    P_ATTRIBUTE1         IN            VARCHAR2 DEFAULT NULL,
214    P_ATTRIBUTE2         IN            VARCHAR2 DEFAULT NULL,
215    P_ATTRIBUTE3         IN            VARCHAR2 DEFAULT NULL,
216    P_ATTRIBUTE4         IN            VARCHAR2 DEFAULT NULL,
217    P_ATTRIBUTE5         IN            VARCHAR2 DEFAULT NULL,
218    P_ATTRIBUTE6         IN            VARCHAR2 DEFAULT NULL,
219    P_ATTRIBUTE7         IN            VARCHAR2 DEFAULT NULL,
220    P_ATTRIBUTE8         IN            VARCHAR2 DEFAULT NULL,
221    P_ATTRIBUTE9         IN            VARCHAR2 DEFAULT NULL,
222    P_ATTRIBUTE10        IN            VARCHAR2 DEFAULT NULL,
223    P_ATTRIBUTE11        IN            VARCHAR2 DEFAULT NULL,
224    P_ATTRIBUTE12        IN            VARCHAR2 DEFAULT NULL,
225    P_ATTRIBUTE13        IN            VARCHAR2 DEFAULT NULL,
226    P_ATTRIBUTE14        IN            VARCHAR2 DEFAULT NULL,
227    P_ATTRIBUTE15        IN            VARCHAR2 DEFAULT NULL,
228    P_START_ACTIVE_DATE  IN            DATE,
229    P_END_ACTIVE_DATE    IN            DATE,
230    P_CONTENT_TYPE       IN            VARCHAR2,
231    X_RETURN             OUT NOCOPY    NUMBER,
232    X_RETURN_STATUS      OUT NOCOPY    VARCHAR2,
233    X_MSG_DATA           OUT NOCOPY    VARCHAR2,
234    X_MSG_COUNT          OUT NOCOPY    NUMBER);
235 
236  PROCEDURE Update_Statement_Admin (
237    P_ELEMENT_ID      IN         NUMBER,
238    P_ELEMENT_NUMBER  IN         VARCHAR2,
239    P_ACCESS_LEVEL    IN         NUMBER,
240    P_ELEMENT_TYPE_ID IN         NUMBER,
241    P_ELEMENT_NAME    IN         VARCHAR2,
242    P_ELEMENT_DESC    IN         CLOB,
243    P_CONTENT_TYPE    IN         VARCHAR2,
244    X_RETURN_ELEMENT  OUT NOCOPY NUMBER,
245    X_RETURN_STATUS   OUT NOCOPY VARCHAR2,
246    X_MSG_DATA        OUT NOCOPY VARCHAR2,
247    X_MSG_COUNT       OUT NOCOPY NUMBER );
248 
249  PROCEDURE Obsolete_Unused_Statements (
250    ERRBUF  OUT NOCOPY VARCHAR2,
251    RETCODE OUT NOCOPY VARCHAR2 );
252 
253 END CS_KB_ELEMENTS_AUDIT_PKG;
254