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

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

Line: 101


    SELECT
            CURE_FUND_TRANS_ID,
            CURE_PAYMENT_ID,
            AMOUNT,
            FUND_TYPE,
            TRANS_TYPE,
            vendor_id,
            CURE_REFUND_LINE_ID,
            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_FUND_TRANS
     WHERE OKL_CURE_FUND_TRANS.cure_fund_trans_id = p_cure_fund_trans_id;

Line: 157


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

Line: 220


    SELECT
            CURE_FUND_TRANS_ID,
            CURE_PAYMENT_ID,
            AMOUNT,
            FUND_TYPE,
            TRANS_TYPE,
            vendor_id,
            CURE_REFUND_LINE_ID,
            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_Fund_Trans
     WHERE OKL_cure_fund_trans.cure_fund_trans_id = p_cure_fund_trans_id;

Line: 276


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

Line: 375


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

Line: 432


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

Line: 435


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

Line: 438


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

Line: 750


    p_to.program_update_date := p_from.program_update_date;

Line: 769


    p_to.last_updated_by := p_from.last_updated_by;

Line: 770


    p_to.last_update_date := p_from.last_update_date;

Line: 771


    p_to.last_update_login := p_from.last_update_login;

Line: 790


    p_to.program_update_date := p_from.program_update_date;

Line: 809


    p_to.last_updated_by := p_from.last_updated_by;

Line: 810


    p_to.last_update_date := p_from.last_update_date;

Line: 811


    p_to.last_update_login := p_from.last_update_login;

Line: 1057


  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_cft_rec                      IN cft_rec_type,
    x_cft_rec                      OUT NOCOPY cft_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1066


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

Line: 1102


    INSERT INTO OKL_CURE_FUND_TRANS(
      cure_fund_trans_id,
      cure_payment_id,
      amount,
      fund_type,
      trans_type,
      vendor_id,
      cure_refund_line_id,
      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)
    VALUES (
      l_cft_rec.cure_fund_trans_id,
      l_cft_rec.cure_payment_id,
      l_cft_rec.amount,
      l_cft_rec.fund_type,
      l_cft_rec.trans_type,
      l_cft_rec.vendor_id,
      l_cft_rec.cure_refund_line_id,
      l_cft_rec.object_version_number,
      l_cft_rec.org_id,
      l_cft_rec.request_id,
      l_cft_rec.program_application_id,
      l_cft_rec.program_id,
      l_cft_rec.program_update_date,
      l_cft_rec.attribute_category,
      l_cft_rec.attribute1,
      l_cft_rec.attribute2,
      l_cft_rec.attribute3,
      l_cft_rec.attribute4,
      l_cft_rec.attribute5,
      l_cft_rec.attribute6,
      l_cft_rec.attribute7,
      l_cft_rec.attribute8,
      l_cft_rec.attribute9,
      l_cft_rec.attribute10,
      l_cft_rec.attribute11,
      l_cft_rec.attribute12,
      l_cft_rec.attribute13,
      l_cft_rec.attribute14,
      l_cft_rec.attribute15,
      l_cft_rec.created_by,
      l_cft_rec.creation_date,
      l_cft_rec.last_updated_by,
      l_cft_rec.last_update_date,
      l_cft_rec.last_update_login);

Line: 1207


  END insert_row;

Line: 1211


  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_cftv_rec                     IN cftv_rec_type,
    x_cftv_rec                     OUT NOCOPY cftv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1221


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

Line: 1237


      l_cftv_rec.LAST_UPDATE_DATE := l_cftv_rec.CREATION_DATE;

Line: 1238


      l_cftv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1239


      l_cftv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1303


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cft_rec,
      lx_cft_rec
    );

Line: 1352


  END insert_row;

Line: 1356


  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_cftv_tbl                     IN cftv_tbl_type,
    x_cftv_tbl                     OUT NOCOPY cftv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1367


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

Line: 1381


          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_cftv_rec                     => p_cftv_tbl(i),
            x_cftv_rec                     => x_cftv_tbl(i));

Line: 1449


  END insert_row;

Line: 1454


  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_cftv_tbl                     IN cftv_tbl_type,
    x_cftv_tbl                     OUT NOCOPY cftv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1464


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

Line: 1471


      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_cftv_tbl                     => p_cftv_tbl,
        x_cftv_tbl                     => x_cftv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1513


  END insert_row;

Line: 1531


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CURE_FUND_TRANS
     WHERE CURE_FUND_TRANS_ID = p_cft_rec.cure_fund_trans_id
       AND OBJECT_VERSION_NUMBER = p_cft_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1538


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CURE_FUND_TRANS
     WHERE CURE_FUND_TRANS_ID = p_cft_rec.cure_fund_trans_id;

Line: 1579


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1588


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1868


  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_cft_rec                      IN cft_rec_type,
    x_cft_rec                      OUT NOCOPY cft_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1877


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

Line: 1945


        IF (x_cft_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cft_rec.program_update_date := l_cft_rec.program_update_date;

Line: 2021


        IF (x_cft_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cft_rec.last_updated_by := l_cft_rec.last_updated_by;

Line: 2025


        IF (x_cft_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cft_rec.last_update_date := l_cft_rec.last_update_date;

Line: 2029


        IF (x_cft_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cft_rec.last_update_login := l_cft_rec.last_update_login;

Line: 2075


    UPDATE OKL_CURE_FUND_TRANS
    SET CURE_PAYMENT_ID = l_def_cft_rec.cure_payment_id,
        AMOUNT = l_def_cft_rec.amount,
        FUND_TYPE = l_def_cft_rec.fund_type,
        TRANS_TYPE = l_def_cft_rec.trans_type,
        vendor_id = l_def_cft_rec.vendor_id,
        CURE_REFUND_LINE_ID = l_def_cft_rec.cure_refund_line_id,
        OBJECT_VERSION_NUMBER = l_def_cft_rec.object_version_number,
        ORG_ID = l_def_cft_rec.org_id,
        REQUEST_ID = l_def_cft_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_cft_rec.program_application_id,
        PROGRAM_ID = l_def_cft_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_cft_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_cft_rec.attribute_category,
        ATTRIBUTE1 = l_def_cft_rec.attribute1,
        ATTRIBUTE2 = l_def_cft_rec.attribute2,
        ATTRIBUTE3 = l_def_cft_rec.attribute3,
        ATTRIBUTE4 = l_def_cft_rec.attribute4,
        ATTRIBUTE5 = l_def_cft_rec.attribute5,
        ATTRIBUTE6 = l_def_cft_rec.attribute6,
        ATTRIBUTE7 = l_def_cft_rec.attribute7,
        ATTRIBUTE8 = l_def_cft_rec.attribute8,
        ATTRIBUTE9 = l_def_cft_rec.attribute9,
        ATTRIBUTE10 = l_def_cft_rec.attribute10,
        ATTRIBUTE11 = l_def_cft_rec.attribute11,
        ATTRIBUTE12 = l_def_cft_rec.attribute12,
        ATTRIBUTE13 = l_def_cft_rec.attribute13,
        ATTRIBUTE14 = l_def_cft_rec.attribute14,
        ATTRIBUTE15 = l_def_cft_rec.attribute15,
        CREATED_BY = l_def_cft_rec.created_by,
        CREATION_DATE = l_def_cft_rec.creation_date,
        LAST_UPDATED_BY = l_def_cft_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cft_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cft_rec.last_update_login
    WHERE CURE_FUND_TRANS_ID = l_def_cft_rec.cure_fund_trans_id;

Line: 2145


  END update_row;

Line: 2149


  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_cftv_rec                     IN cftv_rec_type,
    x_cftv_rec                     OUT NOCOPY cftv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2159


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

Line: 2174


      l_cftv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2175


      l_cftv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2176


      l_cftv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2239


        IF (x_cftv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cftv_rec.program_update_date := l_db_cftv_rec.program_update_date;

Line: 2315


        IF (x_cftv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cftv_rec.last_updated_by := l_db_cftv_rec.last_updated_by;

Line: 2319


        IF (x_cftv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cftv_rec.last_update_date := l_db_cftv_rec.last_update_date;

Line: 2323


        IF (x_cftv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cftv_rec.last_update_login := l_db_cftv_rec.last_update_login;

Line: 2408


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cft_rec,
      lx_cft_rec
    );

Line: 2456


  END update_row;

Line: 2460


  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_cftv_tbl                     IN cftv_tbl_type,
    x_cftv_tbl                     OUT NOCOPY cftv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2471


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

Line: 2485


          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_cftv_rec                     => p_cftv_tbl(i),
            x_cftv_rec                     => x_cftv_tbl(i));

Line: 2553


  END update_row;

Line: 2558


  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_cftv_tbl                     IN cftv_tbl_type,
    x_cftv_tbl                     OUT NOCOPY cftv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2568


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

Line: 2575


      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_cftv_tbl                     => p_cftv_tbl,
        x_cftv_tbl                     => x_cftv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2617


  END update_row;

Line: 2625


  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_cft_rec                      IN cft_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2633


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

Line: 2648


    DELETE FROM OKL_CURE_FUND_TRANS
     WHERE CURE_FUND_TRANS_ID = p_cft_rec.cure_fund_trans_id;

Line: 2684


  END delete_row;

Line: 2688


  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_cftv_rec                     IN cftv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2697


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

Line: 2721


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

Line: 2766


  END delete_row;

Line: 2770


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2780


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

Line: 2794


          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_cftv_rec                     => p_cftv_tbl(i));

Line: 2861


  END delete_row;

Line: 2866


  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_cftv_tbl                     IN cftv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2875


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

Line: 2882


      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_cftv_tbl                     => p_cftv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2923


  END delete_row;