[Home] [Help]
762: --
763: -- Therefore, we need a separate data structure to keep track
764: -- of the documents that are part of a payment. The docsInPaymentRecType
765: -- is that data structure. After all the grouping operations are
766: -- completed, the IBY_DOCS_PAYABLE_ALL table needs to be
767: -- updated to indicate the PAYMENT_ID for each document that
768: -- has been put into a payment. The docsInPaymentRecType
769: -- is used for this update.
770: --
774: TYPE docsInPaymentRecType IS RECORD (
775: payment_id
776: IBY_PAYMENTS_ALL.payment_id%TYPE,
777: document_id
778: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
779: calling_app_id
780: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
781: calling_app_doc_id1
782: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
776: IBY_PAYMENTS_ALL.payment_id%TYPE,
777: document_id
778: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
779: calling_app_id
780: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
781: calling_app_doc_id1
782: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
783: calling_app_doc_id2
784: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
778: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
779: calling_app_id
780: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
781: calling_app_doc_id1
782: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
783: calling_app_doc_id2
784: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
785: calling_app_doc_id3
786: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
780: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
781: calling_app_doc_id1
782: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
783: calling_app_doc_id2
784: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
785: calling_app_doc_id3
786: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
787: calling_app_doc_id4
788: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
782: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
783: calling_app_doc_id2
784: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
785: calling_app_doc_id3
786: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
787: calling_app_doc_id4
788: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
789: calling_app_doc_id5
790: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
784: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
785: calling_app_doc_id3
786: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
787: calling_app_doc_id4
788: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
789: calling_app_doc_id5
790: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
791: pay_proc_ttype_cd
792: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
786: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
787: calling_app_doc_id4
788: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
789: calling_app_doc_id5
790: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
791: pay_proc_ttype_cd
792: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
793: document_amount
794: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
788: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
789: calling_app_doc_id5
790: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
791: pay_proc_ttype_cd
792: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
793: document_amount
794: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
795: document_currency
796: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
790: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
791: pay_proc_ttype_cd
792: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
793: document_amount
794: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
795: document_currency
796: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
797: payment_grp_num
798: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
792: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
793: document_amount
794: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
795: document_currency
796: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
797: payment_grp_num
798: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
799: document_status
800: IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',
794: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
795: document_currency
796: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
797: payment_grp_num
798: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
799: document_status
800: IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',
801: amount_withheld
802: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,
796: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
797: payment_grp_num
798: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
799: document_status
800: IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',
801: amount_withheld
802: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,
803: pmt_due_date
804: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
798: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
799: document_status
800: IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',
801: amount_withheld
802: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,
803: pmt_due_date
804: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
805: discount_date
806: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
800: IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',
801: amount_withheld
802: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,
803: pmt_due_date
804: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
805: discount_date
806: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
807: int_bank_acct_id
808: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
802: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,
803: pmt_due_date
804: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
805: discount_date
806: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
807: int_bank_acct_id
808: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
809: ext_payee_id
810: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
804: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
805: discount_date
806: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
807: int_bank_acct_id
808: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
809: ext_payee_id
810: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
811: payee_id
812: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
806: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
807: int_bank_acct_id
808: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
809: ext_payee_id
810: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
811: payee_id
812: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
813: payee_site_id
814: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
808: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
809: ext_payee_id
810: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
811: payee_id
812: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
813: payee_site_id
814: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
815: supplier_site_id
816: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
810: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
811: payee_id
812: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
813: payee_site_id
814: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
815: supplier_site_id
816: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
817: org_id
818: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
812: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
813: payee_site_id
814: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
815: supplier_site_id
816: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
817: org_id
818: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
819: org_type
820: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
814: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
815: supplier_site_id
816: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
817: org_id
818: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
819: org_type
820: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
821: ext_bank_acct_id
822: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
816: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
817: org_id
818: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
819: org_type
820: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
821: ext_bank_acct_id
822: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
823: pmt_curr_discount
824: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
818: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
819: org_type
820: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
821: ext_bank_acct_id
822: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
823: pmt_curr_discount
824: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
825: delivery_channel
826: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
820: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
821: ext_bank_acct_id
822: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
823: pmt_curr_discount
824: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
825: delivery_channel
826: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
827: unique_remit_id
828: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
822: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
823: pmt_curr_discount
824: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
825: delivery_channel
826: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
827: unique_remit_id
828: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
829: uri_ckdigits
830: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
824: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
825: delivery_channel
826: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
827: unique_remit_id
828: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
829: uri_ckdigits
830: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
831:
832: /*TPP-Start*/
826: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
827: unique_remit_id
828: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
829: uri_ckdigits
830: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
831:
832: /*TPP-Start*/
833: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
834: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
829: uri_ckdigits
830: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
831:
832: /*TPP-Start*/
833: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
834: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
835: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
836: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
837: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
830: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
831:
832: /*TPP-Start*/
833: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
834: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
835: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
836: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
837: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
838: relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE
831:
832: /*TPP-Start*/
833: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
834: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
835: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
836: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
837: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
838: relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE
839: /*TPP-End*/
832: /*TPP-Start*/
833: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
834: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
835: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
836: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
837: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
838: relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE
839: /*TPP-End*/
840: );
833: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
834: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
835: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
836: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
837: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
838: relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE
839: /*TPP-End*/
840: );
841:
834: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
835: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
836: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
837: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
838: relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE
839: /*TPP-End*/
840: );
841:
842: --
839: /*TPP-End*/
840: );
841:
842: --
843: -- Used to update of the IBY_DOCS_PAYABLE_ALL table.
844: --
845: TYPE docsInPaymentTabType IS TABLE OF docsInPaymentRecType
846: INDEX BY BINARY_INTEGER;
847:
896:
897: --
898: -- The document id table
899: --
900: TYPE docPayTabType IS TABLE OF IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
901: INDEX BY BINARY_INTEGER;
902:
903: --
904: -- This record stores all the document fields that are used in
917: TYPE paymentGroupCriteriaType IS RECORD (
918: calling_app_payreq_cd
919: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
920: document_id
921: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
922: calling_app_id
923: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
924: calling_app_doc_id1
925: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
919: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
920: document_id
921: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
922: calling_app_id
923: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
924: calling_app_doc_id1
925: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
926: calling_app_doc_id2
927: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
921: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
922: calling_app_id
923: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
924: calling_app_doc_id1
925: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
926: calling_app_doc_id2
927: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
928: calling_app_doc_id3
929: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
923: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
924: calling_app_doc_id1
925: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
926: calling_app_doc_id2
927: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
928: calling_app_doc_id3
929: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
930: calling_app_doc_id4
931: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
925: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
926: calling_app_doc_id2
927: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
928: calling_app_doc_id3
929: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
930: calling_app_doc_id4
931: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
932: calling_app_doc_id5
933: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
927: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
928: calling_app_doc_id3
929: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
930: calling_app_doc_id4
931: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
932: calling_app_doc_id5
933: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
934: pay_proc_ttype_cd
935: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
929: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
930: calling_app_doc_id4
931: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
932: calling_app_doc_id5
933: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
934: pay_proc_ttype_cd
935: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
936: payment_grp_num
937: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
931: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
932: calling_app_doc_id5
933: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
934: pay_proc_ttype_cd
935: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
936: payment_grp_num
937: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
938: payment_method_cd
939: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
933: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
934: pay_proc_ttype_cd
935: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
936: payment_grp_num
937: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
938: payment_method_cd
939: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
940: int_bank_acct_id
941: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
935: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
936: payment_grp_num
937: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
938: payment_method_cd
939: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
940: int_bank_acct_id
941: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
942: ext_bank_acct_id
943: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
937: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
938: payment_method_cd
939: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
940: int_bank_acct_id
941: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
942: ext_bank_acct_id
943: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
944: payment_profile_id
945: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
939: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
940: int_bank_acct_id
941: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
942: ext_bank_acct_id
943: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
944: payment_profile_id
945: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
946: org_id
947: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
941: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
942: ext_bank_acct_id
943: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
944: payment_profile_id
945: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
946: org_id
947: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
948: org_type
949: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
943: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
944: payment_profile_id
945: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
946: org_id
947: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
948: org_type
949: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
950: payment_function
951: IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
945: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
946: org_id
947: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
948: org_type
949: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
950: payment_function
951: IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
952: ext_payee_id
953: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
947: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
948: org_type
949: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
950: payment_function
951: IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
952: ext_payee_id
953: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
954: payee_party_id
955: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
949: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
950: payment_function
951: IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
952: ext_payee_id
953: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
954: payee_party_id
955: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
956: payee_party_site_id
957: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
951: IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
952: ext_payee_id
953: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
954: payee_party_id
955: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
956: payee_party_site_id
957: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
958: supplier_site_id
959: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
953: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
954: payee_party_id
955: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
956: payee_party_site_id
957: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
958: supplier_site_id
959: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
960: remit_loc_id
961: IBY_DOCS_PAYABLE_ALL.remit_to_location_id%TYPE,
955: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
956: payee_party_site_id
957: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
958: supplier_site_id
959: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
960: remit_loc_id
961: IBY_DOCS_PAYABLE_ALL.remit_to_location_id%TYPE,
962: amount_withheld
963: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE,
957: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
958: supplier_site_id
959: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
960: remit_loc_id
961: IBY_DOCS_PAYABLE_ALL.remit_to_location_id%TYPE,
962: amount_withheld
963: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE,
964: bank_inst1_code
965: IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
959: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
960: remit_loc_id
961: IBY_DOCS_PAYABLE_ALL.remit_to_location_id%TYPE,
962: amount_withheld
963: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE,
964: bank_inst1_code
965: IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
966: bank_inst2_code
967: IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
971: IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
972: pmt_txt_msg3
973: IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
974: payment_currency
975: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
976: payment_amount
977: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
978: payment_date
979: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
973: IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
974: payment_currency
975: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
976: payment_amount
977: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
978: payment_date
979: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
980: pay_alone_flag
981: IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,
975: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
976: payment_amount
977: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
978: payment_date
979: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
980: pay_alone_flag
981: IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,
982: bank_charge_bearer
983: IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
977: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
978: payment_date
979: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
980: pay_alone_flag
981: IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,
982: bank_charge_bearer
983: IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
984: delivery_channel
985: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
979: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
980: pay_alone_flag
981: IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,
982: bank_charge_bearer
983: IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
984: delivery_channel
985: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
986: settle_priority
987: IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,
981: IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,
982: bank_charge_bearer
983: IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
984: delivery_channel
985: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
986: settle_priority
987: IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,
988: supplier_message1
989: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
983: IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
984: delivery_channel
985: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
986: settle_priority
987: IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,
988: supplier_message1
989: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
990: supplier_message2
991: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
985: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
986: settle_priority
987: IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,
988: supplier_message1
989: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
990: supplier_message2
991: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
992: supplier_message3
993: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
987: IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,
988: supplier_message1
989: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
990: supplier_message2
991: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
992: supplier_message3
993: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
994: unique_remit_id
995: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
989: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
990: supplier_message2
991: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
992: supplier_message3
993: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
994: unique_remit_id
995: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
996: uri_checkdigit
997: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
991: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
992: supplier_message3
993: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
994: unique_remit_id
995: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
996: uri_checkdigit
997: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
998: pmt_reason_code
999: IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
993: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
994: unique_remit_id
995: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
996: uri_checkdigit
997: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
998: pmt_reason_code
999: IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
1000: pmt_reason_comments
1001: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
995: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
996: uri_checkdigit
997: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
998: pmt_reason_code
999: IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
1000: pmt_reason_comments
1001: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
1002: pmt_due_date
1003: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
997: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
998: pmt_reason_code
999: IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
1000: pmt_reason_comments
1001: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
1002: pmt_due_date
1003: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1004: discount_date
1005: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
999: IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
1000: pmt_reason_comments
1001: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
1002: pmt_due_date
1003: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1004: discount_date
1005: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1006: discount_amount
1007: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1001: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
1002: pmt_due_date
1003: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1004: discount_date
1005: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1006: discount_amount
1007: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1008: benef_party
1009: IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,
1003: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1004: discount_date
1005: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1006: discount_amount
1007: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1008: benef_party
1009: IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,
1010: addr_source
1011: IBY_DOCS_PAYABLE_ALL.address_source%TYPE,
1005: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1006: discount_amount
1007: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1008: benef_party
1009: IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,
1010: addr_source
1011: IBY_DOCS_PAYABLE_ALL.address_source%TYPE,
1012: emp_addr_code
1013: IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,
1007: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1008: benef_party
1009: IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,
1010: addr_source
1011: IBY_DOCS_PAYABLE_ALL.address_source%TYPE,
1012: emp_addr_code
1013: IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,
1014: emp_person_id
1015: IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,
1009: IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,
1010: addr_source
1011: IBY_DOCS_PAYABLE_ALL.address_source%TYPE,
1012: emp_addr_code
1013: IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,
1014: emp_person_id
1015: IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,
1016: emp_address_id
1017: IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE,
1011: IBY_DOCS_PAYABLE_ALL.address_source%TYPE,
1012: emp_addr_code
1013: IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,
1014: emp_person_id
1015: IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,
1016: emp_address_id
1017: IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE,
1018: emp_payment_flag
1019: IBY_DOCS_PAYABLE_ALL.employee_payment_flag%TYPE,
1013: IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,
1014: emp_person_id
1015: IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,
1016: emp_address_id
1017: IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE,
1018: emp_payment_flag
1019: IBY_DOCS_PAYABLE_ALL.employee_payment_flag%TYPE,
1020: supplier_msg_flag
1021: IBY_PMT_CREATION_RULES.group_by_remittance_message%TYPE,
1015: IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,
1016: emp_address_id
1017: IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE,
1018: emp_payment_flag
1019: IBY_DOCS_PAYABLE_ALL.employee_payment_flag%TYPE,
1020: supplier_msg_flag
1021: IBY_PMT_CREATION_RULES.group_by_remittance_message%TYPE,
1022: bnk_chg_bearer_flag
1023: IBY_PMT_CREATION_RULES.group_by_bank_charge_bearer%TYPE,
2149: |
2150: *---------------------------------------------------------------------*/
2151: PROCEDURE failDocsOfPayment(
2152: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
2153: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
2154: document_status%TYPE,
2155: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2156: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
2157: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType