[Home] [Help]
PACKAGE: APPS.OZF_CLAIM_LINE_HIST_PVT
Source
1 PACKAGE OZF_Claim_Line_Hist_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvclhs.pls 115.4 2004/01/13 09:49:29 upoluri ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Claim_Line_Hist_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- MCHANG 23-OCT-2001 Remove security_group_id.
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17
18 -- Default number of records fetch per call
19 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
20
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- claim_line_hist_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- claim_line_history_id
29 -- object_version_number
30 -- last_update_date
31 -- last_updated_by
32 -- creation_date
33 -- created_by
34 -- last_update_login
35 -- request_id
36 -- program_application_id
37 -- program_update_date
38 -- program_id
39 -- created_from
40 -- claim_history_id
41 -- claim_id
42 -- claim_line_id
43 -- line_number
44 -- split_from_claim_line_id
45 -- amount
46 -- acctd_amount
47 -- currency_code
48 -- exchange_rate_type
49 -- exchange_rate_date
50 -- exchange_rate
51 -- set_of_books_id
52 -- valid_flag
53 -- source_object_id
54 -- source_object_class
55 -- source_object_type_id
56 -- source_object_line_id
57 -- plan_id
58 -- offer_id
59 -- payment_method
60 -- payment_reference_id
61 -- payment_reference_number
62 -- payment_reference_date
63 -- voucher_id
64 -- voucher_number
65 -- payment_status
66 -- approved_flag
67 -- approved_date
68 -- approved_by
69 -- settled_date
70 -- settled_by
71 -- performance_complete_flag
72 -- performance_attached_flag
73 -- attribute_category
74 -- attribute1
75 -- attribute2
76 -- attribute3
77 -- attribute4
78 -- attribute5
79 -- attribute6
80 -- attribute7
81 -- attribute8
82 -- attribute9
83 -- attribute10
84 -- attribute11
85 -- attribute12
86 -- attribute13
87 -- attribute14
88 -- attribute15
89 -- org_id
90 -- utilization_id
91 -- claim_currency_amount
92 -- item_id
93 -- item_description
94 -- quantity
95 -- quantity_uom
96 -- rate
97 -- activity_type
98 -- activity_id
99 -- earnings_associated_flag
100 -- comments
101 -- related_cust_account_id
102 -- relationship_type
103 -- tax_code
104 -- select_cust_children_flag
105 -- buy_group_cust_account_id
106 -- credit_to
107 -- sale_date
108 -- item_type
109 -- tax_amount
110 -- claim_curr_tax_amount
111 -- activity_line_id
112 --
113 -- Required
114 --
115 -- Defaults
116 --
117 -- Note: This is automatic generated record definition, it includes all columns
118 -- defined in the table, developer must manually add or delete some of the attributes.
119 --
120 -- End of Comments
121
122 --===================================================================
123 TYPE claim_line_hist_rec_type IS RECORD
124 (
125 claim_line_history_id NUMBER,
126 object_version_number NUMBER,
127 last_update_date DATE,
128 last_updated_by NUMBER,
129 creation_date DATE,
130 created_by NUMBER,
131 last_update_login NUMBER,
132 request_id NUMBER,
133 program_application_id NUMBER,
134 program_update_date DATE,
135 program_id NUMBER,
136 created_from VARCHAR2(30),
137 claim_history_id NUMBER,
138 claim_id NUMBER,
139 claim_line_id NUMBER,
140 line_number NUMBER,
141 split_from_claim_line_id NUMBER,
142 amount NUMBER,
143 acctd_amount NUMBER,
144 currency_code VARCHAR2(15),
145 exchange_rate_type VARCHAR2(30),
146 exchange_rate_date DATE,
147 exchange_rate NUMBER,
148 set_of_books_id NUMBER,
149 valid_flag VARCHAR2(1),
150 source_object_id NUMBER,
151 source_object_class VARCHAR2(15),
152 source_object_type_id NUMBER,
153 source_object_line_id NUMBER,
154 plan_id NUMBER,
155 offer_id NUMBER,
156 payment_method VARCHAR2(15),
157 payment_reference_id NUMBER,
158 payment_reference_number VARCHAR2(15),
159 payment_reference_date DATE,
160 voucher_id NUMBER,
161 voucher_number VARCHAR2(30),
162 payment_status VARCHAR2(10),
163 approved_flag VARCHAR2(1),
164 approved_date DATE,
165 approved_by NUMBER,
166 settled_date DATE,
167 settled_by NUMBER,
168 performance_complete_flag VARCHAR2(1),
169 performance_attached_flag VARCHAR2(1),
170 attribute_category VARCHAR2(30),
171 attribute1 VARCHAR2(150),
172 attribute2 VARCHAR2(150),
173 attribute3 VARCHAR2(150),
174 attribute4 VARCHAR2(150),
175 attribute5 VARCHAR2(150),
176 attribute6 VARCHAR2(150),
177 attribute7 VARCHAR2(150),
178 attribute8 VARCHAR2(150),
179 attribute9 VARCHAR2(150),
180 attribute10 VARCHAR2(150),
181 attribute11 VARCHAR2(150),
182 attribute12 VARCHAR2(150),
183 attribute13 VARCHAR2(150),
184 attribute14 VARCHAR2(150),
185 attribute15 VARCHAR2(150),
186 org_id NUMBER,
187 utilization_id NUMBER,
188 claim_currency_amount NUMBER,
189 item_id NUMBER,
190 item_description VARCHAR2(240),
191 quantity NUMBER,
192 quantity_uom VARCHAR2(30),
193 rate NUMBER,
194 activity_type VARCHAR2(30),
195 activity_id NUMBER,
196 earnings_associated_flag VARCHAR2(1),
197 comments VARCHAR2(2000),
198 related_cust_account_id NUMBER,
199 relationship_type VARCHAR2(30),
200 tax_code VARCHAR2(50),
201 select_cust_children_flag VARCHAR2(1),
202 buy_group_cust_account_id NUMBER,
203 credit_to VARCHAR2(15),
204 sale_date DATE,
205 item_type VARCHAR2(30),
206 tax_amount NUMBER,
207 claim_curr_tax_amount NUMBER,
208 activity_line_id NUMBER,
209 offer_type VARCHAR2(30),
210 prorate_earnings_flag VARCHAR2(1),
211 earnings_end_date DATE
212 );
213
214 g_miss_claim_line_hist_rec claim_line_hist_rec_type;
215 TYPE claim_line_hist_tbl_type IS TABLE OF claim_line_hist_rec_type
216 INDEX BY BINARY_INTEGER;
217 g_miss_claim_line_hist_tbl claim_line_hist_tbl_type;
218
219 -- ==============================================================================
220 -- Start of Comments
221 -- ==============================================================================
222 -- API Name
223 -- Create_Claim_Line_Hist
224 -- Type
225 -- Private
226 -- Pre-Req
227 --
228 -- Parameters
229 --
230 -- IN
231 -- p_api_version_number IN NUMBER Required
232 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
233 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
234 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
235 -- p_claim_line_hist_rec IN claim_line_hist_rec_type Required
236 --
237 -- OUT
238 -- x_return_status OUT VARCHAR2
239 -- x_msg_count OUT NUMBER
240 -- x_msg_data OUT VARCHAR2
241 --
242 -- Version : Current version 1.0
243 --
244 -- End of Comments
245 -- ==============================================================================
246 --
247 PROCEDURE Create_Claim_Line_Hist(
248 p_api_version_number IN NUMBER,
249 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250 p_commit IN VARCHAR2 := FND_API.G_FALSE,
251 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256
257 p_claim_line_hist_rec IN claim_line_hist_rec_type := g_miss_claim_line_hist_rec,
258 x_claim_line_history_id OUT NOCOPY NUMBER
259 );
260
261
262 -- ==============================================================================
263 -- Start of Comments
264 -- ==============================================================================
265 -- API Name
266 -- Update_Claim_Line_Hist
267 -- Type
268 -- Private
269 -- Pre-Req
270 --
271 -- Parameters
272 --
273 -- IN
274 -- p_api_version_number IN NUMBER Required
275 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
276 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
277 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
278 -- p_claim_line_hist_rec IN claim_line_hist_rec_type Required
279 --
280 -- OUT
281 -- x_return_status OUT VARCHAR2
282 -- x_msg_count OUT NUMBER
283 -- x_msg_data OUT VARCHAR2
284 --
285 -- Version : Current version 1.0
286 --
287 -- End of Comments
288 -- ==============================================================================
289 --
290 PROCEDURE Update_Claim_Line_Hist(
291 p_api_version_number IN NUMBER,
292 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293 p_commit IN VARCHAR2 := FND_API.G_FALSE,
294 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299
300 p_claim_line_hist_rec IN claim_line_hist_rec_type,
301 x_object_version_number OUT NOCOPY NUMBER
302 );
303
304
305 -- ==============================================================================
306 -- Start of Comments
307 -- ==============================================================================
308 -- API Name
309 -- Delete_Claim_Line_Hist
310 -- Type
311 -- Private
312 -- Pre-Req
313 --
314 -- Parameters
315 --
316 -- IN
317 -- p_api_version_number IN NUMBER Required
318 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
319 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
320 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
321 -- p_CLAIM_LINE_HISTORY_ID IN NUMBER
322 -- p_object_version_number IN NUMBER Optional Default = NULL
323 --
324 -- OUT
325 -- x_return_status OUT VARCHAR2
326 -- x_msg_count OUT NUMBER
327 -- x_msg_data OUT VARCHAR2
328 --
329 -- Version : Current version 1.0
330 --
331 -- End of Comments
332 -- ==============================================================================
333 --
334 PROCEDURE Delete_Claim_Line_Hist(
335 p_api_version_number IN NUMBER,
336 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
337 p_commit IN VARCHAR2 := FND_API.G_FALSE,
338 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
339 x_return_status OUT NOCOPY VARCHAR2,
340 x_msg_count OUT NOCOPY NUMBER,
341 x_msg_data OUT NOCOPY VARCHAR2,
342 p_claim_line_history_id IN NUMBER,
343 p_object_version_number IN NUMBER
344 );
345
346
347 -- ==============================================================================
348 -- Start of Comments
349 -- ==============================================================================
350 -- API Name
351 -- Lock_Claim_Line_Hist
352 -- Type
353 -- Private
354 -- Pre-Req
355 --
356 -- Parameters
357 --
358 -- IN
359 -- p_api_version_number IN NUMBER Required
360 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
361 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
362 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
363 -- p_claim_line_hist_rec IN claim_line_hist_rec_type Required
364 --
365 -- OUT
366 -- x_return_status OUT VARCHAR2
367 -- x_msg_count OUT NUMBER
368 -- x_msg_data OUT VARCHAR2
369 --
370 -- Version : Current version 1.0
371 --
372 -- End of Comments
373 -- ==============================================================================
374 --
375 PROCEDURE Lock_Claim_Line_Hist(
376 p_api_version_number IN NUMBER,
377 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
378
379 x_return_status OUT NOCOPY VARCHAR2,
380 x_msg_count OUT NOCOPY NUMBER,
381 x_msg_data OUT NOCOPY VARCHAR2,
382
383 p_claim_line_history_id IN NUMBER,
384 p_object_version IN NUMBER
385 );
386
387
388 -- Start of Comments
389 --
390 -- validation procedures
391 --
392 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
393 -- For create: G_CREATE, for update: G_UPDATE
394 --
395 -- End of Comments
396 PROCEDURE Validate_claim_line_hist(
397 p_api_version_number IN NUMBER,
398 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
399 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
400 p_claim_line_hist_rec IN claim_line_hist_rec_type,
401 x_return_status OUT NOCOPY VARCHAR2,
402 x_msg_count OUT NOCOPY NUMBER,
403 x_msg_data OUT NOCOPY VARCHAR2
404 );
405
406
407 -- Start of Comments
408 --
409 -- validation procedures
410 --
411 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
412 -- For create: G_CREATE, for update: G_UPDATE
413 --
414 -- End of Comments
415 PROCEDURE Check_claim_line_hist_Items (
416 P_claim_line_hist_rec IN claim_line_hist_rec_type,
417 p_validation_mode IN VARCHAR2,
418 x_return_status OUT NOCOPY VARCHAR2
419 );
420
421
422 -- Start of Comments
423 --
424 -- Record level validation procedures
425 --
426 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
427 -- For create: G_CREATE, for update: G_UPDATE
428 --
429 -- End of Comments
430 PROCEDURE Validate_claim_line_hist_rec(
431 p_api_version_number IN NUMBER,
432 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
433 x_return_status OUT NOCOPY VARCHAR2,
434 x_msg_count OUT NOCOPY NUMBER,
435 x_msg_data OUT NOCOPY VARCHAR2,
436 p_claim_line_hist_rec IN claim_line_hist_rec_type
437 );
438
439 END OZF_Claim_Line_Hist_PVT;