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
      FROM Okl_Party_Payment_Dtls_V
     WHERE okl_party_payment_dtls_v.id = p_id;

Line: 199


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

Line: 243


    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
      FROM Okl_Party_Payment_Dtls
     WHERE okl_party_payment_dtls.id = p_id;

Line: 334


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

Line: 496


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

Line: 499


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

Line: 502


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

Line: 569


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

Line: 621


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

Line: 673


      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: 725


      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: 778


      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: 832


      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: 885


      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: 938


      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: 991


      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: 1273


    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: 1380


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1381


    p_to.last_update_date := p_from.last_update_date;

Line: 1382


    p_to.last_update_login := p_from.last_update_login;

Line: 1428


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1429


    p_to.last_update_date := p_from.last_update_date;

Line: 1430


    p_to.last_update_login := p_from.last_update_login;

Line: 1676


  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: 1685


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

Line: 1721


    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)
    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);

Line: 1842


  END insert_row;

Line: 1846


  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: 1856


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

Line: 1873


      l_ppydv_rec.LAST_UPDATE_DATE := l_ppydv_rec.CREATION_DATE;

Line: 1874


      l_ppydv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1875


      l_ppydv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1939


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

Line: 2005


  END insert_row;

Line: 2009


  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: 2020


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

Line: 2034


          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: 2102


  END insert_row;

Line: 2107


  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: 2117


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

Line: 2124


      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: 2166


  END insert_row;

Line: 2184


    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: 2191


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_PARTY_PAYMENT_DTLS
     WHERE ID = p_ppyd_rec.id;

Line: 2232


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2241


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2521


  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: 2530


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

Line: 2707


        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: 2711


        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: 2715


        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: 2760


    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
    WHERE ID = l_def_ppyd_rec.id;

Line: 2838


  END update_row;

Line: 2842


  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: 2852


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

Line: 2868


      l_ppydv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2869


      l_ppydv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2870


      l_ppydv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3045


        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: 3049


        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: 3053


        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: 3141


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

Line: 3206


  END update_row;

Line: 3210


  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: 3221


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

Line: 3235


          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: 3303


  END update_row;

Line: 3308


  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: 3318


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

Line: 3325


      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: 3367


  END update_row;

Line: 3375


  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: 3383


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

Line: 3398


    DELETE FROM OKL_PARTY_PAYMENT_DTLS
     WHERE ID = p_ppyd_rec.id;

Line: 3434


  END delete_row;

Line: 3438


  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: 3447


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

Line: 3453


    SELECT cpl_id FROM okl_party_payment_dtls_v
    WHERE id = p_id;

Line: 3480


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

Line: 3542


  END delete_row;

Line: 3546


  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: 3556


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

Line: 3570


          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: 3637


  END delete_row;

Line: 3642


  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: 3651


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

Line: 3658


      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: 3699


  END delete_row;

Line: 3712


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
)
  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
  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: 3832


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
)
  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

  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;