eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DMSELECTION_PVT dependencies on DBMS_RANDOM

Line 2760: DBMS_RANDOM.initialize (TO_NUMBER (TO_CHAR (SYSDATE, 'DDSSSS')));

2756:
2757: -- Randomize the records
2758: -- Seed the random number generator with the Julian
2759: -- days and seconds representation of sysdate.
2760: DBMS_RANDOM.initialize (TO_NUMBER (TO_CHAR (SYSDATE, 'DDSSSS')));
2761:
2762: -- UPDATE ams_dm_inter_source_stg
2763: UPDATE ams_dm_int_src_stg_gt
2764: SET random_generated_num = DBMS_RANDOM.random

Line 2764: SET random_generated_num = DBMS_RANDOM.random

2760: DBMS_RANDOM.initialize (TO_NUMBER (TO_CHAR (SYSDATE, 'DDSSSS')));
2761:
2762: -- UPDATE ams_dm_inter_source_stg
2763: UPDATE ams_dm_int_src_stg_gt
2764: SET random_generated_num = DBMS_RANDOM.random
2765: WHERE arc_object_used_by = p_arc_object_for
2766: AND object_used_by_id = p_object_for_id
2767: ;
2768:

Line 2769: DBMS_RANDOM.terminate;

2765: WHERE arc_object_used_by = p_arc_object_for
2766: AND object_used_by_id = p_object_for_id
2767: ;
2768:
2769: DBMS_RANDOM.terminate;
2770:
2771: -- Bulk fetch the first l_total_random_rows up to the l_max_rows
2772: OPEN c_randomized_sources (p_arc_object_for, p_object_for_id);
2773: FETCH c_randomized_sources BULK COLLECT INTO l_object_ids LIMIT NVL (p_max_rows, l_total_random_rows);