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

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

Line: 43


    SELECT
            ID,
            SEGMENT,
            SEGMENT_NUMBER,
            AGR_ID,
            SOURCE,
            OBJECT_VERSION_NUMBER,
            CONSTANTS,
            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_Acc_Gen_Rul_Lns
     WHERE okl_acc_gen_rul_lns.id = p_id;

Line: 106


              l_aul_rec.LAST_UPDATED_BY,
              l_aul_rec.LAST_UPDATE_DATE,
              l_aul_rec.LAST_UPDATE_LOGIN;

Line: 129


    SELECT
            ID,
            SEGMENT,
            SEGMENT_NUMBER,
            AGR_ID,
            SOURCE,
            OBJECT_VERSION_NUMBER,
            CONSTANTS,
            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_Acc_Gen_Rul_Lns_V
     WHERE okl_acc_gen_rul_lns_v.id = p_id;

Line: 192


              l_aulv_rec.LAST_UPDATED_BY,
              l_aulv_rec.LAST_UPDATE_DATE,
              l_aulv_rec.LAST_UPDATE_LOGIN;

Line: 288


    IF (l_aulv_rec.last_updated_by = okl_API.G_MISS_NUM) THEN
      l_aulv_rec.last_updated_by := NULL;

Line: 291


    IF (l_aulv_rec.last_update_date = okl_API.G_MISS_DATE) THEN
      l_aulv_rec.last_update_date := NULL;

Line: 294


    IF (l_aulv_rec.last_update_login = okl_API.G_MISS_NUM) THEN
      l_aulv_rec.last_update_login := NULL;

Line: 585


  SELECT '1'
  FROM okl_acc_gen_rules_v
  WHERE id = p_agr_id;

Line: 932


    p_to.last_updated_by := p_from.last_updated_by;

Line: 933


    p_to.last_update_date := p_from.last_update_date;

Line: 934


    p_to.last_update_login := p_from.last_update_login;

Line: 966


    p_to.last_updated_by := p_from.last_updated_by;

Line: 967


    p_to.last_update_date := p_from.last_update_date;

Line: 968


    p_to.last_update_login := p_from.last_update_login;

Line: 1131


  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_aul_rec                      IN aul_rec_type,
    x_aul_rec                      OUT NOCOPY aul_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1140


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

Line: 1176


    INSERT INTO OKL_ACC_GEN_RUL_LNS(
        id,
        SEGMENT,
        segment_number,
        agr_id,
        source,
        object_version_number,
        constants,
        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_aul_rec.id,
        l_aul_rec.SEGMENT,
        l_aul_rec.segment_number,
        l_aul_rec.agr_id,
        l_aul_rec.source,
        l_aul_rec.object_version_number,
        l_aul_rec.constants,
        l_aul_rec.attribute_category,
        l_aul_rec.attribute1,
        l_aul_rec.attribute2,
        l_aul_rec.attribute3,
        l_aul_rec.attribute4,
        l_aul_rec.attribute5,
        l_aul_rec.attribute6,
        l_aul_rec.attribute7,
        l_aul_rec.attribute8,
        l_aul_rec.attribute9,
        l_aul_rec.attribute10,
        l_aul_rec.attribute11,
        l_aul_rec.attribute12,
        l_aul_rec.attribute13,
        l_aul_rec.attribute14,
        l_aul_rec.attribute15,
        l_aul_rec.created_by,
        l_aul_rec.creation_date,
        l_aul_rec.last_updated_by,
        l_aul_rec.last_update_date,
        l_aul_rec.last_update_login);

Line: 1268


  END insert_row;

Line: 1272


  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_aulv_rec                     IN aulv_rec_type,
    x_aulv_rec                     OUT NOCOPY aulv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1282


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

Line: 1298


      l_aulv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1299


      l_aulv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1300


      l_aulv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1364


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aul_rec,
      lx_aul_rec
    );

Line: 1412


  END insert_row;

Line: 1416


  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_aulv_tbl                     IN aulv_tbl_type,
    x_aulv_tbl                     OUT NOCOPY aulv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1426


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

Line: 1436


        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_aulv_rec                     => p_aulv_tbl(i),
          x_aulv_rec                     => x_aulv_tbl(i));

Line: 1492


  END insert_row;

Line: 1510


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ACC_GEN_RUL_LNS
     WHERE ID = p_aul_rec.id
       AND OBJECT_VERSION_NUMBER = p_aul_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1517


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ACC_GEN_RUL_LNS
    WHERE ID = p_aul_rec.id;

Line: 1558


      okl_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1567


      okl_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1763


  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_aul_rec                      IN aul_rec_type,
    x_aul_rec                      OUT NOCOPY aul_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1772


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

Line: 1894


      IF (x_aul_rec.last_updated_by = okl_API.G_MISS_NUM)
      THEN
        x_aul_rec.last_updated_by := l_aul_rec.last_updated_by;

Line: 1898


      IF (x_aul_rec.last_update_date = okl_API.G_MISS_DATE)
      THEN
        x_aul_rec.last_update_date := l_aul_rec.last_update_date;

Line: 1902


      IF (x_aul_rec.last_update_login = okl_API.G_MISS_NUM)
      THEN
        x_aul_rec.last_update_login := l_aul_rec.last_update_login;

Line: 1947


    UPDATE  OKL_ACC_GEN_RUL_LNS
    SET SEGMENT = l_def_aul_rec.SEGMENT,
        SEGMENT_NUMBER = l_def_aul_rec.segment_number,
        AGR_ID = l_def_aul_rec.agr_id,
        SOURCE = l_def_aul_rec.source,
        OBJECT_VERSION_NUMBER = l_def_aul_rec.object_version_number,
        constants = l_def_aul_rec.constants,
        ATTRIBUTE_CATEGORY = l_def_aul_rec.attribute_category,
        ATTRIBUTE1 = l_def_aul_rec.attribute1,
        ATTRIBUTE2 = l_def_aul_rec.attribute2,
        ATTRIBUTE3 = l_def_aul_rec.attribute3,
        ATTRIBUTE4 = l_def_aul_rec.attribute4,
        ATTRIBUTE5 = l_def_aul_rec.attribute5,
        ATTRIBUTE6 = l_def_aul_rec.attribute6,
        ATTRIBUTE7 = l_def_aul_rec.attribute7,
        ATTRIBUTE8 = l_def_aul_rec.attribute8,
        ATTRIBUTE9 = l_def_aul_rec.attribute9,
        ATTRIBUTE10 = l_def_aul_rec.attribute10,
        ATTRIBUTE11 = l_def_aul_rec.attribute11,
        ATTRIBUTE12 = l_def_aul_rec.attribute12,
        ATTRIBUTE13 = l_def_aul_rec.attribute13,
        ATTRIBUTE14 = l_def_aul_rec.attribute14,
        ATTRIBUTE15 = l_def_aul_rec.attribute15,
        CREATED_BY = l_def_aul_rec.created_by,
        CREATION_DATE = l_def_aul_rec.creation_date,
        LAST_UPDATED_BY = l_def_aul_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_aul_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_aul_rec.last_update_login
    WHERE ID = l_def_aul_rec.id;

Line: 2010


  END update_row;

Line: 2014


  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_aulv_rec                     IN aulv_rec_type,
    x_aulv_rec                     OUT NOCOPY aulv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2024


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

Line: 2038


      l_aulv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2039


      l_aulv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2040


      l_aulv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2161


      IF (x_aulv_rec.last_updated_by = okl_API.G_MISS_NUM)
      THEN
        x_aulv_rec.last_updated_by := l_aulv_rec.last_updated_by;

Line: 2165


      IF (x_aulv_rec.last_update_date = okl_API.G_MISS_DATE)
      THEN
        x_aulv_rec.last_update_date := l_aulv_rec.last_update_date;

Line: 2169


      IF (x_aulv_rec.last_update_login = okl_API.G_MISS_NUM)
      THEN
        x_aulv_rec.last_update_login := l_aulv_rec.last_update_login;

Line: 2254


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aul_rec,
      lx_aul_rec
    );

Line: 2277


  END update_row;

Line: 2281


  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_aulv_tbl                     IN aulv_tbl_type,
    x_aulv_tbl                     OUT NOCOPY aulv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2291


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

Line: 2301


        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_aulv_rec                     => p_aulv_tbl(i),
          x_aulv_rec                     => x_aulv_tbl(i));

Line: 2355


  END update_row;

Line: 2363


  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_aul_rec                      IN aul_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2371


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

Line: 2385


    DELETE FROM OKL_ACC_GEN_RUL_LNS
     WHERE ID = l_aul_rec.id;

Line: 2420


  END delete_row;

Line: 2424


  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_aulv_rec                     IN aulv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2433


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

Line: 2457


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

Line: 2501


  END delete_row;

Line: 2505


  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_aulv_tbl                     IN aulv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2514


    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_aulv_rec                     => p_aulv_tbl(i));

Line: 2574


  END delete_row;