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

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

Line: 43


    SELECT
            ID,
            NAME,
            OBJECT_VERSION_NUMBER,
            DESCRIPTION,
            FROM_DATE,
            TO_DATE,
            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_Options
     WHERE okl_options.id       = p_id;

Line: 104


              l_opt_rec.LAST_UPDATED_BY,
              l_opt_rec.LAST_UPDATE_DATE,
              l_opt_rec.LAST_UPDATE_LOGIN;

Line: 127


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            NAME,
            DESCRIPTION,
            FROM_DATE,
            TO_DATE,
            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_Options_V
     WHERE okl_options_v.id     = p_id;

Line: 188


              l_optv_rec.LAST_UPDATED_BY,
              l_optv_rec.LAST_UPDATE_DATE,
              l_optv_rec.LAST_UPDATE_LOGIN;

Line: 281


    IF (l_optv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_optv_rec.last_updated_by := NULL;

Line: 284


    IF (l_optv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_optv_rec.last_update_date := NULL;

Line: 287


    IF (l_optv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_optv_rec.last_update_login := NULL;

Line: 521


    SELECT '1'
       FROM OKL_OPTIONS_V
      WHERE OKL_OPTIONS_V.NAME =  p_unique AND
            OKL_OPTIONS_V.ID <> NVL(p_optv_rec.id,-9999);

Line: 787


    p_to.last_updated_by := p_from.last_updated_by;

Line: 788


    p_to.last_update_date := p_from.last_update_date;

Line: 789


    p_to.last_update_login := p_from.last_update_login;

Line: 820


    p_to.last_updated_by := p_from.last_updated_by;

Line: 821


    p_to.last_update_date := p_from.last_update_date;

Line: 822


    p_to.last_update_login := p_from.last_update_login;

Line: 984


  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_opt_rec                      IN opt_rec_type,
    x_opt_rec                      OUT NOCOPY opt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 993


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

Line: 1029


    INSERT INTO OKL_OPTIONS(
        id,
        name,
        object_version_number,
        description,
        from_date,
        TO_DATE,
        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_opt_rec.id,
        UPPER(l_opt_rec.name),
        l_opt_rec.object_version_number,
        l_opt_rec.description,
        l_opt_rec.from_date,
        l_opt_rec.TO_DATE,
        l_opt_rec.attribute_category,
        l_opt_rec.attribute1,
        l_opt_rec.attribute2,
        l_opt_rec.attribute3,
        l_opt_rec.attribute4,
        l_opt_rec.attribute5,
        l_opt_rec.attribute6,
        l_opt_rec.attribute7,
        l_opt_rec.attribute8,
        l_opt_rec.attribute9,
        l_opt_rec.attribute10,
        l_opt_rec.attribute11,
        l_opt_rec.attribute12,
        l_opt_rec.attribute13,
        l_opt_rec.attribute14,
        l_opt_rec.attribute15,
        l_opt_rec.created_by,
        l_opt_rec.creation_date,
        l_opt_rec.last_updated_by,
        l_opt_rec.last_update_date,
        l_opt_rec.last_update_login);

Line: 1119


  END insert_row;

Line: 1123


  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_optv_rec                     IN optv_rec_type,
    x_optv_rec                     OUT NOCOPY optv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1133


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

Line: 1149


      l_optv_rec.LAST_UPDATE_DATE := l_optv_rec.CREATION_DATE;

Line: 1150


      l_optv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1151


      l_optv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1215


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_opt_rec,
      lx_opt_rec
    );

Line: 1263


  END insert_row;

Line: 1267


  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_optv_tbl                     IN optv_tbl_type,
    x_optv_tbl                     OUT NOCOPY optv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1277


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

Line: 1287


        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_optv_rec                     => p_optv_tbl(i),
          x_optv_rec                     => x_optv_tbl(i));

Line: 1338


  END insert_row;

Line: 1356


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_OPTIONS
     WHERE ID = p_opt_rec.id
       AND OBJECT_VERSION_NUMBER = p_opt_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1363


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_OPTIONS
    WHERE ID = p_opt_rec.id;

Line: 1404


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1413


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1609


  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_opt_rec                      IN opt_rec_type,
    x_opt_rec                      OUT NOCOPY opt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1618


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

Line: 1736


      IF (x_opt_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_opt_rec.last_updated_by := l_opt_rec.last_updated_by;

Line: 1740


      IF (x_opt_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_opt_rec.last_update_date := l_opt_rec.last_update_date;

Line: 1744


      IF (x_opt_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_opt_rec.last_update_login := l_opt_rec.last_update_login;

Line: 1788


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

Line: 1850


  END update_row;

Line: 1854


  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_optv_rec                     IN optv_rec_type,
    x_optv_rec                     OUT NOCOPY optv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1864


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

Line: 1878


      l_optv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1879


      l_optv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1880


      l_optv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1996


      IF (x_optv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_optv_rec.last_updated_by := l_optv_rec.last_updated_by;

Line: 2000


      IF (x_optv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_optv_rec.last_update_date := l_optv_rec.last_update_date;

Line: 2004


      IF (x_optv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_optv_rec.last_update_login := l_optv_rec.last_update_login;

Line: 2075


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_opt_rec,
      lx_opt_rec
    );

Line: 2122


  END update_row;

Line: 2126


  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_optv_tbl                     IN optv_tbl_type,
    x_optv_tbl                     OUT NOCOPY optv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2136


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

Line: 2146


        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_optv_rec                     => p_optv_tbl(i),
          x_optv_rec                     => x_optv_tbl(i));

Line: 2197


  END update_row;

Line: 2205


  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_opt_rec                      IN opt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2213


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

Line: 2227


    DELETE FROM OKL_OPTIONS
     WHERE ID = l_opt_rec.id;

Line: 2262


  END delete_row;

Line: 2266


  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_optv_rec                     IN optv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2275


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

Line: 2299


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

Line: 2343


  END delete_row;

Line: 2347


  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_optv_tbl                     IN optv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2356


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

Line: 2366


        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_optv_rec                     => p_optv_tbl(i));

Line: 2416


  END delete_row;