APPS.AMS_LIST_OPTIONS_PVT dependencies on DBMS_RANDOM

Line 248: DBMS_RANDOM.initialize (TO_NUMBER (TO_CHAR (SYSDATE, 'SSSSDD')));

244: end if;
245:
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

Line 251: SET randomly_generated_number = DBMS_RANDOM.random

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:
255: write_to_act_log('Randomly generated number assigned to '||sql%rowcount||' entries','LIST',p_list_header_id,'LOW');

Line 257: DBMS_RANDOM.terminate;

253: AND enabled_flag = 'Y';
254:
255: write_to_act_log('Randomly generated number assigned to '||sql%rowcount||' entries','LIST',p_list_header_id,'LOW');
256:
257: DBMS_RANDOM.terminate;
258:
259: if nvl(l_total_random_rows,0) > 0 then
260: OPEN c_list_entries (p_list_header_id);
261: FETCH c_list_entries BULK COLLECT INTO g_list_entries_id LIMIT l_total_random_rows;

Line 382: DBMS_RANDOM.initialize (TO_NUMBER (TO_CHAR (SYSDATE, 'SSSSDD')));

378: end if;
379:
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',

Line 385: SET randomly_generated_number = DBMS_RANDOM.random,

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
389: AND enabled_flag = 'Y';

Line 392: DBMS_RANDOM.terminate;

388: WHERE list_header_id = p_list_header_id
389: AND enabled_flag = 'Y';
390: write_to_act_log('Randomly generated number assigned to '||sql%rowcount||' list entries','LIST',p_list_header_id,'LOW');
391:
392: DBMS_RANDOM.terminate;
393:
394: OPEN c_list_entries (p_list_header_id);
395: FETCH c_list_entries BULK COLLECT INTO g_list_entries_id LIMIT l_total_random_rows;
396: CLOSE c_list_entries;