[Home] [Help]
PACKAGE: APPS.OZF_ACCTNG_EVENTS_PVT
Source
1 PACKAGE OZF_Acctng_Events_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvaces.pls 115.2 2003/06/30 19:14:54 mchang ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Acctng_Events_PVT
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 -- acctng_event_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- accounting_event_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 -- accounting_date
37 -- event_number
38 -- event_status_code
39 -- event_type_code
40 -- org_id
41 -- source_id
42 -- source_table
43 -- attribute_category
44 -- attribute1
45 -- attribute2
46 -- attribute3
47 -- attribute4
48 -- attribute5
49 -- attribute6
50 -- attribute7
51 -- attribute8
52 -- attribute9
53 -- attribute10
54 -- attribute11
55 -- attribute12
56 -- attribute13
57 -- attribute14
58 -- attribute15
59 --
60 -- Required
61 --
62 -- Defaults
63 --
64 -- Note: This is automatic generated record definition, it includes all columns
65 -- defined in the table, developer must manually add or delete some of the attributes.
66 --
67 -- End of Comments
68
69 --===================================================================
70 TYPE acctng_event_rec_type IS RECORD
71 (
72 accounting_event_id NUMBER,
73 object_version_number NUMBER,
74 last_update_date DATE,
75 last_updated_by NUMBER,
76 creation_date DATE,
77 created_by NUMBER,
78 last_update_login NUMBER,
79 request_id NUMBER,
80 program_application_id NUMBER,
81 program_update_date DATE,
82 program_id NUMBER,
83 accounting_date DATE,
84 event_number NUMBER,
85 event_status_code VARCHAR2(30),
86 event_type_code VARCHAR2(30),
87 org_id NUMBER,
88 source_id NUMBER,
89 source_table VARCHAR2(30),
90 attribute_category VARCHAR2(30),
91 attribute1 VARCHAR2(150),
92 attribute2 VARCHAR2(150),
93 attribute3 VARCHAR2(150),
94 attribute4 VARCHAR2(150),
95 attribute5 VARCHAR2(150),
96 attribute6 VARCHAR2(150),
97 attribute7 VARCHAR2(150),
98 attribute8 VARCHAR2(150),
99 attribute9 VARCHAR2(150),
100 attribute10 VARCHAR2(150),
101 attribute11 VARCHAR2(150),
102 attribute12 VARCHAR2(150),
103 attribute13 VARCHAR2(150),
104 attribute14 VARCHAR2(150),
105 attribute15 VARCHAR2(150)
106 );
107
108 g_miss_acctng_event_rec acctng_event_rec_type;
109 TYPE acctng_event_tbl_type IS TABLE OF acctng_event_rec_type INDEX BY BINARY_INTEGER;
110 g_miss_acctng_event_tbl acctng_event_tbl_type;
111
112 -- ==============================================================================
113 -- Start of Comments
114 -- ==============================================================================
115 -- API Name
116 -- Create_Acctng_Events
117 -- Type
118 -- Private
119 -- Pre-Req
120 --
121 -- Parameters
122 --
123 -- IN
124 -- p_api_version_number IN NUMBER Required
125 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128 -- p_acctng_event_rec IN acctng_event_rec_type Required
129 --
130 -- OUT
131 -- x_return_status OUT VARCHAR2
132 -- x_msg_count OUT NUMBER
133 -- x_msg_data OUT VARCHAR2
134 -- Version : Current version 1.0
135 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
136 -- and basic operation, developer must manually add parameters and business logic as necessary.
137 --
138 -- End of Comments
139 -- ==============================================================================
140 --
141
142 PROCEDURE Create_Acctng_Events(
143 p_api_version_number IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151
152 p_acctng_event_rec IN acctng_event_rec_type := g_miss_acctng_event_rec,
153 x_accounting_event_id OUT NOCOPY NUMBER
154 );
155
156 -- ==============================================================================
157 -- Start of Comments
158 -- ==============================================================================
159 -- API Name
160 -- Update_Acctng_Events
161 -- Type
162 -- Private
163 -- Pre-Req
164 --
165 -- Parameters
166 --
167 -- IN
168 -- p_api_version_number IN NUMBER Required
169 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
170 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
172 -- p_acctng_event_rec IN acctng_event_rec_type Required
173 --
174 -- OUT
175 -- x_return_status OUT VARCHAR2
176 -- x_msg_count OUT NUMBER
177 -- x_msg_data OUT VARCHAR2
178 -- Version : Current version 1.0
179 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
180 -- and basic operation, developer must manually add parameters and business logic as necessary.
181 --
182 -- End of Comments
183 -- ==============================================================================
184 --
185
186 PROCEDURE Update_Acctng_Events(
187 p_api_version_number IN NUMBER,
188 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189 p_commit IN VARCHAR2 := FND_API.G_FALSE,
190 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195
196 p_acctng_event_rec IN acctng_event_rec_type,
197 x_object_version_number OUT NOCOPY NUMBER
198 );
199
200 -- ==============================================================================
201 -- Start of Comments
202 -- ==============================================================================
203 -- API Name
204 -- Delete_Acctng_Events
205 -- Type
206 -- Private
207 -- Pre-Req
208 --
209 -- Parameters
210 --
211 -- IN
212 -- p_api_version_number IN NUMBER Required
213 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
215 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216 -- p_ACCOUNTING_EVENT_ID IN NUMBER
217 -- p_object_version_number IN NUMBER Optional Default = NULL
218 --
219 -- OUT
220 -- x_return_status OUT VARCHAR2
221 -- x_msg_count OUT NUMBER
222 -- x_msg_data OUT VARCHAR2
223 -- Version : Current version 1.0
224 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
225 -- and basic operation, developer must manually add parameters and business logic as necessary.
226 --
227 -- End of Comments
228 -- ==============================================================================
229 --
230
231 PROCEDURE Delete_Acctng_Events(
232 p_api_version_number IN NUMBER,
233 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234 p_commit IN VARCHAR2 := FND_API.G_FALSE,
235 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_accounting_event_id IN NUMBER,
240 p_object_version_number IN NUMBER
241 );
242
243 -- ==============================================================================
244 -- Start of Comments
245 -- ==============================================================================
246 -- API Name
247 -- Lock_Acctng_Events
248 -- Type
249 -- Private
250 -- Pre-Req
251 --
252 -- Parameters
253 --
254 -- IN
255 -- p_api_version_number IN NUMBER Required
256 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
257 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
258 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
259 -- p_acctng_event_rec IN acctng_event_rec_type Required
260 --
261 -- OUT
262 -- x_return_status OUT VARCHAR2
263 -- x_msg_count OUT NUMBER
264 -- x_msg_data OUT VARCHAR2
265 -- Version : Current version 1.0
266 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
267 -- and basic operation, developer must manually add parameters and business logic as necessary.
268 --
269 -- End of Comments
270 -- ==============================================================================
271 --
272
273 PROCEDURE Lock_Acctng_Events(
274 p_api_version_number IN NUMBER,
275 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276
277 x_return_status OUT NOCOPY VARCHAR2,
278 x_msg_count OUT NOCOPY NUMBER,
279 x_msg_data OUT NOCOPY VARCHAR2,
280
281 p_accounting_event_id IN NUMBER,
282 p_object_version IN NUMBER
283 );
284
285
286 -- Start of Comments
287 --
288 -- validation procedures
289 --
290 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
291 -- For create: G_CREATE, for update: G_UPDATE
292 -- Note: 1. This is automated generated item level validation procedure.
293 -- The actual validation detail is needed to be added.
294 -- 2. We can also validate table instead of record. There will be an option for user to choose.
295 -- End of Comments
296
297 PROCEDURE Validate_acctng_events(
298 p_api_version_number IN NUMBER,
299 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
301 p_acctng_event_rec IN acctng_event_rec_type,
302 x_return_status OUT NOCOPY VARCHAR2,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2
305 );
306
307 -- Start of Comments
308 --
309 -- validation procedures
310 --
311 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
312 -- For create: G_CREATE, for update: G_UPDATE
313 -- Note: 1. This is automated generated item level validation procedure.
314 -- The actual validation detail is needed to be added.
315 -- 2. Validate the unique keys, lookups here
316 -- End of Comments
317
318 PROCEDURE Check_acctng_event_Items (
319 P_acctng_event_rec IN acctng_event_rec_type,
320 p_validation_mode IN VARCHAR2,
321 x_return_status OUT NOCOPY VARCHAR2
322 );
323
324 -- Start of Comments
325 --
326 -- Record level validation procedures
327 --
328 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
329 -- For create: G_CREATE, for update: G_UPDATE
330 -- Note: 1. This is automated generated item level validation procedure.
331 -- The actual validation detail is needed to be added.
332 -- 2. Developer can manually added inter-field level validation.
333 -- End of Comments
334
335 PROCEDURE Validate_acctng_event_rec(
336 p_api_version_number IN NUMBER,
337 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338 x_return_status OUT NOCOPY VARCHAR2,
339 x_msg_count OUT NOCOPY NUMBER,
340 x_msg_data OUT NOCOPY VARCHAR2,
341 p_acctng_event_rec IN acctng_event_rec_type
342 );
343 END OZF_Acctng_Events_PVT;