1 PACKAGE PV_BATCH_CHG_PRTNR_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvchps.pls 115.0 2003/10/15 04:03:02 rdsharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Batch_Chg_Prtnrs_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 -- Batch_Chg_Prtnrs_REC_TYPE
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- partner_id
29 -- vad_partner_id
30 -- last_update_date
31 -- last_update_by
32 -- creation_date
33 -- created_by
34 -- last_update_login
35 -- object_version_number
36 -- request_id
37 -- program_application_id
38 -- program_id
39 -- program_update_date
40 -- processed_flag
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 Batch_Chg_Prtnrs_Rec_Type IS RECORD
53 (
54 partner_id NUMBER,
55 vad_partner_id NUMBER,
56 last_update_date DATE,
57 last_update_by NUMBER,
58 creation_date DATE,
59 created_by NUMBER,
60 last_update_login NUMBER,
61 object_version_number NUMBER,
62 request_id NUMBER,
63 program_application_id NUMBER,
64 program_id NUMBER,
65 program_update_date DATE,
66 processed_flag VARCHAR2(1)
67 );
68
69 g_miss_Batch_Chg_Prtnrs_rec Batch_Chg_Prtnrs_rec_type := NULL;
70 TYPE Batch_Chg_Prtnrs_tbl_type IS TABLE OF Batch_Chg_Prtnrs_rec_type INDEX BY BINARY_INTEGER;
71 g_miss_Batch_Chg_Prtnrs_tbl Batch_Chg_Prtnrs_tbl_type;
72
73 -- ==============================================================================
74 -- Start of Comments
75 -- ==============================================================================
76 -- API Name
77 -- Create_Batch_Chg_Partners
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_Batch_Chg_Prtnrs_rec IN Batch_Chg_Prtnrs_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 -- History
100 --
101 -- NOTE
102 --
103 -- End of Comments
104 -- ==============================================================================
105
106 PROCEDURE Create_Batch_Chg_Partners(
107 p_api_version_number IN NUMBER,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE,
110 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115
116 p_batch_chg_prtnrs_rec IN Batch_Chg_Prtnrs_Rec_Type := g_miss_Batch_Chg_Prtnrs_rec,
117 x_partner_id OUT NOCOPY NUMBER
118 );
119
120 -- ==============================================================================
121 -- Start of Comments
122 -- ==============================================================================
123 -- API Name
124 -- Update_Batch_Chg_Partners
125 -- Type
126 -- Private
127 -- Pre-Req
128 --
129 -- Parameters
130 --
131 -- IN
132 -- p_api_version_number IN NUMBER Required
133 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
136 -- p_Batch_Chg_Prtnrs_rec IN Batch_Chg_Prtnrs_REC_TYPE Required
137 --
138 -- OUT
139 -- x_return_status OUT VARCHAR2
140 -- x_msg_count OUT NUMBER
141 -- x_msg_data OUT VARCHAR2
142 -- Version : Current version 1.0
143 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
144 -- and basic operation, developer must manually add parameters and business logic as necessary.
145 --
146 -- History
147 --
148 -- NOTE
149 --
150 -- End of Comments
151 -- ==============================================================================
152
153 PROCEDURE Update_Batch_Chg_Partners(
154 p_api_version_number IN NUMBER,
155 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
156 p_commit IN VARCHAR2 := FND_API.G_FALSE,
157 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162
163 p_Batch_Chg_Prtnrs_rec IN Batch_Chg_Prtnrs_REC_TYPE
164 );
165
166 -- ==============================================================================
167 -- Start of Comments
168 -- ==============================================================================
169 -- API Name
170 -- Delete_Batch_Chg_Prtnrs
171 -- Type
172 -- Private
173 -- Pre-Req
174 --
175 -- Parameters
176 --
177 -- IN
178 -- p_api_version_number IN NUMBER Required
179 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182 -- p_partner_id IN NUMBER
183 -- p_object_version_number IN NUMBER Optional Default = NULL
184 --
185 -- OUT
186 -- x_return_status OUT VARCHAR2
187 -- x_msg_count OUT NUMBER
188 -- x_msg_data OUT VARCHAR2
189 -- Version : Current version 1.0
190 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
191 -- and basic operation, developer must manually add parameters and business logic as necessary.
192 --
193 -- History
194 --
195 -- NOTE
196 --
197 -- End of Comments
198 -- ==============================================================================
199
200 PROCEDURE Delete_Batch_Chg_Prtnrs(
201 p_api_version_number IN NUMBER,
202 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203 p_commit IN VARCHAR2 := FND_API.G_FALSE,
204 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_partner_id IN NUMBER,
209 p_object_version_number IN NUMBER
210 );
211
212 -- ==============================================================================
213 -- Start of Comments
214 -- ==============================================================================
215 -- API Name
216 -- Lock_Batch_Chg_Prtnrs
217 -- Type
218 -- Private
219 -- Pre-Req
220 --
221 -- Parameters
222 --
223 -- IN
224 -- p_api_version_number IN NUMBER Required
225 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
226 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
227 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
228 -- p_Batch_Chg_Prtnrs_rec IN Batch_Chg_Prtnrs_rec_type Required
229 --
230 -- OUT
231 -- x_return_status OUT VARCHAR2
232 -- x_msg_count OUT NUMBER
233 -- x_msg_data OUT VARCHAR2
234 -- Version : Current version 1.0
235 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
236 -- and basic operation, developer must manually add parameters and business logic as necessary.
237 --
238 -- History
239 --
240 -- NOTE
241 --
242 -- End of Comments
243 -- ==============================================================================
244
248
245 PROCEDURE Lock_Batch_Chg_Prtnrs(
246 p_api_version_number IN NUMBER,
247 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2,
252
253 p_partner_id IN NUMBER,
254 p_object_version IN NUMBER
255 );
256
257
258 -- ==============================================================================
259 -- Start of Comments
260 -- ==============================================================================
261 -- API Name
262 -- Validate_Batch_Chg_Prtnrs
263 --
264 -- Version : Current version 1.0
265 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
266 -- For create: G_CREATE, for update: G_UPDATE
267 -- Note: 1. This is automated generated item level validation procedure.
268 -- The actual validation detail is needed to be added.
269 -- 2. We can also validate table instead of record. There will be an option for user to choose.
270 --
271 -- History
272 --
273 -- NOTE
274 --
275 -- End of Comments
276 -- ==============================================================================
277
278
279 PROCEDURE Validate_Batch_Chg_Partners(
280 p_api_version_number IN NUMBER,
281 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
283 p_Batch_Chg_Prtnrs_rec IN Batch_Chg_Prtnrs_rec_type,
284 p_validation_mode IN VARCHAR2,
285 x_return_status OUT NOCOPY VARCHAR2,
286 x_msg_count OUT NOCOPY NUMBER,
287 x_msg_data OUT NOCOPY VARCHAR2
288 );
289
290 -- ==============================================================================
291 -- Start of Comments
292 -- ==============================================================================
293 -- API Name
294 -- Batch_Chg_Prtnrs_Items
295 --
296 -- Version : Current version 1.0
297 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
298 -- For create: G_CREATE, for update: G_UPDATE
299 -- Note: 1. This is automated generated item level validation procedure.
300 -- The actual validation detail is needed to be added.
301 -- 2. Validate the unique keys, lookups here
302 --
303 -- History
304 --
305 -- NOTE
306 --
307 -- End of Comments
308 -- ==============================================================================
309
310
311 PROCEDURE Check_Batch_Chg_Prtnrs_Items (
312 p_Batch_Chg_Prtnrs_rec IN Batch_Chg_Prtnrs_REC_TYPE,
313 p_validation_mode IN VARCHAR2,
314 x_return_status OUT NOCOPY VARCHAR2
315 );
316
317 -- ==============================================================================
318 -- Start of Comments
319 -- ==============================================================================
320 -- API Name
321 -- Validate_Batch_Chg_Prtnrs_Rec
322 --
323 -- Version : Current version 1.0
324 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
325 -- For create: G_CREATE, for update: G_UPDATE
326 -- Note: 1. This is automated generated item level validation procedure.
327 -- The actual validation detail is needed to be added.
328 -- 2. Developer can manually added inter-field level validation.
329 --
330 -- History
331 --
332 -- NOTE
333 --
334 -- End of Comments
335 -- ==============================================================================
336
337
338 PROCEDURE Validate_Batch_Chg_Prtnrs_Rec (
339 p_api_version_number IN NUMBER,
340 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
341 x_return_status OUT NOCOPY VARCHAR2,
342 x_msg_count OUT NOCOPY NUMBER,
343 x_msg_data OUT NOCOPY VARCHAR2,
344 p_Batch_Chg_Prtnrs_rec IN Batch_Chg_Prtnrs_REC_TYPE
345 );
346 END PV_BATCH_CHG_PRTNR_PVT;
[Home] [Help]