[Home] [Help]
PACKAGE: APPS.OZF_CLAIMS_INT_PUB
Source
1 PACKAGE OZF_Claims_Int_PUB AUTHID CURRENT_USER AS
2 /* $Header: ozfpcins.pls 120.0.12020000.2 2012/08/08 09:11:44 ninarasi ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Claims_Int_PUB
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- claims_int_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- interface_claim_id
26 -- object_version_number
27 -- last_update_date
28 -- last_updated_by
29 -- creation_date
30 -- created_by
31 -- last_update_login
32 -- request_id
33 -- program_application_id
34 -- program_update_date
35 -- program_id
36 -- created_from
37 -- batch_id
38 -- claim_id
39 -- claim_number
40 -- claim_type_id
41 -- claim_class
42 -- claim_date
43 -- due_date
44 -- owner_id
45 -- history_event
46 -- history_event_date
47 -- history_event_description
48 -- split_from_claim_id
49 -- duplicate_claim_id
50 -- split_date
51 -- root_claim_id
52 -- amount
53 -- amount_adjusted
54 -- amount_remaining
55 -- amount_settled
56 -- acctd_amount
57 -- acctd_amount_remaining
58 -- tax_amount
59 -- tax_code
60 -- tax_calculation_flag
61 -- currency_code
62 -- exchange_rate_type
63 -- exchange_rate_date
64 -- exchange_rate
65 -- set_of_books_id
66 -- original_claim_date
67 -- source_object_id
68 -- source_object_class
69 -- source_object_type_id
70 -- source_object_number
71 -- cust_account_id
72 -- cust_billto_acct_site_id
73 -- cust_shipto_acct_site_id
74 -- location_id
75 -- pay_related_account_flag
76 -- related_cust_account_id
77 -- related_site_use_id
78 -- relationship_type
79 -- vendor_id
80 -- vendor_site_id
81 -- reason_type
82 -- reason_code_id
83 -- task_template_group_id
84 -- status_code
85 -- user_status_id
86 -- sales_rep_id
87 -- collector_id
88 -- contact_id
89 -- broker_id
90 -- territory_id
91 -- customer_ref_date
92 -- customer_ref_number
93 -- assigned_to
94 -- receipt_id
95 -- receipt_number
96 -- doc_sequence_id
97 -- doc_sequence_value
98 -- gl_date
99 -- payment_method
100 -- voucher_id
101 -- voucher_number
102 -- payment_reference_id
103 -- payment_reference_number
104 -- payment_reference_date
105 -- payment_status
106 -- approved_flag
107 -- approved_date
108 -- approved_by
109 -- settled_date
110 -- settled_by
111 -- effective_date
112 -- custom_setup_id
113 -- task_id
114 -- country_id
115 -- comments
116 -- attribute_category
117 -- attribute1
118 -- attribute2
119 -- attribute3
120 -- attribute4
121 -- attribute5
122 -- attribute6
123 -- attribute7
124 -- attribute8
125 -- attribute9
126 -- attribute10
127 -- attribute11
128 -- attribute12
129 -- attribute13
130 -- attribute14
131 -- attribute15
132 -- deduction_attribute_category
133 -- deduction_attribute1
134 -- deduction_attribute2
135 -- deduction_attribute3
136 -- deduction_attribute4
137 -- deduction_attribute5
138 -- deduction_attribute6
139 -- deduction_attribute7
140 -- deduction_attribute8
141 -- deduction_attribute9
142 -- deduction_attribute10
143 -- deduction_attribute11
144 -- deduction_attribute12
145 -- deduction_attribute13
146 -- deduction_attribute14
147 -- deduction_attribute15
148 -- org_id
149 --
150 -- Required
151 --
152 -- Defaults
153 --
154 -- Note: This is automatic generated record definition, it includes all columns
155 -- defined in the table, developer must manually add or delete some of the attributes.
156 --
157 -- End of Comments
158
159 --===================================================================
160 TYPE claims_int_rec_type IS RECORD
161 (
162 interface_claim_id NUMBER,
163 object_version_number NUMBER,
164 last_update_date DATE,
165 last_updated_by NUMBER,
166 creation_date DATE,
167 created_by NUMBER,
168 last_update_login NUMBER,
169 request_id NUMBER,
170 program_application_id NUMBER,
171 program_update_date DATE,
172 program_id NUMBER,
173 created_from VARCHAR2(30),
174 batch_id NUMBER,
175 claim_id NUMBER,
176 claim_number VARCHAR2(30),
177 claim_type_id NUMBER,
178 claim_class VARCHAR2(30),
179 claim_date DATE,
180 due_date DATE,
181 owner_id NUMBER,
182 history_event VARCHAR2(30),
183 history_event_date DATE,
184 history_event_description VARCHAR2(2000),
185 split_from_claim_id NUMBER,
186 duplicate_claim_id NUMBER,
187 split_date DATE,
188 root_claim_id NUMBER,
189 amount NUMBER,
190 amount_adjusted NUMBER,
191 amount_remaining NUMBER,
192 amount_settled NUMBER,
193 acctd_amount NUMBER,
194 acctd_amount_remaining NUMBER,
195 tax_amount NUMBER,
196 tax_code VARCHAR2(50),
197 tax_calculation_flag VARCHAR2(1),
198 currency_code VARCHAR2(15),
199 exchange_rate_type VARCHAR2(30),
200 exchange_rate_date DATE,
201 exchange_rate NUMBER,
202 set_of_books_id NUMBER,
203 original_claim_date DATE,
204 source_object_id NUMBER,
205 source_object_class VARCHAR2(15),
206 source_object_type_id NUMBER,
207 source_object_number VARCHAR2(30),
208 cust_account_id NUMBER,
209 cust_billto_acct_site_id NUMBER,
210 cust_shipto_acct_site_id NUMBER,
211 location_id NUMBER,
212 pay_related_account_flag VARCHAR2(1),
213 related_cust_account_id NUMBER,
214 related_site_use_id NUMBER,
215 relationship_type VARCHAR2(30),
216 vendor_id NUMBER,
217 vendor_site_id NUMBER,
218 reason_type VARCHAR2(30),
219 reason_code_id NUMBER,
220 task_template_group_id NUMBER,
221 status_code VARCHAR2(30),
222 user_status_id NUMBER,
223 sales_rep_id NUMBER,
224 collector_id NUMBER,
225 contact_id NUMBER,
226 broker_id NUMBER,
227 territory_id NUMBER,
228 customer_ref_date DATE,
229 customer_ref_number VARCHAR2(100),
230 assigned_to NUMBER,
231 receipt_id NUMBER,
232 receipt_number VARCHAR2(30),
233 doc_sequence_id NUMBER,
234 doc_sequence_value NUMBER,
235 gl_date DATE,
236 payment_method VARCHAR2(15),
237 voucher_id NUMBER,
238 voucher_number VARCHAR2(30),
239 payment_reference_id NUMBER,
240 payment_reference_number VARCHAR2(15),
241 payment_reference_date DATE,
242 payment_status VARCHAR2(10),
243 approved_flag VARCHAR2(1),
244 approved_date DATE,
245 approved_by NUMBER,
246 settled_date DATE,
247 settled_by NUMBER,
248 effective_date DATE,
249 custom_setup_id NUMBER,
250 task_id NUMBER,
251 country_id NUMBER,
252 comments VARCHAR2(2000),
253 attribute_category VARCHAR2(30),
254 attribute1 VARCHAR2(150),
255 attribute2 VARCHAR2(150),
256 attribute3 VARCHAR2(150),
257 attribute4 VARCHAR2(150),
258 attribute5 VARCHAR2(150),
259 attribute6 VARCHAR2(150),
260 attribute7 VARCHAR2(150),
261 attribute8 VARCHAR2(150),
262 attribute9 VARCHAR2(150),
263 attribute10 VARCHAR2(150),
264 attribute11 VARCHAR2(150),
265 attribute12 VARCHAR2(150),
266 attribute13 VARCHAR2(150),
267 attribute14 VARCHAR2(150),
268 attribute15 VARCHAR2(150),
269 deduction_attribute_category VARCHAR2(30),
270 deduction_attribute1 VARCHAR2(150),
271 deduction_attribute2 VARCHAR2(150),
272 deduction_attribute3 VARCHAR2(150),
273 deduction_attribute4 VARCHAR2(150),
274 deduction_attribute5 VARCHAR2(150),
275 deduction_attribute6 VARCHAR2(150),
276 deduction_attribute7 VARCHAR2(150),
277 deduction_attribute8 VARCHAR2(150),
278 deduction_attribute9 VARCHAR2(150),
279 deduction_attribute10 VARCHAR2(150),
280 deduction_attribute11 VARCHAR2(150),
281 deduction_attribute12 VARCHAR2(150),
282 deduction_attribute13 VARCHAR2(150),
283 deduction_attribute14 VARCHAR2(150),
284 deduction_attribute15 VARCHAR2(150),
285 org_id NUMBER
286 );
287
288 g_miss_claims_int_rec claims_int_rec_type;
289 TYPE claims_int_tbl_type IS TABLE OF claims_int_rec_type INDEX BY BINARY_INTEGER;
290 g_miss_claims_int_tbl claims_int_tbl_type;
291
292 TYPE claims_int_sort_rec_type IS RECORD
293 (
294 -- Please define your own sort by record here.
295 object_version_number NUMBER := NULL
296 );
297
298 -- ==============================================================================
299 -- Start of Comments
300 -- ==============================================================================
301 -- API Name
302 -- Create_Claims_Int
303 -- Type
304 -- Public
305 -- Pre-Req
306 --
307 -- Parameters
308 --
309 -- IN
310 -- p_api_version_number IN NUMBER Required
311 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
312 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
313 -- p_claims_int_rec IN claims_int_rec_type Required
314 --
315 -- OUT
316 -- x_return_status OUT VARCHAR2
317 -- x_msg_count OUT NUMBER
318 -- x_msg_data OUT VARCHAR2
319 -- Version : Current version 1.0
320 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
321 -- and basic operation, developer must manually add parameters and business logic as necessary.
322 --
326
323 -- End of Comments
324 -- ==============================================================================
325 --
327 PROCEDURE Create_Claims_Int(
328 p_api_version_number IN NUMBER,
329 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
330 p_commit IN VARCHAR2 := FND_API.G_FALSE,
331
332 x_return_status OUT NOCOPY VARCHAR2,
333 x_msg_count OUT NOCOPY NUMBER,
334 x_msg_data OUT NOCOPY VARCHAR2,
335
336 p_claims_int_rec IN claims_int_rec_type := g_miss_claims_int_rec,
337 x_interface_claim_id OUT NOCOPY NUMBER
338 );
339
340 -- ==============================================================================
341 -- Start of Comments
342 -- ==============================================================================
343 -- API Name
344 -- Update_Claims_Int
345 -- Type
346 -- Public
347 -- Pre-Req
348 --
349 -- Parameters
350 --
351 -- IN
352 -- p_api_version_number IN NUMBER Required
353 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
354 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
355 -- p_claims_int_rec IN claims_int_rec_type Required
356 --
357 -- OUT
358 -- x_return_status OUT VARCHAR2
359 -- x_msg_count OUT NUMBER
360 -- x_msg_data OUT VARCHAR2
361 -- Version : Current version 1.0
362 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
363 -- and basic operation, developer must manually add parameters and business logic as necessary.
364 --
365 -- End of Comments
366 -- ==============================================================================
367 --
368
369 PROCEDURE Update_Claims_Int(
370 p_api_version_number IN NUMBER,
371 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
372 p_commit IN VARCHAR2 := FND_API.G_FALSE,
373
374 x_return_status OUT NOCOPY VARCHAR2,
375 x_msg_count OUT NOCOPY NUMBER,
376 x_msg_data OUT NOCOPY VARCHAR2,
377
378 p_claims_int_rec IN claims_int_rec_type,
379 x_object_version_number OUT NOCOPY NUMBER
380 );
381
382 -- ==============================================================================
383 -- Start of Comments
384 -- ==============================================================================
385 -- API Name
386 -- Delete_Claims_Int
387 -- Type
388 -- Public
389 -- Pre-Req
390 --
391 -- Parameters
392 --
393 -- IN
394 -- p_api_version_number IN NUMBER Required
395 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
396 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
397 -- p_INTERFACE_CLAIM_ID IN NUMBER
398 -- p_object_version_number IN NUMBER Optional Default = NULL
399 --
400 -- OUT
401 -- x_return_status OUT VARCHAR2
402 -- x_msg_count OUT NUMBER
403 -- x_msg_data OUT VARCHAR2
404 -- Version : Current version 1.0
405 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
406 -- and basic operation, developer must manually add parameters and business logic as necessary.
407 --
408 -- End of Comments
409 -- ==============================================================================
410 --
411
412 PROCEDURE Delete_Claims_Int(
413 p_api_version_number IN NUMBER,
414 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
415 p_commit IN VARCHAR2 := FND_API.G_FALSE,
416 x_return_status OUT NOCOPY VARCHAR2,
417 x_msg_count OUT NOCOPY NUMBER,
418 x_msg_data OUT NOCOPY VARCHAR2,
419 p_interface_claim_id IN NUMBER,
420 p_object_version_number IN NUMBER
421 );
422
423 -- ==============================================================================
424 -- Start of Comments
425 -- ==============================================================================
426 -- API Name
427 -- Lock_Claims_Int
428 -- Type
429 -- Public
430 -- Pre-Req
431 --
432 -- Parameters
433 --
434 -- IN
435 -- p_api_version_number IN NUMBER Required
436 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
437 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
438 -- p_claims_int_rec IN claims_int_rec_type Required
439 --
440 -- OUT
441 -- x_return_status OUT VARCHAR2
442 -- x_msg_count OUT NUMBER
443 -- x_msg_data OUT VARCHAR2
444 -- Version : Current version 1.0
445 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
446 -- and basic operation, developer must manually add parameters and business logic as necessary.
447 --
448 -- End of Comments
449 -- ==============================================================================
450 --
451
452 PROCEDURE Lock_Claims_Int(
453 p_api_version_number IN NUMBER,
454 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
455 x_return_status OUT NOCOPY VARCHAR2,
459 p_interface_claim_id IN NUMBER,
456 x_msg_count OUT NOCOPY NUMBER,
457 x_msg_data OUT NOCOPY VARCHAR2,
458
460 p_object_version IN NUMBER
461 );
462
463 END OZF_Claims_Int_PUB;