[Home] [Help]
1: PACKAGE IBY_PAYGROUP_PUB AS
2: /*$Header: ibypaygs.pls 120.38.12010000.3 2008/12/02 20:57:26 pschalla ship $*/
3:
4: --
5: -- This record corresponds to a row in the IBY_PAYMENTS_ALL table.
6: -- A PLSQL table of these records are created after applying
7: -- grouping rules and this table is used in bulk inserting
8: -- these payments into the IBY_PAYMENTS_ALL table
9: --
4: --
5: -- This record corresponds to a row in the IBY_PAYMENTS_ALL table.
6: -- A PLSQL table of these records are created after applying
7: -- grouping rules and this table is used in bulk inserting
8: -- these payments into the IBY_PAYMENTS_ALL table
9: --
10: -- The record docsInPaymentRecType holds the documents
11: -- corresponding to this payment.
12: --
10: -- The record docsInPaymentRecType holds the documents
11: -- corresponding to this payment.
12: --
13: --
14: -- This PLSQL table corresponds to IBY_PAYMENTS_ALL and it
15: -- will be used in bulk updating the IBY_PAYMENTS_ALL table.
16: --
17: --TYPE paymentTabType IS TABLE OF paymentRecType
18: -- INDEX BY BINARY_INTEGER;
11: -- corresponding to this payment.
12: --
13: --
14: -- This PLSQL table corresponds to IBY_PAYMENTS_ALL and it
15: -- will be used in bulk updating the IBY_PAYMENTS_ALL table.
16: --
17: --TYPE paymentTabType IS TABLE OF paymentRecType
18: -- INDEX BY BINARY_INTEGER;
19: TYPE paymentTabType IS TABLE OF IBY_PAYMENTS_ALL%ROWTYPE
15: -- will be used in bulk updating the IBY_PAYMENTS_ALL table.
16: --
17: --TYPE paymentTabType IS TABLE OF paymentRecType
18: -- INDEX BY BINARY_INTEGER;
19: TYPE paymentTabType IS TABLE OF IBY_PAYMENTS_ALL%ROWTYPE
20: INDEX BY BINARY_INTEGER;
21:
22: --
23: -- This PLSQL record of tables corresponds to IBY_PAYMENTS_ALL and it
19: TYPE paymentTabType IS TABLE OF IBY_PAYMENTS_ALL%ROWTYPE
20: INDEX BY BINARY_INTEGER;
21:
22: --
23: -- This PLSQL record of tables corresponds to IBY_PAYMENTS_ALL and it
24: -- will be used in bulk updating the IBY_PAYMENTS_ALL table.
25: --
26: TYPE t_payment_id IS TABLE OF
27: IBY_PAYMENTS_ALL.payment_id%TYPE
20: INDEX BY BINARY_INTEGER;
21:
22: --
23: -- This PLSQL record of tables corresponds to IBY_PAYMENTS_ALL and it
24: -- will be used in bulk updating the IBY_PAYMENTS_ALL table.
25: --
26: TYPE t_payment_id IS TABLE OF
27: IBY_PAYMENTS_ALL.payment_id%TYPE
28: INDEX BY BINARY_INTEGER;
23: -- This PLSQL record of tables corresponds to IBY_PAYMENTS_ALL and it
24: -- will be used in bulk updating the IBY_PAYMENTS_ALL table.
25: --
26: TYPE t_payment_id IS TABLE OF
27: IBY_PAYMENTS_ALL.payment_id%TYPE
28: INDEX BY BINARY_INTEGER;
29: TYPE t_payment_method_code IS TABLE OF
30: IBY_PAYMENTS_ALL.payment_method_code%TYPE
31: INDEX BY BINARY_INTEGER;
26: TYPE t_payment_id IS TABLE OF
27: IBY_PAYMENTS_ALL.payment_id%TYPE
28: INDEX BY BINARY_INTEGER;
29: TYPE t_payment_method_code IS TABLE OF
30: IBY_PAYMENTS_ALL.payment_method_code%TYPE
31: INDEX BY BINARY_INTEGER;
32: TYPE t_payment_service_request_id IS TABLE OF
33: IBY_PAYMENTS_ALL.payment_service_request_id%TYPE
34: INDEX BY BINARY_INTEGER;
29: TYPE t_payment_method_code IS TABLE OF
30: IBY_PAYMENTS_ALL.payment_method_code%TYPE
31: INDEX BY BINARY_INTEGER;
32: TYPE t_payment_service_request_id IS TABLE OF
33: IBY_PAYMENTS_ALL.payment_service_request_id%TYPE
34: INDEX BY BINARY_INTEGER;
35: TYPE t_process_type IS TABLE OF
36: IBY_PAYMENTS_ALL.process_type%TYPE
37: INDEX BY BINARY_INTEGER;
32: TYPE t_payment_service_request_id IS TABLE OF
33: IBY_PAYMENTS_ALL.payment_service_request_id%TYPE
34: INDEX BY BINARY_INTEGER;
35: TYPE t_process_type IS TABLE OF
36: IBY_PAYMENTS_ALL.process_type%TYPE
37: INDEX BY BINARY_INTEGER;
38: TYPE t_payment_status IS TABLE OF
39: IBY_PAYMENTS_ALL.payment_status%TYPE
40: INDEX BY BINARY_INTEGER;
35: TYPE t_process_type IS TABLE OF
36: IBY_PAYMENTS_ALL.process_type%TYPE
37: INDEX BY BINARY_INTEGER;
38: TYPE t_payment_status IS TABLE OF
39: IBY_PAYMENTS_ALL.payment_status%TYPE
40: INDEX BY BINARY_INTEGER;
41: TYPE t_payments_complete_flag IS TABLE OF
42: IBY_PAYMENTS_ALL.payments_complete_flag%TYPE
43: INDEX BY BINARY_INTEGER;
38: TYPE t_payment_status IS TABLE OF
39: IBY_PAYMENTS_ALL.payment_status%TYPE
40: INDEX BY BINARY_INTEGER;
41: TYPE t_payments_complete_flag IS TABLE OF
42: IBY_PAYMENTS_ALL.payments_complete_flag%TYPE
43: INDEX BY BINARY_INTEGER;
44: TYPE t_payment_function IS TABLE OF
45: IBY_PAYMENTS_ALL.payment_function%TYPE
46: INDEX BY BINARY_INTEGER;
41: TYPE t_payments_complete_flag IS TABLE OF
42: IBY_PAYMENTS_ALL.payments_complete_flag%TYPE
43: INDEX BY BINARY_INTEGER;
44: TYPE t_payment_function IS TABLE OF
45: IBY_PAYMENTS_ALL.payment_function%TYPE
46: INDEX BY BINARY_INTEGER;
47: TYPE t_payment_amount IS TABLE OF
48: IBY_PAYMENTS_ALL.payment_amount%TYPE
49: INDEX BY BINARY_INTEGER;
44: TYPE t_payment_function IS TABLE OF
45: IBY_PAYMENTS_ALL.payment_function%TYPE
46: INDEX BY BINARY_INTEGER;
47: TYPE t_payment_amount IS TABLE OF
48: IBY_PAYMENTS_ALL.payment_amount%TYPE
49: INDEX BY BINARY_INTEGER;
50: TYPE t_payment_currency_code IS TABLE OF
51: IBY_PAYMENTS_ALL.payment_currency_code%TYPE
52: INDEX BY BINARY_INTEGER;
47: TYPE t_payment_amount IS TABLE OF
48: IBY_PAYMENTS_ALL.payment_amount%TYPE
49: INDEX BY BINARY_INTEGER;
50: TYPE t_payment_currency_code IS TABLE OF
51: IBY_PAYMENTS_ALL.payment_currency_code%TYPE
52: INDEX BY BINARY_INTEGER;
53: TYPE t_bill_payable_flag IS TABLE OF
54: IBY_PAYMENTS_ALL.bill_payable_flag%TYPE
55: INDEX BY BINARY_INTEGER;
50: TYPE t_payment_currency_code IS TABLE OF
51: IBY_PAYMENTS_ALL.payment_currency_code%TYPE
52: INDEX BY BINARY_INTEGER;
53: TYPE t_bill_payable_flag IS TABLE OF
54: IBY_PAYMENTS_ALL.bill_payable_flag%TYPE
55: INDEX BY BINARY_INTEGER;
56: TYPE t_exclusive_payment_flag IS TABLE OF
57: IBY_PAYMENTS_ALL.exclusive_payment_flag%TYPE
58: INDEX BY BINARY_INTEGER;
53: TYPE t_bill_payable_flag IS TABLE OF
54: IBY_PAYMENTS_ALL.bill_payable_flag%TYPE
55: INDEX BY BINARY_INTEGER;
56: TYPE t_exclusive_payment_flag IS TABLE OF
57: IBY_PAYMENTS_ALL.exclusive_payment_flag%TYPE
58: INDEX BY BINARY_INTEGER;
59: TYPE t_sep_remit_advice_req_flag IS TABLE OF
60: IBY_PAYMENTS_ALL.separate_remit_advice_req_flag%TYPE
61: INDEX BY BINARY_INTEGER;
56: TYPE t_exclusive_payment_flag IS TABLE OF
57: IBY_PAYMENTS_ALL.exclusive_payment_flag%TYPE
58: INDEX BY BINARY_INTEGER;
59: TYPE t_sep_remit_advice_req_flag IS TABLE OF
60: IBY_PAYMENTS_ALL.separate_remit_advice_req_flag%TYPE
61: INDEX BY BINARY_INTEGER;
62: TYPE t_internal_bank_account_id IS TABLE OF
63: IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE
64: INDEX BY BINARY_INTEGER;
59: TYPE t_sep_remit_advice_req_flag IS TABLE OF
60: IBY_PAYMENTS_ALL.separate_remit_advice_req_flag%TYPE
61: INDEX BY BINARY_INTEGER;
62: TYPE t_internal_bank_account_id IS TABLE OF
63: IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE
64: INDEX BY BINARY_INTEGER;
65: TYPE t_org_id IS TABLE OF
66: IBY_PAYMENTS_ALL.org_id%TYPE
67: INDEX BY BINARY_INTEGER;
62: TYPE t_internal_bank_account_id IS TABLE OF
63: IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE
64: INDEX BY BINARY_INTEGER;
65: TYPE t_org_id IS TABLE OF
66: IBY_PAYMENTS_ALL.org_id%TYPE
67: INDEX BY BINARY_INTEGER;
68: TYPE t_org_type IS TABLE OF
69: IBY_PAYMENTS_ALL.org_type%TYPE
70: INDEX BY BINARY_INTEGER;
65: TYPE t_org_id IS TABLE OF
66: IBY_PAYMENTS_ALL.org_id%TYPE
67: INDEX BY BINARY_INTEGER;
68: TYPE t_org_type IS TABLE OF
69: IBY_PAYMENTS_ALL.org_type%TYPE
70: INDEX BY BINARY_INTEGER;
71: TYPE t_legal_entity_id IS TABLE OF
72: IBY_PAYMENTS_ALL.legal_entity_id%TYPE
73: INDEX BY BINARY_INTEGER;
68: TYPE t_org_type IS TABLE OF
69: IBY_PAYMENTS_ALL.org_type%TYPE
70: INDEX BY BINARY_INTEGER;
71: TYPE t_legal_entity_id IS TABLE OF
72: IBY_PAYMENTS_ALL.legal_entity_id%TYPE
73: INDEX BY BINARY_INTEGER;
74: TYPE t_declare_payment_flag IS TABLE OF
75: IBY_PAYMENTS_ALL.declare_payment_flag%TYPE
76: INDEX BY BINARY_INTEGER;
71: TYPE t_legal_entity_id IS TABLE OF
72: IBY_PAYMENTS_ALL.legal_entity_id%TYPE
73: INDEX BY BINARY_INTEGER;
74: TYPE t_declare_payment_flag IS TABLE OF
75: IBY_PAYMENTS_ALL.declare_payment_flag%TYPE
76: INDEX BY BINARY_INTEGER;
77: TYPE t_delivery_channel_code IS TABLE OF
78: IBY_PAYMENTS_ALL.delivery_channel_code%TYPE
79: INDEX BY BINARY_INTEGER;
74: TYPE t_declare_payment_flag IS TABLE OF
75: IBY_PAYMENTS_ALL.declare_payment_flag%TYPE
76: INDEX BY BINARY_INTEGER;
77: TYPE t_delivery_channel_code IS TABLE OF
78: IBY_PAYMENTS_ALL.delivery_channel_code%TYPE
79: INDEX BY BINARY_INTEGER;
80: TYPE t_ext_payee_id IS TABLE OF
81: IBY_PAYMENTS_ALL.ext_payee_id%TYPE
82: INDEX BY BINARY_INTEGER;
77: TYPE t_delivery_channel_code IS TABLE OF
78: IBY_PAYMENTS_ALL.delivery_channel_code%TYPE
79: INDEX BY BINARY_INTEGER;
80: TYPE t_ext_payee_id IS TABLE OF
81: IBY_PAYMENTS_ALL.ext_payee_id%TYPE
82: INDEX BY BINARY_INTEGER;
83: TYPE t_payment_instruction_id IS TABLE OF
84: IBY_PAYMENTS_ALL.payment_instruction_id%TYPE
85: INDEX BY BINARY_INTEGER;
80: TYPE t_ext_payee_id IS TABLE OF
81: IBY_PAYMENTS_ALL.ext_payee_id%TYPE
82: INDEX BY BINARY_INTEGER;
83: TYPE t_payment_instruction_id IS TABLE OF
84: IBY_PAYMENTS_ALL.payment_instruction_id%TYPE
85: INDEX BY BINARY_INTEGER;
86: TYPE t_payment_profile_id IS TABLE OF
87: IBY_PAYMENTS_ALL.payment_profile_id%TYPE
88: INDEX BY BINARY_INTEGER;
83: TYPE t_payment_instruction_id IS TABLE OF
84: IBY_PAYMENTS_ALL.payment_instruction_id%TYPE
85: INDEX BY BINARY_INTEGER;
86: TYPE t_payment_profile_id IS TABLE OF
87: IBY_PAYMENTS_ALL.payment_profile_id%TYPE
88: INDEX BY BINARY_INTEGER;
89: TYPE t_pregrouped_payment_flag IS TABLE OF
90: IBY_PAYMENTS_ALL.pregrouped_payment_flag%TYPE
91: INDEX BY BINARY_INTEGER;
86: TYPE t_payment_profile_id IS TABLE OF
87: IBY_PAYMENTS_ALL.payment_profile_id%TYPE
88: INDEX BY BINARY_INTEGER;
89: TYPE t_pregrouped_payment_flag IS TABLE OF
90: IBY_PAYMENTS_ALL.pregrouped_payment_flag%TYPE
91: INDEX BY BINARY_INTEGER;
92: TYPE t_stop_confirmed_flag IS TABLE OF
93: IBY_PAYMENTS_ALL.stop_confirmed_flag%TYPE
94: INDEX BY BINARY_INTEGER;
89: TYPE t_pregrouped_payment_flag IS TABLE OF
90: IBY_PAYMENTS_ALL.pregrouped_payment_flag%TYPE
91: INDEX BY BINARY_INTEGER;
92: TYPE t_stop_confirmed_flag IS TABLE OF
93: IBY_PAYMENTS_ALL.stop_confirmed_flag%TYPE
94: INDEX BY BINARY_INTEGER;
95: TYPE t_stop_released_flag IS TABLE OF
96: IBY_PAYMENTS_ALL.stop_released_flag%TYPE
97: INDEX BY BINARY_INTEGER;
92: TYPE t_stop_confirmed_flag IS TABLE OF
93: IBY_PAYMENTS_ALL.stop_confirmed_flag%TYPE
94: INDEX BY BINARY_INTEGER;
95: TYPE t_stop_released_flag IS TABLE OF
96: IBY_PAYMENTS_ALL.stop_released_flag%TYPE
97: INDEX BY BINARY_INTEGER;
98: TYPE t_stop_request_placed_flag IS TABLE OF
99: IBY_PAYMENTS_ALL.stop_request_placed_flag%TYPE
100: INDEX BY BINARY_INTEGER;
95: TYPE t_stop_released_flag IS TABLE OF
96: IBY_PAYMENTS_ALL.stop_released_flag%TYPE
97: INDEX BY BINARY_INTEGER;
98: TYPE t_stop_request_placed_flag IS TABLE OF
99: IBY_PAYMENTS_ALL.stop_request_placed_flag%TYPE
100: INDEX BY BINARY_INTEGER;
101: TYPE t_created_by IS TABLE OF
102: IBY_PAYMENTS_ALL.created_by%TYPE
103: INDEX BY BINARY_INTEGER;
98: TYPE t_stop_request_placed_flag IS TABLE OF
99: IBY_PAYMENTS_ALL.stop_request_placed_flag%TYPE
100: INDEX BY BINARY_INTEGER;
101: TYPE t_created_by IS TABLE OF
102: IBY_PAYMENTS_ALL.created_by%TYPE
103: INDEX BY BINARY_INTEGER;
104: TYPE t_creation_date IS TABLE OF
105: IBY_PAYMENTS_ALL.creation_date%TYPE
106: INDEX BY BINARY_INTEGER;
101: TYPE t_created_by IS TABLE OF
102: IBY_PAYMENTS_ALL.created_by%TYPE
103: INDEX BY BINARY_INTEGER;
104: TYPE t_creation_date IS TABLE OF
105: IBY_PAYMENTS_ALL.creation_date%TYPE
106: INDEX BY BINARY_INTEGER;
107: TYPE t_last_updated_by IS TABLE OF
108: IBY_PAYMENTS_ALL.last_updated_by%TYPE
109: INDEX BY BINARY_INTEGER;
104: TYPE t_creation_date IS TABLE OF
105: IBY_PAYMENTS_ALL.creation_date%TYPE
106: INDEX BY BINARY_INTEGER;
107: TYPE t_last_updated_by IS TABLE OF
108: IBY_PAYMENTS_ALL.last_updated_by%TYPE
109: INDEX BY BINARY_INTEGER;
110: TYPE t_last_update_login IS TABLE OF
111: IBY_PAYMENTS_ALL.last_update_login%TYPE
112: INDEX BY BINARY_INTEGER;
107: TYPE t_last_updated_by IS TABLE OF
108: IBY_PAYMENTS_ALL.last_updated_by%TYPE
109: INDEX BY BINARY_INTEGER;
110: TYPE t_last_update_login IS TABLE OF
111: IBY_PAYMENTS_ALL.last_update_login%TYPE
112: INDEX BY BINARY_INTEGER;
113: TYPE t_last_update_date IS TABLE OF
114: IBY_PAYMENTS_ALL.last_update_date%TYPE
115: INDEX BY BINARY_INTEGER;
110: TYPE t_last_update_login IS TABLE OF
111: IBY_PAYMENTS_ALL.last_update_login%TYPE
112: INDEX BY BINARY_INTEGER;
113: TYPE t_last_update_date IS TABLE OF
114: IBY_PAYMENTS_ALL.last_update_date%TYPE
115: INDEX BY BINARY_INTEGER;
116: TYPE t_object_version_number IS TABLE OF
117: IBY_PAYMENTS_ALL.object_version_number%TYPE
118: INDEX BY BINARY_INTEGER;
113: TYPE t_last_update_date IS TABLE OF
114: IBY_PAYMENTS_ALL.last_update_date%TYPE
115: INDEX BY BINARY_INTEGER;
116: TYPE t_object_version_number IS TABLE OF
117: IBY_PAYMENTS_ALL.object_version_number%TYPE
118: INDEX BY BINARY_INTEGER;
119: TYPE t_payee_party_id IS TABLE OF
120: IBY_PAYMENTS_ALL.payee_party_id%TYPE
121: INDEX BY BINARY_INTEGER;
116: TYPE t_object_version_number IS TABLE OF
117: IBY_PAYMENTS_ALL.object_version_number%TYPE
118: INDEX BY BINARY_INTEGER;
119: TYPE t_payee_party_id IS TABLE OF
120: IBY_PAYMENTS_ALL.payee_party_id%TYPE
121: INDEX BY BINARY_INTEGER;
122: TYPE t_party_site_id IS TABLE OF
123: IBY_PAYMENTS_ALL.party_site_id%TYPE
124: INDEX BY BINARY_INTEGER;
119: TYPE t_payee_party_id IS TABLE OF
120: IBY_PAYMENTS_ALL.payee_party_id%TYPE
121: INDEX BY BINARY_INTEGER;
122: TYPE t_party_site_id IS TABLE OF
123: IBY_PAYMENTS_ALL.party_site_id%TYPE
124: INDEX BY BINARY_INTEGER;
125: TYPE t_supplier_site_id IS TABLE OF
126: IBY_PAYMENTS_ALL.supplier_site_id%TYPE
127: INDEX BY BINARY_INTEGER;
122: TYPE t_party_site_id IS TABLE OF
123: IBY_PAYMENTS_ALL.party_site_id%TYPE
124: INDEX BY BINARY_INTEGER;
125: TYPE t_supplier_site_id IS TABLE OF
126: IBY_PAYMENTS_ALL.supplier_site_id%TYPE
127: INDEX BY BINARY_INTEGER;
128: TYPE t_payment_reason_code IS TABLE OF
129: IBY_PAYMENTS_ALL.payment_reason_code%TYPE
130: INDEX BY BINARY_INTEGER;
125: TYPE t_supplier_site_id IS TABLE OF
126: IBY_PAYMENTS_ALL.supplier_site_id%TYPE
127: INDEX BY BINARY_INTEGER;
128: TYPE t_payment_reason_code IS TABLE OF
129: IBY_PAYMENTS_ALL.payment_reason_code%TYPE
130: INDEX BY BINARY_INTEGER;
131: TYPE t_payment_reason_comments IS TABLE OF
132: IBY_PAYMENTS_ALL.payment_reason_comments%TYPE
133: INDEX BY BINARY_INTEGER;
128: TYPE t_payment_reason_code IS TABLE OF
129: IBY_PAYMENTS_ALL.payment_reason_code%TYPE
130: INDEX BY BINARY_INTEGER;
131: TYPE t_payment_reason_comments IS TABLE OF
132: IBY_PAYMENTS_ALL.payment_reason_comments%TYPE
133: INDEX BY BINARY_INTEGER;
134: TYPE t_payment_date IS TABLE OF
135: IBY_PAYMENTS_ALL.payment_date%TYPE
136: INDEX BY BINARY_INTEGER;
131: TYPE t_payment_reason_comments IS TABLE OF
132: IBY_PAYMENTS_ALL.payment_reason_comments%TYPE
133: INDEX BY BINARY_INTEGER;
134: TYPE t_payment_date IS TABLE OF
135: IBY_PAYMENTS_ALL.payment_date%TYPE
136: INDEX BY BINARY_INTEGER;
137: TYPE t_anticipated_value_date IS TABLE OF
138: IBY_PAYMENTS_ALL.anticipated_value_date%TYPE
139: INDEX BY BINARY_INTEGER;
134: TYPE t_payment_date IS TABLE OF
135: IBY_PAYMENTS_ALL.payment_date%TYPE
136: INDEX BY BINARY_INTEGER;
137: TYPE t_anticipated_value_date IS TABLE OF
138: IBY_PAYMENTS_ALL.anticipated_value_date%TYPE
139: INDEX BY BINARY_INTEGER;
140: TYPE t_declaration_amount IS TABLE OF
141: IBY_PAYMENTS_ALL.declaration_amount%TYPE
142: INDEX BY BINARY_INTEGER;
137: TYPE t_anticipated_value_date IS TABLE OF
138: IBY_PAYMENTS_ALL.anticipated_value_date%TYPE
139: INDEX BY BINARY_INTEGER;
140: TYPE t_declaration_amount IS TABLE OF
141: IBY_PAYMENTS_ALL.declaration_amount%TYPE
142: INDEX BY BINARY_INTEGER;
143: TYPE t_declaration_currency_code IS TABLE OF
144: IBY_PAYMENTS_ALL.declaration_currency_code%TYPE
145: INDEX BY BINARY_INTEGER;
140: TYPE t_declaration_amount IS TABLE OF
141: IBY_PAYMENTS_ALL.declaration_amount%TYPE
142: INDEX BY BINARY_INTEGER;
143: TYPE t_declaration_currency_code IS TABLE OF
144: IBY_PAYMENTS_ALL.declaration_currency_code%TYPE
145: INDEX BY BINARY_INTEGER;
146: TYPE t_discount_amount_taken IS TABLE OF
147: IBY_PAYMENTS_ALL.discount_amount_taken%TYPE
148: INDEX BY BINARY_INTEGER;
143: TYPE t_declaration_currency_code IS TABLE OF
144: IBY_PAYMENTS_ALL.declaration_currency_code%TYPE
145: INDEX BY BINARY_INTEGER;
146: TYPE t_discount_amount_taken IS TABLE OF
147: IBY_PAYMENTS_ALL.discount_amount_taken%TYPE
148: INDEX BY BINARY_INTEGER;
149: TYPE t_payment_details IS TABLE OF
150: IBY_PAYMENTS_ALL.payment_details%TYPE
151: INDEX BY BINARY_INTEGER;
146: TYPE t_discount_amount_taken IS TABLE OF
147: IBY_PAYMENTS_ALL.discount_amount_taken%TYPE
148: INDEX BY BINARY_INTEGER;
149: TYPE t_payment_details IS TABLE OF
150: IBY_PAYMENTS_ALL.payment_details%TYPE
151: INDEX BY BINARY_INTEGER;
152: TYPE t_bank_charge_bearer IS TABLE OF
153: IBY_PAYMENTS_ALL.bank_charge_bearer%TYPE
154: INDEX BY BINARY_INTEGER;
149: TYPE t_payment_details IS TABLE OF
150: IBY_PAYMENTS_ALL.payment_details%TYPE
151: INDEX BY BINARY_INTEGER;
152: TYPE t_bank_charge_bearer IS TABLE OF
153: IBY_PAYMENTS_ALL.bank_charge_bearer%TYPE
154: INDEX BY BINARY_INTEGER;
155: TYPE t_bank_charge_amount IS TABLE OF
156: IBY_PAYMENTS_ALL.bank_charge_amount%TYPE
157: INDEX BY BINARY_INTEGER;
152: TYPE t_bank_charge_bearer IS TABLE OF
153: IBY_PAYMENTS_ALL.bank_charge_bearer%TYPE
154: INDEX BY BINARY_INTEGER;
155: TYPE t_bank_charge_amount IS TABLE OF
156: IBY_PAYMENTS_ALL.bank_charge_amount%TYPE
157: INDEX BY BINARY_INTEGER;
158: TYPE t_settlement_priority IS TABLE OF
159: IBY_PAYMENTS_ALL.settlement_priority%TYPE
160: INDEX BY BINARY_INTEGER;
155: TYPE t_bank_charge_amount IS TABLE OF
156: IBY_PAYMENTS_ALL.bank_charge_amount%TYPE
157: INDEX BY BINARY_INTEGER;
158: TYPE t_settlement_priority IS TABLE OF
159: IBY_PAYMENTS_ALL.settlement_priority%TYPE
160: INDEX BY BINARY_INTEGER;
161: TYPE t_remittance_message1 IS TABLE OF
162: IBY_PAYMENTS_ALL.remittance_message1%TYPE
163: INDEX BY BINARY_INTEGER;
158: TYPE t_settlement_priority IS TABLE OF
159: IBY_PAYMENTS_ALL.settlement_priority%TYPE
160: INDEX BY BINARY_INTEGER;
161: TYPE t_remittance_message1 IS TABLE OF
162: IBY_PAYMENTS_ALL.remittance_message1%TYPE
163: INDEX BY BINARY_INTEGER;
164: TYPE t_remittance_message2 IS TABLE OF
165: IBY_PAYMENTS_ALL.remittance_message2%TYPE
166: INDEX BY BINARY_INTEGER;
161: TYPE t_remittance_message1 IS TABLE OF
162: IBY_PAYMENTS_ALL.remittance_message1%TYPE
163: INDEX BY BINARY_INTEGER;
164: TYPE t_remittance_message2 IS TABLE OF
165: IBY_PAYMENTS_ALL.remittance_message2%TYPE
166: INDEX BY BINARY_INTEGER;
167: TYPE t_remittance_message3 IS TABLE OF
168: IBY_PAYMENTS_ALL.remittance_message3%TYPE
169: INDEX BY BINARY_INTEGER;
164: TYPE t_remittance_message2 IS TABLE OF
165: IBY_PAYMENTS_ALL.remittance_message2%TYPE
166: INDEX BY BINARY_INTEGER;
167: TYPE t_remittance_message3 IS TABLE OF
168: IBY_PAYMENTS_ALL.remittance_message3%TYPE
169: INDEX BY BINARY_INTEGER;
170: TYPE t_payment_reference_number IS TABLE OF
171: IBY_PAYMENTS_ALL.payment_reference_number%TYPE
172: INDEX BY BINARY_INTEGER;
167: TYPE t_remittance_message3 IS TABLE OF
168: IBY_PAYMENTS_ALL.remittance_message3%TYPE
169: INDEX BY BINARY_INTEGER;
170: TYPE t_payment_reference_number IS TABLE OF
171: IBY_PAYMENTS_ALL.payment_reference_number%TYPE
172: INDEX BY BINARY_INTEGER;
173: TYPE t_paper_document_number IS TABLE OF
174: IBY_PAYMENTS_ALL.paper_document_number%TYPE
175: INDEX BY BINARY_INTEGER;
170: TYPE t_payment_reference_number IS TABLE OF
171: IBY_PAYMENTS_ALL.payment_reference_number%TYPE
172: INDEX BY BINARY_INTEGER;
173: TYPE t_paper_document_number IS TABLE OF
174: IBY_PAYMENTS_ALL.paper_document_number%TYPE
175: INDEX BY BINARY_INTEGER;
176: TYPE t_bank_assigned_ref_code IS TABLE OF
177: IBY_PAYMENTS_ALL.bank_assigned_ref_code%TYPE
178: INDEX BY BINARY_INTEGER;
173: TYPE t_paper_document_number IS TABLE OF
174: IBY_PAYMENTS_ALL.paper_document_number%TYPE
175: INDEX BY BINARY_INTEGER;
176: TYPE t_bank_assigned_ref_code IS TABLE OF
177: IBY_PAYMENTS_ALL.bank_assigned_ref_code%TYPE
178: INDEX BY BINARY_INTEGER;
179: TYPE t_external_bank_account_id IS TABLE OF
180: IBY_PAYMENTS_ALL.external_bank_account_id%TYPE
181: INDEX BY BINARY_INTEGER;
176: TYPE t_bank_assigned_ref_code IS TABLE OF
177: IBY_PAYMENTS_ALL.bank_assigned_ref_code%TYPE
178: INDEX BY BINARY_INTEGER;
179: TYPE t_external_bank_account_id IS TABLE OF
180: IBY_PAYMENTS_ALL.external_bank_account_id%TYPE
181: INDEX BY BINARY_INTEGER;
182: TYPE t_unique_remittance_identifier IS TABLE OF
183: IBY_PAYMENTS_ALL.unique_remittance_identifier%TYPE
184: INDEX BY BINARY_INTEGER;
179: TYPE t_external_bank_account_id IS TABLE OF
180: IBY_PAYMENTS_ALL.external_bank_account_id%TYPE
181: INDEX BY BINARY_INTEGER;
182: TYPE t_unique_remittance_identifier IS TABLE OF
183: IBY_PAYMENTS_ALL.unique_remittance_identifier%TYPE
184: INDEX BY BINARY_INTEGER;
185: TYPE t_uri_check_digit IS TABLE OF
186: IBY_PAYMENTS_ALL.uri_check_digit%TYPE
187: INDEX BY BINARY_INTEGER;
182: TYPE t_unique_remittance_identifier IS TABLE OF
183: IBY_PAYMENTS_ALL.unique_remittance_identifier%TYPE
184: INDEX BY BINARY_INTEGER;
185: TYPE t_uri_check_digit IS TABLE OF
186: IBY_PAYMENTS_ALL.uri_check_digit%TYPE
187: INDEX BY BINARY_INTEGER;
188: TYPE t_bank_instruction1_code IS TABLE OF
189: IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE
190: INDEX BY BINARY_INTEGER;
185: TYPE t_uri_check_digit IS TABLE OF
186: IBY_PAYMENTS_ALL.uri_check_digit%TYPE
187: INDEX BY BINARY_INTEGER;
188: TYPE t_bank_instruction1_code IS TABLE OF
189: IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE
190: INDEX BY BINARY_INTEGER;
191: TYPE t_bank_instruction2_code IS TABLE OF
192: IBY_PAYMENTS_ALL.bank_instruction2_code%TYPE
193: INDEX BY BINARY_INTEGER;
188: TYPE t_bank_instruction1_code IS TABLE OF
189: IBY_PAYMENTS_ALL.bank_instruction1_code%TYPE
190: INDEX BY BINARY_INTEGER;
191: TYPE t_bank_instruction2_code IS TABLE OF
192: IBY_PAYMENTS_ALL.bank_instruction2_code%TYPE
193: INDEX BY BINARY_INTEGER;
194: TYPE t_bank_instruction_details IS TABLE OF
195: IBY_PAYMENTS_ALL.bank_instruction_details%TYPE
196: INDEX BY BINARY_INTEGER;
191: TYPE t_bank_instruction2_code IS TABLE OF
192: IBY_PAYMENTS_ALL.bank_instruction2_code%TYPE
193: INDEX BY BINARY_INTEGER;
194: TYPE t_bank_instruction_details IS TABLE OF
195: IBY_PAYMENTS_ALL.bank_instruction_details%TYPE
196: INDEX BY BINARY_INTEGER;
197: TYPE t_payment_text_message1 IS TABLE OF
198: IBY_PAYMENTS_ALL.payment_text_message1%TYPE
199: INDEX BY BINARY_INTEGER;
194: TYPE t_bank_instruction_details IS TABLE OF
195: IBY_PAYMENTS_ALL.bank_instruction_details%TYPE
196: INDEX BY BINARY_INTEGER;
197: TYPE t_payment_text_message1 IS TABLE OF
198: IBY_PAYMENTS_ALL.payment_text_message1%TYPE
199: INDEX BY BINARY_INTEGER;
200: TYPE t_payment_text_message2 IS TABLE OF
201: IBY_PAYMENTS_ALL.payment_text_message2%TYPE
202: INDEX BY BINARY_INTEGER;
197: TYPE t_payment_text_message1 IS TABLE OF
198: IBY_PAYMENTS_ALL.payment_text_message1%TYPE
199: INDEX BY BINARY_INTEGER;
200: TYPE t_payment_text_message2 IS TABLE OF
201: IBY_PAYMENTS_ALL.payment_text_message2%TYPE
202: INDEX BY BINARY_INTEGER;
203: TYPE t_payment_text_message3 IS TABLE OF
204: IBY_PAYMENTS_ALL.payment_text_message3%TYPE
205: INDEX BY BINARY_INTEGER;
200: TYPE t_payment_text_message2 IS TABLE OF
201: IBY_PAYMENTS_ALL.payment_text_message2%TYPE
202: INDEX BY BINARY_INTEGER;
203: TYPE t_payment_text_message3 IS TABLE OF
204: IBY_PAYMENTS_ALL.payment_text_message3%TYPE
205: INDEX BY BINARY_INTEGER;
206: TYPE t_maturity_date IS TABLE OF
207: IBY_PAYMENTS_ALL.maturity_date%TYPE
208: INDEX BY BINARY_INTEGER;
203: TYPE t_payment_text_message3 IS TABLE OF
204: IBY_PAYMENTS_ALL.payment_text_message3%TYPE
205: INDEX BY BINARY_INTEGER;
206: TYPE t_maturity_date IS TABLE OF
207: IBY_PAYMENTS_ALL.maturity_date%TYPE
208: INDEX BY BINARY_INTEGER;
209: TYPE t_payment_due_date IS TABLE OF
210: IBY_PAYMENTS_ALL.payment_due_date%TYPE
211: INDEX BY BINARY_INTEGER;
206: TYPE t_maturity_date IS TABLE OF
207: IBY_PAYMENTS_ALL.maturity_date%TYPE
208: INDEX BY BINARY_INTEGER;
209: TYPE t_payment_due_date IS TABLE OF
210: IBY_PAYMENTS_ALL.payment_due_date%TYPE
211: INDEX BY BINARY_INTEGER;
212: TYPE t_document_category_code IS TABLE OF
213: IBY_PAYMENTS_ALL.document_category_code%TYPE
214: INDEX BY BINARY_INTEGER;
209: TYPE t_payment_due_date IS TABLE OF
210: IBY_PAYMENTS_ALL.payment_due_date%TYPE
211: INDEX BY BINARY_INTEGER;
212: TYPE t_document_category_code IS TABLE OF
213: IBY_PAYMENTS_ALL.document_category_code%TYPE
214: INDEX BY BINARY_INTEGER;
215: TYPE t_document_sequence_id IS TABLE OF
216: IBY_PAYMENTS_ALL.document_sequence_id%TYPE
217: INDEX BY BINARY_INTEGER;
212: TYPE t_document_category_code IS TABLE OF
213: IBY_PAYMENTS_ALL.document_category_code%TYPE
214: INDEX BY BINARY_INTEGER;
215: TYPE t_document_sequence_id IS TABLE OF
216: IBY_PAYMENTS_ALL.document_sequence_id%TYPE
217: INDEX BY BINARY_INTEGER;
218: TYPE t_document_sequence_value IS TABLE OF
219: IBY_PAYMENTS_ALL.document_sequence_value%TYPE
220: INDEX BY BINARY_INTEGER;
215: TYPE t_document_sequence_id IS TABLE OF
216: IBY_PAYMENTS_ALL.document_sequence_id%TYPE
217: INDEX BY BINARY_INTEGER;
218: TYPE t_document_sequence_value IS TABLE OF
219: IBY_PAYMENTS_ALL.document_sequence_value%TYPE
220: INDEX BY BINARY_INTEGER;
221: TYPE t_beneficiary_party IS TABLE OF
222: IBY_PAYMENTS_ALL.beneficiary_party%TYPE
223: INDEX BY BINARY_INTEGER;
218: TYPE t_document_sequence_value IS TABLE OF
219: IBY_PAYMENTS_ALL.document_sequence_value%TYPE
220: INDEX BY BINARY_INTEGER;
221: TYPE t_beneficiary_party IS TABLE OF
222: IBY_PAYMENTS_ALL.beneficiary_party%TYPE
223: INDEX BY BINARY_INTEGER;
224: TYPE t_stop_confirmed_by IS TABLE OF
225: IBY_PAYMENTS_ALL.stop_confirmed_by%TYPE
226: INDEX BY BINARY_INTEGER;
221: TYPE t_beneficiary_party IS TABLE OF
222: IBY_PAYMENTS_ALL.beneficiary_party%TYPE
223: INDEX BY BINARY_INTEGER;
224: TYPE t_stop_confirmed_by IS TABLE OF
225: IBY_PAYMENTS_ALL.stop_confirmed_by%TYPE
226: INDEX BY BINARY_INTEGER;
227: TYPE t_stop_confirm_date IS TABLE OF
228: IBY_PAYMENTS_ALL.stop_confirm_date%TYPE
229: INDEX BY BINARY_INTEGER;
224: TYPE t_stop_confirmed_by IS TABLE OF
225: IBY_PAYMENTS_ALL.stop_confirmed_by%TYPE
226: INDEX BY BINARY_INTEGER;
227: TYPE t_stop_confirm_date IS TABLE OF
228: IBY_PAYMENTS_ALL.stop_confirm_date%TYPE
229: INDEX BY BINARY_INTEGER;
230: TYPE t_stop_confirm_reason IS TABLE OF
231: IBY_PAYMENTS_ALL.stop_confirm_reason%TYPE
232: INDEX BY BINARY_INTEGER;
227: TYPE t_stop_confirm_date IS TABLE OF
228: IBY_PAYMENTS_ALL.stop_confirm_date%TYPE
229: INDEX BY BINARY_INTEGER;
230: TYPE t_stop_confirm_reason IS TABLE OF
231: IBY_PAYMENTS_ALL.stop_confirm_reason%TYPE
232: INDEX BY BINARY_INTEGER;
233: TYPE t_stop_confirm_reference IS TABLE OF
234: IBY_PAYMENTS_ALL.stop_confirm_reference%TYPE
235: INDEX BY BINARY_INTEGER;
230: TYPE t_stop_confirm_reason IS TABLE OF
231: IBY_PAYMENTS_ALL.stop_confirm_reason%TYPE
232: INDEX BY BINARY_INTEGER;
233: TYPE t_stop_confirm_reference IS TABLE OF
234: IBY_PAYMENTS_ALL.stop_confirm_reference%TYPE
235: INDEX BY BINARY_INTEGER;
236: TYPE t_stop_released_by IS TABLE OF
237: IBY_PAYMENTS_ALL.stop_released_by%TYPE
238: INDEX BY BINARY_INTEGER;
233: TYPE t_stop_confirm_reference IS TABLE OF
234: IBY_PAYMENTS_ALL.stop_confirm_reference%TYPE
235: INDEX BY BINARY_INTEGER;
236: TYPE t_stop_released_by IS TABLE OF
237: IBY_PAYMENTS_ALL.stop_released_by%TYPE
238: INDEX BY BINARY_INTEGER;
239: TYPE t_stop_release_date IS TABLE OF
240: IBY_PAYMENTS_ALL.stop_release_date%TYPE
241: INDEX BY BINARY_INTEGER;
236: TYPE t_stop_released_by IS TABLE OF
237: IBY_PAYMENTS_ALL.stop_released_by%TYPE
238: INDEX BY BINARY_INTEGER;
239: TYPE t_stop_release_date IS TABLE OF
240: IBY_PAYMENTS_ALL.stop_release_date%TYPE
241: INDEX BY BINARY_INTEGER;
242: TYPE t_stop_release_reason IS TABLE OF
243: IBY_PAYMENTS_ALL.stop_release_reason%TYPE
244: INDEX BY BINARY_INTEGER;
239: TYPE t_stop_release_date IS TABLE OF
240: IBY_PAYMENTS_ALL.stop_release_date%TYPE
241: INDEX BY BINARY_INTEGER;
242: TYPE t_stop_release_reason IS TABLE OF
243: IBY_PAYMENTS_ALL.stop_release_reason%TYPE
244: INDEX BY BINARY_INTEGER;
245: TYPE t_stop_release_reference IS TABLE OF
246: IBY_PAYMENTS_ALL.stop_release_reference%TYPE
247: INDEX BY BINARY_INTEGER;
242: TYPE t_stop_release_reason IS TABLE OF
243: IBY_PAYMENTS_ALL.stop_release_reason%TYPE
244: INDEX BY BINARY_INTEGER;
245: TYPE t_stop_release_reference IS TABLE OF
246: IBY_PAYMENTS_ALL.stop_release_reference%TYPE
247: INDEX BY BINARY_INTEGER;
248: TYPE t_stop_request_date IS TABLE OF
249: IBY_PAYMENTS_ALL.stop_request_date%TYPE
250: INDEX BY BINARY_INTEGER;
245: TYPE t_stop_release_reference IS TABLE OF
246: IBY_PAYMENTS_ALL.stop_release_reference%TYPE
247: INDEX BY BINARY_INTEGER;
248: TYPE t_stop_request_date IS TABLE OF
249: IBY_PAYMENTS_ALL.stop_request_date%TYPE
250: INDEX BY BINARY_INTEGER;
251: TYPE t_stop_request_placed_by IS TABLE OF
252: IBY_PAYMENTS_ALL.stop_request_placed_by%TYPE
253: INDEX BY BINARY_INTEGER;
248: TYPE t_stop_request_date IS TABLE OF
249: IBY_PAYMENTS_ALL.stop_request_date%TYPE
250: INDEX BY BINARY_INTEGER;
251: TYPE t_stop_request_placed_by IS TABLE OF
252: IBY_PAYMENTS_ALL.stop_request_placed_by%TYPE
253: INDEX BY BINARY_INTEGER;
254: TYPE t_stop_request_reason IS TABLE OF
255: IBY_PAYMENTS_ALL.stop_request_reason%TYPE
256: INDEX BY BINARY_INTEGER;
251: TYPE t_stop_request_placed_by IS TABLE OF
252: IBY_PAYMENTS_ALL.stop_request_placed_by%TYPE
253: INDEX BY BINARY_INTEGER;
254: TYPE t_stop_request_reason IS TABLE OF
255: IBY_PAYMENTS_ALL.stop_request_reason%TYPE
256: INDEX BY BINARY_INTEGER;
257: TYPE t_stop_request_reference IS TABLE OF
258: IBY_PAYMENTS_ALL.stop_request_reference%TYPE
259: INDEX BY BINARY_INTEGER;
254: TYPE t_stop_request_reason IS TABLE OF
255: IBY_PAYMENTS_ALL.stop_request_reason%TYPE
256: INDEX BY BINARY_INTEGER;
257: TYPE t_stop_request_reference IS TABLE OF
258: IBY_PAYMENTS_ALL.stop_request_reference%TYPE
259: INDEX BY BINARY_INTEGER;
260: TYPE t_voided_by IS TABLE OF
261: IBY_PAYMENTS_ALL.voided_by%TYPE
262: INDEX BY BINARY_INTEGER;
257: TYPE t_stop_request_reference IS TABLE OF
258: IBY_PAYMENTS_ALL.stop_request_reference%TYPE
259: INDEX BY BINARY_INTEGER;
260: TYPE t_voided_by IS TABLE OF
261: IBY_PAYMENTS_ALL.voided_by%TYPE
262: INDEX BY BINARY_INTEGER;
263: TYPE t_void_date IS TABLE OF
264: IBY_PAYMENTS_ALL.void_date%TYPE
265: INDEX BY BINARY_INTEGER;
260: TYPE t_voided_by IS TABLE OF
261: IBY_PAYMENTS_ALL.voided_by%TYPE
262: INDEX BY BINARY_INTEGER;
263: TYPE t_void_date IS TABLE OF
264: IBY_PAYMENTS_ALL.void_date%TYPE
265: INDEX BY BINARY_INTEGER;
266: TYPE t_void_reason IS TABLE OF
267: IBY_PAYMENTS_ALL.void_reason%TYPE
268: INDEX BY BINARY_INTEGER;
263: TYPE t_void_date IS TABLE OF
264: IBY_PAYMENTS_ALL.void_date%TYPE
265: INDEX BY BINARY_INTEGER;
266: TYPE t_void_reason IS TABLE OF
267: IBY_PAYMENTS_ALL.void_reason%TYPE
268: INDEX BY BINARY_INTEGER;
269: TYPE t_remit_to_location_id IS TABLE OF
270: IBY_PAYMENTS_ALL.remit_to_location_id%TYPE
271: INDEX BY BINARY_INTEGER;
266: TYPE t_void_reason IS TABLE OF
267: IBY_PAYMENTS_ALL.void_reason%TYPE
268: INDEX BY BINARY_INTEGER;
269: TYPE t_remit_to_location_id IS TABLE OF
270: IBY_PAYMENTS_ALL.remit_to_location_id%TYPE
271: INDEX BY BINARY_INTEGER;
272: TYPE t_completed_pmts_group_id IS TABLE OF
273: IBY_PAYMENTS_ALL.completed_pmts_group_id%TYPE
274: INDEX BY BINARY_INTEGER;
269: TYPE t_remit_to_location_id IS TABLE OF
270: IBY_PAYMENTS_ALL.remit_to_location_id%TYPE
271: INDEX BY BINARY_INTEGER;
272: TYPE t_completed_pmts_group_id IS TABLE OF
273: IBY_PAYMENTS_ALL.completed_pmts_group_id%TYPE
274: INDEX BY BINARY_INTEGER;
275: TYPE t_attribute_category IS TABLE OF
276: IBY_PAYMENTS_ALL.attribute_category%TYPE
277: INDEX BY BINARY_INTEGER;
272: TYPE t_completed_pmts_group_id IS TABLE OF
273: IBY_PAYMENTS_ALL.completed_pmts_group_id%TYPE
274: INDEX BY BINARY_INTEGER;
275: TYPE t_attribute_category IS TABLE OF
276: IBY_PAYMENTS_ALL.attribute_category%TYPE
277: INDEX BY BINARY_INTEGER;
278: TYPE t_attribute1 IS TABLE OF
279: IBY_PAYMENTS_ALL.attribute1%TYPE
280: INDEX BY BINARY_INTEGER;
275: TYPE t_attribute_category IS TABLE OF
276: IBY_PAYMENTS_ALL.attribute_category%TYPE
277: INDEX BY BINARY_INTEGER;
278: TYPE t_attribute1 IS TABLE OF
279: IBY_PAYMENTS_ALL.attribute1%TYPE
280: INDEX BY BINARY_INTEGER;
281: TYPE t_attribute2 IS TABLE OF
282: IBY_PAYMENTS_ALL.attribute2%TYPE
283: INDEX BY BINARY_INTEGER;
278: TYPE t_attribute1 IS TABLE OF
279: IBY_PAYMENTS_ALL.attribute1%TYPE
280: INDEX BY BINARY_INTEGER;
281: TYPE t_attribute2 IS TABLE OF
282: IBY_PAYMENTS_ALL.attribute2%TYPE
283: INDEX BY BINARY_INTEGER;
284: TYPE t_attribute3 IS TABLE OF
285: IBY_PAYMENTS_ALL.attribute3%TYPE
286: INDEX BY BINARY_INTEGER;
281: TYPE t_attribute2 IS TABLE OF
282: IBY_PAYMENTS_ALL.attribute2%TYPE
283: INDEX BY BINARY_INTEGER;
284: TYPE t_attribute3 IS TABLE OF
285: IBY_PAYMENTS_ALL.attribute3%TYPE
286: INDEX BY BINARY_INTEGER;
287: TYPE t_attribute4 IS TABLE OF
288: IBY_PAYMENTS_ALL.attribute4%TYPE
289: INDEX BY BINARY_INTEGER;
284: TYPE t_attribute3 IS TABLE OF
285: IBY_PAYMENTS_ALL.attribute3%TYPE
286: INDEX BY BINARY_INTEGER;
287: TYPE t_attribute4 IS TABLE OF
288: IBY_PAYMENTS_ALL.attribute4%TYPE
289: INDEX BY BINARY_INTEGER;
290: TYPE t_attribute5 IS TABLE OF
291: IBY_PAYMENTS_ALL.attribute5%TYPE
292: INDEX BY BINARY_INTEGER;
287: TYPE t_attribute4 IS TABLE OF
288: IBY_PAYMENTS_ALL.attribute4%TYPE
289: INDEX BY BINARY_INTEGER;
290: TYPE t_attribute5 IS TABLE OF
291: IBY_PAYMENTS_ALL.attribute5%TYPE
292: INDEX BY BINARY_INTEGER;
293: TYPE t_attribute6 IS TABLE OF
294: IBY_PAYMENTS_ALL.attribute6%TYPE
295: INDEX BY BINARY_INTEGER;
290: TYPE t_attribute5 IS TABLE OF
291: IBY_PAYMENTS_ALL.attribute5%TYPE
292: INDEX BY BINARY_INTEGER;
293: TYPE t_attribute6 IS TABLE OF
294: IBY_PAYMENTS_ALL.attribute6%TYPE
295: INDEX BY BINARY_INTEGER;
296: TYPE t_attribute7 IS TABLE OF
297: IBY_PAYMENTS_ALL.attribute7%TYPE
298: INDEX BY BINARY_INTEGER;
293: TYPE t_attribute6 IS TABLE OF
294: IBY_PAYMENTS_ALL.attribute6%TYPE
295: INDEX BY BINARY_INTEGER;
296: TYPE t_attribute7 IS TABLE OF
297: IBY_PAYMENTS_ALL.attribute7%TYPE
298: INDEX BY BINARY_INTEGER;
299: TYPE t_attribute8 IS TABLE OF
300: IBY_PAYMENTS_ALL.attribute8%TYPE
301: INDEX BY BINARY_INTEGER;
296: TYPE t_attribute7 IS TABLE OF
297: IBY_PAYMENTS_ALL.attribute7%TYPE
298: INDEX BY BINARY_INTEGER;
299: TYPE t_attribute8 IS TABLE OF
300: IBY_PAYMENTS_ALL.attribute8%TYPE
301: INDEX BY BINARY_INTEGER;
302: TYPE t_attribute9 IS TABLE OF
303: IBY_PAYMENTS_ALL.attribute9%TYPE
304: INDEX BY BINARY_INTEGER;
299: TYPE t_attribute8 IS TABLE OF
300: IBY_PAYMENTS_ALL.attribute8%TYPE
301: INDEX BY BINARY_INTEGER;
302: TYPE t_attribute9 IS TABLE OF
303: IBY_PAYMENTS_ALL.attribute9%TYPE
304: INDEX BY BINARY_INTEGER;
305: TYPE t_attribute10 IS TABLE OF
306: IBY_PAYMENTS_ALL.attribute10%TYPE
307: INDEX BY BINARY_INTEGER;
302: TYPE t_attribute9 IS TABLE OF
303: IBY_PAYMENTS_ALL.attribute9%TYPE
304: INDEX BY BINARY_INTEGER;
305: TYPE t_attribute10 IS TABLE OF
306: IBY_PAYMENTS_ALL.attribute10%TYPE
307: INDEX BY BINARY_INTEGER;
308: TYPE t_attribute11 IS TABLE OF
309: IBY_PAYMENTS_ALL.attribute11%TYPE
310: INDEX BY BINARY_INTEGER;
305: TYPE t_attribute10 IS TABLE OF
306: IBY_PAYMENTS_ALL.attribute10%TYPE
307: INDEX BY BINARY_INTEGER;
308: TYPE t_attribute11 IS TABLE OF
309: IBY_PAYMENTS_ALL.attribute11%TYPE
310: INDEX BY BINARY_INTEGER;
311: TYPE t_attribute12 IS TABLE OF
312: IBY_PAYMENTS_ALL.attribute12%TYPE
313: INDEX BY BINARY_INTEGER;
308: TYPE t_attribute11 IS TABLE OF
309: IBY_PAYMENTS_ALL.attribute11%TYPE
310: INDEX BY BINARY_INTEGER;
311: TYPE t_attribute12 IS TABLE OF
312: IBY_PAYMENTS_ALL.attribute12%TYPE
313: INDEX BY BINARY_INTEGER;
314: TYPE t_attribute13 IS TABLE OF
315: IBY_PAYMENTS_ALL.attribute13%TYPE
316: INDEX BY BINARY_INTEGER;
311: TYPE t_attribute12 IS TABLE OF
312: IBY_PAYMENTS_ALL.attribute12%TYPE
313: INDEX BY BINARY_INTEGER;
314: TYPE t_attribute13 IS TABLE OF
315: IBY_PAYMENTS_ALL.attribute13%TYPE
316: INDEX BY BINARY_INTEGER;
317: TYPE t_attribute14 IS TABLE OF
318: IBY_PAYMENTS_ALL.attribute14%TYPE
319: INDEX BY BINARY_INTEGER;
314: TYPE t_attribute13 IS TABLE OF
315: IBY_PAYMENTS_ALL.attribute13%TYPE
316: INDEX BY BINARY_INTEGER;
317: TYPE t_attribute14 IS TABLE OF
318: IBY_PAYMENTS_ALL.attribute14%TYPE
319: INDEX BY BINARY_INTEGER;
320: TYPE t_attribute15 IS TABLE OF
321: IBY_PAYMENTS_ALL.attribute15%TYPE
322: INDEX BY BINARY_INTEGER;
317: TYPE t_attribute14 IS TABLE OF
318: IBY_PAYMENTS_ALL.attribute14%TYPE
319: INDEX BY BINARY_INTEGER;
320: TYPE t_attribute15 IS TABLE OF
321: IBY_PAYMENTS_ALL.attribute15%TYPE
322: INDEX BY BINARY_INTEGER;
323: TYPE t_ext_branch_number IS TABLE OF
324: IBY_PAYMENTS_ALL.ext_branch_number%TYPE
325: INDEX BY BINARY_INTEGER;
320: TYPE t_attribute15 IS TABLE OF
321: IBY_PAYMENTS_ALL.attribute15%TYPE
322: INDEX BY BINARY_INTEGER;
323: TYPE t_ext_branch_number IS TABLE OF
324: IBY_PAYMENTS_ALL.ext_branch_number%TYPE
325: INDEX BY BINARY_INTEGER;
326: TYPE t_ext_bank_number IS TABLE OF
327: IBY_PAYMENTS_ALL.ext_bank_number%TYPE
328: INDEX BY BINARY_INTEGER;
323: TYPE t_ext_branch_number IS TABLE OF
324: IBY_PAYMENTS_ALL.ext_branch_number%TYPE
325: INDEX BY BINARY_INTEGER;
326: TYPE t_ext_bank_number IS TABLE OF
327: IBY_PAYMENTS_ALL.ext_bank_number%TYPE
328: INDEX BY BINARY_INTEGER;
329: TYPE t_ext_bank_account_name IS TABLE OF
330: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE
331: INDEX BY BINARY_INTEGER;
326: TYPE t_ext_bank_number IS TABLE OF
327: IBY_PAYMENTS_ALL.ext_bank_number%TYPE
328: INDEX BY BINARY_INTEGER;
329: TYPE t_ext_bank_account_name IS TABLE OF
330: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE
331: INDEX BY BINARY_INTEGER;
332: TYPE t_ext_bank_account_number IS TABLE OF
333: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE
334: INDEX BY BINARY_INTEGER;
329: TYPE t_ext_bank_account_name IS TABLE OF
330: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE
331: INDEX BY BINARY_INTEGER;
332: TYPE t_ext_bank_account_number IS TABLE OF
333: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE
334: INDEX BY BINARY_INTEGER;
335: TYPE t_ext_bank_account_type IS TABLE OF
336: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE
337: INDEX BY BINARY_INTEGER;
332: TYPE t_ext_bank_account_number IS TABLE OF
333: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE
334: INDEX BY BINARY_INTEGER;
335: TYPE t_ext_bank_account_type IS TABLE OF
336: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE
337: INDEX BY BINARY_INTEGER;
338: TYPE t_ext_bank_account_iban_number IS TABLE OF
339: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE
340: INDEX BY BINARY_INTEGER;
335: TYPE t_ext_bank_account_type IS TABLE OF
336: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE
337: INDEX BY BINARY_INTEGER;
338: TYPE t_ext_bank_account_iban_number IS TABLE OF
339: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE
340: INDEX BY BINARY_INTEGER;
341: TYPE t_payee_name IS TABLE OF
342: IBY_PAYMENTS_ALL.payee_name%TYPE
343: INDEX BY BINARY_INTEGER;
338: TYPE t_ext_bank_account_iban_number IS TABLE OF
339: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE
340: INDEX BY BINARY_INTEGER;
341: TYPE t_payee_name IS TABLE OF
342: IBY_PAYMENTS_ALL.payee_name%TYPE
343: INDEX BY BINARY_INTEGER;
344: TYPE t_payee_address1 IS TABLE OF
345: IBY_PAYMENTS_ALL.payee_address1%TYPE
346: INDEX BY BINARY_INTEGER;
341: TYPE t_payee_name IS TABLE OF
342: IBY_PAYMENTS_ALL.payee_name%TYPE
343: INDEX BY BINARY_INTEGER;
344: TYPE t_payee_address1 IS TABLE OF
345: IBY_PAYMENTS_ALL.payee_address1%TYPE
346: INDEX BY BINARY_INTEGER;
347: TYPE t_payee_address2 IS TABLE OF
348: IBY_PAYMENTS_ALL.payee_address2%TYPE
349: INDEX BY BINARY_INTEGER;
344: TYPE t_payee_address1 IS TABLE OF
345: IBY_PAYMENTS_ALL.payee_address1%TYPE
346: INDEX BY BINARY_INTEGER;
347: TYPE t_payee_address2 IS TABLE OF
348: IBY_PAYMENTS_ALL.payee_address2%TYPE
349: INDEX BY BINARY_INTEGER;
350: TYPE t_payee_address3 IS TABLE OF
351: IBY_PAYMENTS_ALL.payee_address3%TYPE
352: INDEX BY BINARY_INTEGER;
347: TYPE t_payee_address2 IS TABLE OF
348: IBY_PAYMENTS_ALL.payee_address2%TYPE
349: INDEX BY BINARY_INTEGER;
350: TYPE t_payee_address3 IS TABLE OF
351: IBY_PAYMENTS_ALL.payee_address3%TYPE
352: INDEX BY BINARY_INTEGER;
353: TYPE t_payee_address4 IS TABLE OF
354: IBY_PAYMENTS_ALL.payee_address4%TYPE
355: INDEX BY BINARY_INTEGER;
350: TYPE t_payee_address3 IS TABLE OF
351: IBY_PAYMENTS_ALL.payee_address3%TYPE
352: INDEX BY BINARY_INTEGER;
353: TYPE t_payee_address4 IS TABLE OF
354: IBY_PAYMENTS_ALL.payee_address4%TYPE
355: INDEX BY BINARY_INTEGER;
356: TYPE t_payee_city IS TABLE OF
357: IBY_PAYMENTS_ALL.payee_city%TYPE
358: INDEX BY BINARY_INTEGER;
353: TYPE t_payee_address4 IS TABLE OF
354: IBY_PAYMENTS_ALL.payee_address4%TYPE
355: INDEX BY BINARY_INTEGER;
356: TYPE t_payee_city IS TABLE OF
357: IBY_PAYMENTS_ALL.payee_city%TYPE
358: INDEX BY BINARY_INTEGER;
359: TYPE t_payee_postal_code IS TABLE OF
360: IBY_PAYMENTS_ALL.payee_postal_code%TYPE
361: INDEX BY BINARY_INTEGER;
356: TYPE t_payee_city IS TABLE OF
357: IBY_PAYMENTS_ALL.payee_city%TYPE
358: INDEX BY BINARY_INTEGER;
359: TYPE t_payee_postal_code IS TABLE OF
360: IBY_PAYMENTS_ALL.payee_postal_code%TYPE
361: INDEX BY BINARY_INTEGER;
362: TYPE t_payee_state IS TABLE OF
363: IBY_PAYMENTS_ALL.payee_state%TYPE
364: INDEX BY BINARY_INTEGER;
359: TYPE t_payee_postal_code IS TABLE OF
360: IBY_PAYMENTS_ALL.payee_postal_code%TYPE
361: INDEX BY BINARY_INTEGER;
362: TYPE t_payee_state IS TABLE OF
363: IBY_PAYMENTS_ALL.payee_state%TYPE
364: INDEX BY BINARY_INTEGER;
365: TYPE t_payee_province IS TABLE OF
366: IBY_PAYMENTS_ALL.payee_province%TYPE
367: INDEX BY BINARY_INTEGER;
362: TYPE t_payee_state IS TABLE OF
363: IBY_PAYMENTS_ALL.payee_state%TYPE
364: INDEX BY BINARY_INTEGER;
365: TYPE t_payee_province IS TABLE OF
366: IBY_PAYMENTS_ALL.payee_province%TYPE
367: INDEX BY BINARY_INTEGER;
368: TYPE t_payee_county IS TABLE OF
369: IBY_PAYMENTS_ALL.payee_county%TYPE
370: INDEX BY BINARY_INTEGER;
365: TYPE t_payee_province IS TABLE OF
366: IBY_PAYMENTS_ALL.payee_province%TYPE
367: INDEX BY BINARY_INTEGER;
368: TYPE t_payee_county IS TABLE OF
369: IBY_PAYMENTS_ALL.payee_county%TYPE
370: INDEX BY BINARY_INTEGER;
371: TYPE t_payee_country IS TABLE OF
372: IBY_PAYMENTS_ALL.payee_country%TYPE
373: INDEX BY BINARY_INTEGER;
368: TYPE t_payee_county IS TABLE OF
369: IBY_PAYMENTS_ALL.payee_county%TYPE
370: INDEX BY BINARY_INTEGER;
371: TYPE t_payee_country IS TABLE OF
372: IBY_PAYMENTS_ALL.payee_country%TYPE
373: INDEX BY BINARY_INTEGER;
374: TYPE t_remit_advice_delivery_method IS TABLE OF
375: IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE
376: INDEX BY BINARY_INTEGER;
371: TYPE t_payee_country IS TABLE OF
372: IBY_PAYMENTS_ALL.payee_country%TYPE
373: INDEX BY BINARY_INTEGER;
374: TYPE t_remit_advice_delivery_method IS TABLE OF
375: IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE
376: INDEX BY BINARY_INTEGER;
377: TYPE t_remit_advice_email IS TABLE OF
378: IBY_PAYMENTS_ALL.remit_advice_email%TYPE
379: INDEX BY BINARY_INTEGER;
374: TYPE t_remit_advice_delivery_method IS TABLE OF
375: IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE
376: INDEX BY BINARY_INTEGER;
377: TYPE t_remit_advice_email IS TABLE OF
378: IBY_PAYMENTS_ALL.remit_advice_email%TYPE
379: INDEX BY BINARY_INTEGER;
380: TYPE t_remit_advice_fax IS TABLE OF
381: IBY_PAYMENTS_ALL.remit_advice_fax%TYPE
382: INDEX BY BINARY_INTEGER;
377: TYPE t_remit_advice_email IS TABLE OF
378: IBY_PAYMENTS_ALL.remit_advice_email%TYPE
379: INDEX BY BINARY_INTEGER;
380: TYPE t_remit_advice_fax IS TABLE OF
381: IBY_PAYMENTS_ALL.remit_advice_fax%TYPE
382: INDEX BY BINARY_INTEGER;
383:
384: /*TPP-Start*/
385: TYPE t_ext_inv_payee_id IS TABLE OF
382: INDEX BY BINARY_INTEGER;
383:
384: /*TPP-Start*/
385: TYPE t_ext_inv_payee_id IS TABLE OF
386: IBY_PAYMENTS_ALL.ext_inv_payee_id%TYPE
387: INDEX BY BINARY_INTEGER;
388: TYPE t_inv_payee_party_id IS TABLE OF
389: IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE
390: INDEX BY BINARY_INTEGER;
385: TYPE t_ext_inv_payee_id IS TABLE OF
386: IBY_PAYMENTS_ALL.ext_inv_payee_id%TYPE
387: INDEX BY BINARY_INTEGER;
388: TYPE t_inv_payee_party_id IS TABLE OF
389: IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE
390: INDEX BY BINARY_INTEGER;
391: TYPE t_inv_party_site_id IS TABLE OF
392: IBY_PAYMENTS_ALL.inv_party_site_id%TYPE
393: INDEX BY BINARY_INTEGER;
388: TYPE t_inv_payee_party_id IS TABLE OF
389: IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE
390: INDEX BY BINARY_INTEGER;
391: TYPE t_inv_party_site_id IS TABLE OF
392: IBY_PAYMENTS_ALL.inv_party_site_id%TYPE
393: INDEX BY BINARY_INTEGER;
394: TYPE t_inv_supplier_site_id IS TABLE OF
395: IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE
396: INDEX BY BINARY_INTEGER;
391: TYPE t_inv_party_site_id IS TABLE OF
392: IBY_PAYMENTS_ALL.inv_party_site_id%TYPE
393: INDEX BY BINARY_INTEGER;
394: TYPE t_inv_supplier_site_id IS TABLE OF
395: IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE
396: INDEX BY BINARY_INTEGER;
397: TYPE t_inv_beneficiary_party IS TABLE OF
398: IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE
399: INDEX BY BINARY_INTEGER;
394: TYPE t_inv_supplier_site_id IS TABLE OF
395: IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE
396: INDEX BY BINARY_INTEGER;
397: TYPE t_inv_beneficiary_party IS TABLE OF
398: IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE
399: INDEX BY BINARY_INTEGER;
400: TYPE t_inv_payee_name IS TABLE OF
401: IBY_PAYMENTS_ALL.inv_payee_name%TYPE
402: INDEX BY BINARY_INTEGER;
397: TYPE t_inv_beneficiary_party IS TABLE OF
398: IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE
399: INDEX BY BINARY_INTEGER;
400: TYPE t_inv_payee_name IS TABLE OF
401: IBY_PAYMENTS_ALL.inv_payee_name%TYPE
402: INDEX BY BINARY_INTEGER;
403: TYPE t_inv_payee_address1 IS TABLE OF
404: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE
405: INDEX BY BINARY_INTEGER;
400: TYPE t_inv_payee_name IS TABLE OF
401: IBY_PAYMENTS_ALL.inv_payee_name%TYPE
402: INDEX BY BINARY_INTEGER;
403: TYPE t_inv_payee_address1 IS TABLE OF
404: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE
405: INDEX BY BINARY_INTEGER;
406: TYPE t_inv_payee_address2 IS TABLE OF
407: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE
408: INDEX BY BINARY_INTEGER;
403: TYPE t_inv_payee_address1 IS TABLE OF
404: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE
405: INDEX BY BINARY_INTEGER;
406: TYPE t_inv_payee_address2 IS TABLE OF
407: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE
408: INDEX BY BINARY_INTEGER;
409: TYPE t_inv_payee_address3 IS TABLE OF
410: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE
411: INDEX BY BINARY_INTEGER;
406: TYPE t_inv_payee_address2 IS TABLE OF
407: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE
408: INDEX BY BINARY_INTEGER;
409: TYPE t_inv_payee_address3 IS TABLE OF
410: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE
411: INDEX BY BINARY_INTEGER;
412: TYPE t_inv_payee_address4 IS TABLE OF
413: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE
414: INDEX BY BINARY_INTEGER;
409: TYPE t_inv_payee_address3 IS TABLE OF
410: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE
411: INDEX BY BINARY_INTEGER;
412: TYPE t_inv_payee_address4 IS TABLE OF
413: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE
414: INDEX BY BINARY_INTEGER;
415: TYPE t_inv_payee_city IS TABLE OF
416: IBY_PAYMENTS_ALL.inv_payee_city%TYPE
417: INDEX BY BINARY_INTEGER;
412: TYPE t_inv_payee_address4 IS TABLE OF
413: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE
414: INDEX BY BINARY_INTEGER;
415: TYPE t_inv_payee_city IS TABLE OF
416: IBY_PAYMENTS_ALL.inv_payee_city%TYPE
417: INDEX BY BINARY_INTEGER;
418: TYPE t_inv_payee_postal_code IS TABLE OF
419: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE
420: INDEX BY BINARY_INTEGER;
415: TYPE t_inv_payee_city IS TABLE OF
416: IBY_PAYMENTS_ALL.inv_payee_city%TYPE
417: INDEX BY BINARY_INTEGER;
418: TYPE t_inv_payee_postal_code IS TABLE OF
419: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE
420: INDEX BY BINARY_INTEGER;
421: TYPE t_inv_payee_state IS TABLE OF
422: IBY_PAYMENTS_ALL.inv_payee_state%TYPE
423: INDEX BY BINARY_INTEGER;
418: TYPE t_inv_payee_postal_code IS TABLE OF
419: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE
420: INDEX BY BINARY_INTEGER;
421: TYPE t_inv_payee_state IS TABLE OF
422: IBY_PAYMENTS_ALL.inv_payee_state%TYPE
423: INDEX BY BINARY_INTEGER;
424: TYPE t_inv_payee_province IS TABLE OF
425: IBY_PAYMENTS_ALL.inv_payee_province%TYPE
426: INDEX BY BINARY_INTEGER;
421: TYPE t_inv_payee_state IS TABLE OF
422: IBY_PAYMENTS_ALL.inv_payee_state%TYPE
423: INDEX BY BINARY_INTEGER;
424: TYPE t_inv_payee_province IS TABLE OF
425: IBY_PAYMENTS_ALL.inv_payee_province%TYPE
426: INDEX BY BINARY_INTEGER;
427: TYPE t_inv_payee_county IS TABLE OF
428: IBY_PAYMENTS_ALL.inv_payee_county%TYPE
429: INDEX BY BINARY_INTEGER;
424: TYPE t_inv_payee_province IS TABLE OF
425: IBY_PAYMENTS_ALL.inv_payee_province%TYPE
426: INDEX BY BINARY_INTEGER;
427: TYPE t_inv_payee_county IS TABLE OF
428: IBY_PAYMENTS_ALL.inv_payee_county%TYPE
429: INDEX BY BINARY_INTEGER;
430: TYPE t_inv_payee_country IS TABLE OF
431: IBY_PAYMENTS_ALL.inv_payee_country%TYPE
432: INDEX BY BINARY_INTEGER;
427: TYPE t_inv_payee_county IS TABLE OF
428: IBY_PAYMENTS_ALL.inv_payee_county%TYPE
429: INDEX BY BINARY_INTEGER;
430: TYPE t_inv_payee_country IS TABLE OF
431: IBY_PAYMENTS_ALL.inv_payee_country%TYPE
432: INDEX BY BINARY_INTEGER;
433: TYPE t_inv_payee_party_name IS TABLE OF
434: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE
435: INDEX BY BINARY_INTEGER;
430: TYPE t_inv_payee_country IS TABLE OF
431: IBY_PAYMENTS_ALL.inv_payee_country%TYPE
432: INDEX BY BINARY_INTEGER;
433: TYPE t_inv_payee_party_name IS TABLE OF
434: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE
435: INDEX BY BINARY_INTEGER;
436: TYPE t_inv_payee_le_reg_num IS TABLE OF
437: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE
438: INDEX BY BINARY_INTEGER;
433: TYPE t_inv_payee_party_name IS TABLE OF
434: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE
435: INDEX BY BINARY_INTEGER;
436: TYPE t_inv_payee_le_reg_num IS TABLE OF
437: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE
438: INDEX BY BINARY_INTEGER;
439: TYPE t_inv_payee_tax_reg_num IS TABLE OF
440: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE
441: INDEX BY BINARY_INTEGER;
436: TYPE t_inv_payee_le_reg_num IS TABLE OF
437: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE
438: INDEX BY BINARY_INTEGER;
439: TYPE t_inv_payee_tax_reg_num IS TABLE OF
440: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE
441: INDEX BY BINARY_INTEGER;
442: TYPE t_inv_payee_address_concat IS TABLE OF
443: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
444: INDEX BY BINARY_INTEGER;
439: TYPE t_inv_payee_tax_reg_num IS TABLE OF
440: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE
441: INDEX BY BINARY_INTEGER;
442: TYPE t_inv_payee_address_concat IS TABLE OF
443: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
444: INDEX BY BINARY_INTEGER;
445: TYPE t_inv_beneficiary_name IS TABLE OF
446: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE
447: INDEX BY BINARY_INTEGER;
442: TYPE t_inv_payee_address_concat IS TABLE OF
443: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
444: INDEX BY BINARY_INTEGER;
445: TYPE t_inv_beneficiary_name IS TABLE OF
446: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE
447: INDEX BY BINARY_INTEGER;
448: TYPE t_inv_payee_party_number IS TABLE OF
449: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE
450: INDEX BY BINARY_INTEGER;
445: TYPE t_inv_beneficiary_name IS TABLE OF
446: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE
447: INDEX BY BINARY_INTEGER;
448: TYPE t_inv_payee_party_number IS TABLE OF
449: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE
450: INDEX BY BINARY_INTEGER;
451: TYPE t_inv_payee_alternate_name IS TABLE OF
452: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE
453: INDEX BY BINARY_INTEGER;
448: TYPE t_inv_payee_party_number IS TABLE OF
449: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE
450: INDEX BY BINARY_INTEGER;
451: TYPE t_inv_payee_alternate_name IS TABLE OF
452: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE
453: INDEX BY BINARY_INTEGER;
454: TYPE t_inv_payee_site_alt_name IS TABLE OF
455: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE
456: INDEX BY BINARY_INTEGER;
451: TYPE t_inv_payee_alternate_name IS TABLE OF
452: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE
453: INDEX BY BINARY_INTEGER;
454: TYPE t_inv_payee_site_alt_name IS TABLE OF
455: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE
456: INDEX BY BINARY_INTEGER;
457: TYPE t_inv_payee_supplier_number IS TABLE OF
458: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE
459: INDEX BY BINARY_INTEGER;
454: TYPE t_inv_payee_site_alt_name IS TABLE OF
455: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE
456: INDEX BY BINARY_INTEGER;
457: TYPE t_inv_payee_supplier_number IS TABLE OF
458: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE
459: INDEX BY BINARY_INTEGER;
460: TYPE t_inv_payee_first_party_ref IS TABLE OF
461: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE
462: INDEX BY BINARY_INTEGER;
457: TYPE t_inv_payee_supplier_number IS TABLE OF
458: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE
459: INDEX BY BINARY_INTEGER;
460: TYPE t_inv_payee_first_party_ref IS TABLE OF
461: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE
462: INDEX BY BINARY_INTEGER;
463: TYPE t_ext_acct_ownr_inv_prty_id IS TABLE OF
464: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE
465: INDEX BY BINARY_INTEGER;
460: TYPE t_inv_payee_first_party_ref IS TABLE OF
461: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE
462: INDEX BY BINARY_INTEGER;
463: TYPE t_ext_acct_ownr_inv_prty_id IS TABLE OF
464: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE
465: INDEX BY BINARY_INTEGER;
466: TYPE t_ext_bnk_branch_inv_prty_id IS TABLE OF
467: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE
468: INDEX BY BINARY_INTEGER;
463: TYPE t_ext_acct_ownr_inv_prty_id IS TABLE OF
464: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE
465: INDEX BY BINARY_INTEGER;
466: TYPE t_ext_bnk_branch_inv_prty_id IS TABLE OF
467: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE
468: INDEX BY BINARY_INTEGER;
469: TYPE t_ext_acct_ownr_inv_prty_nme IS TABLE OF
470: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE
471: INDEX BY BINARY_INTEGER;
466: TYPE t_ext_bnk_branch_inv_prty_id IS TABLE OF
467: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE
468: INDEX BY BINARY_INTEGER;
469: TYPE t_ext_acct_ownr_inv_prty_nme IS TABLE OF
470: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE
471: INDEX BY BINARY_INTEGER;
472: TYPE t_inv_payee_party_attr_cat IS TABLE OF
473: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE
474: INDEX BY BINARY_INTEGER;
469: TYPE t_ext_acct_ownr_inv_prty_nme IS TABLE OF
470: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE
471: INDEX BY BINARY_INTEGER;
472: TYPE t_inv_payee_party_attr_cat IS TABLE OF
473: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE
474: INDEX BY BINARY_INTEGER;
475: TYPE t_inv_payee_supplier_attr_cat IS TABLE OF
476: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE
477: INDEX BY BINARY_INTEGER;
472: TYPE t_inv_payee_party_attr_cat IS TABLE OF
473: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE
474: INDEX BY BINARY_INTEGER;
475: TYPE t_inv_payee_supplier_attr_cat IS TABLE OF
476: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE
477: INDEX BY BINARY_INTEGER;
478: TYPE t_inv_payee_site_attr_cat IS TABLE OF
479: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE
480: INDEX BY BINARY_INTEGER;
475: TYPE t_inv_payee_supplier_attr_cat IS TABLE OF
476: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE
477: INDEX BY BINARY_INTEGER;
478: TYPE t_inv_payee_site_attr_cat IS TABLE OF
479: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE
480: INDEX BY BINARY_INTEGER;
481: TYPE t_inv_payee_supplier_site_name IS TABLE OF
482: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE
483: INDEX BY BINARY_INTEGER;
478: TYPE t_inv_payee_site_attr_cat IS TABLE OF
479: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE
480: INDEX BY BINARY_INTEGER;
481: TYPE t_inv_payee_supplier_site_name IS TABLE OF
482: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE
483: INDEX BY BINARY_INTEGER;
484: TYPE t_inv_payee_spp_site_alt_name IS TABLE OF
485: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE
486: INDEX BY BINARY_INTEGER;
481: TYPE t_inv_payee_supplier_site_name IS TABLE OF
482: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE
483: INDEX BY BINARY_INTEGER;
484: TYPE t_inv_payee_spp_site_alt_name IS TABLE OF
485: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE
486: INDEX BY BINARY_INTEGER;
487: TYPE t_inv_payee_supplier_id IS TABLE OF
488: IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
489: INDEX BY BINARY_INTEGER;
484: TYPE t_inv_payee_spp_site_alt_name IS TABLE OF
485: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE
486: INDEX BY BINARY_INTEGER;
487: TYPE t_inv_payee_supplier_id IS TABLE OF
488: IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
489: INDEX BY BINARY_INTEGER;
490: /*TPP-End*/
491:
492: /*
495: * Ensure that employee related fields are populated in the
496: * payment record.
497: */
498: TYPE t_address_source IS TABLE OF
499: IBY_PAYMENTS_ALL.address_source%TYPE
500: INDEX BY BINARY_INTEGER;
501:
502: TYPE t_employee_address_code IS TABLE OF
503: IBY_PAYMENTS_ALL.employee_address_code%TYPE
499: IBY_PAYMENTS_ALL.address_source%TYPE
500: INDEX BY BINARY_INTEGER;
501:
502: TYPE t_employee_address_code IS TABLE OF
503: IBY_PAYMENTS_ALL.employee_address_code%TYPE
504: INDEX BY BINARY_INTEGER;
505:
506: TYPE t_employee_person_id IS TABLE OF
507: IBY_PAYMENTS_ALL.employee_person_id%TYPE
503: IBY_PAYMENTS_ALL.employee_address_code%TYPE
504: INDEX BY BINARY_INTEGER;
505:
506: TYPE t_employee_person_id IS TABLE OF
507: IBY_PAYMENTS_ALL.employee_person_id%TYPE
508: INDEX BY BINARY_INTEGER;
509:
510: TYPE t_employee_address_id IS TABLE OF
511: IBY_PAYMENTS_ALL.employee_address_id%TYPE
507: IBY_PAYMENTS_ALL.employee_person_id%TYPE
508: INDEX BY BINARY_INTEGER;
509:
510: TYPE t_employee_address_id IS TABLE OF
511: IBY_PAYMENTS_ALL.employee_address_id%TYPE
512: INDEX BY BINARY_INTEGER;
513:
514: TYPE t_employee_payment_flag IS TABLE OF
515: IBY_PAYMENTS_ALL.employee_payment_flag%TYPE
511: IBY_PAYMENTS_ALL.employee_address_id%TYPE
512: INDEX BY BINARY_INTEGER;
513:
514: TYPE t_employee_payment_flag IS TABLE OF
515: IBY_PAYMENTS_ALL.employee_payment_flag%TYPE
516: INDEX BY BINARY_INTEGER;
517:
518: TYPE t_calling_app_id IS TABLE OF
519: IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE
754: INDEX BY BINARY_INTEGER;
755:
756: --
757: -- This record needs to be created because of the fact that
758: -- there is no document id column in IBY_PAYMENTS_ALL table. So
759: -- we cannot add the document id as a field in the paymentRecType
760: -- record (adding this field to the record will cause a syntax
761: -- error during the bulk update).
762: --
772: -- to these documents.
773: --
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,
853: -- particular payment.
854: --
855: TYPE successDocsCountPerPmtRec IS RECORD (
856: payment_id
857: IBY_PAYMENTS_ALL.payment_id%TYPE,
858: success_docs_count
859: NUMBER(15)
860: );
861:
1146:
1147: --
1148: -- Table of payment ids.
1149: --
1150: TYPE pmtIdsTab IS TABLE OF IBY_PAYMENTS_ALL.payment_id%TYPE
1151: INDEX BY BINARY_INTEGER;
1152:
1153: --
1154: -- Internal bank account with its corresponding legal entity id.
1154: -- Internal bank account with its corresponding legal entity id.
1155: --
1156: TYPE bankAccountLERecType IS RECORD (
1157: int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE,
1158: le_id IBY_PAYMENTS_ALL.legal_entity_id%TYPE
1159: );
1160:
1161: --
1162: -- Table of internal bank accounts each with its legal entity.
1166:
1167: --
1168: -- Stores the denormalized data related to the payer, payee,
1169: -- payer bank and payee bank. This data is stamped onto
1170: -- the payment in IBY_PAYMENTS_ALL table for audit purposes.
1171: --
1172: TYPE paymentAuditRecType IS RECORD (
1173:
1174: payment_id -- 01
1171: --
1172: TYPE paymentAuditRecType IS RECORD (
1173:
1174: payment_id -- 01
1175: IBY_PAYMENTS_ALL.payment_id%TYPE,
1176:
1177: /* PAYER RELATED */
1178: payer_party_number
1179: IBY_PAYMENTS_ALL.payer_party_number%TYPE,
1175: IBY_PAYMENTS_ALL.payment_id%TYPE,
1176:
1177: /* PAYER RELATED */
1178: payer_party_number
1179: IBY_PAYMENTS_ALL.payer_party_number%TYPE,
1180: payer_party_site_name
1181: IBY_PAYMENTS_ALL.payer_party_site_name%TYPE,
1182: payer_legal_name
1183: IBY_PAYMENTS_ALL.payer_legal_entity_name%TYPE,
1177: /* PAYER RELATED */
1178: payer_party_number
1179: IBY_PAYMENTS_ALL.payer_party_number%TYPE,
1180: payer_party_site_name
1181: IBY_PAYMENTS_ALL.payer_party_site_name%TYPE,
1182: payer_legal_name
1183: IBY_PAYMENTS_ALL.payer_legal_entity_name%TYPE,
1184: payer_tax_reg_number
1185: IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE,
1179: IBY_PAYMENTS_ALL.payer_party_number%TYPE,
1180: payer_party_site_name
1181: IBY_PAYMENTS_ALL.payer_party_site_name%TYPE,
1182: payer_legal_name
1183: IBY_PAYMENTS_ALL.payer_legal_entity_name%TYPE,
1184: payer_tax_reg_number
1185: IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE,
1186: payer_le_reg_number
1187: IBY_PAYMENTS_ALL.payer_le_registration_num%TYPE,
1181: IBY_PAYMENTS_ALL.payer_party_site_name%TYPE,
1182: payer_legal_name
1183: IBY_PAYMENTS_ALL.payer_legal_entity_name%TYPE,
1184: payer_tax_reg_number
1185: IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE,
1186: payer_le_reg_number
1187: IBY_PAYMENTS_ALL.payer_le_registration_num%TYPE,
1188: payer_party_id
1189: IBY_PAYMENTS_ALL.payer_party_id%TYPE,
1183: IBY_PAYMENTS_ALL.payer_legal_entity_name%TYPE,
1184: payer_tax_reg_number
1185: IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE,
1186: payer_le_reg_number
1187: IBY_PAYMENTS_ALL.payer_le_registration_num%TYPE,
1188: payer_party_id
1189: IBY_PAYMENTS_ALL.payer_party_id%TYPE,
1190: payer_location_id
1191: IBY_PAYMENTS_ALL.payer_location_id%TYPE,
1185: IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE,
1186: payer_le_reg_number
1187: IBY_PAYMENTS_ALL.payer_le_registration_num%TYPE,
1188: payer_party_id
1189: IBY_PAYMENTS_ALL.payer_party_id%TYPE,
1190: payer_location_id
1191: IBY_PAYMENTS_ALL.payer_location_id%TYPE,
1192: payer_party_attr_cat
1193: IBY_PAYMENTS_ALL.payer_party_attr_category%TYPE,
1187: IBY_PAYMENTS_ALL.payer_le_registration_num%TYPE,
1188: payer_party_id
1189: IBY_PAYMENTS_ALL.payer_party_id%TYPE,
1190: payer_location_id
1191: IBY_PAYMENTS_ALL.payer_location_id%TYPE,
1192: payer_party_attr_cat
1193: IBY_PAYMENTS_ALL.payer_party_attr_category%TYPE,
1194: payer_le_attr_cat -- 10
1195: IBY_PAYMENTS_ALL.payer_le_attr_category%TYPE,
1189: IBY_PAYMENTS_ALL.payer_party_id%TYPE,
1190: payer_location_id
1191: IBY_PAYMENTS_ALL.payer_location_id%TYPE,
1192: payer_party_attr_cat
1193: IBY_PAYMENTS_ALL.payer_party_attr_category%TYPE,
1194: payer_le_attr_cat -- 10
1195: IBY_PAYMENTS_ALL.payer_le_attr_category%TYPE,
1196:
1197: /* PAYER SPECIAL FIELDS */
1191: IBY_PAYMENTS_ALL.payer_location_id%TYPE,
1192: payer_party_attr_cat
1193: IBY_PAYMENTS_ALL.payer_party_attr_category%TYPE,
1194: payer_le_attr_cat -- 10
1195: IBY_PAYMENTS_ALL.payer_le_attr_category%TYPE,
1196:
1197: /* PAYER SPECIAL FIELDS */
1198: payer_abbrev_agency_code
1199: IBY_PAYMENTS_ALL.payer_abbreviated_agency_code%TYPE,
1195: IBY_PAYMENTS_ALL.payer_le_attr_category%TYPE,
1196:
1197: /* PAYER SPECIAL FIELDS */
1198: payer_abbrev_agency_code
1199: IBY_PAYMENTS_ALL.payer_abbreviated_agency_code%TYPE,
1200: payer_us_employer_id
1201: IBY_PAYMENTS_ALL.payer_federal_us_employer_id%TYPE,
1202:
1203: /* PAYER BANK RELATED */
1197: /* PAYER SPECIAL FIELDS */
1198: payer_abbrev_agency_code
1199: IBY_PAYMENTS_ALL.payer_abbreviated_agency_code%TYPE,
1200: payer_us_employer_id
1201: IBY_PAYMENTS_ALL.payer_federal_us_employer_id%TYPE,
1202:
1203: /* PAYER BANK RELATED */
1204: payer_bank_name
1205: IBY_PAYMENTS_ALL.int_bank_name%TYPE,
1201: IBY_PAYMENTS_ALL.payer_federal_us_employer_id%TYPE,
1202:
1203: /* PAYER BANK RELATED */
1204: payer_bank_name
1205: IBY_PAYMENTS_ALL.int_bank_name%TYPE,
1206: payer_bank_number
1207: IBY_PAYMENTS_ALL.int_bank_number%TYPE,
1208: payer_bank_branch_number
1209: IBY_PAYMENTS_ALL.int_bank_branch_number%TYPE,
1203: /* PAYER BANK RELATED */
1204: payer_bank_name
1205: IBY_PAYMENTS_ALL.int_bank_name%TYPE,
1206: payer_bank_number
1207: IBY_PAYMENTS_ALL.int_bank_number%TYPE,
1208: payer_bank_branch_number
1209: IBY_PAYMENTS_ALL.int_bank_branch_number%TYPE,
1210: payer_bank_branch_name
1211: IBY_PAYMENTS_ALL.int_bank_branch_name%TYPE,
1205: IBY_PAYMENTS_ALL.int_bank_name%TYPE,
1206: payer_bank_number
1207: IBY_PAYMENTS_ALL.int_bank_number%TYPE,
1208: payer_bank_branch_number
1209: IBY_PAYMENTS_ALL.int_bank_branch_number%TYPE,
1210: payer_bank_branch_name
1211: IBY_PAYMENTS_ALL.int_bank_branch_name%TYPE,
1212: payer_bank_swift_code
1213: IBY_PAYMENTS_ALL.int_eft_swift_code%TYPE,
1207: IBY_PAYMENTS_ALL.int_bank_number%TYPE,
1208: payer_bank_branch_number
1209: IBY_PAYMENTS_ALL.int_bank_branch_number%TYPE,
1210: payer_bank_branch_name
1211: IBY_PAYMENTS_ALL.int_bank_branch_name%TYPE,
1212: payer_bank_swift_code
1213: IBY_PAYMENTS_ALL.int_eft_swift_code%TYPE,
1214: payer_bank_acct_num
1215: IBY_PAYMENTS_ALL.int_bank_account_number%TYPE,
1209: IBY_PAYMENTS_ALL.int_bank_branch_number%TYPE,
1210: payer_bank_branch_name
1211: IBY_PAYMENTS_ALL.int_bank_branch_name%TYPE,
1212: payer_bank_swift_code
1213: IBY_PAYMENTS_ALL.int_eft_swift_code%TYPE,
1214: payer_bank_acct_num
1215: IBY_PAYMENTS_ALL.int_bank_account_number%TYPE,
1216: payer_bank_acct_name
1217: IBY_PAYMENTS_ALL.int_bank_account_name%TYPE,
1211: IBY_PAYMENTS_ALL.int_bank_branch_name%TYPE,
1212: payer_bank_swift_code
1213: IBY_PAYMENTS_ALL.int_eft_swift_code%TYPE,
1214: payer_bank_acct_num
1215: IBY_PAYMENTS_ALL.int_bank_account_number%TYPE,
1216: payer_bank_acct_name
1217: IBY_PAYMENTS_ALL.int_bank_account_name%TYPE,
1218: payer_bank_acct_iban -- 20
1219: IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE,
1213: IBY_PAYMENTS_ALL.int_eft_swift_code%TYPE,
1214: payer_bank_acct_num
1215: IBY_PAYMENTS_ALL.int_bank_account_number%TYPE,
1216: payer_bank_acct_name
1217: IBY_PAYMENTS_ALL.int_bank_account_name%TYPE,
1218: payer_bank_acct_iban -- 20
1219: IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE,
1220: payer_bank_agency_loc_code
1221: IBY_PAYMENTS_ALL.int_bank_acct_agency_loc_code%TYPE,
1215: IBY_PAYMENTS_ALL.int_bank_account_number%TYPE,
1216: payer_bank_acct_name
1217: IBY_PAYMENTS_ALL.int_bank_account_name%TYPE,
1218: payer_bank_acct_iban -- 20
1219: IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE,
1220: payer_bank_agency_loc_code
1221: IBY_PAYMENTS_ALL.int_bank_acct_agency_loc_code%TYPE,
1222: payer_bank_branch_party_id
1223: IBY_PAYMENTS_ALL.int_bank_branch_party_id%TYPE,
1217: IBY_PAYMENTS_ALL.int_bank_account_name%TYPE,
1218: payer_bank_acct_iban -- 20
1219: IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE,
1220: payer_bank_agency_loc_code
1221: IBY_PAYMENTS_ALL.int_bank_acct_agency_loc_code%TYPE,
1222: payer_bank_branch_party_id
1223: IBY_PAYMENTS_ALL.int_bank_branch_party_id%TYPE,
1224: payer_bank_alt_name
1225: IBY_PAYMENTS_ALL.int_bank_alt_name%TYPE,
1219: IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE,
1220: payer_bank_agency_loc_code
1221: IBY_PAYMENTS_ALL.int_bank_acct_agency_loc_code%TYPE,
1222: payer_bank_branch_party_id
1223: IBY_PAYMENTS_ALL.int_bank_branch_party_id%TYPE,
1224: payer_bank_alt_name
1225: IBY_PAYMENTS_ALL.int_bank_alt_name%TYPE,
1226: payer_bank_branch_alt_name
1227: IBY_PAYMENTS_ALL.int_bank_branch_alt_name%TYPE,
1221: IBY_PAYMENTS_ALL.int_bank_acct_agency_loc_code%TYPE,
1222: payer_bank_branch_party_id
1223: IBY_PAYMENTS_ALL.int_bank_branch_party_id%TYPE,
1224: payer_bank_alt_name
1225: IBY_PAYMENTS_ALL.int_bank_alt_name%TYPE,
1226: payer_bank_branch_alt_name
1227: IBY_PAYMENTS_ALL.int_bank_branch_alt_name%TYPE,
1228: payer_bank_alt_account_name
1229: IBY_PAYMENTS_ALL.int_bank_account_alt_name%TYPE,
1223: IBY_PAYMENTS_ALL.int_bank_branch_party_id%TYPE,
1224: payer_bank_alt_name
1225: IBY_PAYMENTS_ALL.int_bank_alt_name%TYPE,
1226: payer_bank_branch_alt_name
1227: IBY_PAYMENTS_ALL.int_bank_branch_alt_name%TYPE,
1228: payer_bank_alt_account_name
1229: IBY_PAYMENTS_ALL.int_bank_account_alt_name%TYPE,
1230: payer_bank_account_num_elec
1231: IBY_PAYMENTS_ALL.int_bank_account_num_elec%TYPE,
1225: IBY_PAYMENTS_ALL.int_bank_alt_name%TYPE,
1226: payer_bank_branch_alt_name
1227: IBY_PAYMENTS_ALL.int_bank_branch_alt_name%TYPE,
1228: payer_bank_alt_account_name
1229: IBY_PAYMENTS_ALL.int_bank_account_alt_name%TYPE,
1230: payer_bank_account_num_elec
1231: IBY_PAYMENTS_ALL.int_bank_account_num_elec%TYPE,
1232: payer_bank_branch_location_id
1233: IBY_PAYMENTS_ALL.int_bank_branch_location_id%TYPE,
1227: IBY_PAYMENTS_ALL.int_bank_branch_alt_name%TYPE,
1228: payer_bank_alt_account_name
1229: IBY_PAYMENTS_ALL.int_bank_account_alt_name%TYPE,
1230: payer_bank_account_num_elec
1231: IBY_PAYMENTS_ALL.int_bank_account_num_elec%TYPE,
1232: payer_bank_branch_location_id
1233: IBY_PAYMENTS_ALL.int_bank_branch_location_id%TYPE,
1234: payer_bank_branch_eft_user_num
1235: IBY_PAYMENTS_ALL.int_bank_branch_eft_user_num%TYPE,
1229: IBY_PAYMENTS_ALL.int_bank_account_alt_name%TYPE,
1230: payer_bank_account_num_elec
1231: IBY_PAYMENTS_ALL.int_bank_account_num_elec%TYPE,
1232: payer_bank_branch_location_id
1233: IBY_PAYMENTS_ALL.int_bank_branch_location_id%TYPE,
1234: payer_bank_branch_eft_user_num
1235: IBY_PAYMENTS_ALL.int_bank_branch_eft_user_num%TYPE,
1236:
1237:
1231: IBY_PAYMENTS_ALL.int_bank_account_num_elec%TYPE,
1232: payer_bank_branch_location_id
1233: IBY_PAYMENTS_ALL.int_bank_branch_location_id%TYPE,
1234: payer_bank_branch_eft_user_num
1235: IBY_PAYMENTS_ALL.int_bank_branch_eft_user_num%TYPE,
1236:
1237:
1238: /* PAYEE RELATED */
1239: payee_party_number
1236:
1237:
1238: /* PAYEE RELATED */
1239: payee_party_number
1240: IBY_PAYMENTS_ALL.payee_party_number%TYPE,
1241: payee_party_name -- 30
1242: IBY_PAYMENTS_ALL.payee_party_name%TYPE,
1243: payee_name
1244: IBY_PAYMENTS_ALL.payee_name%TYPE,
1238: /* PAYEE RELATED */
1239: payee_party_number
1240: IBY_PAYMENTS_ALL.payee_party_number%TYPE,
1241: payee_party_name -- 30
1242: IBY_PAYMENTS_ALL.payee_party_name%TYPE,
1243: payee_name
1244: IBY_PAYMENTS_ALL.payee_name%TYPE,
1245: payee_name_alternate
1246: IBY_PAYMENTS_ALL.payee_alternate_name%TYPE,
1240: IBY_PAYMENTS_ALL.payee_party_number%TYPE,
1241: payee_party_name -- 30
1242: IBY_PAYMENTS_ALL.payee_party_name%TYPE,
1243: payee_name
1244: IBY_PAYMENTS_ALL.payee_name%TYPE,
1245: payee_name_alternate
1246: IBY_PAYMENTS_ALL.payee_alternate_name%TYPE,
1247: payee_add_line_1
1248: IBY_PAYMENTS_ALL.payee_address1%TYPE,
1242: IBY_PAYMENTS_ALL.payee_party_name%TYPE,
1243: payee_name
1244: IBY_PAYMENTS_ALL.payee_name%TYPE,
1245: payee_name_alternate
1246: IBY_PAYMENTS_ALL.payee_alternate_name%TYPE,
1247: payee_add_line_1
1248: IBY_PAYMENTS_ALL.payee_address1%TYPE,
1249: payee_add_line_2
1250: IBY_PAYMENTS_ALL.payee_address2%TYPE,
1244: IBY_PAYMENTS_ALL.payee_name%TYPE,
1245: payee_name_alternate
1246: IBY_PAYMENTS_ALL.payee_alternate_name%TYPE,
1247: payee_add_line_1
1248: IBY_PAYMENTS_ALL.payee_address1%TYPE,
1249: payee_add_line_2
1250: IBY_PAYMENTS_ALL.payee_address2%TYPE,
1251: payee_add_line_3
1252: IBY_PAYMENTS_ALL.payee_address3%TYPE,
1246: IBY_PAYMENTS_ALL.payee_alternate_name%TYPE,
1247: payee_add_line_1
1248: IBY_PAYMENTS_ALL.payee_address1%TYPE,
1249: payee_add_line_2
1250: IBY_PAYMENTS_ALL.payee_address2%TYPE,
1251: payee_add_line_3
1252: IBY_PAYMENTS_ALL.payee_address3%TYPE,
1253: payee_add_line_4
1254: IBY_PAYMENTS_ALL.payee_address4%TYPE,
1248: IBY_PAYMENTS_ALL.payee_address1%TYPE,
1249: payee_add_line_2
1250: IBY_PAYMENTS_ALL.payee_address2%TYPE,
1251: payee_add_line_3
1252: IBY_PAYMENTS_ALL.payee_address3%TYPE,
1253: payee_add_line_4
1254: IBY_PAYMENTS_ALL.payee_address4%TYPE,
1255: payee_city
1256: IBY_PAYMENTS_ALL.payee_city%TYPE,
1250: IBY_PAYMENTS_ALL.payee_address2%TYPE,
1251: payee_add_line_3
1252: IBY_PAYMENTS_ALL.payee_address3%TYPE,
1253: payee_add_line_4
1254: IBY_PAYMENTS_ALL.payee_address4%TYPE,
1255: payee_city
1256: IBY_PAYMENTS_ALL.payee_city%TYPE,
1257: payee_county
1258: IBY_PAYMENTS_ALL.payee_county%TYPE,
1252: IBY_PAYMENTS_ALL.payee_address3%TYPE,
1253: payee_add_line_4
1254: IBY_PAYMENTS_ALL.payee_address4%TYPE,
1255: payee_city
1256: IBY_PAYMENTS_ALL.payee_city%TYPE,
1257: payee_county
1258: IBY_PAYMENTS_ALL.payee_county%TYPE,
1259: payee_province
1260: IBY_PAYMENTS_ALL.payee_province%TYPE,
1254: IBY_PAYMENTS_ALL.payee_address4%TYPE,
1255: payee_city
1256: IBY_PAYMENTS_ALL.payee_city%TYPE,
1257: payee_county
1258: IBY_PAYMENTS_ALL.payee_county%TYPE,
1259: payee_province
1260: IBY_PAYMENTS_ALL.payee_province%TYPE,
1261: payee_state -- 40
1262: IBY_PAYMENTS_ALL.payee_state%TYPE,
1256: IBY_PAYMENTS_ALL.payee_city%TYPE,
1257: payee_county
1258: IBY_PAYMENTS_ALL.payee_county%TYPE,
1259: payee_province
1260: IBY_PAYMENTS_ALL.payee_province%TYPE,
1261: payee_state -- 40
1262: IBY_PAYMENTS_ALL.payee_state%TYPE,
1263: payee_country
1264: IBY_PAYMENTS_ALL.payee_country%TYPE,
1258: IBY_PAYMENTS_ALL.payee_county%TYPE,
1259: payee_province
1260: IBY_PAYMENTS_ALL.payee_province%TYPE,
1261: payee_state -- 40
1262: IBY_PAYMENTS_ALL.payee_state%TYPE,
1263: payee_country
1264: IBY_PAYMENTS_ALL.payee_country%TYPE,
1265: payee_postal_code
1266: IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
1260: IBY_PAYMENTS_ALL.payee_province%TYPE,
1261: payee_state -- 40
1262: IBY_PAYMENTS_ALL.payee_state%TYPE,
1263: payee_country
1264: IBY_PAYMENTS_ALL.payee_country%TYPE,
1265: payee_postal_code
1266: IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
1267: payee_address_concat
1268: IBY_PAYMENTS_ALL.payee_address_concat%TYPE,
1262: IBY_PAYMENTS_ALL.payee_state%TYPE,
1263: payee_country
1264: IBY_PAYMENTS_ALL.payee_country%TYPE,
1265: payee_postal_code
1266: IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
1267: payee_address_concat
1268: IBY_PAYMENTS_ALL.payee_address_concat%TYPE,
1269: beneficiary_name
1270: IBY_PAYMENTS_ALL.beneficiary_name%TYPE,
1264: IBY_PAYMENTS_ALL.payee_country%TYPE,
1265: payee_postal_code
1266: IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
1267: payee_address_concat
1268: IBY_PAYMENTS_ALL.payee_address_concat%TYPE,
1269: beneficiary_name
1270: IBY_PAYMENTS_ALL.beneficiary_name%TYPE,
1271: payee_party_attr_cat
1272: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
1266: IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
1267: payee_address_concat
1268: IBY_PAYMENTS_ALL.payee_address_concat%TYPE,
1269: beneficiary_name
1270: IBY_PAYMENTS_ALL.beneficiary_name%TYPE,
1271: payee_party_attr_cat
1272: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
1273: payee_supplier_site_attr_cat
1274: IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
1268: IBY_PAYMENTS_ALL.payee_address_concat%TYPE,
1269: beneficiary_name
1270: IBY_PAYMENTS_ALL.beneficiary_name%TYPE,
1271: payee_party_attr_cat
1272: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
1273: payee_supplier_site_attr_cat
1274: IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
1275: payee_supplier_site_name
1276: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
1270: IBY_PAYMENTS_ALL.beneficiary_name%TYPE,
1271: payee_party_attr_cat
1272: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
1273: payee_supplier_site_attr_cat
1274: IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
1275: payee_supplier_site_name
1276: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
1277:
1278: /* VENDOR RELATED */
1272: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
1273: payee_supplier_site_attr_cat
1274: IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
1275: payee_supplier_site_name
1276: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
1277:
1278: /* VENDOR RELATED */
1279: payee_site_name_alternate
1280: IBY_PAYMENTS_ALL.payee_site_alternate_name%TYPE,
1276: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
1277:
1278: /* VENDOR RELATED */
1279: payee_site_name_alternate
1280: IBY_PAYMENTS_ALL.payee_site_alternate_name%TYPE,
1281: payee_supplier_number
1282: IBY_PAYMENTS_ALL.payee_supplier_number%TYPE,
1283: payee_first_party_ref -- 50
1284: IBY_PAYMENTS_ALL.payee_first_party_reference%TYPE,
1278: /* VENDOR RELATED */
1279: payee_site_name_alternate
1280: IBY_PAYMENTS_ALL.payee_site_alternate_name%TYPE,
1281: payee_supplier_number
1282: IBY_PAYMENTS_ALL.payee_supplier_number%TYPE,
1283: payee_first_party_ref -- 50
1284: IBY_PAYMENTS_ALL.payee_first_party_reference%TYPE,
1285: payee_supplier_attr_cat
1286: IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
1280: IBY_PAYMENTS_ALL.payee_site_alternate_name%TYPE,
1281: payee_supplier_number
1282: IBY_PAYMENTS_ALL.payee_supplier_number%TYPE,
1283: payee_first_party_ref -- 50
1284: IBY_PAYMENTS_ALL.payee_first_party_reference%TYPE,
1285: payee_supplier_attr_cat
1286: IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
1287: payee_supplier_id
1288: IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
1282: IBY_PAYMENTS_ALL.payee_supplier_number%TYPE,
1283: payee_first_party_ref -- 50
1284: IBY_PAYMENTS_ALL.payee_first_party_reference%TYPE,
1285: payee_supplier_attr_cat
1286: IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
1287: payee_supplier_id
1288: IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
1289:
1290: /* PAYEE SPECIAL FIELDS */
1284: IBY_PAYMENTS_ALL.payee_first_party_reference%TYPE,
1285: payee_supplier_attr_cat
1286: IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
1287: payee_supplier_id
1288: IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
1289:
1290: /* PAYEE SPECIAL FIELDS */
1291: payee_tax_reg_number
1292: IBY_PAYMENTS_ALL.payee_tax_registration_num%TYPE,
1288: IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
1289:
1290: /* PAYEE SPECIAL FIELDS */
1291: payee_tax_reg_number
1292: IBY_PAYMENTS_ALL.payee_tax_registration_num%TYPE,
1293: payee_le_reg_number
1294: IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
1295:
1296: /* PAYEE BANK RELATED */
1290: /* PAYEE SPECIAL FIELDS */
1291: payee_tax_reg_number
1292: IBY_PAYMENTS_ALL.payee_tax_registration_num%TYPE,
1293: payee_le_reg_number
1294: IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
1295:
1296: /* PAYEE BANK RELATED */
1297: payee_bank_name
1298: IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
1294: IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
1295:
1296: /* PAYEE BANK RELATED */
1297: payee_bank_name
1298: IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
1299: payee_bank_number
1300: IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
1301: payee_bank_branch_number
1302: IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
1296: /* PAYEE BANK RELATED */
1297: payee_bank_name
1298: IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
1299: payee_bank_number
1300: IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
1301: payee_bank_branch_number
1302: IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
1303: payee_bank_branch_name
1304: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
1298: IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
1299: payee_bank_number
1300: IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
1301: payee_bank_branch_number
1302: IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
1303: payee_bank_branch_name
1304: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
1305: payee_bank_acct_number
1306: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
1300: IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
1301: payee_bank_branch_number
1302: IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
1303: payee_bank_branch_name
1304: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
1305: payee_bank_acct_number
1306: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
1307: payee_bank_acct_name -- 60
1308: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
1302: IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
1303: payee_bank_branch_name
1304: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
1305: payee_bank_acct_number
1306: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
1307: payee_bank_acct_name -- 60
1308: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
1309: payee_bank_acct_iban
1310: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
1304: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
1305: payee_bank_acct_number
1306: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
1307: payee_bank_acct_name -- 60
1308: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
1309: payee_bank_acct_iban
1310: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
1311: payee_bank_swift_code
1312: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
1306: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
1307: payee_bank_acct_name -- 60
1308: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
1309: payee_bank_acct_iban
1310: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
1311: payee_bank_swift_code
1312: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
1313: payee_bank_acct_type
1314: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
1308: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
1309: payee_bank_acct_iban
1310: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
1311: payee_bank_swift_code
1312: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
1313: payee_bank_acct_type
1314: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
1315: payee_bank_payment_factor_flag
1316: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
1310: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
1311: payee_bank_swift_code
1312: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
1313: payee_bank_acct_type
1314: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
1315: payee_bank_payment_factor_flag
1316: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
1317: payee_bank_owner_party_id
1318: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
1312: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
1313: payee_bank_acct_type
1314: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
1315: payee_bank_payment_factor_flag
1316: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
1317: payee_bank_owner_party_id
1318: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
1319: payee_bank_branch_party_id
1320: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
1314: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
1315: payee_bank_payment_factor_flag
1316: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
1317: payee_bank_owner_party_id
1318: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
1319: payee_bank_branch_party_id
1320: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
1321: payee_bank_name_alt
1322: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
1316: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
1317: payee_bank_owner_party_id
1318: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
1319: payee_bank_branch_party_id
1320: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
1321: payee_bank_name_alt
1322: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
1323: payee_bank_branch_name_alt
1324: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
1318: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
1319: payee_bank_branch_party_id
1320: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
1321: payee_bank_name_alt
1322: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
1323: payee_bank_branch_name_alt
1324: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
1325: payee_bank_alt_account_name
1326: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
1320: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
1321: payee_bank_name_alt
1322: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
1323: payee_bank_branch_name_alt
1324: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
1325: payee_bank_alt_account_name
1326: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
1327: payee_bank_electronic_acct_num -- 70
1328: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
1322: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
1323: payee_bank_branch_name_alt
1324: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
1325: payee_bank_alt_account_name
1326: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
1327: payee_bank_electronic_acct_num -- 70
1328: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
1329: payee_bank_branch_location_id
1330: IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
1324: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
1325: payee_bank_alt_account_name
1326: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
1327: payee_bank_electronic_acct_num -- 70
1328: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
1329: payee_bank_branch_location_id
1330: IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
1331: payee_bank_acct_owner_name
1332: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE,
1326: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
1327: payee_bank_electronic_acct_num -- 70
1328: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
1329: payee_bank_branch_location_id
1330: IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
1331: payee_bank_acct_owner_name
1332: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE,
1333:
1334:
1328: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
1329: payee_bank_branch_location_id
1330: IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
1331: payee_bank_acct_owner_name
1332: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE,
1333:
1334:
1335: /* REMITTANCE ADVICE RELATED */
1336: remit_advice_delivery_method
1333:
1334:
1335: /* REMITTANCE ADVICE RELATED */
1336: remit_advice_delivery_method
1337: IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
1338: remit_advice_email
1339: IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
1340: remit_advice_fax
1341: IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
1335: /* REMITTANCE ADVICE RELATED */
1336: remit_advice_delivery_method
1337: IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
1338: remit_advice_email
1339: IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
1340: remit_advice_fax
1341: IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
1342:
1343: /*
1337: IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
1338: remit_advice_email
1339: IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
1340: remit_advice_fax
1341: IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
1342:
1343: /*
1344: * Fix for bug 5522421:
1345: *
1347: * remit_advice_delivery_method and is
1348: * being obsoleted.
1349: */
1350: --remit_advice_delv_method
1351: -- IBY_PAYMENTS_ALL.sra_delivery_method%TYPE,
1352:
1353: /* DELIVERY CHANNEL RELATED */
1354: delivery_channel_format
1355: IBY_PAYMENTS_ALL.delivery_channel_format_value%TYPE,
1351: -- IBY_PAYMENTS_ALL.sra_delivery_method%TYPE,
1352:
1353: /* DELIVERY CHANNEL RELATED */
1354: delivery_channel_format
1355: IBY_PAYMENTS_ALL.delivery_channel_format_value%TYPE,
1356:
1357: /* DECLARATION REPORT RELATED */
1358: decl_curr_fx_rate_type
1359: IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
1355: IBY_PAYMENTS_ALL.delivery_channel_format_value%TYPE,
1356:
1357: /* DECLARATION REPORT RELATED */
1358: decl_curr_fx_rate_type
1359: IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
1360: declaration_format
1361: IBY_PAYMENTS_ALL.declaration_format%TYPE,
1362:
1363: /* PROFILE RELATED */
1357: /* DECLARATION REPORT RELATED */
1358: decl_curr_fx_rate_type
1359: IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
1360: declaration_format
1361: IBY_PAYMENTS_ALL.declaration_format%TYPE,
1362:
1363: /* PROFILE RELATED */
1364: payment_acct_profile_name -- 80
1365: IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
1361: IBY_PAYMENTS_ALL.declaration_format%TYPE,
1362:
1363: /* PROFILE RELATED */
1364: payment_acct_profile_name -- 80
1365: IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
1366: payment_sys_profile_name
1367: IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE,
1368:
1369: /* PAYMENT REASON */
1363: /* PROFILE RELATED */
1364: payment_acct_profile_name -- 80
1365: IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
1366: payment_sys_profile_name
1367: IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE,
1368:
1369: /* PAYMENT REASON */
1370: payment_reason_format
1371: IBY_PAYMENTS_ALL.payment_reason_format_value%TYPE,
1367: IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE,
1368:
1369: /* PAYMENT REASON */
1370: payment_reason_format
1371: IBY_PAYMENTS_ALL.payment_reason_format_value%TYPE,
1372:
1373: /* BANK INSTRUCTION */
1374: bank_instr1_format
1375: IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
1371: IBY_PAYMENTS_ALL.payment_reason_format_value%TYPE,
1372:
1373: /* BANK INSTRUCTION */
1374: bank_instr1_format
1375: IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
1376: bank_instr2_format
1377: IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
1378:
1379: /* ORG */
1373: /* BANK INSTRUCTION */
1374: bank_instr1_format
1375: IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
1376: bank_instr2_format
1377: IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
1378:
1379: /* ORG */
1380: org_name
1381: IBY_PAYMENTS_ALL.org_name%TYPE,
1377: IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
1378:
1379: /* ORG */
1380: org_name
1381: IBY_PAYMENTS_ALL.org_name%TYPE,
1382:
1383: /* RFC */
1384: payer_bank_branch_rfc_id
1385: IBY_PAYMENTS_ALL.int_bank_branch_rfc_identifier%TYPE,
1381: IBY_PAYMENTS_ALL.org_name%TYPE,
1382:
1383: /* RFC */
1384: payer_bank_branch_rfc_id
1385: IBY_PAYMENTS_ALL.int_bank_branch_rfc_identifier%TYPE,
1386:
1387: /* REQUEST */
1388: ppr_name
1389: IBY_PAYMENTS_ALL.payment_process_request_name%TYPE,
1385: IBY_PAYMENTS_ALL.int_bank_branch_rfc_identifier%TYPE,
1386:
1387: /* REQUEST */
1388: ppr_name
1389: IBY_PAYMENTS_ALL.payment_process_request_name%TYPE,
1390: source_product -- 88
1391: IBY_PAYMENTS_ALL.source_product%TYPE,
1392: /*TPP-Start*/
1393:
1387: /* REQUEST */
1388: ppr_name
1389: IBY_PAYMENTS_ALL.payment_process_request_name%TYPE,
1390: source_product -- 88
1391: IBY_PAYMENTS_ALL.source_product%TYPE,
1392: /*TPP-Start*/
1393:
1394: inv_payee_name
1395: IBY_PAYMENTS_ALL.inv_payee_name%TYPE,
1391: IBY_PAYMENTS_ALL.source_product%TYPE,
1392: /*TPP-Start*/
1393:
1394: inv_payee_name
1395: IBY_PAYMENTS_ALL.inv_payee_name%TYPE,
1396: inv_payee_address1
1397: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE,
1398: inv_payee_address2
1399: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE,
1393:
1394: inv_payee_name
1395: IBY_PAYMENTS_ALL.inv_payee_name%TYPE,
1396: inv_payee_address1
1397: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE,
1398: inv_payee_address2
1399: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE,
1400: inv_payee_address3
1401: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE,
1395: IBY_PAYMENTS_ALL.inv_payee_name%TYPE,
1396: inv_payee_address1
1397: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE,
1398: inv_payee_address2
1399: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE,
1400: inv_payee_address3
1401: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE,
1402: inv_payee_address4
1403: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE,
1397: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE,
1398: inv_payee_address2
1399: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE,
1400: inv_payee_address3
1401: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE,
1402: inv_payee_address4
1403: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE,
1404: inv_payee_city
1405: IBY_PAYMENTS_ALL.inv_payee_city%TYPE,
1399: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE,
1400: inv_payee_address3
1401: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE,
1402: inv_payee_address4
1403: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE,
1404: inv_payee_city
1405: IBY_PAYMENTS_ALL.inv_payee_city%TYPE,
1406: inv_payee_postal_code
1407: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE,
1401: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE,
1402: inv_payee_address4
1403: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE,
1404: inv_payee_city
1405: IBY_PAYMENTS_ALL.inv_payee_city%TYPE,
1406: inv_payee_postal_code
1407: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE,
1408: inv_payee_state
1409: IBY_PAYMENTS_ALL.inv_payee_state%TYPE,
1403: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE,
1404: inv_payee_city
1405: IBY_PAYMENTS_ALL.inv_payee_city%TYPE,
1406: inv_payee_postal_code
1407: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE,
1408: inv_payee_state
1409: IBY_PAYMENTS_ALL.inv_payee_state%TYPE,
1410: inv_payee_province
1411: IBY_PAYMENTS_ALL.inv_payee_province%TYPE,
1405: IBY_PAYMENTS_ALL.inv_payee_city%TYPE,
1406: inv_payee_postal_code
1407: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE,
1408: inv_payee_state
1409: IBY_PAYMENTS_ALL.inv_payee_state%TYPE,
1410: inv_payee_province
1411: IBY_PAYMENTS_ALL.inv_payee_province%TYPE,
1412: inv_payee_county
1413: IBY_PAYMENTS_ALL.inv_payee_county%TYPE,
1407: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE,
1408: inv_payee_state
1409: IBY_PAYMENTS_ALL.inv_payee_state%TYPE,
1410: inv_payee_province
1411: IBY_PAYMENTS_ALL.inv_payee_province%TYPE,
1412: inv_payee_county
1413: IBY_PAYMENTS_ALL.inv_payee_county%TYPE,
1414: inv_payee_country
1415: IBY_PAYMENTS_ALL.inv_payee_country%TYPE,
1409: IBY_PAYMENTS_ALL.inv_payee_state%TYPE,
1410: inv_payee_province
1411: IBY_PAYMENTS_ALL.inv_payee_province%TYPE,
1412: inv_payee_county
1413: IBY_PAYMENTS_ALL.inv_payee_county%TYPE,
1414: inv_payee_country
1415: IBY_PAYMENTS_ALL.inv_payee_country%TYPE,
1416: inv_payee_party_name
1417: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE,
1411: IBY_PAYMENTS_ALL.inv_payee_province%TYPE,
1412: inv_payee_county
1413: IBY_PAYMENTS_ALL.inv_payee_county%TYPE,
1414: inv_payee_country
1415: IBY_PAYMENTS_ALL.inv_payee_country%TYPE,
1416: inv_payee_party_name
1417: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE,
1418: inv_payee_le_reg_num
1419: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE,
1413: IBY_PAYMENTS_ALL.inv_payee_county%TYPE,
1414: inv_payee_country
1415: IBY_PAYMENTS_ALL.inv_payee_country%TYPE,
1416: inv_payee_party_name
1417: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE,
1418: inv_payee_le_reg_num
1419: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE,
1420: inv_payee_tax_reg_num
1421: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE,
1415: IBY_PAYMENTS_ALL.inv_payee_country%TYPE,
1416: inv_payee_party_name
1417: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE,
1418: inv_payee_le_reg_num
1419: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE,
1420: inv_payee_tax_reg_num
1421: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE,
1422: inv_payee_address_concat
1423: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE,
1417: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE,
1418: inv_payee_le_reg_num
1419: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE,
1420: inv_payee_tax_reg_num
1421: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE,
1422: inv_payee_address_concat
1423: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE,
1424: inv_beneficiary_name
1425: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE,
1419: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE,
1420: inv_payee_tax_reg_num
1421: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE,
1422: inv_payee_address_concat
1423: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE,
1424: inv_beneficiary_name
1425: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE,
1426: inv_payee_party_number
1427: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE,
1421: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE,
1422: inv_payee_address_concat
1423: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE,
1424: inv_beneficiary_name
1425: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE,
1426: inv_payee_party_number
1427: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE,
1428: inv_payee_alternate_name
1429: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE,
1423: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE,
1424: inv_beneficiary_name
1425: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE,
1426: inv_payee_party_number
1427: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE,
1428: inv_payee_alternate_name
1429: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE,
1430: inv_payee_site_alt_name
1431: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE,
1425: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE,
1426: inv_payee_party_number
1427: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE,
1428: inv_payee_alternate_name
1429: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE,
1430: inv_payee_site_alt_name
1431: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE,
1432: inv_payee_supplier_number
1433: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE,
1427: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE,
1428: inv_payee_alternate_name
1429: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE,
1430: inv_payee_site_alt_name
1431: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE,
1432: inv_payee_supplier_number
1433: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE,
1434: inv_payee_first_party_ref
1435: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE,
1429: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE,
1430: inv_payee_site_alt_name
1431: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE,
1432: inv_payee_supplier_number
1433: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE,
1434: inv_payee_first_party_ref
1435: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE,
1436: ext_bnk_acct_ownr_inv_prty_id
1437: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE,
1431: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE,
1432: inv_payee_supplier_number
1433: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE,
1434: inv_payee_first_party_ref
1435: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE,
1436: ext_bnk_acct_ownr_inv_prty_id
1437: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE,
1438: ext_bnk_branch_inv_prty_id
1439: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE,
1433: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE,
1434: inv_payee_first_party_ref
1435: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE,
1436: ext_bnk_acct_ownr_inv_prty_id
1437: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE,
1438: ext_bnk_branch_inv_prty_id
1439: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE,
1440: ext_bnk_acct_ownr_inv_prty_nme
1441: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE,
1435: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE,
1436: ext_bnk_acct_ownr_inv_prty_id
1437: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE,
1438: ext_bnk_branch_inv_prty_id
1439: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE,
1440: ext_bnk_acct_ownr_inv_prty_nme
1441: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE,
1442: inv_payee_party_attr_cat
1443: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE,
1437: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE,
1438: ext_bnk_branch_inv_prty_id
1439: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE,
1440: ext_bnk_acct_ownr_inv_prty_nme
1441: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE,
1442: inv_payee_party_attr_cat
1443: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE,
1444: inv_payee_supplier_attr_cat
1445: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE,
1439: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE,
1440: ext_bnk_acct_ownr_inv_prty_nme
1441: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE,
1442: inv_payee_party_attr_cat
1443: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE,
1444: inv_payee_supplier_attr_cat
1445: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE,
1446: inv_payee_spplr_site_attr_cat
1447: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE,
1441: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE,
1442: inv_payee_party_attr_cat
1443: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE,
1444: inv_payee_supplier_attr_cat
1445: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE,
1446: inv_payee_spplr_site_attr_cat
1447: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE,
1448: inv_payee_supplier_site_name
1449: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE,
1443: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE,
1444: inv_payee_supplier_attr_cat
1445: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE,
1446: inv_payee_spplr_site_attr_cat
1447: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE,
1448: inv_payee_supplier_site_name
1449: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE,
1450: inv_payee_spplr_site_alt_name
1451: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE,
1445: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE,
1446: inv_payee_spplr_site_attr_cat
1447: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE,
1448: inv_payee_supplier_site_name
1449: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE,
1450: inv_payee_spplr_site_alt_name
1451: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE,
1452: inv_payee_supplier_id
1453: IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
1447: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE,
1448: inv_payee_supplier_site_name
1449: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE,
1450: inv_payee_spplr_site_alt_name
1451: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE,
1452: inv_payee_supplier_id
1453: IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
1454: /*TPP-End*/
1455:
1449: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE,
1450: inv_payee_spplr_site_alt_name
1451: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE,
1452: inv_payee_supplier_id
1453: IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
1454: /*TPP-End*/
1455:
1456: );
1457:
1464: --
1465: -- Central bank reporting record
1466: --
1467: TYPE centralBankReportRecType IS RECORD (
1468: payment_id IBY_PAYMENTS_ALL.
1469: payment_id%TYPE,
1470: decl_option IBY_PAYMENT_PROFILES.
1471: declaration_option%TYPE,
1472: decl_only_fx_flag IBY_PAYMENT_PROFILES.
1571: | NOTES:
1572: |
1573: *---------------------------------------------------------------------*/
1574: PROCEDURE insertDocIntoPayment(
1575: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
1576: x_paymentTab IN OUT NOCOPY paymentTabType,
1577: p_calcDocInfo IN VARCHAR2,
1578: p_newPaymentFlag IN BOOLEAN,
1579: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
1575: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
1576: x_paymentTab IN OUT NOCOPY paymentTabType,
1577: p_calcDocInfo IN VARCHAR2,
1578: p_newPaymentFlag IN BOOLEAN,
1579: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
1580: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
1581: x_docsInPmtRec IN OUT NOCOPY docsInPaymentRecType,
1582: x_docsInPmtCount IN OUT NOCOPY NUMBER
1583: );
1611: | updatePayments
1612: |
1613: | PURPOSE:
1614: | Performs an update of all created payments from PLSQL
1615: | table into IBY_PAYMENTS_ALL table.
1616: |
1617: | The created payments have already been inserted into
1618: | IBY_PAYMENTS_ALL after grouping. So we only need to update
1619: | certain fields of the payment that have been changed
1614: | Performs an update of all created payments from PLSQL
1615: | table into IBY_PAYMENTS_ALL table.
1616: |
1617: | The created payments have already been inserted into
1618: | IBY_PAYMENTS_ALL after grouping. So we only need to update
1619: | certain fields of the payment that have been changed
1620: | after the grouping was performed.
1621: |
1622: | PARAMETERS:
1655: | NOTES:
1656: |
1657: *---------------------------------------------------------------------*/
1658: PROCEDURE getNextPaymentID(
1659: x_paymentID IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE
1660: );
1661:
1662: /*--------------------------------------------------------------------
1663: | NAME:
2148: | NOTES:
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,
2284: | NOTES:
2285: |
2286: *---------------------------------------------------------------------*/
2287: FUNCTION checkIfPmtAlreadyFailed(
2288: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
2289: p_paymentTab IN paymentTabType
2290: )
2291: RETURN BOOLEAN;
2292:
2310: | NOTES:
2311: |
2312: *---------------------------------------------------------------------*/
2313: FUNCTION checkIfPmtAlreadyAdded(
2314: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
2315: p_paymentTab IN pmtIdsTab
2316: )
2317: RETURN BOOLEAN;
2318:
2431: | NOTES:
2432: |
2433: *---------------------------------------------------------------------*/
2434: FUNCTION getMaturityDaysForPmtMethod(
2435: p_pmt_method_code IN IBY_PAYMENTS_ALL.payment_method_code%TYPE,
2436: p_maturityDaysTab IN pmtMethodMaturityDaysTab
2437: ) RETURN NUMBER;
2438:
2439: /*--------------------------------------------------------------------
2455: | NOTES:
2456: |
2457: *---------------------------------------------------------------------*/
2458: PROCEDURE refreshDocAndPmtAmounts(
2459: p_adjustedPmtId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
2460: p_adjustedNegDocsTab IN docsInPaymentTabType,
2461: x_paymentTab IN OUT NOCOPY paymentTabType,
2462: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType
2463: );