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

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

Line: 11


    DELETE FROM OKL_INSURANCE_ESTIMATES_TL T
    WHERE NOT EXISTS (SELECT NULL FROM OKL_LINE_RELATIONSHIPS_B B WHERE B.ID =T.ID);

Line: 14


    UPDATE OKL_LINE_RELATIONSHIPS_TL T
    SET (SHORT_DESCRIPTION,
        DESCRIPTION,
        COMMENTS) =
                     (SELECT
                      B.SHORT_DESCRIPTION,
                      B.DESCRIPTION,
                      B.COMMENTS
                      FROM
                      OKL_LINE_RELATIONSHIPS_TL B
                      WHERE
                      B.ID = T.ID
                      AND B.LANGUAGE = T.SOURCE_LANG)
    WHERE (T.ID, T.LANGUAGE) IN (SELECT
                                 SUBT.ID,
                                 SUBT.LANGUAGE
                                 FROM
                                 OKL_LINE_RELATIONSHIPS_TL SUBB,
                                 OKL_LINE_RELATIONSHIPS_TL SUBT
                                 WHERE
                                 SUBB.ID = SUBT.ID
                                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                                 AND (SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
                                      OR (SUBB.DESCRIPTION <> SUBT.DESCRIPTION)
                                      OR (SUBB.COMMENTS <> SUBT.COMMENTS)
                                      OR (SUBB.SHORT_DESCRIPTION IS NULL AND SUBT.SHORT_DESCRIPTION IS NOT NULL)
                                      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
                                      OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
                                     )
                                );

Line: 45


    INSERT INTO OKL_LINE_RELATIONSHIPS_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        SHORT_DESCRIPTION,
        DESCRIPTION,
        COMMENTS)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN,
            B.SHORT_DESCRIPTION,
            B.DESCRIPTION,
            B.COMMENTS
        FROM OKL_LINE_RELATIONSHIPS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS (
                    SELECT NULL
                      FROM OKL_LINE_RELATIONSHIPS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 193


    SELECT
      id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,source_line_type
      ,source_line_id
      ,related_line_type
      ,related_line_id
      ,amount
      ,short_description
      ,description
      ,comments
            --Added by jjuneja
      ,origination_income
      --end od addition by jjuneja

    INTO
      l_lrev_rec.id
      ,l_lrev_rec.object_version_number
      ,l_lrev_rec.attribute_category
      ,l_lrev_rec.attribute1
      ,l_lrev_rec.attribute2
      ,l_lrev_rec.attribute3
      ,l_lrev_rec.attribute4
      ,l_lrev_rec.attribute5
      ,l_lrev_rec.attribute6
      ,l_lrev_rec.attribute7
      ,l_lrev_rec.attribute8
      ,l_lrev_rec.attribute9
      ,l_lrev_rec.attribute10
      ,l_lrev_rec.attribute11
      ,l_lrev_rec.attribute12
      ,l_lrev_rec.attribute13
      ,l_lrev_rec.attribute14
      ,l_lrev_rec.attribute15
      ,l_lrev_rec.source_line_type
      ,l_lrev_rec.source_line_id
      ,l_lrev_rec.related_line_type
      ,l_lrev_rec.related_line_id
      ,l_lrev_rec.amount
      ,l_lrev_rec.short_description
      ,l_lrev_rec.description
      ,l_lrev_rec.comments
            --added by jjuneja
      ,l_lrev_rec.origination_income
      --end of addition by jjuneja

    FROM OKL_LINE_RELATIONSHIPS_V
    WHERE id = p_id;

Line: 511


  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_lre_rec IN lre_rec_type) IS

    l_prog_name  VARCHAR2(61);

Line: 517


    l_prog_name := G_PKG_NAME||'.insert_row (B)';

Line: 519


    INSERT INTO okl_LINE_RELATIONSHIPS_b (
      id
      ,object_version_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
      ,source_line_type
      ,source_line_id
      ,related_line_type
      ,related_line_id
      ,amount
            --Added by jjuneja
      ,origination_income
      --End of addition by jjuneja

      )
    VALUES
      (
       p_lre_rec.id
      ,p_lre_rec.object_version_number
      ,p_lre_rec.attribute_category
      ,p_lre_rec.attribute1
      ,p_lre_rec.attribute2
      ,p_lre_rec.attribute3
      ,p_lre_rec.attribute4
      ,p_lre_rec.attribute5
      ,p_lre_rec.attribute6
      ,p_lre_rec.attribute7
      ,p_lre_rec.attribute8
      ,p_lre_rec.attribute9
      ,p_lre_rec.attribute10
      ,p_lre_rec.attribute11
      ,p_lre_rec.attribute12
      ,p_lre_rec.attribute13
      ,p_lre_rec.attribute14
      ,p_lre_rec.attribute15
      ,G_USER_ID
      ,SYSDATE
      ,G_USER_ID
      ,SYSDATE
      ,G_LOGIN_ID
      ,p_lre_rec.source_line_type
      ,p_lre_rec.source_line_id
      ,p_lre_rec.related_line_type
      ,p_lre_rec.related_line_id
      ,p_lre_rec.amount
            --Added by jjuneja
      ,p_lre_rec.origination_income
      --Endof addition by jjuneja

    );

Line: 606


  END insert_row;

Line: 612


  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_lretl_rec IN lretl_rec_type) IS

    CURSOR get_languages IS
      SELECT language_code
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');

Line: 625


    l_prog_name := G_PKG_NAME||'.insert_row (TL)';

Line: 635


      INSERT INTO OKL_LINE_RELATIONSHIPS_TL (
        id
       ,language
       ,source_lang
       ,sfwt_flag
       ,created_by
       ,creation_date
       ,last_updated_by
       ,last_update_date
       ,last_update_login
       ,short_description
       ,description
       ,comments)
      VALUES (
        p_lretl_rec.id
       ,l_lang_rec.language_code
       ,USERENV('LANG')
       ,l_sfwt_flag
       ,G_USER_ID
       ,SYSDATE
       ,G_USER_ID
       ,SYSDATE
       ,G_LOGIN_ID
       ,p_lretl_rec.short_description
       ,p_lretl_rec.description
       ,p_lretl_rec.comments);

Line: 681


  END insert_row;

Line: 687


  PROCEDURE insert_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_lrev_rec                     IN lrev_rec_type,
    x_lrev_rec                     OUT NOCOPY lrev_rec_type) IS

    l_return_status                VARCHAR2(1);

Line: 702


    l_prog_name := G_PKG_NAME||'.insert_row (V)';

Line: 706


    SELECT okl_lre_seq.nextval INTO l_lrev_rec.ID FROM DUAL;

Line: 729


    insert_row (x_return_status => l_return_status, p_lre_rec => l_lre_rec);

Line: 737


    insert_row (x_return_status => l_return_status, p_lretl_rec => l_lretl_rec);

Line: 771


  END insert_row;

Line: 777


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lrev_rec                     IN lrev_rec_type,
    x_lrev_rec                     OUT NOCOPY lrev_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 792


    l_prog_name := G_PKG_NAME||'.insert_row (REC)';

Line: 798


    insert_row (x_return_status                => l_return_status,
                p_lrev_rec                     => p_lrev_rec,
                x_lrev_rec                     => x_lrev_rec);

Line: 833


  END insert_row;

Line: 839


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lrev_tbl                     IN lrev_tbl_type,
    x_lrev_tbl                     OUT NOCOPY lrev_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 855


    l_prog_name := G_PKG_NAME||'.insert_row (TBL)';

Line: 866


          insert_row (x_return_status                => l_return_status,
                      p_lrev_rec                     => p_lrev_tbl(i),
                      x_lrev_rec                     => x_lrev_tbl(i));

Line: 914


  END insert_row;

Line: 927


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_LINE_RELATIONSHIPS_B
     WHERE ID = p_lre_rec.id
       AND OBJECT_VERSION_NUMBER = p_lre_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 934


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_LINE_RELATIONSHIPS_B
     WHERE ID = p_lre_rec.id;

Line: 1021


  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_lre_rec IN lre_rec_type) IS

    l_return_status           VARCHAR2(1);

Line: 1029


    l_prog_name := G_PKG_NAME||'.update_row (B)';

Line: 1039


    UPDATE okl_LINE_RELATIONSHIPS_b
    SET
      object_version_number = p_lre_rec.object_version_number
      ,attribute_category = p_lre_rec.attribute_category
      ,attribute1 = p_lre_rec.attribute1
      ,attribute2 = p_lre_rec.attribute2
      ,attribute3 = p_lre_rec.attribute3
      ,attribute4 = p_lre_rec.attribute4
      ,attribute5 = p_lre_rec.attribute5
      ,attribute6 = p_lre_rec.attribute6
      ,attribute7 = p_lre_rec.attribute7
      ,attribute8 = p_lre_rec.attribute8
      ,attribute9 = p_lre_rec.attribute9
      ,attribute10 = p_lre_rec.attribute10
      ,attribute11 = p_lre_rec.attribute11
      ,attribute12 = p_lre_rec.attribute12
      ,attribute13 = p_lre_rec.attribute13
      ,attribute14 = p_lre_rec.attribute14
      ,attribute15 = p_lre_rec.attribute15
      ,source_line_type = p_lre_rec.source_line_type
      ,source_line_id = p_lre_rec.source_line_id
      ,related_line_type = p_lre_rec.related_line_type
      ,related_line_id = p_lre_rec.related_line_id
      ,amount = p_lre_rec.amount
            --added by jjuneja
      ,origination_income = p_lre_rec.origination_income
      --end of addition by jjuneja

    WHERE id = p_lre_rec.id;

Line: 1091


  END update_row;

Line: 1097


  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_lretl_rec IN lretl_rec_type) IS

    l_prog_name               VARCHAR2(61);

Line: 1103


    l_prog_name := G_PKG_NAME||'.update_row (TL)';

Line: 1105


    UPDATE OKL_LINE_RELATIONSHIPS_TL
    SET
      source_lang = USERENV('LANG')
      ,sfwt_flag = 'Y'
      ,last_updated_by = G_USER_ID
      ,last_update_date = SYSDATE
      ,last_update_login = G_LOGIN_ID
      ,short_description = p_lretl_rec.short_description
      ,description = p_lretl_rec.description
      ,comments = p_lretl_rec.comments
    WHERE ID = p_lretl_rec.id;

Line: 1117


    UPDATE OKL_LINE_RELATIONSHIPS_TL
    SET SFWT_FLAG = 'N'
    WHERE ID = p_lretl_rec.id
    AND SOURCE_LANG = LANGUAGE;

Line: 1139


  END update_row;

Line: 1145


  PROCEDURE update_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_lrev_rec                     IN lrev_rec_type,
    x_lrev_rec                     OUT NOCOPY lrev_rec_type) IS

    l_prog_name                    VARCHAR2(61);

Line: 1287


    l_prog_name := G_PKG_NAME||'.update_row (V)';

Line: 1316


    update_row (x_return_status => l_return_status, p_lre_rec => l_lre_rec);

Line: 1324


    update_row (x_return_status => l_return_status, p_lretl_rec => l_lretl_rec);

Line: 1358


  END update_row;

Line: 1364


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lrev_rec                     IN lrev_rec_type,
    x_lrev_rec                     OUT NOCOPY lrev_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1379


    l_prog_name := G_PKG_NAME||'.update_row (REC)';

Line: 1385


    update_row (x_return_status                => l_return_status,
                p_lrev_rec                     => p_lrev_rec,
                x_lrev_rec                     => x_lrev_rec);

Line: 1420


  END update_row;

Line: 1426


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lrev_tbl                     IN lrev_tbl_type,
    x_lrev_tbl                     OUT NOCOPY lrev_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 1441


    l_prog_name := G_PKG_NAME||'.update_row (TBL)';

Line: 1456


          update_row (x_return_status                => l_return_status,
                      p_lrev_rec                     => p_lrev_tbl(i),
                      x_lrev_rec                     => x_lrev_tbl(i));

Line: 1504


  END update_row;

Line: 1510


  PROCEDURE delete_row(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_id                           IN NUMBER) IS

    l_prog_name                  VARCHAR2(61);

Line: 1518


    l_prog_name := G_PKG_NAME||'.delete_row (V)';

Line: 1520


    DELETE FROM OKL_LINE_RELATIONSHIPS_B WHERE id = p_id;

Line: 1521


    DELETE FROM OKL_LINE_RELATIONSHIPS_TL WHERE id = p_id;

Line: 1540


  END delete_row;

Line: 1546


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lrev_rec                     IN lrev_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1560


    l_prog_name := G_PKG_NAME||'.delete_row (REC)';

Line: 1566


    delete_row (x_return_status                => l_return_status,
                p_id                           => p_lrev_rec.id);

Line: 1600


  END delete_row;

Line: 1606


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lrev_tbl                     IN lrev_tbl_type) IS

    l_return_status                VARCHAR2(1);

Line: 1621


    l_prog_name := G_PKG_NAME||'.delete_row (TBL)';

Line: 1635


          delete_row (x_return_status                => l_return_status,
                      p_id                           => p_lrev_tbl(i).id);

Line: 1674


  END delete_row;