1 PACKAGE PV_Entity_Attribute_Pvt AUTHID CURRENT_USER AS
2 /* $Header: pvxveats.pls 120.1 2005/06/30 13:09:12 appldev ship $ */
3
4 -- ===============================================================
5 -- Start of Comments
6 -- Package name
7 -- PV_Entity_Attribute_PVT
8 -- Purpose
9 --
10 -- History
11 --
12 -- NOTE
13 --
14 -- End of Comments
15 -- ===============================================================
16 -- Default number of records fetch per call
17 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- entity_attr_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- entity_attr_id
26 -- last_update_date
27 -- last_updated_by
28 -- creation_date
29 -- created_by
30 -- last_update_login
31 -- object_version_number
32 -- attribute_id
33 -- entity
34 -- sql_text
35 -- attr_data_type
36 -- lov_string
37 -- enabled_flag
38 -- display_flag
39 -- security_group_id
40 -- locator_flag
41 --
42 -- Required
43 --
44 -- Defaults
45 --
46 -- Note: This is automatic generated record definition, it includes all columns
47 -- defined in the table, developer must manually add or delete some of the attributes.
48 --
49 -- End of Comments
50 --===================================================================
51
52 TYPE entity_attr_rec_type IS RECORD
53 (
54 entity_attr_id NUMBER := Fnd_Api.G_MISS_NUM
55 ,last_update_date DATE := Fnd_Api.G_MISS_DATE
56 ,last_updated_by NUMBER := Fnd_Api.G_MISS_NUM
57 ,creation_date DATE := Fnd_Api.G_MISS_DATE
58 ,created_by NUMBER := Fnd_Api.G_MISS_NUM
59 ,last_update_login NUMBER := Fnd_Api.G_MISS_NUM
60 ,object_version_number NUMBER := Fnd_Api.G_MISS_NUM
61 ,attribute_id NUMBER := Fnd_Api.G_MISS_NUM
62 ,entity VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
63 ,entity_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
64 ,sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
65 ,attr_data_type VARCHAR2(30) := Fnd_Api.G_MISS_CHAR
66 ,lov_string VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
67 ,enabled_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
68 ,display_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
69 ,locator_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
70 ,require_validation_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR
71 ,external_update_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
72 ,refresh_frequency NUMBER := Fnd_Api.G_MISS_NUM
73 ,refresh_frequency_uom VARCHAR2(20) := Fnd_Api.G_MISS_CHAR
74 ,batch_sql_text VARCHAR2(2000) := Fnd_Api.G_MISS_CHAR
75 ,last_refresh_date DATE := Fnd_Api.G_MISS_DATE
76 ,display_external_value_flag VARCHAR2(1) := Fnd_Api.G_MISS_CHAR);
77
78 g_miss_entity_attr_rec entity_attr_rec_type;
79
80 TYPE pv_entity_attr_tbl_type IS TABLE OF entity_attr_rec_type INDEX BY BINARY_INTEGER;
81 g_miss_entity_attr_tbl pv_entity_attr_tbl_type;
82
83
84 -- ==============================================================================
85 -- Start of Comments
86 -- ==============================================================================
87 -- API Name
88 -- Create_Entity_Attr
89 -- Type
90 -- Private
91 -- Pre-Req
92 --
93 -- Parameters
94 --
95 -- IN
96 -- p_api_version_number IN NUMBER Required
97 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
98 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
99 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
100 -- p_entity_attr_rec IN entity_attr_rec_type Required
101 --
102 -- OUT
103 -- x_return_status OUT VARCHAR2
104 -- x_msg_count OUT NUMBER
105 -- x_msg_data OUT VARCHAR2
106 -- Version : Current version 1.0
107 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
108 -- and basic operation, developer must manually add parameters and business logic as necessary.
109 --
110 -- End of Comments
111 -- ==============================================================================
112 --
113 Procedure Create_Entity_Attr(
114 p_api_version_number IN NUMBER
115 ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
116 ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
117 ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
118
119 ,x_return_status OUT NOCOPY VARCHAR2
120 ,x_msg_count OUT NOCOPY NUMBER
121 ,x_msg_data OUT NOCOPY VARCHAR2
122
123 ,p_entity_attr_rec IN entity_attr_rec_type := g_miss_entity_attr_rec
124 ,x_entity_attr_id OUT NOCOPY NUMBER
125 );
126
127
128 -- ==============================================================================
129 -- Start of Comments
130 -- ==============================================================================
131 -- API Name
132 -- Update_Entity_Attr
133 -- Type
134 -- Private
135 -- Pre-Req
136 --
137 -- Parameters
138 --
139 -- IN
140 -- p_api_version_number IN NUMBER Required
141 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144 -- p_entity_attr_rec IN entity_attr_rec_type Required
145 --
146 -- OUT
147 -- x_return_status OUT VARCHAR2
148 -- x_msg_count OUT NUMBER
149 -- x_msg_data OUT VARCHAR2
150 -- Version : Current version 1.0
151 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
152 -- and basic operation, developer must manually add parameters and business logic as necessary.
153 --
154 -- End of Comments
155 -- ==============================================================================
156 --
157 PROCEDURE Update_Entity_Attr(
158 p_api_version_number IN NUMBER
159 ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
160 ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
161 ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
162
163 ,x_return_status OUT NOCOPY VARCHAR2
164 ,x_msg_count OUT NOCOPY NUMBER
165 ,x_msg_data OUT NOCOPY VARCHAR2
166
167 ,p_entity_attr_rec IN entity_attr_rec_type
168 ,x_object_version_number OUT NOCOPY NUMBER
169 );
170
171
172 -- ==============================================================================
173 -- Start of Comments
174 -- ==============================================================================
175 -- API Name
176 -- Delete_Entity_Attr
177 -- Type
178 -- Private
179 -- Pre-Req
180 --
181 -- Parameters
182 --
183 -- IN
184 -- p_api_version_number IN NUMBER Required
185 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
188 -- p_ENTITY_ATTR_ID IN NUMBER
189 -- p_object_version_number IN NUMBER Optional Default = NULL
190 --
191 -- OUT
192 -- x_return_status OUT VARCHAR2
193 -- x_msg_count OUT NUMBER
194 -- x_msg_data OUT VARCHAR2
195 -- Version : Current version 1.0
196 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
197 -- and basic operation, developer must manually add parameters and business logic as necessary.
198 --
199 -- End of Comments
200 -- ==============================================================================
201 --
202 PROCEDURE Delete_Entity_Attr(
203 p_api_version_number IN NUMBER
204 ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
205 ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
206 ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
207 ,x_return_status OUT NOCOPY VARCHAR2
208 ,x_msg_count OUT NOCOPY NUMBER
209 ,x_msg_data OUT NOCOPY VARCHAR2
210 ,p_entity_attr_id IN NUMBER
211 ,p_object_version_number IN NUMBER
212 );
213
214
215 -- ==============================================================================
216 -- Start of Comments
217 -- ==============================================================================
218 -- API Name
219 -- Lock_Entity_Attr
220 -- Type
221 -- Private
222 -- Pre-Req
223 --
224 -- Parameters
225 --
226 -- IN
227 -- p_api_version_number IN NUMBER Required
228 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
229 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
230 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
231 -- p_entity_attr_rec IN entity_attr_rec_type Required
232 --
233 -- OUT
234 -- x_return_status OUT VARCHAR2
235 -- x_msg_count OUT NUMBER
236 -- x_msg_data OUT VARCHAR2
237 -- Version : Current version 1.0
238 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
239 -- and basic operation, developer must manually add parameters and business logic as necessary.
240 --
241 -- End of Comments
242 -- ==============================================================================
243 --
244 PROCEDURE Lock_Entity_Attr(
245 p_api_version_number IN NUMBER
246 ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
247 ,x_return_status OUT NOCOPY VARCHAR2
248 ,x_msg_count OUT NOCOPY NUMBER
249 ,x_msg_data OUT NOCOPY VARCHAR2
250 ,p_entity_attr_id IN NUMBER
251 ,p_object_version IN NUMBER
252 );
253
254
255 -- Start of Comments
256 --
257 -- validation procedures
258 --
259 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
260 -- For create: G_CREATE, for update: G_UPDATE
261 -- Note: 1. This is automated generated item level validation procedure.
262 -- The actual validation detail is needed to be added.
263 -- 2. We can also validate table instead of record. There will be an option for user to choose.
264 -- End of Comments
265
266 PROCEDURE Validate_Entity_Attr(
267 p_api_version_number IN NUMBER
268 ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
269 ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
270 ,p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.G_UPDATE
271 ,p_entity_attr_rec IN entity_attr_rec_type
272 ,x_return_status OUT NOCOPY VARCHAR2
273 ,x_msg_count OUT NOCOPY NUMBER
274 ,x_msg_data OUT NOCOPY VARCHAR2
275 );
276
277
278 -- Start of Comments
279 --
280 -- validation procedures
281 --
282 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
283 -- For create: G_CREATE, for update: G_UPDATE
284 -- Note: 1. This is automated generated item level validation procedure.
285 -- The actual validation detail is needed to be added.
286 -- 2. Validate the unique keys, lookups here
287 -- End of Comments
288
289 PROCEDURE Check_Entity_Attr_Items (
290 p_entity_attr_rec IN entity_attr_rec_type
291 ,p_validation_mode IN VARCHAR2
292 ,x_return_status OUT NOCOPY VARCHAR2
293 );
294
295
296 -- Start of Comments
297 --
298 -- Record level validation procedures
299 --
300 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
301 -- For create: G_CREATE, for update: G_UPDATE
302 -- Note: 1. This is automated generated item level validation procedure.
303 -- The actual validation detail is needed to be added.
304 -- 2. Developer can manually added inter-field level validation.
305 -- End of Comments
306
307 PROCEDURE Validate_Entity_Attr_Rec(
308 p_api_version_number IN NUMBER
309 ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
310 ,x_return_status OUT NOCOPY VARCHAR2
311 ,x_msg_count OUT NOCOPY NUMBER
312 ,x_msg_data OUT NOCOPY VARCHAR2
313 ,p_entity_attr_rec IN entity_attr_rec_type
314 ,p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.G_UPDATE
315 );
316
317
318 PROCEDURE Validate_sql_text(
319 p_api_version_number IN NUMBER
320 ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
321 ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
322 ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
323 ,x_return_status OUT NOCOPY VARCHAR2
324 ,x_msg_count OUT NOCOPY NUMBER
325 ,x_msg_data OUT NOCOPY VARCHAR2
326
327 ,p_sql_text IN VARCHAR2
328 ,p_entity IN VARCHAR2
329
330 );
331
332 PROCEDURE Validate_Lov_String(
333 p_api_version_number IN NUMBER
334 ,p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE
335 ,p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
336 ,p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL
337 ,x_return_status OUT NOCOPY VARCHAR2
338 ,x_msg_count OUT NOCOPY NUMBER
339 ,x_msg_data OUT NOCOPY VARCHAR2
340
341 ,p_lov_string IN VARCHAR2
342 ,p_entity IN VARCHAR2
343 ,p_attribute_id IN NUMBER
344 ,x_lov_result OUT NOCOPY VARCHAR2
345 );
346
347 END Pv_Entity_Attribute_Pvt;