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