1 PACKAGE OE_PC_VTMPLTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXPCVTS.pls 115.5 2003/10/20 07:06:05 appldev ship $ */
3
4 -- Start of Comments
5 -- API name Insert_Row
6 -- Type Private
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 PROCEDURE Insert_Row(
21 x_rowid in out nocopy varchar2
22 ,x_validation_tmplt_id in out nocopy number
23 ,x_entity_id in number
24 ,x_display_name in varchar2
25 ,x_description in varchar2
26 ,x_validation_tmplt_short_name in varchar2
27 ,x_validation_type in varchar2
28 ,x_system_flag in varchar2
29 ,x_created_by in number
30 ,x_creation_date in date
31 ,x_last_updated_by in number
32 ,x_last_update_date in date
33 ,x_last_update_login in number
34 ,x_wf_item_type in varchar2
35 ,x_activity_name in varchar2
36 ,x_activity_status_code in varchar2
37 ,x_activity_result_code in varchar2
38 ,x_api_pkg in varchar2
39 ,x_api_proc in varchar2
40 ,x_attribute_category in varchar2
41 ,x_attribute1 in varchar2
42 ,x_attribute2 in varchar2
43 ,x_attribute3 in varchar2
44 ,x_attribute4 in varchar2
45 ,x_attribute5 in varchar2
46 ,x_attribute6 in varchar2
47 ,x_attribute7 in varchar2
48 ,x_attribute8 in varchar2
49 ,x_attribute9 in varchar2
50 ,x_attribute10 in varchar2
51 ,x_attribute11 in varchar2
52 ,x_attribute12 in varchar2
53 ,x_attribute13 in varchar2
54 ,x_attribute14 in varchar2
55 ,x_attribute15 in varchar2
56 );
57
58 ---------------------------------------------------
59
60 -- Start of Comments
61 -- API name Lock_Row
62 -- Type Private
63 -- Function
64 --
65 -- Pre-reqs
66 --
67 -- Parameters
68 --
69 -- Version Current version = 1.0
70 -- Initial version = 1.0
71 --
72 -- Notes
73 --
74 -- End of Comments
75
76 PROCEDURE Lock_Row(
77 x_rowid in varchar2
78 ,x_validation_tmplt_id in number
79 ,x_entity_id in number
80 ,x_display_name in varchar2
81 ,x_description in varchar2
82 ,x_validation_tmplt_short_name in varchar2
83 ,x_validation_type in varchar2
84 ,x_system_flag in varchar2
85 ,x_created_by in number
86 ,x_creation_date in date
87 ,x_last_updated_by in number
88 ,x_last_update_date in date
89 ,x_last_update_login in number
90 ,x_wf_item_type in varchar2
91 ,x_activity_name in varchar2
92 ,x_activity_status_code in varchar2
93 ,x_activity_result_code in varchar2
94 ,x_api_pkg in varchar2
95 ,x_api_proc in varchar2
96 ,x_attribute_category in varchar2
97 ,x_attribute1 in varchar2
98 ,x_attribute2 in varchar2
99 ,x_attribute3 in varchar2
100 ,x_attribute4 in varchar2
101 ,x_attribute5 in varchar2
102 ,x_attribute6 in varchar2
103 ,x_attribute7 in varchar2
104 ,x_attribute8 in varchar2
105 ,x_attribute9 in varchar2
106 ,x_attribute10 in varchar2
107 ,x_attribute11 in varchar2
108 ,x_attribute12 in varchar2
109 ,x_attribute13 in varchar2
110 ,x_attribute14 in varchar2
111 ,x_attribute15 in varchar2
112 );
113
114 ---------------------------------------------------
115
116 -- Start of Comments
117 -- API name Update_Row
118 -- Type Private
119 -- Function
120 --
121 -- Pre-reqs
122 --
123 -- Parameters
124 --
125 -- Version Current version = 1.0
126 -- Initial version = 1.0
127 --
128 -- Notes
129 --
130 -- End of Comments
131
132 PROCEDURE Update_Row(
133 x_rowid in varchar2
134 ,x_validation_tmplt_id in number
135 ,x_entity_id in number
136 ,x_display_name in varchar2
137 ,x_description in varchar2
138 ,x_validation_tmplt_short_name in varchar2
139 ,x_validation_type in varchar2
140 ,x_system_flag in varchar2
141 ,x_created_by in number
142 ,x_creation_date in date
143 ,x_last_updated_by in number
144 ,x_last_update_date in date
145 ,x_last_update_login in number
146 ,x_wf_item_type in varchar2
147 ,x_activity_name in varchar2
148 ,x_activity_status_code in varchar2
149 ,x_activity_result_code in varchar2
150 ,x_api_pkg in varchar2
151 ,x_api_proc in varchar2
152 ,x_attribute_category in varchar2
153 ,x_attribute1 in varchar2
154 ,x_attribute2 in varchar2
155 ,x_attribute3 in varchar2
156 ,x_attribute4 in varchar2
157 ,x_attribute5 in varchar2
158 ,x_attribute6 in varchar2
159 ,x_attribute7 in varchar2
160 ,x_attribute8 in varchar2
161 ,x_attribute9 in varchar2
162 ,x_attribute10 in varchar2
163 ,x_attribute11 in varchar2
164 ,x_attribute12 in varchar2
165 ,x_attribute13 in varchar2
166 ,x_attribute14 in varchar2
167 ,x_attribute15 in varchar2
168 );
169 ---------------------------------------------------
170
171 -- Start of Comments
172 -- API name Delete_Row
173 -- Type Private
174 -- Function
175 --
176 -- Pre-reqs
177 --
178 -- Parameters
179 --
180 -- Version Current version = 1.0
181 -- Initial version = 1.0
182 --
183 -- Notes
184 --
185 -- End of Comments
186
187 PROCEDURE Delete_Row(
188 x_validation_tmplt_id in number
189 );
190 ----------------------------------------------------
191
192 -- Start of Comments
193 -- API name Add_Language
194 -- Type Private
195 -- Function
196 --
197 -- Pre-reqs
198 --
199 -- Parameters
200 --
201 -- Version Current version = 1.0
202 -- Initial version = 1.0
203 --
204 -- Notes
205 --
206 -- End of Comments
207
208 PROCEDURE Add_Language;
209
210 ----------------------------------------------------
211
212 -- Start of Comments
213 -- API name Check_Reference
214 -- Type Private
215 -- Function
216 --
217 -- Pre-reqs
218 --
219 -- Parameters
220 --
221 -- Version Current version = 1.0
222 -- Initial version = 1.0
223 --
224 -- Notes
225 --
226 -- End of Comments
227
228 PROCEDURE Check_References(
229 x_validation_tmplt_id in number
230 );
231
232 ----------------------------------------------------
233
234 -- Start of Comments
235 -- API name Check_Unique
236 -- Type Private
237 -- Function
238 --
239 -- Pre-reqs
240 --
241 -- Parameters
242 --
243 -- Version Current version = 1.0
244 -- Initial version = 1.0
245 --
246 -- Notes
247 --
248 -- End of Comments
249
250 PROCEDURE Check_Unique(
251 x_rowid in varchar2
252 ,x_entity_id in number
253 ,x_display_name in varchar2
254 ,x_validation_tmplt_short_name in varchar2
255 ,x_validation_unit in varchar2
256 );
257
258 PROCEDURE Translate_Row(
259 x_validation_tmplt_id in varchar2
260 ,x_owner in varchar2
261 ,x_display_name in varchar2
262 ,x_description in varchar2
263 );
264
265 PROCEDURE Load_Row(
266 x_validation_tmplt_id in varchar2
267 ,x_owner in varchar2
268 ,x_display_name in varchar2
269 ,x_description in varchar2
270 ,x_entity_id in varchar2
271 ,x_validation_tmplt_short_name in varchar2
272 ,x_validation_type in varchar2
273 ,x_activity_name in varchar2
274 ,x_activity_status_code in varchar2
275 ,x_activity_result_code in varchar2
276 ,x_api_pkg in varchar2
277 ,x_api_proc in varchar2
278 ,x_system_flag in varchar2
279 ,x_attribute_category in varchar2
280 ,x_attribute1 in varchar2
281 ,x_attribute2 in varchar2
282 ,x_attribute3 in varchar2
283 ,x_attribute4 in varchar2
284 ,x_attribute5 in varchar2
285 ,x_attribute6 in varchar2
286 ,x_attribute7 in varchar2
287 ,x_attribute8 in varchar2
288 ,x_attribute9 in varchar2
289 ,x_attribute10 in varchar2
290 ,x_attribute11 in varchar2
291 ,x_attribute12 in varchar2
292 ,x_attribute13 in varchar2
293 ,x_attribute14 in varchar2
294 ,x_attribute15 in varchar2
295 ,x_wf_item_type in varchar2
296 );
297
298 End OE_PC_VTMPLTS_PKG;