eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYGROUP_PUB dependencies on IBY_DOCS_PAYABLE_ALL

Line 738: * used to update the rows in IBY_DOCS_PAYABLE_ALL table with

734: * Since the IBY_PAYMENTS_ALL table does not contain a document id, a
735: * separate data structure is needed to keep track of the documents
736: * that are part of a payment. This information is tracked in the
737: * docsInPaymentTabType table. The rows in docsInPaymentTabType are
738: * used to update the rows in IBY_DOCS_PAYABLE_ALL table with
739: * payment ids.
740: *
741: * x_paymentTab x_docsInPmtTab
742: * (insert into IBY_PAYMENTS_ALL) (update IBY_DOCS_PAYABLE)

Line 777: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;

773: /* holds list of internal bank accounts with corresponding legal entity id */
774: l_bankAcctLETab bankAccountLETabType;
775:
776: /* previous document attributes */
777: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
778: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
779: prev_ca_doc_id1 iby_docs_payable_all.
780: calling_app_doc_unique_ref1%TYPE;
781: prev_ca_doc_id2 iby_docs_payable_all.

Line 778: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;

774: l_bankAcctLETab bankAccountLETabType;
775:
776: /* previous document attributes */
777: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
778: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
779: prev_ca_doc_id1 iby_docs_payable_all.
780: calling_app_doc_unique_ref1%TYPE;
781: prev_ca_doc_id2 iby_docs_payable_all.
782: calling_app_doc_unique_ref2%TYPE;

Line 779: prev_ca_doc_id1 iby_docs_payable_all.

775:
776: /* previous document attributes */
777: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
778: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
779: prev_ca_doc_id1 iby_docs_payable_all.
780: calling_app_doc_unique_ref1%TYPE;
781: prev_ca_doc_id2 iby_docs_payable_all.
782: calling_app_doc_unique_ref2%TYPE;
783: prev_ca_doc_id3 iby_docs_payable_all.

Line 781: prev_ca_doc_id2 iby_docs_payable_all.

777: prev_doc_id iby_docs_payable_all.document_payable_id%TYPE;
778: prev_ca_id iby_docs_payable_all.calling_app_id%TYPE;
779: prev_ca_doc_id1 iby_docs_payable_all.
780: calling_app_doc_unique_ref1%TYPE;
781: prev_ca_doc_id2 iby_docs_payable_all.
782: calling_app_doc_unique_ref2%TYPE;
783: prev_ca_doc_id3 iby_docs_payable_all.
784: calling_app_doc_unique_ref3%TYPE;
785: prev_ca_doc_id4 iby_docs_payable_all.

Line 783: prev_ca_doc_id3 iby_docs_payable_all.

779: prev_ca_doc_id1 iby_docs_payable_all.
780: calling_app_doc_unique_ref1%TYPE;
781: prev_ca_doc_id2 iby_docs_payable_all.
782: calling_app_doc_unique_ref2%TYPE;
783: prev_ca_doc_id3 iby_docs_payable_all.
784: calling_app_doc_unique_ref3%TYPE;
785: prev_ca_doc_id4 iby_docs_payable_all.
786: calling_app_doc_unique_ref4%TYPE;
787: prev_ca_doc_id5 iby_docs_payable_all.

Line 785: prev_ca_doc_id4 iby_docs_payable_all.

781: prev_ca_doc_id2 iby_docs_payable_all.
782: calling_app_doc_unique_ref2%TYPE;
783: prev_ca_doc_id3 iby_docs_payable_all.
784: calling_app_doc_unique_ref3%TYPE;
785: prev_ca_doc_id4 iby_docs_payable_all.
786: calling_app_doc_unique_ref4%TYPE;
787: prev_ca_doc_id5 iby_docs_payable_all.
788: calling_app_doc_unique_ref5%TYPE;
789: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;

Line 787: prev_ca_doc_id5 iby_docs_payable_all.

783: prev_ca_doc_id3 iby_docs_payable_all.
784: calling_app_doc_unique_ref3%TYPE;
785: prev_ca_doc_id4 iby_docs_payable_all.
786: calling_app_doc_unique_ref4%TYPE;
787: prev_ca_doc_id5 iby_docs_payable_all.
788: calling_app_doc_unique_ref5%TYPE;
789: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
790: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
791: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;

Line 789: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;

785: prev_ca_doc_id4 iby_docs_payable_all.
786: calling_app_doc_unique_ref4%TYPE;
787: prev_ca_doc_id5 iby_docs_payable_all.
788: calling_app_doc_unique_ref5%TYPE;
789: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
790: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
791: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
792: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
793: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;

Line 790: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;

786: calling_app_doc_unique_ref4%TYPE;
787: prev_ca_doc_id5 iby_docs_payable_all.
788: calling_app_doc_unique_ref5%TYPE;
789: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
790: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
791: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
792: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
793: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
794: prev_int_bank_acct_id iby_docs_payable_all.

Line 791: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;

787: prev_ca_doc_id5 iby_docs_payable_all.
788: calling_app_doc_unique_ref5%TYPE;
789: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
790: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
791: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
792: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
793: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
794: prev_int_bank_acct_id iby_docs_payable_all.
795: internal_bank_account_id%TYPE;

Line 792: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;

788: calling_app_doc_unique_ref5%TYPE;
789: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
790: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
791: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
792: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
793: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
794: prev_int_bank_acct_id iby_docs_payable_all.
795: internal_bank_account_id%TYPE;
796: prev_ext_bank_acct_id iby_docs_payable_all.

Line 793: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;

789: prev_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
790: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
791: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
792: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
793: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
794: prev_int_bank_acct_id iby_docs_payable_all.
795: internal_bank_account_id%TYPE;
796: prev_ext_bank_acct_id iby_docs_payable_all.
797: external_bank_account_id%TYPE;

Line 794: prev_int_bank_acct_id iby_docs_payable_all.

790: prev_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
791: prev_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
792: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
793: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
794: prev_int_bank_acct_id iby_docs_payable_all.
795: internal_bank_account_id%TYPE;
796: prev_ext_bank_acct_id iby_docs_payable_all.
797: external_bank_account_id%TYPE;
798: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;

Line 796: prev_ext_bank_acct_id iby_docs_payable_all.

792: prev_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
793: prev_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
794: prev_int_bank_acct_id iby_docs_payable_all.
795: internal_bank_account_id%TYPE;
796: prev_ext_bank_acct_id iby_docs_payable_all.
797: external_bank_account_id%TYPE;
798: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
799: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
800: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;

Line 798: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;

794: prev_int_bank_acct_id iby_docs_payable_all.
795: internal_bank_account_id%TYPE;
796: prev_ext_bank_acct_id iby_docs_payable_all.
797: external_bank_account_id%TYPE;
798: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
799: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
800: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
801: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
802: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;

Line 799: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;

795: internal_bank_account_id%TYPE;
796: prev_ext_bank_acct_id iby_docs_payable_all.
797: external_bank_account_id%TYPE;
798: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
799: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
800: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
801: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
802: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
803: prev_org_id iby_docs_payable_all.org_id%TYPE;

Line 800: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;

796: prev_ext_bank_acct_id iby_docs_payable_all.
797: external_bank_account_id%TYPE;
798: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
799: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
800: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
801: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
802: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
803: prev_org_id iby_docs_payable_all.org_id%TYPE;
804: prev_org_type iby_docs_payable_all.org_type%TYPE;

Line 801: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;

797: external_bank_account_id%TYPE;
798: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
799: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
800: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
801: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
802: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
803: prev_org_id iby_docs_payable_all.org_id%TYPE;
804: prev_org_type iby_docs_payable_all.org_type%TYPE;
805: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;

Line 802: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;

798: prev_payee_id iby_docs_payable_all.payee_party_id%TYPE;
799: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
800: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
801: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
802: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
803: prev_org_id iby_docs_payable_all.org_id%TYPE;
804: prev_org_type iby_docs_payable_all.org_type%TYPE;
805: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
806: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;

Line 803: prev_org_id iby_docs_payable_all.org_id%TYPE;

799: prev_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
800: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
801: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
802: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
803: prev_org_id iby_docs_payable_all.org_id%TYPE;
804: prev_org_type iby_docs_payable_all.org_type%TYPE;
805: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
806: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
807: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;

Line 804: prev_org_type iby_docs_payable_all.org_type%TYPE;

800: prev_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
801: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
802: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
803: prev_org_id iby_docs_payable_all.org_id%TYPE;
804: prev_org_type iby_docs_payable_all.org_type%TYPE;
805: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
806: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
807: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
808: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;

Line 805: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;

801: prev_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
802: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
803: prev_org_id iby_docs_payable_all.org_id%TYPE;
804: prev_org_type iby_docs_payable_all.org_type%TYPE;
805: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
806: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
807: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
808: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
809: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;

Line 806: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;

802: prev_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
803: prev_org_id iby_docs_payable_all.org_id%TYPE;
804: prev_org_type iby_docs_payable_all.org_type%TYPE;
805: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
806: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
807: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
808: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
809: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
810: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;

Line 807: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;

803: prev_org_id iby_docs_payable_all.org_id%TYPE;
804: prev_org_type iby_docs_payable_all.org_type%TYPE;
805: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
806: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
807: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
808: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
809: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
810: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
811: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;

Line 808: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;

804: prev_org_type iby_docs_payable_all.org_type%TYPE;
805: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
806: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
807: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
808: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
809: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
810: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
811: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
812: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;

Line 809: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;

805: prev_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
806: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
807: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
808: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
809: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
810: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
811: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
812: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
813: prev_uri iby_docs_payable_all.

Line 810: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;

806: prev_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
807: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
808: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
809: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
810: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
811: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
812: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
813: prev_uri iby_docs_payable_all.
814: unique_remittance_identifier%TYPE;

Line 811: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;

807: prev_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
808: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
809: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
810: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
811: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
812: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
813: prev_uri iby_docs_payable_all.
814: unique_remittance_identifier%TYPE;
815: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;

Line 812: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;

808: prev_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
809: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
810: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
811: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
812: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
813: prev_uri iby_docs_payable_all.
814: unique_remittance_identifier%TYPE;
815: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
816: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;

Line 813: prev_uri iby_docs_payable_all.

809: prev_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
810: prev_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
811: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
812: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
813: prev_uri iby_docs_payable_all.
814: unique_remittance_identifier%TYPE;
815: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
816: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
817: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;

Line 815: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;

811: prev_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
812: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
813: prev_uri iby_docs_payable_all.
814: unique_remittance_identifier%TYPE;
815: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
816: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
817: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
818: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
819: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;

Line 816: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;

812: prev_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
813: prev_uri iby_docs_payable_all.
814: unique_remittance_identifier%TYPE;
815: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
816: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
817: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
818: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
819: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
820: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;

Line 817: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;

813: prev_uri iby_docs_payable_all.
814: unique_remittance_identifier%TYPE;
815: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
816: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
817: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
818: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
819: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
820: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
821: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;

Line 818: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;

814: unique_remittance_identifier%TYPE;
815: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
816: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
817: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
818: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
819: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
820: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
821: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
822:

Line 819: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;

815: prev_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
816: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
817: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
818: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
819: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
820: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
821: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
822:
823: /* payee (employee) address related fields */

Line 820: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;

816: prev_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
817: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
818: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
819: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
820: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
821: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
822:
823: /* payee (employee) address related fields */
824: prev_address_source iby_docs_payable_all.address_source%TYPE;

Line 821: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;

817: prev_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
818: prev_pmt_function iby_docs_payable_all.payment_function%TYPE;
819: prev_pmt_date iby_docs_payable_all.payment_date%TYPE;
820: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
821: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
822:
823: /* payee (employee) address related fields */
824: prev_address_source iby_docs_payable_all.address_source%TYPE;
825: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;

Line 824: prev_address_source iby_docs_payable_all.address_source%TYPE;

820: prev_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
821: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
822:
823: /* payee (employee) address related fields */
824: prev_address_source iby_docs_payable_all.address_source%TYPE;
825: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
826: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
827: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
828:

Line 825: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;

821: prev_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
822:
823: /* payee (employee) address related fields */
824: prev_address_source iby_docs_payable_all.address_source%TYPE;
825: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
826: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
827: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
828:
829: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;

Line 826: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;

822:
823: /* payee (employee) address related fields */
824: prev_address_source iby_docs_payable_all.address_source%TYPE;
825: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
826: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
827: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
828:
829: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
830:

Line 827: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;

823: /* payee (employee) address related fields */
824: prev_address_source iby_docs_payable_all.address_source%TYPE;
825: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
826: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
827: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
828:
829: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
830:
831: /*TPP-Start*/

Line 829: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;

825: prev_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
826: prev_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
827: prev_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
828:
829: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
830:
831: /*TPP-Start*/
832: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
833: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;

Line 832: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;

828:
829: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
830:
831: /*TPP-Start*/
832: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
833: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
834: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
835: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
836: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;

Line 833: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;

829: prev_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
830:
831: /*TPP-Start*/
832: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
833: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
834: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
835: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
836: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
837:

Line 834: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;

830:
831: /*TPP-Start*/
832: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
833: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
834: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
835: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
836: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
837:
838: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;

Line 835: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;

831: /*TPP-Start*/
832: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
833: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
834: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
835: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
836: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
837:
838: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
839: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;

Line 836: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;

832: prev_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
833: prev_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
834: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
835: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
836: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
837:
838: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
839: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
840: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;

Line 838: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;

834: prev_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
835: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
836: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
837:
838: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
839: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
840: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
841: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
842: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;

Line 839: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;

835: prev_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
836: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
837:
838: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
839: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
840: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
841: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
842: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
843: /*TPP-End*/

Line 840: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;

836: prev_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
837:
838: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
839: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
840: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
841: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
842: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
843: /*TPP-End*/
844:

Line 841: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;

837:
838: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
839: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
840: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
841: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
842: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
843: /*TPP-End*/
844:
845:

Line 842: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;

838: curr_inv_payee_party_id iby_docs_payable_all.inv_payee_party_id%TYPE;
839: curr_inv_party_site_id iby_docs_payable_all.inv_party_site_id%TYPE;
840: curr_inv_supplier_site_id iby_docs_payable_all.inv_supplier_site_id%TYPE;
841: curr_ext_inv_payee_id iby_docs_payable_all.ext_inv_payee_id%TYPE;
842: curr_inv_beneficiary_party iby_docs_payable_all.inv_beneficiary_party%TYPE;
843: /*TPP-End*/
844:
845:
846: /* current document attributes */

Line 847: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;

843: /*TPP-End*/
844:
845:
846: /* current document attributes */
847: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
848: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
849: curr_ca_doc_id1 iby_docs_payable_all.
850: calling_app_doc_unique_ref1%TYPE;
851: curr_ca_doc_id2 iby_docs_payable_all.

Line 848: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;

844:
845:
846: /* current document attributes */
847: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
848: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
849: curr_ca_doc_id1 iby_docs_payable_all.
850: calling_app_doc_unique_ref1%TYPE;
851: curr_ca_doc_id2 iby_docs_payable_all.
852: calling_app_doc_unique_ref2%TYPE;

Line 849: curr_ca_doc_id1 iby_docs_payable_all.

845:
846: /* current document attributes */
847: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
848: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
849: curr_ca_doc_id1 iby_docs_payable_all.
850: calling_app_doc_unique_ref1%TYPE;
851: curr_ca_doc_id2 iby_docs_payable_all.
852: calling_app_doc_unique_ref2%TYPE;
853: curr_ca_doc_id3 iby_docs_payable_all.

Line 851: curr_ca_doc_id2 iby_docs_payable_all.

847: curr_doc_id iby_docs_payable_all.document_payable_id%TYPE;
848: curr_ca_id iby_docs_payable_all.calling_app_id%TYPE;
849: curr_ca_doc_id1 iby_docs_payable_all.
850: calling_app_doc_unique_ref1%TYPE;
851: curr_ca_doc_id2 iby_docs_payable_all.
852: calling_app_doc_unique_ref2%TYPE;
853: curr_ca_doc_id3 iby_docs_payable_all.
854: calling_app_doc_unique_ref3%TYPE;
855: curr_ca_doc_id4 iby_docs_payable_all.

Line 853: curr_ca_doc_id3 iby_docs_payable_all.

849: curr_ca_doc_id1 iby_docs_payable_all.
850: calling_app_doc_unique_ref1%TYPE;
851: curr_ca_doc_id2 iby_docs_payable_all.
852: calling_app_doc_unique_ref2%TYPE;
853: curr_ca_doc_id3 iby_docs_payable_all.
854: calling_app_doc_unique_ref3%TYPE;
855: curr_ca_doc_id4 iby_docs_payable_all.
856: calling_app_doc_unique_ref4%TYPE;
857: curr_ca_doc_id5 iby_docs_payable_all.

Line 855: curr_ca_doc_id4 iby_docs_payable_all.

851: curr_ca_doc_id2 iby_docs_payable_all.
852: calling_app_doc_unique_ref2%TYPE;
853: curr_ca_doc_id3 iby_docs_payable_all.
854: calling_app_doc_unique_ref3%TYPE;
855: curr_ca_doc_id4 iby_docs_payable_all.
856: calling_app_doc_unique_ref4%TYPE;
857: curr_ca_doc_id5 iby_docs_payable_all.
858: calling_app_doc_unique_ref5%TYPE;
859: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;

Line 857: curr_ca_doc_id5 iby_docs_payable_all.

853: curr_ca_doc_id3 iby_docs_payable_all.
854: calling_app_doc_unique_ref3%TYPE;
855: curr_ca_doc_id4 iby_docs_payable_all.
856: calling_app_doc_unique_ref4%TYPE;
857: curr_ca_doc_id5 iby_docs_payable_all.
858: calling_app_doc_unique_ref5%TYPE;
859: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
860: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
861: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;

Line 859: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;

855: curr_ca_doc_id4 iby_docs_payable_all.
856: calling_app_doc_unique_ref4%TYPE;
857: curr_ca_doc_id5 iby_docs_payable_all.
858: calling_app_doc_unique_ref5%TYPE;
859: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
860: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
861: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
862: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
863: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;

Line 860: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;

856: calling_app_doc_unique_ref4%TYPE;
857: curr_ca_doc_id5 iby_docs_payable_all.
858: calling_app_doc_unique_ref5%TYPE;
859: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
860: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
861: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
862: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
863: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
864: curr_int_bank_acct_id iby_docs_payable_all.

Line 861: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;

857: curr_ca_doc_id5 iby_docs_payable_all.
858: calling_app_doc_unique_ref5%TYPE;
859: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
860: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
861: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
862: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
863: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
864: curr_int_bank_acct_id iby_docs_payable_all.
865: internal_bank_account_id%TYPE;

Line 862: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;

858: calling_app_doc_unique_ref5%TYPE;
859: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
860: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
861: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
862: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
863: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
864: curr_int_bank_acct_id iby_docs_payable_all.
865: internal_bank_account_id%TYPE;
866: curr_ext_bank_acct_id iby_docs_payable_all.

Line 863: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;

859: curr_pp_tt_cd iby_docs_payable_all.pay_proc_trxn_type_code%TYPE;
860: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
861: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
862: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
863: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
864: curr_int_bank_acct_id iby_docs_payable_all.
865: internal_bank_account_id%TYPE;
866: curr_ext_bank_acct_id iby_docs_payable_all.
867: external_bank_account_id%TYPE;

Line 864: curr_int_bank_acct_id iby_docs_payable_all.

860: curr_pmt_grp_num iby_docs_payable_all.payment_grouping_number%TYPE;
861: curr_pmt_method_cd iby_docs_payable_all.payment_method_code%TYPE;
862: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
863: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
864: curr_int_bank_acct_id iby_docs_payable_all.
865: internal_bank_account_id%TYPE;
866: curr_ext_bank_acct_id iby_docs_payable_all.
867: external_bank_account_id%TYPE;
868: curr_org_id iby_docs_payable_all.org_id%TYPE;

Line 866: curr_ext_bank_acct_id iby_docs_payable_all.

862: curr_doc_pmt_currency iby_docs_payable_all.payment_currency_code%TYPE;
863: curr_doc_pmt_amount iby_docs_payable_all.payment_amount%TYPE;
864: curr_int_bank_acct_id iby_docs_payable_all.
865: internal_bank_account_id%TYPE;
866: curr_ext_bank_acct_id iby_docs_payable_all.
867: external_bank_account_id%TYPE;
868: curr_org_id iby_docs_payable_all.org_id%TYPE;
869: curr_org_type iby_docs_payable_all.org_type%TYPE;
870: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;

Line 868: curr_org_id iby_docs_payable_all.org_id%TYPE;

864: curr_int_bank_acct_id iby_docs_payable_all.
865: internal_bank_account_id%TYPE;
866: curr_ext_bank_acct_id iby_docs_payable_all.
867: external_bank_account_id%TYPE;
868: curr_org_id iby_docs_payable_all.org_id%TYPE;
869: curr_org_type iby_docs_payable_all.org_type%TYPE;
870: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
871: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
872: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;

Line 869: curr_org_type iby_docs_payable_all.org_type%TYPE;

865: internal_bank_account_id%TYPE;
866: curr_ext_bank_acct_id iby_docs_payable_all.
867: external_bank_account_id%TYPE;
868: curr_org_id iby_docs_payable_all.org_id%TYPE;
869: curr_org_type iby_docs_payable_all.org_type%TYPE;
870: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
871: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
872: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
873: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;

Line 870: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;

866: curr_ext_bank_acct_id iby_docs_payable_all.
867: external_bank_account_id%TYPE;
868: curr_org_id iby_docs_payable_all.org_id%TYPE;
869: curr_org_type iby_docs_payable_all.org_type%TYPE;
870: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
871: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
872: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
873: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
874: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;

Line 871: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;

867: external_bank_account_id%TYPE;
868: curr_org_id iby_docs_payable_all.org_id%TYPE;
869: curr_org_type iby_docs_payable_all.org_type%TYPE;
870: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
871: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
872: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
873: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
874: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
875: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;

Line 872: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;

868: curr_org_id iby_docs_payable_all.org_id%TYPE;
869: curr_org_type iby_docs_payable_all.org_type%TYPE;
870: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
871: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
872: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
873: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
874: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
875: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
876: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;

Line 873: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;

869: curr_org_type iby_docs_payable_all.org_type%TYPE;
870: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
871: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
872: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
873: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
874: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
875: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
876: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
877: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;

Line 874: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;

870: curr_payee_id iby_docs_payable_all.payee_party_id%TYPE;
871: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
872: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
873: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
874: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
875: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
876: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
877: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
878: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;

Line 875: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;

871: curr_payee_site_id iby_docs_payable_all.party_site_id%TYPE;
872: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
873: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
874: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
875: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
876: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
877: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
878: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
879: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;

Line 876: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;

872: curr_supplier_site_id iby_docs_payable_all.supplier_site_id%TYPE;
873: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
874: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
875: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
876: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
877: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
878: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
879: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
880: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;

Line 877: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;

873: curr_remit_loc_id iby_docs_payable_all.remit_to_location_id%TYPE;
874: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
875: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
876: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
877: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
878: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
879: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
880: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
881: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;

Line 878: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;

874: curr_ext_payee_id iby_docs_payable_all.ext_payee_id%TYPE;
875: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
876: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
877: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
878: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
879: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
880: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
881: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
882: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;

Line 879: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;

875: curr_profile_id iby_docs_payable_all.payment_profile_id%TYPE;
876: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
877: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
878: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
879: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
880: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
881: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
882: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
883: curr_uri iby_docs_payable_all.

Line 880: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;

876: curr_pay_alone_flag iby_docs_payable_all.exclusive_payment_flag%TYPE;
877: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
878: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
879: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
880: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
881: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
882: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
883: curr_uri iby_docs_payable_all.
884: unique_remittance_identifier%TYPE;

Line 881: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;

877: curr_supplier_msg1 iby_docs_payable_all.remittance_message1%TYPE;
878: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
879: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
880: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
881: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
882: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
883: curr_uri iby_docs_payable_all.
884: unique_remittance_identifier%TYPE;
885: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;

Line 882: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;

878: curr_supplier_msg2 iby_docs_payable_all.remittance_message2%TYPE;
879: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
880: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
881: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
882: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
883: curr_uri iby_docs_payable_all.
884: unique_remittance_identifier%TYPE;
885: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
886: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;

Line 883: curr_uri iby_docs_payable_all.

879: curr_supplier_msg3 iby_docs_payable_all.remittance_message3%TYPE;
880: curr_bnk_chg_bearer iby_docs_payable_all.bank_charge_bearer%TYPE;
881: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
882: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
883: curr_uri iby_docs_payable_all.
884: unique_remittance_identifier%TYPE;
885: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
886: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
887: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;

Line 885: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;

881: curr_delivery_channel iby_docs_payable_all.delivery_channel_code%TYPE;
882: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
883: curr_uri iby_docs_payable_all.
884: unique_remittance_identifier%TYPE;
885: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
886: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
887: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
888: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
889: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;

Line 886: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;

882: curr_settle_priority iby_docs_payable_all.settlement_priority%TYPE;
883: curr_uri iby_docs_payable_all.
884: unique_remittance_identifier%TYPE;
885: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
886: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
887: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
888: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
889: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
890: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;

Line 887: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;

883: curr_uri iby_docs_payable_all.
884: unique_remittance_identifier%TYPE;
885: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
886: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
887: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
888: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
889: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
890: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
891: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;

Line 888: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;

884: unique_remittance_identifier%TYPE;
885: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
886: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
887: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
888: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
889: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
890: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
891: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
892:

Line 889: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;

885: curr_uri_checkdigits iby_docs_payable_all.uri_check_digit%TYPE;
886: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
887: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
888: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
889: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
890: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
891: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
892:
893: /* payee (employee) address related fields */

Line 890: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;

886: curr_pmt_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
887: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
888: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
889: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
890: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
891: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
892:
893: /* payee (employee) address related fields */
894: curr_address_source iby_docs_payable_all.address_source%TYPE;

Line 891: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;

887: curr_pmt_reason_commts iby_docs_payable_all.payment_reason_comments%TYPE;
888: curr_pmt_function iby_docs_payable_all.payment_function%TYPE;
889: curr_pmt_date iby_docs_payable_all.payment_date%TYPE;
890: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
891: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
892:
893: /* payee (employee) address related fields */
894: curr_address_source iby_docs_payable_all.address_source%TYPE;
895: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;

Line 894: curr_address_source iby_docs_payable_all.address_source%TYPE;

890: curr_pmt_due_date iby_docs_payable_all.payment_due_date%TYPE;
891: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
892:
893: /* payee (employee) address related fields */
894: curr_address_source iby_docs_payable_all.address_source%TYPE;
895: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
896: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
897: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
898:

Line 895: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;

891: curr_benef_party iby_docs_payable_all.beneficiary_party%TYPE;
892:
893: /* payee (employee) address related fields */
894: curr_address_source iby_docs_payable_all.address_source%TYPE;
895: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
896: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
897: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
898:
899: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;

Line 896: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;

892:
893: /* payee (employee) address related fields */
894: curr_address_source iby_docs_payable_all.address_source%TYPE;
895: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
896: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
897: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
898:
899: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
900:

Line 897: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;

893: /* payee (employee) address related fields */
894: curr_address_source iby_docs_payable_all.address_source%TYPE;
895: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
896: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
897: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
898:
899: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
900:
901: /* these two are passed to the external application hook */

Line 899: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;

895: curr_emp_add_code iby_docs_payable_all.employee_address_code%TYPE;
896: curr_emp_person_id iby_docs_payable_all.employee_person_id%TYPE;
897: curr_emp_addr_id iby_docs_payable_all.employee_address_id%TYPE;
898:
899: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
900:
901: /* these two are passed to the external application hook */
902: l_amount_withheld iby_docs_payable_all.amount_withheld%TYPE;
903:

Line 902: l_amount_withheld iby_docs_payable_all.amount_withheld%TYPE;

898:
899: curr_emp_pmt_flag iby_docs_payable_all.employee_payment_flag%TYPE;
900:
901: /* these two are passed to the external application hook */
902: l_amount_withheld iby_docs_payable_all.amount_withheld%TYPE;
903:
904: /* used for maturity date calculation */
905: l_discount_date iby_docs_payable_all.discount_date%TYPE;
906:

Line 905: l_discount_date iby_docs_payable_all.discount_date%TYPE;

901: /* these two are passed to the external application hook */
902: l_amount_withheld iby_docs_payable_all.amount_withheld%TYPE;
903:
904: /* used for maturity date calculation */
905: l_discount_date iby_docs_payable_all.discount_date%TYPE;
906:
907: /* passed to hook */
908: l_discount_amount iby_docs_payable_all.payment_curr_discount_taken
909: %TYPE;

Line 908: l_discount_amount iby_docs_payable_all.payment_curr_discount_taken

904: /* used for maturity date calculation */
905: l_discount_date iby_docs_payable_all.discount_date%TYPE;
906:
907: /* passed to hook */
908: l_discount_amount iby_docs_payable_all.payment_curr_discount_taken
909: %TYPE;
910: l_trx_line_index BINARY_INTEGER;
911: l_no_rec_in_ppr BOOLEAN;
912: G_LINES_PER_FETCH CONSTANT NUMBER:= 1000;

Line 1024: FROM IBY_DOCS_PAYABLE_ALL docs,

1020: docs.inv_supplier_site_id,
1021: docs.inv_beneficiary_party,
1022: docs.ext_inv_payee_id
1023: /*TPP-Start*/
1024: FROM IBY_DOCS_PAYABLE_ALL docs,
1025: IBY_PMT_CREATION_RULES pcr,
1026: IBY_PAYMENT_PROFILES ppf,
1027: IBY_PAY_SERVICE_REQUESTS prq,
1028: IBY_EXTERNAL_PAYEES_ALL ext_payee,

Line 3801: | Updates individual documents in IBY_DOCS_PAYABLE_ALL table

Line 3831: || 'IBY_DOCS_PAYABLE_ALL table. Possible data '

3827: /* Normally, this should not happen */
3828: IF (p_docsInPmtTab.COUNT = 0) THEN
3829: print_debuginfo(l_module_name, 'After grouping, no '
3830: || 'payments/documents provided to update '
3831: || 'IBY_DOCS_PAYABLE_ALL table. Possible data '
3832: || 'corruption issue.');
3833: RETURN;
3834: END IF;
3835:

Line 3855: IBY_DOCS_PAYABLE_ALL

3851: || p_docsInPmtTab(i).payment_id || ', document: '
3852: || p_docsInPmtTab(i).document_id);
3853:
3854: UPDATE
3855: IBY_DOCS_PAYABLE_ALL
3856: SET
3857: payment_id = p_docsInPmtTab(i).payment_id,
3858: formatting_payment_id = p_docsInPmtTab(i).payment_id,
3859: document_status = p_docsInPmtTab(i).document_status,

Line 4808: l_orig_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;

4804: )
4805: IS
4806:
4807: l_orig_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4808: l_orig_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
4809: l_orig_pmt_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
4810:
4811: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4812: l_compare_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;

Line 4809: l_orig_pmt_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;

4805: IS
4806:
4807: l_orig_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4808: l_orig_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
4809: l_orig_pmt_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
4810:
4811: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4812: l_compare_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
4813:

Line 4812: l_compare_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;

4808: l_orig_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
4809: l_orig_pmt_grp_num IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE;
4810:
4811: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4812: l_compare_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
4813:
4814: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
4815:
4816: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 6435: || 'IBY_DOCS_PAYABLE_ALL WHERE '

6431:
6432: print_debuginfo(l_module_name, 'ENTER');
6433:
6434: l_sql_string := 'SELECT ' || p_pmtDetailsFormula || ' FROM '
6435: || 'IBY_DOCS_PAYABLE_ALL WHERE '
6436: || 'document_payable_id = :bind_var';
6437:
6438: EXECUTE IMMEDIATE l_sql_string INTO l_calc_doc_details USING p_documentID;
6439:

Line 7175: p_docStatus IN IBY_DOCS_PAYABLE_ALL.

7171: |
7172: *---------------------------------------------------------------------*/
7173: PROCEDURE failDocsOfPayment(
7174: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
7175: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
7176: document_status%TYPE,
7177: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
7178: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
7179: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

Line 8967: || 'FROM IBY_DOCS_PAYABLE_ALL '

8963: || 'calling_app_doc_unique_ref3'
8964: || 'calling_app_doc_unique_ref4'
8965: || 'calling_app_doc_unique_ref5'
8966: || 'pay_proc_trxn_type_id '
8967: || 'FROM IBY_DOCS_PAYABLE_ALL '
8968: || 'WHERE payment_service_request_id = :payreq_id '
8969: || 'AND document_status <> :doc_status '
8970: || 'AND payment_id IS NOT NULL';
8971:

Line 9072: IBY_DOCS_PAYABLE_ALL doc

9068: SELECT
9069: doc.document_payable_id,
9070: doc.document_status
9071: FROM
9072: IBY_DOCS_PAYABLE_ALL doc
9073: WHERE
9074: doc.payment_service_request_id = p_payreq_id AND
9075: doc.document_status <> DOC_STATUS_PAY_CREATED AND
9076: doc.payment_id IS NOT NULL

Line 11296: IBY_DOCS_PAYABLE_ALL

11292: inv_beneficiary_party,
11293: ext_inv_payee_id,
11294: relationship_id
11295: FROM
11296: IBY_DOCS_PAYABLE_ALL
11297: WHERE
11298: payment_service_request_id = p_payment_request_id AND
11299: payment_id = p_payment_id AND
11300: document_status IN