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

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

Line: 5


  SELECT dnz_chr_id
  FROM   okc_k_party_roles_b WHERE
         id = p_cpl_id;

Line: 108


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CPL_ID,
            VENDOR_ID,
            PAY_SITE_ID,
            PAYMENT_TERM_ID,
            PAYMENT_METHOD_CODE,
            PAY_GROUP_CODE,
			PAYMENT_HDR_ID,
			PAYMENT_START_DATE,
			PAYMENT_FREQUENCY,
			REMIT_DAYS,
			DISBURSEMENT_BASIS,
			DISBURSEMENT_FIXED_AMOUNT,
			DISBURSEMENT_PERCENT,
			PROCESSING_FEE_BASIS,
			PROCESSING_FEE_FIXED_AMOUNT,
			PROCESSING_FEE_PERCENT,
			--INCLUDE_IN_YIELD_FLAG,
			--PROCESSING_FEE_FORMULA,
			PAYMENT_BASIS,
            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,
            ORIG_CONTRACT_LINE_ID
      FROM Okl_Party_Payment_Dtls_V
     WHERE okl_party_payment_dtls_v.id = p_id;

Line: 200


              l_ppydv_rec.last_updated_by,
              l_ppydv_rec.last_update_date,
              l_ppydv_rec.last_update_login,
			  l_ppydv_rec.ORIG_CONTRACT_LINE_ID;

Line: 245


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CPL_ID,
            VENDOR_ID,
            PAY_SITE_ID,
            PAYMENT_TERM_ID,
            PAYMENT_METHOD_CODE,
            PAY_GROUP_CODE,
			PAYMENT_HDR_ID,
			PAYMENT_START_DATE,
			PAYMENT_FREQUENCY,
			REMIT_DAYS,
			DISBURSEMENT_BASIS,
			DISBURSEMENT_FIXED_AMOUNT,
			DISBURSEMENT_PERCENT,
			PROCESSING_FEE_BASIS,
			PROCESSING_FEE_FIXED_AMOUNT,
			PROCESSING_FEE_PERCENT,
			--INCLUDE_IN_YIELD_FLAG,
			--PROCESSING_FEE_FORMULA,
			PAYMENT_BASIS,
            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,
            ORIG_CONTRACT_LINE_ID
      FROM Okl_Party_Payment_Dtls
     WHERE okl_party_payment_dtls.id = p_id;

Line: 337


              l_ppyd_rec.last_updated_by,
              l_ppyd_rec.last_update_date,
              l_ppyd_rec.last_update_login,
			  l_ppyd_rec.ORIG_CONTRACT_LINE_ID;

Line: 500


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

Line: 503


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

Line: 506


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

Line: 579


      SELECT 'Y'
      FROM  okc_k_party_roles_b cplb
      WHERE cplb.id = p_cpl_id;

Line: 631


      SELECT 'Y'
      FROM  po_vendors pov
      WHERE pov.vendor_id = p_vendor_id;

Line: 683


      SELECT 'Y'
      FROM  OKX_PAYABLES_TERMS_V
      WHERE   id1 = p_pay_term_id
      AND    nvl(b_status,'N') = 'Y'
      AND    sysdate between (start_date_active) and nvl(end_date_active,sysdate);

Line: 735


      SELECT 'Y'
      From AP_LOOKUP_CODES
      Where lookup_type = 'PAYMENT METHOD'
      And  nvl(enabled_flag,'N') = 'Y'
      And sysdate between nvl(start_date_active,sysdate) and nvl(inactive_date,sysdate)
      And lookup_code = p_payment_method;

Line: 788


      SELECT 'Y'
      From  PO_LOOKUP_CODES
      Where lookup_type = 'PAY GROUP'
      --Bug# 3566580 : 11.5.8 enabled flag is not there in table po_lookup_codes
      --And  nvl(enabled_flag,'N') = 'Y'
      And sysdate <=  nvl(inactive_date,sysdate)
      And lookup_code = p_pay_group;

Line: 842


      SELECT 'Y'
      From FND_LOOKUPS
      Where lookup_type = 'OKL_DISBURSE_BASIS'
      And  nvl(enabled_flag,'N') = 'Y'
      And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
      And lookup_code = p_disbursement_basis;

Line: 895


      SELECT 'Y'
      From FND_LOOKUPS
      Where lookup_type = 'OKL_PROC_FEE_BASIS'
      And  nvl(enabled_flag,'N') = 'Y'
      And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
      And lookup_code = p_processing_fee_basis;

Line: 948


      SELECT 'Y'
      From FND_LOOKUPS
      Where lookup_type = 'OKL_PAYMENT_BASIS'
      And  nvl(enabled_flag,'N') = 'Y'
      And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
      And lookup_code = p_payment_basis;

Line: 1001


      SELECT 'Y'
      From FND_LOOKUPS
      Where lookup_type = 'OKL_PAYMENT_FRQ'
      And  nvl(enabled_flag,'N') = 'Y'
      And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
      And lookup_code = p_payment_frequency;

Line: 1283


    SELECT 'Y'
    FROM    po_vendor_sites_all pvs,
            okc_k_headers_b     chrb,
            okc_k_party_roles_b cplb
    WHERE   pvs.vendor_id                    = p_vendor_id
    AND     pvs.org_id                       = chrb.authoring_org_id
    AND     pvs.vendor_site_id               = p_paysite_id
    AND     nvl(pvs.pay_site_flag,'N')       = 'Y'
    AND     sysdate                          <= nvl(pvs.inactive_date,sysdate)
    AND     chrb.id                          = cplb.dnz_chr_id
    AND     cplb.id                          = p_cpl_id;

Line: 1390


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1391


    p_to.last_update_date := p_from.last_update_date;

Line: 1392


    p_to.last_update_login := p_from.last_update_login;

Line: 1439


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1440


    p_to.last_update_date := p_from.last_update_date;

Line: 1441


    p_to.last_update_login := p_from.last_update_login;

Line: 1688


  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_ppyd_rec                     IN ppyd_rec_type,
    x_ppyd_rec                     OUT NOCOPY ppyd_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1697


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

Line: 1733


    INSERT INTO OKL_PARTY_PAYMENT_DTLS(
      id,
      object_version_number,
      cpl_id,
      vendor_id,
      pay_site_id,
      payment_term_id,
      payment_method_code,
      pay_group_code,
	  payment_hdr_id,
	  payment_start_date,
	  payment_frequency,
	  remit_days,
	  disbursement_basis,
	  disbursement_fixed_amount,
	  disbursement_percent,
	  processing_fee_basis,
	  processing_fee_fixed_amount,
	  processing_fee_percent,
	 -- include_in_yield_flag,
	  --processing_fee_formula,
	  payment_basis,
      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,
	  ORIG_CONTRACT_LINE_ID)
    VALUES (
      l_ppyd_rec.id,
      l_ppyd_rec.object_version_number,
      l_ppyd_rec.cpl_id,
      l_ppyd_rec.vendor_id,
      l_ppyd_rec.pay_site_id,
      l_ppyd_rec.payment_term_id,
      l_ppyd_rec.payment_method_code,
      l_ppyd_rec.pay_group_code,
	  l_ppyd_rec.payment_hdr_id,
	  l_ppyd_rec.payment_start_date,
	  l_ppyd_rec.payment_frequency,
	  l_ppyd_rec.remit_days,
	  l_ppyd_rec.disbursement_basis,
	  l_ppyd_rec.disbursement_fixed_amount,
	  l_ppyd_rec.disbursement_percent,
	  l_ppyd_rec.processing_fee_basis,
	  l_ppyd_rec.processing_fee_fixed_amount,
	  l_ppyd_rec.processing_fee_percent,
	  --l_ppyd_rec.include_in_yield_flag,
	  --l_ppyd_rec.processing_fee_formula,
	  l_ppyd_rec.payment_basis,
      l_ppyd_rec.attribute_category,
      l_ppyd_rec.attribute1,
      l_ppyd_rec.attribute2,
      l_ppyd_rec.attribute3,
      l_ppyd_rec.attribute4,
      l_ppyd_rec.attribute5,
      l_ppyd_rec.attribute6,
      l_ppyd_rec.attribute7,
      l_ppyd_rec.attribute8,
      l_ppyd_rec.attribute9,
      l_ppyd_rec.attribute10,
      l_ppyd_rec.attribute11,
      l_ppyd_rec.attribute12,
      l_ppyd_rec.attribute13,
      l_ppyd_rec.attribute14,
      l_ppyd_rec.attribute15,
      l_ppyd_rec.created_by,
      l_ppyd_rec.creation_date,
      l_ppyd_rec.last_updated_by,
      l_ppyd_rec.last_update_date,
      l_ppyd_rec.last_update_login,
	  l_ppyd_rec.ORIG_CONTRACT_LINE_ID);

Line: 1856


  END insert_row;

Line: 1860


  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_ppydv_rec                    IN ppydv_rec_type,
    x_ppydv_rec                    OUT NOCOPY ppydv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1870


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

Line: 1887


      l_ppydv_rec.LAST_UPDATE_DATE := l_ppydv_rec.CREATION_DATE;

Line: 1888


      l_ppydv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1889


      l_ppydv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1953


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ppyd_rec,
      lx_ppyd_rec
    );

Line: 2019


  END insert_row;

Line: 2023


  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_ppydv_tbl                    IN ppydv_tbl_type,
    x_ppydv_tbl                    OUT NOCOPY  ppydv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2034


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

Line: 2048


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_ppydv_rec                    => p_ppydv_tbl(i),
            x_ppydv_rec                    => x_ppydv_tbl(i));

Line: 2116


  END insert_row;

Line: 2121


  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_ppydv_tbl                    IN ppydv_tbl_type,
    x_ppydv_tbl                    OUT NOCOPY ppydv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2131


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

Line: 2138


      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_ppydv_tbl                    => p_ppydv_tbl,
        x_ppydv_tbl                    => x_ppydv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2180


  END insert_row;

Line: 2198


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_PARTY_PAYMENT_DTLS
     WHERE ID = p_ppyd_rec.id
       AND OBJECT_VERSION_NUMBER = p_ppyd_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2205


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_PARTY_PAYMENT_DTLS
     WHERE ID = p_ppyd_rec.id;

Line: 2246


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2255


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2535


  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_ppyd_rec                     IN ppyd_rec_type,
    x_ppyd_rec                     OUT NOCOPY ppyd_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2544


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

Line: 2721


        IF (x_ppyd_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_ppyd_rec.last_updated_by := l_ppyd_rec.last_updated_by;

Line: 2725


        IF (x_ppyd_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_ppyd_rec.last_update_date := l_ppyd_rec.last_update_date;

Line: 2729


        IF (x_ppyd_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_ppyd_rec.last_update_login := l_ppyd_rec.last_update_login;

Line: 2781


    UPDATE OKL_PARTY_PAYMENT_DTLS
    SET OBJECT_VERSION_NUMBER = l_def_ppyd_rec.object_version_number,
        CPL_ID = l_def_ppyd_rec.cpl_id,
        VENDOR_ID = l_def_ppyd_rec.vendor_id,
        PAY_SITE_ID = l_def_ppyd_rec.pay_site_id,
        PAYMENT_TERM_ID = l_def_ppyd_rec.payment_term_id,
        PAYMENT_METHOD_CODE = l_def_ppyd_rec.payment_method_code,
        PAY_GROUP_CODE = l_def_ppyd_rec.pay_group_code,
		PAYMENT_HDR_ID = l_def_ppyd_rec.payment_hdr_id,
		PAYMENT_START_DATE = l_def_ppyd_rec.payment_start_date,
		PAYMENT_FREQUENCY = l_def_ppyd_rec.payment_frequency,
		REMIT_DAYS = l_def_ppyd_rec.remit_days,
		DISBURSEMENT_BASIS = l_def_ppyd_rec.disbursement_basis,
		DISBURSEMENT_FIXED_AMOUNT = l_def_ppyd_rec.disbursement_fixed_amount,
		DISBURSEMENT_PERCENT = l_def_ppyd_rec.disbursement_percent,
		PROCESSING_FEE_BASIS = l_def_ppyd_rec.processing_fee_basis,
		PROCESSING_FEE_FIXED_AMOUNT = l_def_ppyd_rec.processing_fee_fixed_amount,
		PROCESSING_FEE_PERCENT = l_def_ppyd_rec.processing_fee_percent,
		--INCLUDE_IN_YIELD_FLAG = l_def_ppyd_rec.include_in_yield_flag,
		--PROCESSING_FEE_FORMULA = l_def_ppyd_rec.processing_fee_formula,
		PAYMENT_BASIS = l_def_ppyd_rec.payment_basis,
        ATTRIBUTE_CATEGORY = l_def_ppyd_rec.attribute_category,
        ATTRIBUTE1 = l_def_ppyd_rec.attribute1,
        ATTRIBUTE2 = l_def_ppyd_rec.attribute2,
        ATTRIBUTE3 = l_def_ppyd_rec.attribute3,
        ATTRIBUTE4 = l_def_ppyd_rec.attribute4,
        ATTRIBUTE5 = l_def_ppyd_rec.attribute5,
        ATTRIBUTE6 = l_def_ppyd_rec.attribute6,
        ATTRIBUTE7 = l_def_ppyd_rec.attribute7,
        ATTRIBUTE8 = l_def_ppyd_rec.attribute8,
        ATTRIBUTE9 = l_def_ppyd_rec.attribute9,
        ATTRIBUTE10 = l_def_ppyd_rec.attribute10,
        ATTRIBUTE11 = l_def_ppyd_rec.attribute11,
        ATTRIBUTE12 = l_def_ppyd_rec.attribute12,
        ATTRIBUTE13 = l_def_ppyd_rec.attribute13,
        ATTRIBUTE14 = l_def_ppyd_rec.attribute14,
        ATTRIBUTE15 = l_def_ppyd_rec.attribute15,
        CREATED_BY = l_def_ppyd_rec.created_by,
        CREATION_DATE = l_def_ppyd_rec.creation_date,
        LAST_UPDATED_BY = l_def_ppyd_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_ppyd_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_ppyd_rec.last_update_login,
        ORIG_CONTRACT_LINE_ID = l_def_ppyd_rec.ORIG_CONTRACT_LINE_ID
    WHERE ID = l_def_ppyd_rec.id;

Line: 2860


  END update_row;

Line: 2864


  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_ppydv_rec                    IN ppydv_rec_type,
    x_ppydv_rec                    OUT NOCOPY ppydv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2874


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

Line: 2890


      l_ppydv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2891


      l_ppydv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2892


      l_ppydv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3067


        IF (x_ppydv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_ppydv_rec.last_updated_by := l_db_ppydv_rec.last_updated_by;

Line: 3071


        IF (x_ppydv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_ppydv_rec.last_update_date := l_db_ppydv_rec.last_update_date;

Line: 3075


        IF (x_ppydv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_ppydv_rec.last_update_login := l_db_ppydv_rec.last_update_login;

Line: 3170


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ppyd_rec,
      lx_ppyd_rec
    );

Line: 3235


  END update_row;

Line: 3239


  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_ppydv_tbl                    IN ppydv_tbl_type,
    x_ppydv_tbl                    OUT NOCOPY ppydv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3250


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

Line: 3264


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_ppydv_rec                    => p_ppydv_tbl(i),
            x_ppydv_rec                    => x_ppydv_tbl(i));

Line: 3332


  END update_row;

Line: 3337


  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_ppydv_tbl                    IN ppydv_tbl_type,
    x_ppydv_tbl                    OUT NOCOPY ppydv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3347


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

Line: 3354


      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_ppydv_tbl                    => p_ppydv_tbl,
        x_ppydv_tbl                    => x_ppydv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3396


  END update_row;

Line: 3404


  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_ppyd_rec                     IN ppyd_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3412


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

Line: 3427


    DELETE FROM OKL_PARTY_PAYMENT_DTLS
     WHERE ID = p_ppyd_rec.id;

Line: 3463


  END delete_row;

Line: 3467


  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_ppydv_rec                    IN ppydv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3476


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

Line: 3482


    SELECT cpl_id FROM okl_party_payment_dtls_v
    WHERE id = p_id;

Line: 3509


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

Line: 3571


  END delete_row;

Line: 3575


  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_ppydv_tbl                    IN ppydv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3585


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

Line: 3599


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_ppydv_rec                    => p_ppydv_tbl(i));

Line: 3666


  END delete_row;

Line: 3671


  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_ppydv_tbl                    IN ppydv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3680


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

Line: 3687


      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_ppydv_tbl                    => p_ppydv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3728


  END delete_row;

Line: 3741


INSERT INTO OKL_PARTY_PYMT_DTLS_H
  (
ID
,OBJECT_VERSION_NUMBER
,MAJOR_VERSION
,CPL_ID
,VENDOR_ID
,PAY_SITE_ID
,PAYMENT_TERM_ID
,PAYMENT_METHOD_CODE
,PAY_GROUP_CODE
,PAYMENT_HDR_ID
,PAYMENT_START_DATE
,PAYMENT_FREQUENCY
,REMIT_DAYS
,DISBURSEMENT_BASIS
,DISBURSEMENT_FIXED_AMOUNT
,DISBURSEMENT_PERCENT
,PROCESSING_FEE_BASIS
,PROCESSING_FEE_FIXED_AMOUNT
,PROCESSING_FEE_PERCENT
--,INCLUDE_IN_YIELD_FLAG
--,PROCESSING_FEE_FORMULA
,PAYMENT_BASIS
,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
,ORIG_CONTRACT_LINE_ID
)
  SELECT
 ID
,OBJECT_VERSION_NUMBER
,p_major_version
,CPL_ID
,VENDOR_ID
,PAY_SITE_ID
,PAYMENT_TERM_ID
,PAYMENT_METHOD_CODE
,PAY_GROUP_CODE
,PAYMENT_HDR_ID
,PAYMENT_START_DATE
,PAYMENT_FREQUENCY
,REMIT_DAYS
,DISBURSEMENT_BASIS
,DISBURSEMENT_FIXED_AMOUNT
,DISBURSEMENT_PERCENT
,PROCESSING_FEE_BASIS
,PROCESSING_FEE_FIXED_AMOUNT
,PROCESSING_FEE_PERCENT
--,INCLUDE_IN_YIELD_FLAG
--,PROCESSING_FEE_FORMULA
,PAYMENT_BASIS
,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
,ORIG_CONTRACT_LINE_ID
  FROM OKL_PARTY_PAYMENT_DTLS
  WHERE cpl_id in (select id from okc_k_party_roles_b  where dnz_chr_id = p_chr_id);

Line: 3863


INSERT INTO OKL_PARTY_PAYMENT_DTLS
  (
ID
,OBJECT_VERSION_NUMBER
,CPL_ID
,VENDOR_ID
,PAY_SITE_ID
,PAYMENT_TERM_ID
,PAYMENT_METHOD_CODE
,PAY_GROUP_CODE
,PAYMENT_HDR_ID
,PAYMENT_START_DATE
,PAYMENT_FREQUENCY
,REMIT_DAYS
,DISBURSEMENT_BASIS
,DISBURSEMENT_FIXED_AMOUNT
,DISBURSEMENT_PERCENT
,PROCESSING_FEE_BASIS
,PROCESSING_FEE_FIXED_AMOUNT
,PROCESSING_FEE_PERCENT
--,INCLUDE_IN_YIELD_FLAG
--,PROCESSING_FEE_FORMULA
,PAYMENT_BASIS
,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
,ORIG_CONTRACT_LINE_ID
)
  SELECT
ID
,OBJECT_VERSION_NUMBER
,CPL_ID
,VENDOR_ID
,PAY_SITE_ID
,PAYMENT_TERM_ID
,PAYMENT_METHOD_CODE
,PAY_GROUP_CODE
,PAYMENT_HDR_ID
,PAYMENT_START_DATE
,PAYMENT_FREQUENCY
,REMIT_DAYS
,DISBURSEMENT_BASIS
,DISBURSEMENT_FIXED_AMOUNT
,DISBURSEMENT_PERCENT
,PROCESSING_FEE_BASIS
,PROCESSING_FEE_FIXED_AMOUNT
,PROCESSING_FEE_PERCENT
--,INCLUDE_IN_YIELD_FLAG
--,PROCESSING_FEE_FORMULA
,PAYMENT_BASIS
,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
,ORIG_CONTRACT_LINE_ID

  FROM OKL_PARTY_PYMT_DTLS_H
  WHERE cpl_id in (select id from okc_k_party_roles_b where dnz_chr_id = p_chr_id) and major_version = p_major_version;