1 PACKAGE CS_KB_SOLN_CATEGORIES_PKG AUTHID CURRENT_USER AS
2 /* $Header: cskbcats.pls 115.6 2003/08/06 23:16:59 dtian noship $ */
3
4 procedure INSERT_ROW
5 (
6 X_ROWID in OUT NOCOPY VARCHAR2,
7 X_CATEGORY_ID in OUT NOCOPY NUMBER,
8 X_PARENT_CATEGORY_ID in NUMBER,
9 X_NAME in VARCHAR2,
10 X_DESCRIPTION in VARCHAR2,
11 X_CREATION_DATE in DATE,
12 X_CREATED_BY in NUMBER,
13 X_LAST_UPDATE_DATE in DATE,
14 X_LAST_UPDATED_BY in NUMBER,
15 X_LAST_UPDATE_LOGIN in NUMBER,
16 X_VISIBILITY_ID in NUMBER
17 );
18
19 procedure UPDATE_ROW
20 (
21 X_CATEGORY_ID in NUMBER,
22 X_PARENT_CATEGORY_ID in NUMBER,
23 X_NAME in VARCHAR2,
24 X_DESCRIPTION in VARCHAR2,
25 X_LAST_UPDATE_DATE in DATE,
26 X_LAST_UPDATED_BY in NUMBER,
27 X_LAST_UPDATE_LOGIN in NUMBER,
28 X_VISIBILITY_ID in NUMBER
29 );
30
31 procedure DELETE_ROW
32 (
33 X_CATEGORY_ID in NUMBER
34 );
35
36 procedure LOCK_ROW
37 (
38 X_CATEGORY_ID in NUMBER,
39 X_PARENT_CATEGORY_ID in NUMBER,
40 X_NAME in VARCHAR2,
41 X_DESCRIPTION in VARCHAR2,
42 X_CREATION_DATE in DATE,
43 X_CREATED_BY in NUMBER,
44 X_LAST_UPDATE_DATE in DATE,
45 X_LAST_UPDATED_BY in NUMBER,
46 X_LAST_UPDATE_LOGIN in NUMBER,
47 X_VISIBILITY_ID in NUMBER
48 );
49
50 procedure ADD_LANGUAGE;
51
52 PROCEDURE TRANSLATE_ROW
53 (
54 X_CATEGORY_ID in NUMBER,
55 X_NAME in VARCHAR2,
56 X_DESCRIPTION in VARCHAR2,
57 X_OWNER in VARCHAR2
58 );
59
60 PROCEDURE LOAD_ROW
61 (
62 X_CATEGORY_ID in NUMBER,
63 X_PARENT_CATEGORY_ID in NUMBER,
64 X_NAME in VARCHAR2,
65 X_DESCRIPTION in VARCHAR2,
66 X_OWNER in VARCHAR2,
67 X_VISIBILITY_ID in NUMBER
68 );
69
70 END CS_KB_SOLN_CATEGORIES_PKG;