[Home] [Help]
PACKAGE: APPS.AMS_THLDCHK_PVT
Source
1 PACKAGE AMS_ThldChk_PVT AUTHID CURRENT_USER as
2 /* $Header: amsvthcs.pls 115.14 2002/11/22 23:39:27 dbiswas ship $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AMS_Thldchk_PVT
8 --
9 -- PURPOSE
10 -- This package is a Private API for managing Trigger Checks information in
11 -- AMS. It contains specification for pl/sql records and tables
12 --
13 -- Procedures:
14 --
15 -- ams_trigger_checks:
16 --
17 -- Create_Thldchk (see below for specification)
18 -- Update_Thldchk (see below for specification)
19 -- Delete_Thldchk (see below for specification)
20 -- Lock_Thldchk (see below for specification)
21 -- Validate_Thldchk (see below for specification)
22 -- Check_Thldchk_Items (see below for specification)
23 -- Check_Thldchk_Record (see below for specification)
24 -- Init_Thldchk_Rec (see below for specification)
25 -- Complete_Thldchk_rec (see below for specification)
26 --
27 --
28 -- NOTES
29 --
30 --
31 -- HISTORY
32 -- 06/29/1999 ptendulk created
33 -- 15-Feb-2001 ptendulk Modified for Hornet release ,
34 -- Added chk1/chk2 object ids in record type.
35 -- End of Comments
36 --
37 -- ams_trigger_checks
38 --
39 TYPE thldchk_rec_type IS RECORD
40 (
41 -- PK
42 trigger_check_id NUMBER ,
43 last_update_date DATE ,
44 last_updated_by NUMBER ,
45 creation_date DATE,
46 created_by NUMBER,
47 last_update_login NUMBER,
48 object_version_number NUMBER,
49 trigger_id NUMBER,
50 order_number NUMBER,
51 chk1_type VARCHAR2(30),
52 chk1_arc_source_code_from VARCHAR2(30),
53 chk1_act_object_id NUMBER,
54 chk1_source_code VARCHAR2(30),
55 chk1_source_code_metric_id NUMBER,
56 chk1_source_code_metric_type VARCHAR2(30),
57 chk1_workbook_owner NUMBER,
58 chk1_workbook_name VARCHAR2(254),
59 chk1_to_chk2_operator_type VARCHAR2(30),
60 chk2_type VARCHAR2(30),
61 chk2_value NUMBER,
62 chk2_low_value NUMBER,
63 chk2_high_value NUMBER,
64 chk2_uom_code VARCHAR2(3),
65 chk2_currency_code VARCHAR2(15),
66 chk2_source_code VARCHAR2(30),
67 chk2_arc_source_code_from VARCHAR2(30),
68 chk2_act_object_id NUMBER,
69 chk2_source_code_metric_id NUMBER,
70 chk2_source_code_metric_type VARCHAR2(30),
71 chk2_workbook_name VARCHAR2(254),
72 chk2_workbook_owner VARCHAR2(100),
73 chk2_worksheet_name VARCHAR2(254)
74 --
75 );
76
77
78 --
79 -- Start of Comments
80 --
81 --SQL> desc ams_trigger_checks ;
82 -- Name Null? Type
83 -- ----------------------------------------------------- -------- -----------------------
84 -- TRIGGER_CHECK_ID NOT NULL NUMBER
85 -- LAST_UPDATE_DATE NOT NULL DATE
86 -- LAST_UPDATED_BY NOT NULL NUMBER(15)
87 -- CREATION_DATE NOT NULL DATE
88 -- CREATED_BY NOT NULL NUMBER(15)
89 -- LAST_UPDATE_LOGIN NUMBER(15)
90 -- OBJECT_VERSION_NUMBER NUMBER(9)
91 -- TRIGGER_ID NOT NULL NUMBER
92 -- ORDER_NUMBER NOT NULL NUMBER(15)
93 -- CHK1_TYPE NOT NULL VARCHAR2(30)
94 -- CHK1_ARC_SOURCE_CODE_FROM VARCHAR2(30)
95 -- CHK1_SOURCE_CODE VARCHAR2(30)
96 -- CHK1_SOURCE_CODE_METRIC_ID NUMBER
97 -- CHK1_SOURCE_CODE_METRIC_TYPE VARCHAR2(30)
98 -- CHK1_WORKBOOK_OWNER NUMBER(15)
99 -- CHK1_WORKBOOK_NAME VARCHAR2(254)
100 -- CHK1_TO_CHK2_OPERATOR_TYPE NOT NULL VARCHAR2(30)
101 -- CHK2_TYPE NOT NULL VARCHAR2(30)
102 -- CHK2_VALUE NUMBER(15)
103 -- CHK2_LOW_VALUE NUMBER(15)
104 -- CHK2_HIGH_VALUE NUMBER(15)
105 -- CHK2_SOURCE_CODE VARCHAR2(30)
106 -- CHK2_ARC_SOURCE_CODE_FROM VARCHAR2(30)
107 -- CHK2_SOURCE_CODE_METRIC_ID NUMBER
108 -- CHK2_SOURCE_CODE_METRIC_TYPE VARCHAR2(30)
109 -- CHK2_WORKBOOK_NAME VARCHAR2(254)
110 -- CHK2_WORKBOOK_OWNER VARCHAR2(100)
111 -- CHK2_UOM_CODE VARCHAR2(3)
112 -- CHK2_CURRENCY_CODE VARCHAR2(15)
113 -- CHK2_WORKSHEET_NAME VARCHAR2(254)
114 -- CHK1_ACT_OBJECT_ID NUMBER
115 -- CHK2_ACT_OBJECT_ID NUMBER
116 -----
117 -- End of Comments
118 --
119
120
121 -- global constants
122 ----------------------------------------------------------------------------------------
123 ----------------------------------------------------------------------------------------
124 ----------------------------------------------------------------------------------------
125 -------------------------------- AMS_TRIGGER_CHECKS-------------------------------------
126 ----------------------------------------------------------------------------------------
127 ----------------------------------------------------------------------------------------
128 ----------------------------------------------------------------------------------------
129
130
131 /*****************************************************************************************/
132 -- Start of Comments
133 --
134 -- API name : Create_Thldchk
135 -- Type : Private
136 -- Function : Create a row in ams_trigger_checks table
137 --
138 -- Pre-reqs : None
139 -- Paramaeters :
140 -- IN :
141 -- standard IN parameters
142 -- p_api_version IN NUMBER := NULL Required
143 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144 -- p_commit IN VARCHAR2 := FND_API.G_FALSE, Optional
145 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146 --
147 -- API's IN parameters
148 -- p_Thldchk_Rec IN thldchk_rec_type,
149 -- OUT :
150 -- standard OUT parameters
151 -- x_return_status OUT VARCHAR2(1)
152 -- x_msg_count OUT NUMBER
153 -- x_msg_data OUT VARCHAR2(2000)
154 --
155 --
156 -- API's OUT parameters
157 -- x_trigger_check_id OUT NUMBER
158 --
159 --
160 -- Version : Current version 1.0
161 -- Initial version 1.0
162 --
163 -- Business rules:
164 -- 1. ...
165 --
166 --
167 -- End Of Comments
168
169 PROCEDURE Create_thldchk
170 ( p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
172 p_commit IN VARCHAR2 := FND_API.G_False,
173 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177
178 p_thldchk_Rec IN thldchk_rec_type,
179 x_trigger_check_id OUT NOCOPY NUMBER
180 );
181
182 /*****************************************************************************************/
183 -- Start of Comments
184 --
185 -- API name : Update_Thldchk
186 -- Type : Private
187 -- Function : Update a row in ams_trigger_checks table
188 --
189 -- Pre-reqs : None
190 -- Paramaeters :
191 -- IN :
192 -- standard IN parameters
193 -- p_api_version IN NUMBER := NULL Required
194 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
195 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
196 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197 -- API's IN parameters
198 -- p_thldchk_rec IN thldchk_rec_type
199
200 -- OUT :
201 -- standard OUT parameters
202 -- x_return_status OUT VARCHAR2(1)
203 -- x_msg_count OUT NUMBER
204 -- x_msg_data OUT VARCHAR2(2000)
205 --
206 --
207 -- Version : Current version 1.0
208 -- Initial version 1.0
209 -- Business rules:
210 -- 1. ...
211 --
212 -- End Of Comments
213
214 PROCEDURE Update_Thldchk
215 ( p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
217 p_commit IN VARCHAR2 := FND_API.G_False,
218 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223
224 p_thldchk_rec IN thldchk_rec_type
225 );
226
227 /*****************************************************************************************/
228 -- Start of Comments
229 --
230 -- API name : Delete_Thldchk
231 -- Type : Private
232 -- Function : Delete a row in ams_trigger_checks table
233 --
234 -- Pre-reqs : None
235 -- Paramaeters :
236 -- IN :
237 -- standard IN parameters
238 -- p_api_version IN NUMBER := NULL Required
239 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
240 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
241 -- API's IN parameters
242 -- p_trigger_check_id IN NUMBER,
243 -- p_object_version_number IN NUMBER
244 --
245 -- OUT :
246 -- standard OUT parameters
247 -- x_return_status OUT VARCHAR2(1)
248 -- x_msg_count OUT NUMBER
249 -- x_msg_data OUT VARCHAR2(2000)
250 --
251 -- Version : Current version 1.0
252 -- Initial version 1.0
253 --
254 -- Business rules:
255 -- 1. ...
256 --
257 -- End Of Comments
258
259 PROCEDURE Delete_Thldchk
260 ( p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
262 p_commit IN VARCHAR2 := FND_API.G_False,
263
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267
268 p_trigger_check_id IN NUMBER,
269 p_object_version_number IN NUMBER
270 );
271
272
273 /******************************************************************************/
274 -- Start of Comments
275 --
276 -- API name : Lock_Thldchk
277 -- Type : Private
278 -- Function : Lock a row in ams_trigger_checks
279 --
280 -- Pre-reqs : None
281 -- Paramaeters :
282 -- IN :
283 -- standard IN parameters
284 -- p_api_version IN NUMBER := NULL Required
285 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
286 --
287 -- API's IN parameters
288 -- p_trigger_check_id IN NUMBER
289 -- p_object_version_number IN NUMBER
290 --
291 -- OUT :
292 -- standard OUT parameters
293 -- x_return_status OUT VARCHAR2(1)
294 -- x_msg_count OUT NUMBER
295 -- x_msg_data OUT VARCHAR2(2000)
296 --
297 --
298 -- Version : Current version 1.0
299 -- Initial version 1.0
300 --
301 -- End Of Comments
302
303
304
305 PROCEDURE Lock_Thldchk
306 ( p_api_version IN NUMBER,
307 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
308
309 x_return_status OUT NOCOPY VARCHAR2,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_msg_data OUT NOCOPY VARCHAR2,
312
313 p_trigger_check_id IN NUMBER,
314 p_object_version_number IN NUMBER
315 );
316
317
318 /******************************************************************************/
319 -- Start of Comments
320 --
321 -- API name : Validate_Thldchk
322 -- Type : Private
323 -- Function : Validate a row in ams_trigger_checks table
324 --
325 -- Pre-reqs : None
326 -- Paramaeters :
327 -- IN :
328 -- standard IN parameters
329 -- p_api_version IN NUMBER := NULL Required
330 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
331 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
332 --
333 -- API's IN parameters
334 -- p_thldchk_Rec IN thldchk_rec_type
335 --
336 -- OUT :
337 -- standard OUT parameters
338 -- x_return_status OUT VARCHAR2(1)
339 -- x_msg_count OUT NUMBER
340 -- x_msg_data OUT VARCHAR2(2000)
341 --
342 -- API's OUT parameters
343 -- x_thldchk_rec OUT thldchk_rec_type
344 --
345 --
346 -- Version : Current version 1.0
347 -- Initial version 1.0
348 --
349 -- End Of Comments
350
351 PROCEDURE Validate_Thldchk
352 ( p_api_version IN NUMBER,
353 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
354 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355 x_return_status OUT NOCOPY VARCHAR2,
356 x_msg_count OUT NOCOPY NUMBER,
357 x_msg_data OUT NOCOPY VARCHAR2,
358
359 p_thldchk_Rec IN thldchk_rec_type
360
361 );
362
363 /******************************************************************************/
364 -- Start of Comments
365 --
366 -- Name : Validate_Thldchk_Items
367 -- Type : Private
368 -- Function : Validate columns in ams_trigger_checks
369 --
370 -- Pre-reqs : None
371 -- Paramaeters :
372 -- IN :
373 -- p_thldchk_rec IN thldchk_rec_type,
374 -- p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
375 -- OUT :
376 -- x_return_status OUT VARCHAR2
377 --
378 -- Business rules:
379 -- 1. ...
380 --
381 -- End Of Comments
382
383 PROCEDURE Check_Thldchk_Items(
384 p_thldchk_rec IN thldchk_rec_type,
385 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
386 x_return_status OUT NOCOPY VARCHAR2
387 );
388
392 -- API name : Validate_Thldchk_Record
389 /*****************************************************************************************/
390 -- Start of Comments
391 --
393 -- Type : Private
394 -- Function : Validate a row in ams_trigger_checks table
395 --
396 -- Pre-reqs : None
397 -- Paramaeters :
398 -- IN :
399 -- standard IN parameters
400 --
401 -- API's IN parameters
402 -- p_Thldchk_rec IN thldchk_rec_type
403 -- p_complete_rec IN thldchk_rec_type,
404 --
405 -- OUT :
406 -- standard OUT parameters
407 -- x_return_status OUT VARCHAR2(1)
408 --
409 -- Version : Current version 1.0
410 -- Initial version 1.0
411 --
412 -- Business rules:
413 -- 1. ...
414 --
415 -- End Of Comments
416
417 PROCEDURE Check_Thldchk_Record(
418 p_thldchk_rec IN thldchk_rec_type,
419 p_complete_rec IN thldchk_rec_type,
420 x_return_status OUT NOCOPY VARCHAR2
421 );
422
423
424 /*****************************************************************************************/
425 -- Start of Comments
426 --
427 -- Name : Init_Thldchk_Rec
428 -- Type : Private
429 -- Function : CInitialize the Record type before Updation
430 --
431 -- Pre-reqs : None
432 -- Paramaeters :
433 -- IN :
434 -- p_thldchk_rec IN thldchk_rec_type Required
435 -- p_thldchk_req_item_rec IN thldchk_validate_rec_type,
436 --
437 -- OUT :
438 -- x_return_status OUT VARCHAR2
439 --
440 --
441 -- End Of Comments
442
443 PROCEDURE Init_Thldchk_Rec(
444 x_thldchk_rec OUT NOCOPY thldchk_rec_type
445 );
446
447 /*****************************************************************************************/
448 -- Start of Comments
449 --
450 -- Name : Complete_Thldchk_rec
451 -- Type : Private
452 -- Function : Complete the record as we don't pass whole record for Updation
453 --
454 -- Pre-reqs : None
455 -- Paramaeters :
456 -- IN :
457 -- p_thldchk_rec IN thldchk_rec_type Required
458 --
459 -- OUT :
460 -- x_complete_rec OUT thldchk_rec_type
461 --
462 -- Business rules:
463 -- 1. ...
464 --
465 -- End Of Comments
466 PROCEDURE Complete_Thldchk_rec(
467 p_thldchk_rec IN thldchk_rec_type,
468 x_complete_rec OUT NOCOPY thldchk_rec_type
469 )
470 ;
471
472
473
474 END AMS_ThldChk_PVT;