[Home] [Help]
PACKAGE BODY: APPS.AMS_LIST_SELECT_ACTIONS_PKG
Source
1 PACKAGE BODY AMS_LIST_SELECT_ACTIONS_PKG as
2 /* $Header: amstlsab.pls 120.0 2005/05/31 23:05:25 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_LIST_SELECT_ACTIONS_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16
17 G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_LIST_SELECT_ACTIONS_PKG';
18 G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstlsab.pls';
19
20
21 ----------------------------------------------------------
22 ---- MEDIA ----
23 ----------------------------------------------------------
24
25 -- ========================================================
26 --
27 -- NAME
28 -- createInsertBody
29 --
30 -- PURPOSE
31 --
32 -- NOTES
33 --
34 -- HISTORY
35 --
36 -- ========================================================
37 AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
38 AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
39 AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
40
41 PROCEDURE Insert_Row(
42 px_list_select_action_id IN OUT NOCOPY NUMBER,
43 p_last_update_date DATE,
44 p_last_updated_by NUMBER,
45 p_creation_date DATE,
46 p_created_by NUMBER,
47 p_last_update_login NUMBER,
48 px_object_version_number IN OUT NOCOPY NUMBER,
49 p_list_header_id NUMBER,
50 p_order_number NUMBER,
51 p_list_action_type VARCHAR2,
52 p_incl_object_name VARCHAR2,
53 p_arc_incl_object_from VARCHAR2,
54 p_incl_object_id NUMBER,
55 p_incl_object_wb_sheet VARCHAR2,
56 p_incl_object_wb_owner NUMBER,
57 p_incl_object_cell_code VARCHAR2,
58 p_rank NUMBER,
59 p_no_of_rows_available NUMBER,
60 p_no_of_rows_requested NUMBER,
61 p_no_of_rows_used NUMBER,
62 p_distribution_pct NUMBER,
63 p_result_text VARCHAR2,
64 p_description VARCHAR2,
65 p_arc_action_used_by VARCHAR2,
66 p_action_used_by_id NUMBER,
67 p_incl_control_group VARCHAR2,
68 p_no_of_rows_targeted NUMBER)
69
70 IS
71 x_rowid VARCHAR2(30);
72
73
74 BEGIN
75
76
77 px_object_version_number := 1;
78
79
80 INSERT INTO AMS_LIST_SELECT_ACTIONS(
81 list_select_action_id,
82 last_update_date,
83 last_updated_by,
84 creation_date,
85 created_by,
86 last_update_login,
87 object_version_number,
88 list_header_id,
89 order_number,
90 list_action_type,
91 incl_object_name,
92 arc_incl_object_from,
93 incl_object_id,
94 incl_object_wb_sheet,
95 incl_object_wb_owner,
96 incl_object_cell_code,
97 rank,
98 no_of_rows_available,
99 no_of_rows_requested,
100 no_of_rows_used,
101 distribution_pct,
102 result_text,
103 description,
104 arc_action_used_by,
105 action_used_by_id,
106 incl_control_group,
107 no_of_rows_targeted
108 ) VALUES (
109 DECODE( px_list_select_action_id, FND_API.g_miss_num, NULL, px_list_select_action_id),
110 DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
111 DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
112 DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
113 DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
114 DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
115 DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
116 DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
117 DECODE( p_order_number, FND_API.g_miss_num, NULL, p_order_number),
118 DECODE( p_list_action_type, FND_API.g_miss_char, NULL, p_list_action_type),
119 DECODE( p_incl_object_name, FND_API.g_miss_char, NULL, p_incl_object_name),
120 DECODE( p_arc_incl_object_from, FND_API.g_miss_char, NULL, p_arc_incl_object_from),
121 DECODE( p_incl_object_id, FND_API.g_miss_num, NULL, p_incl_object_id),
122 DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, NULL, p_incl_object_wb_sheet),
123 DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, NULL, p_incl_object_wb_owner),
124 DECODE( p_incl_object_cell_code, FND_API.g_miss_char, NULL, p_incl_object_cell_code),
125 DECODE( p_rank, FND_API.g_miss_num, NULL, p_rank),
126 DECODE( p_no_of_rows_available, FND_API.g_miss_num, NULL, p_no_of_rows_available),
127 DECODE( p_no_of_rows_requested, FND_API.g_miss_num, NULL, p_no_of_rows_requested),
128 DECODE( p_no_of_rows_used, FND_API.g_miss_num, NULL, p_no_of_rows_used),
129 DECODE( p_distribution_pct, FND_API.g_miss_num, NULL, p_distribution_pct),
130 DECODE( p_result_text, FND_API.g_miss_char, NULL, p_result_text),
131 DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
132 DECODE( p_arc_action_used_by, FND_API.g_miss_char, NULL, p_arc_action_used_by),
133 DECODE( p_action_used_by_id, FND_API.g_miss_num, NULL, p_action_used_by_id),
134 DECODE( p_incl_control_group, FND_API.g_miss_char, NULL, p_incl_control_group),
135 DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, NULL, p_no_of_rows_targeted));
136 END Insert_Row;
137
138
139 ----------------------------------------------------------
140 ---- MEDIA ----
141 ----------------------------------------------------------
142
143 -- ========================================================
144 --
145 -- NAME
146 -- createUpdateBody
147 --
148 -- PURPOSE
149 --
150 -- NOTES
151 --
152 -- HISTORY
153 --
154 -- ========================================================
155 PROCEDURE Update_Row(
156 p_list_select_action_id NUMBER,
157 p_last_update_date DATE,
158 p_last_updated_by NUMBER,
159 p_creation_date DATE,
160 p_created_by NUMBER,
161 p_last_update_login NUMBER,
162 p_object_version_number NUMBER,
163 p_list_header_id NUMBER,
164 p_order_number NUMBER,
165 p_list_action_type VARCHAR2,
166 p_incl_object_name VARCHAR2,
167 p_arc_incl_object_from VARCHAR2,
168 p_incl_object_id NUMBER,
169 p_incl_object_wb_sheet VARCHAR2,
170 p_incl_object_wb_owner NUMBER,
171 p_incl_object_cell_code VARCHAR2,
172 p_rank NUMBER,
173 p_no_of_rows_available NUMBER,
174 p_no_of_rows_requested NUMBER,
175 p_no_of_rows_used NUMBER,
176 p_distribution_pct NUMBER,
177 p_result_text VARCHAR2,
178 p_description VARCHAR2,
179 p_arc_action_used_by VARCHAR2,
180 p_action_used_by_id NUMBER,
181 p_incl_control_group VARCHAR2,
182 p_no_of_rows_targeted NUMBER)
183
184 IS
185 BEGIN
186 Update AMS_LIST_SELECT_ACTIONS
187 SET
188 list_select_action_id = DECODE( p_list_select_action_id, FND_API.g_miss_num, list_select_action_id, p_list_select_action_id),
189 last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190 last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191 creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192 created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193 last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194 object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
195 list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
196 order_number = DECODE( p_order_number, FND_API.g_miss_num, order_number, p_order_number),
197 list_action_type = DECODE( p_list_action_type, FND_API.g_miss_char, list_action_type, p_list_action_type),
198 incl_object_name = DECODE( p_incl_object_name, FND_API.g_miss_char, incl_object_name, p_incl_object_name),
199 arc_incl_object_from = DECODE( p_arc_incl_object_from, FND_API.g_miss_char, arc_incl_object_from, p_arc_incl_object_from),
200 incl_object_id = DECODE( p_incl_object_id, FND_API.g_miss_num, incl_object_id, p_incl_object_id),
201 incl_object_wb_sheet = DECODE( p_incl_object_wb_sheet, FND_API.g_miss_char, incl_object_wb_sheet, p_incl_object_wb_sheet),
202 incl_object_wb_owner = DECODE( p_incl_object_wb_owner, FND_API.g_miss_num, incl_object_wb_owner, p_incl_object_wb_owner),
203 incl_object_cell_code = DECODE( p_incl_object_cell_code, FND_API.g_miss_char, incl_object_cell_code, p_incl_object_cell_code),
204 rank = DECODE( p_rank, FND_API.g_miss_num, rank, p_rank),
205 no_of_rows_available = DECODE( p_no_of_rows_available, FND_API.g_miss_num, no_of_rows_available, p_no_of_rows_available),
206 no_of_rows_requested = DECODE( p_no_of_rows_requested, FND_API.g_miss_num, no_of_rows_requested, p_no_of_rows_requested),
207 no_of_rows_used = DECODE( p_no_of_rows_used, FND_API.g_miss_num, no_of_rows_used, p_no_of_rows_used),
208 distribution_pct = DECODE( p_distribution_pct, FND_API.g_miss_num, distribution_pct, p_distribution_pct),
209 result_text = DECODE( p_result_text, FND_API.g_miss_char, result_text, p_result_text),
210 description = DECODE( p_description, FND_API.g_miss_char, description, p_description),
211 arc_action_used_by = DECODE( p_arc_action_used_by, FND_API.g_miss_char, arc_action_used_by, p_arc_action_used_by),
212 action_used_by_id = DECODE( p_action_used_by_id, FND_API.g_miss_num, action_used_by_id, p_action_used_by_id),
213 incl_control_group = DECODE( p_incl_control_group, FND_API.g_miss_char, incl_control_group, p_incl_control_group),
214 no_of_rows_targeted = DECODE( p_no_of_rows_targeted, FND_API.g_miss_num, no_of_rows_targeted, p_no_of_rows_targeted)
215 WHERE LIST_SELECT_ACTION_ID = p_LIST_SELECT_ACTION_ID;
216 -- AND object_version_number = p_object_version_number;
217
218 IF (SQL%NOTFOUND) THEN
219 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220 END IF;
221 END Update_Row;
222
223
224 ----------------------------------------------------------
225 ---- MEDIA ----
226 ----------------------------------------------------------
227
228 -- ========================================================
229 --
230 -- NAME
231 -- createDeleteBody
232 --
233 -- PURPOSE
234 --
235 -- NOTES
236 --
237 -- HISTORY
238 --
239 -- ========================================================
240 PROCEDURE Delete_Row(
241 p_LIST_SELECT_ACTION_ID NUMBER)
242 IS
243 BEGIN
244 DELETE FROM AMS_LIST_SELECT_ACTIONS
245 WHERE LIST_SELECT_ACTION_ID = p_LIST_SELECT_ACTION_ID;
246 If (SQL%NOTFOUND) then
247 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248 End If;
249 END Delete_Row ;
250
251
252
253 ----------------------------------------------------------
254 ---- MEDIA ----
255 ----------------------------------------------------------
256
257 -- ========================================================
258 --
259 -- NAME
260 -- createLockBody
261 --
262 -- PURPOSE
263 --
264 -- NOTES
265 --
266 -- HISTORY
267 --
268 -- ========================================================
269 PROCEDURE Lock_Row(
270 p_list_select_action_id NUMBER,
271 p_last_update_date DATE,
272 p_last_updated_by NUMBER,
273 p_creation_date DATE,
274 p_created_by NUMBER,
275 p_last_update_login NUMBER,
276 p_object_version_number NUMBER,
277 p_list_header_id NUMBER,
278 p_order_number NUMBER,
279 p_list_action_type VARCHAR2,
280 p_incl_object_name VARCHAR2,
281 p_arc_incl_object_from VARCHAR2,
282 p_incl_object_id NUMBER,
283 p_incl_object_wb_sheet VARCHAR2,
284 p_incl_object_wb_owner NUMBER,
285 p_incl_object_cell_code VARCHAR2,
286 p_rank NUMBER,
287 p_no_of_rows_available NUMBER,
288 p_no_of_rows_requested NUMBER,
289 p_no_of_rows_used NUMBER,
290 p_distribution_pct NUMBER,
291 p_result_text VARCHAR2,
292 p_description VARCHAR2,
293 p_arc_action_used_by VARCHAR2,
294 p_action_used_by_id NUMBER,
295 p_incl_control_group VARCHAR2,
296 p_no_of_rows_targeted NUMBER)
297
298 IS
299 CURSOR C IS
300 SELECT *
301 FROM AMS_LIST_SELECT_ACTIONS
302 WHERE LIST_SELECT_ACTION_ID = p_LIST_SELECT_ACTION_ID
303 FOR UPDATE of LIST_SELECT_ACTION_ID NOWAIT;
304 Recinfo C%ROWTYPE;
305 BEGIN
306 OPEN c;
307 FETCH c INTO Recinfo;
308 If (c%NOTFOUND) then
309 CLOSE c;
310 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
311 APP_EXCEPTION.RAISE_EXCEPTION;
312 END IF;
313 CLOSE C;
314 IF (
315 ( Recinfo.list_select_action_id = p_list_select_action_id)
316 AND ( ( Recinfo.last_update_date = p_last_update_date)
317 OR ( ( Recinfo.last_update_date IS NULL )
318 AND ( p_last_update_date IS NULL )))
319 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
320 OR ( ( Recinfo.last_updated_by IS NULL )
321 AND ( p_last_updated_by IS NULL )))
322 AND ( ( Recinfo.creation_date = p_creation_date)
323 OR ( ( Recinfo.creation_date IS NULL )
324 AND ( p_creation_date IS NULL )))
325 AND ( ( Recinfo.created_by = p_created_by)
326 OR ( ( Recinfo.created_by IS NULL )
327 AND ( p_created_by IS NULL )))
328 AND ( ( Recinfo.last_update_login = p_last_update_login)
329 OR ( ( Recinfo.last_update_login IS NULL )
330 AND ( p_last_update_login IS NULL )))
331 AND ( ( Recinfo.object_version_number = p_object_version_number)
332 OR ( ( Recinfo.object_version_number IS NULL )
333 AND ( p_object_version_number IS NULL )))
334 AND ( ( Recinfo.list_header_id = p_list_header_id)
335 OR ( ( Recinfo.list_header_id IS NULL )
336 AND ( p_list_header_id IS NULL )))
337 AND ( ( Recinfo.order_number = p_order_number)
338 OR ( ( Recinfo.order_number IS NULL )
339 AND ( p_order_number IS NULL )))
340 AND ( ( Recinfo.list_action_type = p_list_action_type)
341 OR ( ( Recinfo.list_action_type IS NULL )
342 AND ( p_list_action_type IS NULL )))
343 AND ( ( Recinfo.incl_object_name = p_incl_object_name)
344 OR ( ( Recinfo.incl_object_name IS NULL )
345 AND ( p_incl_object_name IS NULL )))
346 AND ( ( Recinfo.arc_incl_object_from = p_arc_incl_object_from)
347 OR ( ( Recinfo.arc_incl_object_from IS NULL )
348 AND ( p_arc_incl_object_from IS NULL )))
349 AND ( ( Recinfo.incl_object_id = p_incl_object_id)
350 OR ( ( Recinfo.incl_object_id IS NULL )
354 AND ( p_incl_object_wb_sheet IS NULL )))
351 AND ( p_incl_object_id IS NULL )))
352 AND ( ( Recinfo.incl_object_wb_sheet = p_incl_object_wb_sheet)
353 OR ( ( Recinfo.incl_object_wb_sheet IS NULL )
355 AND ( ( Recinfo.incl_object_wb_owner = p_incl_object_wb_owner)
356 OR ( ( Recinfo.incl_object_wb_owner IS NULL )
357 AND ( p_incl_object_wb_owner IS NULL )))
358 AND ( ( Recinfo.incl_object_cell_code = p_incl_object_cell_code)
359 OR ( ( Recinfo.incl_object_cell_code IS NULL )
360 AND ( p_incl_object_cell_code IS NULL )))
361 AND ( ( Recinfo.rank = p_rank)
362 OR ( ( Recinfo.rank IS NULL )
363 AND ( p_rank IS NULL )))
364 AND ( ( Recinfo.no_of_rows_available = p_no_of_rows_available)
365 OR ( ( Recinfo.no_of_rows_available IS NULL )
366 AND ( p_no_of_rows_available IS NULL )))
367 AND ( ( Recinfo.no_of_rows_requested = p_no_of_rows_requested)
368 OR ( ( Recinfo.no_of_rows_requested IS NULL )
369 AND ( p_no_of_rows_requested IS NULL )))
370 AND ( ( Recinfo.no_of_rows_used = p_no_of_rows_used)
371 OR ( ( Recinfo.no_of_rows_used IS NULL )
372 AND ( p_no_of_rows_used IS NULL )))
373 AND ( ( Recinfo.distribution_pct = p_distribution_pct)
374 OR ( ( Recinfo.distribution_pct IS NULL )
375 AND ( p_distribution_pct IS NULL )))
376 AND ( ( Recinfo.result_text = p_result_text)
377 OR ( ( Recinfo.result_text IS NULL )
378 AND ( p_result_text IS NULL )))
379 AND ( ( Recinfo.description = p_description)
380 OR ( ( Recinfo.description IS NULL )
381 AND ( p_description IS NULL )))
382 AND ( ( Recinfo.arc_action_used_by = p_arc_action_used_by)
383 OR ( ( Recinfo.arc_action_used_by IS NULL )
384 AND ( p_arc_action_used_by IS NULL )))
385 AND ( ( Recinfo.action_used_by_id = p_action_used_by_id)
386 OR ( ( Recinfo.action_used_by_id IS NULL )
387 AND ( p_action_used_by_id IS NULL )))
388 AND ( ( Recinfo.incl_control_group = p_incl_control_group)
389 OR ( ( Recinfo.incl_control_group IS NULL )
390 AND ( p_incl_control_group IS NULL )))
391 AND ( ( Recinfo.no_of_rows_targeted = p_no_of_rows_targeted)
392 OR ( ( Recinfo.no_of_rows_targeted IS NULL )
393 AND ( p_no_of_rows_targeted IS NULL )))
394 ) THEN
395 RETURN;
396 ELSE
397 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
398 APP_EXCEPTION.RAISE_EXCEPTION;
399 END IF;
400 END Lock_Row;
401
402 PROCEDURE LOAD_ROW(
403 p_owner varchar2,
404 p_list_select_action_id NUMBER,
405 p_last_update_date DATE,
406 p_last_updated_by NUMBER,
407 p_creation_date DATE,
408 p_created_by NUMBER,
409 p_last_update_login NUMBER,
410 p_object_version_number NUMBER,
411 p_list_header_id NUMBER,
412 p_order_number NUMBER,
413 p_list_action_type VARCHAR2,
414 p_incl_object_name VARCHAR2,
415 p_arc_incl_object_from VARCHAR2,
416 p_incl_object_id NUMBER,
417 p_incl_object_wb_sheet VARCHAR2,
418 p_incl_object_wb_owner NUMBER,
419 p_incl_object_cell_code VARCHAR2,
420 p_rank NUMBER,
421 p_no_of_rows_available NUMBER,
422 p_no_of_rows_requested NUMBER,
423 p_no_of_rows_used NUMBER,
424 p_distribution_pct NUMBER,
425 p_result_text VARCHAR2,
426 p_description VARCHAR2,
427 p_arc_action_used_by VARCHAR2,
428 p_action_used_by_id NUMBER,
429 p_incl_control_group VARCHAR2,
430 p_no_of_rows_targeted NUMBER,
431 p_custom_mode VARCHAR2
432
433 ) is
434 l_dummy_char varchar2(1);
435 x_return_status varchar2(1);
436 l_row_id varchar2(100);
437 l_user_id number;
438
439 l_last_updated_by number;
440
441 l_object_version_number NUMBER := p_object_version_number ;
442 l_list_select_action_id NUMBER := p_list_select_action_id ;
443 cursor c_chk_col_exists is
444 select 'x'
445 from ams_list_select_actions
446 where list_select_action_id = p_list_select_action_id;
447
448 CURSOR c_obj_verno IS
449 SELECT object_version_number, last_updated_by
450 FROM ams_list_select_actions
451 WHERE list_select_action_id = p_list_select_action_id;
452
453 begin
454 if p_OWNER = 'SEED' then
455 l_user_id := 1;
456 elsif p_OWNER = 'ORACLE' then
457 l_user_id := 2;
458 elsif p_OWNER = 'SYSADMIN' THEN
459 l_user_id := 0;
460
461 end if;
462 open c_chk_col_exists;
463 fetch c_chk_col_exists into l_dummy_char;
464 if c_chk_col_exists%notfound then
465 close c_chk_col_exists;
466
467 AMS_LIST_SELECT_ACTIONS_PKG.Insert_Row(
468 px_list_select_action_id => l_list_select_action_id,
469 p_last_update_date => SYSDATE,
470 p_last_updated_by => nvl(l_user_id,p_last_updated_by),
471 p_creation_date => SYSDATE,
472 p_created_by => nvl(l_user_id,p_created_by),
473 p_last_update_login => nvl(l_user_id,p_last_update_login),
474 px_object_version_number => l_object_version_number,
475 p_list_header_id => p_list_header_id,
476 p_order_number => p_order_number,
477 p_list_action_type => p_list_action_type,
478 p_incl_object_name => p_incl_object_name,
479 p_arc_incl_object_from => p_arc_incl_object_from,
480 p_incl_object_id => p_incl_object_id,
481 p_incl_object_wb_sheet => p_incl_object_wb_sheet,
482 p_incl_object_wb_owner => p_incl_object_wb_owner,
483 p_incl_object_cell_code => p_incl_object_cell_code,
484 p_rank => p_rank,
485 p_no_of_rows_available => p_no_of_rows_available,
486 p_no_of_rows_requested => p_no_of_rows_requested,
487 p_no_of_rows_used => p_no_of_rows_used,
488 p_distribution_pct => p_distribution_pct,
489 p_result_text => p_result_text,
490 p_description => p_description,
491 p_arc_action_used_by => p_arc_action_used_by,
492 p_action_used_by_id => p_action_used_by_id,
493 p_incl_control_group => p_incl_control_group,
494 p_no_of_rows_targeted => p_no_of_rows_targeted);
495 IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496 RAISE FND_API.G_EXC_ERROR;
497 END IF;
498 else
499 close c_chk_col_exists;
500
501 OPEN c_obj_verno;
502 FETCH c_obj_verno INTO l_object_version_number ,l_last_updated_by;
503 CLOSE c_obj_verno;
504
505
506 if (l_last_updated_by in (1,2,0) OR
507 NVL(p_custom_mode,'PRESERVE')='FORCE') THEN
508
509
510
511 -- Invoke table handler(AMS_LIST_SELECT_ACTIONS_PKG.Update_Row)
512 AMS_LIST_SELECT_ACTIONS_PKG.Update_Row(
513 p_list_select_action_id => l_list_select_action_id,
514 p_last_update_date => SYSDATE,
515 p_last_updated_by => nvl(l_user_id,p_last_updated_by),
516 p_creation_date => SYSDATE,
517 p_created_by => nvl(l_user_id,p_created_by),
518 p_last_update_login => nvl(l_user_id,p_last_update_login),
519 p_object_version_number => p_object_version_number,
520 p_list_header_id => p_list_header_id,
521 p_order_number => p_order_number,
522 p_list_action_type => p_list_action_type,
523 p_incl_object_name => p_incl_object_name,
524 p_arc_incl_object_from => p_arc_incl_object_from,
525 p_incl_object_id => p_incl_object_id,
526 p_incl_object_wb_sheet => p_incl_object_wb_sheet,
527 p_incl_object_wb_owner => p_incl_object_wb_owner,
528 p_incl_object_cell_code => p_incl_object_cell_code,
529 p_rank => p_rank,
530 p_no_of_rows_available => p_no_of_rows_available,
531 p_no_of_rows_requested => p_no_of_rows_requested,
532 p_no_of_rows_used => p_no_of_rows_used,
533 p_distribution_pct => p_distribution_pct,
534 p_result_text => p_result_text,
535 p_description => p_description,
536 p_arc_action_used_by => p_arc_action_used_by,
537 p_action_used_by_id => p_action_used_by_id,
538 p_incl_control_group => p_incl_control_group,
539 p_no_of_rows_targeted => p_no_of_rows_targeted);
540 --
541
542 end if;
543 end if;
544 end;
545
546
547 END AMS_LIST_SELECT_ACTIONS_PKG;