APPS.AMS_DMSOURCE_PVT dependencies on AMS_DM_APPLY_STG_GT

Line 1409: l_sql := 'INSERT INTO ams_dm_apply_stg_gt (SELECT idkey, score, probability FROM ' || l_source_object || ')';

1405:
1406: -- stage all data into local table for processing
1407: -- nyostos - Sep 15, 2003 - Use Global Temporary Table
1408: -- l_sql := 'INSERT INTO ams_dm_apply_stg (SELECT idkey, score, probability FROM ' || l_source_object || ')';
1409: l_sql := 'INSERT INTO ams_dm_apply_stg_gt (SELECT idkey, score, probability FROM ' || l_source_object || ')';
1410:
1411: IF (AMS_DEBUG_HIGH_ON) THEN
1412: AMS_Utility_PVT.debug_message (L_API_NAME || ' - SQL: ' || l_sql);
1413: END IF;

Line 1435: FROM ams_dm_apply_stg_gt stg

1431:
1432: UPDATE ams_dm_source s
1433: SET (score_result, confidence, continuous_score) = (SELECT score, probability * 100, DECODE (score, l_target_positive_value, probability, 1 - probability) * 100
1434: -- FROM ams_dm_apply_stg stg
1435: FROM ams_dm_apply_stg_gt stg
1436: WHERE stg.source_id = s.source_id)
1437: -- WHERE s.source_id IN (SELECT source_id from ams_dm_apply_stg);
1438: WHERE s.source_id IN (SELECT source_id from ams_dm_apply_stg_gt);
1439:

Line 1438: WHERE s.source_id IN (SELECT source_id from ams_dm_apply_stg_gt);

1434: -- FROM ams_dm_apply_stg stg
1435: FROM ams_dm_apply_stg_gt stg
1436: WHERE stg.source_id = s.source_id)
1437: -- WHERE s.source_id IN (SELECT source_id from ams_dm_apply_stg);
1438: WHERE s.source_id IN (SELECT source_id from ams_dm_apply_stg_gt);
1439:
1440: -- DELETE FROM ams_dm_apply_stg;
1441: DELETE FROM ams_dm_apply_stg_gt;
1442:

Line 1441: DELETE FROM ams_dm_apply_stg_gt;

1437: -- WHERE s.source_id IN (SELECT source_id from ams_dm_apply_stg);
1438: WHERE s.source_id IN (SELECT source_id from ams_dm_apply_stg_gt);
1439:
1440: -- DELETE FROM ams_dm_apply_stg;
1441: DELETE FROM ams_dm_apply_stg_gt;
1442:
1443: -- Standard check for p_commit
1444: IF FND_API.to_Boolean (p_commit) THEN
1445: COMMIT WORK;