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