1 PACKAGE AMS_DM_TARGET_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvdtgs.pls 120.0 2005/05/31 14:39:13 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_DM_TARGET_PVT
7 -- Purpose
8 --
9 -- History
10 -- 10-Apr-2002 nyostos Created.
11 --
12 -- NOTE
13 --
14 -- End of Comments
15 -- ===============================================================
16
17 -- Default number of records fetch per call
18 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
19 --===================================================================
20 -- Start of Comments
21 -- -------------------------------------------------------
22 -- Record name
23 -- dm_target_rec_type
24 -- -------------------------------------------------------
25 -- Parameters:
26 -- target_id
27 -- last_update_date
28 -- last_updated_by
29 -- creation_date
30 -- created_by
31 -- last_update_login
32 -- object_version_number
33 -- active_flag
34 -- model_type
35 -- data_source_id
36 -- source_field_id
37 -- target_name
38 -- description
39 -- target_source_id
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 dm_target_rec_type IS RECORD
52 (
53 target_id NUMBER := FND_API.G_MISS_NUM,
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 active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
61 model_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62 data_source_id NUMBER := FND_API.G_MISS_NUM,
63 source_field_id NUMBER := FND_API.G_MISS_NUM,
64 target_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65 description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
66 target_source_id NUMBER := FND_API.G_MISS_NUM
67 );
68
69 g_miss_dm_target_rec dm_target_rec_type;
70 TYPE dm_target_tbl_type IS TABLE OF dm_target_rec_type INDEX BY BINARY_INTEGER;
71 g_miss_dm_target_tbl dm_target_tbl_type;
72
73 -- ==============================================================================
74 -- Start of Comments
75 -- ==============================================================================
76 -- API Name
77 -- Create_Dmtarget
78 -- Type
79 -- Private
80 -- Pre-Req
81 --
82 -- Parameters
83 --
84 -- IN
85 -- p_api_version_number IN NUMBER Required
86 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
87 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
88 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
89 -- p_dm_target_rec IN dm_target_rec_type Required
90 --
91 -- OUT
92 -- x_return_status OUT VARCHAR2
93 -- x_msg_count OUT NUMBER
94 -- x_msg_data OUT VARCHAR2
95 -- Version : Current version 1.0
96 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
97 -- and basic operation, developer must manually add parameters and business logic as necessary.
98 --
99 -- End of Comments
100 -- ==============================================================================
101 --
102
103 PROCEDURE Create_Dmtarget(
104 p_api_version_number IN NUMBER,
105 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
106 p_commit IN VARCHAR2 := FND_API.G_FALSE,
107 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112
113 p_dm_target_rec IN dm_target_rec_type := g_miss_dm_target_rec,
114 x_target_id OUT NOCOPY NUMBER
115 );
116
117 -- ==============================================================================
118 -- Start of Comments
119 -- ==============================================================================
120 -- API Name
121 -- Update_Dmtarget
122 -- Type
123 -- Private
124 -- Pre-Req
125 --
126 -- Parameters
127 --
128 -- IN
129 -- p_api_version_number IN NUMBER Required
130 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133 -- p_dm_target_rec IN dm_target_rec_type Required
134 --
135 -- OUT
136 -- x_return_status OUT VARCHAR2
137 -- x_msg_count OUT NUMBER
138 -- x_msg_data OUT VARCHAR2
139 -- Version : Current version 1.0
140 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
141 -- and basic operation, developer must manually add parameters and business logic as necessary.
142 --
143 -- End of Comments
144 -- ==============================================================================
145 --
146
147 PROCEDURE Update_Dmtarget(
148 p_api_version_number IN NUMBER,
149 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150 p_commit IN VARCHAR2 := FND_API.G_FALSE,
151 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156
157 p_dm_target_rec IN dm_target_rec_type,
158 x_object_version_number OUT NOCOPY NUMBER
159 );
160
161 -- ==============================================================================
162 -- Start of Comments
163 -- ==============================================================================
164 -- API Name
165 -- Delete_Dmtarget
166 -- Type
167 -- Private
168 -- Pre-Req
169 --
170 -- Parameters
171 --
172 -- IN
173 -- p_api_version_number IN NUMBER Required
174 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177 -- p_TARGET_ID IN NUMBER
178 -- p_object_version_number IN NUMBER Optional Default = NULL
179 --
180 -- OUT
181 -- x_return_status OUT VARCHAR2
182 -- x_msg_count OUT NUMBER
183 -- x_msg_data OUT VARCHAR2
184 -- Version : Current version 1.0
185 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
186 -- and basic operation, developer must manually add parameters and business logic as necessary.
187 --
188 -- End of Comments
189 -- ==============================================================================
190 --
191
192 PROCEDURE Delete_Dmtarget(
193 p_api_version_number IN NUMBER,
194 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195 p_commit IN VARCHAR2 := FND_API.G_FALSE,
196 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_target_id IN NUMBER,
201 p_object_version_number IN NUMBER
202 );
203
204 -- ==============================================================================
205 -- Start of Comments
206 -- ==============================================================================
207 -- API Name
208 -- Lock_Dmtarget
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 -- p_dm_target_rec IN dm_target_rec_type Required
221 --
222 -- OUT
223 -- x_return_status OUT VARCHAR2
224 -- x_msg_count OUT NUMBER
225 -- x_msg_data OUT VARCHAR2
226 -- Version : Current version 1.0
227 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
228 -- and basic operation, developer must manually add parameters and business logic as necessary.
229 --
230 -- End of Comments
231 -- ==============================================================================
232 --
233
234 PROCEDURE Lock_Dmtarget(
235 p_api_version_number IN NUMBER,
236 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
237
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241
242 p_target_id IN NUMBER,
243 p_object_version IN NUMBER
244 );
245
246
247 -- Start of Comments
248 --
249 -- validation procedures
250 --
251 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
252 -- For create: G_CREATE, for update: G_UPDATE
253 -- Note: 1. This is automated generated item level validation procedure.
254 -- The actual validation detail is needed to be added.
255 -- 2. We can also validate table instead of record. There will be an option for user to choose.
256 -- End of Comments
257
258 PROCEDURE Validate_dmtarget(
259 p_api_version_number IN NUMBER,
260 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262 p_dm_target_rec IN dm_target_rec_type,
263 p_validation_mode IN VARCHAR2,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2
267 );
268
269 -- Start of Comments
270 --
271 -- validation procedures
272 --
273 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
274 -- For create: G_CREATE, for update: G_UPDATE
275 -- Note: 1. This is automated generated item level validation procedure.
276 -- The actual validation detail is needed to be added.
277 -- 2. Validate the unique keys, lookups here
278 -- End of Comments
279
280 PROCEDURE Check_dm_target_Items (
281 P_dm_target_rec IN dm_target_rec_type,
282 p_validation_mode IN VARCHAR2,
283 x_return_status OUT NOCOPY VARCHAR2
284 );
285
286 -- Start of Comments
287 --
288 -- Record level validation procedures
289 --
290 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
291 -- For create: G_CREATE, for update: G_UPDATE
292 -- Note: 1. This is automated generated item level validation procedure.
293 -- The actual validation detail is needed to be added.
294 -- 2. Developer can manually added inter-field level validation.
295 -- End of Comments
296
297 PROCEDURE Validate_dm_target_rec(
298 p_api_version_number IN NUMBER,
299 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300 x_return_status OUT NOCOPY VARCHAR2,
301 x_msg_count OUT NOCOPY NUMBER,
302 x_msg_data OUT NOCOPY VARCHAR2,
303 p_dm_target_rec IN dm_target_rec_type
304 );
305
306 -- ==============================================================================
307 -- Start of Comments
308 -- ==============================================================================
309 -- API Name
310 -- Handle_Data_Source_Disabling
311 -- Type
312 -- Private
313 -- Pre-Req
314 --
315 -- Parameters
316 --
317 -- IN
318 -- p_data_source_id IN NUMBER
319 --
320 -- Version : Current version 1.0
321 --
322 -- History
323 --
324 -- NOTE
325 --
326 -- End of Comments
327 -- ==============================================================================
328
329 PROCEDURE Handle_Data_Source_Disabling(
330 p_data_source_id IN NUMBER
331 );
332
333 -- ==============================================================================
334 -- Start of Comments
335 -- ==============================================================================
336 -- API Name
337 -- Handle_Data_Source_Enabling
338 -- Type
339 -- Private
340 -- Pre-Req
341 --
342 -- Parameters
343 --
344 -- IN
345 -- p_data_source_id IN NUMBER
346 --
347 -- Version : Current version 1.0
348 --
349 -- History
350 --
351 -- NOTE
352 --
353 -- End of Comments
354 -- ==============================================================================
355
356 PROCEDURE Handle_Data_Source_Enabling(
357 p_data_source_id IN NUMBER
358 );
359
360 -- ==============================================================================
361 -- Start of Comments
362 -- ==============================================================================
363 -- API Name
364 -- Handle_DS_Assoc_Enabling
365 -- Type
366 -- Private
367 -- Pre-Req
368 --
369 -- Parameters
370 --
371 -- IN
372 -- p_master_source_id IN NUMBER
373 -- p_sub_source_id IN NUMBER
374 --
375 -- Version : Current version 1.0
376 --
377 -- History
378 --
379 -- NOTE
380 --
381 -- End of Comments
382 -- ==============================================================================
383
384 PROCEDURE Handle_DS_Assoc_Enabling(
385 p_master_source_id IN NUMBER,
386 p_sub_source_id IN NUMBER
387 );
388
389 -- ==============================================================================
390 -- Start of Comments
391 -- ==============================================================================
392 -- API Name
393 -- Handle_DS_Assoc_Disabling
394 -- Type
395 -- Private
396 -- Pre-Req
397 --
398 -- Parameters
399 --
400 -- IN
401 -- p_master_source_id IN NUMBER
402 -- p_sub_source_id IN NUMBER
403 --
404 -- Version : Current version 1.0
405 --
406 -- History
407 --
408 -- NOTE
409 --
410 -- End of Comments
411 -- ==============================================================================
412
413 PROCEDURE Handle_DS_Assoc_Disabling(
414 p_master_source_id IN NUMBER,
415 p_sub_source_id IN NUMBER
416 );
417
418 PROCEDURE is_target_enabled(
419 p_target_id IN NUMBER,
420 x_is_enabled OUT NOCOPY BOOLEAN
421 );
422
423 -- ==============================================================================
424 -- Start of Comments
425 -- ==============================================================================
426 -- API Name
427 -- in_list
428 -- Type
429 -- Public
430 -- Pre-Req
431 --
432 -- Parameters
433 --
434 -- IN
435 -- p_string IN VARCHAR2 Required
436 --
437 -- OUT
438 -- None
439 --
440 -- Version : Current version 1.0
441 -- History
442 -- 11-May-2005 srivikri Created. Fix for bug 4360174
443 --
444 -- End of Comments
445 -- ==============================================================================
446 --
447
448 FUNCTION in_list ( p_string IN VARCHAR2 ) RETURN JTF_NUMBER_TABLE;
449
450 END AMS_DM_TARGET_PVT;