[Home] [Help]
PACKAGE: APPS.AMS_THLDACT_PVT
Source
1 PACKAGE AMS_ThldAct_PVT AUTHID CURRENT_USER as
2 /* $Header: amsvthas.pls 115.12 2003/07/03 14:23:07 cgoyal ship $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AMS_thldact_PVT
8 --
9 -- PURPOSE
10 -- This package is a Private API for managing Trigger Actions information in
11 -- AMS. It contains specification for pl/sql records and tables
12 --
13 -- Procedures:
14 --
15 -- ams_trigger_Actions:
16 --
17 -- Create_thldact (see below for specification)
18 -- Update_thldact (see below for specification)
19 -- Delete_thldact (see below for specification)
20 -- Lock_thldact (see below for specification)
21 -- Validate_thldact (see below for specification)
22 -- Check_thldact_Items (see below for specification)
23 -- Check_thldact_Record (see below for specification)
24 -- Init_thldact_Rec (see below for specification)
25 -- Complete_thldact_rec (see below for specification)
26 --
27 --
28 -- NOTES
29 --
30 --
31 -- HISTORY
32 -- 06/29/1999 ptendulk created
33 -- 12/27/1999 ptendulk Modified (added new Columns Del_id,..)
34 -- 09/08/2000 ptendulk Added Additional 4 columns for fulfillment
35 -- 22/04/03 cgoyal added ACTION_NOTIF_USER_ID column for 11.5.8 backport
36 -- End of Comments
37 --
38 -- ams_trigger_actions
39 --
40 TYPE thldact_rec_type IS RECORD
41 (
42 -- PK
43 trigger_action_id NUMBER ,
44 last_update_date DATE ,
45 last_updated_by NUMBER ,
46 creation_date DATE,
47 created_by NUMBER,
48 last_update_login NUMBER,
49 object_version_number NUMBER,
50
51 process_id NUMBER,
52 trigger_id NUMBER,
53 order_number NUMBER,
54
55 notify_flag VARCHAR2(1),
56 --ACTION_NOTIF_USER_ID NUMBER := NULL,
57 generate_list_flag VARCHAR2(1),
58 action_need_approval_flag VARCHAR2(1),
59 action_approver_user_id NUMBER,
60 execute_action_type VARCHAR2(30),
61 list_header_id NUMBER,
62 list_connected_to_id NUMBER,
63 arc_list_connected_to VARCHAR2(30),
64 deliverable_id NUMBER,
65 activity_offer_id NUMBER,
66 dscript_name VARCHAR2(256),
67 program_to_call VARCHAR2(30)
68 ,cover_letter_id NUMBER
69 ,mail_subject VARCHAR2(240)
70 ,mail_sender_name VARCHAR2(120)
71 ,from_fax_no VARCHAR2(25)
72 --soagrawa 30-apr-2003 for trigger backporting
73 , action_for_id NUMBER
74 );
75
76
77 --
78 -- Start of Comments
79 --
80 --SQL> desc ams_trigger_actions ;
81 -- Name Null? Type
82 -- ----------------------------------------------------- -------- -----------------
83 -- TRIGGER_ACTION_ID NOT NULL NUMBER
84 -- LAST_UPDATE_DATE NOT NULL DATE
85 -- LAST_UPDATED_BY NOT NULL NUMBER(15)
86 -- CREATION_DATE NOT NULL DATE
87 -- CREATED_BY NOT NULL NUMBER(15)
88 -- LAST_UPDATE_LOGIN NUMBER(15)
89 -- OBJECT_VERSION_NUMBER NUMBER(9)
90 -- PROCESS_ID NUMBER
91 -- TRIGGER_ID NOT NULL NUMBER
92 -- ORDER_NUMBER NUMBER(15)
93 -- NOTIFY_FLAG NOT NULL VARCHAR2(1)
94 -- ACTION_NOTIF_USER_ID NUMBER
95 -- G-ENERATE_LIST_FLAG NOT NULL VARCHAR2(1)
96 -- ACTION_NEED_APPROVAL_FLAG NOT NULL VARCHAR2(1)
97 -- ACTION_APPROVER_USER_ID NUMBER
98 -- EXECUTE_ACTION_TYPE VARCHAR2(30)
99 -- LIST_HEADER_ID NUMBER
100 -- LIST_CONNECTED_TO_ID NUMBER
101 -- ARC_LIST_CONNECTED_TO VARCHAR2(30)
102 -- PROGRAM_TO_CALL VARCHAR2(30)
103 ----
104 ---
105 -- End of Comments
106 --
107
108
109 -- global constants
110 ----------------------------------------------------------------------------------------
111 ----------------------------------------------------------------------------------------
112 ----------------------------------------------------------------------------------------
113 -------------------------------- AMS_TRIGGER_ACTIONS-------------------------------------
114 ----------------------------------------------------------------------------------------
115 ----------------------------------------------------------------------------------------
116 ----------------------------------------------------------------------------------------
117
118
119 /*****************************************************************************************/
120 -- Start of Comments
121 --
122 -- API name : Create_thldact
123 -- Type : Private
124 -- Function : Create a row in ams_trigger_actions table
125 --
126 -- Pre-reqs : None
127 -- Paramaeters :
128 -- IN :
129 -- standard IN parameters
130 -- p_api_version IN NUMBER := NULL Required
131 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132 -- p_commit IN VARCHAR2 := FND_API.G_FALSE, Optional
133 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134 --
135 -- API's IN parameters
136 -- p_thldact_Rec IN thldact_rec_type,
137 -- OUT :
138 -- standard OUT parameters
139 -- x_return_status OUT VARCHAR2(1)
140 -- x_msg_count OUT NUMBER
141 -- x_msg_data OUT VARCHAR2(2000)
142 --
143 --
144 -- API's OUT parameters
145 -- x_trigger_action_id OUT NUMBER
146 --
147 --
148 -- Version : Current version 1.0
149 -- Initial version 1.0
150 --
151 -- End Of Comments
152
153 PROCEDURE Create_thldact
154 ( p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
156 p_commit IN VARCHAR2 := FND_API.G_False,
157 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161
162 p_thldact_Rec IN thldact_rec_type,
163 x_trigger_action_id OUT NOCOPY NUMBER
164 );
165
166 /*****************************************************************************************/
167 -- Start of Comments
168 --
169 -- API name : Update_thldact
170 -- Type : Private
171 -- Function : Update a row in ams_trigger_actions table
172 --
173 -- Pre-reqs : None
174 -- Paramaeters :
175 -- IN :
176 -- standard IN parameters
177 -- p_api_version IN NUMBER := NULL Required
178 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
179 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
180 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181 -- API's IN parameters
182 -- p_thldact_rec IN thldact_rec_type
183
184 -- OUT :
185 -- standard OUT parameters
186 -- x_return_status OUT VARCHAR2(1)
187 -- x_msg_count OUT NUMBER
188 -- x_msg_data OUT VARCHAR2(2000)
189 --
190 --
191 -- Version : Current version 1.0
192 -- Initial version 1.0
193 -- End Of Comments
194
195 PROCEDURE Update_thldact
196 ( p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
198 p_commit IN VARCHAR2 := FND_API.G_False,
199 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204
205 p_thldact_rec IN thldact_rec_type
206 );
207
208 /*****************************************************************************************/
209 -- Start of Comments
210 --
211 -- API name : Delete_thldact
212 -- Type : Private
213 -- Function : Delete a row in ams_trigger_actions table
214 --
215 -- Pre-reqs : None
216 -- Paramaeters :
217 -- IN :
218 -- standard IN parameters
219 -- p_api_version IN NUMBER := NULL Required
220 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
221 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
222 -- API's IN parameters
223 -- p_trigger_action_id IN NUMBER,
224 -- p_object_version_number IN NUMBER
225 --
226 -- OUT :
227 -- standard OUT parameters
228 -- x_return_status OUT VARCHAR2(1)
229 -- x_msg_count OUT NUMBER
230 -- x_msg_data OUT VARCHAR2(2000)
231 --
232 -- Version : Current version 1.0
233 -- Initial version 1.0
234 --
235 -- End Of Comments
236
237 PROCEDURE Delete_thldact
238 ( p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
240 p_commit IN VARCHAR2 := FND_API.G_False,
241
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245
246 p_trigger_action_id IN NUMBER,
247 p_object_version_number IN NUMBER
248 );
249
250
251 /******************************************************************************/
252 -- Start of Comments
253 --
254 -- API name : Lock_thldact
255 -- Type : Private
256 -- Function : Lock a row in ams_trigger_actions
257 --
258 -- Pre-reqs : None
259 -- Paramaeters :
260 -- IN :
261 -- standard IN parameters
262 -- p_api_version IN NUMBER := NULL Required
263 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
264 --
265 -- API's IN parameters
266 -- p_trigger_action_id IN NUMBER
267 -- p_object_version_number IN NUMBER
268 --
269 -- OUT :
270 -- standard OUT parameters
271 -- x_return_status OUT VARCHAR2(1)
272 -- x_msg_count OUT NUMBER
273 -- x_msg_data OUT VARCHAR2(2000)
274 --
275 --
276 -- Version : Current version 1.0
277 -- Initial version 1.0
278 --
279 -- End Of Comments
280
281
282
283 PROCEDURE Lock_thldact
284 ( p_api_version IN NUMBER,
285 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
286
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2,
290
291 p_trigger_action_id IN NUMBER,
292 p_object_version_number IN NUMBER
293 );
294
295
296 /******************************************************************************/
297 -- Start of Comments
298 --
299 -- API name : Validate_thldact
300 -- Type : Private
301 -- Function : Validate a row in ams_trigger_actions table
302 --
303 -- Pre-reqs : None
304 -- Paramaeters :
305 -- IN :
306 -- standard IN parameters
307 -- p_api_version IN NUMBER := NULL Required
308 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE Optional
309 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
310 --
311 -- API's IN parameters
312 -- p_thldact_Rec IN thldact_rec_type
313 --
314 -- OUT :
315 -- standard OUT parameters
316 -- x_return_status OUT VARCHAR2(1)
317 -- x_msg_count OUT NUMBER
318 -- x_msg_data OUT VARCHAR2(2000)
319 --
320 -- API's OUT parameters
321 -- x_thldact_rec OUT thldact_rec_type
322 --
323 --
324 -- Version : Current version 1.0
325 -- Initial version 1.0
326 --
327 -- End Of Comments
328
329 PROCEDURE Validate_thldact
330 ( p_api_version IN NUMBER,
331 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
332 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2,
336
337 p_thldact_Rec IN thldact_rec_type
338
339 );
340
341 /******************************************************************************/
342 -- Start of Comments
343 --
344 -- Name : Validate_thldact_Items
345 -- Type : Private
346 -- Function : Validate columns in ams_trigger_actions
347 --
348 -- Pre-reqs : None
349 -- Paramaeters :
350 -- IN :
351 -- p_thldact_rec IN thldact_rec_type,
352 -- p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
353 -- OUT :
354 -- x_return_status OUT VARCHAR2
355 --
356 -- Business rules:
357 -- 1. ...
358 --
359 -- End Of Comments
360
361 PROCEDURE Check_thldact_Items(
362 p_thldact_rec IN thldact_rec_type,
363 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
364 x_return_status OUT NOCOPY VARCHAR2
365 );
366
367 /*****************************************************************************************/
368 -- Start of Comments
369 --
370 -- API name : Validate_thldact_Record
371 -- Type : Private
372 -- Function : Validate a row in ams_trigger_actions table
373 --
374 -- Pre-reqs : None
375 -- Paramaeters :
376 -- IN :
377 -- standard IN parameters
378 --
379 -- API's IN parameters
380 -- p_thldact_rec IN thldact_rec_type
381 -- p_complete_rec IN thldact_rec_type,
382 --
383 -- OUT :
384 -- standard OUT parameters
385 -- x_return_status OUT VARCHAR2(1)
386 --
387 -- Version : Current version 1.0
388 -- Initial version 1.0
389 --
390 -- Business rules:
391 -- 1. ...
392 --
393 -- End Of Comments
394
395 PROCEDURE Check_thldact_Record(
396 p_thldact_rec IN thldact_rec_type,
397 p_complete_rec IN thldact_rec_type,
398 x_return_status OUT NOCOPY VARCHAR2
399 );
400
401
402 /*****************************************************************************************/
403 -- Start of Comments
404 --
405 -- Name : Init_thldact_Rec
406 -- Type : Private
407 -- Function : CInitialize the Record type before Updation
408 --
412 -- p_thldact_rec IN thldact_rec_type Required
409 -- Pre-reqs : None
410 -- Paramaeters :
411 -- IN :
413 -- p_thldact_req_item_rec IN thldact_validate_rec_type,
414 --
415 -- OUT :
416 -- x_return_status OUT VARCHAR2
417 --
418 --
419 -- End Of Comments
420
421 PROCEDURE Init_thldact_Rec(
422 x_thldact_rec OUT NOCOPY thldact_rec_type
423 );
424
425 /*****************************************************************************************/
426 -- Start of Comments
427 --
428 -- Name : Complete_thldact_rec
429 -- Type : Private
430 -- Function : Complete the record as we don't pass whole record for Updation
431 --
432 -- Pre-reqs : None
433 -- Paramaeters :
434 -- IN :
435 -- p_thldact_rec IN thldact_rec_type Required
436 --
437 -- OUT :
438 -- x_complete_rec OUT thldact_rec_type
439 --
440 -- End Of Comments
441 PROCEDURE Complete_thldact_rec(
442 p_thldact_rec IN thldact_rec_type,
443 x_complete_rec OUT NOCOPY thldact_rec_type
444 )
445 ;
446
447
448
449 END AMS_thldact_PVT;