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

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

Line: 38


    SELECT lse.lty_code
    FROM okc_k_lines_b cle,
         okc_line_styles_b lse
    WHERE cle.id = p_cle_id
    AND cle.lse_id = lse.id;

Line: 46


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT t1.id
                  FROM okc_line_styles_b t1
                       ,okc_line_styles_b t2
                       ,okc_subclass_top_line t3
                       ,okc_k_lines_b cle
                  WHERE t1.lty_code = p_code
                  AND cle.id = p_cle_id
                  AND cle.lse_id = t1.id
                  AND t2.lty_code = G_FIN_LINE_LTY_CODE
                  AND t1.lse_parent_id = t2.id
                  AND t3.lse_id = t2.id
                  AND t3.scs_code = 'LEASE');

Line: 64


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT t1.id
                  FROM okc_line_styles_b t1
                       ,okc_line_styles_b t2
                       ,okc_line_styles_b t3
                       ,okc_subclass_top_line t4
                       ,okc_k_lines_b cle
                  WHERE t1.lty_code = p_code
                  AND cle.id = p_cle_id
                  AND cle.lse_id = t1.id
                  AND t2.lty_code = p_code2
                  AND t1.lse_parent_id = t2.id
                  AND t2.lse_parent_id = t3.id
                  AND t3.lty_code = G_FIN_LINE_LTY_CODE
                  AND t4.lse_id = t3.id
                  AND t4.scs_code = 'LEASE');

Line: 198


    SELECT lse.lty_code
    FROM okc_k_lines_b cle,
         okc_line_styles_b lse
    WHERE cle.id = p_cle_id
    AND cle.lse_id = lse.id;

Line: 206


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT t1.id
                  FROM okc_line_styles_b t1
                       ,okc_line_styles_b t2
                       ,okc_subclass_top_line t3
                       ,okc_k_lines_b cle
                  WHERE t1.lty_code = p_code
                  AND cle.id = p_cle_id
                  AND cle.lse_id = t1.id
                  AND t2.lty_code = G_FIN_LINE_LTY_CODE
                  AND t1.lse_parent_id = t2.id
                  AND t3.lse_id = t2.id
                  AND t3.scs_code = 'LEASE');

Line: 309


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT '1'
                  FROM OKX_CUST_SITE_USES_V
                  WHERE id1 = p_shipping_id1
                  AND id2 = G_ID2
                  AND site_use_code = 'SHIP_TO');

Line: 387


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT '1'
                  FROM OKX_CUST_SITE_USES_V
                  WHERE id1 = p_shipping_id1
                  AND id2 = p_shipping_id2
                  AND site_use_code = 'SHIP_TO');

Line: 464


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT '1'
                  FROM JTF_OBJECTS_B
                  WHERE object_code = p_shipping_code);

Line: 622


    SELECT ID,
           OBJECT_VERSION_NUMBER,
           CLE_ID,
           FA_CLE_ID,
           INVOICE_NUMBER,
           DATE_INVOICED,
           DATE_DUE,
           SHIPPING_ADDRESS_ID1,
           SHIPPING_ADDRESS_ID2,
           SHIPPING_ADDRESS_CODE,
           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_Supp_Invoice_Dtls_V
      WHERE okl_supp_invoice_dtls_V.id = p_id;

Line: 690


              l_sidv_rec.last_updated_by,
              l_sidv_rec.last_update_date,
              l_sidv_rec.last_update_login;

Line: 735


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CLE_ID,
            FA_CLE_ID,
            INVOICE_NUMBER,
            DATE_INVOICED,
            DATE_DUE,
            SHIPPING_ADDRESS_ID1,
            SHIPPING_ADDRESS_ID2,
            SHIPPING_ADDRESS_CODE,
            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_Supp_Invoice_Dtls
     WHERE okl_supp_invoice_dtls.id = p_id;

Line: 804


              l_sid_rec.last_updated_by,
              l_sid_rec.last_update_date,
              l_sid_rec.last_update_login;

Line: 848


    SELECT ID,
           OBJECT_VERSION_NUMBER,
           MAJOR_VERSION,
           CLE_ID,
           FA_CLE_ID,
           INVOICE_NUMBER,
           DATE_INVOICED,
           DATE_DUE,
           SHIPPING_ADDRESS_ID1,
           SHIPPING_ADDRESS_ID2,
           SHIPPING_ADDRESS_CODE,
           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_Supp_Invoice_Dtls_h
     WHERE okl_supp_invoice_dtls_h.id = p_id;

Line: 918


        l_okl_sidh_rec.LAST_UPDATED_BY,
        l_okl_sidh_rec.LAST_UPDATE_DATE,
        l_okl_sidh_rec.LAST_UPDATE_LOGIN;

Line: 1046


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

Line: 1049


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

Line: 1052


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

Line: 1192


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1193


    p_to.last_update_date := p_from.last_update_date;

Line: 1194


    p_to.last_update_login := p_from.last_update_login;

Line: 1230


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1231


    p_to.last_update_date := p_from.last_update_date;

Line: 1232


    p_to.last_update_login := p_from.last_update_login;

Line: 1268


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1269


    p_to.last_update_date := p_from.last_update_date;

Line: 1270


    p_to.last_update_login := p_from.last_update_login;

Line: 1419


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sidh_rec                     IN okl_sidh_rec_type,
    x_sidh_rec                     OUT NOCOPY okl_sidh_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1429


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

Line: 1467


    INSERT INTO OKL_SUPP_INVOICE_DTLS_H(
      id,
      object_version_number,
      major_version,
      cle_id,
      fa_cle_id,
      invoice_number,
      date_invoiced,
      date_due,
      shipping_address_id1,
      shipping_address_id2,
      shipping_address_code,
      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_sidh_rec.id,
      l_sidh_rec.object_version_number,
      l_sidh_rec.major_version,
      l_sidh_rec.cle_id,
      l_sidh_rec.fa_cle_id,
      l_sidh_rec.invoice_number,
      l_sidh_rec.date_invoiced,
      l_sidh_rec.date_due,
      l_sidh_rec.shipping_address_id1,
      l_sidh_rec.shipping_address_id2,
      l_sidh_rec.shipping_address_code,
      l_sidh_rec.attribute_category,
      l_sidh_rec.attribute1,
      l_sidh_rec.attribute2,
      l_sidh_rec.attribute3,
      l_sidh_rec.attribute4,
      l_sidh_rec.attribute5,
      l_sidh_rec.attribute6,
      l_sidh_rec.attribute7,
      l_sidh_rec.attribute8,
      l_sidh_rec.attribute9,
      l_sidh_rec.attribute10,
      l_sidh_rec.attribute11,
      l_sidh_rec.attribute12,
      l_sidh_rec.attribute13,
      l_sidh_rec.attribute14,
      l_sidh_rec.attribute15,
      l_sidh_rec.created_by,
      l_sidh_rec.creation_date,
      l_sidh_rec.last_updated_by,
      l_sidh_rec.last_update_date,
      l_sidh_rec.last_update_login);

Line: 1568


  END insert_row;

Line: 1575


  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_sid_rec                      IN sid_rec_type,
    x_sid_rec                      OUT NOCOPY sid_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1584


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

Line: 1620


    INSERT INTO OKL_SUPP_INVOICE_DTLS(
      id,
      object_version_number,
      cle_id,
      fa_cle_id,
      invoice_number,
      date_invoiced,
      date_due,
      shipping_address_id1,
      shipping_address_id2,
      shipping_address_code,
      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_sid_rec.id,
      l_sid_rec.object_version_number,
      l_sid_rec.cle_id,
      l_sid_rec.fa_cle_id,
      l_sid_rec.invoice_number,
      l_sid_rec.date_invoiced,
      l_sid_rec.date_due,
      l_sid_rec.shipping_address_id1,
      l_sid_rec.shipping_address_id2,
      l_sid_rec.shipping_address_code,
      l_sid_rec.attribute_category,
      l_sid_rec.attribute1,
      l_sid_rec.attribute2,
      l_sid_rec.attribute3,
      l_sid_rec.attribute4,
      l_sid_rec.attribute5,
      l_sid_rec.attribute6,
      l_sid_rec.attribute7,
      l_sid_rec.attribute8,
      l_sid_rec.attribute9,
      l_sid_rec.attribute10,
      l_sid_rec.attribute11,
      l_sid_rec.attribute12,
      l_sid_rec.attribute13,
      l_sid_rec.attribute14,
      l_sid_rec.attribute15,
      l_sid_rec.created_by,
      l_sid_rec.creation_date,
      l_sid_rec.last_updated_by,
      l_sid_rec.last_update_date,
      l_sid_rec.last_update_login);

Line: 1719


  END insert_row;

Line: 1723


  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_sidv_rec                     IN sidv_rec_type,
    x_sidv_rec                     OUT NOCOPY sidv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1733


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

Line: 1749


      l_sidv_rec.LAST_UPDATE_DATE := l_sidv_rec.CREATION_DATE;

Line: 1750


      l_sidv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1751


      l_sidv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1815


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_sid_rec,
      lx_sid_rec
    );

Line: 1864


  END insert_row;

Line: 1868


  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_sidv_tbl                     IN sidv_tbl_type,
    x_sidv_tbl                     OUT NOCOPY sidv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1878


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

Line: 1886


        insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => p_init_msg_list,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_sidv_rec                     => p_sidv_tbl(i),
            x_sidv_rec                     => x_sidv_tbl(i));

Line: 1930


  END insert_row;

Line: 1947


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SUPP_INVOICE_DTLS
     WHERE ID = p_sid_rec.id
       AND OBJECT_VERSION_NUMBER = p_sid_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1954


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SUPP_INVOICE_DTLS
     WHERE ID = p_sid_rec.id;

Line: 1995


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2004


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2193


  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_sid_rec                      IN sid_rec_type,
    x_sid_rec                      OUT NOCOPY sid_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2202


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

Line: 2340


        IF (x_sid_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_sid_rec.last_updated_by := l_sid_rec.last_updated_by;

Line: 2344


        IF (x_sid_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_sid_rec.last_update_date := l_sid_rec.last_update_date;

Line: 2348


        IF (x_sid_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_sid_rec.last_update_login := l_sid_rec.last_update_login;

Line: 2394


    UPDATE OKL_SUPP_INVOICE_DTLS
    SET OBJECT_VERSION_NUMBER = l_def_sid_rec.object_version_number,
        CLE_ID = l_def_sid_rec.cle_id,
        FA_CLE_ID = l_def_sid_rec.fa_cle_id,
        INVOICE_NUMBER = l_def_sid_rec.invoice_number,
        DATE_INVOICED = l_def_sid_rec.date_invoiced,
        DATE_DUE = l_def_sid_rec.date_due,
        SHIPPING_ADDRESS_ID1 = l_def_sid_rec.shipping_address_id1,
        SHIPPING_ADDRESS_ID2 = l_def_sid_rec.shipping_address_id2,
        SHIPPING_ADDRESS_CODE = l_def_sid_rec.shipping_address_code,
        ATTRIBUTE_CATEGORY = l_def_sid_rec.attribute_category,
        ATTRIBUTE1 = l_def_sid_rec.attribute1,
        ATTRIBUTE2 = l_def_sid_rec.attribute2,
        ATTRIBUTE3 = l_def_sid_rec.attribute3,
        ATTRIBUTE4 = l_def_sid_rec.attribute4,
        ATTRIBUTE5 = l_def_sid_rec.attribute5,
        ATTRIBUTE6 = l_def_sid_rec.attribute6,
        ATTRIBUTE7 = l_def_sid_rec.attribute7,
        ATTRIBUTE8 = l_def_sid_rec.attribute8,
        ATTRIBUTE9 = l_def_sid_rec.attribute9,
        ATTRIBUTE10 = l_def_sid_rec.attribute10,
        ATTRIBUTE11 = l_def_sid_rec.attribute11,
        ATTRIBUTE12 = l_def_sid_rec.attribute12,
        ATTRIBUTE13 = l_def_sid_rec.attribute13,
        ATTRIBUTE14 = l_def_sid_rec.attribute14,
        ATTRIBUTE15 = l_def_sid_rec.attribute15,
        CREATED_BY = l_def_sid_rec.created_by,
        CREATION_DATE = l_def_sid_rec.creation_date,
        LAST_UPDATED_BY = l_def_sid_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_sid_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_sid_rec.last_update_login
    WHERE ID = l_def_sid_rec.id;

Line: 2460


  END update_row;

Line: 2464


  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_sidv_rec                     IN sidv_rec_type,
    x_sidv_rec                     OUT NOCOPY sidv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2474


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

Line: 2489


      l_sidv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2490


      l_sidv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2491


      l_sidv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2622


        IF (x_sidv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_sidv_rec.last_updated_by := l_db_sidv_rec.last_updated_by;

Line: 2626


        IF (x_sidv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_sidv_rec.last_update_date := l_db_sidv_rec.last_update_date;

Line: 2630


        IF (x_sidv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_sidv_rec.last_update_login := l_db_sidv_rec.last_update_login;

Line: 2700


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_sid_rec,
      lx_sid_rec
    );

Line: 2748


  END update_row;

Line: 2752


  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_sidv_tbl                     IN sidv_tbl_type,
    x_sidv_tbl                     OUT NOCOPY sidv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2762


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

Line: 2770


        update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => p_init_msg_list,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_sidv_rec                     => p_sidv_tbl(i),
            x_sidv_rec                     => x_sidv_tbl(i));

Line: 2814


  END update_row;

Line: 2821


  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_sid_rec                      IN sid_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2829


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

Line: 2844


    DELETE FROM OKL_SUPP_INVOICE_DTLS
     WHERE ID = p_sid_rec.id;

Line: 2880


  END delete_row;

Line: 2884


  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_sidv_rec                     IN sidv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2893


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

Line: 2917


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

Line: 2962


  END delete_row;

Line: 2966


  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_sidv_tbl                     IN sidv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2975


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

Line: 2983


        delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => p_init_msg_list,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_sidv_rec                     => p_sidv_tbl(i));

Line: 3026


  END delete_row;

Line: 3037


    INSERT INTO OKL_SUPP_INVOICE_DTLS_H(
      id,
      object_version_number,
      major_version,
      cle_id,
      fa_cle_id,
      invoice_number,
      date_invoiced,
      date_due,
      shipping_address_id1,
      shipping_address_id2,
      shipping_address_code,
      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)
  SELECT
      id,
      object_version_number,
      p_major_version,
      cle_id,
      fa_cle_id,
      invoice_number,
      date_invoiced,
      date_due,
      shipping_address_id1,
      shipping_address_id2,
      shipping_address_code,
      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_SUPP_INVOICE_DTLS
  WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);

Line: 3129


    INSERT INTO OKL_SUPP_INVOICE_DTLS(
      id,
      object_version_number,
      cle_id,
      fa_cle_id,
      invoice_number,
      date_invoiced,
      date_due,
      shipping_address_id1,
      shipping_address_id2,
      shipping_address_code,
      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)
  SELECT id,
        object_version_number,
        cle_id,
        fa_cle_id,
        invoice_number,
        date_invoiced,
        date_due,
        shipping_address_id1,
        shipping_address_id2,
        shipping_address_code,
        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_SUPP_INVOICE_DTLS_H
  WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id)
  and major_version = p_major_version;