[Home] [Help]
PACKAGE: APPS.OZF_CLAIM_LINES_INT_PVT
Source
1 PACKAGE OZF_Claim_Lines_Int_PVT AS
2 /* $Header: ozfvclis.pls 120.1 2006/07/27 06:48:39 sshivali noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Claim_Lines_Int_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- SSHIVALI 27-Jul-2006 Bug5381478: Increased the column size for payment_reference_number.
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 -- claim_lines_int_rec_type
24 -- -------------------------------------------------------
25 -- Parameters:
26 -- interface_claim_line_id
27 -- object_version_number
28 -- last_update_date
29 -- last_updated_by
30 -- creation_date
31 -- created_by
32 -- last_update_login
33 -- request_id
34 -- program_application_id
35 -- program_update_date
36 -- program_id
37 -- created_from
38 -- interface_claim_id
39 -- line_number
40 -- split_from_claim_line_id
41 -- amount
42 -- claim_currency_amount
43 -- acctd_amount
44 -- currency_code
45 -- exchange_rate_type
46 -- exchange_rate_date
47 -- exchange_rate
48 -- set_of_books_id
49 -- valid_flag
50 -- source_object_id
51 -- source_object_class
52 -- source_object_type_id
53 -- source_object_line_id
54 -- plan_id
55 -- offer_id
56 -- utilization_id
57 -- payment_method
58 -- payment_reference_id
59 -- payment_reference_number
60 -- payment_reference_date
61 -- voucher_id
62 -- voucher_number
63 -- payment_status
64 -- approved_flag
65 -- approved_date
66 -- approved_by
67 -- settled_date
68 -- settled_by
69 -- performance_complete_flag
70 -- performance_attached_flag
71 -- attribute_category
72 -- attribute1
73 -- attribute2
74 -- attribute3
75 -- attribute4
76 -- attribute5
77 -- attribute6
78 -- attribute7
79 -- attribute8
80 -- attribute9
81 -- attribute10
82 -- attribute11
83 -- attribute12
84 -- attribute13
85 -- attribute14
86 -- attribute15
87 -- org_id
88 --
89 -- Required
90 --
91 -- Defaults
92 --
93 -- Note: This is automatic generated record definition, it includes all columns
94 -- defined in the table, developer must manually add or delete some of the attributes.
95 --
96 -- End of Comments
97
98 --===================================================================
99 TYPE claim_lines_int_rec_type IS RECORD
100 (
101 interface_claim_line_id NUMBER,
102 object_version_number NUMBER,
103 last_update_date DATE,
104 last_updated_by NUMBER,
105 creation_date DATE,
106 created_by NUMBER,
107 last_update_login NUMBER,
108 request_id NUMBER,
109 program_application_id NUMBER,
110 program_update_date DATE,
111 program_id NUMBER,
112 created_from VARCHAR2(30),
113 interface_claim_id NUMBER,
114 line_number NUMBER,
115 split_from_claim_line_id NUMBER,
116 amount NUMBER,
117 claim_currency_amount NUMBER,
118 acctd_amount NUMBER,
119 currency_code VARCHAR2(15),
120 exchange_rate_type VARCHAR2(30),
121 exchange_rate_date DATE,
122 exchange_rate NUMBER,
123 set_of_books_id NUMBER,
124 valid_flag VARCHAR2(1),
125 source_object_id NUMBER,
126 source_object_class VARCHAR2(15),
127 source_object_type_id NUMBER,
128 source_object_line_id NUMBER,
129 plan_id NUMBER,
130 offer_id NUMBER,
131 utilization_id NUMBER,
132 payment_method VARCHAR2(15),
133 payment_reference_id NUMBER,
134 payment_reference_number VARCHAR2(30),
135 payment_reference_date DATE,
136 voucher_id NUMBER,
137 voucher_number VARCHAR2(30),
138 payment_status VARCHAR2(10),
139 approved_flag VARCHAR2(1),
140 approved_date DATE,
141 approved_by NUMBER,
142 settled_date DATE,
143 settled_by NUMBER,
144 performance_complete_flag VARCHAR2(1),
145 performance_attached_flag VARCHAR2(1),
146 attribute_category VARCHAR2(30),
147 attribute1 VARCHAR2(150),
148 attribute2 VARCHAR2(150),
149 attribute3 VARCHAR2(150),
150 attribute4 VARCHAR2(150),
151 attribute5 VARCHAR2(150),
152 attribute6 VARCHAR2(150),
153 attribute7 VARCHAR2(150),
154 attribute8 VARCHAR2(150),
155 attribute9 VARCHAR2(150),
156 attribute10 VARCHAR2(150),
157 attribute11 VARCHAR2(150),
158 attribute12 VARCHAR2(150),
159 attribute13 VARCHAR2(150),
160 attribute14 VARCHAR2(150),
161 attribute15 VARCHAR2(150),
162 org_id NUMBER
163 );
164
165 g_miss_claim_lines_int_rec claim_lines_int_rec_type;
166 TYPE claim_lines_int_tbl_type IS TABLE OF claim_lines_int_rec_type INDEX BY BINARY_INTEGER;
167 g_miss_claim_lines_int_tbl claim_lines_int_tbl_type;
168
169 -- ==============================================================================
170 -- Start of Comments
171 -- ==============================================================================
172 -- API Name
173 -- Create_Claim_Lines_Int
174 -- Type
175 -- Private
176 -- Pre-Req
177 --
178 -- Parameters
179 --
180 -- IN
181 -- p_api_version_number IN NUMBER Required
182 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185 -- p_claim_lines_int_rec IN claim_lines_int_rec_type Required
186 --
187 -- OUT
188 -- x_return_status OUT VARCHAR2
189 -- x_msg_count OUT NUMBER
190 -- x_msg_data OUT VARCHAR2
191 -- Version : Current version 1.0
192 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
193 -- and basic operation, developer must manually add parameters and business logic as necessary.
194 --
195 -- End of Comments
196 -- ==============================================================================
197 --
198
199 PROCEDURE Create_Claim_Lines_Int(
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
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208
209 p_claim_lines_int_rec IN claim_lines_int_rec_type := g_miss_claim_lines_int_rec,
210 x_interface_claim_line_id OUT NOCOPY NUMBER
211 );
212
213 -- ==============================================================================
214 -- Start of Comments
215 -- ==============================================================================
216 -- API Name
217 -- Update_Claim_Lines_Int
218 -- Type
219 -- Private
220 -- Pre-Req
221 --
222 -- Parameters
223 --
224 -- IN
225 -- p_api_version_number IN NUMBER Required
226 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229 -- p_claim_lines_int_rec IN claim_lines_int_rec_type Required
230 --
231 -- OUT
232 -- x_return_status OUT VARCHAR2
233 -- x_msg_count OUT NUMBER
234 -- x_msg_data OUT VARCHAR2
235 -- Version : Current version 1.0
236 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
237 -- and basic operation, developer must manually add parameters and business logic as necessary.
238 --
239 -- End of Comments
240 -- ==============================================================================
241 --
242
243 PROCEDURE Update_Claim_Lines_Int(
244 p_api_version_number IN NUMBER,
245 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246 p_commit IN VARCHAR2 := FND_API.G_FALSE,
247 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
248
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2,
252
253 p_claim_lines_int_rec IN claim_lines_int_rec_type,
254 x_object_version_number OUT NOCOPY NUMBER
255 );
256
257 -- ==============================================================================
258 -- Start of Comments
259 -- ==============================================================================
260 -- API Name
261 -- Delete_Claim_Lines_Int
262 -- Type
263 -- Private
264 -- Pre-Req
265 --
266 -- Parameters
267 --
268 -- IN
269 -- p_api_version_number IN NUMBER Required
270 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
271 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
272 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
273 -- p_INTERFACE_CLAIM_LINE_ID IN NUMBER
274 -- p_object_version_number IN NUMBER Optional Default = NULL
275 --
276 -- OUT
277 -- x_return_status OUT VARCHAR2
278 -- x_msg_count OUT NUMBER
279 -- x_msg_data OUT VARCHAR2
280 -- Version : Current version 1.0
281 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
282 -- and basic operation, developer must manually add parameters and business logic as necessary.
283 --
284 -- End of Comments
285 -- ==============================================================================
286 --
287
288 PROCEDURE Delete_Claim_Lines_Int(
289 p_api_version_number IN NUMBER,
290 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291 p_commit IN VARCHAR2 := FND_API.G_FALSE,
292 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293 x_return_status OUT NOCOPY VARCHAR2,
294 x_msg_count OUT NOCOPY NUMBER,
295 x_msg_data OUT NOCOPY VARCHAR2,
296 p_interface_claim_line_id IN NUMBER,
297 p_object_version_number IN NUMBER
298 );
299
300 -- ==============================================================================
301 -- Start of Comments
302 -- ==============================================================================
303 -- API Name
304 -- Lock_Claim_Lines_Int
305 -- Type
306 -- Private
307 -- Pre-Req
308 --
309 -- Parameters
310 --
311 -- IN
312 -- p_api_version_number IN NUMBER Required
313 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
314 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
315 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
316 -- p_claim_lines_int_rec IN claim_lines_int_rec_type Required
317 --
318 -- OUT
319 -- x_return_status OUT VARCHAR2
320 -- x_msg_count OUT NUMBER
321 -- x_msg_data OUT VARCHAR2
322 -- Version : Current version 1.0
323 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
324 -- and basic operation, developer must manually add parameters and business logic as necessary.
325 --
326 -- End of Comments
327 -- ==============================================================================
328 --
329
330 PROCEDURE Lock_Claim_Lines_Int(
331 p_api_version_number IN NUMBER,
332 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
333
334 x_return_status OUT NOCOPY VARCHAR2,
335 x_msg_count OUT NOCOPY NUMBER,
336 x_msg_data OUT NOCOPY VARCHAR2,
337
338 p_interface_claim_line_id IN NUMBER,
339 p_object_version IN NUMBER
340 );
341
342
343 -- Start of Comments
344 --
345 -- validation procedures
346 --
347 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
348 -- For create: G_CREATE, for update: G_UPDATE
349 -- Note: 1. This is automated generated item level validation procedure.
350 -- The actual validation detail is needed to be added.
351 -- 2. We can also validate table instead of record. There will be an option for user to choose.
352 -- End of Comments
353
354 PROCEDURE Validate_claim_lines_int(
355 p_api_version_number IN NUMBER,
356 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
357 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
358 p_claim_lines_int_rec IN claim_lines_int_rec_type,
359 x_return_status OUT NOCOPY VARCHAR2,
360 x_msg_count OUT NOCOPY NUMBER,
361 x_msg_data OUT NOCOPY VARCHAR2
362 );
363
364 -- Start of Comments
365 --
366 -- validation procedures
367 --
368 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
369 -- For create: G_CREATE, for update: G_UPDATE
370 -- Note: 1. This is automated generated item level validation procedure.
371 -- The actual validation detail is needed to be added.
372 -- 2. Validate the unique keys, lookups here
373 -- End of Comments
374
375 PROCEDURE Check_claim_lines_int_Items (
376 P_claim_lines_int_rec IN claim_lines_int_rec_type,
377 p_validation_mode IN VARCHAR2,
378 x_return_status OUT NOCOPY VARCHAR2
379 );
380
381 -- Start of Comments
382 --
383 -- Record level validation procedures
384 --
385 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
386 -- For create: G_CREATE, for update: G_UPDATE
387 -- Note: 1. This is automated generated item level validation procedure.
388 -- The actual validation detail is needed to be added.
389 -- 2. Developer can manually added inter-field level validation.
390 -- End of Comments
391
392 PROCEDURE Validate_claim_lines_int_rec(
393 p_api_version_number IN NUMBER,
394 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
395 x_return_status OUT NOCOPY VARCHAR2,
396 x_msg_count OUT NOCOPY NUMBER,
397 x_msg_data OUT NOCOPY VARCHAR2,
398 p_claim_lines_int_rec IN claim_lines_int_rec_type
399 );
400 END OZF_Claim_Lines_Int_PVT;