APPS.BIS_PMF_ALERT_REG_PVT SQL Statements

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

Line: 79

  select bis_alert_registration_s.NextVal into l_registration_id from dual;

Line: 107

        select '~WF_ADHOC-' ||WF_ADHOC_ROLE_S.NEXTVAL
        into l_null_role_name
        from dual;

Line: 135

  insert into bis_pmf_alert_parameters(
    REGISTRATION_ID
  , PERFORMANCE_MEASURE_ID
  , TARGET_LEVEL_ID
  , TIME_DIMENSION_LEVEL_ID
  , PLAN_ID
  , NOTIFIERS_CODE
  , PARAMETER1_VALUE
  , PARAMETER2_VALUE
  , PARAMETER3_VALUE
  , PARAMETER4_VALUE
  , PARAMETER5_VALUE
  , PARAMETER6_VALUE
  , PARAMETER7_VALUE
  , NOTIFY_OWNER_FLAG
  , CREATION_DATE
  , CREATED_BY
  , LAST_UPDATE_DATE
  , LAST_UPDATED_BY
  , LAST_UPDATE_LOGIN
  )
  values
  ( l_registration_id
  , p_Param_Set_Rec.PERFORMANCE_MEASURE_ID
  , p_Param_Set_Rec.TARGET_LEVEL_ID
  , p_Param_Set_Rec.TIME_DIMENSION_LEVEL_ID
  , p_Param_Set_Rec.PLAN_ID
  , p_Param_Set_Rec.NOTIFIERS_CODE
  , p_Param_Set_Rec.PARAMETER1_VALUE
  , p_Param_Set_Rec.PARAMETER2_VALUE
  , p_Param_Set_Rec.PARAMETER3_VALUE
  , p_Param_Set_Rec.PARAMETER4_VALUE
  , p_Param_Set_Rec.PARAMETER5_VALUE
  , p_Param_Set_Rec.PARAMETER6_VALUE
  , p_Param_Set_Rec.PARAMETER7_VALUE
  , p_Param_Set_Rec.NOTIFY_OWNER_FLAG
  , SYSDATE
  , l_user_id
  , SYSDATE
  , l_user_id
  , l_login_id
  );

Line: 208

PROCEDURE Delete_Parameter_set
( p_api_version      IN  NUMBER
, p_commit           IN  VARCHAR2   := FND_API.G_FALSE
, p_Param_Set_Rec    IN  BIS_PMF_ALERT_REG_PUB.parameter_set_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: 222

    Delete_Parameter_Set(p_Param_Set_Rec.registration_id,x_return_status);

Line: 224

    BIS_UTILITIES_PUB.put_line(p_text =>'Cannot delete parameter set without Registeration ID.');

Line: 233

    BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in delete parameter set: '||sqlerrm);

Line: 236

    BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in delete parameter set: '||sqlerrm);

Line: 238

    BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in delete parameter set: '||sqlerrm);

Line: 244

    , p_error_proc_name   => G_PKG_NAME||'.Delete_Parameter_set'
    , p_error_table       => l_error_tbl
    , x_error_table       => x_error_tbl
    );

Line: 249

END Delete_Parameter_set;

Line: 251

PROCEDURE Delete_Parameter_Set
( p_registration_ID  IN NUMBER
, x_return_status    OUT NOCOPY VARCHAR2
)
IS

  l_count_1 number := 0;

Line: 270

  delete from bis_pmf_alert_parameters
    where registration_id = p_registration_id;

Line: 277

  BIS_UTILITIES_PUB.put_line(p_text =>'before delete: '||l_count_1||', after delete: '||l_count_2);

Line: 278

  l_debug := 'before delete: '||l_count_1||', after delete: '||l_count_2;

Line: 280

  x_return_status := x_return_status ||'--delete debug--'||l_debug;

Line: 285

    BIS_UTILITIES_PUB.put_line(p_text =>'exception in delete parameter set: '||sqlerrm);

Line: 286

END Delete_Parameter_Set;

Line: 307

  Cursor parameter_set_list is select
    REGISTRATION_ID
  , PERFORMANCE_MEASURE_ID
  , TARGET_LEVEL_ID
  , TIME_DIMENSION_LEVEL_ID
  , PLAN_ID
  , NOTIFIERS_CODE
  , PARAMETER1_VALUE
  , PARAMETER2_VALUE
  , PARAMETER3_VALUE
  , PARAMETER4_VALUE
  , PARAMETER5_VALUE
  , PARAMETER6_VALUE
  , PARAMETER7_VALUE
  , NOTIFY_OWNER_FLAG
from
  BIS_PMF_ALERT_PARAMETERS
where PERFORMANCE_MEASURE_ID =  p_measure_id
  and TIME_DIMENSION_LEVEL_ID =  p_time_dimension_level_id;

Line: 405

  select
    REGISTRATION_ID
  , PERFORMANCE_MEASURE_ID
  , TARGET_LEVEL_ID
  , TIME_DIMENSION_LEVEL_ID
  , PLAN_ID
  , NOTIFIERS_CODE
  , PARAMETER1_VALUE
  , PARAMETER2_VALUE
  , PARAMETER3_VALUE
  , PARAMETER4_VALUE
  , PARAMETER5_VALUE
  , PARAMETER6_VALUE
  , PARAMETER7_VALUE
  , NOTIFY_OWNER_FLAG
from
  BIS_PMF_ALERT_PARAMETERS
where  REGISTRATION_ID = p_Param_Set_Rec.REGISTRATION_ID;

Line: 425

  select
    REGISTRATION_ID
  , PERFORMANCE_MEASURE_ID
  , TARGET_LEVEL_ID
  , TIME_DIMENSION_LEVEL_ID
  , PLAN_ID
  , NOTIFIERS_CODE
  , PARAMETER1_VALUE
  , PARAMETER2_VALUE
  , PARAMETER3_VALUE
  , PARAMETER4_VALUE
  , PARAMETER5_VALUE
  , PARAMETER6_VALUE
  , PARAMETER7_VALUE
  , NOTIFY_OWNER_FLAG
from
  BIS_PMF_ALERT_PARAMETERS
where TARGET_LEVEL_ID = p_Param_Set_Rec.TARGET_LEVEL_ID
  and PLAN_ID = p_Param_Set_Rec.PLAN_ID
--  and ( (TIME_DIMENSION_LEVEL_ID IS NULL
--        and p_Param_Set_Rec.TIME_DIMENSION_LEVEL_ID IS NULL)
--       or (TIME_DIMENSION_LEVEL_ID = p_Param_Set_Rec.TIME_DIMENSION_LEVEL_ID))
  and ( (PARAMETER1_VALUE is NULL
         and P_Param_Set_Rec.PARAMETER1_VALUE IS NULL)
       or (PARAMETER1_VALUE = P_Param_Set_Rec.PARAMETER1_VALUE))
  and ((PARAMETER2_VALUE is NULL
        and P_Param_Set_Rec.PARAMETER2_VALUE IS NULL)
       or (PARAMETER2_VALUE = P_Param_Set_Rec.PARAMETER2_VALUE))
  and ( (PARAMETER3_VALUE is NULL
        and P_Param_Set_Rec.PARAMETER3_VALUE IS NULL)
       or(PARAMETER3_VALUE = P_Param_Set_Rec.PARAMETER3_VALUE))
  and ((PARAMETER4_VALUE is NULL
        and P_Param_Set_Rec.PARAMETER4_VALUE IS NULL)
       or (PARAMETER4_VALUE = P_Param_Set_Rec.PARAMETER4_VALUE))
  and ((PARAMETER5_VALUE is NULL
        and P_Param_Set_Rec.PARAMETER5_VALUE IS NULL)
       or (PARAMETER5_VALUE = P_Param_Set_Rec.PARAMETER5_VALUE))
  and ((PARAMETER6_VALUE is NULL
        and P_Param_Set_Rec.PARAMETER6_VALUE IS NULL)
       or (PARAMETER6_VALUE = P_Param_Set_Rec.PARAMETER6_VALUE))
  and ((PARAMETER7_VALUE is NULL
        and P_Param_Set_Rec.PARAMETER7_VALUE IS NULL)
       or (PARAMETER7_VALUE = P_Param_Set_Rec.PARAMETER7_VALUE));