APPS.BIS_CUSTOM_CAUSE_EFFECT_PVT SQL Statements

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

Line: 43

  INSERT INTO BIS_CUSTOM_CAUSE_EFFECT_RELS
  (
    ID,
    CAUSE_SHORT_NAME,
    EFFECT_SHORT_NAME,
    CAUSE_SEQUENCE,
    EFFECT_SEQUENCE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  )
  VALUES
  (
    BIS_CAUSE_EFFECT_S.nextVal,
    p_Cause_Short_Name,
    p_Effect_Short_Name,
    p_Cause_Sequence,
    p_Effect_Sequence,
    FND_GLOBAL.USER_ID,
    SYSDATE,
    FND_GLOBAL.USER_ID,
    SYSDATE,
    FND_GLOBAL.LOGIN_ID
  );

Line: 84

PROCEDURE Update_Custom_Cause_Effect_Rel(
  p_commit              	IN      VARCHAR2 := FND_API.G_FALSE
 ,p_Cause_Short_Name     	IN	bis_custom_cause_effect_rels.cause_short_name%TYPE
 ,p_Effect_Short_Name     	IN	bis_custom_cause_effect_rels.effect_short_name%TYPE
 ,p_Cause_Sequence         	IN	bis_custom_cause_effect_rels.cause_sequence%TYPE
 ,p_Effect_Sequence         	IN	bis_custom_cause_effect_rels.effect_sequence%TYPE
 ,x_return_status       	OUT NOCOPY     VARCHAR2
 ,x_msg_count			OUT NOCOPY	NUMBER
 ,x_msg_data			OUT NOCOPY	VARCHAR2
)IS

  l_count NUMBER := 0;

Line: 98

  SELECT COUNT(1)
  FROM bis_custom_cause_effect_rels
  WHERE cause_short_name = x_cause_short_name
  AND effect_short_name = x_effect_short_name;

Line: 136

    UPDATE bis_custom_cause_effect_rels
    SET
      cause_sequence    = p_Cause_Sequence
    , effect_sequence   = p_Effect_Sequence
    , last_updated_by   = FND_GLOBAL.USER_ID
    , last_update_date  = SYSDATE
    , last_update_login = FND_GLOBAL.LOGIN_ID
    WHERE
      cause_short_name = p_Cause_Short_Name AND
      effect_short_name = p_Effect_Short_Name;

Line: 156

            x_msg_data      :=  x_msg_data||' -> BIS_CUSTOM_CAUSE_EFFECT_PVT.Update_Custom_Cause_Effect_Rel ';

Line: 158

            x_msg_data      :=  SQLERRM||' at BIS_CUSTOM_CAUSE_EFFECT_PVT.Update_Custom_Cause_Effect_Rel ';

Line: 160

END Update_Custom_Cause_Effect_Rel;

Line: 163

PROCEDURE Delete_Custom_Cause_Effect_Rel(
  p_commit              	IN      VARCHAR2 := FND_API.G_FALSE
 ,p_Cause_Short_Name     	IN	bis_custom_cause_effect_rels.cause_short_name%TYPE
 ,p_Effect_Short_Name     	IN	bis_custom_cause_effect_rels.effect_short_name%TYPE
 ,x_return_status       	OUT NOCOPY     VARCHAR2
 ,x_msg_count			OUT NOCOPY	NUMBER
 ,x_msg_data			OUT NOCOPY	VARCHAR2
) IS
  l_count NUMBER := 0;

Line: 174

  SELECT COUNT(1)
  FROM bis_custom_cause_effect_rels
  WHERE cause_short_name = x_cause_short_name
  AND effect_short_name = x_effect_short_name;

Line: 200

    DELETE FROM bis_custom_cause_effect_rels
    WHERE
      cause_short_name = p_Cause_Short_Name AND
      effect_short_name = p_Effect_Short_Name;

Line: 214

            x_msg_data      :=  x_msg_data||' -> BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';

Line: 216

            x_msg_data      :=  SQLERRM||' at BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';

Line: 219

END Delete_Custom_Cause_Effect_Rel;

Line: 222

PROCEDURE Delete_Custom_Cause_Effect_Rel(
  p_commit              	IN      VARCHAR2 := FND_API.G_FALSE
 ,p_Cause_DataSetId     	IN	bis_indicators.dataset_id%TYPE
 ,p_Effect_DataSetId     	IN	bis_indicators.dataset_id%TYPE
 ,x_return_status       	OUT NOCOPY     VARCHAR2
 ,x_msg_count			OUT NOCOPY	NUMBER
 ,x_msg_data			OUT NOCOPY	VARCHAR2
)
IS
  l_Cause_Short_Name bis_custom_cause_effect_rels.cause_short_name%TYPE;

Line: 236

  SELECT
    short_name
  FROM
    bis_indicators
  WHERE
    dataset_id = l_dataset_id;

Line: 267

  Delete_Custom_Cause_Effect_Rel(
      p_commit             => p_commit
    , p_Cause_Short_Name   => l_Cause_Short_Name
    , p_Effect_Short_Name  => l_Effect_Short_Name
    , x_return_status      => x_return_status
    , x_msg_count          => x_msg_count
    , x_msg_data           => x_msg_data
  );

Line: 280

            x_msg_data      :=  x_msg_data||' -> BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';

Line: 282

            x_msg_data      :=  SQLERRM||' at BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';

Line: 285

END Delete_Custom_Cause_Effect_Rel;