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

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

Line: 101


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CHANGE_REQUEST_NUMBER,
            CHR_ID,
            CHANGE_TYPE_CODE,
            STATUS_CODE,
            REQUEST_DATE,
            EFFECTIVE_DATE,
            APPROVED_DATE,
            REJECTED_DATE,
            INEFFECTIVE_DATE,
            APPLIED_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Vp_Change_Requests_V
     WHERE okl_vp_change_requests_v.id = p_id;

Line: 179


              l_vcrv_rec.program_update_date,
              l_vcrv_rec.created_by,
              l_vcrv_rec.creation_date,
              l_vcrv_rec.last_updated_by,
              l_vcrv_rec.last_update_date,
              l_vcrv_rec.last_update_login;

Line: 226


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CHANGE_REQUEST_NUMBER,
            CHR_ID,
            CHANGE_TYPE_CODE,
            STATUS_CODE,
            REQUEST_DATE,
            EFFECTIVE_DATE,
            APPROVED_DATE,
            REJECTED_DATE,
            INEFFECTIVE_DATE,
            APPLIED_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Vp_Change_Requests
     WHERE okl_vp_change_requests.id = p_id;

Line: 304


              l_vcr_rec.program_update_date,
              l_vcr_rec.created_by,
              l_vcr_rec.creation_date,
              l_vcr_rec.last_updated_by,
              l_vcr_rec.last_update_date,
              l_vcr_rec.last_update_login;

Line: 444


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

Line: 453


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

Line: 456


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

Line: 459


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

Line: 553


    SELECT 'X'
      FROM okc_k_headers_b
     WHERE id = p_chr_id
       AND (scs_code = 'PROGRAM' or SCS_CODE = 'OPERATING');

Line: 595


    SELECT 'X'
      FROM fnd_lookups
     WHERE lookup_type = 'OKL_VP_CHANGE_REQUEST_TYPES'
       AND lookup_code = p_change_type_code;

Line: 638


    SELECT 'X'
      FROM fnd_lookups
     WHERE lookup_type = 'OKL_VP_CR_STATUS_CODE'
       AND lookup_code = p_status_code;

Line: 821


    p_to.program_update_date := p_from.program_update_date;

Line: 824


    p_to.last_updated_by := p_from.last_updated_by;

Line: 825


    p_to.last_update_date := p_from.last_update_date;

Line: 826


    p_to.last_update_login := p_from.last_update_login;

Line: 864


    p_to.program_update_date := p_from.program_update_date;

Line: 867


    p_to.last_updated_by := p_from.last_updated_by;

Line: 868


    p_to.last_update_date := p_from.last_update_date;

Line: 869


    p_to.last_update_login := p_from.last_update_login;

Line: 1115


  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_vcr_rec                      IN vcr_rec_type,
    x_vcr_rec                      OUT NOCOPY vcr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1124


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

Line: 1160


    INSERT INTO OKL_VP_CHANGE_REQUESTS(
      id,
      object_version_number,
      change_request_number,
      chr_id,
      change_type_code,
      status_code,
      request_date,
      effective_date,
      approved_date,
      rejected_date,
      ineffective_date,
      applied_date,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_vcr_rec.id,
      l_vcr_rec.object_version_number,
      l_vcr_rec.change_request_number,
      l_vcr_rec.chr_id,
      l_vcr_rec.change_type_code,
      l_vcr_rec.status_code,
      l_vcr_rec.request_date,
      l_vcr_rec.effective_date,
      l_vcr_rec.approved_date,
      l_vcr_rec.rejected_date,
      l_vcr_rec.ineffective_date,
      l_vcr_rec.applied_date,
      l_vcr_rec.attribute_category,
      l_vcr_rec.attribute1,
      l_vcr_rec.attribute2,
      l_vcr_rec.attribute3,
      l_vcr_rec.attribute4,
      l_vcr_rec.attribute5,
      l_vcr_rec.attribute6,
      l_vcr_rec.attribute7,
      l_vcr_rec.attribute8,
      l_vcr_rec.attribute9,
      l_vcr_rec.attribute10,
      l_vcr_rec.attribute11,
      l_vcr_rec.attribute12,
      l_vcr_rec.attribute13,
      l_vcr_rec.attribute14,
      l_vcr_rec.attribute15,
      l_vcr_rec.request_id,
      l_vcr_rec.program_application_id,
      l_vcr_rec.program_id,
      l_vcr_rec.program_update_date,
      l_vcr_rec.created_by,
      l_vcr_rec.creation_date,
      l_vcr_rec.last_updated_by,
      l_vcr_rec.last_update_date,
      l_vcr_rec.last_update_login);

Line: 1271


  END insert_row;

Line: 1275


  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_vcrv_rec                     IN vcrv_rec_type,
    x_vcrv_rec                     OUT NOCOPY vcrv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1285


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

Line: 1301


      l_vcrv_rec.LAST_UPDATE_DATE := l_vcrv_rec.CREATION_DATE;

Line: 1302


      l_vcrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1303


      l_vcrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1367


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vcr_rec,
      lx_vcr_rec
    );

Line: 1416


  END insert_row;

Line: 1420


  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_vcrv_tbl                     IN vcrv_tbl_type,
    x_vcrv_tbl                     OUT NOCOPY vcrv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1431


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

Line: 1445


          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_vcrv_rec                     => p_vcrv_tbl(i),
            x_vcrv_rec                     => x_vcrv_tbl(i));

Line: 1513


  END insert_row;

Line: 1518


  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_vcrv_tbl                     IN vcrv_tbl_type,
    x_vcrv_tbl                     OUT NOCOPY vcrv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1528


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

Line: 1535


      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_vcrv_tbl                     => p_vcrv_tbl,
        x_vcrv_tbl                     => x_vcrv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1577


  END insert_row;

Line: 1595


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VP_CHANGE_REQUESTS
     WHERE ID = p_vcr_rec.id
       AND OBJECT_VERSION_NUMBER = p_vcr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1602


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VP_CHANGE_REQUESTS
     WHERE ID = p_vcr_rec.id;

Line: 1643


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1652


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1932


  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_vcr_rec                      IN vcr_rec_type,
    x_vcr_rec                      OUT NOCOPY vcr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1941


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

Line: 2085


        IF (x_vcr_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vcr_rec.program_update_date := l_vcr_rec.program_update_date;

Line: 2097


        IF (x_vcr_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_vcr_rec.last_updated_by := l_vcr_rec.last_updated_by;

Line: 2101


        IF (x_vcr_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vcr_rec.last_update_date := l_vcr_rec.last_update_date;

Line: 2105


        IF (x_vcr_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_vcr_rec.last_update_login := l_vcr_rec.last_update_login;

Line: 2151


    UPDATE OKL_VP_CHANGE_REQUESTS
    SET OBJECT_VERSION_NUMBER = l_def_vcr_rec.object_version_number,
        CHANGE_REQUEST_NUMBER = l_def_vcr_rec.change_request_number,
        CHR_ID = l_def_vcr_rec.chr_id,
        CHANGE_TYPE_CODE = l_def_vcr_rec.change_type_code,
        STATUS_CODE = l_def_vcr_rec.status_code,
        REQUEST_DATE = l_def_vcr_rec.request_date,
        EFFECTIVE_DATE = l_def_vcr_rec.effective_date,
        APPROVED_DATE = l_def_vcr_rec.approved_date,
        REJECTED_DATE = l_def_vcr_rec.rejected_date,
        INEFFECTIVE_DATE = l_def_vcr_rec.ineffective_date,
        APPLIED_DATE = l_def_vcr_rec.applied_date,
        ATTRIBUTE_CATEGORY = l_def_vcr_rec.attribute_category,
        ATTRIBUTE1 = l_def_vcr_rec.attribute1,
        ATTRIBUTE2 = l_def_vcr_rec.attribute2,
        ATTRIBUTE3 = l_def_vcr_rec.attribute3,
        ATTRIBUTE4 = l_def_vcr_rec.attribute4,
        ATTRIBUTE5 = l_def_vcr_rec.attribute5,
        ATTRIBUTE6 = l_def_vcr_rec.attribute6,
        ATTRIBUTE7 = l_def_vcr_rec.attribute7,
        ATTRIBUTE8 = l_def_vcr_rec.attribute8,
        ATTRIBUTE9 = l_def_vcr_rec.attribute9,
        ATTRIBUTE10 = l_def_vcr_rec.attribute10,
        ATTRIBUTE11 = l_def_vcr_rec.attribute11,
        ATTRIBUTE12 = l_def_vcr_rec.attribute12,
        ATTRIBUTE13 = l_def_vcr_rec.attribute13,
        ATTRIBUTE14 = l_def_vcr_rec.attribute14,
        ATTRIBUTE15 = l_def_vcr_rec.attribute15,
        REQUEST_ID = l_def_vcr_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_vcr_rec.program_application_id,
        PROGRAM_ID = l_def_vcr_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_vcr_rec.program_update_date,
        CREATED_BY = l_def_vcr_rec.created_by,
        CREATION_DATE = l_def_vcr_rec.creation_date,
        LAST_UPDATED_BY = l_def_vcr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_vcr_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_vcr_rec.last_update_login
    WHERE ID = l_def_vcr_rec.id;

Line: 2224


  END update_row;

Line: 2228


  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_vcrv_rec                     IN vcrv_rec_type,
    x_vcrv_rec                     OUT NOCOPY vcrv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2238


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

Line: 2253


      l_vcrv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2254


      l_vcrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2255


      l_vcrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2394


        IF (x_vcrv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vcrv_rec.program_update_date := l_db_vcrv_rec.program_update_date;

Line: 2406


        IF (x_vcrv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_vcrv_rec.last_updated_by := l_db_vcrv_rec.last_updated_by;

Line: 2410


        IF (x_vcrv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vcrv_rec.last_update_date := l_db_vcrv_rec.last_update_date;

Line: 2414


        IF (x_vcrv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_vcrv_rec.last_update_login := l_db_vcrv_rec.last_update_login;

Line: 2500


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vcr_rec,
      lx_vcr_rec
    );

Line: 2548


  END update_row;

Line: 2552


  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_vcrv_tbl                     IN vcrv_tbl_type,
    x_vcrv_tbl                     OUT NOCOPY vcrv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2563


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

Line: 2577


          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_vcrv_rec                     => p_vcrv_tbl(i),
            x_vcrv_rec                     => x_vcrv_tbl(i));

Line: 2645


  END update_row;

Line: 2650


  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_vcrv_tbl                     IN vcrv_tbl_type,
    x_vcrv_tbl                     OUT NOCOPY vcrv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2660


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

Line: 2667


      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_vcrv_tbl                     => p_vcrv_tbl,
        x_vcrv_tbl                     => x_vcrv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2709


  END update_row;

Line: 2717


  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_vcr_rec                      IN vcr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2725


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

Line: 2740


    DELETE FROM OKL_VP_CHANGE_REQUESTS
     WHERE ID = p_vcr_rec.id;

Line: 2776


  END delete_row;

Line: 2780


  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_vcrv_rec                     IN vcrv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2789


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

Line: 2813


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

Line: 2858


  END delete_row;

Line: 2862


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2872


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

Line: 2886


          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_vcrv_rec                     => p_vcrv_tbl(i));

Line: 2953


  END delete_row;

Line: 2958


  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_vcrv_tbl                     IN vcrv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2967


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

Line: 2974


      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_vcrv_tbl                     => p_vcrv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3015


  END delete_row;