APPS.AMS_ACT_LIST_PVT dependencies on DBMS_RANDOM

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

2110: else
2111: l_total_random_rows := p_no_random ;
2112: end if;
2113:
2114: DBMS_RANDOM.initialize (TO_NUMBER (TO_CHAR (SYSDATE, 'SSSSDD')));
2115:
2116: UPDATE ams_list_entries
2117: SET randomly_generated_number = DBMS_RANDOM.random
2118: WHERE list_header_id = p_list_header_id

Line 2117: SET randomly_generated_number = DBMS_RANDOM.random

2113:
2114: DBMS_RANDOM.initialize (TO_NUMBER (TO_CHAR (SYSDATE, 'SSSSDD')));
2115:
2116: UPDATE ams_list_entries
2117: SET randomly_generated_number = DBMS_RANDOM.random
2118: WHERE list_header_id = p_list_header_id
2119: and enabled_flag = 'Y';
2120:
2121: write_to_act_log('Randomly generated number assigned to '||sql%rowcount||' list entries','LIST',p_list_header_id,'LOW');

Line 2123: DBMS_RANDOM.terminate;

2119: and enabled_flag = 'Y';
2120:
2121: write_to_act_log('Randomly generated number assigned to '||sql%rowcount||' list entries','LIST',p_list_header_id,'LOW');
2122:
2123: DBMS_RANDOM.terminate;
2124:
2125: OPEN c_list_entries (p_list_header_id);
2126: FETCH c_list_entries BULK COLLECT INTO l_list_entries_id LIMIT l_total_random_rows;
2127: CLOSE c_list_entries;