59:
60:
61: l_trx_pmt_index BINARY_INTEGER :=0;
62: l_calling_app_procedure VARCHAR2(255);
63: TYPE getSDAPTabType IS TABLE OF IBY_DOCS_PAYABLE_ALL.document_status%TYPE INDEX BY BINARY_INTEGER;
64:
65: sdap_tbl getSDAPTabType;
66:
67: TYPE getMaturityDateTabType IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(30);
379: BEGIN
380: SELECT DISTINCT(SETTLEMENT_PRIORITY)
381: INTO
382: l_settlement_pr
383: FROM IBY_DOCS_PAYABLE_ALL
384: WHERE
385: PAYMENT_ID = IBY_PAYGROUP_PUB.pmtTable.PAYMENT_ID(l_trx_audit_index);
386: EXCEPTION
387: WHEN TOO_MANY_ROWS THEN
810: * Anticipated Value Date is usually set as anticipated
811: * Float (in Payment Methods) + Payment Date
812: * There are two exceptions to the given rule ::
813: * 1. FUTURE DATED PAYMENT :: If payment is bills payable :: Anticipated_float + maturity_date
814: * 2. IMMEDIATE :: Take the greatest of iby_docs_payable_all
815: * and this will be anticipated_value_date. In this case
816: * immediate payments is associated with single payments
817: * hence payment_date = anticipated_value_date.
818: */
1405: * Since the IBY_PAYMENTS_ALL table does not contain a document id, a
1406: * separate data structure is needed to keep track of the documents
1407: * that are part of a payment. This information is tracked in the
1408: * docsInPaymentTabType table. The rows in docsInPaymentTabType are
1409: * used to update the rows in IBY_DOCS_PAYABLE_ALL table with
1410: * payment ids.
1411: *
1412: * x_paymentTab x_docsInPmtTab
1413: * (insert into IBY_PAYMENTS_ALL) (update IBY_DOCS_PAYABLE)
1446:
1447: l_commonAttributes commonAttributesTabType;
1448:
1449: /* previous document attributes */
1450: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
1451: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
1452: prev_ca_doc_id1 iby_docs_payable_all.
1453: calling_app_doc_unique_ref1%TYPE;
1454: prev_ca_doc_id2 iby_docs_payable_all.
1447: l_commonAttributes commonAttributesTabType;
1448:
1449: /* previous document attributes */
1450: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
1451: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
1452: prev_ca_doc_id1 iby_docs_payable_all.
1453: calling_app_doc_unique_ref1%TYPE;
1454: prev_ca_doc_id2 iby_docs_payable_all.
1455: calling_app_doc_unique_ref2%TYPE;
1448:
1449: /* previous document attributes */
1450: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
1451: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
1452: prev_ca_doc_id1 iby_docs_payable_all.
1453: calling_app_doc_unique_ref1%TYPE;
1454: prev_ca_doc_id2 iby_docs_payable_all.
1455: calling_app_doc_unique_ref2%TYPE;
1456: prev_ca_doc_id3 iby_docs_payable_all.
1450: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
1451: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
1452: prev_ca_doc_id1 iby_docs_payable_all.
1453: calling_app_doc_unique_ref1%TYPE;
1454: prev_ca_doc_id2 iby_docs_payable_all.
1455: calling_app_doc_unique_ref2%TYPE;
1456: prev_ca_doc_id3 iby_docs_payable_all.
1457: calling_app_doc_unique_ref3%TYPE;
1458: prev_ca_doc_id4 iby_docs_payable_all.
1452: prev_ca_doc_id1 iby_docs_payable_all.
1453: calling_app_doc_unique_ref1%TYPE;
1454: prev_ca_doc_id2 iby_docs_payable_all.
1455: calling_app_doc_unique_ref2%TYPE;
1456: prev_ca_doc_id3 iby_docs_payable_all.
1457: calling_app_doc_unique_ref3%TYPE;
1458: prev_ca_doc_id4 iby_docs_payable_all.
1459: calling_app_doc_unique_ref4%TYPE;
1460: prev_ca_doc_id5 iby_docs_payable_all.
1454: prev_ca_doc_id2 iby_docs_payable_all.
1455: calling_app_doc_unique_ref2%TYPE;
1456: prev_ca_doc_id3 iby_docs_payable_all.
1457: calling_app_doc_unique_ref3%TYPE;
1458: prev_ca_doc_id4 iby_docs_payable_all.
1459: calling_app_doc_unique_ref4%TYPE;
1460: prev_ca_doc_id5 iby_docs_payable_all.
1461: calling_app_doc_unique_ref5%TYPE;
1462: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1456: prev_ca_doc_id3 iby_docs_payable_all.
1457: calling_app_doc_unique_ref3%TYPE;
1458: prev_ca_doc_id4 iby_docs_payable_all.
1459: calling_app_doc_unique_ref4%TYPE;
1460: prev_ca_doc_id5 iby_docs_payable_all.
1461: calling_app_doc_unique_ref5%TYPE;
1462: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1463: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1464: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1458: prev_ca_doc_id4 iby_docs_payable_all.
1459: calling_app_doc_unique_ref4%TYPE;
1460: prev_ca_doc_id5 iby_docs_payable_all.
1461: calling_app_doc_unique_ref5%TYPE;
1462: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1463: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1464: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1465: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1466: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1459: calling_app_doc_unique_ref4%TYPE;
1460: prev_ca_doc_id5 iby_docs_payable_all.
1461: calling_app_doc_unique_ref5%TYPE;
1462: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1463: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1464: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1465: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1466: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1467: prev_int_bank_acct_id iby_docs_payable_all.
1460: prev_ca_doc_id5 iby_docs_payable_all.
1461: calling_app_doc_unique_ref5%TYPE;
1462: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1463: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1464: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1465: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1466: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1467: prev_int_bank_acct_id iby_docs_payable_all.
1468: internal_bank_account_id%TYPE;
1461: calling_app_doc_unique_ref5%TYPE;
1462: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1463: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1464: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1465: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1466: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1467: prev_int_bank_acct_id iby_docs_payable_all.
1468: internal_bank_account_id%TYPE;
1469: prev_ext_bank_acct_id iby_docs_payable_all.
1462: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1463: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1464: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1465: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1466: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1467: prev_int_bank_acct_id iby_docs_payable_all.
1468: internal_bank_account_id%TYPE;
1469: prev_ext_bank_acct_id iby_docs_payable_all.
1470: external_bank_account_id%TYPE;
1463: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1464: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1465: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1466: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1467: prev_int_bank_acct_id iby_docs_payable_all.
1468: internal_bank_account_id%TYPE;
1469: prev_ext_bank_acct_id iby_docs_payable_all.
1470: external_bank_account_id%TYPE;
1471: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1465: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1466: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1467: prev_int_bank_acct_id iby_docs_payable_all.
1468: internal_bank_account_id%TYPE;
1469: prev_ext_bank_acct_id iby_docs_payable_all.
1470: external_bank_account_id%TYPE;
1471: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1472: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1473: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1467: prev_int_bank_acct_id iby_docs_payable_all.
1468: internal_bank_account_id%TYPE;
1469: prev_ext_bank_acct_id iby_docs_payable_all.
1470: external_bank_account_id%TYPE;
1471: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1472: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1473: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1474: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1475: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1468: internal_bank_account_id%TYPE;
1469: prev_ext_bank_acct_id iby_docs_payable_all.
1470: external_bank_account_id%TYPE;
1471: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1472: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1473: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1474: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1475: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1476: prev_org_id iby_docs_payable_all.org_id%TYPE;
1469: prev_ext_bank_acct_id iby_docs_payable_all.
1470: external_bank_account_id%TYPE;
1471: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1472: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1473: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1474: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1475: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1476: prev_org_id iby_docs_payable_all.org_id%TYPE;
1477: prev_org_type iby_docs_payable_all.org_type%TYPE;
1470: external_bank_account_id%TYPE;
1471: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1472: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1473: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1474: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1475: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1476: prev_org_id iby_docs_payable_all.org_id%TYPE;
1477: prev_org_type iby_docs_payable_all.org_type%TYPE;
1478: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1471: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1472: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1473: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1474: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1475: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1476: prev_org_id iby_docs_payable_all.org_id%TYPE;
1477: prev_org_type iby_docs_payable_all.org_type%TYPE;
1478: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1479: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1472: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1473: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1474: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1475: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1476: prev_org_id iby_docs_payable_all.org_id%TYPE;
1477: prev_org_type iby_docs_payable_all.org_type%TYPE;
1478: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1479: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1480: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1473: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1474: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1475: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1476: prev_org_id iby_docs_payable_all.org_id%TYPE;
1477: prev_org_type iby_docs_payable_all.org_type%TYPE;
1478: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1479: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1480: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1481: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1474: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1475: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1476: prev_org_id iby_docs_payable_all.org_id%TYPE;
1477: prev_org_type iby_docs_payable_all.org_type%TYPE;
1478: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1479: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1480: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1481: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1482: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1475: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1476: prev_org_id iby_docs_payable_all.org_id%TYPE;
1477: prev_org_type iby_docs_payable_all.org_type%TYPE;
1478: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1479: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1480: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1481: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1482: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1483: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1476: prev_org_id iby_docs_payable_all.org_id%TYPE;
1477: prev_org_type iby_docs_payable_all.org_type%TYPE;
1478: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1479: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1480: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1481: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1482: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1483: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1484: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1477: prev_org_type iby_docs_payable_all.org_type%TYPE;
1478: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1479: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1480: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1481: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1482: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1483: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1484: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1485: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1478: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1479: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1480: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1481: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1482: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1483: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1484: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1485: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1486: prev_uri iby_docs_payable_all.
1479: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1480: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1481: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1482: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1483: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1484: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1485: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1486: prev_uri iby_docs_payable_all.
1487: unique_remittance_identifier%TYPE;
1480: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1481: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1482: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1483: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1484: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1485: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1486: prev_uri iby_docs_payable_all.
1487: unique_remittance_identifier%TYPE;
1488: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1481: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1482: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1483: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1484: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1485: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1486: prev_uri iby_docs_payable_all.
1487: unique_remittance_identifier%TYPE;
1488: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1489: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1482: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1483: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1484: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1485: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1486: prev_uri iby_docs_payable_all.
1487: unique_remittance_identifier%TYPE;
1488: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1489: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1490: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1484: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1485: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1486: prev_uri iby_docs_payable_all.
1487: unique_remittance_identifier%TYPE;
1488: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1489: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1490: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1491: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
1492: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
1485: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1486: prev_uri iby_docs_payable_all.
1487: unique_remittance_identifier%TYPE;
1488: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1489: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1490: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1491: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
1492: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
1493: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1486: prev_uri iby_docs_payable_all.
1487: unique_remittance_identifier%TYPE;
1488: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1489: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1490: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1491: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
1492: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
1493: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1494: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1487: unique_remittance_identifier%TYPE;
1488: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1489: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1490: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1491: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
1492: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
1493: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1494: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1495:
1488: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1489: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1490: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1491: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
1492: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
1493: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1494: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1495:
1496: /* payee (employee) address related fields */
1489: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1490: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1491: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
1492: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
1493: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1494: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1495:
1496: /* payee (employee) address related fields */
1497: prev_address_source iby_docs_payable_all.address_source%TYPE;
1490: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1491: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
1492: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
1493: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1494: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1495:
1496: /* payee (employee) address related fields */
1497: prev_address_source iby_docs_payable_all.address_source%TYPE;
1498: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1493: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1494: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1495:
1496: /* payee (employee) address related fields */
1497: prev_address_source iby_docs_payable_all.address_source%TYPE;
1498: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1499: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
1500: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
1501:
1494: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1495:
1496: /* payee (employee) address related fields */
1497: prev_address_source iby_docs_payable_all.address_source%TYPE;
1498: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1499: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
1500: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
1501:
1502: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
1495:
1496: /* payee (employee) address related fields */
1497: prev_address_source iby_docs_payable_all.address_source%TYPE;
1498: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1499: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
1500: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
1501:
1502: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
1503:
1496: /* payee (employee) address related fields */
1497: prev_address_source iby_docs_payable_all.address_source%TYPE;
1498: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1499: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
1500: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
1501:
1502: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
1503:
1504: /*TPP-Start*/
1498: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1499: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
1500: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
1501:
1502: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
1503:
1504: /*TPP-Start*/
1505: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1506: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1501:
1502: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
1503:
1504: /*TPP-Start*/
1505: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1506: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1507: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1508: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1509: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1502: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
1503:
1504: /*TPP-Start*/
1505: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1506: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1507: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1508: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1509: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1510:
1503:
1504: /*TPP-Start*/
1505: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1506: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1507: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1508: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1509: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1510:
1511: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1504: /*TPP-Start*/
1505: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1506: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1507: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1508: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1509: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1510:
1511: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1512: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1505: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1506: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1507: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1508: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1509: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1510:
1511: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1512: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1513: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1507: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1508: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1509: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1510:
1511: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1512: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1513: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1514: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1515: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1508: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1509: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1510:
1511: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1512: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1513: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1514: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1515: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1516: /*TPP-End*/
1509: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1510:
1511: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1512: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1513: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1514: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1515: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1516: /*TPP-End*/
1517:
1510:
1511: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1512: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1513: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1514: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1515: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1516: /*TPP-End*/
1517:
1518:
1511: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
1512: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
1513: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
1514: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
1515: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
1516: /*TPP-End*/
1517:
1518:
1519: /* current document attributes */
1516: /*TPP-End*/
1517:
1518:
1519: /* current document attributes */
1520: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
1521: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
1522: curr_ca_doc_id1 iby_docs_payable_all.
1523: calling_app_doc_unique_ref1%TYPE;
1524: curr_ca_doc_id2 iby_docs_payable_all.
1517:
1518:
1519: /* current document attributes */
1520: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
1521: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
1522: curr_ca_doc_id1 iby_docs_payable_all.
1523: calling_app_doc_unique_ref1%TYPE;
1524: curr_ca_doc_id2 iby_docs_payable_all.
1525: calling_app_doc_unique_ref2%TYPE;
1518:
1519: /* current document attributes */
1520: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
1521: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
1522: curr_ca_doc_id1 iby_docs_payable_all.
1523: calling_app_doc_unique_ref1%TYPE;
1524: curr_ca_doc_id2 iby_docs_payable_all.
1525: calling_app_doc_unique_ref2%TYPE;
1526: curr_ca_doc_id3 iby_docs_payable_all.
1520: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
1521: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
1522: curr_ca_doc_id1 iby_docs_payable_all.
1523: calling_app_doc_unique_ref1%TYPE;
1524: curr_ca_doc_id2 iby_docs_payable_all.
1525: calling_app_doc_unique_ref2%TYPE;
1526: curr_ca_doc_id3 iby_docs_payable_all.
1527: calling_app_doc_unique_ref3%TYPE;
1528: curr_ca_doc_id4 iby_docs_payable_all.
1522: curr_ca_doc_id1 iby_docs_payable_all.
1523: calling_app_doc_unique_ref1%TYPE;
1524: curr_ca_doc_id2 iby_docs_payable_all.
1525: calling_app_doc_unique_ref2%TYPE;
1526: curr_ca_doc_id3 iby_docs_payable_all.
1527: calling_app_doc_unique_ref3%TYPE;
1528: curr_ca_doc_id4 iby_docs_payable_all.
1529: calling_app_doc_unique_ref4%TYPE;
1530: curr_ca_doc_id5 iby_docs_payable_all.
1524: curr_ca_doc_id2 iby_docs_payable_all.
1525: calling_app_doc_unique_ref2%TYPE;
1526: curr_ca_doc_id3 iby_docs_payable_all.
1527: calling_app_doc_unique_ref3%TYPE;
1528: curr_ca_doc_id4 iby_docs_payable_all.
1529: calling_app_doc_unique_ref4%TYPE;
1530: curr_ca_doc_id5 iby_docs_payable_all.
1531: calling_app_doc_unique_ref5%TYPE;
1532: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1526: curr_ca_doc_id3 iby_docs_payable_all.
1527: calling_app_doc_unique_ref3%TYPE;
1528: curr_ca_doc_id4 iby_docs_payable_all.
1529: calling_app_doc_unique_ref4%TYPE;
1530: curr_ca_doc_id5 iby_docs_payable_all.
1531: calling_app_doc_unique_ref5%TYPE;
1532: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1533: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1534: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1528: curr_ca_doc_id4 iby_docs_payable_all.
1529: calling_app_doc_unique_ref4%TYPE;
1530: curr_ca_doc_id5 iby_docs_payable_all.
1531: calling_app_doc_unique_ref5%TYPE;
1532: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1533: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1534: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1535: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1536: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1529: calling_app_doc_unique_ref4%TYPE;
1530: curr_ca_doc_id5 iby_docs_payable_all.
1531: calling_app_doc_unique_ref5%TYPE;
1532: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1533: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1534: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1535: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1536: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1537: curr_int_bank_acct_id iby_docs_payable_all.
1530: curr_ca_doc_id5 iby_docs_payable_all.
1531: calling_app_doc_unique_ref5%TYPE;
1532: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1533: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1534: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1535: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1536: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1537: curr_int_bank_acct_id iby_docs_payable_all.
1538: internal_bank_account_id%TYPE;
1531: calling_app_doc_unique_ref5%TYPE;
1532: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1533: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1534: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1535: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1536: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1537: curr_int_bank_acct_id iby_docs_payable_all.
1538: internal_bank_account_id%TYPE;
1539: curr_ext_bank_acct_id iby_docs_payable_all.
1532: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
1533: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1534: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1535: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1536: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1537: curr_int_bank_acct_id iby_docs_payable_all.
1538: internal_bank_account_id%TYPE;
1539: curr_ext_bank_acct_id iby_docs_payable_all.
1540: external_bank_account_id%TYPE;
1533: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
1534: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
1535: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1536: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1537: curr_int_bank_acct_id iby_docs_payable_all.
1538: internal_bank_account_id%TYPE;
1539: curr_ext_bank_acct_id iby_docs_payable_all.
1540: external_bank_account_id%TYPE;
1541: curr_org_id iby_docs_payable_all.org_id%TYPE;
1535: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
1536: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
1537: curr_int_bank_acct_id iby_docs_payable_all.
1538: internal_bank_account_id%TYPE;
1539: curr_ext_bank_acct_id iby_docs_payable_all.
1540: external_bank_account_id%TYPE;
1541: curr_org_id iby_docs_payable_all.org_id%TYPE;
1542: curr_org_type iby_docs_payable_all.org_type%TYPE;
1543: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1537: curr_int_bank_acct_id iby_docs_payable_all.
1538: internal_bank_account_id%TYPE;
1539: curr_ext_bank_acct_id iby_docs_payable_all.
1540: external_bank_account_id%TYPE;
1541: curr_org_id iby_docs_payable_all.org_id%TYPE;
1542: curr_org_type iby_docs_payable_all.org_type%TYPE;
1543: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1544: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1545: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1538: internal_bank_account_id%TYPE;
1539: curr_ext_bank_acct_id iby_docs_payable_all.
1540: external_bank_account_id%TYPE;
1541: curr_org_id iby_docs_payable_all.org_id%TYPE;
1542: curr_org_type iby_docs_payable_all.org_type%TYPE;
1543: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1544: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1545: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1546: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1539: curr_ext_bank_acct_id iby_docs_payable_all.
1540: external_bank_account_id%TYPE;
1541: curr_org_id iby_docs_payable_all.org_id%TYPE;
1542: curr_org_type iby_docs_payable_all.org_type%TYPE;
1543: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1544: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1545: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1546: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1547: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1540: external_bank_account_id%TYPE;
1541: curr_org_id iby_docs_payable_all.org_id%TYPE;
1542: curr_org_type iby_docs_payable_all.org_type%TYPE;
1543: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1544: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1545: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1546: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1547: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1548: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1541: curr_org_id iby_docs_payable_all.org_id%TYPE;
1542: curr_org_type iby_docs_payable_all.org_type%TYPE;
1543: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1544: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1545: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1546: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1547: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1548: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1549: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1542: curr_org_type iby_docs_payable_all.org_type%TYPE;
1543: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1544: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1545: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1546: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1547: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1548: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1549: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1550: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1543: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
1544: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1545: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1546: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1547: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1548: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1549: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1550: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1551: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1544: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
1545: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1546: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1547: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1548: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1549: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1550: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1551: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1552: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1545: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
1546: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1547: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1548: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1549: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1550: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1551: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1552: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1553: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1546: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
1547: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1548: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1549: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1550: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1551: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1552: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1553: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1554: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1547: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
1548: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1549: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1550: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1551: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1552: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1553: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1554: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1555: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1548: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
1549: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1550: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1551: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1552: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1553: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1554: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1555: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1556: curr_uri iby_docs_payable_all.
1549: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
1550: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1551: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1552: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1553: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1554: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1555: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1556: curr_uri iby_docs_payable_all.
1557: unique_remittance_identifier%TYPE;
1550: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
1551: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1552: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1553: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1554: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1555: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1556: curr_uri iby_docs_payable_all.
1557: unique_remittance_identifier%TYPE;
1558: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1551: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
1552: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1553: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1554: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1555: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1556: curr_uri iby_docs_payable_all.
1557: unique_remittance_identifier%TYPE;
1558: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1559: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1552: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
1553: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
1554: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1555: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1556: curr_uri iby_docs_payable_all.
1557: unique_remittance_identifier%TYPE;
1558: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1559: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1560: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1554: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
1555: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1556: curr_uri iby_docs_payable_all.
1557: unique_remittance_identifier%TYPE;
1558: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1559: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1560: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1561: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
1562: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
1555: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
1556: curr_uri iby_docs_payable_all.
1557: unique_remittance_identifier%TYPE;
1558: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1559: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1560: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1561: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
1562: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
1563: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1556: curr_uri iby_docs_payable_all.
1557: unique_remittance_identifier%TYPE;
1558: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1559: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1560: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1561: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
1562: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
1563: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1564: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1557: unique_remittance_identifier%TYPE;
1558: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1559: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1560: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1561: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
1562: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
1563: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1564: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1565:
1558: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
1559: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1560: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1561: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
1562: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
1563: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1564: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1565:
1566: /* payee (employee) address related fields */
1559: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
1560: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1561: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
1562: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
1563: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1564: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1565:
1566: /* payee (employee) address related fields */
1567: curr_address_source iby_docs_payable_all.address_source%TYPE;
1560: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
1561: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
1562: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
1563: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1564: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1565:
1566: /* payee (employee) address related fields */
1567: curr_address_source iby_docs_payable_all.address_source%TYPE;
1568: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1563: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
1564: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1565:
1566: /* payee (employee) address related fields */
1567: curr_address_source iby_docs_payable_all.address_source%TYPE;
1568: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1569: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
1570: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
1571:
1564: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
1565:
1566: /* payee (employee) address related fields */
1567: curr_address_source iby_docs_payable_all.address_source%TYPE;
1568: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1569: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
1570: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
1571:
1572: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
1565:
1566: /* payee (employee) address related fields */
1567: curr_address_source iby_docs_payable_all.address_source%TYPE;
1568: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1569: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
1570: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
1571:
1572: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
1573:
1566: /* payee (employee) address related fields */
1567: curr_address_source iby_docs_payable_all.address_source%TYPE;
1568: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1569: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
1570: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
1571:
1572: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
1573:
1574: /* these two are passed to the external application hook */
1568: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
1569: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
1570: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
1571:
1572: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
1573:
1574: /* these two are passed to the external application hook */
1575: l_amount_withheld iby_docs_payable_all.amount_withheld%TYPE;
1576:
1571:
1572: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
1573:
1574: /* these two are passed to the external application hook */
1575: l_amount_withheld iby_docs_payable_all.amount_withheld%TYPE;
1576:
1577: /* used for maturity date calculation */
1578: l_discount_date iby_docs_payable_all.discount_date%TYPE;
1579:
1574: /* these two are passed to the external application hook */
1575: l_amount_withheld iby_docs_payable_all.amount_withheld%TYPE;
1576:
1577: /* used for maturity date calculation */
1578: l_discount_date iby_docs_payable_all.discount_date%TYPE;
1579:
1580: /* passed to hook */
1581: l_discount_amount iby_docs_payable_all.payment_curr_discount_taken
1582: %TYPE;
1577: /* used for maturity date calculation */
1578: l_discount_date iby_docs_payable_all.discount_date%TYPE;
1579:
1580: /* passed to hook */
1581: l_discount_amount iby_docs_payable_all.payment_curr_discount_taken
1582: %TYPE;
1583: l_trx_line_index BINARY_INTEGER;
1584: l_no_rec_in_ppr BOOLEAN;
1585: G_LINES_PER_FETCH CONSTANT NUMBER:= 100;
1693: docs.inv_supplier_site_id,
1694: docs.inv_beneficiary_party,
1695: docs.ext_inv_payee_id
1696: /*TPP-Start*/
1697: FROM IBY_DOCS_PAYABLE_ALL docs,
1698: IBY_PMT_CREATION_RULES pcr,
1699: IBY_PAYMENT_PROFILES ppf,
1700: IBY_PAY_SERVICE_REQUESTS prq,
1701: IBY_EXTERNAL_PAYEES_ALL ext_payee,
3484: * Since the IBY_PAYMENTS_ALL table does not contain a document id, a
3485: * separate data structure is needed to keep track of the documents
3486: * that are part of a payment. This information is tracked in the
3487: * docsInPaymentTabType table. The rows in docsInPaymentTabType are
3488: * used to update the rows in IBY_DOCS_PAYABLE_ALL table with
3489: * payment ids.
3490: *
3491: * x_paymentTab x_docsInPmtTab
3492: * (insert into IBY_PAYMENTS_ALL) (update IBY_DOCS_PAYABLE)
3525:
3526: l_commonAttributes commonAttributesTabType;
3527:
3528: /* previous document attributes */
3529: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
3530: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
3531: prev_ca_doc_id1 iby_docs_payable_all.
3532: calling_app_doc_unique_ref1%TYPE;
3533: prev_ca_doc_id2 iby_docs_payable_all.
3526: l_commonAttributes commonAttributesTabType;
3527:
3528: /* previous document attributes */
3529: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
3530: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
3531: prev_ca_doc_id1 iby_docs_payable_all.
3532: calling_app_doc_unique_ref1%TYPE;
3533: prev_ca_doc_id2 iby_docs_payable_all.
3534: calling_app_doc_unique_ref2%TYPE;
3527:
3528: /* previous document attributes */
3529: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
3530: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
3531: prev_ca_doc_id1 iby_docs_payable_all.
3532: calling_app_doc_unique_ref1%TYPE;
3533: prev_ca_doc_id2 iby_docs_payable_all.
3534: calling_app_doc_unique_ref2%TYPE;
3535: prev_ca_doc_id3 iby_docs_payable_all.
3529: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
3530: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
3531: prev_ca_doc_id1 iby_docs_payable_all.
3532: calling_app_doc_unique_ref1%TYPE;
3533: prev_ca_doc_id2 iby_docs_payable_all.
3534: calling_app_doc_unique_ref2%TYPE;
3535: prev_ca_doc_id3 iby_docs_payable_all.
3536: calling_app_doc_unique_ref3%TYPE;
3537: prev_ca_doc_id4 iby_docs_payable_all.
3531: prev_ca_doc_id1 iby_docs_payable_all.
3532: calling_app_doc_unique_ref1%TYPE;
3533: prev_ca_doc_id2 iby_docs_payable_all.
3534: calling_app_doc_unique_ref2%TYPE;
3535: prev_ca_doc_id3 iby_docs_payable_all.
3536: calling_app_doc_unique_ref3%TYPE;
3537: prev_ca_doc_id4 iby_docs_payable_all.
3538: calling_app_doc_unique_ref4%TYPE;
3539: prev_ca_doc_id5 iby_docs_payable_all.
3533: prev_ca_doc_id2 iby_docs_payable_all.
3534: calling_app_doc_unique_ref2%TYPE;
3535: prev_ca_doc_id3 iby_docs_payable_all.
3536: calling_app_doc_unique_ref3%TYPE;
3537: prev_ca_doc_id4 iby_docs_payable_all.
3538: calling_app_doc_unique_ref4%TYPE;
3539: prev_ca_doc_id5 iby_docs_payable_all.
3540: calling_app_doc_unique_ref5%TYPE;
3541: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3535: prev_ca_doc_id3 iby_docs_payable_all.
3536: calling_app_doc_unique_ref3%TYPE;
3537: prev_ca_doc_id4 iby_docs_payable_all.
3538: calling_app_doc_unique_ref4%TYPE;
3539: prev_ca_doc_id5 iby_docs_payable_all.
3540: calling_app_doc_unique_ref5%TYPE;
3541: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3542: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3543: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3537: prev_ca_doc_id4 iby_docs_payable_all.
3538: calling_app_doc_unique_ref4%TYPE;
3539: prev_ca_doc_id5 iby_docs_payable_all.
3540: calling_app_doc_unique_ref5%TYPE;
3541: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3542: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3543: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3544: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3545: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3538: calling_app_doc_unique_ref4%TYPE;
3539: prev_ca_doc_id5 iby_docs_payable_all.
3540: calling_app_doc_unique_ref5%TYPE;
3541: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3542: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3543: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3544: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3545: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3546: prev_int_bank_acct_id iby_docs_payable_all.
3539: prev_ca_doc_id5 iby_docs_payable_all.
3540: calling_app_doc_unique_ref5%TYPE;
3541: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3542: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3543: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3544: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3545: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3546: prev_int_bank_acct_id iby_docs_payable_all.
3547: internal_bank_account_id%TYPE;
3540: calling_app_doc_unique_ref5%TYPE;
3541: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3542: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3543: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3544: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3545: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3546: prev_int_bank_acct_id iby_docs_payable_all.
3547: internal_bank_account_id%TYPE;
3548: prev_ext_bank_acct_id iby_docs_payable_all.
3541: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3542: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3543: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3544: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3545: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3546: prev_int_bank_acct_id iby_docs_payable_all.
3547: internal_bank_account_id%TYPE;
3548: prev_ext_bank_acct_id iby_docs_payable_all.
3549: external_bank_account_id%TYPE;
3542: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3543: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3544: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3545: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3546: prev_int_bank_acct_id iby_docs_payable_all.
3547: internal_bank_account_id%TYPE;
3548: prev_ext_bank_acct_id iby_docs_payable_all.
3549: external_bank_account_id%TYPE;
3550: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3544: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3545: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3546: prev_int_bank_acct_id iby_docs_payable_all.
3547: internal_bank_account_id%TYPE;
3548: prev_ext_bank_acct_id iby_docs_payable_all.
3549: external_bank_account_id%TYPE;
3550: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3551: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3552: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3546: prev_int_bank_acct_id iby_docs_payable_all.
3547: internal_bank_account_id%TYPE;
3548: prev_ext_bank_acct_id iby_docs_payable_all.
3549: external_bank_account_id%TYPE;
3550: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3551: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3552: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3553: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3554: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3547: internal_bank_account_id%TYPE;
3548: prev_ext_bank_acct_id iby_docs_payable_all.
3549: external_bank_account_id%TYPE;
3550: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3551: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3552: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3553: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3554: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3555: prev_org_id iby_docs_payable_all.org_id%TYPE;
3548: prev_ext_bank_acct_id iby_docs_payable_all.
3549: external_bank_account_id%TYPE;
3550: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3551: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3552: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3553: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3554: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3555: prev_org_id iby_docs_payable_all.org_id%TYPE;
3556: prev_org_type iby_docs_payable_all.org_type%TYPE;
3549: external_bank_account_id%TYPE;
3550: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3551: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3552: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3553: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3554: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3555: prev_org_id iby_docs_payable_all.org_id%TYPE;
3556: prev_org_type iby_docs_payable_all.org_type%TYPE;
3557: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3550: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3551: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3552: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3553: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3554: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3555: prev_org_id iby_docs_payable_all.org_id%TYPE;
3556: prev_org_type iby_docs_payable_all.org_type%TYPE;
3557: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3558: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3551: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3552: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3553: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3554: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3555: prev_org_id iby_docs_payable_all.org_id%TYPE;
3556: prev_org_type iby_docs_payable_all.org_type%TYPE;
3557: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3558: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3559: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3552: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3553: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3554: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3555: prev_org_id iby_docs_payable_all.org_id%TYPE;
3556: prev_org_type iby_docs_payable_all.org_type%TYPE;
3557: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3558: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3559: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3560: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3553: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3554: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3555: prev_org_id iby_docs_payable_all.org_id%TYPE;
3556: prev_org_type iby_docs_payable_all.org_type%TYPE;
3557: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3558: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3559: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3560: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3561: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3554: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3555: prev_org_id iby_docs_payable_all.org_id%TYPE;
3556: prev_org_type iby_docs_payable_all.org_type%TYPE;
3557: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3558: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3559: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3560: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3561: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3562: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3555: prev_org_id iby_docs_payable_all.org_id%TYPE;
3556: prev_org_type iby_docs_payable_all.org_type%TYPE;
3557: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3558: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3559: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3560: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3561: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3562: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3563: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3556: prev_org_type iby_docs_payable_all.org_type%TYPE;
3557: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3558: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3559: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3560: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3561: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3562: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3563: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3564: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3557: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3558: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3559: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3560: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3561: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3562: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3563: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3564: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3565: prev_uri iby_docs_payable_all.
3558: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3559: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3560: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3561: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3562: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3563: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3564: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3565: prev_uri iby_docs_payable_all.
3566: unique_remittance_identifier%TYPE;
3559: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3560: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3561: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3562: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3563: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3564: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3565: prev_uri iby_docs_payable_all.
3566: unique_remittance_identifier%TYPE;
3567: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3560: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3561: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3562: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3563: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3564: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3565: prev_uri iby_docs_payable_all.
3566: unique_remittance_identifier%TYPE;
3567: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3568: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3561: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3562: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3563: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3564: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3565: prev_uri iby_docs_payable_all.
3566: unique_remittance_identifier%TYPE;
3567: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3568: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3569: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3563: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3564: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3565: prev_uri iby_docs_payable_all.
3566: unique_remittance_identifier%TYPE;
3567: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3568: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3569: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3570: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
3571: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
3564: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3565: prev_uri iby_docs_payable_all.
3566: unique_remittance_identifier%TYPE;
3567: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3568: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3569: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3570: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
3571: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
3572: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3565: prev_uri iby_docs_payable_all.
3566: unique_remittance_identifier%TYPE;
3567: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3568: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3569: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3570: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
3571: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
3572: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3573: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3566: unique_remittance_identifier%TYPE;
3567: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3568: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3569: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3570: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
3571: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
3572: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3573: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3574:
3567: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3568: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3569: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3570: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
3571: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
3572: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3573: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3574:
3575: /* payee (employee) address related fields */
3568: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3569: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3570: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
3571: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
3572: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3573: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3574:
3575: /* payee (employee) address related fields */
3576: prev_address_source iby_docs_payable_all.address_source%TYPE;
3569: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3570: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
3571: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
3572: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3573: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3574:
3575: /* payee (employee) address related fields */
3576: prev_address_source iby_docs_payable_all.address_source%TYPE;
3577: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3572: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3573: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3574:
3575: /* payee (employee) address related fields */
3576: prev_address_source iby_docs_payable_all.address_source%TYPE;
3577: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3578: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
3579: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
3580:
3573: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3574:
3575: /* payee (employee) address related fields */
3576: prev_address_source iby_docs_payable_all.address_source%TYPE;
3577: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3578: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
3579: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
3580:
3581: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
3574:
3575: /* payee (employee) address related fields */
3576: prev_address_source iby_docs_payable_all.address_source%TYPE;
3577: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3578: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
3579: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
3580:
3581: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
3582:
3575: /* payee (employee) address related fields */
3576: prev_address_source iby_docs_payable_all.address_source%TYPE;
3577: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3578: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
3579: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
3580:
3581: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
3582:
3583: /*TPP-Start*/
3577: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3578: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
3579: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
3580:
3581: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
3582:
3583: /*TPP-Start*/
3584: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3585: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3580:
3581: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
3582:
3583: /*TPP-Start*/
3584: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3585: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3586: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3587: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3588: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3581: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
3582:
3583: /*TPP-Start*/
3584: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3585: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3586: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3587: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3588: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3589:
3582:
3583: /*TPP-Start*/
3584: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3585: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3586: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3587: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3588: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3589:
3590: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3583: /*TPP-Start*/
3584: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3585: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3586: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3587: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3588: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3589:
3590: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3591: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3584: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3585: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3586: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3587: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3588: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3589:
3590: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3591: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3592: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3586: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3587: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3588: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3589:
3590: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3591: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3592: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3593: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3594: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3587: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3588: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3589:
3590: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3591: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3592: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3593: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3594: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3595: /*TPP-End*/
3588: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3589:
3590: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3591: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3592: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3593: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3594: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3595: /*TPP-End*/
3596:
3589:
3590: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3591: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3592: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3593: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3594: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3595: /*TPP-End*/
3596:
3597:
3590: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
3591: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
3592: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
3593: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
3594: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
3595: /*TPP-End*/
3596:
3597:
3598: /* current document attributes */
3595: /*TPP-End*/
3596:
3597:
3598: /* current document attributes */
3599: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
3600: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
3601: curr_ca_doc_id1 iby_docs_payable_all.
3602: calling_app_doc_unique_ref1%TYPE;
3603: curr_ca_doc_id2 iby_docs_payable_all.
3596:
3597:
3598: /* current document attributes */
3599: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
3600: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
3601: curr_ca_doc_id1 iby_docs_payable_all.
3602: calling_app_doc_unique_ref1%TYPE;
3603: curr_ca_doc_id2 iby_docs_payable_all.
3604: calling_app_doc_unique_ref2%TYPE;
3597:
3598: /* current document attributes */
3599: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
3600: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
3601: curr_ca_doc_id1 iby_docs_payable_all.
3602: calling_app_doc_unique_ref1%TYPE;
3603: curr_ca_doc_id2 iby_docs_payable_all.
3604: calling_app_doc_unique_ref2%TYPE;
3605: curr_ca_doc_id3 iby_docs_payable_all.
3599: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
3600: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
3601: curr_ca_doc_id1 iby_docs_payable_all.
3602: calling_app_doc_unique_ref1%TYPE;
3603: curr_ca_doc_id2 iby_docs_payable_all.
3604: calling_app_doc_unique_ref2%TYPE;
3605: curr_ca_doc_id3 iby_docs_payable_all.
3606: calling_app_doc_unique_ref3%TYPE;
3607: curr_ca_doc_id4 iby_docs_payable_all.
3601: curr_ca_doc_id1 iby_docs_payable_all.
3602: calling_app_doc_unique_ref1%TYPE;
3603: curr_ca_doc_id2 iby_docs_payable_all.
3604: calling_app_doc_unique_ref2%TYPE;
3605: curr_ca_doc_id3 iby_docs_payable_all.
3606: calling_app_doc_unique_ref3%TYPE;
3607: curr_ca_doc_id4 iby_docs_payable_all.
3608: calling_app_doc_unique_ref4%TYPE;
3609: curr_ca_doc_id5 iby_docs_payable_all.
3603: curr_ca_doc_id2 iby_docs_payable_all.
3604: calling_app_doc_unique_ref2%TYPE;
3605: curr_ca_doc_id3 iby_docs_payable_all.
3606: calling_app_doc_unique_ref3%TYPE;
3607: curr_ca_doc_id4 iby_docs_payable_all.
3608: calling_app_doc_unique_ref4%TYPE;
3609: curr_ca_doc_id5 iby_docs_payable_all.
3610: calling_app_doc_unique_ref5%TYPE;
3611: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3605: curr_ca_doc_id3 iby_docs_payable_all.
3606: calling_app_doc_unique_ref3%TYPE;
3607: curr_ca_doc_id4 iby_docs_payable_all.
3608: calling_app_doc_unique_ref4%TYPE;
3609: curr_ca_doc_id5 iby_docs_payable_all.
3610: calling_app_doc_unique_ref5%TYPE;
3611: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3612: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3613: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3607: curr_ca_doc_id4 iby_docs_payable_all.
3608: calling_app_doc_unique_ref4%TYPE;
3609: curr_ca_doc_id5 iby_docs_payable_all.
3610: calling_app_doc_unique_ref5%TYPE;
3611: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3612: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3613: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3614: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3615: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3608: calling_app_doc_unique_ref4%TYPE;
3609: curr_ca_doc_id5 iby_docs_payable_all.
3610: calling_app_doc_unique_ref5%TYPE;
3611: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3612: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3613: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3614: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3615: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3616: curr_int_bank_acct_id iby_docs_payable_all.
3609: curr_ca_doc_id5 iby_docs_payable_all.
3610: calling_app_doc_unique_ref5%TYPE;
3611: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3612: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3613: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3614: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3615: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3616: curr_int_bank_acct_id iby_docs_payable_all.
3617: internal_bank_account_id%TYPE;
3610: calling_app_doc_unique_ref5%TYPE;
3611: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3612: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3613: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3614: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3615: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3616: curr_int_bank_acct_id iby_docs_payable_all.
3617: internal_bank_account_id%TYPE;
3618: curr_ext_bank_acct_id iby_docs_payable_all.
3611: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
3612: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3613: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3614: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3615: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3616: curr_int_bank_acct_id iby_docs_payable_all.
3617: internal_bank_account_id%TYPE;
3618: curr_ext_bank_acct_id iby_docs_payable_all.
3619: external_bank_account_id%TYPE;
3612: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
3613: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
3614: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3615: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3616: curr_int_bank_acct_id iby_docs_payable_all.
3617: internal_bank_account_id%TYPE;
3618: curr_ext_bank_acct_id iby_docs_payable_all.
3619: external_bank_account_id%TYPE;
3620: curr_org_id iby_docs_payable_all.org_id%TYPE;
3614: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
3615: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
3616: curr_int_bank_acct_id iby_docs_payable_all.
3617: internal_bank_account_id%TYPE;
3618: curr_ext_bank_acct_id iby_docs_payable_all.
3619: external_bank_account_id%TYPE;
3620: curr_org_id iby_docs_payable_all.org_id%TYPE;
3621: curr_org_type iby_docs_payable_all.org_type%TYPE;
3622: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3616: curr_int_bank_acct_id iby_docs_payable_all.
3617: internal_bank_account_id%TYPE;
3618: curr_ext_bank_acct_id iby_docs_payable_all.
3619: external_bank_account_id%TYPE;
3620: curr_org_id iby_docs_payable_all.org_id%TYPE;
3621: curr_org_type iby_docs_payable_all.org_type%TYPE;
3622: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3623: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3624: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3617: internal_bank_account_id%TYPE;
3618: curr_ext_bank_acct_id iby_docs_payable_all.
3619: external_bank_account_id%TYPE;
3620: curr_org_id iby_docs_payable_all.org_id%TYPE;
3621: curr_org_type iby_docs_payable_all.org_type%TYPE;
3622: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3623: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3624: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3625: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3618: curr_ext_bank_acct_id iby_docs_payable_all.
3619: external_bank_account_id%TYPE;
3620: curr_org_id iby_docs_payable_all.org_id%TYPE;
3621: curr_org_type iby_docs_payable_all.org_type%TYPE;
3622: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3623: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3624: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3625: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3626: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3619: external_bank_account_id%TYPE;
3620: curr_org_id iby_docs_payable_all.org_id%TYPE;
3621: curr_org_type iby_docs_payable_all.org_type%TYPE;
3622: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3623: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3624: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3625: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3626: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3627: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3620: curr_org_id iby_docs_payable_all.org_id%TYPE;
3621: curr_org_type iby_docs_payable_all.org_type%TYPE;
3622: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3623: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3624: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3625: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3626: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3627: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3628: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3621: curr_org_type iby_docs_payable_all.org_type%TYPE;
3622: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3623: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3624: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3625: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3626: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3627: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3628: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3629: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3622: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
3623: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3624: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3625: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3626: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3627: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3628: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3629: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3630: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3623: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
3624: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3625: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3626: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3627: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3628: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3629: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3630: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3631: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3624: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
3625: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3626: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3627: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3628: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3629: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3630: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3631: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3632: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3625: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
3626: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3627: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3628: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3629: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3630: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3631: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3632: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3633: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3626: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
3627: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3628: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3629: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3630: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3631: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3632: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3633: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3634: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3627: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
3628: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3629: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3630: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3631: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3632: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3633: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3634: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3635: curr_uri iby_docs_payable_all.
3628: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
3629: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3630: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3631: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3632: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3633: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3634: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3635: curr_uri iby_docs_payable_all.
3636: unique_remittance_identifier%TYPE;
3629: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
3630: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3631: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3632: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3633: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3634: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3635: curr_uri iby_docs_payable_all.
3636: unique_remittance_identifier%TYPE;
3637: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3630: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
3631: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3632: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3633: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3634: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3635: curr_uri iby_docs_payable_all.
3636: unique_remittance_identifier%TYPE;
3637: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3638: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3631: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
3632: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
3633: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3634: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3635: curr_uri iby_docs_payable_all.
3636: unique_remittance_identifier%TYPE;
3637: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3638: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3639: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3633: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
3634: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3635: curr_uri iby_docs_payable_all.
3636: unique_remittance_identifier%TYPE;
3637: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3638: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3639: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3640: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
3641: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
3634: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
3635: curr_uri iby_docs_payable_all.
3636: unique_remittance_identifier%TYPE;
3637: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3638: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3639: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3640: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
3641: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
3642: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3635: curr_uri iby_docs_payable_all.
3636: unique_remittance_identifier%TYPE;
3637: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3638: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3639: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3640: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
3641: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
3642: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3643: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3636: unique_remittance_identifier%TYPE;
3637: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3638: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3639: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3640: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
3641: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
3642: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3643: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3644:
3637: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
3638: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3639: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3640: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
3641: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
3642: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3643: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3644:
3645: /* payee (employee) address related fields */
3638: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
3639: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3640: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
3641: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
3642: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3643: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3644:
3645: /* payee (employee) address related fields */
3646: curr_address_source iby_docs_payable_all.address_source%TYPE;
3639: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
3640: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
3641: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
3642: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3643: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3644:
3645: /* payee (employee) address related fields */
3646: curr_address_source iby_docs_payable_all.address_source%TYPE;
3647: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3642: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
3643: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3644:
3645: /* payee (employee) address related fields */
3646: curr_address_source iby_docs_payable_all.address_source%TYPE;
3647: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3648: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
3649: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
3650:
3643: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
3644:
3645: /* payee (employee) address related fields */
3646: curr_address_source iby_docs_payable_all.address_source%TYPE;
3647: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3648: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
3649: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
3650:
3651: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
3644:
3645: /* payee (employee) address related fields */
3646: curr_address_source iby_docs_payable_all.address_source%TYPE;
3647: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3648: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
3649: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
3650:
3651: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
3652:
3645: /* payee (employee) address related fields */
3646: curr_address_source iby_docs_payable_all.address_source%TYPE;
3647: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3648: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
3649: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
3650:
3651: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
3652:
3653: /* these two are passed to the external application hook */
3647: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
3648: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
3649: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
3650:
3651: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
3652:
3653: /* these two are passed to the external application hook */
3654: l_amount_withheld iby_docs_payable_all.amount_withheld%TYPE;
3655:
3650:
3651: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
3652:
3653: /* these two are passed to the external application hook */
3654: l_amount_withheld iby_docs_payable_all.amount_withheld%TYPE;
3655:
3656: /* used for maturity date calculation */
3657: l_discount_date iby_docs_payable_all.discount_date%TYPE;
3658:
3653: /* these two are passed to the external application hook */
3654: l_amount_withheld iby_docs_payable_all.amount_withheld%TYPE;
3655:
3656: /* used for maturity date calculation */
3657: l_discount_date iby_docs_payable_all.discount_date%TYPE;
3658:
3659: /* passed to hook */
3660: l_discount_amount iby_docs_payable_all.payment_curr_discount_taken
3661: %TYPE;
3656: /* used for maturity date calculation */
3657: l_discount_date iby_docs_payable_all.discount_date%TYPE;
3658:
3659: /* passed to hook */
3660: l_discount_amount iby_docs_payable_all.payment_curr_discount_taken
3661: %TYPE;
3662: l_trx_line_index BINARY_INTEGER;
3663: l_no_rec_in_ppr BOOLEAN;
3664: G_LINES_PER_FETCH CONSTANT NUMBER:= 1000;
3773: docs.inv_beneficiary_party,
3774: docs.ext_inv_payee_id,
3775: /*TPP-Start*/
3776: docs.affects_rejection_level --AWT Enh 16296267
3777: FROM IBY_DOCS_PAYABLE_ALL docs,
3778: IBY_PMT_CREATION_RULES pcr,
3779: IBY_PAYMENT_PROFILES ppf,
3780: IBY_PAY_SERVICE_REQUESTS prq,
3781: IBY_EXTERNAL_PAYEES_ALL ext_payee,
9358: | NAME:
9359: | updateDocsWithPaymentID
9360: |
9361: | PURPOSE:
9362: | Updates individual documents in IBY_DOCS_PAYABLE_ALL table
9363: | with payment ids from given PLSQL table.
9364: |
9365: | PARAMETERS:
9366: | IN
9390: IF (p_docsInPmtTab.COUNT = 0) THEN
9391: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9392: print_debuginfo(l_module_name, 'After grouping, no '
9393: || 'payments/documents provided to update '
9394: || 'IBY_DOCS_PAYABLE_ALL table. Possible data '
9395: || 'corruption issue.');
9396: END IF;
9397:
9398: RETURN;
9419:
9420: END IF;
9421:
9422: UPDATE
9423: IBY_DOCS_PAYABLE_ALL
9424: SET
9425: payment_id = p_docsInPmtTab(i).payment_id,
9426: formatting_payment_id = p_docsInPmtTab(i).payment_id,
9427: document_status = p_docsInPmtTab(i).document_status,
9473: | NAME:
9474: | updateDocsWithPaymentID
9475: |
9476: | PURPOSE:
9477: | Updates individual documents in IBY_DOCS_PAYABLE_ALL table
9478: | with payment ids from given PLSQL table.
9479: |
9480: | PARAMETERS:
9481: | IN
9508: *
9509: * TBD: Is there any way to optimize this update?
9510: */
9511: MERGE
9512: INTO iby_docs_payable_all idpa
9513: /* Oracle 10gR2 doesn't require WHEN NOT MATCHED */
9514: USING iby_docs_in_pmt_gt idpt ON(idpt.document_payable_id = idpa.document_payable_id)
9515: WHEN MATCHED THEN UPDATE
9516: SET idpa.payment_id = idpt.payment_id,
10962: )
10963: IS
10964:
10965: l_orig_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
10966: l_orig_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
10967: l_orig_pmt_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
10968:
10969: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
10970: l_compare_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
10963: IS
10964:
10965: l_orig_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
10966: l_orig_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
10967: l_orig_pmt_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
10968:
10969: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
10970: l_compare_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
10971:
10966: l_orig_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
10967: l_orig_pmt_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
10968:
10969: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
10970: l_compare_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
10971:
10972: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
10973:
10974: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
13828:
13829: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
13830: '.adjustSisterDocsAndPmts';
13831:
13832: l_document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE;
13833:
13834: l_payment_id_indx IBY_DOCS_PAYABLE_ALL.payment_id%TYPE;
13835:
13836: l_prev_payment_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
13830: '.adjustSisterDocsAndPmts';
13831:
13832: l_document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE;
13833:
13834: l_payment_id_indx IBY_DOCS_PAYABLE_ALL.payment_id%TYPE;
13835:
13836: l_prev_payment_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
13837:
13838:
13832: l_document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE;
13833:
13834: l_payment_id_indx IBY_DOCS_PAYABLE_ALL.payment_id%TYPE;
13835:
13836: l_prev_payment_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
13837:
13838:
13839:
13840: CURSOR c_adjust_sdap IS
14057:
14058: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
14059: '.adjustSisterDocsAndPmtsPost';
14060:
14061: l_document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE;
14062:
14063: l_payment_id_indx IBY_DOCS_PAYABLE_ALL.payment_id%TYPE;
14064:
14065: l_prev_payment_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
14059: '.adjustSisterDocsAndPmtsPost';
14060:
14061: l_document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE;
14062:
14063: l_payment_id_indx IBY_DOCS_PAYABLE_ALL.payment_id%TYPE;
14064:
14065: l_prev_payment_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
14066:
14067:
14061: l_document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE;
14062:
14063: l_payment_id_indx IBY_DOCS_PAYABLE_ALL.payment_id%TYPE;
14064:
14065: l_prev_payment_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
14066:
14067:
14068:
14069: CURSOR c_adjust_sdap IS
14288:
14289: END IF;
14290:
14291: l_sql_string := 'SELECT ' || p_pmtDetailsFormula || ' FROM '
14292: || 'IBY_DOCS_PAYABLE_ALL WHERE '
14293: || 'document_payable_id = :bind_var';
14294:
14295: EXECUTE IMMEDIATE l_sql_string INTO l_calc_doc_details USING p_documentID;
14296:
15589: |
15590: *---------------------------------------------------------------------*/
15591: PROCEDURE failDocsOfPayment(
15592: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
15593: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
15594: document_status%TYPE,
15595: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
15596: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
15597: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
15687: |
15688: *---------------------------------------------------------------------*/
15689: PROCEDURE failDocsOfPayment(
15690: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
15691: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
15692: document_status%TYPE,
15693: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
15694: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
15695: )
16125: FROM
16126: IBY_REMIT_ADVICE_SETUP advice,
16127: IBY_PAYMENT_PROFILES ppp,
16128: IBY_PAYMENTS_ALL pmt,
16129: IBY_DOCS_PAYABLE_ALL docs
16130:
16131: WHERE
16132: remittance_advice_format_code IS NOT NULL
16133: AND advice.SYSTEM_PROFILE_CODE = ppp.SYSTEM_PROFILE_CODE
19282: || 'calling_app_doc_unique_ref3'
19283: || 'calling_app_doc_unique_ref4'
19284: || 'calling_app_doc_unique_ref5'
19285: || 'pay_proc_trxn_type_id '
19286: || 'FROM IBY_DOCS_PAYABLE_ALL '
19287: || 'WHERE payment_service_request_id = :payreq_id '
19288: || 'AND document_status <> :doc_status '
19289: || 'AND payment_id IS NOT NULL';
19290:
19390: SELECT
19391: doc.document_payable_id,
19392: doc.document_status
19393: FROM
19394: IBY_DOCS_PAYABLE_ALL doc
19395: WHERE
19396: doc.payment_service_request_id = p_payreq_id AND
19397: doc.document_status <> DOC_STATUS_PAY_CREATED AND
19398: doc.payment_id IS NOT NULL
22531: inv_beneficiary_party,
22532: ext_inv_payee_id,
22533: relationship_id
22534: FROM
22535: IBY_DOCS_PAYABLE_ALL
22536: WHERE
22537: payment_service_request_id = p_payment_request_id AND
22538: payment_id = p_payment_id AND
22539: document_status IN
22959: 'N',
22960: null,
22961: null
22962: FROM
22963: IBY_DOCS_PAYABLE_ALL idpa, IBY_PAYMENTS_ALL ibpa
22964: WHERE
22965: idpa.payment_service_request_id = p_payment_request_id
22966: AND idpa.payment_service_request_id = ibpa.payment_service_request_id
22967: AND idpa.payment_id = ibpa.payment_id