[Home] [Help]
PACKAGE: APPS.OZF_FUNDTHRESHOLD_PVT
Source
1 PACKAGE OZF_Fundthreshold_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvthrs.pls 115.4 2004/01/21 20:11:48 kvattiku noship $ */
3 -- ===============================================================
4
5 -- Start of Comments
6 -- Package name
7 -- OZF_Fundthreshold_PVT
8 -- Purpose
9 --
10 -- History
11 --Jan 20, 2004 kvattiku......changed the description field in threshold_rec_type
12 -- to VARCHAR2(2000) from VARCHAR2(240)....bug 3386996..
13 --
14 -- NOTE
15 --
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- threshold_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- threshold_id
29 -- last_update_date
30 -- last_updated_by
31 -- last_update_login
32 -- creation_date
33 -- created_by
34 -- created_from
35 -- request_id
36 -- program_application_id
37 -- program_id
38 -- program_update_date
39 -- threshold_calendar
40 -- start_period_name
41 -- end_period_name
42 -- start_date_active
43 -- end_date_active
44 -- owner
45 -- enable_flag
46 -- attribute_category
47 -- attribute1
48 -- attribute2
49 -- attribute3
50 -- attribute4
51 -- attribute5
52 -- attribute6
53 -- attribute7
54 -- attribute8
55 -- attribute9
56 -- attribute10
57 -- attribute11
58 -- attribute12
59 -- attribute13
60 -- attribute14
61 -- attribute15
62 -- org_id
63 -- security_group_id
64 -- object_version_number
65 -- name
66 -- description
67 -- language
68 -- source_lang
69 --
70 -- Required
71 --
72 -- Defaults
73 --
74 -- Note: This is automatic generated record definition, it includes all columns
75 -- defined in the table, developer must manually add or delete some of the attributes.
76 --
77 -- End of Comments
78
79 --===================================================================
80 TYPE threshold_rec_type IS RECORD
81 (
82 threshold_id NUMBER ,
83 last_update_date DATE ,
84 last_updated_by NUMBER ,
85 last_update_login NUMBER ,
86 creation_date DATE ,
87 created_by NUMBER ,
88 created_from VARCHAR2(30) ,
89 request_id NUMBER ,
90 program_application_id NUMBER ,
91 program_id NUMBER ,
92 program_update_date DATE ,
93 threshold_calendar VARCHAR2(30) ,
94 start_period_name VARCHAR2(15) ,
95 end_period_name VARCHAR2(15) ,
96 start_date_active DATE ,
97 end_date_active DATE ,
98 owner NUMBER ,
99 enable_flag VARCHAR2(1) ,
100 attribute_category VARCHAR2(30) ,
101 attribute1 VARCHAR2(150),
102 attribute2 VARCHAR2(150) ,
103 attribute3 VARCHAR2(150) ,
104 attribute4 VARCHAR2(150) ,
105 attribute5 VARCHAR2(150) ,
106 attribute6 VARCHAR2(150) ,
107 attribute7 VARCHAR2(150) ,
108 attribute8 VARCHAR2(150) ,
109 attribute9 VARCHAR2(150) ,
110 attribute10 VARCHAR2(150) ,
111 attribute11 VARCHAR2(150) ,
112 attribute12 VARCHAR2(150) ,
113 attribute13 VARCHAR2(150) ,
114 attribute14 VARCHAR2(150) ,
115 attribute15 VARCHAR2(150) ,
116 org_id NUMBER ,
117 security_group_id NUMBER ,
118 object_version_number NUMBER ,
119 name VARCHAR2(80) ,
120 description VARCHAR2(2000),
121 language VARCHAR2(4) ,
122 source_lang VARCHAR2(4),
123 threshold_type VARCHAR2(30)
124 );
125
126 g_miss_threshold_rec threshold_rec_type;
127 TYPE threshold_tbl_type IS TABLE OF threshold_rec_type INDEX BY BINARY_INTEGER;
128 g_miss_threshold_tbl threshold_tbl_type;
129
130 -- ==============================================================================
131 -- Start of Comments
132 -- ==============================================================================
133 -- API Name
134 -- Create_Threshold
135 -- Type
136 -- Private
137 -- Pre-Req
138 --
139 -- Parameters
140 --
141 -- IN
142 -- p_api_version_number IN NUMBER Required
143 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146 -- p_threshold_rec IN threshold_rec_type Required
147 --
148 -- OUT
149 -- x_return_status OUT VARCHAR2
150 -- x_msg_count OUT NUMBER
151 -- x_msg_data OUT VARCHAR2
152 -- Version : Current version 1.0
153 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
154 -- and basic operation, developer must manually add parameters and business logic as necessary.
155 --
156 -- End of Comments
157 -- ==============================================================================
158 --
159
160 PROCEDURE Create_Threshold(
161 p_api_version_number IN NUMBER,
162 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163 p_commit IN VARCHAR2 := FND_API.G_FALSE,
164 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169
170 p_threshold_rec IN threshold_rec_type := g_miss_threshold_rec,
171 x_threshold_id OUT NOCOPY NUMBER
172 );
173
174 -- ==============================================================================
175 -- Start of Comments
176 -- ==============================================================================
177 -- API Name
178 -- Update_Threshold
179 -- Type
180 -- Private
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_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
190 -- p_threshold_rec IN threshold_rec_type Required
191 --
192 -- OUT
193 -- x_return_status OUT VARCHAR2
194 -- x_msg_count OUT NUMBER
195 -- x_msg_data OUT VARCHAR2
196 -- Version : Current version 1.0
197 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
198 -- and basic operation, developer must manually add parameters and business logic as necessary.
199 --
200 -- End of Comments
201 -- ==============================================================================
202 --
203
204 PROCEDURE Update_Threshold(
205 p_api_version_number IN NUMBER,
206 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207 p_commit IN VARCHAR2 := FND_API.G_FALSE,
208 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213
214 p_threshold_rec IN threshold_rec_type,
215 x_object_version_number OUT NOCOPY NUMBER
216 );
217
218 -- ==============================================================================
219 -- Start of Comments
220 -- ==============================================================================
221 -- API Name
222 -- Delete_Threshold
223 -- Type
224 -- Private
225 -- Pre-Req
226 --
227 -- Parameters
228 --
229 -- IN
230 -- p_api_version_number IN NUMBER Required
231 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
232 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
233 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
234 -- p_THRESHOLD_ID IN NUMBER
235 -- p_object_version_number IN NUMBER Optional Default = NULL
236 --
237 -- OUT
238 -- x_return_status OUT VARCHAR2
239 -- x_msg_count OUT NUMBER
240 -- x_msg_data OUT VARCHAR2
241 -- Version : Current version 1.0
242 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
243 -- and basic operation, developer must manually add parameters and business logic as necessary.
244 --
245 -- End of Comments
246 -- ==============================================================================
247 --
248
249 PROCEDURE Delete_Threshold(
250 p_api_version_number IN NUMBER,
251 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252 p_commit IN VARCHAR2 := FND_API.G_FALSE,
253 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_threshold_id IN NUMBER,
258 p_object_version_number IN NUMBER
259 );
260
261 -- ==============================================================================
262 -- Start of Comments
263 -- ==============================================================================
264 -- API Name
265 -- Lock_Threshold
266 -- Type
267 -- Private
268 -- Pre-Req
269 --
270 -- Parameters
271 --
272 -- IN
273 -- p_api_version_number IN NUMBER Required
274 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
275 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
276 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
277 -- p_threshold_rec IN threshold_rec_type Required
278 --
279 -- OUT
280 -- x_return_status OUT VARCHAR2
281 -- x_msg_count OUT NUMBER
282 -- x_msg_data OUT VARCHAR2
283 -- Version : Current version 1.0
284 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
285 -- and basic operation, developer must manually add parameters and business logic as necessary.
286 --
287 -- End of Comments
288 -- ==============================================================================
289 --
290
291 PROCEDURE Lock_Threshold(
292 p_api_version_number IN NUMBER,
293 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294
295 x_return_status OUT NOCOPY VARCHAR2,
296 x_msg_count OUT NOCOPY NUMBER,
297 x_msg_data OUT NOCOPY VARCHAR2,
298
299 p_threshold_id IN NUMBER,
300 p_object_version IN NUMBER
301 );
302
303
304 -- Start of Comments
305 --
306 -- validation procedures
307 --
308 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
309 -- For create: G_CREATE, for update: G_UPDATE
310 -- Note: 1. This is automated generated item level validation procedure.
311 -- The actual validation detail is needed to be added.
312 -- 2. We can also validate table instead of record. There will be an option for user to choose.
313 -- End of Comments
314
315 PROCEDURE Validate_threshold(
316 p_api_version_number IN NUMBER,
317 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
319 p_threshold_rec IN threshold_rec_type,
320 x_return_status OUT NOCOPY VARCHAR2,
321 x_msg_count OUT NOCOPY NUMBER,
322 x_msg_data OUT NOCOPY VARCHAR2
323 );
324
325 -- Start of Comments
326 --
327 -- validation procedures
328 --
329 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
330 -- For create: G_CREATE, for update: G_UPDATE
331 -- Note: 1. This is automated generated item level validation procedure.
332 -- The actual validation detail is needed to be added.
336 PROCEDURE Check_threshold_Items (
333 -- 2. Validate the unique keys, lookups here
334 -- End of Comments
335
337 P_threshold_rec IN threshold_rec_type,
338 p_validation_mode IN VARCHAR2,
339 x_return_status OUT NOCOPY VARCHAR2
340 );
341
342 -- Start of Comments
343 --
344 -- Record level validation procedures
345 --
346 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
347 -- For create: G_CREATE, for update: G_UPDATE
348 -- Note: 1. This is automated generated item level validation procedure.
349 -- The actual validation detail is needed to be added.
350 -- 2. Developer can manually added inter-field level validation.
351 -- End of Comments
352
353 PROCEDURE Validate_threshold_rec(
354 p_api_version_number IN NUMBER,
355 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
356 x_return_status OUT NOCOPY VARCHAR2,
357 x_msg_count OUT NOCOPY NUMBER,
358 x_msg_data OUT NOCOPY VARCHAR2,
359 p_threshold_rec IN threshold_rec_type
360 );
361
362
363 PROCEDURE Complete_threshold_Rec (
364 P_threshold_rec IN threshold_rec_type,
365 x_complete_rec OUT NOCOPY threshold_rec_type
366 );
367 END OZF_Fundthreshold_PVT;