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

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

Line: 43


    SELECT
            ID,
            NAME,
            SEQUENCE_NUMBER,
            CASH_SEARCH_TYPE,
            OBJECT_VERSION_NUMBER,
            DESCRIPTION,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Csh_Allct_Srchs
     WHERE okl_csh_allct_srchs.id = p_id;

Line: 106


              l_cah_rec.LAST_UPDATED_BY,
              l_cah_rec.LAST_UPDATE_DATE,
              l_cah_rec.LAST_UPDATE_LOGIN;

Line: 129


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            NAME,
            DESCRIPTION,
            SEQUENCE_NUMBER,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            CASH_SEARCH_TYPE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_CSH_ALLCT_SRCHS
     WHERE OKL_CSH_ALLCT_SRCHS.id = p_id;

Line: 192


              l_cahv_rec.LAST_UPDATED_BY,
              l_cahv_rec.LAST_UPDATE_DATE,
              l_cahv_rec.LAST_UPDATE_LOGIN;

Line: 288


    IF (l_cahv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
      l_cahv_rec.last_updated_by := NULL;

Line: 291


    IF (l_cahv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
      l_cahv_rec.last_update_date := NULL;

Line: 294


    IF (l_cahv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
      l_cahv_rec.last_update_login := NULL;

Line: 335


		 SELECT 'x'
		 FROM okl_csh_allct_srchs
		 WHERE name = p_cahv_rec.name
		 AND   id <> NVL(p_cahv_rec.id,-99999);

Line: 474


    p_to.last_updated_by := p_from.last_updated_by;

Line: 475


    p_to.last_update_date := p_from.last_update_date;

Line: 476


    p_to.last_update_login := p_from.last_update_login;

Line: 508


    p_to.last_updated_by := p_from.last_updated_by;

Line: 509


    p_to.last_update_date := p_from.last_update_date;

Line: 510


    p_to.last_update_login := p_from.last_update_login;

Line: 542


    p_to.last_updated_by := p_from.last_updated_by;

Line: 543


    p_to.last_update_date := p_from.last_update_date;

Line: 544


    p_to.last_update_login := p_from.last_update_login;

Line: 718


  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_okl_csh_allct_srchs_h_rec    IN okl_csh_allct_srchs_h_rec_type,
    x_okl_csh_allct_srchs_h_rec    OUT NOCOPY okl_csh_allct_srchs_h_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 727


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

Line: 773


    INSERT INTO OKL_CSH_ALLCT_SRCHS_H(
        id,
        major_version,
        name,
        sequence_number,
        cash_search_type,
        object_version_number,
        description,
        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_okl_csh_allct_srchs_h_rec.id,
        l_okl_csh_allct_srchs_h_rec.major_version,
        l_okl_csh_allct_srchs_h_rec.name,
        l_okl_csh_allct_srchs_h_rec.sequence_number,
        l_okl_csh_allct_srchs_h_rec.cash_search_type,
        l_okl_csh_allct_srchs_h_rec.object_version_number,
        l_okl_csh_allct_srchs_h_rec.description,
        l_okl_csh_allct_srchs_h_rec.attribute_category,
        l_okl_csh_allct_srchs_h_rec.attribute1,
        l_okl_csh_allct_srchs_h_rec.attribute2,
        l_okl_csh_allct_srchs_h_rec.attribute3,
        l_okl_csh_allct_srchs_h_rec.attribute4,
        l_okl_csh_allct_srchs_h_rec.attribute5,
        l_okl_csh_allct_srchs_h_rec.attribute6,
        l_okl_csh_allct_srchs_h_rec.attribute7,
        l_okl_csh_allct_srchs_h_rec.attribute8,
        l_okl_csh_allct_srchs_h_rec.attribute9,
        l_okl_csh_allct_srchs_h_rec.attribute10,
        l_okl_csh_allct_srchs_h_rec.attribute11,
        l_okl_csh_allct_srchs_h_rec.attribute12,
        l_okl_csh_allct_srchs_h_rec.attribute13,
        l_okl_csh_allct_srchs_h_rec.attribute14,
        l_okl_csh_allct_srchs_h_rec.attribute15,
        l_okl_csh_allct_srchs_h_rec.created_by,
        l_okl_csh_allct_srchs_h_rec.creation_date,
        l_okl_csh_allct_srchs_h_rec.last_updated_by,
        l_okl_csh_allct_srchs_h_rec.last_update_date,
        l_okl_csh_allct_srchs_h_rec.last_update_login);

Line: 865


  END insert_row;

Line: 870


  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_cah_rec                      IN cah_rec_type,
    x_cah_rec                      OUT NOCOPY cah_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 879


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

Line: 915


    INSERT INTO OKL_CSH_ALLCT_SRCHS(
        id,
        name,
        sequence_number,
        cash_search_type,
        object_version_number,
        description,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        org_id,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_cah_rec.id,
        l_cah_rec.name,
        l_cah_rec.sequence_number,
        l_cah_rec.cash_search_type,
        l_cah_rec.object_version_number,
        l_cah_rec.description,
        l_cah_rec.attribute_category,
        l_cah_rec.attribute1,
        l_cah_rec.attribute2,
        l_cah_rec.attribute3,
        l_cah_rec.attribute4,
        l_cah_rec.attribute5,
        l_cah_rec.attribute6,
        l_cah_rec.attribute7,
        l_cah_rec.attribute8,
        l_cah_rec.attribute9,
        l_cah_rec.attribute10,
        l_cah_rec.attribute11,
        l_cah_rec.attribute12,
        l_cah_rec.attribute13,
        l_cah_rec.attribute14,
        l_cah_rec.attribute15,
        l_cah_rec.org_id,
        l_cah_rec.created_by,
        l_cah_rec.creation_date,
        l_cah_rec.last_updated_by,
        l_cah_rec.last_update_date,
        l_cah_rec.last_update_login);

Line: 1019


  END insert_row;

Line: 1023


  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_cahv_rec                     IN cahv_rec_type,
    x_cahv_rec                     OUT NOCOPY cahv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1033


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

Line: 1049


      l_cahv_rec.LAST_UPDATE_DATE := l_cahv_rec.CREATION_DATE;

Line: 1050


      l_cahv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;

Line: 1051


      l_cahv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1121


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cah_rec,
      lx_cah_rec
    );

Line: 1182


  END insert_row;

Line: 1186


  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_cahv_tbl                     IN cahv_tbl_type,
    x_cahv_tbl                     OUT NOCOPY cahv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1196


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

Line: 1227


   SELECT SEQUENCE_NUMBER, ID , NAME
   FROM OKL_CSH_ALLCT_SRCHS
   order by SEQUENCE_NUMBER;

Line: 1244


        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_cahv_rec                     => p_cahv_tbl(i),
          x_cahv_rec                     => x_cahv_tbl(i));

Line: 1295


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okl_Api.G_FALSE,
          x_return_status                => x1_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_cahv_tbl                     => l_cahv_seq_tbl,
          x_cahv_tbl                     => x_cahv_seq_tbl);

Line: 1341


  END insert_row;

Line: 1359


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CSH_ALLCT_SRCHS
     WHERE ID = p_cah_rec.id
       AND OBJECT_VERSION_NUMBER = p_cah_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1366


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CSH_ALLCT_SRCHS
    WHERE ID = p_cah_rec.id;

Line: 1407


      Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1416


      Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1624


  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_cah_rec                      IN cah_rec_type,
    x_cah_rec                      OUT NOCOPY cah_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1633


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

Line: 1761


      IF (x_cah_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_cah_rec.last_updated_by := l_cah_rec.last_updated_by;

Line: 1765


      IF (x_cah_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_cah_rec.last_update_date := l_cah_rec.last_update_date;

Line: 1769


      IF (x_cah_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_cah_rec.last_update_login := l_cah_rec.last_update_login;

Line: 1813


    UPDATE  OKL_CSH_ALLCT_SRCHS
    SET NAME = l_def_cah_rec.name,
        SEQUENCE_NUMBER = l_def_cah_rec.sequence_number,
        CASH_SEARCH_TYPE = l_def_cah_rec.cash_search_type,
        OBJECT_VERSION_NUMBER = l_def_cah_rec.object_version_number,
        DESCRIPTION = l_def_cah_rec.description,
        ATTRIBUTE_CATEGORY = l_def_cah_rec.attribute_category,
        ATTRIBUTE1 = l_def_cah_rec.attribute1,
        ATTRIBUTE2 = l_def_cah_rec.attribute2,
        ATTRIBUTE3 = l_def_cah_rec.attribute3,
        ATTRIBUTE4 = l_def_cah_rec.attribute4,
        ATTRIBUTE5 = l_def_cah_rec.attribute5,
        ATTRIBUTE6 = l_def_cah_rec.attribute6,
        ATTRIBUTE7 = l_def_cah_rec.attribute7,
        ATTRIBUTE8 = l_def_cah_rec.attribute8,
        ATTRIBUTE9 = l_def_cah_rec.attribute9,
        ATTRIBUTE10 = l_def_cah_rec.attribute10,
        ATTRIBUTE11 = l_def_cah_rec.attribute11,
        ATTRIBUTE12 = l_def_cah_rec.attribute12,
        ATTRIBUTE13 = l_def_cah_rec.attribute13,
        ATTRIBUTE14 = l_def_cah_rec.attribute14,
        ATTRIBUTE15 = l_def_cah_rec.attribute15,
        ORG_ID = l_def_cah_rec.org_id,
        CREATED_BY = l_def_cah_rec.created_by,
        CREATION_DATE = l_def_cah_rec.creation_date,
        LAST_UPDATED_BY = l_def_cah_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cah_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cah_rec.last_update_login
    WHERE ID = l_def_cah_rec.id;

Line: 1845


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_csh_allct_srchs_h_rec,
      lx_okl_csh_allct_srchs_h_rec
    );

Line: 1892


  END update_row;

Line: 1896


  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_cahv_rec                     IN cahv_rec_type,
    x_cahv_rec                     OUT NOCOPY cahv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1906


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

Line: 1920


      l_cahv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1921


      l_cahv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;

Line: 1922


      l_cahv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 2042


      IF (x_cahv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_cahv_rec.last_updated_by := l_cahv_rec.last_updated_by;

Line: 2046


      IF (x_cahv_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_cahv_rec.last_update_date := l_cahv_rec.last_update_date;

Line: 2050


      IF (x_cahv_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_cahv_rec.last_update_login := l_cahv_rec.last_update_login;

Line: 2124


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cah_rec,
      lx_cah_rec
    );

Line: 2172


  END update_row;

Line: 2176


  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_cahv_tbl                     IN cahv_tbl_type,
    x_cahv_tbl                     OUT NOCOPY cahv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2186


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

Line: 2213


   SELECT SEQUENCE_NUMBER, ID
   FROM OKL_CSH_ALLCT_SRCHS
   order by SEQUENCE_NUMBER;

Line: 2230


        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_cahv_rec                     => p_cahv_tbl(i),
          x_cahv_rec                     => x_cahv_tbl(i));

Line: 2276


    update_row (
      p_api_version                  => p_api_version,
      p_init_msg_list                => Okl_Api.G_FALSE,
      x_return_status                => x1_return_status,
      x_msg_count                    => x_msg_count,
      x_msg_data                     => x_msg_data,
      p_cahv_rec                     => l_cahv_rec,
      x_cahv_rec                     => x_cahv_rec);

Line: 2327


  END update_row;

Line: 2335


  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_cah_rec                      IN cah_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2343


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

Line: 2366


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_csh_allct_srchs_h_rec,
      lx_okl_csh_allct_srchs_h_rec
    );

Line: 2380


    DELETE FROM OKL_CSH_ALLCT_SRCHS
     WHERE ID = l_cah_rec.id;

Line: 2415


  END delete_row;

Line: 2419


  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_cahv_rec                     IN cahv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2428


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

Line: 2447


   SELECT SEQUENCE_NUMBER, ID
   FROM OKL_CSH_ALLCT_SRCHS
   order by SEQUENCE_NUMBER;

Line: 2478


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

Line: 2509


            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_cahv_rec                     => l_cahv_rec,
              x_cahv_rec                     => x_cahv_rec);

Line: 2567


  END delete_row;

Line: 2571


  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_cahv_tbl                     IN cahv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2580


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

Line: 2594


        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_cahv_rec                     => p_cahv_tbl(i));

Line: 2652


  END delete_row;