[Home] [Help]
PACKAGE: APPS.CS_KB_SET_TYPES_PKG
Source
1 PACKAGE CS_KB_SET_TYPES_PKG AUTHID CURRENT_USER AS
2 /* $Header: cskbsts.pls 115.6 2002/11/11 23:53:31 mkettle ship $ */
3 /*======================================================================+
4 | Copyright (c) 1999 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +======================================================================+
8 | HISTORY |
9 | 18-OCT-1999 A. WONG Created |
10 | 29-JAN-2000 ALAM Added parameter name to create/update func. |
11 | 14-AUG-2002 KLOU (SEDATE) |
12 | 1. Add new parameters p_start_date and p_end_date. |
13 +======================================================================*/
14
15
16 /* for return status */
17 ERROR_STATUS CONSTANT NUMBER := -1;
18 OKAY_STATUS CONSTANT NUMBER := 0;
19
20 /* for cs_kb_set_eles.assoc_degree */
21 POSITIVE_ASSOC CONSTANT NUMBER := 1;
22 NEGATIVE_ASSOC CONSTANT NUMBER := -1;
23
24 /* default increment for count */
25 COUNT_INCR CONSTANT NUMBER := 1;
26 COUNT_INIT CONSTANT NUMBER := 1;
27
28
29 FUNCTION Create_Set_Type(
30 p_name in varchar2,
31 p_desc in varchar2,
32 P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
33 P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
34 P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
35 P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
36 P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
37 P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
38 P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
39 P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
40 P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
41 P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
42 P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
43 P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
44 P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
45 P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
46 P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
47 P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
48 P_START_DATE in DATE DEFAULT NULL,
49 P_END_DATE in DATE DEFAULT NULL
50 ) return number;
51
52 FUNCTION Update_Set_Type(
53 p_set_type_id in number,
54 p_name in varchar2,
55 p_desc in varchar2,
56 P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
57 P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
58 P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
59 P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
60 P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
61 P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
62 P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
63 P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
64 P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
65 P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
66 P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
67 P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
68 P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
69 P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
70 P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
71 P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
72 P_START_DATE in DATE DEFAULT NULL,
73 P_END_DATE in DATE DEFAULT NULL
74 ) return number;
75
76 FUNCTION Delete_Set_Type(
77 p_set_type_id in number
78 ) return number;
79
80
81 procedure INSERT_ROW (
82 X_ROWID in OUT NOCOPY VARCHAR2,
83 X_SET_TYPE_ID in NUMBER,
84 X_SET_TYPE_NAME in VARCHAR2,
85 X_NAME in VARCHAR2,
86 X_DESCRIPTION in VARCHAR2,
87 X_CREATION_DATE in DATE,
88 X_CREATED_BY in NUMBER,
89 X_LAST_UPDATE_DATE in DATE,
90 X_LAST_UPDATED_BY in NUMBER,
91 X_LAST_UPDATE_LOGIN in NUMBER,
92 X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
93 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
94 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
95 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
96 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
97 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
98 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
99 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
100 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
101 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
102 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
103 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
104 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
105 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
106 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
107 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
108 X_START_DATE in DATE DEFAULT NULL,
109 X_END_DATE in DATE DEFAULT NULL
110 );
111
112 procedure LOCK_ROW (
113 X_SET_TYPE_ID in NUMBER,
114 X_SET_TYPE_NAME in VARCHAR2,
115 X_NAME in VARCHAR2,
116 X_DESCRIPTION in VARCHAR2,
117 X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
118 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
119 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
120 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
121 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
122 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
123 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
124 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
125 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
126 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
127 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
128 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
129 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
130 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
131 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
132 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
133 X_START_DATE in DATE DEFAULT NULL,
134 X_END_DATE in DATE DEFAULT NULL
135 );
136
137 procedure UPDATE_ROW (
138 X_SET_TYPE_ID in NUMBER,
139 X_SET_TYPE_NAME in VARCHAR2,
140 X_NAME in VARCHAR2,
141 X_DESCRIPTION in VARCHAR2,
142 X_LAST_UPDATE_DATE in DATE,
143 X_LAST_UPDATED_BY in NUMBER,
144 X_LAST_UPDATE_LOGIN in NUMBER,
145 X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
146 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
147 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
148 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
149 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
150 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
151 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
152 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
153 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
154 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
155 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
156 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
157 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
158 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
159 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
160 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
161 X_START_DATE in DATE DEFAULT NULL,
162 X_END_DATE in DATE DEFAULT NULL
163 );
164
165 procedure DELETE_ROW (
166 X_SET_TYPE_ID in NUMBER
167 );
168
169 procedure ADD_LANGUAGE;
170
171 PROCEDURE TRANSLATE_ROW(
172 x_set_type_id in number,
173 x_owner in varchar2,
174 x_name in varchar2,
175 x_description in varchar2);
176
177 PROCEDURE LOAD_ROW(
178 x_set_type_id in number,
179 x_owner in varchar2,
180 x_name in varchar2,
181 x_description in varchar2);
182
183 end CS_KB_SET_TYPES_PKG;