APPS.FND_SVC_COMP_PARAM_VALS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_COMPONENT_PARAMETER_ID in NUMBER,
  X_COMPONENT_ID in NUMBER,
  X_PARAMETER_ID in NUMBER,
  X_PARAMETER_VALUE in VARCHAR2,
  X_CUSTOMIZATION_LEVEL in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from FND_SVC_COMP_PARAM_VALS
    where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID
    ;

Line: 22

  insert into FND_SVC_COMP_PARAM_VALS (
    COMPONENT_PARAMETER_ID,
    COMPONENT_ID,
    PARAMETER_ID,
    PARAMETER_VALUE,
    CUSTOMIZATION_LEVEL,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values
  (
    X_COMPONENT_PARAMETER_ID,
    X_COMPONENT_ID,
    X_PARAMETER_ID,
    X_PARAMETER_VALUE,
    X_CUSTOMIZATION_LEVEL,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_OBJECT_VERSION_NUMBER
  );

Line: 59

    wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Insert_Row', X_COMPONENT_PARAMETER_ID);

Line: 61

end INSERT_ROW;

Line: 72

  cursor c is select
      COMPONENT_ID,
      PARAMETER_ID,
      PARAMETER_VALUE,
      CUSTOMIZATION_LEVEL,
      OBJECT_VERSION_NUMBER
    from FND_SVC_COMP_PARAM_VALS
    where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID
    for update of COMPONENT_PARAMETER_ID nowait;

Line: 88

    wf_core.raise('WF_RECORD_DELETED');

Line: 112

procedure UPDATE_ROW (
  X_COMPONENT_PARAMETER_ID in NUMBER,
  X_COMPONENT_ID in NUMBER,
  X_PARAMETER_ID in NUMBER,
  X_PARAMETER_VALUE in VARCHAR2,
  X_CUSTOMIZATION_LEVEL in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is

  l_object_version_number NUMBER;

Line: 135

    select OBJECT_VERSION_NUMBER
    into l_object_version_number
    from FND_SVC_COMP_PARAM_VALS
    where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID;

Line: 152

    select OBJECT_VERSION_NUMBER
    into l_object_version_number
    from FND_SVC_COMP_PARAM_VALS
    where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID
    for update;

Line: 164

        wf_core.translate('SVC_RECORD_ALREADY_UPDATED'));

Line: 181

      update FND_SVC_COMP_PARAM_VALS set
        COMPONENT_ID = X_COMPONENT_ID,
        PARAMETER_ID = X_PARAMETER_ID,
        PARAMETER_VALUE = X_PARAMETER_VALUE,
        CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,
        OBJECT_VERSION_NUMBER = l_object_version_number,
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
      where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID;

Line: 215

      update FND_SVC_COMP_PARAM_VALS set
        COMPONENT_ID = X_COMPONENT_ID,
        PARAMETER_ID = X_PARAMETER_ID,
        -- PARAMETER_VALUE = X_PARAMETER_VALUE, // limit column
        CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,
        OBJECT_VERSION_NUMBER = l_object_version_number,
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
      where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID;

Line: 237

      update FND_SVC_COMP_PARAM_VALS set
        PARAMETER_VALUE = X_PARAMETER_VALUE,
        OBJECT_VERSION_NUMBER = l_object_version_number,
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
      where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID;

Line: 268

      update FND_SVC_COMP_PARAM_VALS set
        COMPONENT_ID = X_COMPONENT_ID,
        PARAMETER_ID = X_PARAMETER_ID,
        PARAMETER_VALUE = X_PARAMETER_VALUE,
        CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,
        OBJECT_VERSION_NUMBER = l_object_version_number,
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
      where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID;

Line: 287

    wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Update_Row', X_COMPONENT_PARAMETER_ID);

Line: 289

end UPDATE_ROW;

Line: 291

procedure DELETE_ROW (
  X_COMPONENT_PARAMETER_ID in NUMBER
) is
l_customization_level varchar2(1);

Line: 297

  select CUSTOMIZATION_LEVEL
  into l_customization_level
  from FND_SVC_COMP_PARAM_VALS
  where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID;

Line: 304

    delete from FND_SVC_COMP_PARAM_VALS
    where COMPONENT_PARAMETER_ID = X_COMPONENT_PARAMETER_ID;

Line: 313

    wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Delete_Row', X_COMPONENT_PARAMETER_ID);

Line: 316

end DELETE_ROW;

Line: 344

      SELECT component_id, component_type
      INTO l_component_id, l_component_type
      FROM fnd_svc_components
      WHERE component_name = X_COMPONENT_NAME;

Line: 349

      SELECT parameter_id
      INTO l_parameter_id
      FROM fnd_svc_comp_params_b
      WHERE parameter_name = X_PARAMETER_NAME
        AND component_type = l_component_type;

Line: 357

        SELECT component_parameter_id
        INTO l_component_parameter_id
        FROM fnd_svc_comp_param_vals
        WHERE component_id = l_component_id
        AND parameter_id = l_parameter_id;

Line: 363

        FND_SVC_COMP_PARAM_VALS_PKG.UPDATE_ROW (
            X_COMPONENT_PARAMETER_ID => l_component_parameter_id,
            X_COMPONENT_ID => l_component_id,
            X_PARAMETER_ID => l_parameter_id,
            X_PARAMETER_VALUE => X_PARAMETER_VALUE,
            X_CUSTOMIZATION_LEVEL => X_CUSTOMIZATION_LEVEL,
            X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
            X_LAST_UPDATE_DATE => sysdate,
            X_LAST_UPDATED_BY => user_id,
            X_LAST_UPDATE_LOGIN => 0);

Line: 376

          SELECT fnd_svc_comp_param_vals_s.nextval
          INTO l_component_parameter_id
          FROM dual;

Line: 380

          FND_SVC_COMP_PARAM_VALS_PKG.INSERT_ROW (
              X_ROWID => row_id,
              X_COMPONENT_PARAMETER_ID => l_component_parameter_id,
              X_COMPONENT_ID => l_component_id,
              X_PARAMETER_ID => l_parameter_id,
              X_PARAMETER_VALUE => X_PARAMETER_VALUE,
              X_CUSTOMIZATION_LEVEL => X_CUSTOMIZATION_LEVEL,
              X_CREATION_DATE => sysdate,
              X_CREATED_BY => user_id,
              X_LAST_UPDATE_DATE => sysdate,
              X_LAST_UPDATED_BY => user_id,
              X_LAST_UPDATE_LOGIN => 0);