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

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

Line: 60


    SELECT
            ID,
            PACKAGE_NAME,
            PROCEDURE_NAME,
            SEQUENCE_NUMBER,
            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_Invc_Mss_Prcdrs
     WHERE okl_invc_mss_prcdrs.id = p_id;

Line: 119


              l_ivm_rec.LAST_UPDATED_BY,
              l_ivm_rec.LAST_UPDATE_DATE,
              l_ivm_rec.LAST_UPDATE_LOGIN;

Line: 142


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            PACKAGE_NAME,
            PROCEDURE_NAME,
            SEQUENCE_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_Invc_Mss_Prcdrs_V
     WHERE okl_invc_mss_prcdrs_v.id = p_id;

Line: 201


              l_ivmv_rec.LAST_UPDATED_BY,
              l_ivmv_rec.LAST_UPDATE_DATE,
              l_ivmv_rec.LAST_UPDATE_LOGIN;

Line: 291


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

Line: 294


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

Line: 297


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

Line: 583


		  SELECT 'x'
		  FROM   okl_invc_mss_prcdrs_v
		  WHERE  package_name   = p_ivmv_rec.package_name
		  AND    procedure_name = p_ivmv_rec.procedure_name
		  AND    id             <> nvl (p_ivmv_rec.id, -99999);

Line: 806


    p_to.last_updated_by := p_from.last_updated_by;

Line: 807


    p_to.last_update_date := p_from.last_update_date;

Line: 808


    p_to.last_update_login := p_from.last_update_login;

Line: 838


    p_to.last_updated_by := p_from.last_updated_by;

Line: 839


    p_to.last_update_date := p_from.last_update_date;

Line: 840


    p_to.last_update_login := p_from.last_update_login;

Line: 1010


  PROCEDURE insert_row(
    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_ivm_rec                      IN ivm_rec_type,
    x_ivm_rec                      OUT NOCOPY ivm_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1019


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

Line: 1055


    INSERT INTO OKL_INVC_MSS_PRCDRS(
        id,
        package_name,
        procedure_name,
        sequence_number,
        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_ivm_rec.id,
        l_ivm_rec.package_name,
        l_ivm_rec.procedure_name,
        l_ivm_rec.sequence_number,
        l_ivm_rec.object_version_number,
        l_ivm_rec.attribute_category,
        l_ivm_rec.attribute1,
        l_ivm_rec.attribute2,
        l_ivm_rec.attribute3,
        l_ivm_rec.attribute4,
        l_ivm_rec.attribute5,
        l_ivm_rec.attribute6,
        l_ivm_rec.attribute7,
        l_ivm_rec.attribute8,
        l_ivm_rec.attribute9,
        l_ivm_rec.attribute10,
        l_ivm_rec.attribute11,
        l_ivm_rec.attribute12,
        l_ivm_rec.attribute13,
        l_ivm_rec.attribute14,
        l_ivm_rec.attribute15,
        l_ivm_rec.created_by,
        l_ivm_rec.creation_date,
        l_ivm_rec.last_updated_by,
        l_ivm_rec.last_update_date,
        l_ivm_rec.last_update_login);

Line: 1143


  END insert_row;

Line: 1147


  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_ivmv_rec                     IN ivmv_rec_type,
    x_ivmv_rec                     OUT NOCOPY ivmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1157


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

Line: 1173


      l_ivmv_rec.LAST_UPDATE_DATE := l_ivmv_rec.CREATION_DATE;

Line: 1174


      l_ivmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1175


      l_ivmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1239


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ivm_rec,
      lx_ivm_rec
    );

Line: 1287


  END insert_row;

Line: 1291


  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_ivmv_tbl                     IN ivmv_tbl_type,
    x_ivmv_tbl                     OUT NOCOPY ivmv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1301


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

Line: 1315


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_ivmv_rec                     => p_ivmv_tbl(i),
          x_ivmv_rec                     => x_ivmv_tbl(i));

Line: 1370


  END insert_row;

Line: 1388


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_INVC_MSS_PRCDRS
     WHERE ID = p_ivm_rec.id
       AND OBJECT_VERSION_NUMBER = p_ivm_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1395


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_INVC_MSS_PRCDRS
    WHERE ID = p_ivm_rec.id;

Line: 1436


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1445


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1649


  PROCEDURE update_row(
    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_ivm_rec                      IN ivm_rec_type,
    x_ivm_rec                      OUT NOCOPY ivm_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1658


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

Line: 1772


      IF (x_ivm_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_ivm_rec.last_updated_by := l_ivm_rec.last_updated_by;

Line: 1776


      IF (x_ivm_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_ivm_rec.last_update_date := l_ivm_rec.last_update_date;

Line: 1780


      IF (x_ivm_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_ivm_rec.last_update_login := l_ivm_rec.last_update_login;

Line: 1824


    UPDATE  OKL_INVC_MSS_PRCDRS
    SET PACKAGE_NAME = l_def_ivm_rec.package_name,
        PROCEDURE_NAME = l_def_ivm_rec.procedure_name,
        SEQUENCE_NUMBER = l_def_ivm_rec.sequence_number,
        OBJECT_VERSION_NUMBER = l_def_ivm_rec.object_version_number,
        ATTRIBUTE_CATEGORY = l_def_ivm_rec.attribute_category,
        ATTRIBUTE1 = l_def_ivm_rec.attribute1,
        ATTRIBUTE2 = l_def_ivm_rec.attribute2,
        ATTRIBUTE3 = l_def_ivm_rec.attribute3,
        ATTRIBUTE4 = l_def_ivm_rec.attribute4,
        ATTRIBUTE5 = l_def_ivm_rec.attribute5,
        ATTRIBUTE6 = l_def_ivm_rec.attribute6,
        ATTRIBUTE7 = l_def_ivm_rec.attribute7,
        ATTRIBUTE8 = l_def_ivm_rec.attribute8,
        ATTRIBUTE9 = l_def_ivm_rec.attribute9,
        ATTRIBUTE10 = l_def_ivm_rec.attribute10,
        ATTRIBUTE11 = l_def_ivm_rec.attribute11,
        ATTRIBUTE12 = l_def_ivm_rec.attribute12,
        ATTRIBUTE13 = l_def_ivm_rec.attribute13,
        ATTRIBUTE14 = l_def_ivm_rec.attribute14,
        ATTRIBUTE15 = l_def_ivm_rec.attribute15,
        CREATED_BY = l_def_ivm_rec.created_by,
        CREATION_DATE = l_def_ivm_rec.creation_date,
        LAST_UPDATED_BY = l_def_ivm_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_ivm_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_ivm_rec.last_update_login
    WHERE ID = l_def_ivm_rec.id;

Line: 1885


  END update_row;

Line: 1889


  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_ivmv_rec                     IN ivmv_rec_type,
    x_ivmv_rec                     OUT NOCOPY ivmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1899


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

Line: 1913


      l_ivmv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1914


      l_ivmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1915


      l_ivmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2027


      IF (x_ivmv_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_ivmv_rec.last_updated_by := l_ivmv_rec.last_updated_by;

Line: 2031


      IF (x_ivmv_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_ivmv_rec.last_update_date := l_ivmv_rec.last_update_date;

Line: 2035


      IF (x_ivmv_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_ivmv_rec.last_update_login := l_ivmv_rec.last_update_login;

Line: 2106


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ivm_rec,
      lx_ivm_rec
    );

Line: 2153


  END update_row;

Line: 2157


  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_ivmv_tbl                     IN ivmv_tbl_type,
    x_ivmv_tbl                     OUT NOCOPY ivmv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2167


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

Line: 2181


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_ivmv_rec                     => p_ivmv_tbl(i),
          x_ivmv_rec                     => x_ivmv_tbl(i));

Line: 2236


  END update_row;

Line: 2244


  PROCEDURE delete_row(
    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_ivm_rec                      IN ivm_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2252


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

Line: 2266


    DELETE FROM OKL_INVC_MSS_PRCDRS
     WHERE ID = l_ivm_rec.id;

Line: 2301


  END delete_row;

Line: 2305


  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_ivmv_rec                     IN ivmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2314


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

Line: 2338


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

Line: 2382


  END delete_row;

Line: 2386


  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_ivmv_tbl                     IN ivmv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2395


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

Line: 2409


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_ivmv_rec                     => p_ivmv_tbl(i));

Line: 2463


  END delete_row;