1 PACKAGE AMS_Dm_Target_Sources_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvdtss.pls 115.3 2004/06/16 12:27:37 rosharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Dm_Target_Sources_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 -- target_source_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- target_source_id
29 -- last_update_date
30 -- last_updated_by
31 -- creation_date
32 -- created_by
33 -- last_update_login
34 -- object_version_number
35 -- target_id
36 -- data_source_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 --===================================================================
48 TYPE target_source_rec_type IS RECORD
49 (
50 target_source_id NUMBER,
51 last_update_date DATE,
52 last_updated_by NUMBER,
53 creation_date DATE,
54 created_by NUMBER,
55 last_update_login NUMBER,
56 object_version_number NUMBER,
57 target_id NUMBER,
58 data_source_id NUMBER
59 );
60
61 g_miss_target_source_rec target_source_rec_type := NULL;
62 TYPE target_source_tbl_type IS TABLE OF target_source_rec_type INDEX BY BINARY_INTEGER;
63 g_miss_target_source_tbl target_source_tbl_type;
64
65 -- ==============================================================================
66 -- Start of Comments
67 -- ==============================================================================
68 -- API Name
69 -- Create_Dm_Target_Sources
70 -- Type
71 -- Private
72 -- Pre-Req
73 --
74 -- Parameters
75 --
76 -- IN
77 -- p_api_version_number IN NUMBER Required
78 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
81 -- p_target_source_rec_type_rec IN target_source_rec_type Required
82 --
83 -- OUT
84 -- x_return_status OUT NOCOPY VARCHAR2
85 -- x_msg_count OUT NOCOPY NUMBER
86 -- x_msg_data OUT NOCOPY VARCHAR2
87 -- Version : Current version 1.0
88 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
89 -- and basic operation, developer must manually add parameters and business logic as necessary.
90 --
91 -- History
92 --
93 -- NOTE
94 --
95 -- End of Comments
96 -- ==============================================================================
97
98 PROCEDURE Create_Dm_Target_Sources(
99 p_api_version_number IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107
108 p_target_source_rec_type_rec IN target_source_rec_type := g_miss_target_source_rec,
109 x_target_source_id OUT NOCOPY NUMBER
110 );
111
112 -- ==============================================================================
113 -- Start of Comments
114 -- ==============================================================================
115 -- API Name
116 -- Update_Dm_Target_Sources
117 -- Type
118 -- Private
119 -- Pre-Req
120 --
121 -- Parameters
122 --
123 -- IN
124 -- p_api_version_number IN NUMBER Required
125 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128 -- p_target_source_rec_type_rec IN target_source_rec_type Required
129 --
130 -- OUT
131 -- x_return_status OUT NOCOPY VARCHAR2
132 -- x_msg_count OUT NOCOPY NUMBER
133 -- x_msg_data OUT NOCOPY VARCHAR2
134 -- Version : Current version 1.0
135 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
136 -- and basic operation, developer must manually add parameters and business logic as necessary.
137 --
138 -- History
139 --
140 -- NOTE
141 --
142 -- End of Comments
143 -- ==============================================================================
144
145 PROCEDURE Update_Dm_Target_Sources(
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_target_source_rec_type_rec IN target_source_rec_type
156 );
157
158 -- ==============================================================================
159 -- Start of Comments
160 -- ==============================================================================
161 -- API Name
162 -- Delete_Dm_Target_Sources
163 -- Type
164 -- Private
165 -- Pre-Req
166 --
167 -- Parameters
168 --
169 -- IN
170 -- p_api_version_number IN NUMBER Required
171 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174 -- p_target_source_id IN NUMBER
175 -- p_object_version_number IN NUMBER Optional Default = NULL
176 --
177 -- OUT
178 -- x_return_status OUT NOCOPY VARCHAR2
179 -- x_msg_count OUT NOCOPY NUMBER
180 -- x_msg_data OUT NOCOPY VARCHAR2
181 -- Version : Current version 1.0
182 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
183 -- and basic operation, developer must manually add parameters and business logic as necessary.
184 --
185 -- History
186 --
187 -- NOTE
188 --
189 -- End of Comments
190 -- ==============================================================================
191
192 PROCEDURE Delete_Dm_Target_Sources(
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_source_id IN NUMBER,
201 p_object_version_number IN NUMBER
202 );
203
204 -- ==============================================================================
205 -- Start of Comments
206 -- ==============================================================================
207 -- API Name
208 -- Lock_Dm_Target_Sources
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_target_source_rec_type_rec IN target_source_rec_type Required
221 --
222 -- OUT
223 -- x_return_status OUT NOCOPY VARCHAR2
224 -- x_msg_count OUT NOCOPY NUMBER
225 -- x_msg_data OUT NOCOPY 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 -- History
231 --
232 -- NOTE
233 --
234 -- End of Comments
235 -- ==============================================================================
236
237 PROCEDURE Lock_Dm_Target_Sources(
238 p_api_version_number IN NUMBER,
239 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244
245 p_target_source_id IN NUMBER,
246 p_object_version IN NUMBER
247 );
248
249
250 -- ==============================================================================
251 -- Start of Comments
252 -- ==============================================================================
253 -- API Name
254 -- Validate_Dm_Target_Sources
255 --
256 -- Version : Current version 1.0
257 -- p_validation_mode is a constant defined in AMS_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 --
263 -- History
264 --
265 -- NOTE
266 --
267 -- End of Comments
268 -- ==============================================================================
269
270
271 PROCEDURE Validate_Dm_Target_Sources(
272 p_api_version_number IN NUMBER,
273 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275 p_target_source_rec_type_rec IN target_source_rec_type,
276 p_validation_mode IN VARCHAR2,
277 x_return_status OUT NOCOPY VARCHAR2,
278 x_msg_count OUT NOCOPY NUMBER,
279 x_msg_data OUT NOCOPY VARCHAR2
280 );
281
282 -- ==============================================================================
283 -- Start of Comments
284 -- ==============================================================================
285 -- API Name
286 -- Target_Source_Rec_Type_Items
287 --
288 -- Version : Current version 1.0
289 -- p_validation_mode is a constant defined in AMS_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. Validate the unique keys, lookups here
294 --
295 -- History
296 --
297 -- NOTE
298 --
299 -- End of Comments
300 -- ==============================================================================
301
302
303 PROCEDURE Check_Target_Source_Items (
304 P_target_source_rec_type_rec IN target_source_rec_type,
305 p_validation_mode IN VARCHAR2,
306 x_return_status OUT NOCOPY VARCHAR2
307 );
308
309 -- ==============================================================================
310 -- Start of Comments
311 -- ==============================================================================
312 -- API Name
313 -- Validate_Target_Source_Rec
314 --
315 -- Version : Current version 1.0
316 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
317 -- For create: G_CREATE, for update: G_UPDATE
318 -- Note: 1. This is automated generated item level validation procedure.
319 -- The actual validation detail is needed to be added.
320 -- 2. Developer can manually added inter-field level validation.
321 --
322 -- History
323 --
324 -- NOTE
325 --
326 -- End of Comments
327 -- ==============================================================================
328
329
330 PROCEDURE Validate_Target_Source_Rec (
331 p_api_version_number IN NUMBER,
332 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
333 p_validation_mode IN VARCHAR2,
334 x_return_status OUT NOCOPY VARCHAR2,
335 x_msg_count OUT NOCOPY NUMBER,
336 x_msg_data OUT NOCOPY VARCHAR2,
337 p_target_source_rec_type_rec IN target_source_rec_type
338 );
339
340 PROCEDURE delete_tgtsources_for_target (
341 p_target_id IN NUMBER
342 );
343
344 END AMS_Dm_Target_Sources_PVT;