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