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

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

Line: 108


    SELECT
            ID,
            KHR_ID,
            KLE_ID,
            ASSET_ID,
            ASSET_NUMBER,
            TAX_LINE_TYPE,
            SEL_ID,
            TAX_DUE_DATE,
            TAX_TYPE,
            TAX_RATE_CODE_ID,
            TAX_RATE_CODE,
            TAXABLE_AMOUNT,
            TAX_EXEMPTION_ID,
            MANUALLY_ENTERED_FLAG,
            OVERRIDDEN_FLAG,
            CALCULATED_TAX_AMOUNT,
            TAX_RATE,
            TAX_AMOUNT,
            SALES_TAX_ID,
            SOURCE_TRX_ID,
            ORG_ID,
            HISTORY_YN,
            ACTUAL_YN,
            SOURCE_NAME,
            TRQ_ID,
            PROGRAM_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_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_TAX_LINES
     WHERE OKL_TAX_LINES.id   = p_id;

Line: 196


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

Line: 259


    SELECT
            ID,
            KHR_ID,
            KLE_ID,
            ASSET_ID,
            ASSET_NUMBER,
            TAX_LINE_TYPE,
            SEL_ID,
            TAX_DUE_DATE,
            TAX_TYPE,
            TAX_RATE_CODE_ID,
            TAX_RATE_CODE,
            TAXABLE_AMOUNT,
            TAX_EXEMPTION_ID,
            MANUALLY_ENTERED_FLAG,
            OVERRIDDEN_FLAG,
            CALCULATED_TAX_AMOUNT,
            TAX_RATE,
            TAX_AMOUNT,
            SALES_TAX_ID,
            SOURCE_TRX_ID,
            ORG_ID,
            HISTORY_YN,
            ACTUAL_YN,
            SOURCE_NAME,
            TRQ_ID,
            PROGRAM_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_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_Tax_Lines
     WHERE okl_tax_lines.id     = p_id;

Line: 347


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

Line: 494


    IF (l_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
      l_OKL_TAX_LINES_rec.program_update_date := NULL;

Line: 551


    IF (l_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
      l_OKL_TAX_LINES_rec.last_updated_by := NULL;

Line: 554


    IF (l_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
      l_OKL_TAX_LINES_rec.last_update_date := NULL;

Line: 557


    IF (l_OKL_TAX_LINES_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
      l_OKL_TAX_LINES_rec.last_update_login := NULL;

Line: 733


      SELECT 'x'
        FROM Fnd_Lookups
       WHERE fnd_lookups.lookup_type='OKL_TAX_LINE_TYPE'
       AND fnd_lookups.lookup_code = p_lookup_code;

Line: 740


      SELECT 'x'
        FROM OKL_TRX_REQUESTS
       WHERE  OKL_TRX_REQUESTS.id = p_id;

Line: 830


    p_to.program_update_date := p_from.program_update_date;

Line: 849


    p_to.last_updated_by := p_from.last_updated_by;

Line: 850


    p_to.last_update_date := p_from.last_update_date;

Line: 851


    p_to.last_update_login := p_from.last_update_login;

Line: 886


    p_to.program_update_date := p_from.program_update_date;

Line: 905


    p_to.last_updated_by := p_from.last_updated_by;

Line: 906


    p_to.last_update_date := p_from.last_update_date;

Line: 907


    p_to.last_update_login := p_from.last_update_login;

Line: 1153


  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_tax_rec                      IN tax_rec_type,
    x_tax_rec                      OUT NOCOPY tax_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1162


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

Line: 1198


    INSERT INTO OKL_TAX_LINES(
      id,
      khr_id,
      kle_id,
      asset_id,
      asset_number,
      tax_line_type,
      sel_id,
      tax_due_date,
      tax_type,
      tax_rate_code_id,
      tax_rate_code,
      taxable_amount,
      tax_exemption_id,
      manually_entered_flag,
      overridden_flag,
      calculated_tax_amount,
      tax_rate,
      tax_amount,
      sales_tax_id,
      source_trx_id,
      org_id,
      history_yn,
      actual_yn,
      source_name,
      trq_id,
      program_id,
      request_id,
      program_application_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_tax_rec.id,
      l_tax_rec.khr_id,
      l_tax_rec.kle_id,
      l_tax_rec.asset_id,
      l_tax_rec.asset_number,
      l_tax_rec.tax_line_type,
      l_tax_rec.sel_id,
      l_tax_rec.tax_due_date,
      l_tax_rec.tax_type,
      l_tax_rec.tax_rate_code_id,
      l_tax_rec.tax_rate_code,
      l_tax_rec.taxable_amount,
      l_tax_rec.tax_exemption_id,
      l_tax_rec.manually_entered_flag,
      l_tax_rec.overridden_flag,
      l_tax_rec.calculated_tax_amount,
      l_tax_rec.tax_rate,
      l_tax_rec.tax_amount,
      l_tax_rec.sales_tax_id,
      l_tax_rec.source_trx_id,
      l_tax_rec.org_id,
      l_tax_rec.history_yn,
      l_tax_rec.actual_yn,
      l_tax_rec.source_name,
      l_tax_rec.trq_id,
      l_tax_rec.program_id,
      l_tax_rec.request_id,
      l_tax_rec.program_application_id,
      l_tax_rec.program_update_date,
      l_tax_rec.attribute_category,
      l_tax_rec.attribute1,
      l_tax_rec.attribute2,
      l_tax_rec.attribute3,
      l_tax_rec.attribute4,
      l_tax_rec.attribute5,
      l_tax_rec.attribute6,
      l_tax_rec.attribute7,
      l_tax_rec.attribute8,
      l_tax_rec.attribute9,
      l_tax_rec.attribute10,
      l_tax_rec.attribute11,
      l_tax_rec.attribute12,
      l_tax_rec.attribute13,
      l_tax_rec.attribute14,
      l_tax_rec.attribute15,
      l_tax_rec.created_by,
      l_tax_rec.creation_date,
      l_tax_rec.last_updated_by,
      l_tax_rec.last_update_date,
      l_tax_rec.last_update_login);

Line: 1335


  END insert_row;

Line: 1339


  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_OKL_TAX_LINES_rec          IN OKL_TAX_LINES_rec_type,
    x_OKL_TAX_LINES_rec          OUT NOCOPY OKL_TAX_LINES_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1349


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

Line: 1365


      l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := l_OKL_TAX_LINES_rec.CREATION_DATE;

Line: 1366


      l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1367


      l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1430


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_tax_rec,
      lx_tax_rec
    );

Line: 1479


  END insert_row;

Line: 1483


  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_OKL_TAX_LINES_tbl          IN OKL_TAX_LINES_tbl_type,
    x_OKL_TAX_LINES_tbl          OUT NOCOPY OKL_TAX_LINES_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1494


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

Line: 1508


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_OKL_TAX_LINES_rec          => p_OKL_TAX_LINES_tbl(i),
            x_OKL_TAX_LINES_rec          => x_OKL_TAX_LINES_tbl(i));

Line: 1576


  END insert_row;

Line: 1583


  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_OKL_TAX_LINES_tbl          IN OKL_TAX_LINES_tbl_type,
    x_OKL_TAX_LINES_tbl          OUT NOCOPY OKL_TAX_LINES_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1593


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

Line: 1600


      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_OKL_TAX_LINES_tbl          => p_OKL_TAX_LINES_tbl,
        x_OKL_TAX_LINES_tbl          => x_OKL_TAX_LINES_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1642


  END insert_row;

Line: 1660


    SELECT *
      FROM OKL_TAX_LINES
     WHERE ID = p_tax_rec.id
    FOR UPDATE NOWAIT;

Line: 1696


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1811


      IF (l_lock_var.program_update_date <> p_tax_rec.program_update_date) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 1887


      IF (l_lock_var.last_updated_by <> p_tax_rec.last_updated_by) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 1891


      IF (l_lock_var.last_update_date <> p_tax_rec.last_update_date) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 1895


      IF (l_lock_var.last_update_login <> p_tax_rec.last_update_login) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 2177


  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_tax_rec                      IN tax_rec_type,
    x_tax_rec                      OUT NOCOPY tax_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2186


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

Line: 2318


        IF (x_tax_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_tax_rec.program_update_date := l_tax_rec.program_update_date;

Line: 2394


        IF (x_tax_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_tax_rec.last_updated_by := l_tax_rec.last_updated_by;

Line: 2398


        IF (x_tax_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_tax_rec.last_update_date := l_tax_rec.last_update_date;

Line: 2402


        IF (x_tax_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_tax_rec.last_update_login := l_tax_rec.last_update_login;

Line: 2447


    UPDATE OKL_TAX_LINES
    SET KHR_ID = l_def_tax_rec.khr_id,
        KLE_ID = l_def_tax_rec.kle_id,
        ASSET_ID = l_def_tax_rec.asset_id,
        ASSET_NUMBER = l_def_tax_rec.asset_number,
        TAX_LINE_TYPE = l_def_tax_rec.tax_line_type,
        SEL_ID = l_def_tax_rec.sel_id,
        TAX_DUE_DATE = l_def_tax_rec.tax_due_date,
        TAX_TYPE = l_def_tax_rec.tax_type,
        TAX_RATE_CODE_ID = l_def_tax_rec.tax_rate_code_id,
        TAX_RATE_CODE = l_def_tax_rec.tax_rate_code,
        TAXABLE_AMOUNT = l_def_tax_rec.taxable_amount,
        TAX_EXEMPTION_ID = l_def_tax_rec.tax_exemption_id,
        MANUALLY_ENTERED_FLAG = l_def_tax_rec.manually_entered_flag,
        OVERRIDDEN_FLAG = l_def_tax_rec.overridden_flag,
        CALCULATED_TAX_AMOUNT = l_def_tax_rec.calculated_tax_amount,
        TAX_RATE = l_def_tax_rec.tax_rate,
        TAX_AMOUNT = l_def_tax_rec.tax_amount,
        SALES_TAX_ID = l_def_tax_rec.sales_tax_id,
        SOURCE_TRX_ID = l_def_tax_rec.source_trx_id,
        ORG_ID = l_def_tax_rec.org_id,
        HISTORY_YN = l_def_tax_rec.history_yn,
        ACTUAL_YN = l_def_tax_rec.actual_yn,
        SOURCE_NAME = l_def_tax_rec.source_name,
        TRQ_ID = l_def_tax_rec.trq_id,
        PROGRAM_ID = l_def_tax_rec.program_id,
        REQUEST_ID = l_def_tax_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_tax_rec.program_application_id,
        PROGRAM_UPDATE_DATE = l_def_tax_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_tax_rec.attribute_category,
        ATTRIBUTE1 = l_def_tax_rec.attribute1,
        ATTRIBUTE2 = l_def_tax_rec.attribute2,
        ATTRIBUTE3 = l_def_tax_rec.attribute3,
        ATTRIBUTE4 = l_def_tax_rec.attribute4,
        ATTRIBUTE5 = l_def_tax_rec.attribute5,
        ATTRIBUTE6 = l_def_tax_rec.attribute6,
        ATTRIBUTE7 = l_def_tax_rec.attribute7,
        ATTRIBUTE8 = l_def_tax_rec.attribute8,
        ATTRIBUTE9 = l_def_tax_rec.attribute9,
        ATTRIBUTE10 = l_def_tax_rec.attribute10,
        ATTRIBUTE11 = l_def_tax_rec.attribute11,
        ATTRIBUTE12 = l_def_tax_rec.attribute12,
        ATTRIBUTE13 = l_def_tax_rec.attribute13,
        ATTRIBUTE14 = l_def_tax_rec.attribute14,
        ATTRIBUTE15 = l_def_tax_rec.attribute15,
        CREATED_BY = l_def_tax_rec.created_by,
        CREATION_DATE = l_def_tax_rec.creation_date,
        LAST_UPDATED_BY = l_def_tax_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_tax_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_tax_rec.last_update_login
    WHERE ID = l_def_tax_rec.id;

Line: 2533


  END update_row;

Line: 2537


  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_OKL_TAX_LINES_rec          IN OKL_TAX_LINES_rec_type,
    x_OKL_TAX_LINES_rec          OUT NOCOPY OKL_TAX_LINES_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2547


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

Line: 2562


      l_OKL_TAX_LINES_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2563


      l_OKL_TAX_LINES_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2564


      l_OKL_TAX_LINES_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2695


        IF (x_OKL_TAX_LINES_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_OKL_TAX_LINES_rec.program_update_date := l_db_OKL_TAX_LINES_rec.program_update_date;

Line: 2771


        IF (x_OKL_TAX_LINES_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_OKL_TAX_LINES_rec.last_updated_by := l_db_OKL_TAX_LINES_rec.last_updated_by;

Line: 2775


        IF (x_OKL_TAX_LINES_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_OKL_TAX_LINES_rec.last_update_date := l_db_OKL_TAX_LINES_rec.last_update_date;

Line: 2779


        IF (x_OKL_TAX_LINES_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_OKL_TAX_LINES_rec.last_update_login := l_db_OKL_TAX_LINES_rec.last_update_login;

Line: 2864


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_tax_rec,
      lx_tax_rec
    );

Line: 2912


  END update_row;

Line: 2916


  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_OKL_TAX_LINES_tbl          IN OKL_TAX_LINES_tbl_type,
    x_OKL_TAX_LINES_tbl          OUT NOCOPY OKL_TAX_LINES_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2927


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

Line: 2941


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_OKL_TAX_LINES_rec          => p_OKL_TAX_LINES_tbl(i),
            x_OKL_TAX_LINES_rec          => x_OKL_TAX_LINES_tbl(i));

Line: 3009


  END update_row;

Line: 3016


  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_OKL_TAX_LINES_tbl          IN OKL_TAX_LINES_tbl_type,
    x_OKL_TAX_LINES_tbl          OUT NOCOPY OKL_TAX_LINES_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3026


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

Line: 3033


      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_OKL_TAX_LINES_tbl          => p_OKL_TAX_LINES_tbl,
        x_OKL_TAX_LINES_tbl          => x_OKL_TAX_LINES_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3075


  END update_row;

Line: 3083


  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_tax_rec                      IN tax_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3091


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

Line: 3106


    DELETE FROM OKL_TAX_LINES
     WHERE ID = p_tax_rec.id;

Line: 3142


  END delete_row;

Line: 3146


  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_OKL_TAX_LINES_rec          IN OKL_TAX_LINES_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3155


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

Line: 3179


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

Line: 3224


  END delete_row;

Line: 3228


  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_OKL_TAX_LINES_tbl          IN OKL_TAX_LINES_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3238


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

Line: 3252


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_OKL_TAX_LINES_rec          => p_OKL_TAX_LINES_tbl(i));

Line: 3319


  END delete_row;

Line: 3324


  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_OKL_TAX_LINES_tbl          IN OKL_TAX_LINES_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3333


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

Line: 3340


      delete_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_OKL_TAX_LINES_tbl          => p_OKL_TAX_LINES_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3381


  END delete_row;