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

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

Line: 60


    SELECT
            ID,
            CNR_ID,
            IMS_ID,
            OBJECT_VERSION_NUMBER,
            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_Inv_Mssg_Att
     WHERE okl_inv_mssg_att.id  = p_id;

Line: 117


              l_ima_rec.LAST_UPDATED_BY,
              l_ima_rec.LAST_UPDATE_DATE,
              l_ima_rec.LAST_UPDATE_LOGIN;

Line: 140


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CNR_ID,
            IMS_ID,
            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_Inv_Mssg_Att_V
     WHERE okl_inv_mssg_att_v.id = p_id;

Line: 197


              l_imav_rec.LAST_UPDATED_BY,
              l_imav_rec.LAST_UPDATE_DATE,
              l_imav_rec.LAST_UPDATE_LOGIN;

Line: 284


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

Line: 287


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

Line: 290


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

Line: 416


		  SELECT 'x'
		  FROM   okl_invoice_mssgs_v
		  WHERE  id = p_imav_rec.ims_id;

Line: 505


		  SELECT 'x'
		  FROM   okl_cnsld_ar_hdrs_v
		  WHERE  id = p_imav_rec.cnr_id;

Line: 591


		  SELECT 'x'
		  FROM   okl_inv_mssg_att_v
		  WHERE  ims_id   = p_imav_rec.ims_id
		  AND    cnr_id   = p_imav_rec.cnr_id
		  AND    id       <> nvl (p_imav_rec.id, -99999);

Line: 803


    p_to.last_updated_by := p_from.last_updated_by;

Line: 804


    p_to.last_update_date := p_from.last_update_date;

Line: 805


    p_to.last_update_login := p_from.last_update_login;

Line: 834


    p_to.last_updated_by := p_from.last_updated_by;

Line: 835


    p_to.last_update_date := p_from.last_update_date;

Line: 836


    p_to.last_update_login := p_from.last_update_login;

Line: 1006


  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_ima_rec                      IN ima_rec_type,
    x_ima_rec                      OUT NOCOPY ima_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1015


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

Line: 1051


    INSERT INTO OKL_INV_MSSG_ATT(
        id,
        cnr_id,
        ims_id,
        object_version_number,
        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_ima_rec.id,
        l_ima_rec.cnr_id,
        l_ima_rec.ims_id,
        l_ima_rec.object_version_number,
        l_ima_rec.attribute_category,
        l_ima_rec.attribute1,
        l_ima_rec.attribute2,
        l_ima_rec.attribute3,
        l_ima_rec.attribute4,
        l_ima_rec.attribute5,
        l_ima_rec.attribute6,
        l_ima_rec.attribute7,
        l_ima_rec.attribute8,
        l_ima_rec.attribute9,
        l_ima_rec.attribute10,
        l_ima_rec.attribute11,
        l_ima_rec.attribute12,
        l_ima_rec.attribute13,
        l_ima_rec.attribute14,
        l_ima_rec.attribute15,
        l_ima_rec.created_by,
        l_ima_rec.creation_date,
        l_ima_rec.last_updated_by,
        l_ima_rec.last_update_date,
        l_ima_rec.last_update_login);

Line: 1137


  END insert_row;

Line: 1141


  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_imav_rec                     IN imav_rec_type,
    x_imav_rec                     OUT NOCOPY imav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1151


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

Line: 1167


      l_imav_rec.LAST_UPDATE_DATE := l_imav_rec.CREATION_DATE;

Line: 1168


      l_imav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1169


      l_imav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1233


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ima_rec,
      lx_ima_rec
    );

Line: 1281


  END insert_row;

Line: 1285


  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_imav_tbl                     IN imav_tbl_type,
    x_imav_tbl                     OUT NOCOPY imav_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1295


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

Line: 1309


        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_imav_rec                     => p_imav_tbl(i),
          x_imav_rec                     => x_imav_tbl(i));

Line: 1364


  END insert_row;

Line: 1382


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_INV_MSSG_ATT
     WHERE ID = p_ima_rec.id
       AND OBJECT_VERSION_NUMBER = p_ima_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1389


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_INV_MSSG_ATT
    WHERE ID = p_ima_rec.id;

Line: 1430


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1439


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1643


  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_ima_rec                      IN ima_rec_type,
    x_ima_rec                      OUT NOCOPY ima_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1652


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

Line: 1762


      IF (x_ima_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_ima_rec.last_updated_by := l_ima_rec.last_updated_by;

Line: 1766


      IF (x_ima_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_ima_rec.last_update_date := l_ima_rec.last_update_date;

Line: 1770


      IF (x_ima_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_ima_rec.last_update_login := l_ima_rec.last_update_login;

Line: 1814


    UPDATE  OKL_INV_MSSG_ATT
    SET CNR_ID = l_def_ima_rec.cnr_id,
        IMS_ID = l_def_ima_rec.ims_id,
        OBJECT_VERSION_NUMBER = l_def_ima_rec.object_version_number,
        ATTRIBUTE_CATEGORY = l_def_ima_rec.attribute_category,
        ATTRIBUTE1 = l_def_ima_rec.attribute1,
        ATTRIBUTE2 = l_def_ima_rec.attribute2,
        ATTRIBUTE3 = l_def_ima_rec.attribute3,
        ATTRIBUTE4 = l_def_ima_rec.attribute4,
        ATTRIBUTE5 = l_def_ima_rec.attribute5,
        ATTRIBUTE6 = l_def_ima_rec.attribute6,
        ATTRIBUTE7 = l_def_ima_rec.attribute7,
        ATTRIBUTE8 = l_def_ima_rec.attribute8,
        ATTRIBUTE9 = l_def_ima_rec.attribute9,
        ATTRIBUTE10 = l_def_ima_rec.attribute10,
        ATTRIBUTE11 = l_def_ima_rec.attribute11,
        ATTRIBUTE12 = l_def_ima_rec.attribute12,
        ATTRIBUTE13 = l_def_ima_rec.attribute13,
        ATTRIBUTE14 = l_def_ima_rec.attribute14,
        ATTRIBUTE15 = l_def_ima_rec.attribute15,
        CREATED_BY = l_def_ima_rec.created_by,
        CREATION_DATE = l_def_ima_rec.creation_date,
        LAST_UPDATED_BY = l_def_ima_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_ima_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_ima_rec.last_update_login
    WHERE ID = l_def_ima_rec.id;

Line: 1874


  END update_row;

Line: 1878


  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_imav_rec                     IN imav_rec_type,
    x_imav_rec                     OUT NOCOPY imav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1888


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

Line: 1902


      l_imav_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1903


      l_imav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1904


      l_imav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2012


      IF (x_imav_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_imav_rec.last_updated_by := l_imav_rec.last_updated_by;

Line: 2016


      IF (x_imav_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_imav_rec.last_update_date := l_imav_rec.last_update_date;

Line: 2020


      IF (x_imav_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_imav_rec.last_update_login := l_imav_rec.last_update_login;

Line: 2091


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ima_rec,
      lx_ima_rec
    );

Line: 2138


  END update_row;

Line: 2142


  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_imav_tbl                     IN imav_tbl_type,
    x_imav_tbl                     OUT NOCOPY imav_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2152


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

Line: 2166


        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_imav_rec                     => p_imav_tbl(i),
          x_imav_rec                     => x_imav_tbl(i));

Line: 2221


  END update_row;

Line: 2229


  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_ima_rec                      IN ima_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2237


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

Line: 2251


    DELETE FROM OKL_INV_MSSG_ATT
     WHERE ID = l_ima_rec.id;

Line: 2286


  END delete_row;

Line: 2290


  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_imav_rec                     IN imav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2299


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

Line: 2323


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ima_rec
    );

Line: 2367


  END delete_row;

Line: 2371


  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_imav_tbl                     IN imav_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2380


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

Line: 2394


        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_imav_rec                     => p_imav_tbl(i));

Line: 2448


  END delete_row;