167: HZ_CODE_ASSIGNMENTS.class_code%TYPE,
168: payment_method_code
169: IBY_PAYMENTS_ALL.payment_method_code%TYPE,
170: pmt_date_flag
171: IBY_INSTR_CREATION_RULES.group_by_payment_date%TYPE,
172: pmt_curr_flag
173: IBY_INSTR_CREATION_RULES.group_by_payment_currency%TYPE,
174: max_payments_flag
175: IBY_INSTR_CREATION_RULES.group_by_max_payments_flag%TYPE,
169: IBY_PAYMENTS_ALL.payment_method_code%TYPE,
170: pmt_date_flag
171: IBY_INSTR_CREATION_RULES.group_by_payment_date%TYPE,
172: pmt_curr_flag
173: IBY_INSTR_CREATION_RULES.group_by_payment_currency%TYPE,
174: max_payments_flag
175: IBY_INSTR_CREATION_RULES.group_by_max_payments_flag%TYPE,
176: max_payments_limit
177: IBY_INSTR_CREATION_RULES.max_payments_per_instruction%TYPE,
171: IBY_INSTR_CREATION_RULES.group_by_payment_date%TYPE,
172: pmt_curr_flag
173: IBY_INSTR_CREATION_RULES.group_by_payment_currency%TYPE,
174: max_payments_flag
175: IBY_INSTR_CREATION_RULES.group_by_max_payments_flag%TYPE,
176: max_payments_limit
177: IBY_INSTR_CREATION_RULES.max_payments_per_instruction%TYPE,
178: int_bank_acct_flag
179: IBY_INSTR_CREATION_RULES.group_by_internal_bank_account%TYPE,
173: IBY_INSTR_CREATION_RULES.group_by_payment_currency%TYPE,
174: max_payments_flag
175: IBY_INSTR_CREATION_RULES.group_by_max_payments_flag%TYPE,
176: max_payments_limit
177: IBY_INSTR_CREATION_RULES.max_payments_per_instruction%TYPE,
178: int_bank_acct_flag
179: IBY_INSTR_CREATION_RULES.group_by_internal_bank_account%TYPE,
180: max_amount_flag
181: IBY_INSTR_CREATION_RULES.group_by_max_instruction_flag%TYPE,
175: IBY_INSTR_CREATION_RULES.group_by_max_payments_flag%TYPE,
176: max_payments_limit
177: IBY_INSTR_CREATION_RULES.max_payments_per_instruction%TYPE,
178: int_bank_acct_flag
179: IBY_INSTR_CREATION_RULES.group_by_internal_bank_account%TYPE,
180: max_amount_flag
181: IBY_INSTR_CREATION_RULES.group_by_max_instruction_flag%TYPE,
182: max_amount_limit
183: IBY_INSTR_CREATION_RULES.max_amount_per_instr_value%TYPE,
177: IBY_INSTR_CREATION_RULES.max_payments_per_instruction%TYPE,
178: int_bank_acct_flag
179: IBY_INSTR_CREATION_RULES.group_by_internal_bank_account%TYPE,
180: max_amount_flag
181: IBY_INSTR_CREATION_RULES.group_by_max_instruction_flag%TYPE,
182: max_amount_limit
183: IBY_INSTR_CREATION_RULES.max_amount_per_instr_value%TYPE,
184: max_amount_currency
185: IBY_INSTR_CREATION_RULES.max_amount_per_instr_curr_code%TYPE,
179: IBY_INSTR_CREATION_RULES.group_by_internal_bank_account%TYPE,
180: max_amount_flag
181: IBY_INSTR_CREATION_RULES.group_by_max_instruction_flag%TYPE,
182: max_amount_limit
183: IBY_INSTR_CREATION_RULES.max_amount_per_instr_value%TYPE,
184: max_amount_currency
185: IBY_INSTR_CREATION_RULES.max_amount_per_instr_curr_code%TYPE,
186: max_amount_fx_rate_type
187: IBY_INSTR_CREATION_RULES.max_amount_fx_rate_type%TYPE,
181: IBY_INSTR_CREATION_RULES.group_by_max_instruction_flag%TYPE,
182: max_amount_limit
183: IBY_INSTR_CREATION_RULES.max_amount_per_instr_value%TYPE,
184: max_amount_currency
185: IBY_INSTR_CREATION_RULES.max_amount_per_instr_curr_code%TYPE,
186: max_amount_fx_rate_type
187: IBY_INSTR_CREATION_RULES.max_amount_fx_rate_type%TYPE,
188: pay_service_req_flag
189: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%TYPE,
183: IBY_INSTR_CREATION_RULES.max_amount_per_instr_value%TYPE,
184: max_amount_currency
185: IBY_INSTR_CREATION_RULES.max_amount_per_instr_curr_code%TYPE,
186: max_amount_fx_rate_type
187: IBY_INSTR_CREATION_RULES.max_amount_fx_rate_type%TYPE,
188: pay_service_req_flag
189: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%TYPE,
190: le_flag
191: IBY_INSTR_CREATION_RULES.group_by_legal_entity%TYPE,
185: IBY_INSTR_CREATION_RULES.max_amount_per_instr_curr_code%TYPE,
186: max_amount_fx_rate_type
187: IBY_INSTR_CREATION_RULES.max_amount_fx_rate_type%TYPE,
188: pay_service_req_flag
189: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%TYPE,
190: le_flag
191: IBY_INSTR_CREATION_RULES.group_by_legal_entity%TYPE,
192: org_flag
193: IBY_INSTR_CREATION_RULES.group_by_organization%TYPE,
187: IBY_INSTR_CREATION_RULES.max_amount_fx_rate_type%TYPE,
188: pay_service_req_flag
189: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%TYPE,
190: le_flag
191: IBY_INSTR_CREATION_RULES.group_by_legal_entity%TYPE,
192: org_flag
193: IBY_INSTR_CREATION_RULES.group_by_organization%TYPE,
194: pmt_function_flag
195: IBY_INSTR_CREATION_RULES.group_by_payment_function%TYPE,
189: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%TYPE,
190: le_flag
191: IBY_INSTR_CREATION_RULES.group_by_legal_entity%TYPE,
192: org_flag
193: IBY_INSTR_CREATION_RULES.group_by_organization%TYPE,
194: pmt_function_flag
195: IBY_INSTR_CREATION_RULES.group_by_payment_function%TYPE,
196: pmt_reason_flag
197: IBY_INSTR_CREATION_RULES.group_by_payment_reason%TYPE,
191: IBY_INSTR_CREATION_RULES.group_by_legal_entity%TYPE,
192: org_flag
193: IBY_INSTR_CREATION_RULES.group_by_organization%TYPE,
194: pmt_function_flag
195: IBY_INSTR_CREATION_RULES.group_by_payment_function%TYPE,
196: pmt_reason_flag
197: IBY_INSTR_CREATION_RULES.group_by_payment_reason%TYPE,
198: prom_note_flag
199: IBY_INSTR_CREATION_RULES.group_by_bill_payable%TYPE,
193: IBY_INSTR_CREATION_RULES.group_by_organization%TYPE,
194: pmt_function_flag
195: IBY_INSTR_CREATION_RULES.group_by_payment_function%TYPE,
196: pmt_reason_flag
197: IBY_INSTR_CREATION_RULES.group_by_payment_reason%TYPE,
198: prom_note_flag
199: IBY_INSTR_CREATION_RULES.group_by_bill_payable%TYPE,
200: ppr_flag
201: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%TYPE,
195: IBY_INSTR_CREATION_RULES.group_by_payment_function%TYPE,
196: pmt_reason_flag
197: IBY_INSTR_CREATION_RULES.group_by_payment_reason%TYPE,
198: prom_note_flag
199: IBY_INSTR_CREATION_RULES.group_by_bill_payable%TYPE,
200: ppr_flag
201: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%TYPE,
202: rfc_flag
203: IBY_INSTR_CREATION_RULES.group_by_rfc%TYPE,
197: IBY_INSTR_CREATION_RULES.group_by_payment_reason%TYPE,
198: prom_note_flag
199: IBY_INSTR_CREATION_RULES.group_by_bill_payable%TYPE,
200: ppr_flag
201: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%TYPE,
202: rfc_flag
203: IBY_INSTR_CREATION_RULES.group_by_rfc%TYPE,
204: pmt_method_flag
205: IBY_INSTR_CREATION_RULES.group_by_payment_method%TYPE
199: IBY_INSTR_CREATION_RULES.group_by_bill_payable%TYPE,
200: ppr_flag
201: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%TYPE,
202: rfc_flag
203: IBY_INSTR_CREATION_RULES.group_by_rfc%TYPE,
204: pmt_method_flag
205: IBY_INSTR_CREATION_RULES.group_by_payment_method%TYPE
206: );
207:
201: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%TYPE,
202: rfc_flag
203: IBY_INSTR_CREATION_RULES.group_by_rfc%TYPE,
204: pmt_method_flag
205: IBY_INSTR_CREATION_RULES.group_by_payment_method%TYPE
206: );
207:
208: --
209: -- Table of payment grouping criteria.
308: -- Possible sort options along with the sort order for a single
309: -- payment profile.
310: --
311: TYPE sortOptionsRecType IS RECORD (
312: pmt_profile_cd IBY_INSTR_CREATION_RULES.system_profile_code%TYPE,
313: sort_option_1 IBY_INSTR_CREATION_RULES.sort_option_1%TYPE,
314: sort_order_1 IBY_INSTR_CREATION_RULES.sort_order_1%TYPE,
315: sort_option_2 IBY_INSTR_CREATION_RULES.sort_option_2%TYPE,
316: sort_order_2 IBY_INSTR_CREATION_RULES.sort_order_2%TYPE,
309: -- payment profile.
310: --
311: TYPE sortOptionsRecType IS RECORD (
312: pmt_profile_cd IBY_INSTR_CREATION_RULES.system_profile_code%TYPE,
313: sort_option_1 IBY_INSTR_CREATION_RULES.sort_option_1%TYPE,
314: sort_order_1 IBY_INSTR_CREATION_RULES.sort_order_1%TYPE,
315: sort_option_2 IBY_INSTR_CREATION_RULES.sort_option_2%TYPE,
316: sort_order_2 IBY_INSTR_CREATION_RULES.sort_order_2%TYPE,
317: sort_option_3 IBY_INSTR_CREATION_RULES.sort_option_3%TYPE,
310: --
311: TYPE sortOptionsRecType IS RECORD (
312: pmt_profile_cd IBY_INSTR_CREATION_RULES.system_profile_code%TYPE,
313: sort_option_1 IBY_INSTR_CREATION_RULES.sort_option_1%TYPE,
314: sort_order_1 IBY_INSTR_CREATION_RULES.sort_order_1%TYPE,
315: sort_option_2 IBY_INSTR_CREATION_RULES.sort_option_2%TYPE,
316: sort_order_2 IBY_INSTR_CREATION_RULES.sort_order_2%TYPE,
317: sort_option_3 IBY_INSTR_CREATION_RULES.sort_option_3%TYPE,
318: sort_order_3 IBY_INSTR_CREATION_RULES.sort_order_3%TYPE
311: TYPE sortOptionsRecType IS RECORD (
312: pmt_profile_cd IBY_INSTR_CREATION_RULES.system_profile_code%TYPE,
313: sort_option_1 IBY_INSTR_CREATION_RULES.sort_option_1%TYPE,
314: sort_order_1 IBY_INSTR_CREATION_RULES.sort_order_1%TYPE,
315: sort_option_2 IBY_INSTR_CREATION_RULES.sort_option_2%TYPE,
316: sort_order_2 IBY_INSTR_CREATION_RULES.sort_order_2%TYPE,
317: sort_option_3 IBY_INSTR_CREATION_RULES.sort_option_3%TYPE,
318: sort_order_3 IBY_INSTR_CREATION_RULES.sort_order_3%TYPE
319: );
312: pmt_profile_cd IBY_INSTR_CREATION_RULES.system_profile_code%TYPE,
313: sort_option_1 IBY_INSTR_CREATION_RULES.sort_option_1%TYPE,
314: sort_order_1 IBY_INSTR_CREATION_RULES.sort_order_1%TYPE,
315: sort_option_2 IBY_INSTR_CREATION_RULES.sort_option_2%TYPE,
316: sort_order_2 IBY_INSTR_CREATION_RULES.sort_order_2%TYPE,
317: sort_option_3 IBY_INSTR_CREATION_RULES.sort_option_3%TYPE,
318: sort_order_3 IBY_INSTR_CREATION_RULES.sort_order_3%TYPE
319: );
320:
313: sort_option_1 IBY_INSTR_CREATION_RULES.sort_option_1%TYPE,
314: sort_order_1 IBY_INSTR_CREATION_RULES.sort_order_1%TYPE,
315: sort_option_2 IBY_INSTR_CREATION_RULES.sort_option_2%TYPE,
316: sort_order_2 IBY_INSTR_CREATION_RULES.sort_order_2%TYPE,
317: sort_option_3 IBY_INSTR_CREATION_RULES.sort_option_3%TYPE,
318: sort_order_3 IBY_INSTR_CREATION_RULES.sort_order_3%TYPE
319: );
320:
321: --
314: sort_order_1 IBY_INSTR_CREATION_RULES.sort_order_1%TYPE,
315: sort_option_2 IBY_INSTR_CREATION_RULES.sort_option_2%TYPE,
316: sort_order_2 IBY_INSTR_CREATION_RULES.sort_order_2%TYPE,
317: sort_option_3 IBY_INSTR_CREATION_RULES.sort_option_3%TYPE,
318: sort_order_3 IBY_INSTR_CREATION_RULES.sort_order_3%TYPE
319: );
320:
321: --
322: -- Table of sort options across profiles.