APPS.AMS_LIST_OPTIONS_PVT dependencies on AMS_LIST_ENTRIES

Line 28: FROM ams_list_entries

24: WHERE list_header_id = p_list_header_id;
25:
26: CURSOR c_get_count (p_list_header_id IN number ) is
27: SELECT count(1)
28: FROM ams_list_entries
29: WHERE list_header_id = p_list_header_id
30: AND enabled_flag = 'Y';
31:
32: TYPE g_entries_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 126: FROM ams_list_entries

122: l_total_random_rows number := 0;
123:
124: CURSOR c_list_entries (p_list_header_id IN number ) is
125: SELECT list_entry_id
126: FROM ams_list_entries
127: WHERE list_header_id = p_list_header_id
128: AND enabled_flag = 'Y'
129: ORDER BY randomly_generated_number ;
130:

Line 162: from ams_list_entries

158: 0)),
159: sum(decode(MARKED_AS_SUPPRESSED_FLAG,'Y',1,0)),
160: sum(decode(MARKED_AS_FATIGUED_FLAG,'Y',1,0)),
161: sum(decode(TCA_LOAD_STATUS,'ERROR',1,0))
162: from ams_list_entries
163: where list_header_id = p_list_header_id ;
164:
165: l_sample_size number := 0;
166: l_status varchar2(100);

Line 208: update ams_list_entries -- need this when the CG is generated seperately..

204: elsif l_status_code = 'LOCKED' then
205: l_status_id := 304;
206: end if;
207:
208: update ams_list_entries -- need this when the CG is generated seperately..
209: set part_of_control_group_flag = 'N',
210: enabled_flag = 'Y'
211: where part_of_control_group_flag = 'Y'
212: and enabled_flag = 'N'

Line 250: UPDATE ams_list_entries

246: write_to_act_log('Total no of rows to be made part of control group is ' || to_char(l_total_random_rows), 'LIST', p_list_header_id,'LOW');
247:
248: DBMS_RANDOM.initialize (TO_NUMBER (TO_CHAR (SYSDATE, 'SSSSDD')));
249:
250: UPDATE ams_list_entries
251: SET randomly_generated_number = DBMS_RANDOM.random
252: WHERE list_header_id = p_list_header_id
253: AND enabled_flag = 'Y';
254:

Line 265: UPDATE ams_list_entries

261: FETCH c_list_entries BULK COLLECT INTO g_list_entries_id LIMIT l_total_random_rows;
262: CLOSE c_list_entries;
263:
264: FORALL i in g_list_entries_id.FIRST .. g_list_entries_id.LAST
265: UPDATE ams_list_entries
266: SET part_of_control_group_flag = 'Y',
267: enabled_flag = 'N'
268: WHERE list_header_id = p_list_header_id
269: AND list_entry_id = g_list_entries_id(i);

Line 350: FROM ams_list_entries

346: x_msg_data out nocopy varchar2) IS
347:
348: CURSOR c_list_entries (p_list_header_id IN number ) is
349: SELECT list_entry_id
350: FROM ams_list_entries
351: WHERE list_header_id = p_list_header_id
352: AND marked_as_random_flag = 'Y'
353: AND enabled_flag = 'N'
354: ORDER BY randomly_generated_number ;

Line 384: UPDATE ams_list_entries

380: write_to_act_log('Total no of rows to be generated randomly is ' || to_char(l_total_random_rows), 'LIST', p_list_header_id,'LOW');
381:
382: DBMS_RANDOM.initialize (TO_NUMBER (TO_CHAR (SYSDATE, 'SSSSDD')));
383:
384: UPDATE ams_list_entries
385: SET randomly_generated_number = DBMS_RANDOM.random,
386: marked_as_random_flag = 'Y',
387: enabled_flag = 'N'
388: WHERE list_header_id = p_list_header_id

Line 399: UPDATE ams_list_entries

395: FETCH c_list_entries BULK COLLECT INTO g_list_entries_id LIMIT l_total_random_rows;
396: CLOSE c_list_entries;
397:
398: FORALL i in g_list_entries_id.FIRST .. g_list_entries_id.LAST
399: UPDATE ams_list_entries
400: SET marked_as_random_flag = 'Y',
401: enabled_flag = 'Y'
402: WHERE list_header_id = g_list_header_info.list_header_id
403: AND list_entry_id = g_list_entries_id(i);

Line 422: -- need to consider only the entries from ams_list_entries..no need to be specific about the selections.

418: x_msg_data out nocopy varchar2) is
419:
420: l_sel_excess number := 0;
421:
422: -- need to consider only the entries from ams_list_entries..no need to be specific about the selections.
423: CURSOR c_list_entries is
424: SELECT e.list_entry_id
425: FROM ams_list_entries e
426: WHERE e.list_header_id = p_list_header_id

Line 425: FROM ams_list_entries e

421:
422: -- need to consider only the entries from ams_list_entries..no need to be specific about the selections.
423: CURSOR c_list_entries is
424: SELECT e.list_entry_id
425: FROM ams_list_entries e
426: WHERE e.list_header_id = p_list_header_id
427: AND e.enabled_flag ='Y';
428:
429: BEGIN

Line 454: UPDATE ams_list_entries

450: open c_list_entries;
451: fetch c_list_entries bulk collect into g_list_entries_id limit l_sel_excess ;
452: close c_list_entries;
453: FORALL i in g_list_entries_id.FIRST .. g_list_entries_id.LAST
454: UPDATE ams_list_entries
455: SET enabled_flag = 'N'
456: WHERE list_header_id = p_list_header_id
457: AND list_entry_id = g_list_entries_id(i);
458: write_to_act_log(sql%rowcount||' entries disabled to restrict list size.' , 'LIST', p_list_header_id, 'HIGH');