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

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

Line: 16


    SELECT  '1'
    FROM OKL_AE_TEMPLATES
    WHERE id = v_avl_id;

Line: 440


    SELECT
            ID,
            SEQUENCE_NUMBER,
            AVL_ID,
            CODE_COMBINATION_ID,
            AE_LINE_TYPE,
            CRD_CODE,
            ACCOUNT_BUILDER_YN,
            OBJECT_VERSION_NUMBER,
            DESCRIPTION,
            PERCENTAGE,
            ORG_ID,
            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_Ae_Tmpt_Lnes
     WHERE okl_ae_tmpt_lnes.id  = p_id;

Line: 511


              l_atl_rec.LAST_UPDATED_BY,
              l_atl_rec.LAST_UPDATE_DATE,
              l_atl_rec.LAST_UPDATE_LOGIN;

Line: 534


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            AVL_ID,
            CRD_CODE,
            CODE_COMBINATION_ID,
            AE_LINE_TYPE,
            SEQUENCE_NUMBER,
            DESCRIPTION,
            PERCENTAGE,
            ACCOUNT_BUILDER_YN,
            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_AE_TMPT_LNES
     WHERE OKL_AE_TMPT_LNES.id = p_id;

Line: 605


              l_atlv_rec.LAST_UPDATED_BY,
              l_atlv_rec.LAST_UPDATE_DATE,
              l_atlv_rec.LAST_UPDATE_LOGIN;

Line: 713


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

Line: 716


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

Line: 719


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

Line: 919


    p_to.last_updated_by := p_from.last_updated_by;

Line: 920


    p_to.last_update_date := p_from.last_update_date;

Line: 921


    p_to.last_update_login := p_from.last_update_login;

Line: 957


    p_to.last_updated_by := p_from.last_updated_by;

Line: 958


    p_to.last_update_date := p_from.last_update_date;

Line: 959


    p_to.last_update_login := p_from.last_update_login;

Line: 1122


  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_atl_rec                      IN atl_rec_type,
    x_atl_rec                      OUT NOCOPY atl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1131


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

Line: 1177


    INSERT INTO OKL_AE_TMPT_LNES(
        id,
        sequence_number,
        avl_id,
        code_combination_id,
        ae_line_type,
        crd_code,
        account_builder_yn,
        object_version_number,
        description,
        percentage,
        org_id,
        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_atl_rec.id,
        l_atl_rec.sequence_number,
        l_atl_rec.avl_id,
        l_atl_rec.code_combination_id,
        l_atl_rec.ae_line_type,
        l_atl_rec.crd_code,
        l_atl_rec.account_builder_yn,
        l_atl_rec.object_version_number,
        l_atl_rec.description,
        l_atl_rec.percentage,
	  l_org_id,
        l_atl_rec.attribute_category,
        l_atl_rec.attribute1,
        l_atl_rec.attribute2,
        l_atl_rec.attribute3,
        l_atl_rec.attribute4,
        l_atl_rec.attribute5,
        l_atl_rec.attribute6,
        l_atl_rec.attribute7,
        l_atl_rec.attribute8,
        l_atl_rec.attribute9,
        l_atl_rec.attribute10,
        l_atl_rec.attribute11,
        l_atl_rec.attribute12,
        l_atl_rec.attribute13,
        l_atl_rec.attribute14,
        l_atl_rec.attribute15,
        l_atl_rec.created_by,
        l_atl_rec.creation_date,
        l_atl_rec.last_updated_by,
        l_atl_rec.last_update_date,
        l_atl_rec.last_update_login);

Line: 1277


  END insert_row;

Line: 1281


  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_atlv_rec                     IN atlv_rec_type,
    x_atlv_rec                     OUT NOCOPY atlv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1291


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

Line: 1307


      l_atlv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1308


      l_atlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1309


      l_atlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1323


      SELECT nvl(MAX(sequence_number),0)
      FROM OKL_AE_TMPT_LNES
      WHERE AVL_ID = v_avl_id;

Line: 1394


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_atl_rec,
      lx_atl_rec
    );

Line: 1442


  END insert_row;

Line: 1446


  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_atlv_tbl                     IN atlv_tbl_type,
    x_atlv_tbl                     OUT NOCOPY atlv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1456


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

Line: 1466


        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_atlv_rec                     => p_atlv_tbl(i),
          x_atlv_rec                     => x_atlv_tbl(i));

Line: 1517


  END insert_row;

Line: 1535


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_AE_TMPT_LNES
     WHERE ID = p_atl_rec.id
       AND OBJECT_VERSION_NUMBER = p_atl_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1542


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_AE_TMPT_LNES
    WHERE ID = p_atl_rec.id;

Line: 1583


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1592


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1786


  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_atl_rec                      IN atl_rec_type,
    x_atl_rec                      OUT NOCOPY atl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1795


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

Line: 1933


      IF (x_atl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_atl_rec.last_updated_by := l_atl_rec.last_updated_by;

Line: 1937


      IF (x_atl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_atl_rec.last_update_date := l_atl_rec.last_update_date;

Line: 1941


      IF (x_atl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_atl_rec.last_update_login := l_atl_rec.last_update_login;

Line: 1985


    UPDATE  OKL_AE_TMPT_LNES
    SET SEQUENCE_NUMBER = l_def_atl_rec.sequence_number,
        AVL_ID = l_def_atl_rec.avl_id,
        CODE_COMBINATION_ID = l_def_atl_rec.code_combination_id,
        AE_LINE_TYPE = l_def_atl_rec.ae_line_type,
        CRD_CODE = l_def_atl_rec.crd_code,
        ACCOUNT_BUILDER_YN = l_def_atl_rec.account_builder_yn,
        OBJECT_VERSION_NUMBER = l_def_atl_rec.object_version_number,
        DESCRIPTION = l_def_atl_rec.description,
        PERCENTAGE = l_def_atl_rec.percentage,
        ORG_ID = l_def_atl_rec.org_id,
        ATTRIBUTE_CATEGORY = l_def_atl_rec.attribute_category,
        ATTRIBUTE1 = l_def_atl_rec.attribute1,
        ATTRIBUTE2 = l_def_atl_rec.attribute2,
        ATTRIBUTE3 = l_def_atl_rec.attribute3,
        ATTRIBUTE4 = l_def_atl_rec.attribute4,
        ATTRIBUTE5 = l_def_atl_rec.attribute5,
        ATTRIBUTE6 = l_def_atl_rec.attribute6,
        ATTRIBUTE7 = l_def_atl_rec.attribute7,
        ATTRIBUTE8 = l_def_atl_rec.attribute8,
        ATTRIBUTE9 = l_def_atl_rec.attribute9,
        ATTRIBUTE10 = l_def_atl_rec.attribute10,
        ATTRIBUTE11 = l_def_atl_rec.attribute11,
        ATTRIBUTE12 = l_def_atl_rec.attribute12,
        ATTRIBUTE13 = l_def_atl_rec.attribute13,
        ATTRIBUTE14 = l_def_atl_rec.attribute14,
        ATTRIBUTE15 = l_def_atl_rec.attribute15,
        CREATED_BY = l_def_atl_rec.created_by,
        CREATION_DATE = l_def_atl_rec.creation_date,
        LAST_UPDATED_BY = l_def_atl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_atl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_atl_rec.last_update_login
    WHERE ID = l_def_atl_rec.id;

Line: 2052


  END update_row;

Line: 2056


  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_atlv_rec                     IN atlv_rec_type,
    x_atlv_rec                     OUT NOCOPY atlv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2066


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

Line: 2080


      l_atlv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2081


      l_atlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2082


      l_atlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2218


      IF (x_atlv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_atlv_rec.last_updated_by := l_atlv_rec.last_updated_by;

Line: 2222


      IF (x_atlv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_atlv_rec.last_update_date := l_atlv_rec.last_update_date;

Line: 2226


      IF (x_atlv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_atlv_rec.last_update_login := l_atlv_rec.last_update_login;

Line: 2296


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_atl_rec,
      lx_atl_rec
    );

Line: 2343


  END update_row;

Line: 2347


  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_atlv_tbl                     IN atlv_tbl_type,
    x_atlv_tbl                     OUT NOCOPY atlv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2357


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

Line: 2367


        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_atlv_rec                     => p_atlv_tbl(i),
          x_atlv_rec                     => x_atlv_tbl(i));

Line: 2416


  END update_row;

Line: 2424


  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_atl_rec                      IN atl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2432


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

Line: 2446


    DELETE FROM OKL_AE_TMPT_LNES
     WHERE ID = l_atl_rec.id;

Line: 2481


  END delete_row;

Line: 2485


  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_atlv_rec                     IN atlv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2494


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

Line: 2518


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

Line: 2562


  END delete_row;

Line: 2566


  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_atlv_tbl                     IN atlv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2575


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

Line: 2585


        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_atlv_rec                     => p_atlv_tbl(i));

Line: 2633


  END delete_row;