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

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

Line: 25


    SELECT '1'
    FROM OKL_AG_SOURCE_MAPS
    WHERE ae_line_type    = p_alsv_rec.ae_line_type
    AND   source = p_alsv_rec.source
    AND   ID <> p_alsv_rec.id;

Line: 97


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            AE_LINE_TYPE,
            SOURCE,
            PRIMARY_KEY_COLUMN,
            SELECT_COLUMN,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_AG_SOURCE_MAPS
     WHERE OKL_AG_SOURCE_MAPS.id  = p_id;

Line: 125


              l_ALS_rec.SELECT_COLUMN,
              l_ALS_rec.CREATED_BY,
              l_ALS_rec.CREATION_DATE,
              l_ALS_rec.LAST_UPDATED_BY,
              l_ALS_rec.LAST_UPDATE_DATE,
              l_ALS_rec.LAST_UPDATE_LOGIN;

Line: 151


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            AE_LINE_TYPE,
            SOURCE,
            PRIMARY_KEY_COLUMN,
            SELECT_COLUMN,
            ORG_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_AG_SOURCE_MAPS
     WHERE OKL_AG_SOURCE_MAPS.id = p_id;

Line: 178


              l_ALSv_rec.SELECT_COLUMN,
              l_ALSv_rec.ORG_ID,
              l_ALSv_rec.CREATED_BY,
              l_ALSv_rec.CREATION_DATE,
              l_ALSv_rec.LAST_UPDATED_BY,
              l_ALSv_rec.LAST_UPDATE_DATE,
              l_ALSv_rec.LAST_UPDATE_LOGIN;

Line: 218


    IF (l_ALSv_rec.SELECT_COLUMN = okl_api.G_MISS_CHAR) THEN
      l_ALSv_rec.SELECT_COLUMN := NULL;

Line: 230


    IF (l_ALSv_rec.last_updated_by = okl_api.G_MISS_NUM) THEN
      l_ALSv_rec.last_updated_by := NULL;

Line: 233


    IF (l_ALSv_rec.last_update_date = okl_api.G_MISS_DATE) THEN
      l_ALSv_rec.last_update_date := NULL;

Line: 236


    IF (l_ALSv_rec.last_update_login = okl_api.G_MISS_NUM) THEN
      l_ALSv_rec.last_update_login := NULL;

Line: 271


      IF p_alsv_rec.select_column = okl_api.G_MISS_CHAR OR
       p_alsv_rec.select_column IS NULL OR
       p_alsv_rec.select_column = 'NONE' THEN
        okl_api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Select Column');

Line: 360


    p_to.SELECT_COLUMN := p_from.SELECT_COLUMN;

Line: 363


    p_to.last_updated_by := p_from.last_updated_by;

Line: 364


    p_to.last_update_date := p_from.last_update_date;

Line: 365


    p_to.last_update_login := p_from.last_update_login;

Line: 378


    p_to.SELECT_COLUMN := p_from.SELECT_COLUMN;

Line: 381


    p_to.last_updated_by := p_from.last_updated_by;

Line: 382


    p_to.last_update_date := p_from.last_update_date;

Line: 383


    p_to.last_update_login := p_from.last_update_login;

Line: 543


  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_ALS_rec                      IN ALS_rec_type,
    x_ALS_rec                      OUT NOCOPY ALS_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 552


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

Line: 596


    INSERT INTO OKL_AG_SOURCE_MAPS(
        id,
        object_version_number,
        org_id,
        AE_LINE_TYPE,
        SOURCE,
        PRIMARY_KEY_COLUMN,
        SELECT_COLUMN,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_ALS_rec.id,
        l_ALS_rec.object_version_number,
        l_ALS_rec.org_id,
        l_ALS_rec.AE_LINE_TYPE,
        l_ALS_rec.SOURCE,
        l_ALS_rec.PRIMARY_KEY_COLUMN,
        l_ALS_rec.SELECT_COLUMN,
        l_ALS_rec.created_by,
        l_ALS_rec.creation_date,
        l_ALS_rec.last_updated_by,
        l_ALS_rec.last_update_date,
        l_ALS_rec.last_update_login);

Line: 656


  END insert_row;

Line: 660


  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_ALSv_rec                     IN ALSv_rec_type,
    x_ALSv_rec                     OUT NOCOPY ALSv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 670


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

Line: 686


      l_ALSv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 687


      l_ALSv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 688


      l_ALSv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 754


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ALS_rec,
      lx_ALS_rec
    );

Line: 802


  END insert_row;

Line: 806


  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_ALSv_tbl                     IN ALSv_tbl_type,
    x_ALSv_tbl                     OUT NOCOPY ALSv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 816


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

Line: 826


        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_ALSv_rec                     => p_ALSv_tbl(i),
          x_ALSv_rec                     => x_ALSv_tbl(i));

Line: 875


  END insert_row;

Line: 893


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_AG_SOURCE_MAPS
     WHERE ID = p_ALS_rec.id
       AND OBJECT_VERSION_NUMBER = p_ALS_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 900


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_AG_SOURCE_MAPS
    WHERE ID = p_ALS_rec.id;

Line: 941


      okl_api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 950


      okl_api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1144


  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_ALS_rec                      IN ALS_rec_type,
    x_ALS_rec                      OUT NOCOPY ALS_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1153


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

Line: 1199


      IF (x_ALS_rec.SELECT_COLUMN = okl_api.G_MISS_CHAR)
      THEN
        x_ALS_rec.SELECT_COLUMN := l_ALS_rec.SELECT_COLUMN;

Line: 1211


      IF (x_ALS_rec.last_updated_by = okl_api.G_MISS_NUM)
      THEN
        x_ALS_rec.last_updated_by := l_ALS_rec.last_updated_by;

Line: 1215


      IF (x_ALS_rec.last_update_date = okl_api.G_MISS_DATE)
      THEN
        x_ALS_rec.last_update_date := l_ALS_rec.last_update_date;

Line: 1219


      IF (x_ALS_rec.last_update_login = okl_api.G_MISS_NUM)
      THEN
        x_ALS_rec.last_update_login := l_ALS_rec.last_update_login;

Line: 1264


    UPDATE  OKL_AG_SOURCE_MAPS
    SET OBJECT_VERSION_NUMBER = l_def_ALS_rec.object_version_number,
        ORG_ID = l_def_ALS_rec.org_id,
        AE_LINE_TYPE = l_def_ALS_rec.AE_LINE_TYPE,
        SOURCE = l_def_ALS_rec.SOURCE,
        PRIMARY_KEY_COLUMN = l_def_ALS_rec.PRIMARY_KEY_COLUMN,
        SELECT_COLUMN = l_def_ALS_rec.SELECT_COLUMN,
        CREATED_BY = l_def_ALS_rec.created_by,
        CREATION_DATE = l_def_ALS_rec.creation_date,
        LAST_UPDATED_BY = l_def_ALS_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_ALS_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_ALS_rec.last_update_login
    WHERE ID = l_def_ALS_rec.id;

Line: 1311


  END update_row;

Line: 1315


  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_ALSv_rec                     IN ALSv_rec_type,
    x_ALSv_rec                     OUT NOCOPY ALSv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1325


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

Line: 1339


      l_ALSv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1340


      l_ALSv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1341


      l_ALSv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1381


      IF (x_ALSv_rec.SELECT_COLUMN = okl_api.G_MISS_CHAR)
      THEN
        x_ALSv_rec.SELECT_COLUMN := l_ALSv_rec.SELECT_COLUMN;

Line: 1397


      IF (x_ALSv_rec.last_updated_by = okl_api.G_MISS_NUM)
      THEN
        x_ALSv_rec.last_updated_by := l_ALSv_rec.last_updated_by;

Line: 1401


      IF (x_ALSv_rec.last_update_date = okl_api.G_MISS_DATE)
      THEN
        x_ALSv_rec.last_update_date := l_ALSv_rec.last_update_date;

Line: 1405


      IF (x_ALSv_rec.last_update_login = okl_api.G_MISS_NUM)
      THEN
        x_ALSv_rec.last_update_login := l_ALSv_rec.last_update_login;

Line: 1490


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ALS_rec,
      lx_ALS_rec
    );

Line: 1513


  END update_row;

Line: 1517


  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_ALSv_tbl                     IN ALSv_tbl_type,
    x_ALSv_tbl                     OUT NOCOPY ALSv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1527


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

Line: 1537


        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_ALSv_rec                     => p_ALSv_tbl(i),
          x_ALSv_rec                     => x_ALSv_tbl(i));

Line: 1586


  END update_row;

Line: 1594


  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_ALS_rec                      IN ALS_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1602


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

Line: 1616


    DELETE FROM OKL_AG_SOURCE_MAPS
     WHERE ID = l_ALS_rec.id;

Line: 1651


  END delete_row;

Line: 1655


  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_ALSv_rec                     IN ALSv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1664


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

Line: 1688


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

Line: 1732


  END delete_row;

Line: 1736


  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_ALSv_tbl                     IN ALSv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1745


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

Line: 1755


        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_ALSv_rec                     => p_ALSv_tbl(i));

Line: 1803


  END delete_row;