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

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

Line: 43


    SELECT
            ID,
            CAT_ID,
            STY_ID,
            STREAM_ALLC_TYPE,
            OBJECT_VERSION_NUMBER,
            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_Strm_Typ_Allocs
     WHERE okl_strm_typ_allocs.id = p_id;

Line: 104


              l_sta_rec.LAST_UPDATED_BY,
              l_sta_rec.LAST_UPDATE_DATE,
              l_sta_rec.LAST_UPDATE_LOGIN;

Line: 127


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            STY_ID,
            CAT_ID,
            SEQUENCE_NUMBER,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            STREAM_ALLC_TYPE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_STRM_TYP_ALLOCS
     WHERE OKL_STRM_TYP_ALLOCS.id = p_id;

Line: 188


              l_stav_rec.LAST_UPDATED_BY,
              l_stav_rec.LAST_UPDATE_DATE,
              l_stav_rec.LAST_UPDATE_LOGIN;

Line: 281


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

Line: 284


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

Line: 287


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

Line: 352


   SELECT '1'
   FROM   okl_cash_allctn_rls
   WHERE  id = p_stav_rec.cat_id;

Line: 422


   SELECT '1'
   FROM   okl_strm_type_b
   WHERE  id = p_stav_rec.sty_id;

Line: 484


		 SELECT 'x'
		 FROM okl_strm_typ_allocs
		 WHERE sty_id = p_stav_rec.sty_id
		 AND   cat_id = p_stav_rec.cat_id
		 AND   id <> NVL(p_stav_rec.id,-99999);

Line: 662


    p_to.last_updated_by := p_from.last_updated_by;

Line: 663


    p_to.last_update_date := p_from.last_update_date;

Line: 664


    p_to.last_update_login := p_from.last_update_login;

Line: 695


    p_to.last_updated_by := p_from.last_updated_by;

Line: 696


    p_to.last_update_date := p_from.last_update_date;

Line: 697


    p_to.last_update_login := p_from.last_update_login;

Line: 730


    p_to.last_updated_by := p_from.last_updated_by;

Line: 731


    p_to.last_update_date := p_from.last_update_date;

Line: 732


    p_to.last_update_login := p_from.last_update_login;

Line: 910


  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_strm_typ_allocs_h_rec    IN okl_strm_typ_allocs_h_rec_type,
    x_okl_strm_typ_allocs_h_rec    OUT NOCOPY okl_strm_typ_allocs_h_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 919


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

Line: 955


    INSERT INTO OKL_STRM_TYP_ALLOCS_H(
        id,
        major_version,
        cat_id,
        sty_id,
        stream_allc_type,
        object_version_number,
        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)
      VALUES (
        l_okl_strm_typ_allocs_h_rec.id,
        l_okl_strm_typ_allocs_h_rec.major_version,
        l_okl_strm_typ_allocs_h_rec.cat_id,
        l_okl_strm_typ_allocs_h_rec.sty_id,
        l_okl_strm_typ_allocs_h_rec.stream_allc_type,
        l_okl_strm_typ_allocs_h_rec.object_version_number,
        l_okl_strm_typ_allocs_h_rec.sequence_number,
        l_okl_strm_typ_allocs_h_rec.attribute_category,
        l_okl_strm_typ_allocs_h_rec.attribute1,
        l_okl_strm_typ_allocs_h_rec.attribute2,
        l_okl_strm_typ_allocs_h_rec.attribute3,
        l_okl_strm_typ_allocs_h_rec.attribute4,
        l_okl_strm_typ_allocs_h_rec.attribute5,
        l_okl_strm_typ_allocs_h_rec.attribute6,
        l_okl_strm_typ_allocs_h_rec.attribute7,
        l_okl_strm_typ_allocs_h_rec.attribute8,
        l_okl_strm_typ_allocs_h_rec.attribute9,
        l_okl_strm_typ_allocs_h_rec.attribute10,
        l_okl_strm_typ_allocs_h_rec.attribute11,
        l_okl_strm_typ_allocs_h_rec.attribute12,
        l_okl_strm_typ_allocs_h_rec.attribute13,
        l_okl_strm_typ_allocs_h_rec.attribute14,
        l_okl_strm_typ_allocs_h_rec.attribute15,
        l_okl_strm_typ_allocs_h_rec.created_by,
        l_okl_strm_typ_allocs_h_rec.creation_date,
        l_okl_strm_typ_allocs_h_rec.last_updated_by,
        l_okl_strm_typ_allocs_h_rec.last_update_date,
        l_okl_strm_typ_allocs_h_rec.last_update_login);

Line: 1047


  END insert_row;

Line: 1053


  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_sta_rec                      IN sta_rec_type,
    x_sta_rec                      OUT NOCOPY sta_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1062


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

Line: 1098


    INSERT INTO OKL_STRM_TYP_ALLOCS(
        id,
        cat_id,
        sty_id,
        stream_allc_type,
        object_version_number,
        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)
      VALUES (
        l_sta_rec.id,
        l_sta_rec.cat_id,
        l_sta_rec.sty_id,
        l_sta_rec.stream_allc_type,
        l_sta_rec.object_version_number,
        l_sta_rec.sequence_number,
        l_sta_rec.attribute_category,
        l_sta_rec.attribute1,
        l_sta_rec.attribute2,
        l_sta_rec.attribute3,
        l_sta_rec.attribute4,
        l_sta_rec.attribute5,
        l_sta_rec.attribute6,
        l_sta_rec.attribute7,
        l_sta_rec.attribute8,
        l_sta_rec.attribute9,
        l_sta_rec.attribute10,
        l_sta_rec.attribute11,
        l_sta_rec.attribute12,
        l_sta_rec.attribute13,
        l_sta_rec.attribute14,
        l_sta_rec.attribute15,
        l_sta_rec.created_by,
        l_sta_rec.creation_date,
        l_sta_rec.last_updated_by,
        l_sta_rec.last_update_date,
        l_sta_rec.last_update_login);

Line: 1188


  END insert_row;

Line: 1192


  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_stav_rec                     IN stav_rec_type,
    x_stav_rec                     OUT NOCOPY stav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1202


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

Line: 1218


      l_stav_rec.LAST_UPDATE_DATE := l_stav_rec.CREATION_DATE;

Line: 1219


      l_stav_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;

Line: 1220


      l_stav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1284


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sta_rec,
      lx_sta_rec
    );

Line: 1332


  END insert_row;

Line: 1336


  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_stav_tbl                     IN stav_tbl_type,
    x_stav_tbl                     OUT NOCOPY stav_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1346


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

Line: 1361


        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_stav_rec                     => p_stav_tbl(i),
          x_stav_rec                     => x_stav_tbl(i));

Line: 1420


  END insert_row;

Line: 1438


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_STRM_TYP_ALLOCS
     WHERE ID = p_sta_rec.id
       AND OBJECT_VERSION_NUMBER = p_sta_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1445


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_STRM_TYP_ALLOCS
    WHERE ID = p_sta_rec.id;

Line: 1486


      Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1495


      Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1703


  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_sta_rec                      IN sta_rec_type,
    x_sta_rec                      OUT NOCOPY sta_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1712


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

Line: 1836


      IF (x_sta_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_sta_rec.last_updated_by := l_sta_rec.last_updated_by;

Line: 1840


      IF (x_sta_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_sta_rec.last_update_date := l_sta_rec.last_update_date;

Line: 1844


      IF (x_sta_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_sta_rec.last_update_login := l_sta_rec.last_update_login;

Line: 1888


    UPDATE  OKL_STRM_TYP_ALLOCS
    SET CAT_ID = l_def_sta_rec.cat_id,
        STY_ID = l_def_sta_rec.sty_id,
        STREAM_ALLC_TYPE = l_def_sta_rec.stream_allc_type,
        OBJECT_VERSION_NUMBER = l_def_sta_rec.object_version_number,
        SEQUENCE_NUMBER = l_def_sta_rec.sequence_number,
        ATTRIBUTE_CATEGORY = l_def_sta_rec.attribute_category,
        ATTRIBUTE1 = l_def_sta_rec.attribute1,
        ATTRIBUTE2 = l_def_sta_rec.attribute2,
        ATTRIBUTE3 = l_def_sta_rec.attribute3,
        ATTRIBUTE4 = l_def_sta_rec.attribute4,
        ATTRIBUTE5 = l_def_sta_rec.attribute5,
        ATTRIBUTE6 = l_def_sta_rec.attribute6,
        ATTRIBUTE7 = l_def_sta_rec.attribute7,
        ATTRIBUTE8 = l_def_sta_rec.attribute8,
        ATTRIBUTE9 = l_def_sta_rec.attribute9,
        ATTRIBUTE10 = l_def_sta_rec.attribute10,
        ATTRIBUTE11 = l_def_sta_rec.attribute11,
        ATTRIBUTE12 = l_def_sta_rec.attribute12,
        ATTRIBUTE13 = l_def_sta_rec.attribute13,
        ATTRIBUTE14 = l_def_sta_rec.attribute14,
        ATTRIBUTE15 = l_def_sta_rec.attribute15,
        CREATED_BY = l_def_sta_rec.created_by,
        CREATION_DATE = l_def_sta_rec.creation_date,
        LAST_UPDATED_BY = l_def_sta_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_sta_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_sta_rec.last_update_login
    WHERE ID = l_def_sta_rec.id;

Line: 1919


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_strm_typ_allocs_h_rec,
      lx_okl_strm_typ_allocs_h_rec
    );

Line: 1966


  END update_row;

Line: 1970


  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_stav_rec                     IN stav_rec_type,
    x_stav_rec                     OUT NOCOPY stav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1980


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

Line: 1994


      l_stav_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1995


      l_stav_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;

Line: 1996


      l_stav_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 2112


      IF (x_stav_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_stav_rec.last_updated_by := l_stav_rec.last_updated_by;

Line: 2116


      IF (x_stav_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_stav_rec.last_update_date := l_stav_rec.last_update_date;

Line: 2120


      IF (x_stav_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_stav_rec.last_update_login := l_stav_rec.last_update_login;

Line: 2191


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sta_rec,
      lx_sta_rec
    );

Line: 2238


  END update_row;

Line: 2242


  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_stav_tbl                     IN stav_tbl_type,
    x_stav_tbl                     OUT NOCOPY stav_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2252


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

Line: 2267


        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_stav_rec                     => p_stav_tbl(i),
          x_stav_rec                     => x_stav_tbl(i));

Line: 2326


  END update_row;

Line: 2334


  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_sta_rec                      IN sta_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2342


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

Line: 2366


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_strm_typ_allocs_h_rec,
      lx_okl_strm_typ_allocs_h_rec
    );

Line: 2381


    DELETE FROM OKL_STRM_TYP_ALLOCS
     WHERE ID = l_sta_rec.id;

Line: 2416


  END delete_row;

Line: 2420


  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_stav_rec                     IN stav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2429


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

Line: 2453


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

Line: 2497


  END delete_row;

Line: 2501


  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_stav_tbl                     IN stav_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2510


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

Line: 2524


        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_stav_rec                     => p_stav_tbl(i));

Line: 2582


  END delete_row;