APPS.AMS_DMSOURCE_PVT dependencies on DUAL

Line 63: -- an individual row in model data selection is to be

59:
60: --
61: -- PURPOSE
62: -- Randomly set the build data flag to indicate that
63: -- an individual row in model data selection is to be
64: -- used for either training or testing.
65: --
66: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
67: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 310: FROM dual;

306: l_dummy NUMBER;
307:
308: CURSOR c_id IS
309: SELECT AMS_dm_source_s.NEXTVAL
310: FROM dual;
311:
312: CURSOR c_id_exists (l_id IN NUMBER) IS
313: SELECT 1 FROM dual
314: WHERE EXISTS (SELECT 1 FROM ams_dm_source

Line 313: SELECT 1 FROM dual

309: SELECT AMS_dm_source_s.NEXTVAL
310: FROM dual;
311:
312: CURSOR c_id_exists (l_id IN NUMBER) IS
313: SELECT 1 FROM dual
314: WHERE EXISTS (SELECT 1 FROM ams_dm_source
315: WHERE SOURCE_ID = l_id);
316:
317: BEGIN

Line 1709: l_check_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (';

1705: OPEN c_ds_pk_field (p_data_source_id);
1706: FETCH c_ds_pk_field INTO l_ds_pk_field;
1707: CLOSE c_ds_pk_field;
1708:
1709: l_check_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (';
1710: l_check_sql := l_check_sql || 'SELECT ' || l_ds_pk_field || ', COUNT(*) ' || l_from_clause || l_where_clause_sel;
1711: l_check_sql := l_check_sql || ' GROUP BY ' || l_ds_pk_field || ' HAVING COUNT(*) > 1)';
1712:
1713: