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_CDJ_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_COST_ADJUSTMENTS_B B WHERE B.ID =T.ID);

Line: 14


    UPDATE OKL_COST_ADJUSTMENTS_TL T
    SET (SHORT_DESCRIPTION,
        DESCRIPTION,
        COMMENTS) =
                     (SELECT
                      B.SHORT_DESCRIPTION,
                      B.DESCRIPTION,
                      B.COMMENTS
                      FROM
                      OKL_COST_ADJUSTMENTS_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_COST_ADJUSTMENTS_TL SUBB,
                                 OKL_COST_ADJUSTMENTS_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_COST_ADJUSTMENTS_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_COST_ADJUSTMENTS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS (
                    SELECT NULL
                      FROM OKL_COST_ADJUSTMENTS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 208


    SELECT
      id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,parent_object_code
      ,parent_object_id
      ,adjustment_source_type
      ,adjustment_source_id
      ,basis
      ,value
      ,processing_type
      ,supplier_id
      ,default_subsidy_amount
      ,short_description
      ,description
      ,comments
      ,percent_basis_value
      --Bug # 5142940 ssdeshpa start
      ,stream_type_id
      --Bug # 5142940 ssdeshpa end;

Line: 505


  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_cdj_rec IN cdj_rec_type) IS

    l_prog_name  VARCHAR2(61);

Line: 511


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

Line: 513


    INSERT INTO okl_cost_adjustments_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
      ,parent_object_code
      ,parent_object_id
      ,adjustment_source_type
      ,adjustment_source_id
      ,basis
      ,value
      ,processing_type
      ,supplier_id
      ,default_subsidy_amount
      ,percent_basis_value
      --Bug # 5142940 ssdeshpa start
      ,stream_type_id
      --Bug # 5142940 ssdeshpa start
      )
    VALUES
      (
       p_cdj_rec.id
      ,p_cdj_rec.object_version_number
      ,p_cdj_rec.attribute_category
      ,p_cdj_rec.attribute1
      ,p_cdj_rec.attribute2
      ,p_cdj_rec.attribute3
      ,p_cdj_rec.attribute4
      ,p_cdj_rec.attribute5
      ,p_cdj_rec.attribute6
      ,p_cdj_rec.attribute7
      ,p_cdj_rec.attribute8
      ,p_cdj_rec.attribute9
      ,p_cdj_rec.attribute10
      ,p_cdj_rec.attribute11
      ,p_cdj_rec.attribute12
      ,p_cdj_rec.attribute13
      ,p_cdj_rec.attribute14
      ,p_cdj_rec.attribute15
      ,G_USER_ID
      ,SYSDATE
      ,G_USER_ID
      ,SYSDATE
      ,G_LOGIN_ID
      ,p_cdj_rec.parent_object_code
      ,p_cdj_rec.parent_object_id
      ,p_cdj_rec.adjustment_source_type
      ,p_cdj_rec.adjustment_source_id
      ,p_cdj_rec.basis
      ,p_cdj_rec.value
      ,p_cdj_rec.processing_type
      ,p_cdj_rec.supplier_id
      ,p_cdj_rec.default_subsidy_amount
      ,p_cdj_rec.percent_basis_value
      --Bug # 5142940 ssdeshpa start
      ,p_cdj_rec.stream_type_id
      --Bug # 5142940 ssdeshpa start
    );

Line: 608


  END insert_row;

Line: 614


  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_cdjtl_rec IN cdjtl_rec_type) IS

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

Line: 627


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

Line: 637


      INSERT INTO OKL_COST_ADJUSTMENTS_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_cdjtl_rec.id
       ,l_lang_rec.language_code
       ,USERENV('LANG')
       ,l_sfwt_flag
       ,G_USER_ID
       ,SYSDATE
       ,G_USER_ID
       ,SYSDATE
       ,G_LOGIN_ID
       ,p_cdjtl_rec.short_description
       ,p_cdjtl_rec.description
       ,p_cdjtl_rec.comments);

Line: 683


  END insert_row;

Line: 689


  PROCEDURE insert_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_cdjv_rec                     IN cdjv_rec_type,
    x_cdjv_rec                     OUT NOCOPY cdjv_rec_type) IS

    l_return_status                VARCHAR2(1);

Line: 704


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

Line: 708


    SELECT okl_cdj_seq.nextval INTO l_cdjv_rec.ID FROM DUAL;

Line: 731


    insert_row (x_return_status => l_return_status, p_cdj_rec => l_cdj_rec);

Line: 739


    insert_row (x_return_status => l_return_status, p_cdjtl_rec => l_cdjtl_rec);

Line: 773


  END insert_row;

Line: 779


  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_cdjv_rec                     IN cdjv_rec_type,
    x_cdjv_rec                     OUT NOCOPY cdjv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 794


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

Line: 800


    insert_row (x_return_status                => l_return_status,
                p_cdjv_rec                     => p_cdjv_rec,
                x_cdjv_rec                     => x_cdjv_rec);

Line: 835


  END insert_row;

Line: 841


  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_cdjv_tbl                     IN cdjv_tbl_type,
    x_cdjv_tbl                     OUT NOCOPY cdjv_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 857


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

Line: 868


          insert_row (x_return_status                => l_return_status,
                      p_cdjv_rec                     => p_cdjv_tbl(i),
                      x_cdjv_rec                     => x_cdjv_tbl(i));

Line: 916


  END insert_row;

Line: 929


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_COST_ADJUSTMENTS_B
     WHERE ID = p_cdj_rec.id
       AND OBJECT_VERSION_NUMBER = p_cdj_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 936


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_COST_ADJUSTMENTS_B
     WHERE ID = p_cdj_rec.id;

Line: 1023


  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_cdj_rec IN cdj_rec_type) IS

    l_return_status           VARCHAR2(1);

Line: 1031


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

Line: 1041


    UPDATE okl_cost_adjustments_b
    SET
      object_version_number = p_cdj_rec.object_version_number+1
      ,attribute_category = p_cdj_rec.attribute_category
      ,attribute1 = p_cdj_rec.attribute1
      ,attribute2 = p_cdj_rec.attribute2
      ,attribute3 = p_cdj_rec.attribute3
      ,attribute4 = p_cdj_rec.attribute4
      ,attribute5 = p_cdj_rec.attribute5
      ,attribute6 = p_cdj_rec.attribute6
      ,attribute7 = p_cdj_rec.attribute7
      ,attribute8 = p_cdj_rec.attribute8
      ,attribute9 = p_cdj_rec.attribute9
      ,attribute10 = p_cdj_rec.attribute10
      ,attribute11 = p_cdj_rec.attribute11
      ,attribute12 = p_cdj_rec.attribute12
      ,attribute13 = p_cdj_rec.attribute13
      ,attribute14 = p_cdj_rec.attribute14
      ,attribute15 = p_cdj_rec.attribute15
      ,parent_object_code = p_cdj_rec.parent_object_code
      ,parent_object_id = p_cdj_rec.parent_object_id
      ,adjustment_source_type = p_cdj_rec.adjustment_source_type
      ,adjustment_source_id = p_cdj_rec.adjustment_source_id
      ,basis = p_cdj_rec.basis
      ,value = p_cdj_rec.value
      ,processing_type = p_cdj_rec.processing_type
      ,supplier_id = p_cdj_rec.supplier_id
      ,default_subsidy_amount = p_cdj_rec.default_subsidy_amount
      ,percent_basis_value = p_cdj_rec.percent_basis_value
      --Bug # 5142940 ssdeshpa start
      ,stream_type_id = p_cdj_rec.stream_type_id
      --Bug # 5142940 ssdeshpa start

    WHERE id = p_cdj_rec.id;

Line: 1098


  END update_row;

Line: 1104


  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_cdjtl_rec IN cdjtl_rec_type) IS

    l_prog_name               VARCHAR2(61);

Line: 1110


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

Line: 1112


    UPDATE OKL_COST_ADJUSTMENTS_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_cdjtl_rec.short_description
      ,description = p_cdjtl_rec.description
      ,comments = p_cdjtl_rec.comments
    WHERE ID = p_cdjtl_rec.id;

Line: 1124


    UPDATE OKL_COST_ADJUSTMENTS_TL
    SET SFWT_FLAG = 'N'
    WHERE ID = p_cdjtl_rec.id
    AND SOURCE_LANG = LANGUAGE;

Line: 1146


  END update_row;

Line: 1152


  PROCEDURE update_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_cdjv_rec                     IN cdjv_rec_type,
    x_cdjv_rec                     OUT NOCOPY cdjv_rec_type) IS

    l_prog_name                    VARCHAR2(61);

Line: 1308


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

Line: 1337


    update_row (x_return_status => l_return_status, p_cdj_rec => l_cdj_rec);

Line: 1345


    update_row (x_return_status => l_return_status, p_cdjtl_rec => l_cdjtl_rec);

Line: 1379


  END update_row;

Line: 1385


  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_cdjv_rec                     IN cdjv_rec_type,
    x_cdjv_rec                     OUT NOCOPY cdjv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1400


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

Line: 1406


    update_row (x_return_status                => l_return_status,
                p_cdjv_rec                     => p_cdjv_rec,
                x_cdjv_rec                     => x_cdjv_rec);

Line: 1441


  END update_row;

Line: 1447


  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_cdjv_tbl                     IN cdjv_tbl_type,
    x_cdjv_tbl                     OUT NOCOPY cdjv_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 1462


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

Line: 1477


          update_row (x_return_status                => l_return_status,
                      p_cdjv_rec                     => p_cdjv_tbl(i),
                      x_cdjv_rec                     => x_cdjv_tbl(i));

Line: 1525


  END update_row;

Line: 1531


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

    l_prog_name                  VARCHAR2(61);

Line: 1539


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

Line: 1541


    DELETE FROM OKL_COST_ADJUSTMENTS_B WHERE id = p_id;

Line: 1542


    DELETE FROM OKL_COST_ADJUSTMENTS_TL WHERE id = p_id;

Line: 1561


  END delete_row;

Line: 1567


  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_cdjv_rec                     IN cdjv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1581


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

Line: 1587


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

Line: 1621


  END delete_row;

Line: 1627


  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_cdjv_tbl                     IN cdjv_tbl_type) IS

    l_return_status                VARCHAR2(1);

Line: 1642


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

Line: 1656


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

Line: 1695


  END delete_row;