[Home] [Help]
PACKAGE: APPS.AMS_PS_POSTING_PVT
Source
1 PACKAGE AMS_Ps_Posting_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvpsts.pls 115.9 2002/12/19 04:17:07 ryedator ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Ps_Posting_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 -- ps_posting_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- created_by
26 -- creation_date
27 -- last_updated_by
28 -- last_update_date
29 -- last_update_login
30 -- object_version_number
31 -- posting_id
32 -- max_no_contents
33 -- posting_type
34 -- content_type
35 -- default_content_id
36 -- status_code
37 -- posting_name
38 -- display_name
39 -- posting_description
40 -- attribute_category
41 -- attribute1
42 -- attribute2
43 -- attribute3
44 -- attribute4
45 -- attribute5
46 -- attribute6
47 -- attribute7
48 -- attribute8
49 -- attribute9
50 -- attribute10
51 -- attribute11
52 -- attribute12
53 -- attribute13
54 -- attribute14
55 -- attribute15
56 --
57 -- Required
58 --
59 -- Defaults
60 --
61 -- Note: This is automatic generated record definition, it includes all columns
62 -- defined in the table, developer must manually add or delete some of the attributes.
63 --
64 -- End of Comments
65
66 --===================================================================
67 TYPE ps_posting_rec_type IS RECORD
68 (
69 created_by NUMBER := FND_API.G_MISS_NUM,
70 creation_date DATE := FND_API.G_MISS_DATE,
71 last_updated_by NUMBER := FND_API.G_MISS_NUM,
72 last_update_date DATE := FND_API.G_MISS_DATE,
73 last_update_login NUMBER := FND_API.G_MISS_NUM,
74 object_version_number NUMBER := FND_API.G_MISS_NUM,
75 posting_id NUMBER := FND_API.G_MISS_NUM,
76 max_no_contents NUMBER := FND_API.G_MISS_NUM,
77 posting_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78 content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
79 default_content_id NUMBER := FND_API.G_MISS_NUM,
80 status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
81 posting_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
82 display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83 posting_description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84 attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98 attribute14 VARCHAR2(100) := FND_API.G_MISS_CHAR,
99 attribute15 VARCHAR2(1000) := FND_API.G_MISS_CHAR
100 );
101
102 g_miss_ps_posting_rec ps_posting_rec_type;
103 TYPE ps_posting_tbl_type IS TABLE OF ps_posting_rec_type INDEX BY BINARY_INTEGER;
104 g_miss_ps_posting_tbl ps_posting_tbl_type;
105
106 -- =======================================================================
107 -- Start of Comments
108 -- =======================================================================
109 -- API Name
110 -- Create_Ps_Posting
111 -- Type
112 -- Private
113 -- Pre-Req
114 --
115 -- Parameters
116 --
117 -- IN
118 -- p_api_version_number IN NUMBER Required
119 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
120 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
121 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
122 -- p_ps_posting_rec IN ps_posting_rec_type Required
123 --
124 -- OUT
125 -- x_return_status OUT VARCHAR2
126 -- x_msg_count OUT NUMBER
127 -- x_msg_data OUT VARCHAR2
128 -- Version : Current version 1.0
129 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
130 -- and basic operation, developer must manually add parameters and business logic as necessary.
131 --
132 -- End of Comments
133 -- ===========================================================
134 --
135
136 PROCEDURE Create_Ps_Posting(
137 p_api_version_number IN NUMBER,
138 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139 p_commit IN VARCHAR2 := FND_API.G_FALSE,
140 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145
146 p_ps_posting_rec IN ps_posting_rec_type := g_miss_ps_posting_rec,
147 x_posting_id OUT NOCOPY NUMBER
148 );
149
150 -- =============================================================
151 -- Start of Comments
152 -- =============================================================
153 -- API Name
154 -- Update_Ps_Posting
155 -- Type
156 -- Private
157 -- Pre-Req
158 --
159 -- Parameters
160 --
161 -- IN
162 -- p_api_version_number IN NUMBER Required
163 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166 -- p_ps_posting_rec IN ps_posting_rec_type Required
167 --
168 -- OUT
169 -- x_return_status OUT VARCHAR2
170 -- x_msg_count OUT NUMBER
171 -- x_msg_data OUT VARCHAR2
172 -- Version : Current version 1.0
173 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
174 -- and basic operation, developer must manually add parameters and business logic as necessary.
175 --
176 -- End of Comments
177 -- =============================================================
178 --
179
180 PROCEDURE Update_Ps_Posting(
181 p_api_version_number IN NUMBER,
182 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183 p_commit IN VARCHAR2 := FND_API.G_FALSE,
184 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189
190 p_ps_posting_rec IN ps_posting_rec_type,
191 x_object_version_number OUT NOCOPY NUMBER
192 );
193
194 -- =============================================================
195 -- Start of Comments
196 -- =============================================================
197 -- API Name
198 -- Delete_Ps_Posting
199 -- Type
200 -- Private
201 -- Pre-Req
202 --
203 -- Parameters
204 --
205 -- IN
206 -- p_api_version_number IN NUMBER Required
207 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210 -- p_POSTING_ID IN NUMBER
211 -- p_object_version_number IN NUMBER Optional Default = NULL
212 --
213 -- OUT
214 -- x_return_status OUT VARCHAR2
215 -- x_msg_count OUT NUMBER
216 -- x_msg_data OUT VARCHAR2
217 -- Version : Current version 1.0
218 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
219 -- and basic operation, developer must manually add parameters and business logic as necessary.
220 --
221 -- End of Comments
222 -- ====================================================================
223 --
224
225 PROCEDURE Delete_Ps_Posting(
226 p_api_version_number IN NUMBER,
227 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228 p_commit IN VARCHAR2 := FND_API.G_FALSE,
229 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233 p_posting_id IN NUMBER,
234 p_object_version_number IN NUMBER
235 );
236
237 -- =======================================================================
238 -- Start of Comments
239 -- =======================================================================
240 -- API Name
241 -- Lock_Ps_Posting
242 -- Type
243 -- Private
244 -- Pre-Req
245 --
246 -- Parameters
247 --
248 -- IN
249 -- p_api_version_number IN NUMBER Required
250 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
251 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
252 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
253 -- p_ps_posting_rec IN ps_posting_rec_type Required
254 --
255 -- OUT
256 -- x_return_status OUT VARCHAR2
257 -- x_msg_count OUT NUMBER
258 -- x_msg_data OUT VARCHAR2
259 -- Version : Current version 1.0
260 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
261 -- and basic operation, developer must manually add parameters and business logic as necessary.
262 --
263 -- End of Comments
264 -- ====================================================================
265 --
266
267 PROCEDURE Lock_Ps_Posting(
268 p_api_version_number IN NUMBER,
269 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274
275 p_posting_id IN NUMBER,
276 p_object_version IN NUMBER
277 );
278
279
280 -- Start of Comments
281 --
282 -- validation procedures
283 --
284 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
285 -- For create: G_CREATE, for update: G_UPDATE
286 -- Note: 1. This is automated generated item level validation procedure.
287 -- The actual validation detail is needed to be added.
288 -- 2. We can also validate table instead of record. There will be an option for user to choose.
289 -- End of Comments
290
291 PROCEDURE Validate_ps_posting(
292 p_api_version_number IN NUMBER,
293 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295 p_ps_posting_rec IN ps_posting_rec_type,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2
299 );
300
301 -- Start of Comments
302 --
303 -- validation procedures
304 --
305 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
306 -- For create: G_CREATE, for update: G_UPDATE
307 -- Note: 1. This is automated generated item level validation procedure.
308 -- The actual validation detail is needed to be added.
309 -- 2. Validate the unique keys, lookups here
310 -- End of Comments
311
312 /****************************************************************************/
313 -- Procedure
314 -- Check_ps_posting_Items
315 -- Purpose
316 -- item_level validate
317 -- Parameters
318 -- IN:
319 -- p_validation_mode IN VARCHAR2
320 -- p_ps_posting_rec IN ps_posting_rec_type,
321 -- OUT:
322 -- x_return_status OUT VARCHAR2
323 ------------------------------------------------------------------------------
324 PROCEDURE Check_ps_posting_Items
325 (
326 p_ps_posting_rec IN ps_posting_rec_type,
327 p_validation_mode IN VARCHAR2,
328 x_return_status OUT NOCOPY VARCHAR2
329 );
330
331 /****************************************************************************/
332 -- Procedure
333 -- check_ps_posting_req_items
334 -- Purpose
335 -- check if required items are miss
336 -- Parameters
337 -- IN:
338 -- p_validation_mode IN VARCHAR2
339 -- p_ps_posting_rec IN ps_posting_rec_type,
340 -- OUT:
341 -- x_return_status OUT VARCHAR2
342 ------------------------------------------------------------------------------
343 PROCEDURE check_ps_posting_req_items
344 (
345 p_validation_mode IN VARCHAR2,
346 p_ps_posting_rec IN ps_posting_rec_type,
347 x_return_status OUT NOCOPY VARCHAR2
348 );
349
350 /****************************************************************************/
351 -- Procedure
352 -- check_ps_posting_fk_items
353 -- Purpose
354 -- check foreign key items
355 -- Parameters
356 -- IN:
357 -- p_ps_posting_rec IN ps_posting_rec_type
358 -- OUT:
359 -- x_return_status OUT VARCHAR2
360 ------------------------------------------------------------------------------
361 PROCEDURE check_ps_posting_fk_items
362 (
363 p_ps_posting_rec IN ps_posting_rec_type,
364 x_return_status OUT NOCOPY VARCHAR2
365 );
366
367 -- Start of Comments
368 --
369 -- Record level validation procedures
370 --
371 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
372 -- For create: G_CREATE, for update: G_UPDATE
373 -- Note: 1. This is automated generated item level validation procedure.
374 -- The actual validation detail is needed to be added.
375 -- 2. Developer can manually added inter-field level validation.
376 -- End of Comments
377
378 PROCEDURE Validate_ps_posting_rec(
379 p_api_version_number IN NUMBER,
380 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
381 x_return_status OUT NOCOPY VARCHAR2,
382 x_msg_count OUT NOCOPY NUMBER,
383 x_msg_data OUT NOCOPY VARCHAR2,
384 p_ps_posting_rec IN ps_posting_rec_type
385 );
386 END AMS_Ps_Posting_PVT;