1 PACKAGE AMS_Dm_Imp_Attribute_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvdias.pls 115.3 2002/12/09 11:05:06 choang noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Dm_Imp_Attribute_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- imp_attribute_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- imp_attribute_id
29 -- last_update_date
30 -- last_updated_by
31 -- creation_date
32 -- created_by
33 -- last_update_login
34 -- object_version_number
35 -- model_id
36 -- source_field_id
37 -- rank
38 -- value
39 -- source_field_name
40 --
41 -- Required
42 --
43 -- Defaults
44 --
45 -- Note: This is automatic generated record definition, it includes all columns
46 -- defined in the table, developer must manually add or delete some of the attributes.
47 --
48 -- End of Comments
49
50 --===================================================================
51 TYPE imp_attribute_rec_type IS RECORD
52 (
53 imp_attribute_id NUMBER,
54 last_update_date DATE,
55 last_updated_by NUMBER,
56 creation_date DATE,
57 created_by NUMBER,
58 last_update_login NUMBER,
59 object_version_number NUMBER,
60 model_id NUMBER,
61 source_field_id NUMBER,
62 rank NUMBER,
63 value NUMBER,
64 source_field_name VARCHAR2(120)
65 );
66
67 g_miss_imp_attribute_rec imp_attribute_rec_type := NULL;
68 TYPE imp_attribute_tbl_type IS TABLE OF imp_attribute_rec_type INDEX BY BINARY_INTEGER;
69 g_miss_imp_attribute_tbl imp_attribute_tbl_type;
70
71 -- ==============================================================================
72 -- Start of Comments
73 -- ==============================================================================
74 -- API Name
75 -- Create_Imp_Attribute
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_imp_attribute_rec IN imp_attribute_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 -- History
98 --
99 -- NOTE
100 --
101 -- End of Comments
102 -- ==============================================================================
103
104 PROCEDURE Create_Imp_Attribute(
105 p_api_version_number IN NUMBER,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107 p_commit IN VARCHAR2 := FND_API.G_FALSE,
108 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113
114 p_imp_attribute_rec IN imp_attribute_rec_type := g_miss_imp_attribute_rec,
115 x_Dm_Imp_Attribute_id OUT NOCOPY NUMBER
116 );
117
118 -- ==============================================================================
119 -- Start of Comments
120 -- ==============================================================================
121 -- API Name
122 -- Update_Imp_Attribute
123 -- Type
124 -- Private
125 -- Pre-Req
126 --
127 -- Parameters
128 --
129 -- IN
130 -- p_api_version_number IN NUMBER Required
131 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134 -- p_imp_attribute_rec IN imp_attribute_rec_type Required
135 --
136 -- OUT
137 -- x_return_status OUT VARCHAR2
138 -- x_msg_count OUT NUMBER
139 -- x_msg_data OUT VARCHAR2
140 -- Version : Current version 1.0
141 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
142 -- and basic operation, developer must manually add parameters and business logic as necessary.
143 --
144 -- History
145 --
146 -- NOTE
147 --
148 -- End of Comments
149 -- ==============================================================================
150
151 PROCEDURE Update_Imp_Attribute(
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_imp_attribute_rec IN imp_attribute_rec_type,
162 x_object_version_number OUT NOCOPY NUMBER
163 );
164
165 -- ==============================================================================
166 -- Start of Comments
167 -- ==============================================================================
168 -- API Name
169 -- Delete_Imp_Attribute
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_Dm_Imp_Attribute_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 -- History
193 --
194 -- NOTE
195 --
196 -- End of Comments
197 -- ==============================================================================
198
199 PROCEDURE Delete_Imp_Attribute(
200 p_api_version_number IN NUMBER,
201 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202 p_commit IN VARCHAR2 := FND_API.G_FALSE,
203 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_Dm_Imp_Attribute_id IN NUMBER,
208 p_object_version_number IN NUMBER
209 );
210
211 -- ==============================================================================
212 -- Start of Comments
213 -- ==============================================================================
214 -- API Name
215 -- Lock_Imp_Attribute
216 -- Type
217 -- Private
218 -- Pre-Req
219 --
220 -- Parameters
221 --
222 -- IN
223 -- p_api_version_number IN NUMBER Required
224 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
225 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
226 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
227 -- p_imp_attribute_rec IN imp_attribute_rec_type Required
228 --
229 -- OUT
230 -- x_return_status OUT VARCHAR2
231 -- x_msg_count OUT NUMBER
232 -- x_msg_data OUT VARCHAR2
233 -- Version : Current version 1.0
234 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
235 -- and basic operation, developer must manually add parameters and business logic as necessary.
236 --
237 -- History
238 --
239 -- NOTE
240 --
241 -- End of Comments
242 -- ==============================================================================
243
244 PROCEDURE Lock_Imp_Attribute(
245 p_api_version_number IN NUMBER,
246 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
247
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251
252 p_Dm_Imp_Attribute_id IN NUMBER,
253 p_object_version IN NUMBER
254 );
255
256 -- ==============================================================================
257 -- Start of Comments
258 -- ==============================================================================
259 -- API Name
260 -- Validate_Imp_Attribute
261 --
262 -- Version : Current version 1.0
263 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
264 -- For create: G_CREATE, for update: G_UPDATE
265 -- Note: 1. This is automated generated item level validation procedure.
266 -- The actual validation detail is needed to be added.
267 -- 2. We can also validate table instead of record. There will be an option for user to choose.
268 --
269 -- History
270 --
271 -- NOTE
272 --
273 -- End of Comments
274 -- ==============================================================================
275
276
277 PROCEDURE Validate_Imp_Attribute(
278 p_api_version_number IN NUMBER,
279 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281 p_imp_attribute_rec IN imp_attribute_rec_type,
282 p_validation_mode IN VARCHAR2,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2
286 );
287
288 -- ==============================================================================
289 -- Start of Comments
290 -- ==============================================================================
291 -- API Name
292 -- Imp_Attribute_Rec_Type_Items
293 --
294 -- Version : Current version 1.0
295 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
296 -- For create: G_CREATE, for update: G_UPDATE
297 -- Note: 1. This is automated generated item level validation procedure.
298 -- The actual validation detail is needed to be added.
299 -- 2. Validate the unique keys, lookups here
300 --
301 -- History
302 --
303 -- NOTE
304 --
305 -- End of Comments
306 -- ==============================================================================
307
308
309 PROCEDURE Check_Imp_Attribute_Items (
310 P_imp_attribute_rec IN imp_attribute_rec_type,
311 p_validation_mode IN VARCHAR2,
312 x_return_status OUT NOCOPY VARCHAR2
313 );
314
315 -- ==============================================================================
316 -- Start of Comments
317 -- ==============================================================================
318 -- API Name
319 -- Validate_imp_attribute_rec
320 --
321 -- Version : Current version 1.0
322 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
323 -- For create: G_CREATE, for update: G_UPDATE
324 -- Note: 1. This is automated generated item level validation procedure.
325 -- The actual validation detail is needed to be added.
326 -- 2. Developer can manually added inter-field level validation.
327 --
328 -- History
329 --
330 -- NOTE
331 --
332 -- End of Comments
333 -- ==============================================================================
334
335
336 PROCEDURE Validate_imp_attribute_rec (
337 p_api_version_number IN NUMBER,
338 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339 x_return_status OUT NOCOPY VARCHAR2,
340 x_msg_count OUT NOCOPY NUMBER,
341 x_msg_data OUT NOCOPY VARCHAR2,
342 p_imp_attribute_rec IN imp_attribute_rec_type
343 );
344 END AMS_Dm_Imp_Attribute_PVT;