909: -- for grouping, but for raising business events etc.
910: -- e.g., the calling app pay req id
911: --
912: -- Some of the grouping criteria are user defined; these are
913: -- specified in the IBY_PMT_CREATION_RULES table. This record
914: -- contains placeholder for the user defined grouping fields
915: -- as well.
916: --
917: TYPE paymentGroupCriteriaType IS RECORD (
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,
1024: delv_channel_flag
1025: IBY_PMT_CREATION_RULES.group_by_delivery_channel%TYPE,
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,
1024: delv_channel_flag
1025: IBY_PMT_CREATION_RULES.group_by_delivery_channel%TYPE,
1026: settle_priority_flag
1027: IBY_PMT_CREATION_RULES.group_by_settle_priority_flag%TYPE,
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,
1024: delv_channel_flag
1025: IBY_PMT_CREATION_RULES.group_by_delivery_channel%TYPE,
1026: settle_priority_flag
1027: IBY_PMT_CREATION_RULES.group_by_settle_priority_flag%TYPE,
1028: pmt_details_flag
1029: IBY_PMT_CREATION_RULES.group_by_payment_details_flag%TYPE,
1023: IBY_PMT_CREATION_RULES.group_by_bank_charge_bearer%TYPE,
1024: delv_channel_flag
1025: IBY_PMT_CREATION_RULES.group_by_delivery_channel%TYPE,
1026: settle_priority_flag
1027: IBY_PMT_CREATION_RULES.group_by_settle_priority_flag%TYPE,
1028: pmt_details_flag
1029: IBY_PMT_CREATION_RULES.group_by_payment_details_flag%TYPE,
1030: pmt_details_length
1031: IBY_PMT_CREATION_RULES.payment_details_length_limit%TYPE,
1025: IBY_PMT_CREATION_RULES.group_by_delivery_channel%TYPE,
1026: settle_priority_flag
1027: IBY_PMT_CREATION_RULES.group_by_settle_priority_flag%TYPE,
1028: pmt_details_flag
1029: IBY_PMT_CREATION_RULES.group_by_payment_details_flag%TYPE,
1030: pmt_details_length
1031: IBY_PMT_CREATION_RULES.payment_details_length_limit%TYPE,
1032: payment_details_formula
1033: IBY_PMT_CREATION_RULES.payment_details_formula%TYPE,
1027: IBY_PMT_CREATION_RULES.group_by_settle_priority_flag%TYPE,
1028: pmt_details_flag
1029: IBY_PMT_CREATION_RULES.group_by_payment_details_flag%TYPE,
1030: pmt_details_length
1031: IBY_PMT_CREATION_RULES.payment_details_length_limit%TYPE,
1032: payment_details_formula
1033: IBY_PMT_CREATION_RULES.payment_details_formula%TYPE,
1034: max_documents_flag
1035: IBY_PMT_CREATION_RULES.group_by_max_documents_flag%TYPE,
1029: IBY_PMT_CREATION_RULES.group_by_payment_details_flag%TYPE,
1030: pmt_details_length
1031: IBY_PMT_CREATION_RULES.payment_details_length_limit%TYPE,
1032: payment_details_formula
1033: IBY_PMT_CREATION_RULES.payment_details_formula%TYPE,
1034: max_documents_flag
1035: IBY_PMT_CREATION_RULES.group_by_max_documents_flag%TYPE,
1036: max_documents_limit
1037: IBY_PMT_CREATION_RULES.max_documents_per_payment%TYPE,
1031: IBY_PMT_CREATION_RULES.payment_details_length_limit%TYPE,
1032: payment_details_formula
1033: IBY_PMT_CREATION_RULES.payment_details_formula%TYPE,
1034: max_documents_flag
1035: IBY_PMT_CREATION_RULES.group_by_max_documents_flag%TYPE,
1036: max_documents_limit
1037: IBY_PMT_CREATION_RULES.max_documents_per_payment%TYPE,
1038: unique_remit_id_flag
1039: IBY_PMT_CREATION_RULES.group_by_unique_remit_id_flag%TYPE,
1033: IBY_PMT_CREATION_RULES.payment_details_formula%TYPE,
1034: max_documents_flag
1035: IBY_PMT_CREATION_RULES.group_by_max_documents_flag%TYPE,
1036: max_documents_limit
1037: IBY_PMT_CREATION_RULES.max_documents_per_payment%TYPE,
1038: unique_remit_id_flag
1039: IBY_PMT_CREATION_RULES.group_by_unique_remit_id_flag%TYPE,
1040: pmt_reason_flag
1041: IBY_PMT_CREATION_RULES.group_by_payment_reason%TYPE,
1035: IBY_PMT_CREATION_RULES.group_by_max_documents_flag%TYPE,
1036: max_documents_limit
1037: IBY_PMT_CREATION_RULES.max_documents_per_payment%TYPE,
1038: unique_remit_id_flag
1039: IBY_PMT_CREATION_RULES.group_by_unique_remit_id_flag%TYPE,
1040: pmt_reason_flag
1041: IBY_PMT_CREATION_RULES.group_by_payment_reason%TYPE,
1042: pmt_due_date_flag
1043: IBY_PMT_CREATION_RULES.group_by_due_date_flag%TYPE,
1037: IBY_PMT_CREATION_RULES.max_documents_per_payment%TYPE,
1038: unique_remit_id_flag
1039: IBY_PMT_CREATION_RULES.group_by_unique_remit_id_flag%TYPE,
1040: pmt_reason_flag
1041: IBY_PMT_CREATION_RULES.group_by_payment_reason%TYPE,
1042: pmt_due_date_flag
1043: IBY_PMT_CREATION_RULES.group_by_due_date_flag%TYPE,
1044: processing_type
1045: IBY_PAYMENT_PROFILES.processing_type%TYPE,
1039: IBY_PMT_CREATION_RULES.group_by_unique_remit_id_flag%TYPE,
1040: pmt_reason_flag
1041: IBY_PMT_CREATION_RULES.group_by_payment_reason%TYPE,
1042: pmt_due_date_flag
1043: IBY_PMT_CREATION_RULES.group_by_due_date_flag%TYPE,
1044: processing_type
1045: IBY_PAYMENT_PROFILES.processing_type%TYPE,
1046: decl_option
1047: IBY_PAYMENT_PROFILES.declaration_option%TYPE,