APPS.IES_SVY_DEPLOYMENT_PVT dependencies on DBMS_RANDOM

Line 1226: dbms_random.initialize (l_seed);

1222: IF l_total_list_entries > 0 THEN
1223: l_time_in_sec := dbms_utility.get_time();
1224: l_seed := MOD(l_time_in_sec,100000);
1225: --DBMS_OUTPUT.PUT_LINE('seedis '|| l_seed);
1226: dbms_random.initialize (l_seed);
1227:
1228: -- To check if concurrent manager has entered values for particular deployment ID on prior failure.
1229: SELECT count(*) INTO l_count_value
1230: FROM IES_SVY_LIST_ENTRIES

Line 1238: l_random_number := ABS(dbms_random.random);

1234: OPEN CLISTENTRYID;
1235: LOOP
1236: FETCH CLISTENTRYID into l_list_entry_id;
1237: EXIT WHEN CLISTENTRYID%NOTFOUND;
1238: l_random_number := ABS(dbms_random.random);
1239: --DBMS_OUTPUT.PUT_LINE('Random no is '||l_random_number);
1240: --DBMS_OUTPUT.PUT_LINE('list_entry_id is '|| ABS(l_list_entry_id));
1241:
1242: insert into ies_svy_list_entries

Line 1270: dbms_random.terminate;

1266: );
1267:
1268: END LOOP;
1269: CLOSE CLISTENTRYID;
1270: dbms_random.terminate;
1271:
1272: END IF;
1273: ELSIF l_total_list_entries = 0 THEN
1274: -- vacharya: Hard Coded x_message 'IES_SVY_EMPTY_AMS_LIST' remember to enter it in FND_NEW_MESSAGE