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_MST_PVT SQL Statements

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

Line: 20


    SELECT 'Y'
    FROM   okl_mass_rbk_criteria
    WHERE  request_name = p_request_name;

Line: 102


    SELECT
            ID,
            REQUEST_NAME,
            KHR_ID,
            CONTRACT_NUMBER,
            CONTRACT_DESCRIPTION,
            KLE_ID,
            TRANSACTION_ID,
            SELECTED_FLAG,
            STATUS,
            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,
            TRANSACTION_DATE
      FROM Okl_Rbk_Selected_Contract_V
     WHERE okl_rbk_selected_contract_v.id = p_id;

Line: 150


              l_mstv_rec.selected_flag,
              l_mstv_rec.status,
              l_mstv_rec.attribute_category,
              l_mstv_rec.attribute1,
              l_mstv_rec.attribute2,
              l_mstv_rec.attribute3,
              l_mstv_rec.attribute4,
              l_mstv_rec.attribute5,
              l_mstv_rec.attribute6,
              l_mstv_rec.attribute7,
              l_mstv_rec.attribute8,
              l_mstv_rec.attribute9,
              l_mstv_rec.attribute10,
              l_mstv_rec.attribute11,
              l_mstv_rec.attribute12,
              l_mstv_rec.attribute13,
              l_mstv_rec.attribute14,
              l_mstv_rec.attribute15,
              l_mstv_rec.created_by,
              l_mstv_rec.creation_date,
              l_mstv_rec.last_updated_by,
              l_mstv_rec.last_update_date,
              l_mstv_rec.last_update_login,
              l_mstv_rec.transaction_date;

Line: 215


    SELECT
            ID,
            request_name,
            KHR_ID,
            CONTRACT_NUMBER,
            contract_description,
            KLE_ID,
            TRANSACTION_ID,
            SELECTED_FLAG,
            STATUS,
            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,
            TRANSACTION_DATE
      FROM Okl_Rbk_Selected_Contract
     WHERE okl_rbk_selected_contract.id = p_id;

Line: 263


              l_mst_rec.selected_flag,
              l_mst_rec.status,
              l_mst_rec.attribute_category,
              l_mst_rec.attribute1,
              l_mst_rec.attribute2,
              l_mst_rec.attribute3,
              l_mst_rec.attribute4,
              l_mst_rec.attribute5,
              l_mst_rec.attribute6,
              l_mst_rec.attribute7,
              l_mst_rec.attribute8,
              l_mst_rec.attribute9,
              l_mst_rec.attribute10,
              l_mst_rec.attribute11,
              l_mst_rec.attribute12,
              l_mst_rec.attribute13,
              l_mst_rec.attribute14,
              l_mst_rec.attribute15,
              l_mst_rec.created_by,
              l_mst_rec.creation_date,
              l_mst_rec.last_updated_by,
              l_mst_rec.last_update_date,
              l_mst_rec.last_update_login,
              l_mst_rec.transaction_date;

Line: 349


    IF (l_mstv_rec.selected_flag = OKL_API.G_MISS_CHAR ) THEN
      l_mstv_rec.selected_flag := NULL;

Line: 409


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

Line: 412


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

Line: 415


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

Line: 546


    p_to.selected_flag := p_from.selected_flag;

Line: 566


    p_to.last_updated_by := p_from.last_updated_by;

Line: 567


    p_to.last_update_date := p_from.last_update_date;

Line: 568


    p_to.last_update_login := p_from.last_update_login;

Line: 583


    p_to.selected_flag := p_from.selected_flag;

Line: 603


    p_to.last_updated_by := p_from.last_updated_by;

Line: 604


    p_to.last_update_date := p_from.last_update_date;

Line: 605


    p_to.last_update_login := p_from.last_update_login;

Line: 768


  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_mst_rec                      IN mst_rec_type,
    x_mst_rec                      OUT NOCOPY mst_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 777


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

Line: 813


    INSERT INTO OKL_RBK_SELECTED_CONTRACT(
      id,
      request_name,
      khr_id,
      contract_number,
      contract_description,
      kle_id,
      transaction_id,
      selected_flag,
      status,
      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,
      transaction_date)
    VALUES (
      l_mst_rec.id,
      l_mst_rec.request_name,
      l_mst_rec.khr_id,
      l_mst_rec.contract_number,
      l_mst_rec.contract_description,
      l_mst_rec.kle_id,
      l_mst_rec.transaction_id,
      l_mst_rec.selected_flag,
      l_mst_rec.status,
      l_mst_rec.attribute_category,
      l_mst_rec.attribute1,
      l_mst_rec.attribute2,
      l_mst_rec.attribute3,
      l_mst_rec.attribute4,
      l_mst_rec.attribute5,
      l_mst_rec.attribute6,
      l_mst_rec.attribute7,
      l_mst_rec.attribute8,
      l_mst_rec.attribute9,
      l_mst_rec.attribute10,
      l_mst_rec.attribute11,
      l_mst_rec.attribute12,
      l_mst_rec.attribute13,
      l_mst_rec.attribute14,
      l_mst_rec.attribute15,
      l_mst_rec.created_by,
      l_mst_rec.creation_date,
      l_mst_rec.last_updated_by,
      l_mst_rec.last_update_date,
      l_mst_rec.last_update_login,
      l_mst_rec.transaction_date);

Line: 912


  END insert_row;

Line: 916


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mstv_rec                     IN mstv_rec_type,
    x_mstv_rec                     OUT NOCOPY mstv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 926


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

Line: 942


      l_mstv_rec.LAST_UPDATE_DATE := l_mstv_rec.CREATION_DATE;

Line: 943


      l_mstv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 944


      l_mstv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1007


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_mst_rec,
      lx_mst_rec
    );

Line: 1056


  END insert_row;

Line: 1060


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mstv_tbl                     IN mstv_tbl_type,
    x_mstv_tbl                     OUT NOCOPY mstv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1070


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

Line: 1079


          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_mstv_rec                     => p_mstv_tbl(i),
            x_mstv_rec                     => x_mstv_tbl(i));

Line: 1131


  END insert_row;

Line: 1149


    SELECT *
      FROM OKL_RBK_SELECTED_CONTRACT
     WHERE ID = p_mst_rec.id
    FOR UPDATE NOWAIT;

Line: 1185


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1216


      IF (l_lock_var.selected_flag <> p_mst_rec.selected_flag) THEN
        OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 1296


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

Line: 1300


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

Line: 1304


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

Line: 1507


  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_mst_rec                      IN mst_rec_type,
    x_mst_rec                      OUT NOCOPY mst_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1516


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

Line: 1564


        IF (x_mst_rec.selected_flag = OKL_API.G_MISS_CHAR)
        THEN
          x_mst_rec.selected_flag := l_mst_rec.selected_flag;

Line: 1644


        IF (x_mst_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_mst_rec.last_updated_by := l_mst_rec.last_updated_by;

Line: 1648


        IF (x_mst_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_mst_rec.last_update_date := l_mst_rec.last_update_date;

Line: 1652


        IF (x_mst_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_mst_rec.last_update_login := l_mst_rec.last_update_login;

Line: 1701


    UPDATE OKL_RBK_SELECTED_CONTRACT
    SET request_name = l_def_mst_rec.request_name,
        KHR_ID = l_def_mst_rec.khr_id,
        CONTRACT_NUMBER = l_def_mst_rec.contract_number,
        contract_description = l_def_mst_rec.contract_description,
        KLE_ID = l_def_mst_rec.kle_id,
        TRANSACTION_ID = l_def_mst_rec.transaction_id,
        SELECTED_FLAG = l_def_mst_rec.selected_flag,
        STATUS = l_def_mst_rec.status,
        ATTRIBUTE_CATEGORY = l_def_mst_rec.attribute_category,
        ATTRIBUTE1 = l_def_mst_rec.attribute1,
        ATTRIBUTE2 = l_def_mst_rec.attribute2,
        ATTRIBUTE3 = l_def_mst_rec.attribute3,
        ATTRIBUTE4 = l_def_mst_rec.attribute4,
        ATTRIBUTE5 = l_def_mst_rec.attribute5,
        ATTRIBUTE6 = l_def_mst_rec.attribute6,
        ATTRIBUTE7 = l_def_mst_rec.attribute7,
        ATTRIBUTE8 = l_def_mst_rec.attribute8,
        ATTRIBUTE9 = l_def_mst_rec.attribute9,
        ATTRIBUTE10 = l_def_mst_rec.attribute10,
        ATTRIBUTE11 = l_def_mst_rec.attribute11,
        ATTRIBUTE12 = l_def_mst_rec.attribute12,
        ATTRIBUTE13 = l_def_mst_rec.attribute13,
        ATTRIBUTE14 = l_def_mst_rec.attribute14,
        ATTRIBUTE15 = l_def_mst_rec.attribute15,
        CREATED_BY = l_def_mst_rec.created_by,
        CREATION_DATE = l_def_mst_rec.creation_date,
        LAST_UPDATED_BY = l_def_mst_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_mst_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_mst_rec.last_update_login,
        TRANSACTION_DATE = l_def_mst_rec.transaction_date
    WHERE ID = l_def_mst_rec.id;

Line: 1768


  END update_row;

Line: 1772


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mstv_rec                     IN mstv_rec_type,
    x_mstv_rec                     OUT NOCOPY mstv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1782


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

Line: 1797


      l_mstv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1798


      l_mstv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1799


      l_mstv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1846


        IF (x_mstv_rec.selected_flag = OKL_API.G_MISS_CHAR)
        THEN
          x_mstv_rec.selected_flag := l_db_mstv_rec.selected_flag;

Line: 1926


        IF (x_mstv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_mstv_rec.last_updated_by := l_db_mstv_rec.last_updated_by;

Line: 1930


        IF (x_mstv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_mstv_rec.last_update_date := l_db_mstv_rec.last_update_date;

Line: 1934


        IF (x_mstv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_mstv_rec.last_update_login := l_db_mstv_rec.last_update_login;

Line: 2009


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_mst_rec,
      lx_mst_rec
    );

Line: 2057


  END update_row;

Line: 2061


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mstv_tbl                     IN mstv_tbl_type,
    x_mstv_tbl                     OUT NOCOPY mstv_tbl_type ) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2071


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

Line: 2080


        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_mstv_rec                     => p_mstv_tbl(i),
            x_mstv_rec                     => x_mstv_tbl(i));

Line: 2132


  END update_row;

Line: 2140


  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_mst_rec                      IN mst_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2148


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

Line: 2163


    DELETE FROM OKL_RBK_SELECTED_CONTRACT
     WHERE ID = p_mst_rec.id;

Line: 2199


  END delete_row;

Line: 2204


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mstv_rec                     IN mstv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2213


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

Line: 2237


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

Line: 2282


  END delete_row;

Line: 2287


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_mstv_tbl                     IN mstv_tbl_type ) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2296


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

Line: 2305


        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_mstv_rec                     => p_mstv_tbl(i));

Line: 2356


  END delete_row;