APPS.BSC_CAUSE_EFFECT_REL_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 48

      SELECT count(*) INTO l_count
      FROM bsc_kpis_b
      WHERE indicator = p_Bsc_Cause_Effect_Rel_Rec.Cause_Indicator;

Line: 52

      SELECT count(*) INTO l_count
      FROM bsc_sys_datasets_b
      WHERE dataset_id = p_Bsc_Cause_Effect_Rel_Rec.Cause_Indicator;

Line: 64

      SELECT count(*) INTO l_count
      FROM bsc_kpis_b
      WHERE indicator = p_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator;

Line: 68

      SELECT count(*) INTO l_count
      FROM bsc_sys_datasets_b
      WHERE dataset_id = p_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator;

Line: 81

  SELECT count(*) INTO l_count
  FROM bsc_kpi_cause_effect_rels
  WHERE
      cause_indicator = p_Bsc_Cause_Effect_Rel_Rec.Cause_Indicator AND
      effect_indicator = p_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator AND
      NVL(cause_level, 'KPI') = p_Bsc_Cause_Effect_Rel_Rec.Cause_Level AND
      NVL(effect_level, 'KPI') = p_Bsc_Cause_Effect_Rel_Rec.Effect_Level;

Line: 91

      l_dynamic_sql := 'INSERT INTO bsc_kpi_cause_effect_rels (cause_indicator,effect_indicator,'||
                       'cause_level,effect_level)VALUES (:1,:2,:3,:4)';

Line: 128

PROCEDURE Delete_Cause_Effect_Rel(
  p_commit              	IN      VARCHAR2 := FND_API.G_FALSE
 ,p_Bsc_Cause_Effect_Rel_Rec	IN      BSC_CAUSE_EFFECT_REL_PUB.Bsc_Cause_Effect_Rel_Rec
 ,x_return_status       	OUT NOCOPY     VARCHAR2
 ,x_msg_count           	OUT NOCOPY     NUMBER
 ,x_msg_data            	OUT NOCOPY     VARCHAR2
) IS

l_count				NUMBER;

Line: 142

  DELETE FROM bsc_kpi_cause_effect_rels
  WHERE
      cause_indicator = p_Bsc_Cause_Effect_Rel_Rec.Cause_Indicator AND
      effect_indicator = p_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator AND
      NVL(cause_level, 'KPI') = p_Bsc_Cause_Effect_Rel_Rec.Cause_Level AND
      NVL(effect_level, 'KPI') = p_Bsc_Cause_Effect_Rel_Rec.Effect_Level;

Line: 175

END Delete_Cause_Effect_Rel;

Line: 180

PROCEDURE Delete_All_Cause_Effect_Rels(
  p_commit              	IN      VARCHAR2 := FND_API.G_FALSE
 ,p_indicator			IN      NUMBER
 ,p_level			IN      VARCHAR2
 ,x_return_status       	OUT NOCOPY     VARCHAR2
 ,x_msg_count           	OUT NOCOPY     NUMBER
 ,x_msg_data            	OUT NOCOPY     VARCHAR2
) IS

l_count				NUMBER;

Line: 195

  DELETE FROM bsc_kpi_cause_effect_rels
  WHERE
      (cause_indicator = p_indicator AND NVL(cause_level, 'KPI') = p_level) OR
      (effect_indicator = p_indicator AND NVL(effect_level, 'KPI') = p_level);

Line: 226

END Delete_All_Cause_Effect_Rels;