1 PACKAGE PV_Attribute_PVT AS
2 /* $Header: pvxvatss.pls 120.0 2005/05/27 16:12:54 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Attribute_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
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 -- attribute_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- attribute_id
26 -- last_update_date
27 -- last_updated_by
28 -- creation_date
29 -- created_by
30 -- last_update_login
31 -- object_version_number
32 -- --security_group_id
33 -- enabled_flag
34 -- attribute_type
35 -- attribute_category
36 -- seeded_flag
37 -- lov_function_name
38 -- return_type
39 -- max_value_flag
40 -- name
41 -- description
42 -- short_name
43 -- display_style
44 -- character_width
45 -- decimal_points
46 -- no_of_lines
47 -- expose_to_partner_flag
48 -- value_extn_return_type
49 -- enable_matching_flag
50 -- performance_flag
51 -- additive_flag
52 -- sequence_number
53 --
54 -- Required
55 --
56 -- Defaults
57 --
58 -- Note: This is automatic generated record definition, it includes all columns
59 -- defined in the table, developer must manually add or delete some of the attributes.
60 --
61 -- End of Comments
62
63 --===================================================================
64 TYPE attribute_rec_type IS RECORD
65 (
66 attribute_id NUMBER := FND_API.G_MISS_NUM
67 ,last_update_date DATE := FND_API.G_MISS_DATE
68 ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69 ,creation_date DATE := FND_API.G_MISS_DATE
70 ,created_by NUMBER := FND_API.G_MISS_NUM
71 ,last_update_login NUMBER := FND_API.G_MISS_NUM
72 ,object_version_number NUMBER := FND_API.G_MISS_NUM
73 --,security_group_id NUMBER := FND_API.G_MISS_NUM
74 ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75 ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76 ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77 ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78 ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79 ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80 ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81 ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82 ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83 ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84 ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85 ,character_width NUMBER := FND_API.G_MISS_NUM
86 ,decimal_points NUMBER := FND_API.G_MISS_NUM
87 ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88 ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89 ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90 ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91 ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92 ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93 ,sequence_number NUMBER := FND_API.G_MISS_NUM
94 );
95
96 g_miss_attribute_rec attribute_rec_type;
97 TYPE attribute_tbl_type IS TABLE OF attribute_rec_type INDEX BY BINARY_INTEGER;
98 g_miss_attribute_tbl attribute_tbl_type;
99
100 -- ==============================================================================
101 -- Start of Comments
102 -- ==============================================================================
103 -- API Name
104 -- Create_Attribute
105 -- Type
106 -- Private
107 -- Pre-Req
108 --
109 -- Parameters
110 --
111 -- IN
112 -- p_api_version_number IN NUMBER Required
113 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
116 -- p_attribute_rec IN attribute_rec_type Required
117 --
118 -- OUT
119 -- x_return_status OUT VARCHAR2
120 -- x_msg_count OUT NUMBER
121 -- x_msg_data OUT VARCHAR2
122 -- Version : Current version 1.0
123 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
124 -- and basic operation, developer must manually add parameters and business logic as necessary.
125 --
126 -- End of Comments
127 -- ==============================================================================
128 --
129
130 PROCEDURE Create_Attribute(
131 p_api_version_number IN NUMBER
132 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
133 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
134 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
135
136 ,x_return_status OUT NOCOPY VARCHAR2
137 ,x_msg_count OUT NOCOPY NUMBER
138 ,x_msg_data OUT NOCOPY VARCHAR2
139
140 ,p_attribute_rec IN attribute_rec_type := g_miss_attribute_rec
141 ,x_attribute_id OUT NOCOPY NUMBER
142 );
143
144 -- ==============================================================================
145 -- Start of Comments
146 -- ==============================================================================
147 -- API Name
148 -- Update_Attribute
149 -- Type
150 -- Private
151 -- Pre-Req
152 --
153 -- Parameters
154 --
155 -- IN
156 -- p_api_version_number IN NUMBER Required
157 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
158 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
159 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
160 -- p_attribute_rec IN attribute_rec_type Required
161 --
162 -- OUT
163 -- x_return_status OUT VARCHAR2
164 -- x_msg_count OUT NUMBER
165 -- x_msg_data OUT VARCHAR2
166 -- Version : Current version 1.0
167 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
168 -- and basic operation, developer must manually add parameters and business logic as necessary.
169 --
170 -- End of Comments
171 -- ==============================================================================
172 --
173
174 PROCEDURE Update_Attribute(
175 p_api_version_number IN NUMBER
176 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
179
180 ,x_return_status OUT NOCOPY VARCHAR2
181 ,x_msg_count OUT NOCOPY NUMBER
182 ,x_msg_data OUT NOCOPY VARCHAR2
183
184 ,p_attribute_rec IN attribute_rec_type
185 ,x_object_version_number OUT NOCOPY NUMBER
186 );
187
188 -- ==============================================================================
189 -- Start of Comments
190 -- ==============================================================================
191 -- API Name
192 -- Delete_Attribute
193 -- Type
194 -- Private
195 -- Pre-Req
196 --
197 -- Parameters
198 --
199 -- IN
200 -- p_api_version_number IN NUMBER Required
201 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
202 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
203 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204 -- p_ATTRIBUTE_ID IN NUMBER
205 -- p_object_version_number IN NUMBER Optional Default = NULL
206 --
207 -- OUT
208 -- x_return_status OUT VARCHAR2
209 -- x_msg_count OUT NUMBER
210 -- x_msg_data OUT VARCHAR2
211 -- Version : Current version 1.0
212 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
213 -- and basic operation, developer must manually add parameters and business logic as necessary.
214 --
215 -- End of Comments
216 -- ==============================================================================
217 --
218
219 PROCEDURE Delete_Attribute(
220 p_api_version_number IN NUMBER
221 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
222 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
223 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
224 ,x_return_status OUT NOCOPY VARCHAR2
225 ,x_msg_count OUT NOCOPY NUMBER
226 ,x_msg_data OUT NOCOPY VARCHAR2
227 ,p_attribute_id IN NUMBER
228 ,p_object_version_number IN NUMBER
229 );
230
231 -- ==============================================================================
232 -- Start of Comments
233 -- ==============================================================================
234 -- API Name
235 -- Lock_Attribute
236 -- Type
237 -- Private
238 -- Pre-Req
239 --
240 -- Parameters
241 --
242 -- IN
243 -- p_api_version_number IN NUMBER Required
244 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
245 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
246 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
247 -- p_attribute_rec IN attribute_rec_type Required
248 --
249 -- OUT
250 -- x_return_status OUT VARCHAR2
251 -- x_msg_count OUT NUMBER
252 -- x_msg_data OUT VARCHAR2
253 -- Version : Current version 1.0
254 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
255 -- and basic operation, developer must manually add parameters and business logic as necessary.
256 --
257 -- End of Comments
258 -- ==============================================================================
259 --
260
261 PROCEDURE Lock_Attribute(
262 p_api_version_number IN NUMBER
263 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
264
265 ,x_return_status OUT NOCOPY VARCHAR2
266 ,x_msg_count OUT NOCOPY NUMBER
267 ,x_msg_data OUT NOCOPY VARCHAR2
268
269 ,p_attribute_id IN NUMBER
270 ,p_object_version IN NUMBER
271 );
272
273
274 -- Start of Comments
275 --
276 -- validation procedures
277 --
278 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
279 -- For create: G_CREATE, for update: G_UPDATE
280 -- Note: 1. This is automated generated item level validation procedure.
281 -- The actual validation detail is needed to be added.
282 -- 2. We can also validate table instead of record. There will be an option for user to choose.
283 -- End of Comments
284
285 PROCEDURE Validate_attribute(
286 p_api_version_number IN NUMBER
287 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
288 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
289 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_UPDATE
290 ,p_attribute_rec IN attribute_rec_type
291 ,x_return_status OUT NOCOPY VARCHAR2
292 ,x_msg_count OUT NOCOPY NUMBER
293 ,x_msg_data OUT NOCOPY VARCHAR2
294 );
295
296 -- Start of Comments
297 --
298 -- 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. Validate the unique keys, lookups here
305 -- End of Comments
306
307 PROCEDURE Check_attribute_Items (
308 p_attribute_rec IN attribute_rec_type
309 ,p_validation_mode IN VARCHAR2
310 ,x_return_status OUT NOCOPY VARCHAR2
311 );
312
313 -- Start of Comments
314 --
315 -- Record level validation procedures
316 --
317 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
318 -- For create: G_CREATE, for update: G_UPDATE
319 -- Note: 1. This is automated generated item level validation procedure.
320 -- The actual validation detail is needed to be added.
321 -- 2. Developer can manually added inter-field level validation.
322 -- End of Comments
323
324 PROCEDURE Validate_attribute_rec(
325 p_api_version_number IN NUMBER
326 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
327 ,x_return_status OUT NOCOPY VARCHAR2
328 ,x_msg_count OUT NOCOPY NUMBER
332 );
329 ,x_msg_data OUT NOCOPY VARCHAR2
330 ,p_attribute_rec IN attribute_rec_type
331 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_UPDATE
333 END PV_Attribute_PVT;