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

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

Line: 110


    SELECT
      id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,org_id
      ,name
      ,template_status
      ,credit_review_purpose
      ,cust_credit_classification
      ,industry_class
      ,industry_code
      ,valid_from
      ,valid_to
    INTO
      l_latv_rec.id
      ,l_latv_rec.object_version_number
      ,l_latv_rec.attribute_category
      ,l_latv_rec.attribute1
      ,l_latv_rec.attribute2
      ,l_latv_rec.attribute3
      ,l_latv_rec.attribute4
      ,l_latv_rec.attribute5
      ,l_latv_rec.attribute6
      ,l_latv_rec.attribute7
      ,l_latv_rec.attribute8
      ,l_latv_rec.attribute9
      ,l_latv_rec.attribute10
      ,l_latv_rec.attribute11
      ,l_latv_rec.attribute12
      ,l_latv_rec.attribute13
      ,l_latv_rec.attribute14
      ,l_latv_rec.attribute15
      ,l_latv_rec.org_id
      ,l_latv_rec.name
      ,l_latv_rec.template_status
      ,l_latv_rec.credit_review_purpose
      ,l_latv_rec.cust_credit_classification
      ,l_latv_rec.industry_class
      ,l_latv_rec.industry_code
      ,l_latv_rec.valid_from
      ,l_latv_rec.valid_to
    FROM OKL_LEASEAPP_TMPLS
    WHERE id = p_id;

Line: 352


      SELECT 'x'
      FROM Okl_Leaseapp_Templates LATV
      WHERE LATV.name  = p_latv_rec.name
        AND LATV.id <> nvl(p_latv_rec.id,-99999);

Line: 413


  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_lat_rec IN lat_rec_type) IS

    l_prog_name  VARCHAR2(61);

Line: 419


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

Line: 421


    INSERT INTO okl_leaseapp_templates (
      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
      ,org_id
      ,name
      ,template_status
      ,credit_review_purpose
      ,cust_credit_classification
      ,industry_class
      ,industry_code
      ,valid_from
      ,valid_to
      )
    VALUES
      (
       p_lat_rec.id
      ,p_lat_rec.object_version_number
      ,p_lat_rec.attribute_category
      ,p_lat_rec.attribute1
      ,p_lat_rec.attribute2
      ,p_lat_rec.attribute3
      ,p_lat_rec.attribute4
      ,p_lat_rec.attribute5
      ,p_lat_rec.attribute6
      ,p_lat_rec.attribute7
      ,p_lat_rec.attribute8
      ,p_lat_rec.attribute9
      ,p_lat_rec.attribute10
      ,p_lat_rec.attribute11
      ,p_lat_rec.attribute12
      ,p_lat_rec.attribute13
      ,p_lat_rec.attribute14
      ,p_lat_rec.attribute15
      ,G_USER_ID
      ,SYSDATE
      ,G_USER_ID
      ,SYSDATE
      ,G_LOGIN_ID
      ,p_lat_rec.org_id
      ,p_lat_rec.name
      ,p_lat_rec.template_status
      ,p_lat_rec.credit_review_purpose
      ,p_lat_rec.cust_credit_classification
      ,p_lat_rec.industry_class
      ,p_lat_rec.industry_code
      ,p_lat_rec.valid_from
      ,p_lat_rec.valid_to
    );

Line: 508


  END insert_row;

Line: 514


  PROCEDURE insert_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_latv_rec                     IN latv_rec_type,
    x_latv_rec                     OUT NOCOPY latv_rec_type) IS

    l_return_status                VARCHAR2(1);

Line: 528


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

Line: 532


    SELECT okl_lat_seq.nextval INTO l_latv_rec.ID FROM DUAL;

Line: 554


    insert_row (x_return_status => l_return_status, p_lat_rec => l_lat_rec);

Line: 588


  END insert_row;

Line: 593


  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_latv_rec                     IN latv_rec_type,
    x_latv_rec                     OUT NOCOPY latv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 608


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

Line: 614


    insert_row (x_return_status                => l_return_status,
                p_latv_rec                     => p_latv_rec,
                x_latv_rec                     => x_latv_rec);

Line: 649


  END insert_row;

Line: 654


  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_latv_tbl                     IN latv_tbl_type,
    x_latv_tbl                     OUT NOCOPY latv_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 670


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

Line: 681


          insert_row (x_return_status                => l_return_status,
                      p_latv_rec                     => p_latv_tbl(i),
                      x_latv_rec                     => x_latv_tbl(i));

Line: 729


  END insert_row;

Line: 741


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_LEASEAPP_TEMPLATES
     WHERE ID = p_lat_rec.id
       AND OBJECT_VERSION_NUMBER = p_lat_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 748


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_LEASEAPP_TEMPLATES
     WHERE ID = p_lat_rec.id;

Line: 834


  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_lat_rec IN lat_rec_type) IS

    l_return_status           VARCHAR2(1);

Line: 839


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

Line: 849


    UPDATE okl_leaseapp_templates
    SET
      object_version_number = p_lat_rec.object_version_number+1
      ,attribute_category = p_lat_rec.attribute_category
      ,attribute1 = p_lat_rec.attribute1
      ,attribute2 = p_lat_rec.attribute2
      ,attribute3 = p_lat_rec.attribute3
      ,attribute4 = p_lat_rec.attribute4
      ,attribute5 = p_lat_rec.attribute5
      ,attribute6 = p_lat_rec.attribute6
      ,attribute7 = p_lat_rec.attribute7
      ,attribute8 = p_lat_rec.attribute8
      ,attribute9 = p_lat_rec.attribute9
      ,attribute10 = p_lat_rec.attribute10
      ,attribute11 = p_lat_rec.attribute11
      ,attribute12 = p_lat_rec.attribute12
      ,attribute13 = p_lat_rec.attribute13
      ,attribute14 = p_lat_rec.attribute14
      ,attribute15 = p_lat_rec.attribute15
      ,org_id = p_lat_rec.org_id
      ,name = p_lat_rec.name
      ,template_status = p_lat_rec.template_status
      ,credit_review_purpose = p_lat_rec.credit_review_purpose
      ,cust_credit_classification = p_lat_rec.cust_credit_classification
      ,industry_class = p_lat_rec.industry_class
      ,industry_code = p_lat_rec.industry_code
      ,valid_from = p_lat_rec.valid_from
      ,valid_to = p_lat_rec.valid_to
    WHERE id = p_lat_rec.id;

Line: 901


  END update_row;

Line: 906


  PROCEDURE update_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_latv_rec                     IN latv_rec_type,
    x_latv_rec                     OUT NOCOPY latv_rec_type) IS

    l_prog_name                    VARCHAR2(61);

Line: 1043


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

Line: 1072


    update_row (x_return_status => l_return_status, p_lat_rec => l_lat_rec);

Line: 1106


  END update_row;

Line: 1111


  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_latv_rec                     IN latv_rec_type,
    x_latv_rec                     OUT NOCOPY latv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1126


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

Line: 1132


    update_row (x_return_status                => l_return_status,
                p_latv_rec                     => p_latv_rec,
                x_latv_rec                     => x_latv_rec);

Line: 1167


  END update_row;

Line: 1172


  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_latv_tbl                     IN latv_tbl_type,
    x_latv_tbl                     OUT NOCOPY latv_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 1187


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

Line: 1202


          update_row (x_return_status                => l_return_status,
                      p_latv_rec                     => p_latv_tbl(i),
                      x_latv_rec                     => x_latv_tbl(i));

Line: 1250


  END update_row;

Line: 1255


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

    l_prog_name                  VARCHAR2(61);

Line: 1263


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

Line: 1265


    DELETE FROM OKL_QUOTE_SUBPOOL_USAGE WHERE id = p_id;

Line: 1284


  END delete_row;

Line: 1289


  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_latv_rec                     IN latv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1303


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

Line: 1309


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

Line: 1343


  END delete_row;

Line: 1348


  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_latv_tbl                     IN latv_tbl_type) IS

    l_return_status                VARCHAR2(1);

Line: 1363


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

Line: 1377


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

Line: 1416


  END delete_row;