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.

[Home] [Help]

APPS.OKL_CRT_PVT SQL Statements

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

Line: 101


    SELECT
            CURE_REPORT_ID,
            REPORT_NUMBER,
            REPORT_TYPE,
            REPORT_DATE,
            VENDOR_ID,
            VENDOR_SITE_ID,
            VENDOR_CONTACT_ID,
            APPROVAL_STATUS,
            APPROVAL_REASON,
            EXPIRATION_DATE,
            CURRENCY_CODE,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            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_CURE_REPORTS
     WHERE OKL_CURE_REPORTS.cure_report_id = p_cure_report_id;

Line: 165


              l_crtv_rec.program_update_date,
              l_crtv_rec.attribute_category,
              l_crtv_rec.attribute1,
              l_crtv_rec.attribute2,
              l_crtv_rec.attribute3,
              l_crtv_rec.attribute4,
              l_crtv_rec.attribute5,
              l_crtv_rec.attribute6,
              l_crtv_rec.attribute7,
              l_crtv_rec.attribute8,
              l_crtv_rec.attribute9,
              l_crtv_rec.attribute10,
              l_crtv_rec.attribute11,
              l_crtv_rec.attribute12,
              l_crtv_rec.attribute13,
              l_crtv_rec.attribute14,
              l_crtv_rec.attribute15,
              l_crtv_rec.created_by,
              l_crtv_rec.creation_date,
              l_crtv_rec.last_updated_by,
              l_crtv_rec.last_update_date,
              l_crtv_rec.last_update_login;

Line: 228


    SELECT
            CURE_REPORT_ID,
            REPORT_NUMBER,
            REPORT_TYPE,
            REPORT_DATE,
            VENDOR_ID,
            VENDOR_SITE_ID,
            VENDOR_CONTACT_ID,
            APPROVAL_STATUS,
            APPROVAL_REASON,
            EXPIRATION_DATE,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            CURRENCY_CODE,
            PROGRAM_UPDATE_DATE,
            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_Cure_Reports
     WHERE okl_cure_reports.cure_report_id = p_cure_report_id;

Line: 292


              l_crt_rec.program_update_date,
              l_crt_rec.attribute_category,
              l_crt_rec.attribute1,
              l_crt_rec.attribute2,
              l_crt_rec.attribute3,
              l_crt_rec.attribute4,
              l_crt_rec.attribute5,
              l_crt_rec.attribute6,
              l_crt_rec.attribute7,
              l_crt_rec.attribute8,
              l_crt_rec.attribute9,
              l_crt_rec.attribute10,
              l_crt_rec.attribute11,
              l_crt_rec.attribute12,
              l_crt_rec.attribute13,
              l_crt_rec.attribute14,
              l_crt_rec.attribute15,
              l_crt_rec.created_by,
              l_crt_rec.creation_date,
              l_crt_rec.last_updated_by,
              l_crt_rec.last_update_date,
              l_crt_rec.last_update_login;

Line: 403


    IF (l_crtv_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
      l_crtv_rec.program_update_date := NULL;

Line: 460


    IF (l_crtv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_crtv_rec.last_updated_by := NULL;

Line: 463


    IF (l_crtv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_crtv_rec.last_update_date := NULL;

Line: 466


    IF (l_crtv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_crtv_rec.last_update_login := NULL;

Line: 505


    select count(*)
    from okl_cure_reports
    where upper(report_number)  = upper(p_crtv_rec.report_number);

Line: 880


    p_to.program_update_date := p_from.program_update_date;

Line: 899


    p_to.last_updated_by := p_from.last_updated_by;

Line: 900


    p_to.last_update_date := p_from.last_update_date;

Line: 901


    p_to.last_update_login := p_from.last_update_login;

Line: 924


    p_to.program_update_date := p_from.program_update_date;

Line: 943


    p_to.last_updated_by := p_from.last_updated_by;

Line: 944


    p_to.last_update_date := p_from.last_update_date;

Line: 945


    p_to.last_update_login := p_from.last_update_login;

Line: 1191


  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_crt_rec                      IN crt_rec_type,
    x_crt_rec                      OUT NOCOPY crt_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1200


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

Line: 1237


    INSERT INTO OKL_CURE_REPORTS(
      cure_report_id,
      report_number,
      report_type,
      report_date,
      vendor_id,
      vendor_site_id,
      vendor_contact_id,
      approval_status,
      approval_reason,
      expiration_date,
      object_version_number,
      org_id,
      request_id,
      program_application_id,
      program_id,
      currency_code,
      program_update_date,
      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_crt_rec.cure_report_id,
      l_crt_rec.report_number,
      l_crt_rec.report_type,
      --l_crt_rec.report_date,
      SYSDATE,
      l_crt_rec.vendor_id,
      l_crt_rec.vendor_site_id,
      l_crt_rec.vendor_contact_id,
      l_crt_rec.approval_status,
      l_crt_rec.approval_reason,
      l_crt_rec.expiration_date,
      l_crt_rec.object_version_number,
      l_crt_rec.org_id,
      l_crt_rec.request_id,
      l_crt_rec.program_application_id,
      l_crt_rec.program_id,
      l_crt_rec.currency_code,
      l_crt_rec.program_update_date,
      l_crt_rec.attribute_category,
      l_crt_rec.attribute1,
      l_crt_rec.attribute2,
      l_crt_rec.attribute3,
      l_crt_rec.attribute4,
      l_crt_rec.attribute5,
      l_crt_rec.attribute6,
      l_crt_rec.attribute7,
      l_crt_rec.attribute8,
      l_crt_rec.attribute9,
      l_crt_rec.attribute10,
      l_crt_rec.attribute11,
      l_crt_rec.attribute12,
      l_crt_rec.attribute13,
      l_crt_rec.attribute14,
      l_crt_rec.attribute15,
      l_crt_rec.created_by,
      l_crt_rec.creation_date,
      l_crt_rec.last_updated_by,
      l_crt_rec.last_update_date,
      l_crt_rec.last_update_login);

Line: 1351


  END insert_row;

Line: 1355


  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_crtv_rec                     IN crtv_rec_type,
    x_crtv_rec                     OUT NOCOPY crtv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1365


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

Line: 1381


      l_crtv_rec.LAST_UPDATE_DATE := l_crtv_rec.CREATION_DATE;

Line: 1382


      l_crtv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1383


      l_crtv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1451


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_crt_rec,
      lx_crt_rec
    );

Line: 1500


  END insert_row;

Line: 1504


  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_crtv_tbl                     IN crtv_tbl_type,
    x_crtv_tbl                     OUT NOCOPY crtv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1515


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

Line: 1529


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_crtv_rec                     => p_crtv_tbl(i),
            x_crtv_rec                     => x_crtv_tbl(i));

Line: 1597


  END insert_row;

Line: 1602


  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_crtv_tbl                     IN crtv_tbl_type,
    x_crtv_tbl                     OUT NOCOPY crtv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1612


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

Line: 1619


      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_crtv_tbl                     => p_crtv_tbl,
        x_crtv_tbl                     => x_crtv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1661


  END insert_row;

Line: 1679


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CURE_REPORTS
     WHERE CURE_REPORT_ID = p_crt_rec.cure_report_id
       AND OBJECT_VERSION_NUMBER = p_crt_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1686


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CURE_REPORTS
     WHERE CURE_REPORT_ID = p_crt_rec.cure_report_id;

Line: 1727


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1736


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2016


  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_crt_rec                      IN crt_rec_type,
    x_crt_rec                      OUT NOCOPY crt_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2025


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

Line: 2109


        IF (x_crt_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_crt_rec.program_update_date := l_crt_rec.program_update_date;

Line: 2185


        IF (x_crt_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_crt_rec.last_updated_by := l_crt_rec.last_updated_by;

Line: 2189


        IF (x_crt_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_crt_rec.last_update_date := l_crt_rec.last_update_date;

Line: 2193


        IF (x_crt_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_crt_rec.last_update_login := l_crt_rec.last_update_login;

Line: 2239


    UPDATE OKL_CURE_REPORTS
    SET REPORT_NUMBER = l_def_crt_rec.report_number,
        REPORT_TYPE = l_def_crt_rec.report_type,
        REPORT_DATE = l_def_crt_rec.report_date,
        VENDOR_ID = l_def_crt_rec.vendor_id,
        VENDOR_SITE_ID = l_def_crt_rec.vendor_site_id,
        VENDOR_CONTACT_ID = l_def_crt_rec.vendor_contact_id,
        APPROVAL_STATUS = l_def_crt_rec.approval_status,
        APPROVAL_REASON = l_def_crt_rec.approval_reason,
        EXPIRATION_DATE = l_def_crt_rec.expiration_date,
        OBJECT_VERSION_NUMBER = l_def_crt_rec.object_version_number,
        ORG_ID = l_def_crt_rec.org_id,
        REQUEST_ID = l_def_crt_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_crt_rec.program_application_id,
        PROGRAM_ID = l_def_crt_rec.program_id,
        CURRENCY_CODE = l_def_crt_rec.currency_code,
        PROGRAM_UPDATE_DATE = l_def_crt_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_crt_rec.attribute_category,
        ATTRIBUTE1 = l_def_crt_rec.attribute1,
        ATTRIBUTE2 = l_def_crt_rec.attribute2,
        ATTRIBUTE3 = l_def_crt_rec.attribute3,
        ATTRIBUTE4 = l_def_crt_rec.attribute4,
        ATTRIBUTE5 = l_def_crt_rec.attribute5,
        ATTRIBUTE6 = l_def_crt_rec.attribute6,
        ATTRIBUTE7 = l_def_crt_rec.attribute7,
        ATTRIBUTE8 = l_def_crt_rec.attribute8,
        ATTRIBUTE9 = l_def_crt_rec.attribute9,
        ATTRIBUTE10 = l_def_crt_rec.attribute10,
        ATTRIBUTE11 = l_def_crt_rec.attribute11,
        ATTRIBUTE12 = l_def_crt_rec.attribute12,
        ATTRIBUTE13 = l_def_crt_rec.attribute13,
        ATTRIBUTE14 = l_def_crt_rec.attribute14,
        ATTRIBUTE15 = l_def_crt_rec.attribute15,
        CREATED_BY = l_def_crt_rec.created_by,
        CREATION_DATE = l_def_crt_rec.creation_date,
        LAST_UPDATED_BY = l_def_crt_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_crt_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_crt_rec.last_update_login
    WHERE CURE_REPORT_ID = l_def_crt_rec.cure_report_id;

Line: 2313


  END update_row;

Line: 2317


  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_crtv_rec                     IN crtv_rec_type,
    x_crtv_rec                     OUT NOCOPY crtv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2327


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

Line: 2342


      l_crtv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2343


      l_crtv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2344


      l_crtv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2423


        IF (x_crtv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_crtv_rec.program_update_date := l_db_crtv_rec.program_update_date;

Line: 2499


        IF (x_crtv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_crtv_rec.last_updated_by := l_db_crtv_rec.last_updated_by;

Line: 2503


        IF (x_crtv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_crtv_rec.last_update_date := l_db_crtv_rec.last_update_date;

Line: 2507


        IF (x_crtv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_crtv_rec.last_update_login := l_db_crtv_rec.last_update_login;

Line: 2592


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_crt_rec,
      lx_crt_rec
    );

Line: 2640


  END update_row;

Line: 2644


  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_crtv_tbl                     IN crtv_tbl_type,
    x_crtv_tbl                     OUT NOCOPY crtv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2655


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

Line: 2669


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_crtv_rec                     => p_crtv_tbl(i),
            x_crtv_rec                     => x_crtv_tbl(i));

Line: 2737


  END update_row;

Line: 2742


  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_crtv_tbl                     IN crtv_tbl_type,
    x_crtv_tbl                     OUT NOCOPY crtv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2752


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

Line: 2759


      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_crtv_tbl                     => p_crtv_tbl,
        x_crtv_tbl                     => x_crtv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2801


  END update_row;

Line: 2809


  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_crt_rec                      IN crt_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2817


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

Line: 2832


    DELETE FROM OKL_CURE_REPORTS
     WHERE CURE_REPORT_ID = p_crt_rec.cure_report_id;

Line: 2868


  END delete_row;

Line: 2872


  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_crtv_rec                     IN crtv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2881


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

Line: 2905


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_crt_rec
    );

Line: 2950


  END delete_row;

Line: 2954


  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_crtv_tbl                     IN crtv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2964


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

Line: 2978


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_crtv_rec                     => p_crtv_tbl(i));

Line: 3045


  END delete_row;

Line: 3050


  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_crtv_tbl                     IN crtv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3059


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

Line: 3066


      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_crtv_tbl                     => p_crtv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3107


  END delete_row;