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

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

Line: 101


    SELECT
            ID,
            TCN_ID,
            NEW_CONTRACT_NUMBER,
            BILL_TO_SITE_ID,
            CUST_ACCT_ID,
            BANK_ACCT_ID,
            INVOICE_FORMAT_ID,
            PAYMENT_MTHD_ID,
            MLA_ID,
            CREDIT_LINE_ID,
            INSURANCE_YN,
            LEASE_POLICY_YN,
            IPY_TYPE,
            POLICY_NUMBER,
            COVERED_AMT,
            DEDUCTIBLE_AMT,
            EFFECTIVE_TO_DATE,
            EFFECTIVE_FROM_DATE,
            PROOF_PROVIDED_DATE,
            PROOF_REQUIRED_DATE,
            LESSOR_INSURED_YN,
            LESSOR_PAYEE_YN,
            INT_ID,
            ISU_ID,
            AGENCY_SITE_ID,
            AGENT_SITE_ID,
            TERRITORY_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_Taa_Request_Details_V
     WHERE okl_taa_request_details_v.id = p_id;

Line: 204


              l_taav_rec.last_updated_by,
              l_taav_rec.last_update_date,
              l_taav_rec.last_update_login;

Line: 248


    SELECT
            ID,
            TCN_ID,
            NEW_CONTRACT_NUMBER,
            BILL_TO_SITE_ID,
            CUST_ACCT_ID,
            BANK_ACCT_ID,
            INVOICE_FORMAT_ID,
            PAYMENT_MTHD_ID,
            MLA_ID,
            CREDIT_LINE_ID,
            INSURANCE_YN,
            LEASE_POLICY_YN,
            IPY_TYPE,
            POLICY_NUMBER,
            COVERED_AMT,
            DEDUCTIBLE_AMT,
            EFFECTIVE_TO_DATE,
            EFFECTIVE_FROM_DATE,
            PROOF_PROVIDED_DATE,
            PROOF_REQUIRED_DATE,
            LESSOR_INSURED_YN,
            LESSOR_PAYEE_YN,
            INT_ID,
            ISU_ID,
            AGENCY_SITE_ID,
            AGENT_SITE_ID,
            TERRITORY_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_Taa_Request_Details_B
     WHERE okl_taa_request_details_b.id = p_id;

Line: 351


              l_taa_rec.last_updated_by,
              l_taa_rec.last_update_date,
              l_taa_rec.last_update_login;

Line: 530


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

Line: 533


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

Line: 536


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

Line: 720


    p_to.last_updated_by := p_from.last_updated_by;

Line: 721


    p_to.last_update_date := p_from.last_update_date;

Line: 722


    p_to.last_update_login := p_from.last_update_login;

Line: 774


    p_to.last_updated_by := p_from.last_updated_by;

Line: 775


    p_to.last_update_date := p_from.last_update_date;

Line: 776


    p_to.last_update_login := p_from.last_update_login;

Line: 1022


  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_taa_rec                      IN taa_rec_type,
    x_taa_rec                      OUT NOCOPY taa_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1031


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

Line: 1067


    INSERT INTO OKL_TAA_REQUEST_DETAILS_B(
      id,
      tcn_id,
      new_contract_number,
      bill_to_site_id,
      cust_acct_id,
      bank_acct_id,
      invoice_format_id,
      payment_mthd_id,
      mla_id,
      credit_line_id,
      insurance_yn,
      lease_policy_yn,
      ipy_type,
      policy_number,
      covered_amt,
      deductible_amt,
      effective_to_date,
      effective_from_date,
      proof_provided_date,
      proof_required_date,
      lessor_insured_yn,
      lessor_payee_yn,
      int_id,
      isu_id,
      agency_site_id,
      agent_site_id,
      territory_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_taa_rec.id,
      l_taa_rec.tcn_id,
      l_taa_rec.new_contract_number,
      l_taa_rec.bill_to_site_id,
      l_taa_rec.cust_acct_id,
      l_taa_rec.bank_acct_id,
      l_taa_rec.invoice_format_id,
      l_taa_rec.payment_mthd_id,
      l_taa_rec.mla_id,
      l_taa_rec.credit_line_id,
      l_taa_rec.insurance_yn,
      l_taa_rec.lease_policy_yn,
      l_taa_rec.ipy_type,
      l_taa_rec.policy_number,
      l_taa_rec.covered_amt,
      l_taa_rec.deductible_amt,
      l_taa_rec.effective_to_date,
      l_taa_rec.effective_from_date,
      l_taa_rec.proof_provided_date,
      l_taa_rec.proof_required_date,
      l_taa_rec.lessor_insured_yn,
      l_taa_rec.lessor_payee_yn,
      l_taa_rec.int_id,
      l_taa_rec.isu_id,
      l_taa_rec.agency_site_id,
      l_taa_rec.agent_site_id,
      l_taa_rec.territory_code,
      l_taa_rec.attribute_category,
      l_taa_rec.attribute1,
      l_taa_rec.attribute2,
      l_taa_rec.attribute3,
      l_taa_rec.attribute4,
      l_taa_rec.attribute5,
      l_taa_rec.attribute6,
      l_taa_rec.attribute7,
      l_taa_rec.attribute8,
      l_taa_rec.attribute9,
      l_taa_rec.attribute10,
      l_taa_rec.attribute11,
      l_taa_rec.attribute12,
      l_taa_rec.attribute13,
      l_taa_rec.attribute14,
      l_taa_rec.attribute15,
      l_taa_rec.created_by,
      l_taa_rec.creation_date,
      l_taa_rec.last_updated_by,
      l_taa_rec.last_update_date,
      l_taa_rec.last_update_login);

Line: 1200


  END insert_row;

Line: 1204


  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_taav_rec                     IN taav_rec_type,
    x_taav_rec                     OUT NOCOPY taav_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1214


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

Line: 1230


      l_taav_rec.LAST_UPDATE_DATE := l_taav_rec.CREATION_DATE;

Line: 1231


      l_taav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1232


      l_taav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1295


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_taa_rec,
      lx_taa_rec
    );

Line: 1344


  END insert_row;

Line: 1348


  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_taav_tbl                     IN taav_tbl_type,
    x_taav_tbl                     OUT NOCOPY taav_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1359


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

Line: 1373


          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_taav_rec                     => p_taav_tbl(i),
            x_taav_rec                     => x_taav_tbl(i));

Line: 1441


  END insert_row;

Line: 1448


  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_taav_tbl                     IN taav_tbl_type,
    x_taav_tbl                     OUT NOCOPY taav_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1458


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

Line: 1465


      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_taav_tbl                     => p_taav_tbl,
        x_taav_tbl                     => x_taav_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1507


  END insert_row;

Line: 1525


    SELECT *
      FROM OKL_TAA_REQUEST_DETAILS_B
     WHERE ID = p_taa_rec.id
    FOR UPDATE NOWAIT;

Line: 1561


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1851


  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_taa_rec                      IN taa_rec_type,
    x_taa_rec                      OUT NOCOPY taa_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1860


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

Line: 2060


        IF (x_taa_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_taa_rec.last_updated_by := l_taa_rec.last_updated_by;

Line: 2064


        IF (x_taa_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_taa_rec.last_update_date := l_taa_rec.last_update_date;

Line: 2068


        IF (x_taa_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_taa_rec.last_update_login := l_taa_rec.last_update_login;

Line: 2113


    UPDATE OKL_TAA_REQUEST_DETAILS_B
    SET TCN_ID = l_def_taa_rec.tcn_id,
        NEW_CONTRACT_NUMBER = l_def_taa_rec.new_contract_number,
        BILL_TO_SITE_ID = l_def_taa_rec.bill_to_site_id,
        CUST_ACCT_ID = l_def_taa_rec.cust_acct_id,
        BANK_ACCT_ID = l_def_taa_rec.bank_acct_id,
        INVOICE_FORMAT_ID = l_def_taa_rec.invoice_format_id,
        PAYMENT_MTHD_ID = l_def_taa_rec.payment_mthd_id,
        MLA_ID = l_def_taa_rec.mla_id,
        CREDIT_LINE_ID = l_def_taa_rec.credit_line_id,
        INSURANCE_YN = l_def_taa_rec.insurance_yn,
        LEASE_POLICY_YN = l_def_taa_rec.lease_policy_yn,
        IPY_TYPE = l_def_taa_rec.ipy_type,
        POLICY_NUMBER = l_def_taa_rec.policy_number,
        COVERED_AMT = l_def_taa_rec.covered_amt,
        DEDUCTIBLE_AMT = l_def_taa_rec.deductible_amt,
        EFFECTIVE_TO_DATE = l_def_taa_rec.effective_to_date,
        EFFECTIVE_FROM_DATE = l_def_taa_rec.effective_from_date,
        PROOF_PROVIDED_DATE = l_def_taa_rec.proof_provided_date,
        PROOF_REQUIRED_DATE = l_def_taa_rec.proof_required_date,
        LESSOR_INSURED_YN = l_def_taa_rec.lessor_insured_yn,
        LESSOR_PAYEE_YN = l_def_taa_rec.lessor_payee_yn,
        INT_ID = l_def_taa_rec.int_id,
        ISU_ID = l_def_taa_rec.isu_id,
        AGENCY_SITE_ID = l_def_taa_rec.agency_site_id,
        AGENT_SITE_ID = l_def_taa_rec.agent_site_id,
        TERRITORY_CODE = l_def_taa_rec.territory_code,
        ATTRIBUTE_CATEGORY = l_def_taa_rec.attribute_category,
        ATTRIBUTE1 = l_def_taa_rec.attribute1,
        ATTRIBUTE2 = l_def_taa_rec.attribute2,
        ATTRIBUTE3 = l_def_taa_rec.attribute3,
        ATTRIBUTE4 = l_def_taa_rec.attribute4,
        ATTRIBUTE5 = l_def_taa_rec.attribute5,
        ATTRIBUTE6 = l_def_taa_rec.attribute6,
        ATTRIBUTE7 = l_def_taa_rec.attribute7,
        ATTRIBUTE8 = l_def_taa_rec.attribute8,
        ATTRIBUTE9 = l_def_taa_rec.attribute9,
        ATTRIBUTE10 = l_def_taa_rec.attribute10,
        ATTRIBUTE11 = l_def_taa_rec.attribute11,
        ATTRIBUTE12 = l_def_taa_rec.attribute12,
        ATTRIBUTE13 = l_def_taa_rec.attribute13,
        ATTRIBUTE14 = l_def_taa_rec.attribute14,
        ATTRIBUTE15 = l_def_taa_rec.attribute15,
        CREATED_BY = l_def_taa_rec.created_by,
        CREATION_DATE = l_def_taa_rec.creation_date,
        LAST_UPDATED_BY = l_def_taa_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_taa_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_taa_rec.last_update_login
    WHERE ID = l_def_taa_rec.id;

Line: 2197


  END update_row;

Line: 2201


  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_taav_rec                     IN taav_rec_type,
    x_taav_rec                     OUT NOCOPY taav_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2211


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

Line: 2226


      l_taav_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2227


      l_taav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2228


      l_taav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2427


        IF (x_taav_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_taav_rec.last_updated_by := l_db_taav_rec.last_updated_by;

Line: 2431


        IF (x_taav_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_taav_rec.last_update_date := l_db_taav_rec.last_update_date;

Line: 2435


        IF (x_taav_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_taav_rec.last_update_login := l_db_taav_rec.last_update_login;

Line: 2520


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_taa_rec,
      lx_taa_rec
    );

Line: 2568


  END update_row;

Line: 2572


  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_taav_tbl                     IN taav_tbl_type,
    x_taav_tbl                     OUT NOCOPY taav_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2583


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

Line: 2597


          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_taav_rec                     => p_taav_tbl(i),
            x_taav_rec                     => x_taav_tbl(i));

Line: 2665


  END update_row;

Line: 2672


  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_taav_tbl                     IN taav_tbl_type,
    x_taav_tbl                     OUT NOCOPY taav_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2682


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

Line: 2689


      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_taav_tbl                     => p_taav_tbl,
        x_taav_tbl                     => x_taav_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2731


  END update_row;

Line: 2739


  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_taa_rec                      IN taa_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2747


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

Line: 2762


    DELETE FROM OKL_TAA_REQUEST_DETAILS_B
     WHERE ID = p_taa_rec.id;

Line: 2798


  END delete_row;

Line: 2802


  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_taav_rec                     IN taav_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2811


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

Line: 2835


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

Line: 2880


  END delete_row;

Line: 2884


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2894


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

Line: 2908


          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_taav_rec                     => p_taav_tbl(i));

Line: 2975


  END delete_row;

Line: 2980


  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_taav_tbl                     IN taav_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2989


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

Line: 2996


      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_taav_tbl                     => p_taav_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3037


  END delete_row;