1 PACKAGE OE_PC_RSETS_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXPCRDS.pls 120.0 2005/05/31 23:03:22 appldev noship $ */
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 /* file.sql.39 change */ varchar2
22 ,x_record_set_id in out NOCOPY /* file.sql.39 change */ number
23 ,x_entity_id in number
24 ,x_record_set_short_name in varchar2
25 ,x_pk_record_set_flag in varchar2
26 ,x_record_set_display_name in varchar2
27 ,x_record_set_description 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_attribute_category in varchar2
35 ,x_attribute1 in varchar2
36 ,x_attribute2 in varchar2
37 ,x_attribute3 in varchar2
38 ,x_attribute4 in varchar2
39 ,x_attribute5 in varchar2
40 ,x_attribute6 in varchar2
41 ,x_attribute7 in varchar2
42 ,x_attribute8 in varchar2
43 ,x_attribute9 in varchar2
44 ,x_attribute10 in varchar2
45 ,x_attribute11 in varchar2
46 ,x_attribute12 in varchar2
47 ,x_attribute13 in varchar2
48 ,x_attribute14 in varchar2
49 ,x_attribute15 in varchar2
50 );
51
52 ---------------------------------------------------
53 -- Start of Comments
54 -- API name Lock_Row
55 -- Type Private
56 -- Function
57 --
58 -- Pre-reqs
59 --
60 -- Parameters
61 --
62 -- Version Current version = 1.0
63 -- Initial version = 1.0
64 --
65 -- Notes
66 --
67 -- End of Comments
68
69
70 PROCEDURE Lock_Row(
71 x_rowid in varchar2
72 ,x_record_set_id in number
73 ,x_entity_id in number
74 ,x_record_set_short_name in varchar2
75 ,x_pk_record_set_flag in varchar2
76 ,x_record_set_display_name in varchar2
77 ,x_record_set_description in varchar2
78 ,x_system_flag in varchar2
79 ,x_created_by in number
80 ,x_creation_date in date
81 ,x_last_updated_by in number
82 ,x_last_update_date in date
83 ,x_last_update_login in number
84 ,x_attribute_category in varchar2
85 ,x_attribute1 in varchar2
86 ,x_attribute2 in varchar2
87 ,x_attribute3 in varchar2
88 ,x_attribute4 in varchar2
89 ,x_attribute5 in varchar2
90 ,x_attribute6 in varchar2
91 ,x_attribute7 in varchar2
92 ,x_attribute8 in varchar2
93 ,x_attribute9 in varchar2
94 ,x_attribute10 in varchar2
95 ,x_attribute11 in varchar2
96 ,x_attribute12 in varchar2
97 ,x_attribute13 in varchar2
98 ,x_attribute14 in varchar2
99 ,x_attribute15 in varchar2
100 );
101
102 ---------------------------------------------------
103 -- Start of Comments
104 -- API name Update_Row
105 -- Type Private
106 -- Function
107 --
108 -- Pre-reqs
109 --
110 -- Parameters
111 --
112 -- Version Current version = 1.0
113 -- Initial version = 1.0
114 --
115 -- Notes
116 --
117 -- End of Comments
118
119 PROCEDURE Update_Row(
120 x_rowid in varchar2
121 ,x_record_set_id in number
122 ,x_entity_id in number
123 ,x_record_set_short_name in varchar2
124 ,x_pk_record_set_flag in varchar2
125 ,x_record_set_display_name in varchar2
126 ,x_record_set_description in varchar2
127 ,x_system_flag in varchar2
128 ,x_created_by in number
129 ,x_creation_date in date
130 ,x_last_updated_by in number
131 ,x_last_update_date in date
132 ,x_last_update_login in number
133 ,x_attribute_category in varchar2
134 ,x_attribute1 in varchar2
135 ,x_attribute2 in varchar2
136 ,x_attribute3 in varchar2
137 ,x_attribute4 in varchar2
138 ,x_attribute5 in varchar2
139 ,x_attribute6 in varchar2
140 ,x_attribute7 in varchar2
141 ,x_attribute8 in varchar2
142 ,x_attribute9 in varchar2
143 ,x_attribute10 in varchar2
144 ,x_attribute11 in varchar2
145 ,x_attribute12 in varchar2
146 ,x_attribute13 in varchar2
147 ,x_attribute14 in varchar2
148 ,x_attribute15 in varchar2
149 );
150 ---------------------------------------------------
151 -- Start of Comments
152 -- API name Delete_Row
153 -- Type Private
154 -- Function
155 --
156 -- Pre-reqs
157 --
158 -- Parameters
159 --
160 -- Version Current version = 1.0
161 -- Initial version = 1.0
162 --
163 -- Notes
164 --
165 -- End of Comments
166
167 PROCEDURE Delete_Row(
168 x_record_set_id in number
169 );
170
171 ----------------------------------------------------
172 -- Start of Comments
173 -- API name Add_Language
174 -- Type Private
175 -- Function
176 --
177 -- Pre-reqs
178 --
179 -- Parameters
180 --
181 -- Version Current version = 1.0
182 -- Initial version = 1.0
183 --
184 -- Notes
185 --
186 -- End of Comments
187
188 PROCEDURE Add_Language;
189
190 ----------------------------------------------------
191 -- Start of Comments
192 -- API name Check_References
193 -- Type Private
194 -- Function
195 --
196 -- Pre-reqs
197 --
198 -- Parameters
199 --
200 -- Version Current version = 1.0
201 -- Initial version = 1.0
202 --
203 -- Notes
204 --
205 -- End of Comments
206
207 PROCEDURE Check_References(
208 x_record_set_id in number
209 );
210
211 ----------------------------------------------------
212 -- Start of Comments
213 -- API name Check_Unique
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_Unique(
229 x_rowid in varchar2
230 ,x_entity_id in number
231 ,x_record_set_display_name in varchar2
232 ,x_record_set_short_name in varchar2
233 ,x_pk_record_set_flag in varchar2
234 ,x_validation_unit in varchar2
235 );
236
237 PROCEDURE Translate_Row(
238 x_record_set_id in varchar2
239 ,x_owner in varchar2
240 ,x_record_set_display_name in varchar2
241 ,x_record_set_description in varchar2
242 );
243
244 PROCEDURE Load_Row(
245 x_record_set_id in varchar2
246 ,x_owner in varchar2
247 ,x_record_set_display_name in varchar2
248 ,x_record_set_description in varchar2
249 ,x_entity_id in varchar2
250 ,x_record_set_short_name in varchar2
251 ,x_pk_record_set_flag in varchar2
252 ,x_system_flag in varchar2
253 ,x_attribute_category in varchar2
254 ,x_attribute1 in varchar2
255 ,x_attribute2 in varchar2
256 ,x_attribute3 in varchar2
257 ,x_attribute4 in varchar2
258 ,x_attribute5 in varchar2
259 ,x_attribute6 in varchar2
260 ,x_attribute7 in varchar2
261 ,x_attribute8 in varchar2
262 ,x_attribute9 in varchar2
263 ,x_attribute10 in varchar2
264 ,x_attribute11 in varchar2
265 ,x_attribute12 in varchar2
266 ,x_attribute13 in varchar2
267 ,x_attribute14 in varchar2
268 ,x_attribute15 in varchar2
269 );
270
271 End OE_PC_RSETS_PKG;