DBA Data[Home] [Help]

APPS.IBY_PAYINSTR_PUB dependencies on IBY_INSTR_CREATION_RULES

Line 171: IBY_INSTR_CREATION_RULES.group_by_payment_date%TYPE,

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,

Line 173: IBY_INSTR_CREATION_RULES.group_by_payment_currency%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,

Line 175: IBY_INSTR_CREATION_RULES.group_by_max_payments_flag%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,

Line 177: IBY_INSTR_CREATION_RULES.max_payments_per_instruction%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,

Line 179: IBY_INSTR_CREATION_RULES.group_by_internal_bank_account%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,

Line 181: IBY_INSTR_CREATION_RULES.group_by_max_instruction_flag%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,

Line 183: IBY_INSTR_CREATION_RULES.max_amount_per_instr_value%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,

Line 185: IBY_INSTR_CREATION_RULES.max_amount_per_instr_curr_code%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,

Line 187: IBY_INSTR_CREATION_RULES.max_amount_fx_rate_type%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,

Line 189: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%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,

Line 191: IBY_INSTR_CREATION_RULES.group_by_legal_entity%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,

Line 193: IBY_INSTR_CREATION_RULES.group_by_organization%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,

Line 195: IBY_INSTR_CREATION_RULES.group_by_payment_function%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,

Line 197: IBY_INSTR_CREATION_RULES.group_by_payment_reason%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,

Line 199: IBY_INSTR_CREATION_RULES.group_by_bill_payable%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,

Line 201: IBY_INSTR_CREATION_RULES.group_by_pay_service_request%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

Line 203: IBY_INSTR_CREATION_RULES.group_by_rfc%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:

Line 205: IBY_INSTR_CREATION_RULES.group_by_payment_method%TYPE

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.

Line 312: pmt_profile_cd IBY_INSTR_CREATION_RULES.system_profile_code%TYPE,

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,

Line 313: sort_option_1 IBY_INSTR_CREATION_RULES.sort_option_1%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,

Line 314: sort_order_1 IBY_INSTR_CREATION_RULES.sort_order_1%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

Line 315: sort_option_2 IBY_INSTR_CREATION_RULES.sort_option_2%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: );

Line 316: sort_order_2 IBY_INSTR_CREATION_RULES.sort_order_2%TYPE,

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:

Line 317: sort_option_3 IBY_INSTR_CREATION_RULES.sort_option_3%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:
321: --

Line 318: sort_order_3 IBY_INSTR_CREATION_RULES.sort_order_3%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: --
322: -- Table of sort options across profiles.