eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_MRB_PVT SQL Statements

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

Line: 43


    SELECT
            ID,
            REQUEST_NAME,
            LINE_NUMBER,
            RBR_CODE,
            CRITERIA_CODE,
            OPERAND,
            CRITERIA_VALUE1,
            CRITERIA_VALUE2,
            SET_VALUE,
            DESCRIPTION,
            TSU_CODE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Mass_Rbk_Criteria_V
     WHERE okl_mass_rbk_criteria_v.id = p_id;

Line: 114


              l_mrbv_rec.last_updated_by,
              l_mrbv_rec.last_update_date,
              l_mrbv_rec.last_update_login;

Line: 158


    SELECT
            ID,
            REQUEST_NAME,
            LINE_NUMBER,
            RBR_CODE,
            CRITERIA_CODE,
            OPERAND,
            CRITERIA_VALUE1,
            CRITERIA_VALUE2,
            SET_VALUE,
            DESCRIPTION,
            TSU_CODE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Mass_Rbk_Criteria
     WHERE okl_mass_rbk_criteria.id = p_id;

Line: 229


              l_mrb_rec.last_updated_by,
              l_mrb_rec.last_update_date,
              l_mrb_rec.last_update_login;

Line: 360


    IF (l_mrbv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_mrbv_rec.last_updated_by := NULL;

Line: 363


    IF (l_mrbv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_mrbv_rec.last_update_date := NULL;

Line: 366


    IF (l_mrbv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_mrbv_rec.last_update_login := NULL;

Line: 498


    p_to.last_updated_by := p_from.last_updated_by;

Line: 499


    p_to.last_update_date := p_from.last_update_date;

Line: 500


    p_to.last_update_login := p_from.last_update_login;

Line: 536


    p_to.last_updated_by := p_from.last_updated_by;

Line: 537


    p_to.last_update_date := p_from.last_update_date;

Line: 538


    p_to.last_update_login := p_from.last_update_login;

Line: 703


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mrb_rec                      IN mrb_rec_type,
    x_mrb_rec                      OUT NOCOPY mrb_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 712


    l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';

Line: 748


    INSERT INTO OKL_MASS_RBK_CRITERIA(
      id,
      request_name,
      line_number,
      rbr_code,
      criteria_code,
      operand,
      criteria_value1,
      criteria_value2,
      set_value,
      description,
      tsu_code,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_mrb_rec.id,
      l_mrb_rec.request_name,
      l_mrb_rec.line_number,
      l_mrb_rec.rbr_code,
      l_mrb_rec.criteria_code,
      l_mrb_rec.operand,
      l_mrb_rec.criteria_value1,
      l_mrb_rec.criteria_value2,
      l_mrb_rec.set_value,
      l_mrb_rec.description,
      l_mrb_rec.tsu_code,
      l_mrb_rec.attribute_category,
      l_mrb_rec.attribute1,
      l_mrb_rec.attribute2,
      l_mrb_rec.attribute3,
      l_mrb_rec.attribute4,
      l_mrb_rec.attribute5,
      l_mrb_rec.attribute6,
      l_mrb_rec.attribute7,
      l_mrb_rec.attribute8,
      l_mrb_rec.attribute9,
      l_mrb_rec.attribute10,
      l_mrb_rec.attribute11,
      l_mrb_rec.attribute12,
      l_mrb_rec.attribute13,
      l_mrb_rec.attribute14,
      l_mrb_rec.attribute15,
      l_mrb_rec.created_by,
      l_mrb_rec.creation_date,
      l_mrb_rec.last_updated_by,
      l_mrb_rec.last_update_date,
      l_mrb_rec.last_update_login);

Line: 849


  END insert_row;

Line: 853


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mrbv_rec                     IN mrbv_rec_type,
    x_mrbv_rec                     OUT NOCOPY mrbv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 863


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';

Line: 879


      l_mrbv_rec.LAST_UPDATE_DATE := l_mrbv_rec.CREATION_DATE;

Line: 880


      l_mrbv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 881


      l_mrbv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 944


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_mrb_rec,
      lx_mrb_rec
    );

Line: 993


  END insert_row;

Line: 997


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mrbv_tbl                     IN mrbv_tbl_type,
    x_mrbv_tbl                     OUT NOCOPY mrbv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1007


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';

Line: 1017


        insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_mrbv_rec                     => p_mrbv_tbl(i),
            x_mrbv_rec                     => x_mrbv_tbl(i));

Line: 1070


  END insert_row;

Line: 1088


    SELECT *
      FROM OKL_MASS_RBK_CRITERIA
     WHERE ID = p_mrb_rec.id
    FOR UPDATE NOWAIT;

Line: 1124


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1243


      IF (l_lock_var.last_updated_by <> p_mrb_rec.last_updated_by) THEN
        OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 1247


      IF (l_lock_var.last_update_date <> p_mrb_rec.last_update_date) THEN
        OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 1251


      IF (l_lock_var.last_update_login <> p_mrb_rec.last_update_login) THEN
        OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 1451


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mrb_rec                      IN mrb_rec_type,
    x_mrb_rec                      OUT NOCOPY mrb_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1460


    l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';

Line: 1596


        IF (x_mrb_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_mrb_rec.last_updated_by := l_mrb_rec.last_updated_by;

Line: 1600


        IF (x_mrb_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_mrb_rec.last_update_date := l_mrb_rec.last_update_date;

Line: 1604


        IF (x_mrb_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_mrb_rec.last_update_login := l_mrb_rec.last_update_login;

Line: 1649


    UPDATE OKL_MASS_RBK_CRITERIA
    SET REQUEST_NAME = l_def_mrb_rec.request_name,
        LINE_NUMBER = l_def_mrb_rec.line_number,
        RBR_CODE = l_def_mrb_rec.rbr_code,
        CRITERIA_CODE = l_def_mrb_rec.criteria_code,
        OPERAND = l_def_mrb_rec.operand,
        CRITERIA_VALUE1 = l_def_mrb_rec.criteria_value1,
        CRITERIA_VALUE2 = l_def_mrb_rec.criteria_value2,
        SET_VALUE = l_def_mrb_rec.set_value,
        DESCRIPTION = l_def_mrb_rec.description,
        TSU_CODE = l_def_mrb_rec.tsu_code,
        ATTRIBUTE_CATEGORY = l_def_mrb_rec.attribute_category,
        ATTRIBUTE1 = l_def_mrb_rec.attribute1,
        ATTRIBUTE2 = l_def_mrb_rec.attribute2,
        ATTRIBUTE3 = l_def_mrb_rec.attribute3,
        ATTRIBUTE4 = l_def_mrb_rec.attribute4,
        ATTRIBUTE5 = l_def_mrb_rec.attribute5,
        ATTRIBUTE6 = l_def_mrb_rec.attribute6,
        ATTRIBUTE7 = l_def_mrb_rec.attribute7,
        ATTRIBUTE8 = l_def_mrb_rec.attribute8,
        ATTRIBUTE9 = l_def_mrb_rec.attribute9,
        ATTRIBUTE10 = l_def_mrb_rec.attribute10,
        ATTRIBUTE11 = l_def_mrb_rec.attribute11,
        ATTRIBUTE12 = l_def_mrb_rec.attribute12,
        ATTRIBUTE13 = l_def_mrb_rec.attribute13,
        ATTRIBUTE14 = l_def_mrb_rec.attribute14,
        ATTRIBUTE15 = l_def_mrb_rec.attribute15,
        CREATED_BY = l_def_mrb_rec.created_by,
        CREATION_DATE = l_def_mrb_rec.creation_date,
        LAST_UPDATED_BY = l_def_mrb_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_mrb_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_mrb_rec.last_update_login
    WHERE ID = l_def_mrb_rec.id;

Line: 1717


  END update_row;

Line: 1721


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mrbv_rec                     IN mrbv_rec_type,
    x_mrbv_rec                     OUT NOCOPY mrbv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1731


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';

Line: 1746


      l_mrbv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1747


      l_mrbv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1748


      l_mrbv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1883


        IF (x_mrbv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_mrbv_rec.last_updated_by := l_db_mrbv_rec.last_updated_by;

Line: 1887


        IF (x_mrbv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_mrbv_rec.last_update_date := l_db_mrbv_rec.last_update_date;

Line: 1891


        IF (x_mrbv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_mrbv_rec.last_update_login := l_db_mrbv_rec.last_update_login;

Line: 1962


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_mrb_rec,
      lx_mrb_rec
    );

Line: 2010


  END update_row;

Line: 2014


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mrbv_tbl                     IN mrbv_tbl_type,
    x_mrbv_tbl                     OUT NOCOPY mrbv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2024


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';

Line: 2033


        update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_mrbv_rec                     => p_mrbv_tbl(i),
            x_mrbv_rec                     => x_mrbv_tbl(i));

Line: 2085


  END update_row;

Line: 2093


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mrb_rec                      IN mrb_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2101


    l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';

Line: 2116


    DELETE FROM OKL_MASS_RBK_CRITERIA
     WHERE ID = p_mrb_rec.id;

Line: 2152


  END delete_row;

Line: 2156


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mrbv_rec                     IN mrbv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2165


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';

Line: 2189


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_mrb_rec
    );

Line: 2234


  END delete_row;

Line: 2238


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mrbv_tbl                     IN mrbv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2247


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';

Line: 2256


        delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_mrbv_rec                     => p_mrbv_tbl(i));

Line: 2307


  END delete_row;