DBA Data[Home] [Help]

APPS.BIS_MEASURE_SECURITY_PVT SQL Statements

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

Line: 73

  select bis_indicator_resps_s.NextVal into l_id from dual;
Line: 76

  insert into bis_indicator_resps
  (
    INDICATOR_RESP_ID
  , RESPONSIBILITY_ID
  , TARGET_LEVEL_ID
  , CREATION_DATE
  , CREATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_LOGIN
  )
  values
  ( l_id
  , p_Measure_Security_Rec.RESPONSIBILITY_ID
  , p_Measure_Security_Rec.TARGET_LEVEL_ID
  , SYSDATE
  , l_user_id
  , SYSDATE
  , l_user_id
  , l_login_id
  );
Line: 165

select RESPONSIBILITY_ID
from bis_indicator_resps
where TARGET_LEVEL_ID=p_Target_Level_Rec.Target_Level_Id;
Line: 284

select a.RESPONSIBILITY_ID
         , a.RESPONSIBILITY_KEY
         , a.RESPONSIBILITY_NAME
    from fnd_responsibility_vl a, bis_indicator_resps b
    where VERSION='W'
    and start_date <= sysdate
    and nvl(end_date, sysdate) >= sysdate
    and a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID and b.TARGET_LEVEL_ID=p_Target_Level_Rec.Target_Level_Id
    order by RESPONSIBILITY_NAME;
Line: 420

Procedure Update_Measure_Security
( p_api_version      IN  NUMBER
, p_commit           IN  VARCHAR2   := FND_API.G_FALSE
, p_validation_level IN  NUMBER := FND_API.G_VALID_LEVEL_FULL
, p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
, x_return_status    OUT NOCOPY VARCHAR2
, x_error_Tbl        OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
Line: 462

      , p_error_proc_name   => G_PKG_NAME||'.Update_Measure_Security'
      , p_error_table       => l_error_tbl
      , x_error_table       => x_error_tbl
      );
Line: 468

END Update_Measure_Security;
Line: 473

Procedure Delete_Measure_Security
( p_api_version      IN  NUMBER
, p_commit           IN  VARCHAR2   := FND_API.G_FALSE
, p_Target_Level_Rec IN  BIS_Target_Level_PUB.Target_Level_Rec_Type
, x_return_status    OUT NOCOPY VARCHAR2
, x_error_Tbl        OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
is
begin

  x_return_status := FND_API.G_RET_STS_SUCCESS;
Line: 491

  delete from bis_indicator_resps
  where target_level_id = p_Target_Level_Rec.Target_Level_Id;
Line: 499

end Delete_Measure_Security;
Line: 501

Procedure Delete_Measure_Security
( p_api_version   IN  NUMBER
, p_commit        IN  VARCHAR2   := FND_API.G_FALSE
, p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl     OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
Line: 524

  delete from bis_indicator_resps
  where target_level_id = p_Measure_Security_Rec.Target_Level_Id
    and RESPONSIBILITY_ID = p_Measure_Security_Rec.Responsibility_id;
Line: 550

      , p_error_proc_name   => G_PKG_NAME||'.Delete_Measure_Security'
      , p_error_table       => l_error_tbl
      , x_error_table       => x_error_tbl
      );
Line: 556

END Delete_Measure_Security;
Line: 755

  select il.target_level_id
       , il.target_level_short_name
       , il.target_level_name
       , ir.Responsibility_ID
       , fr.RESPONSIBILITY_NAME
       , fr.RESPONSIBILITY_KEY
  from bis_indicator_resps  ir
     , fnd_user_resp_groups ur
     , bisbv_target_levels  il
     , fnd_responsibility_vl fr
  where ur.user_id           = p_user_id
  and   ir.responsibility_id = ur.responsibility_id
  and   ir.responsibility_id = fr.responsibility_id
  and   il.target_level_id   = ir.target_level_id
  and   il.target_level_id   = p_target_level_rec.target_level_id;
Line: 772

  select il.target_level_id
       , il.target_level_short_name
       , il.target_level_name
       , ir.Responsibility_ID
       , fr.RESPONSIBILITY_NAME
       , fr.RESPONSIBILITY_KEY
  from bis_indicator_resps  ir
     , fnd_user_resp_groups ur
     , bisbv_target_levels  il
     , fnd_responsibility_vl fr
  where ur.user_id           = p_user_id
  and   ir.responsibility_id = ur.responsibility_id
  and   ir.responsibility_id = fr.responsibility_id
  and   il.target_level_id   = ir.target_level_id
  and   il.target_level_short_name=p_target_level_rec.target_level_short_name;
Line: 789

  select il.target_level_id
       , il.target_level_short_name
       , il.target_level_name
       , ir.Responsibility_ID
       , fr.RESPONSIBILITY_NAME
       , fr.RESPONSIBILITY_KEY
  from bis_indicator_resps  ir
     , fnd_user_resp_groups ur
     , bisbv_target_levels  il
     , fnd_responsibility_vl fr
  where ur.user_id           = p_user_id
  and   ir.responsibility_id = ur.responsibility_id
  and   ir.responsibility_id = fr.responsibility_id
  and   il.target_level_id   = ir.target_level_id
  and   il.target_level_name = p_target_level_rec.target_level_name;
Line: 929

  SELECT responsibility_id
  FROM fnd_user_resp_groups
  WHERE user_id=p_user_id;
Line: 933

  SELECT responsibility_id
  FROM bis_indicator_Resps
  WHERE target_level_id=p_target_level_id;
Line: 1030

PROCEDURE Delete_TargetLevel_Resp
( p_commit 				IN  VARCHAR2	:= FND_API.G_FALSE
, p_measure_short_name	IN  VARCHAR2
, x_return_status   	OUT NOCOPY VARCHAR2
, x_error_Tbl			OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
  l_indicator_id NUMBER;
Line: 1040

    SELECT target_level_id FROM bis_target_levels
      WHERE indicator_id = cp_indicator_id;
Line: 1044

  SAVEPOINT delete_resps;
Line: 1046

  SELECT indicator_id INTO l_indicator_id FROM bis_indicators WHERE short_name = p_measure_short_name;
Line: 1048

    DELETE FROM bis_indicator_resps
      WHERE target_level_id = target_cursor.target_level_id;
Line: 1058

    ROLLBACK TO delete_resps;
Line: 1064

      , p_error_proc_name   => G_PKG_NAME||'.Delete_TargetLevel_Resp'
      , p_error_type        => BIS_UTILITIES_PUB.G_ERROR
      , p_error_table       => l_error_tbl
      , x_error_table       => x_error_tbl
      );
Line: 1070

    ROLLBACK TO delete_resps;
Line: 1073

    ROLLBACK TO delete_resps;
Line: 1076

    ROLLBACK TO delete_resps;
Line: 1082

      , p_error_proc_name   => G_PKG_NAME||'.Delete_TargetLevel_Resp'
      , p_error_table       => l_error_tbl
      , x_error_table       => x_error_tbl
      );
Line: 1087

END Delete_TargetLevel_Resp;