[Home] [Help]
PACKAGE: APPS.OZF_CLAIM_LINES_INT_PUB
Source
1 PACKAGE OZF_Claim_Lines_Int_PUB AS
2 /* $Header: ozfpclis.pls 120.0 2005/06/01 02:53:09 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Claim_Lines_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 -- claim_lines_int_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- interface_claim_line_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 -- interface_claim_id
38 -- line_number
39 -- split_from_claim_line_id
40 -- amount
41 -- claim_currency_amount
42 -- acctd_amount
43 -- currency_code
44 -- exchange_rate_type
45 -- exchange_rate_date
46 -- exchange_rate
47 -- set_of_books_id
48 -- valid_flag
49 -- source_object_id
50 -- source_object_class
51 -- source_object_type_id
52 -- source_object_line_id
53 -- plan_id
54 -- offer_id
55 -- utilization_id
56 -- payment_method
57 -- payment_reference_id
58 -- payment_reference_number
59 -- payment_reference_date
60 -- voucher_id
61 -- voucher_number
62 -- payment_status
63 -- approved_flag
64 -- approved_date
65 -- approved_by
66 -- settled_date
67 -- settled_by
68 -- performance_complete_flag
69 -- performance_attached_flag
70 -- attribute_category
71 -- attribute1
72 -- attribute2
73 -- attribute3
74 -- attribute4
75 -- attribute5
76 -- attribute6
77 -- attribute7
78 -- attribute8
79 -- attribute9
80 -- attribute10
81 -- attribute11
82 -- attribute12
83 -- attribute13
84 -- attribute14
85 -- attribute15
86 -- org_id
87 --
88 -- Required
89 --
90 -- Defaults
91 --
92 -- Note: This is automatic generated record definition, it includes all columns
93 -- defined in the table, developer must manually add or delete some of the attributes.
94 --
95 -- End of Comments
96
97 --===================================================================
98 TYPE claim_lines_int_rec_type IS RECORD
99 (
100 interface_claim_line_id NUMBER,
101 object_version_number NUMBER,
102 last_update_date DATE,
103 last_updated_by NUMBER,
104 creation_date DATE,
105 created_by NUMBER,
106 last_update_login NUMBER,
107 request_id NUMBER,
108 program_application_id NUMBER,
109 program_update_date DATE,
110 program_id NUMBER,
111 created_from VARCHAR2(30),
112 interface_claim_id NUMBER,
113 line_number NUMBER,
114 split_from_claim_line_id NUMBER,
115 amount NUMBER,
116 claim_currency_amount NUMBER,
117 acctd_amount NUMBER,
118 currency_code VARCHAR2(15),
119 exchange_rate_type VARCHAR2(30),
120 exchange_rate_date DATE,
121 exchange_rate NUMBER,
122 set_of_books_id NUMBER,
123 valid_flag VARCHAR2(1),
124 source_object_id NUMBER,
125 source_object_class VARCHAR2(15),
126 source_object_type_id NUMBER,
127 source_object_line_id NUMBER,
128 plan_id NUMBER,
129 offer_id NUMBER,
130 utilization_id NUMBER,
131 payment_method VARCHAR2(15),
132 payment_reference_id NUMBER,
133 payment_reference_number VARCHAR2(15),
134 payment_reference_date DATE,
135 voucher_id NUMBER,
136 voucher_number VARCHAR2(30),
137 payment_status VARCHAR2(10),
138 approved_flag VARCHAR2(1),
139 approved_date DATE,
140 approved_by NUMBER,
141 settled_date DATE,
142 settled_by NUMBER,
143 performance_complete_flag VARCHAR2(1),
144 performance_attached_flag VARCHAR2(1),
145 attribute_category VARCHAR2(30),
146 attribute1 VARCHAR2(150),
147 attribute2 VARCHAR2(150),
148 attribute3 VARCHAR2(150),
149 attribute4 VARCHAR2(150),
150 attribute5 VARCHAR2(150),
151 attribute6 VARCHAR2(150),
152 attribute7 VARCHAR2(150),
153 attribute8 VARCHAR2(150),
154 attribute9 VARCHAR2(150),
155 attribute10 VARCHAR2(150),
156 attribute11 VARCHAR2(150),
157 attribute12 VARCHAR2(150),
158 attribute13 VARCHAR2(150),
159 attribute14 VARCHAR2(150),
160 attribute15 VARCHAR2(150),
161 org_id NUMBER
162 );
163
164 g_miss_claim_lines_int_rec claim_lines_int_rec_type;
165 TYPE claim_lines_int_tbl_type IS TABLE OF claim_lines_int_rec_type INDEX BY BINARY_INTEGER;
166 g_miss_claim_lines_int_tbl claim_lines_int_tbl_type;
167
168 TYPE claim_lines_int_sort_rec_type IS RECORD
169 (
170 -- Please define your own sort by record here.
171 object_version_number NUMBER := NULL
172 );
173
174 -- ==============================================================================
175 -- Start of Comments
176 -- ==============================================================================
177 -- API Name
178 -- Create_Claim_Lines_Int
179 -- Type
180 -- Public
181 -- Pre-Req
182 --
183 -- Parameters
184 --
185 -- IN
186 -- p_api_version_number IN NUMBER Required
187 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
188 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
189 -- p_claim_lines_int_rec IN claim_lines_int_rec_type Required
190 --
191 -- OUT
192 -- x_return_status OUT VARCHAR2
193 -- x_msg_count OUT NUMBER
194 -- x_msg_data OUT VARCHAR2
195 -- Version : Current version 1.0
196 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
197 -- and basic operation, developer must manually add parameters and business logic as necessary.
198 --
199 -- End of Comments
200 -- ==============================================================================
201 --
202
203 PROCEDURE Create_Claim_Lines_Int(
204 p_api_version_number IN NUMBER,
205 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
206 p_commit IN VARCHAR2 := FND_API.G_FALSE,
207
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211
212 p_claim_lines_int_rec IN claim_lines_int_rec_type := g_miss_claim_lines_int_rec,
213 x_interface_claim_line_id OUT NOCOPY NUMBER
214 );
215
216 -- ==============================================================================
217 -- Start of Comments
218 -- ==============================================================================
219 -- API Name
220 -- Update_Claim_Lines_Int
221 -- Type
222 -- Public
223 -- Pre-Req
224 --
225 -- Parameters
226 --
227 -- IN
228 -- p_api_version_number IN NUMBER Required
229 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231 -- p_claim_lines_int_rec IN claim_lines_int_rec_type Required
232 --
233 -- OUT
234 -- x_return_status OUT VARCHAR2
235 -- x_msg_count OUT NUMBER
236 -- x_msg_data OUT VARCHAR2
237 -- Version : Current version 1.0
238 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
239 -- and basic operation, developer must manually add parameters and business logic as necessary.
240 --
241 -- End of Comments
242 -- ==============================================================================
243 --
244
245 PROCEDURE Update_Claim_Lines_Int(
246 p_api_version_number IN NUMBER,
247 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
248 p_commit IN VARCHAR2 := FND_API.G_FALSE,
249
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253
254 p_claim_lines_int_rec IN claim_lines_int_rec_type,
255 x_object_version_number OUT NOCOPY NUMBER
256 );
257
258 -- ==============================================================================
259 -- Start of Comments
260 -- ==============================================================================
261 -- API Name
262 -- Delete_Claim_Lines_Int
263 -- Type
264 -- Public
265 -- Pre-Req
266 --
267 -- Parameters
268 --
269 -- IN
270 -- p_api_version_number IN NUMBER Required
271 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
272 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
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 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2,
295 p_interface_claim_line_id IN NUMBER,
296 p_object_version_number IN NUMBER
297 );
298
299 -- ==============================================================================
300 -- Start of Comments
301 -- ==============================================================================
302 -- API Name
303 -- Lock_Claim_Lines_Int
304 -- Type
305 -- Public
306 -- Pre-Req
307 --
308 -- Parameters
309 --
310 -- IN
311 -- p_api_version_number IN NUMBER Required
312 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
313 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
314 -- p_claim_lines_int_rec IN claim_lines_int_rec_type Required
315 --
316 -- OUT
317 -- x_return_status OUT VARCHAR2
318 -- x_msg_count OUT NUMBER
319 -- x_msg_data OUT VARCHAR2
320 -- Version : Current version 1.0
321 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
322 -- and basic operation, developer must manually add parameters and business logic as necessary.
323 --
324 -- End of Comments
325 -- ==============================================================================
326 --
327
328 PROCEDURE Lock_Claim_Lines_Int(
329 p_api_version_number IN NUMBER,
330 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
331 x_return_status OUT NOCOPY VARCHAR2,
332 x_msg_count OUT NOCOPY NUMBER,
333 x_msg_data OUT NOCOPY VARCHAR2,
334
335 p_interface_claim_line_id IN NUMBER,
336 p_object_version IN NUMBER
337 );
338
339 END OZF_Claim_Lines_Int_PUB;