APPS.OKL_TAP_PVT SQL Statements

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

Line: 567

    SELECT 'x'
	FROM fnd_currencies_vl
	WHERE currency_code = p_tapv_rec.currency_code;

Line: 630

      SELECT 'x'
      FROM OKX_VENDOR_SITES_V
      WHERE id1 = p_tapv_rec.ipvs_id;

Line: 693

      SELECT 'x'
      FROM OKX_CODE_COMBINATIONS_V
      WHERE id = p_tapv_rec.code_combination_id;

Line: 762

      SELECT 'x'
      FROM OKL_TRX_AP_INVOICES_V
      WHERE id = p_tapv_rec.tap_id_reverses;

Line: 827

      SELECT 'x'
      FROM OKC_K_PARTY_ROLES_V
      WHERE id = p_tapv_rec.cplv_id;

Line: 892

      SELECT 'x'
      FROM OKL_TRX_QUOTES_V
      WHERE id = p_tapv_rec.qte_id;

Line: 957

      SELECT 'x'
      FROM OKL_TRX_CONTRACTS
      WHERE id = p_tapv_rec.tcn_id;

Line: 1023

      SELECT 'x'
      FROM OKX_PAYABLES_PAYMENT_TERMS_V
      WHERE id = p_tapv_rec.ippt_id;

Line: 1092

      SELECT 'x'
      FROM OKL_ASSET_RETURNS_V
      WHERE id = p_tapv_rec.art_id;

Line: 1162

      SELECT 'x'
      FROM OKL_K_HEADERS
      WHERE id = p_tapv_rec.khr_id;

Line: 1227

      SELECT 'x'
      FROM OKL_CSE_K_REFUNDS_V
      WHERE id = p_tapv_rec.ccf_id;

Line: 1293

      SELECT 'x'
      FROM OKL_CSE_COSTS_V
      WHERE id = p_tapv_rec.cct_id;

Line: 1359

      SELECT 'x'
      FROM OKL_TRX_TYPES_V
      WHERE id = p_tapv_rec.try_id;

Line: 1421

      SELECT 'x'
      FROM GL_LEDGERS_PUBLIC_V
      WHERE ledger_id = p_tapv_rec.set_of_books_id;

Line: 1486

    SELECT '1'
	FROM OKL_POOL_TRANSACTIONS
	WHERE id = p_tapv_rec.pox_id;

Line: 1575

    SELECT '1'
	FROM OKL_TRX_AP_INVOICES_V
	WHERE id = p_tapv_rec.asset_tap_id;

Line: 1636

    DELETE FROM OKL_TRX_AP_INVOICES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_TRX_AP_INVS_ALL_B B
         WHERE B.ID = T.ID
         AND T.LANGUAGE = USERENV('LANG')
        );

Line: 1643

    UPDATE OKL_TRX_AP_INVOICES_TL T SET (
        DESCRIPTION) = (SELECT
                                  B.DESCRIPTION
                                FROM OKL_TRX_AP_INVOICES_TL B
                               WHERE B.ID = T.ID
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE (
              T.ID,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.ID,
                  SUBT.LANGUAGE
                FROM OKL_TRX_AP_INVOICES_TL SUBB, OKL_TRX_AP_INVOICES_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
                      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
                      OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
              ));

Line: 1662

    INSERT INTO OKL_TRX_AP_INVOICES_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        DESCRIPTION,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.DESCRIPTION,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKL_TRX_AP_INVOICES_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS(
                    SELECT NULL
                      FROM OKL_TRX_AP_INVOICES_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 1702

    SELECT
            ID,
            CURRENCY_CODE,
            PAYMENT_METHOD_CODE,
            FUNDING_TYPE_CODE,
            INVOICE_CATEGORY_CODE,
            IPVS_ID,
            KHR_ID,
            CCF_ID,
            CCT_ID,
            CPLV_ID,
            POX_ID,
            IPPT_ID,
            code_combination_id,
            QTE_ID,
            ART_ID,
            TCN_ID,
            TAP_ID_REVERSES,
            DATE_ENTERED,
            DATE_INVOICED,
            AMOUNT,
            TRX_STATUS_CODE,  -- Post Postgen 14,15
            SET_OF_BOOKS_ID,  -- Post Postgen 14,15
            TRY_ID,           -- Post Postgen 14,15
            OBJECT_VERSION_NUMBER,
            DATE_REQUISITION,
            DATE_FUNDING_APPROVED,
            INVOICE_NUMBER,
            DATE_GL,
            WORKFLOW_YN,
            CONSOLIDATE_YN,
            WAIT_VENDOR_INVOICE_YN,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ORG_ID,
            CURRENCY_CONVERSION_TYPE,
            CURRENCY_CONVERSION_RATE,
            CURRENCY_CONVERSION_DATE,
            VENDOR_ID,
            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,
            INVOICE_TYPE,
            PAY_GROUP_LOOKUP_CODE,
            VENDOR_INVOICE_NUMBER,
            NETTABLE_YN,
            ASSET_TAP_ID,
 -- 30-OCT-2006 ANSETHUR  R12B - Legal Entity
            legal_entity_id
            ,transaction_date
      FROM Okl_Trx_Ap_Invoices_B
     WHERE okl_trx_ap_invoices_b.id = p_id;

Line: 1815

              l_tap_rec.PROGRAM_UPDATE_DATE,
              l_tap_rec.ORG_ID,
              l_tap_rec.CURRENCY_CONVERSION_TYPE,
              l_tap_rec.CURRENCY_CONVERSION_RATE,
              l_tap_rec.CURRENCY_CONVERSION_DATE,
              l_tap_rec.VENDOR_ID,
              l_tap_rec.ATTRIBUTE_CATEGORY,
              l_tap_rec.ATTRIBUTE1,
              l_tap_rec.ATTRIBUTE2,
              l_tap_rec.ATTRIBUTE3,
              l_tap_rec.ATTRIBUTE4,
              l_tap_rec.ATTRIBUTE5,
              l_tap_rec.ATTRIBUTE6,
              l_tap_rec.ATTRIBUTE7,
              l_tap_rec.ATTRIBUTE8,
              l_tap_rec.ATTRIBUTE9,
              l_tap_rec.ATTRIBUTE10,
              l_tap_rec.ATTRIBUTE11,
              l_tap_rec.ATTRIBUTE12,
              l_tap_rec.ATTRIBUTE13,
              l_tap_rec.ATTRIBUTE14,
              l_tap_rec.ATTRIBUTE15,
              l_tap_rec.CREATED_BY,
              l_tap_rec.CREATION_DATE,
              l_tap_rec.LAST_UPDATED_BY,
              l_tap_rec.LAST_UPDATE_DATE,
              l_tap_rec.LAST_UPDATE_LOGIN,
              l_tap_rec.INVOICE_TYPE,
              l_tap_rec.PAY_GROUP_LOOKUP_CODE,
              l_tap_rec.VENDOR_INVOICE_NUMBER,
              l_tap_rec.NETTABLE_YN,
              l_tap_rec.asset_tap_id,
 -- 30-OCT-2006 ANSETHUR  R12B - Legal Entity
              l_tap_rec.legal_entity_id
              ,l_tap_rec.transaction_date;

Line: 1870

    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Trx_Ap_Invoices_Tl
     WHERE okl_trx_ap_invoices_tl.id = p_id
       AND okl_trx_ap_invoices_tl.language = p_language;

Line: 1899

              l_okl_trx_ap_invoices_tl_rec.LAST_UPDATED_BY,
              l_okl_trx_ap_invoices_tl_rec.LAST_UPDATE_DATE,
              l_okl_trx_ap_invoices_tl_rec.LAST_UPDATE_LOGIN;

Line: 1921

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            CCT_ID,
            CURRENCY_CODE,
            CCF_ID,
            FUNDING_TYPE_CODE,
            KHR_ID,
            ART_ID,
            TAP_ID_REVERSES,
            IPPT_ID,
            code_combination_id,
            IPVS_ID,
            TCN_ID,
            QTE_ID,
            INVOICE_CATEGORY_CODE,
            PAYMENT_METHOD_CODE,
            CPLV_ID,
            POX_ID,
            AMOUNT,
            DATE_INVOICED,
            INVOICE_NUMBER,
            DATE_FUNDING_APPROVED,
            DATE_GL,
            WORKFLOW_YN,
            CONSOLIDATE_YN,
            WAIT_VENDOR_INVOICE_YN,
            DATE_REQUISITION,
            DESCRIPTION,
            CURRENCY_CONVERSION_TYPE,
            CURRENCY_CONVERSION_RATE,
            CURRENCY_CONVERSION_DATE,
            VENDOR_ID,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            DATE_ENTERED,
            TRX_STATUS_CODE,  -- Post Postgen 14,15
            SET_OF_BOOKS_ID,  -- Post Postgen 14,15
            TRY_ID,           -- Post Postgen 14,15
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ORG_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            INVOICE_TYPE,
            PAY_GROUP_LOOKUP_CODE,
            VENDOR_INVOICE_NUMBER,
            NETTABLE_YN,
            ASSET_TAP_ID,
 -- 30-OCT-2006 ANSETHUR  R12B - Legal Entity
              legal_entity_id
              ,transaction_date
      FROM Okl_Trx_Ap_Invoices_V
     WHERE okl_trx_ap_invoices_v.id = p_id;

Line: 2058

              l_tapv_rec.PROGRAM_UPDATE_DATE,
              l_tapv_rec.ORG_ID,
              l_tapv_rec.CREATED_BY,
              l_tapv_rec.CREATION_DATE,
              l_tapv_rec.LAST_UPDATED_BY,
              l_tapv_rec.LAST_UPDATE_DATE,
              l_tapv_rec.LAST_UPDATE_LOGIN,
              l_tapv_rec.INVOICE_TYPE,
              l_tapv_rec.PAY_GROUP_LOOKUP_CODE,
              l_tapv_rec.VENDOR_INVOICE_NUMBER,
              l_tapv_rec.NETTABLE_YN,
              l_tapv_rec.asset_tap_id,
 -- 30-OCT-2006 ANSETHUR  R12B - Legal Entity
              l_tapv_rec.legal_entity_id
              ,l_tapv_rec.transaction_date;

Line: 2275

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

Line: 2287

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

Line: 2290

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

Line: 2293

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

Line: 2731

    SELECT
            ID,OBJECT_VERSION_NUMBER,SFWT_FLAG,CHR_ID,CPL_ID,CLE_ID,RLE_CODE,
            DNZ_CHR_ID,OBJECT1_ID1,OBJECT1_ID2,JTOT_OBJECT1_CODE,COGNOMEN,CODE,
            FACILITY,MINORITY_GROUP_LOOKUP_CODE,SMALL_BUSINESS_FLAG,WOMEN_OWNED_FLAG,
            ALIAS,ROLE,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 OKC_K_PARTY_ROLES_V
     WHERE OKC_K_PARTY_ROLES_V.id = p_id;

Line: 2809

    p_to.program_update_date := p_from.program_update_date;

Line: 2833

    p_to.last_updated_by := p_from.last_updated_by;

Line: 2834

    p_to.last_update_date := p_from.last_update_date;

Line: 2835

    p_to.last_update_login := p_from.last_update_login;

Line: 2889

    p_to.program_update_date := p_from.program_update_date;

Line: 2913

    p_to.last_updated_by := p_from.last_updated_by;

Line: 2914

    p_to.last_update_date := p_from.last_update_date;

Line: 2915

    p_to.last_update_login := p_from.last_update_login;

Line: 2936

    p_to.last_updated_by := p_from.last_updated_by;

Line: 2937

    p_to.last_update_date := p_from.last_update_date;

Line: 2938

    p_to.last_update_login := p_from.last_update_login;

Line: 2950

    p_to.last_updated_by := p_from.last_updated_by;

Line: 2951

    p_to.last_update_date := p_from.last_update_date;

Line: 2952

    p_to.last_update_login := p_from.last_update_login;

Line: 3110

  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_tap_rec                      IN tap_rec_type,
    x_tap_rec                      OUT NOCOPY tap_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 3118

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

Line: 3154

    INSERT INTO OKL_TRX_AP_INVOICES_B(
        id,
        currency_code,
        payment_method_code,
        funding_type_code,
        invoice_category_code,
        ipvs_id,
        khr_id,
        ccf_id,
        cct_id,
        cplv_id,
        pox_id,
        ippt_id,
        code_combination_id,
        qte_id,
        art_id,
        tcn_id,
        vpa_id,
        ipt_id,
        tap_id_reverses,
        date_entered,
        date_invoiced,
        amount,
        trx_status_code, -- Post Postgen 14,15
        set_of_books_id, -- Post Postgen 14,15
        try_id,          -- Post Postgen 14,15
        object_version_number,
        date_requisition,
        date_funding_approved,
        invoice_number,
        date_gl,
        workflow_yn,
        match_required_yn,
        ipt_frequency,
        consolidate_yn,
        wait_vendor_invoice_yn,
        request_id,
        program_application_id,
        program_id,
        program_update_date,
        org_id,
        CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE,
        vendor_id,
        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,
        invoice_type,
        pay_group_lookup_code,
        vendor_invoice_number,
        nettable_yn,
        asset_tap_id,
 -- 30-OCT-2006 ANSETHUR  R12B - Legal Entity
        legal_entity_id
        ,transaction_date
        )
      VALUES (
        l_tap_rec.id,
        l_tap_rec.currency_code,
        l_tap_rec.payment_method_code,
        l_tap_rec.funding_type_code,
        l_tap_rec.invoice_category_code,
        l_tap_rec.ipvs_id,
        l_tap_rec.khr_id,
        l_tap_rec.ccf_id,
        l_tap_rec.cct_id,
        l_tap_rec.cplv_id,
        l_tap_rec.pox_id,
        l_tap_rec.ippt_id,
        l_tap_rec.code_combination_id,
        l_tap_rec.qte_id,
        l_tap_rec.art_id,
        l_tap_rec.tcn_id,
        l_tap_rec.vpa_id,
        l_tap_rec.ipt_id,
        l_tap_rec.tap_id_reverses,
        l_tap_rec.date_entered,
        l_tap_rec.date_invoiced,
        l_tap_rec.amount,
        l_tap_rec.trx_status_code, -- Post Postgen 14,15
        l_tap_rec.set_of_books_id, -- Post Postgen 14,15
        l_tap_rec.try_id,          -- Post Postgen 14,15
        l_tap_rec.object_version_number,
        l_tap_rec.date_requisition,
        l_tap_rec.date_funding_approved,
        l_tap_rec.invoice_number,
        l_tap_rec.date_gl,
        l_tap_rec.workflow_yn,
        l_tap_rec.match_required_yn,
        l_tap_rec.ipt_frequency,
        l_tap_rec.consolidate_yn,
        l_tap_rec.wait_vendor_invoice_yn,
        l_tap_rec.request_id,
        l_tap_rec.program_application_id,
        l_tap_rec.program_id,
        l_tap_rec.program_update_date,
        l_tap_rec.org_id,
        l_tap_rec.CURRENCY_CONVERSION_TYPE,
        l_tap_rec.CURRENCY_CONVERSION_RATE,
        l_tap_rec.CURRENCY_CONVERSION_DATE,
        l_tap_rec.vendor_id,
        l_tap_rec.attribute_category,
        l_tap_rec.attribute1,
        l_tap_rec.attribute2,
        l_tap_rec.attribute3,
        l_tap_rec.attribute4,
        l_tap_rec.attribute5,
        l_tap_rec.attribute6,
        l_tap_rec.attribute7,
        l_tap_rec.attribute8,
        l_tap_rec.attribute9,
        l_tap_rec.attribute10,
        l_tap_rec.attribute11,
        l_tap_rec.attribute12,
        l_tap_rec.attribute13,
        l_tap_rec.attribute14,
        l_tap_rec.attribute15,
        l_tap_rec.created_by,
        l_tap_rec.creation_date,
        l_tap_rec.last_updated_by,
        l_tap_rec.last_update_date,
        l_tap_rec.last_update_login,
        l_tap_rec.invoice_type,
        l_tap_rec.pay_group_lookup_code,
        l_tap_rec.vendor_invoice_number,
        l_tap_rec.nettable_yn,
        l_tap_rec.asset_tap_id,
 -- 30-OCT-2006 ANSETHUR  R12B - Legal Entity
        l_tap_rec.legal_entity_id
        ,NVL(l_tap_rec.transaction_date,SYSDATE)
        );

Line: 3338

  END insert_row;

Line: 3342

  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_okl_trx_ap_invoices_tl_rec   IN OklTrxApInvoicesTlRecType,
    x_okl_trx_ap_invoices_tl_rec   OUT NOCOPY OklTrxApInvoicesTlRecType) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 3350

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

Line: 3355

      SELECT *
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');

Line: 3394

      INSERT INTO OKL_TRX_AP_INVOICES_TL(
          id,
          language,
          source_lang,
          sfwt_flag,
          description,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okl_trx_ap_invoices_tl_rec.id,
          l_okl_trx_ap_invoices_tl_rec.language,
          l_okl_trx_ap_invoices_tl_rec.source_lang,
          l_okl_trx_ap_invoices_tl_rec.sfwt_flag,
          l_okl_trx_ap_invoices_tl_rec.description,
          l_okl_trx_ap_invoices_tl_rec.created_by,
          l_okl_trx_ap_invoices_tl_rec.creation_date,
          l_okl_trx_ap_invoices_tl_rec.last_updated_by,
          l_okl_trx_ap_invoices_tl_rec.last_update_date,
          l_okl_trx_ap_invoices_tl_rec.last_update_login);

Line: 3451

  END insert_row;

Line: 3455

  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_tapv_rec                     IN tapv_rec_type,
    x_tapv_rec                     OUT NOCOPY tapv_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 3464

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

Line: 3482

      l_tapv_rec.LAST_UPDATE_DATE := l_tapv_rec.CREATION_DATE;

Line: 3483

      l_tapv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3484

      l_tapv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3500

      SELECT
        DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
        DECODE(Fnd_Global.PROG_APPL_ID,   -1,NULL,Fnd_Global.PROG_APPL_ID),
        DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
        DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
      INTO
        x_tapv_rec.request_id,
        x_tapv_rec.program_application_id,
        x_tapv_rec.program_id,
        x_tapv_rec.program_update_date
      FROM   dual;

Line: 3563

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tap_rec,
      lx_tap_rec
    );

Line: 3577

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_trx_ap_invoices_tl_rec,
      lx_okl_trx_ap_invoices_tl_rec
    );

Line: 3625

  END insert_row;

Line: 3629

  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_tapv_tbl                     IN tapv_tbl_type,
    x_tapv_tbl                     OUT NOCOPY tapv_tbl_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 3638

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

Line: 3648

        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_tapv_rec                     => p_tapv_tbl(i),
          x_tapv_rec                     => x_tapv_tbl(i));

Line: 3698

  END insert_row;

Line: 3714

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_AP_INVOICES_B
     WHERE ID = p_tap_rec.id
       AND OBJECT_VERSION_NUMBER = p_tap_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 3720

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_AP_INVOICES_B
    WHERE ID = p_tap_rec.id;

Line: 3760

      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 3769

      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 3817

    SELECT *
      FROM OKL_TRX_AP_INVOICES_TL
     WHERE ID = p_okl_trx_ap_invoices_tl_rec.id
    FOR UPDATE NOWAIT;

Line: 3851

      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 4057

  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_tap_rec                      IN tap_rec_type,
    x_tap_rec                      OUT NOCOPY tap_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 4065

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

Line: 4245

      IF (x_tap_rec.program_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_tap_rec.program_update_date := l_tap_rec.program_update_date;

Line: 4339

      IF (x_tap_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_tap_rec.last_updated_by := l_tap_rec.last_updated_by;

Line: 4343

      IF (x_tap_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_tap_rec.last_update_date := l_tap_rec.last_update_date;

Line: 4347

      IF (x_tap_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_tap_rec.last_update_login := l_tap_rec.last_update_login;

Line: 4420

    UPDATE  OKL_TRX_AP_INVOICES_B
    SET CURRENCY_CODE = l_def_tap_rec.currency_code,
        PAYMENT_METHOD_CODE = l_def_tap_rec.payment_method_code,
        FUNDING_TYPE_CODE = l_def_tap_rec.funding_type_code,
        INVOICE_CATEGORY_CODE = l_def_tap_rec.invoice_category_code,
        IPVS_ID = l_def_tap_rec.ipvs_id,
        KHR_ID = l_def_tap_rec.khr_id,
        CCF_ID = l_def_tap_rec.ccf_id,
        CCT_ID = l_def_tap_rec.cct_id,
        CPLV_ID = l_def_tap_rec.cplv_id,
        POX_ID = l_def_tap_rec.pox_id,
        IPPT_ID = l_def_tap_rec.ippt_id,
        code_combination_id = l_def_tap_rec.code_combination_id,
        QTE_ID = l_def_tap_rec.qte_id,
        ART_ID = l_def_tap_rec.art_id,
        TCN_ID = l_def_tap_rec.tcn_id,
        TAP_ID_REVERSES = l_def_tap_rec.tap_id_reverses,
        DATE_ENTERED = l_def_tap_rec.date_entered,
        DATE_INVOICED = l_def_tap_rec.date_invoiced,
        AMOUNT = l_def_tap_rec.amount,
        TRX_STATUS_CODE = l_def_tap_rec.trx_status_code, -- Post Postgen 14,15
        SET_OF_BOOKS_ID = l_def_tap_rec.set_of_books_id, -- Post Postgen 14,15
        TRY_ID = l_def_tap_rec.try_id,                   -- Post Postgen 14,15
        OBJECT_VERSION_NUMBER = l_def_tap_rec.object_version_number,
        DATE_REQUISITION = l_def_tap_rec.date_requisition,
        DATE_FUNDING_APPROVED = l_def_tap_rec.date_funding_approved,
        INVOICE_NUMBER = l_def_tap_rec.invoice_number,
        DATE_GL = l_def_tap_rec.date_gl,
        WORKFLOW_YN = l_def_tap_rec.workflow_yn,
        MATCH_REQUIRED_YN = l_def_tap_rec.match_required_yn,
        IPT_FREQUENCY = l_def_tap_rec.ipt_frequency,
        CONSOLIDATE_YN = l_def_tap_rec.consolidate_yn,
        WAIT_VENDOR_INVOICE_YN = l_def_tap_rec.wait_vendor_invoice_yn,
        REQUEST_ID = l_def_tap_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_tap_rec.program_application_id,
        PROGRAM_ID = l_def_tap_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_tap_rec.program_update_date,
        ORG_ID = l_def_tap_rec.org_id,
        CURRENCY_CONVERSION_TYPE = l_def_tap_rec.CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE = l_def_tap_rec.CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE = l_def_tap_rec.CURRENCY_CONVERSION_DATE,
        VENDOR_ID          = l_def_tap_rec.vendor_id,
        ATTRIBUTE_CATEGORY = l_def_tap_rec.attribute_category,
        ATTRIBUTE1 = l_def_tap_rec.attribute1,
        ATTRIBUTE2 = l_def_tap_rec.attribute2,
        ATTRIBUTE3 = l_def_tap_rec.attribute3,
        ATTRIBUTE4 = l_def_tap_rec.attribute4,
        ATTRIBUTE5 = l_def_tap_rec.attribute5,
        ATTRIBUTE6 = l_def_tap_rec.attribute6,
        ATTRIBUTE7 = l_def_tap_rec.attribute7,
        ATTRIBUTE8 = l_def_tap_rec.attribute8,
        ATTRIBUTE9 = l_def_tap_rec.attribute9,
        ATTRIBUTE10 = l_def_tap_rec.attribute10,
        ATTRIBUTE11 = l_def_tap_rec.attribute11,
        ATTRIBUTE12 = l_def_tap_rec.attribute12,
        ATTRIBUTE13 = l_def_tap_rec.attribute13,
        ATTRIBUTE14 = l_def_tap_rec.attribute14,
        ATTRIBUTE15 = l_def_tap_rec.attribute15,
        CREATED_BY = l_def_tap_rec.created_by,
        CREATION_DATE = l_def_tap_rec.creation_date,
        LAST_UPDATED_BY = l_def_tap_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_tap_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_tap_rec.last_update_login,
        INVOICE_TYPE = l_def_tap_rec.invoice_type,
        PAY_GROUP_LOOKUP_CODE = l_def_tap_rec.pay_group_lookup_code,
        VENDOR_INVOICE_NUMBER = l_def_tap_rec.vendor_invoice_number,
        NETTABLE_YN = l_def_tap_rec.nettable_yn,
        ASSET_TAP_ID = l_def_tap_rec.asset_tap_id,                   -- Post Postgen 14,15
 -- 30-OCT-2006 ANSETHUR  R12B - Legal Entity
       legal_entity_id = l_def_tap_rec.legal_entity_id
       ,transaction_date = l_def_tap_rec.transaction_date
    WHERE ID = l_def_tap_rec.id;

Line: 4525

  END update_row;

Line: 4529

  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_okl_trx_ap_invoices_tl_rec   IN OklTrxApInvoicesTlRecType,
    x_okl_trx_ap_invoices_tl_rec   OUT NOCOPY OklTrxApInvoicesTlRecType) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 4537

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

Line: 4587

      IF (x_okl_trx_ap_invoices_tl_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_okl_trx_ap_invoices_tl_rec.last_updated_by := l_okl_trx_ap_invoices_tl_rec.last_updated_by;

Line: 4591

      IF (x_okl_trx_ap_invoices_tl_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_okl_trx_ap_invoices_tl_rec.last_update_date := l_okl_trx_ap_invoices_tl_rec.last_update_date;

Line: 4595

      IF (x_okl_trx_ap_invoices_tl_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_okl_trx_ap_invoices_tl_rec.last_update_login := l_okl_trx_ap_invoices_tl_rec.last_update_login;

Line: 4641

    UPDATE  OKL_TRX_AP_INVOICES_TL
    SET DESCRIPTION = ldefokltrxapinvoicestlrec.description,
        SOURCE_LANG = ldefokltrxapinvoicestlrec.source_lang,
        CREATED_BY = ldefokltrxapinvoicestlrec.created_by,
        CREATION_DATE = ldefokltrxapinvoicestlrec.creation_date,
        LAST_UPDATED_BY = ldefokltrxapinvoicestlrec.last_updated_by,
        LAST_UPDATE_DATE = ldefokltrxapinvoicestlrec.last_update_date,
        LAST_UPDATE_LOGIN = ldefokltrxapinvoicestlrec.last_update_login
    WHERE ID = ldefokltrxapinvoicestlrec.id
    AND USERENV('LANG') in (SOURCE_LANG, LANGUAGE);

Line: 4652

    UPDATE  OKL_TRX_AP_INVOICES_TL
    SET SFWT_FLAG = 'Y'
    WHERE ID = ldefokltrxapinvoicestlrec.id
      AND SOURCE_LANG <> USERENV('LANG');

Line: 4689

  END update_row;

Line: 4693

  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_tapv_rec                     IN tapv_rec_type,
    x_tapv_rec                     OUT NOCOPY tapv_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 4702

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

Line: 4718

      l_tapv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 4719

      l_tapv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 4720

      l_tapv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 4982

      IF (x_tapv_rec.program_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_tapv_rec.program_update_date := l_tapv_rec.program_update_date;

Line: 4998

      IF (x_tapv_rec.last_updated_by = OKL_API.G_MISS_NUM)
      THEN
        x_tapv_rec.last_updated_by := l_tapv_rec.last_updated_by;

Line: 5002

      IF (x_tapv_rec.last_update_date = OKL_API.G_MISS_DATE)
      THEN
        x_tapv_rec.last_update_date := l_tapv_rec.last_update_date;

Line: 5006

      IF (x_tapv_rec.last_update_login = OKL_API.G_MISS_NUM)
      THEN
        x_tapv_rec.last_update_login := l_tapv_rec.last_update_login;

Line: 5056

      SELECT
        NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
            x_tapv_rec.request_id),
        NVL(DECODE(Fnd_Global.PROG_APPL_ID,   -1,NULL,Fnd_Global.PROG_APPL_ID),
            x_tapv_rec.program_application_id),
        NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
            x_tapv_rec.program_id),
        DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
            NULL,x_tapv_rec.program_update_date,SYSDATE)
      INTO
        x_tapv_rec.request_id,
        x_tapv_rec.program_application_id,
        x_tapv_rec.program_id,
        x_tapv_rec.program_update_date
      FROM   dual;

Line: 5126

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_trx_ap_invoices_tl_rec,
      lx_okl_trx_ap_invoices_tl_rec
    );

Line: 5140

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tap_rec,
      lx_tap_rec
    );

Line: 5187

  END update_row;

Line: 5191

  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_tapv_tbl                     IN tapv_tbl_type,
    x_tapv_tbl                     OUT NOCOPY tapv_tbl_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 5200

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

Line: 5210

        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_tapv_rec                     => p_tapv_tbl(i),
          x_tapv_rec                     => x_tapv_tbl(i));

Line: 5260

  END update_row;

Line: 5267

  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_tap_rec                      IN tap_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 5274

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

Line: 5288

    DELETE FROM OKL_TRX_AP_INVOICES_B
     WHERE ID = l_tap_rec.id;

Line: 5322

  END delete_row;

Line: 5326

  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_okl_trx_ap_invoices_tl_rec   IN OklTrxApInvoicesTlRecType) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 5333

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

Line: 5370

    DELETE FROM OKL_TRX_AP_INVOICES_TL
     WHERE ID = l_okl_trx_ap_invoices_tl_rec.id;

Line: 5404

  END delete_row;

Line: 5408

  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_tapv_rec                     IN tapv_rec_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 5416

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

Line: 5442

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_trx_ap_invoices_tl_rec
    );

Line: 5454

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tap_rec
    );

Line: 5498

  END delete_row;

Line: 5502

  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_tapv_tbl                     IN tapv_tbl_type) IS
    l_api_version                 CONSTANT NUMBER := 1;

Line: 5510

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

Line: 5520

        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_tapv_rec                     => p_tapv_tbl(i));

Line: 5569

  END delete_row;