APPS.AMS_DMSOURCE_PVT dependencies on DBMS_RANDOM

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

1788: AND TARGET_VALUE = '1';
1789: l_target_count NUMBER;
1790:
1791: BEGIN
1792: DBMS_RANDOM.initialize (TO_NUMBER (TO_CHAR (SYSDATE, 'DDSSSS')));
1793:
1794: -- choang - 09-may-2002
1795: -- per ODM development, changed build data split as:
1796: -- 70% training data, 30% test data.

Line 1798: -- SET training_data_flag = DECODE (MOD (DBMS_RANDOM.random, 2), 0, 'N', 'Y')

1794: -- choang - 09-may-2002
1795: -- per ODM development, changed build data split as:
1796: -- 70% training data, 30% test data.
1797: -- UPDATE ams_dm_source
1798: -- SET training_data_flag = DECODE (MOD (DBMS_RANDOM.random, 2), 0, 'N', 'Y')
1799: -- SET training_data_flag = DECODE (MOD (ABS (DBMS_RANDOM.random), 10), 0, 'N', 1, 'N', 2, 'N', 'Y')
1800: -- WHERE arc_used_for_object = p_object_type
1801: -- AND used_for_object_id = p_object_id;
1802:

Line 1799: -- SET training_data_flag = DECODE (MOD (ABS (DBMS_RANDOM.random), 10), 0, 'N', 1, 'N', 2, 'N', 'Y')

1795: -- per ODM development, changed build data split as:
1796: -- 70% training data, 30% test data.
1797: -- UPDATE ams_dm_source
1798: -- SET training_data_flag = DECODE (MOD (DBMS_RANDOM.random, 2), 0, 'N', 'Y')
1799: -- SET training_data_flag = DECODE (MOD (ABS (DBMS_RANDOM.random), 10), 0, 'N', 1, 'N', 2, 'N', 'Y')
1800: -- WHERE arc_used_for_object = p_object_type
1801: -- AND used_for_object_id = p_object_id;
1802:
1803: -- kbasavar - 24-June-2003

Line 1806: SET training_data_flag = DECODE (MOD (ABS (DBMS_RANDOM.random), 10), 0, 'N', 1, 'N', 2, 'N', 'Y')

1802:
1803: -- kbasavar - 24-June-2003
1804: -- per 11.5.10 enhancements changed to split the positive and negative targets by 70-30
1805: UPDATE ams_dm_source
1806: SET training_data_flag = DECODE (MOD (ABS (DBMS_RANDOM.random), 10), 0, 'N', 1, 'N', 2, 'N', 'Y')
1807: WHERE arc_used_for_object = p_object_type
1808: AND used_for_object_id = p_object_id
1809: AND TARGET_VALUE = '0';
1810:

Line 1812: SET training_data_flag = DECODE (MOD (ABS (DBMS_RANDOM.random), 10), 0, 'N', 1, 'N', 2, 'N', 'Y')

1808: AND used_for_object_id = p_object_id
1809: AND TARGET_VALUE = '0';
1810:
1811: UPDATE ams_dm_source
1812: SET training_data_flag = DECODE (MOD (ABS (DBMS_RANDOM.random), 10), 0, 'N', 1, 'N', 2, 'N', 'Y')
1813: WHERE arc_used_for_object = p_object_type
1814: AND used_for_object_id = p_object_id
1815: AND TARGET_VALUE = '1';
1816:

Line 1845: DBMS_RANDOM.terminate;

1841: END IF;
1842:
1843: CLOSE c_check_targets;
1844:
1845: DBMS_RANDOM.terminate;
1846: END randomize_build_data;
1847:
1848:
1849: -- choang - 03-jun-2002 - obseleted