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.IEX_REP_PVT SQL Statements

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

Line: 69


    select iex_repos_objects_s.nextval INTO l_seq_id FROM dual;

Line: 105


    SELECT
            REPOS_OBJECT_ID,
            REPOSSESSION_ID,
            ASSET_ID,
            RNA_ID,
            RNA_SITE_ID,
            ART_ID,
            ACTIVE_YN,
            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,
            SECURITY_GROUP_ID
      FROM Iex_Repos_Objects_V
     WHERE iex_repos_objects_v.repos_object_id = p_repos_object_id;

Line: 162


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

Line: 226


    SELECT
            REPOS_OBJECT_ID,
            REPOSSESSION_ID,
            ASSET_ID,
            RNA_ID,
            RNA_SITE_ID,
            ART_ID,
            ACTIVE_YN,
            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 Iex_Repos_Objects
     WHERE iex_repos_objects.repos_object_id = p_repos_object_id;

Line: 282


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

Line: 381


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

Line: 438


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

Line: 441


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

Line: 444


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

Line: 487


    SELECT repossession_id
    FROM iex_repossessions
    WHERE repossession_id = cp_repossession_id;

Line: 538


    SELECT asset_id
   --START jsanju 01/06/06 for bug 4932911
   --change okx_assests_lines_v to okx_assests_v
   --END jsanju 01/06/06 for bug 4932911

    FROM okx_assets_v
    WHERE asset_id = cp_asset_id;

Line: 592


    SELECT vendor_id
    FROM po_vendors
    WHERE vendor_id = cp_rna_id;

Line: 643


    SELECT vendor_site_id
    FROM po_vendor_sites_all
    WHERE vendor_id = cp_rna_id
    AND vendor_site_id = cp_rna_site_id;

Line: 689


    SELECT id
    FROM okl_asset_returns_b
    WHERE id = cp_art_id;

Line: 917


    p_to.program_update_date := p_from.program_update_date;

Line: 936


    p_to.last_updated_by := p_from.last_updated_by;

Line: 937


    p_to.last_update_date := p_from.last_update_date;

Line: 938


    p_to.last_update_login := p_from.last_update_login;

Line: 957


    p_to.program_update_date := p_from.program_update_date;

Line: 976


    p_to.last_updated_by := p_from.last_updated_by;

Line: 977


    p_to.last_update_date := p_from.last_update_date;

Line: 978


    p_to.last_update_login := p_from.last_update_login;

Line: 1224


  PROCEDURE insert_row(
    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_rep_rec                      IN rep_rec_type,
    x_rep_rec                      OUT NOCOPY rep_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1233


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

Line: 1269


    INSERT INTO IEX_REPOS_OBJECTS(
      repos_object_id,
      repossession_id,
      asset_id,
      rna_id,
      rna_site_id,
      art_id,
      active_yn,
      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_rep_rec.repos_object_id,
      l_rep_rec.repossession_id,
      l_rep_rec.asset_id,
      l_rep_rec.rna_id,
      l_rep_rec.rna_site_id,
      l_rep_rec.art_id,
      l_rep_rec.active_yn,
      l_rep_rec.object_version_number,
      l_rep_rec.org_id,
      l_rep_rec.request_id,
      l_rep_rec.program_application_id,
      l_rep_rec.program_id,
      l_rep_rec.program_update_date,
      l_rep_rec.attribute_category,
      l_rep_rec.attribute1,
      l_rep_rec.attribute2,
      l_rep_rec.attribute3,
      l_rep_rec.attribute4,
      l_rep_rec.attribute5,
      l_rep_rec.attribute6,
      l_rep_rec.attribute7,
      l_rep_rec.attribute8,
      l_rep_rec.attribute9,
      l_rep_rec.attribute10,
      l_rep_rec.attribute11,
      l_rep_rec.attribute12,
      l_rep_rec.attribute13,
      l_rep_rec.attribute14,
      l_rep_rec.attribute15,
      l_rep_rec.created_by,
      l_rep_rec.creation_date,
      l_rep_rec.last_updated_by,
      l_rep_rec.last_update_date,
      l_rep_rec.last_update_login);

Line: 1374


  END insert_row;

Line: 1378


  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_repv_rec                     IN repv_rec_type,
    x_repv_rec                     OUT NOCOPY repv_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1388


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

Line: 1404


      l_repv_rec.LAST_UPDATE_DATE := l_repv_rec.CREATION_DATE;

Line: 1405


      l_repv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1406


      l_repv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1470


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_rep_rec,
      lx_rep_rec
    );

Line: 1519


  END insert_row;

Line: 1523


  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_repv_tbl                     IN repv_tbl_type,
    x_repv_tbl                     OUT NOCOPY repv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1534


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

Line: 1548


          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_repv_rec                     => p_repv_tbl(i),
            x_repv_rec                     => x_repv_tbl(i));

Line: 1616


  END insert_row;

Line: 1621


  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_repv_tbl                     IN repv_tbl_type,
    x_repv_tbl                     OUT NOCOPY repv_tbl_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1631


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

Line: 1638


      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_repv_tbl                     => p_repv_tbl,
        x_repv_tbl                     => x_repv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1680


  END insert_row;

Line: 1698


    SELECT OBJECT_VERSION_NUMBER
      FROM IEX_REPOS_OBJECTS
     WHERE REPOS_OBJECT_ID = p_rep_rec.repos_object_id
       AND OBJECT_VERSION_NUMBER = p_rep_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1705


    SELECT OBJECT_VERSION_NUMBER
      FROM IEX_REPOS_OBJECTS
     WHERE REPOS_OBJECT_ID = p_rep_rec.repos_object_id;

Line: 1746


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1755


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2035


  PROCEDURE update_row(
    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_rep_rec                      IN rep_rec_type,
    x_rep_rec                      OUT NOCOPY rep_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2044


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

Line: 2112


        IF (x_rep_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_rep_rec.program_update_date := l_rep_rec.program_update_date;

Line: 2188


        IF (x_rep_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_rep_rec.last_updated_by := l_rep_rec.last_updated_by;

Line: 2192


        IF (x_rep_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_rep_rec.last_update_date := l_rep_rec.last_update_date;

Line: 2196


        IF (x_rep_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_rep_rec.last_update_login := l_rep_rec.last_update_login;

Line: 2242


    UPDATE IEX_REPOS_OBJECTS
    SET REPOSSESSION_ID = l_def_rep_rec.repossession_id,
        ASSET_ID = l_def_rep_rec.asset_id,
        RNA_ID = l_def_rep_rec.rna_id,
        RNA_SITE_ID = l_def_rep_rec.rna_site_id,
        ART_ID = l_def_rep_rec.art_id,
        ACTIVE_YN = l_def_rep_rec.active_yn,
        OBJECT_VERSION_NUMBER = l_def_rep_rec.object_version_number,
        ORG_ID = l_def_rep_rec.org_id,
        REQUEST_ID = l_def_rep_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_rep_rec.program_application_id,
        PROGRAM_ID = l_def_rep_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_rep_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_rep_rec.attribute_category,
        ATTRIBUTE1 = l_def_rep_rec.attribute1,
        ATTRIBUTE2 = l_def_rep_rec.attribute2,
        ATTRIBUTE3 = l_def_rep_rec.attribute3,
        ATTRIBUTE4 = l_def_rep_rec.attribute4,
        ATTRIBUTE5 = l_def_rep_rec.attribute5,
        ATTRIBUTE6 = l_def_rep_rec.attribute6,
        ATTRIBUTE7 = l_def_rep_rec.attribute7,
        ATTRIBUTE8 = l_def_rep_rec.attribute8,
        ATTRIBUTE9 = l_def_rep_rec.attribute9,
        ATTRIBUTE10 = l_def_rep_rec.attribute10,
        ATTRIBUTE11 = l_def_rep_rec.attribute11,
        ATTRIBUTE12 = l_def_rep_rec.attribute12,
        ATTRIBUTE13 = l_def_rep_rec.attribute13,
        ATTRIBUTE14 = l_def_rep_rec.attribute14,
        ATTRIBUTE15 = l_def_rep_rec.attribute15,
        CREATED_BY = l_def_rep_rec.created_by,
        CREATION_DATE = l_def_rep_rec.creation_date,
        LAST_UPDATED_BY = l_def_rep_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rep_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_rep_rec.last_update_login
    WHERE REPOS_OBJECT_ID = l_def_rep_rec.repos_object_id;

Line: 2312


  END update_row;

Line: 2316


  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_repv_rec                     IN repv_rec_type,
    x_repv_rec                     OUT NOCOPY repv_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2326


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

Line: 2341


      l_repv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2342


      l_repv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2343


      l_repv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2406


        IF (x_repv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_repv_rec.program_update_date := l_db_repv_rec.program_update_date;

Line: 2482


        IF (x_repv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_repv_rec.last_updated_by := l_db_repv_rec.last_updated_by;

Line: 2486


        IF (x_repv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_repv_rec.last_update_date := l_db_repv_rec.last_update_date;

Line: 2490


        IF (x_repv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_repv_rec.last_update_login := l_db_repv_rec.last_update_login;

Line: 2579


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_rep_rec,
      lx_rep_rec
    );

Line: 2627


  END update_row;

Line: 2631


  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_repv_tbl                     IN repv_tbl_type,
    x_repv_tbl                     OUT NOCOPY repv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2642


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

Line: 2656


          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_repv_rec                     => p_repv_tbl(i),
            x_repv_rec                     => x_repv_tbl(i));

Line: 2724


  END update_row;

Line: 2729


  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_repv_tbl                     IN repv_tbl_type,
    x_repv_tbl                     OUT NOCOPY repv_tbl_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2739


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

Line: 2746


      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_repv_tbl                     => p_repv_tbl,
        x_repv_tbl                     => x_repv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2788


  END update_row;

Line: 2796


  PROCEDURE delete_row(
    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_rep_rec                      IN rep_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2804


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

Line: 2819


    DELETE FROM IEX_REPOS_OBJECTS
     WHERE REPOS_OBJECT_ID = p_rep_rec.repos_object_id;

Line: 2855


  END delete_row;

Line: 2859


  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_repv_rec                     IN repv_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2868


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

Line: 2892


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

Line: 2937


  END delete_row;

Line: 2941


  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_repv_tbl                     IN repv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2951


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

Line: 2965


          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_repv_rec                     => p_repv_tbl(i));

Line: 3032


  END delete_row;

Line: 3037


  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_repv_tbl                     IN repv_tbl_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3046


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

Line: 3053


      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_repv_tbl                     => p_repv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3094


  END delete_row;