[Home] [Help]
1: PACKAGE iby_paygroup_pub AUTHID CURRENT_USER AS
2: /*$Header: ibypaygs.pls 120.49.12020000.2 2013/02/25 10:36:11 kchavali 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:
385: /*TPP-Start*/
383:
384:
385: /*TPP-Start*/
386: TYPE t_ext_inv_payee_id IS TABLE OF
387: IBY_PAYMENTS_ALL.ext_inv_payee_id%TYPE
388: INDEX BY BINARY_INTEGER;
389: TYPE t_inv_payee_party_id IS TABLE OF
390: IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE
391: INDEX BY BINARY_INTEGER;
386: TYPE t_ext_inv_payee_id IS TABLE OF
387: IBY_PAYMENTS_ALL.ext_inv_payee_id%TYPE
388: INDEX BY BINARY_INTEGER;
389: TYPE t_inv_payee_party_id IS TABLE OF
390: IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE
391: INDEX BY BINARY_INTEGER;
392: TYPE t_inv_party_site_id IS TABLE OF
393: IBY_PAYMENTS_ALL.inv_party_site_id%TYPE
394: INDEX BY BINARY_INTEGER;
389: TYPE t_inv_payee_party_id IS TABLE OF
390: IBY_PAYMENTS_ALL.inv_payee_party_id%TYPE
391: INDEX BY BINARY_INTEGER;
392: TYPE t_inv_party_site_id IS TABLE OF
393: IBY_PAYMENTS_ALL.inv_party_site_id%TYPE
394: INDEX BY BINARY_INTEGER;
395: TYPE t_inv_supplier_site_id IS TABLE OF
396: IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE
397: INDEX BY BINARY_INTEGER;
392: TYPE t_inv_party_site_id IS TABLE OF
393: IBY_PAYMENTS_ALL.inv_party_site_id%TYPE
394: INDEX BY BINARY_INTEGER;
395: TYPE t_inv_supplier_site_id IS TABLE OF
396: IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE
397: INDEX BY BINARY_INTEGER;
398: TYPE t_inv_beneficiary_party IS TABLE OF
399: IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE
400: INDEX BY BINARY_INTEGER;
395: TYPE t_inv_supplier_site_id IS TABLE OF
396: IBY_PAYMENTS_ALL.inv_supplier_site_id%TYPE
397: INDEX BY BINARY_INTEGER;
398: TYPE t_inv_beneficiary_party IS TABLE OF
399: IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE
400: INDEX BY BINARY_INTEGER;
401: TYPE t_inv_payee_name IS TABLE OF
402: IBY_PAYMENTS_ALL.inv_payee_name%TYPE
403: INDEX BY BINARY_INTEGER;
398: TYPE t_inv_beneficiary_party IS TABLE OF
399: IBY_PAYMENTS_ALL.inv_beneficiary_party%TYPE
400: INDEX BY BINARY_INTEGER;
401: TYPE t_inv_payee_name IS TABLE OF
402: IBY_PAYMENTS_ALL.inv_payee_name%TYPE
403: INDEX BY BINARY_INTEGER;
404: TYPE t_inv_payee_address1 IS TABLE OF
405: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE
406: INDEX BY BINARY_INTEGER;
401: TYPE t_inv_payee_name IS TABLE OF
402: IBY_PAYMENTS_ALL.inv_payee_name%TYPE
403: INDEX BY BINARY_INTEGER;
404: TYPE t_inv_payee_address1 IS TABLE OF
405: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE
406: INDEX BY BINARY_INTEGER;
407: TYPE t_inv_payee_address2 IS TABLE OF
408: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE
409: INDEX BY BINARY_INTEGER;
404: TYPE t_inv_payee_address1 IS TABLE OF
405: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE
406: INDEX BY BINARY_INTEGER;
407: TYPE t_inv_payee_address2 IS TABLE OF
408: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE
409: INDEX BY BINARY_INTEGER;
410: TYPE t_inv_payee_address3 IS TABLE OF
411: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE
412: INDEX BY BINARY_INTEGER;
407: TYPE t_inv_payee_address2 IS TABLE OF
408: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE
409: INDEX BY BINARY_INTEGER;
410: TYPE t_inv_payee_address3 IS TABLE OF
411: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE
412: INDEX BY BINARY_INTEGER;
413: TYPE t_inv_payee_address4 IS TABLE OF
414: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE
415: INDEX BY BINARY_INTEGER;
410: TYPE t_inv_payee_address3 IS TABLE OF
411: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE
412: INDEX BY BINARY_INTEGER;
413: TYPE t_inv_payee_address4 IS TABLE OF
414: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE
415: INDEX BY BINARY_INTEGER;
416: TYPE t_inv_payee_city IS TABLE OF
417: IBY_PAYMENTS_ALL.inv_payee_city%TYPE
418: INDEX BY BINARY_INTEGER;
413: TYPE t_inv_payee_address4 IS TABLE OF
414: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE
415: INDEX BY BINARY_INTEGER;
416: TYPE t_inv_payee_city IS TABLE OF
417: IBY_PAYMENTS_ALL.inv_payee_city%TYPE
418: INDEX BY BINARY_INTEGER;
419: TYPE t_inv_payee_postal_code IS TABLE OF
420: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE
421: INDEX BY BINARY_INTEGER;
416: TYPE t_inv_payee_city IS TABLE OF
417: IBY_PAYMENTS_ALL.inv_payee_city%TYPE
418: INDEX BY BINARY_INTEGER;
419: TYPE t_inv_payee_postal_code IS TABLE OF
420: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE
421: INDEX BY BINARY_INTEGER;
422: TYPE t_inv_payee_state IS TABLE OF
423: IBY_PAYMENTS_ALL.inv_payee_state%TYPE
424: INDEX BY BINARY_INTEGER;
419: TYPE t_inv_payee_postal_code IS TABLE OF
420: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE
421: INDEX BY BINARY_INTEGER;
422: TYPE t_inv_payee_state IS TABLE OF
423: IBY_PAYMENTS_ALL.inv_payee_state%TYPE
424: INDEX BY BINARY_INTEGER;
425: TYPE t_inv_payee_province IS TABLE OF
426: IBY_PAYMENTS_ALL.inv_payee_province%TYPE
427: INDEX BY BINARY_INTEGER;
422: TYPE t_inv_payee_state IS TABLE OF
423: IBY_PAYMENTS_ALL.inv_payee_state%TYPE
424: INDEX BY BINARY_INTEGER;
425: TYPE t_inv_payee_province IS TABLE OF
426: IBY_PAYMENTS_ALL.inv_payee_province%TYPE
427: INDEX BY BINARY_INTEGER;
428: TYPE t_inv_payee_county IS TABLE OF
429: IBY_PAYMENTS_ALL.inv_payee_county%TYPE
430: INDEX BY BINARY_INTEGER;
425: TYPE t_inv_payee_province IS TABLE OF
426: IBY_PAYMENTS_ALL.inv_payee_province%TYPE
427: INDEX BY BINARY_INTEGER;
428: TYPE t_inv_payee_county IS TABLE OF
429: IBY_PAYMENTS_ALL.inv_payee_county%TYPE
430: INDEX BY BINARY_INTEGER;
431: TYPE t_inv_payee_country IS TABLE OF
432: IBY_PAYMENTS_ALL.inv_payee_country%TYPE
433: INDEX BY BINARY_INTEGER;
428: TYPE t_inv_payee_county IS TABLE OF
429: IBY_PAYMENTS_ALL.inv_payee_county%TYPE
430: INDEX BY BINARY_INTEGER;
431: TYPE t_inv_payee_country IS TABLE OF
432: IBY_PAYMENTS_ALL.inv_payee_country%TYPE
433: INDEX BY BINARY_INTEGER;
434: TYPE t_inv_payee_party_name IS TABLE OF
435: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE
436: INDEX BY BINARY_INTEGER;
431: TYPE t_inv_payee_country IS TABLE OF
432: IBY_PAYMENTS_ALL.inv_payee_country%TYPE
433: INDEX BY BINARY_INTEGER;
434: TYPE t_inv_payee_party_name IS TABLE OF
435: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE
436: INDEX BY BINARY_INTEGER;
437: TYPE t_inv_payee_le_reg_num IS TABLE OF
438: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE
439: INDEX BY BINARY_INTEGER;
434: TYPE t_inv_payee_party_name IS TABLE OF
435: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE
436: INDEX BY BINARY_INTEGER;
437: TYPE t_inv_payee_le_reg_num IS TABLE OF
438: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE
439: INDEX BY BINARY_INTEGER;
440: TYPE t_inv_payee_tax_reg_num IS TABLE OF
441: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE
442: INDEX BY BINARY_INTEGER;
437: TYPE t_inv_payee_le_reg_num IS TABLE OF
438: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE
439: INDEX BY BINARY_INTEGER;
440: TYPE t_inv_payee_tax_reg_num IS TABLE OF
441: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE
442: INDEX BY BINARY_INTEGER;
443: TYPE t_inv_payee_address_concat IS TABLE OF
444: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
445: INDEX BY BINARY_INTEGER;
440: TYPE t_inv_payee_tax_reg_num IS TABLE OF
441: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE
442: INDEX BY BINARY_INTEGER;
443: TYPE t_inv_payee_address_concat IS TABLE OF
444: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
445: INDEX BY BINARY_INTEGER;
446: TYPE t_inv_beneficiary_name IS TABLE OF
447: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE
448: INDEX BY BINARY_INTEGER;
443: TYPE t_inv_payee_address_concat IS TABLE OF
444: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE
445: INDEX BY BINARY_INTEGER;
446: TYPE t_inv_beneficiary_name IS TABLE OF
447: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE
448: INDEX BY BINARY_INTEGER;
449: TYPE t_inv_payee_party_number IS TABLE OF
450: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE
451: INDEX BY BINARY_INTEGER;
446: TYPE t_inv_beneficiary_name IS TABLE OF
447: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE
448: INDEX BY BINARY_INTEGER;
449: TYPE t_inv_payee_party_number IS TABLE OF
450: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE
451: INDEX BY BINARY_INTEGER;
452: TYPE t_inv_payee_alternate_name IS TABLE OF
453: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE
454: INDEX BY BINARY_INTEGER;
449: TYPE t_inv_payee_party_number IS TABLE OF
450: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE
451: INDEX BY BINARY_INTEGER;
452: TYPE t_inv_payee_alternate_name IS TABLE OF
453: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE
454: INDEX BY BINARY_INTEGER;
455: TYPE t_inv_payee_site_alt_name IS TABLE OF
456: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE
457: INDEX BY BINARY_INTEGER;
452: TYPE t_inv_payee_alternate_name IS TABLE OF
453: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE
454: INDEX BY BINARY_INTEGER;
455: TYPE t_inv_payee_site_alt_name IS TABLE OF
456: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE
457: INDEX BY BINARY_INTEGER;
458: TYPE t_inv_payee_supplier_number IS TABLE OF
459: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE
460: INDEX BY BINARY_INTEGER;
455: TYPE t_inv_payee_site_alt_name IS TABLE OF
456: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE
457: INDEX BY BINARY_INTEGER;
458: TYPE t_inv_payee_supplier_number IS TABLE OF
459: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE
460: INDEX BY BINARY_INTEGER;
461: TYPE t_inv_payee_first_party_ref IS TABLE OF
462: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE
463: INDEX BY BINARY_INTEGER;
458: TYPE t_inv_payee_supplier_number IS TABLE OF
459: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE
460: INDEX BY BINARY_INTEGER;
461: TYPE t_inv_payee_first_party_ref IS TABLE OF
462: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE
463: INDEX BY BINARY_INTEGER;
464: TYPE t_ext_acct_ownr_inv_prty_id IS TABLE OF
465: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE
466: INDEX BY BINARY_INTEGER;
461: TYPE t_inv_payee_first_party_ref IS TABLE OF
462: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE
463: INDEX BY BINARY_INTEGER;
464: TYPE t_ext_acct_ownr_inv_prty_id IS TABLE OF
465: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE
466: INDEX BY BINARY_INTEGER;
467: TYPE t_ext_bnk_branch_inv_prty_id IS TABLE OF
468: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE
469: INDEX BY BINARY_INTEGER;
464: TYPE t_ext_acct_ownr_inv_prty_id IS TABLE OF
465: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE
466: INDEX BY BINARY_INTEGER;
467: TYPE t_ext_bnk_branch_inv_prty_id IS TABLE OF
468: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE
469: INDEX BY BINARY_INTEGER;
470: TYPE t_ext_acct_ownr_inv_prty_nme IS TABLE OF
471: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE
472: INDEX BY BINARY_INTEGER;
467: TYPE t_ext_bnk_branch_inv_prty_id IS TABLE OF
468: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE
469: INDEX BY BINARY_INTEGER;
470: TYPE t_ext_acct_ownr_inv_prty_nme IS TABLE OF
471: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE
472: INDEX BY BINARY_INTEGER;
473: TYPE t_inv_payee_party_attr_cat IS TABLE OF
474: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE
475: INDEX BY BINARY_INTEGER;
470: TYPE t_ext_acct_ownr_inv_prty_nme IS TABLE OF
471: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE
472: INDEX BY BINARY_INTEGER;
473: TYPE t_inv_payee_party_attr_cat IS TABLE OF
474: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE
475: INDEX BY BINARY_INTEGER;
476: TYPE t_inv_payee_supplier_attr_cat IS TABLE OF
477: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE
478: INDEX BY BINARY_INTEGER;
473: TYPE t_inv_payee_party_attr_cat IS TABLE OF
474: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE
475: INDEX BY BINARY_INTEGER;
476: TYPE t_inv_payee_supplier_attr_cat IS TABLE OF
477: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE
478: INDEX BY BINARY_INTEGER;
479: TYPE t_inv_payee_site_attr_cat IS TABLE OF
480: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE
481: INDEX BY BINARY_INTEGER;
476: TYPE t_inv_payee_supplier_attr_cat IS TABLE OF
477: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE
478: INDEX BY BINARY_INTEGER;
479: TYPE t_inv_payee_site_attr_cat IS TABLE OF
480: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE
481: INDEX BY BINARY_INTEGER;
482: TYPE t_inv_payee_supplier_site_name IS TABLE OF
483: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE
484: INDEX BY BINARY_INTEGER;
479: TYPE t_inv_payee_site_attr_cat IS TABLE OF
480: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE
481: INDEX BY BINARY_INTEGER;
482: TYPE t_inv_payee_supplier_site_name IS TABLE OF
483: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE
484: INDEX BY BINARY_INTEGER;
485: TYPE t_inv_payee_spp_site_alt_name IS TABLE OF
486: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE
487: INDEX BY BINARY_INTEGER;
482: TYPE t_inv_payee_supplier_site_name IS TABLE OF
483: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE
484: INDEX BY BINARY_INTEGER;
485: TYPE t_inv_payee_spp_site_alt_name IS TABLE OF
486: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE
487: INDEX BY BINARY_INTEGER;
488: TYPE t_inv_payee_supplier_id IS TABLE OF
489: IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
490: INDEX BY BINARY_INTEGER;
485: TYPE t_inv_payee_spp_site_alt_name IS TABLE OF
486: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE
487: INDEX BY BINARY_INTEGER;
488: TYPE t_inv_payee_supplier_id IS TABLE OF
489: IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
490: INDEX BY BINARY_INTEGER;
491: /*TPP-End*/
492:
493: /*
496: * Ensure that employee related fields are populated in the
497: * payment record.
498: */
499: TYPE t_address_source IS TABLE OF
500: IBY_PAYMENTS_ALL.address_source%TYPE
501: INDEX BY BINARY_INTEGER;
502:
503: TYPE t_employee_address_code IS TABLE OF
504: IBY_PAYMENTS_ALL.employee_address_code%TYPE
500: IBY_PAYMENTS_ALL.address_source%TYPE
501: INDEX BY BINARY_INTEGER;
502:
503: TYPE t_employee_address_code IS TABLE OF
504: IBY_PAYMENTS_ALL.employee_address_code%TYPE
505: INDEX BY BINARY_INTEGER;
506:
507: TYPE t_employee_person_id IS TABLE OF
508: IBY_PAYMENTS_ALL.employee_person_id%TYPE
504: IBY_PAYMENTS_ALL.employee_address_code%TYPE
505: INDEX BY BINARY_INTEGER;
506:
507: TYPE t_employee_person_id IS TABLE OF
508: IBY_PAYMENTS_ALL.employee_person_id%TYPE
509: INDEX BY BINARY_INTEGER;
510:
511: TYPE t_employee_address_id IS TABLE OF
512: IBY_PAYMENTS_ALL.employee_address_id%TYPE
508: IBY_PAYMENTS_ALL.employee_person_id%TYPE
509: INDEX BY BINARY_INTEGER;
510:
511: TYPE t_employee_address_id IS TABLE OF
512: IBY_PAYMENTS_ALL.employee_address_id%TYPE
513: INDEX BY BINARY_INTEGER;
514:
515: TYPE t_employee_payment_flag IS TABLE OF
516: IBY_PAYMENTS_ALL.employee_payment_flag%TYPE
512: IBY_PAYMENTS_ALL.employee_address_id%TYPE
513: INDEX BY BINARY_INTEGER;
514:
515: TYPE t_employee_payment_flag IS TABLE OF
516: IBY_PAYMENTS_ALL.employee_payment_flag%TYPE
517: INDEX BY BINARY_INTEGER;
518:
519: TYPE t_calling_app_id IS TABLE OF
520: IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE
541: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
542: INDEX BY BINARY_INTEGER;
543:
544: TYPE t_payer_party_number IS TABLE OF
545: IBY_PAYMENTS_ALL.PAYER_PARTY_NUMBER%TYPE
546: INDEX BY BINARY_INTEGER;
547:
548: TYPE t_payer_party_site_name IS TABLE OF
549: IBY_PAYMENTS_ALL.PAYER_PARTY_SITE_NAME%TYPE
545: IBY_PAYMENTS_ALL.PAYER_PARTY_NUMBER%TYPE
546: INDEX BY BINARY_INTEGER;
547:
548: TYPE t_payer_party_site_name IS TABLE OF
549: IBY_PAYMENTS_ALL.PAYER_PARTY_SITE_NAME%TYPE
550: INDEX BY BINARY_INTEGER;
551:
552: TYPE t_payer_legal_entity_name IS TABLE OF
553: IBY_PAYMENTS_ALL.PAYER_LEGAL_ENTITY_NAME%TYPE
549: IBY_PAYMENTS_ALL.PAYER_PARTY_SITE_NAME%TYPE
550: INDEX BY BINARY_INTEGER;
551:
552: TYPE t_payer_legal_entity_name IS TABLE OF
553: IBY_PAYMENTS_ALL.PAYER_LEGAL_ENTITY_NAME%TYPE
554: INDEX BY BINARY_INTEGER;
555:
556: TYPE t_payer_tax_registration_num IS TABLE OF
557: IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE
553: IBY_PAYMENTS_ALL.PAYER_LEGAL_ENTITY_NAME%TYPE
554: INDEX BY BINARY_INTEGER;
555:
556: TYPE t_payer_tax_registration_num IS TABLE OF
557: IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE
558: INDEX BY BINARY_INTEGER;
559:
560: TYPE t_payer_le_registration_num IS TABLE OF
561: IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE
557: IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM%TYPE
558: INDEX BY BINARY_INTEGER;
559:
560: TYPE t_payer_le_registration_num IS TABLE OF
561: IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE
562: INDEX BY BINARY_INTEGER;
563:
564: TYPE t_payer_party_id IS TABLE OF
565: IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE
561: IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM%TYPE
562: INDEX BY BINARY_INTEGER;
563:
564: TYPE t_payer_party_id IS TABLE OF
565: IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE
566: INDEX BY BINARY_INTEGER;
567:
568: TYPE t_payer_location_id IS TABLE OF
569: IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE
565: IBY_PAYMENTS_ALL.PAYER_PARTY_ID%TYPE
566: INDEX BY BINARY_INTEGER;
567:
568: TYPE t_payer_location_id IS TABLE OF
569: IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE
570: INDEX BY BINARY_INTEGER;
571:
572: TYPE t_payer_party_attr_category IS TABLE OF
573: IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE
569: IBY_PAYMENTS_ALL.PAYER_LOCATION_ID%TYPE
570: INDEX BY BINARY_INTEGER;
571:
572: TYPE t_payer_party_attr_category IS TABLE OF
573: IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE
574: INDEX BY BINARY_INTEGER;
575:
576: TYPE t_payer_le_attr_category IS TABLE OF
577: IBY_PAYMENTS_ALL.PAYER_LE_ATTR_CATEGORY%TYPE
573: IBY_PAYMENTS_ALL.PAYER_PARTY_ATTR_CATEGORY%TYPE
574: INDEX BY BINARY_INTEGER;
575:
576: TYPE t_payer_le_attr_category IS TABLE OF
577: IBY_PAYMENTS_ALL.PAYER_LE_ATTR_CATEGORY%TYPE
578: INDEX BY BINARY_INTEGER;
579:
580: TYPE t_payer_abbr_agency_code IS TABLE OF
581: IBY_PAYMENTS_ALL.PAYER_ABBREVIATED_AGENCY_CODE%TYPE
577: IBY_PAYMENTS_ALL.PAYER_LE_ATTR_CATEGORY%TYPE
578: INDEX BY BINARY_INTEGER;
579:
580: TYPE t_payer_abbr_agency_code IS TABLE OF
581: IBY_PAYMENTS_ALL.PAYER_ABBREVIATED_AGENCY_CODE%TYPE
582: INDEX BY BINARY_INTEGER;
583:
584: TYPE t_payer_federal_us_employer_id IS TABLE OF
585: IBY_PAYMENTS_ALL.PAYER_FEDERAL_US_EMPLOYER_ID%TYPE
581: IBY_PAYMENTS_ALL.PAYER_ABBREVIATED_AGENCY_CODE%TYPE
582: INDEX BY BINARY_INTEGER;
583:
584: TYPE t_payer_federal_us_employer_id IS TABLE OF
585: IBY_PAYMENTS_ALL.PAYER_FEDERAL_US_EMPLOYER_ID%TYPE
586: INDEX BY BINARY_INTEGER;
587:
588:
589:
587:
588:
589:
590: TYPE t_int_bank_name IS TABLE OF
591: IBY_PAYMENTS_ALL.INT_BANK_NAME%TYPE
592: INDEX BY BINARY_INTEGER;
593:
594: TYPE t_int_bank_number IS TABLE OF
595: IBY_PAYMENTS_ALL.INT_BANK_NUMBER%TYPE
591: IBY_PAYMENTS_ALL.INT_BANK_NAME%TYPE
592: INDEX BY BINARY_INTEGER;
593:
594: TYPE t_int_bank_number IS TABLE OF
595: IBY_PAYMENTS_ALL.INT_BANK_NUMBER%TYPE
596: INDEX BY BINARY_INTEGER;
597:
598: TYPE t_int_bank_branch_number IS TABLE OF
599: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NUMBER%TYPE
595: IBY_PAYMENTS_ALL.INT_BANK_NUMBER%TYPE
596: INDEX BY BINARY_INTEGER;
597:
598: TYPE t_int_bank_branch_number IS TABLE OF
599: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NUMBER%TYPE
600: INDEX BY BINARY_INTEGER;
601:
602: TYPE t_int_bank_branch_name IS TABLE OF
603: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE
599: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NUMBER%TYPE
600: INDEX BY BINARY_INTEGER;
601:
602: TYPE t_int_bank_branch_name IS TABLE OF
603: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE
604: INDEX BY BINARY_INTEGER;
605:
606: TYPE t_int_eft_swift_code IS TABLE OF
607: IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE
603: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_NAME%TYPE
604: INDEX BY BINARY_INTEGER;
605:
606: TYPE t_int_eft_swift_code IS TABLE OF
607: IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE
608: INDEX BY BINARY_INTEGER;
609:
610: TYPE t_int_bank_account_number IS TABLE OF
611: IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE
607: IBY_PAYMENTS_ALL.INT_EFT_SWIFT_CODE%TYPE
608: INDEX BY BINARY_INTEGER;
609:
610: TYPE t_int_bank_account_number IS TABLE OF
611: IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE
612: INDEX BY BINARY_INTEGER;
613:
614: TYPE t_int_bank_account_name IS TABLE OF
615: IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE
611: IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUMBER%TYPE
612: INDEX BY BINARY_INTEGER;
613:
614: TYPE t_int_bank_account_name IS TABLE OF
615: IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NAME%TYPE
616: INDEX BY BINARY_INTEGER;
617:
618:
619: TYPE t_int_bank_account_iban IS TABLE OF
616: INDEX BY BINARY_INTEGER;
617:
618:
619: TYPE t_int_bank_account_iban IS TABLE OF
620: IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_IBAN%TYPE
621: INDEX BY BINARY_INTEGER;
622:
623:
624: TYPE t_int_bank_acct_ag_loc_code IS TABLE OF
621: INDEX BY BINARY_INTEGER;
622:
623:
624: TYPE t_int_bank_acct_ag_loc_code IS TABLE OF
625: IBY_PAYMENTS_ALL.INT_BANK_ACCT_AGENCY_LOC_CODE%TYPE
626: INDEX BY BINARY_INTEGER;
627:
628:
629: TYPE t_int_bank_branch_party_id IS TABLE OF
626: INDEX BY BINARY_INTEGER;
627:
628:
629: TYPE t_int_bank_branch_party_id IS TABLE OF
630: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_PARTY_ID%TYPE
631: INDEX BY BINARY_INTEGER;
632:
633:
634: TYPE t_int_bank_alt_name IS TABLE OF
631: INDEX BY BINARY_INTEGER;
632:
633:
634: TYPE t_int_bank_alt_name IS TABLE OF
635: IBY_PAYMENTS_ALL.INT_BANK_ALT_NAME%TYPE
636: INDEX BY BINARY_INTEGER;
637:
638:
639: TYPE t_int_bank_branch_alt_name IS TABLE OF
636: INDEX BY BINARY_INTEGER;
637:
638:
639: TYPE t_int_bank_branch_alt_name IS TABLE OF
640: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_ALT_NAME%TYPE
641: INDEX BY BINARY_INTEGER;
642:
643:
644: TYPE t_int_bank_account_alt_name IS TABLE OF
641: INDEX BY BINARY_INTEGER;
642:
643:
644: TYPE t_int_bank_account_alt_name IS TABLE OF
645: IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_ALT_NAME%TYPE
646: INDEX BY BINARY_INTEGER;
647:
648:
649: TYPE t_int_bank_account_num_elec IS TABLE OF
646: INDEX BY BINARY_INTEGER;
647:
648:
649: TYPE t_int_bank_account_num_elec IS TABLE OF
650: IBY_PAYMENTS_ALL.INT_BANK_ACCOUNT_NUM_ELEC%TYPE
651: INDEX BY BINARY_INTEGER;
652:
653:
654: TYPE t_int_bank_branch_location_id IS TABLE OF
651: INDEX BY BINARY_INTEGER;
652:
653:
654: TYPE t_int_bank_branch_location_id IS TABLE OF
655: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_LOCATION_ID%TYPE
656: INDEX BY BINARY_INTEGER;
657:
658: TYPE t_int_bank_branch_eft_user_num IS TABLE OF
659: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_EFT_USER_NUM%TYPE
655: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_LOCATION_ID%TYPE
656: INDEX BY BINARY_INTEGER;
657:
658: TYPE t_int_bank_branch_eft_user_num IS TABLE OF
659: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_EFT_USER_NUM%TYPE
660: INDEX BY BINARY_INTEGER;
661:
662: TYPE t_int_bank_branch_rfc_id IS TABLE OF
663: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_RFC_IDENTIFIER%TYPE
659: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_EFT_USER_NUM%TYPE
660: INDEX BY BINARY_INTEGER;
661:
662: TYPE t_int_bank_branch_rfc_id IS TABLE OF
663: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_RFC_IDENTIFIER%TYPE
664: INDEX BY BINARY_INTEGER;
665:
666: TYPE t_payee_site_alt_name IS TABLE OF
667: IBY_PAYMENTS_ALL.PAYEE_SITE_ALTERNATE_NAME%TYPE
663: IBY_PAYMENTS_ALL.INT_BANK_BRANCH_RFC_IDENTIFIER%TYPE
664: INDEX BY BINARY_INTEGER;
665:
666: TYPE t_payee_site_alt_name IS TABLE OF
667: IBY_PAYMENTS_ALL.PAYEE_SITE_ALTERNATE_NAME%TYPE
668: INDEX BY BINARY_INTEGER;
669:
670: TYPE t_payee_supplier_number IS TABLE OF
671: IBY_PAYMENTS_ALL.PAYEE_SUPPLIER_NUMBER%TYPE
667: IBY_PAYMENTS_ALL.PAYEE_SITE_ALTERNATE_NAME%TYPE
668: INDEX BY BINARY_INTEGER;
669:
670: TYPE t_payee_supplier_number IS TABLE OF
671: IBY_PAYMENTS_ALL.PAYEE_SUPPLIER_NUMBER%TYPE
672: INDEX BY BINARY_INTEGER;
673:
674:
675: TYPE t_payee_first_party_ref IS TABLE OF
672: INDEX BY BINARY_INTEGER;
673:
674:
675: TYPE t_payee_first_party_ref IS TABLE OF
676: IBY_PAYMENTS_ALL.PAYEE_FIRST_PARTY_REFERENCE%TYPE
677: INDEX BY BINARY_INTEGER;
678:
679: TYPE t_payee_supp_attr_categ IS TABLE OF
680: IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE
676: IBY_PAYMENTS_ALL.PAYEE_FIRST_PARTY_REFERENCE%TYPE
677: INDEX BY BINARY_INTEGER;
678:
679: TYPE t_payee_supp_attr_categ IS TABLE OF
680: IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE
681: INDEX BY BINARY_INTEGER;
682:
683: TYPE t_payee_supplier_id IS TABLE OF
684: IBY_PAYMENTS_ALL.payee_supplier_id%TYPE
680: IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE
681: INDEX BY BINARY_INTEGER;
682:
683: TYPE t_payee_supplier_id IS TABLE OF
684: IBY_PAYMENTS_ALL.payee_supplier_id%TYPE
685: INDEX BY BINARY_INTEGER;
686:
687: TYPE t_payee_tax_reg_num IS TABLE OF
688: IBY_PAYMENTS_ALL.payee_tax_registration_num%TYPE
684: IBY_PAYMENTS_ALL.payee_supplier_id%TYPE
685: INDEX BY BINARY_INTEGER;
686:
687: TYPE t_payee_tax_reg_num IS TABLE OF
688: IBY_PAYMENTS_ALL.payee_tax_registration_num%TYPE
689: INDEX BY BINARY_INTEGER;
690:
691:
692: TYPE t_payee_le_reg_num IS TABLE OF
689: INDEX BY BINARY_INTEGER;
690:
691:
692: TYPE t_payee_le_reg_num IS TABLE OF
693: IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE
694: INDEX BY BINARY_INTEGER;
695:
696:
697:
695:
696:
697:
698: TYPE t_payee_spplr_site_attr_categ IS TABLE OF
699: IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE
700: INDEX BY BINARY_INTEGER;
701:
702: TYPE t_payee_supplier_site_name IS TABLE OF
703: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE
699: IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE
700: INDEX BY BINARY_INTEGER;
701:
702: TYPE t_payee_supplier_site_name IS TABLE OF
703: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE
704: INDEX BY BINARY_INTEGER;
705:
706: TYPE t_payee_party_site_name IS TABLE OF
707: IBY_PAYMENTS_ALL.payee_party_site_name%TYPE
703: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE
704: INDEX BY BINARY_INTEGER;
705:
706: TYPE t_payee_party_site_name IS TABLE OF
707: IBY_PAYMENTS_ALL.payee_party_site_name%TYPE
708: INDEX BY BINARY_INTEGER;
709:
710: TYPE t_ext_bank_name IS TABLE OF
711: IBY_PAYMENTS_ALL.ext_bank_name%TYPE
707: IBY_PAYMENTS_ALL.payee_party_site_name%TYPE
708: INDEX BY BINARY_INTEGER;
709:
710: TYPE t_ext_bank_name IS TABLE OF
711: IBY_PAYMENTS_ALL.ext_bank_name%TYPE
712: INDEX BY BINARY_INTEGER;
713:
714: TYPE t_ext_bank_branch_name IS TABLE OF
715: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE
711: IBY_PAYMENTS_ALL.ext_bank_name%TYPE
712: INDEX BY BINARY_INTEGER;
713:
714: TYPE t_ext_bank_branch_name IS TABLE OF
715: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE
716: INDEX BY BINARY_INTEGER;
717:
718: TYPE t_ext_eft_swift_code IS TABLE OF
719: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE
715: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE
716: INDEX BY BINARY_INTEGER;
717:
718: TYPE t_ext_eft_swift_code IS TABLE OF
719: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE
720: INDEX BY BINARY_INTEGER;
721:
722: TYPE t_ext_bnk_acct_factor_flag IS TABLE OF
723: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE
719: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE
720: INDEX BY BINARY_INTEGER;
721:
722: TYPE t_ext_bnk_acct_factor_flag IS TABLE OF
723: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE
724: INDEX BY BINARY_INTEGER;
725:
726: TYPE t_ext_bank_acct_owner_party_id IS TABLE OF
727: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE
723: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE
724: INDEX BY BINARY_INTEGER;
725:
726: TYPE t_ext_bank_acct_owner_party_id IS TABLE OF
727: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE
728: INDEX BY BINARY_INTEGER;
729:
730:
731: TYPE t_ext_bank_branch_party_id IS TABLE OF
728: INDEX BY BINARY_INTEGER;
729:
730:
731: TYPE t_ext_bank_branch_party_id IS TABLE OF
732: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE
733: INDEX BY BINARY_INTEGER;
734:
735: TYPE t_ext_bank_alt_name IS TABLE OF
736: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE
732: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE
733: INDEX BY BINARY_INTEGER;
734:
735: TYPE t_ext_bank_alt_name IS TABLE OF
736: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE
737: INDEX BY BINARY_INTEGER;
738:
739: TYPE t_ext_bank_branch_alt_name IS TABLE OF
740: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE
736: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE
737: INDEX BY BINARY_INTEGER;
738:
739: TYPE t_ext_bank_branch_alt_name IS TABLE OF
740: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE
741: INDEX BY BINARY_INTEGER;
742:
743: TYPE t_ext_bank_account_alt_name IS TABLE OF
744: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE
740: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE
741: INDEX BY BINARY_INTEGER;
742:
743: TYPE t_ext_bank_account_alt_name IS TABLE OF
744: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE
745: INDEX BY BINARY_INTEGER;
746:
747: TYPE t_ext_bank_account_num_elec IS TABLE OF
748: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE
744: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE
745: INDEX BY BINARY_INTEGER;
746:
747: TYPE t_ext_bank_account_num_elec IS TABLE OF
748: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE
749: INDEX BY BINARY_INTEGER;
750:
751: TYPE t_ext_bank_branch_location_id IS TABLE OF
752: IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE
748: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE
749: INDEX BY BINARY_INTEGER;
750:
751: TYPE t_ext_bank_branch_location_id IS TABLE OF
752: IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE
753: INDEX BY BINARY_INTEGER;
754:
755: TYPE t_ext_acct_owner_party_name IS TABLE OF
756: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE
752: IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE
753: INDEX BY BINARY_INTEGER;
754:
755: TYPE t_ext_acct_owner_party_name IS TABLE OF
756: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE
757: INDEX BY BINARY_INTEGER;
758:
759:
760:
758:
759:
760:
761: TYPE t_payee_address_concat IS TABLE OF
762: IBY_PAYMENTS_ALL.payee_address_concat%TYPE
763: INDEX BY BINARY_INTEGER;
764:
765: TYPE t_declaration_exch_rate_type IS TABLE OF
766: IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE
762: IBY_PAYMENTS_ALL.payee_address_concat%TYPE
763: INDEX BY BINARY_INTEGER;
764:
765: TYPE t_declaration_exch_rate_type IS TABLE OF
766: IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE
767: INDEX BY BINARY_INTEGER;
768:
769:
770: TYPE t_declaration_format IS TABLE OF
767: INDEX BY BINARY_INTEGER;
768:
769:
770: TYPE t_declaration_format IS TABLE OF
771: IBY_PAYMENTS_ALL.declaration_format%TYPE
772: INDEX BY BINARY_INTEGER;
773:
774:
775: TYPE t_bank_instr1_format_value IS TABLE OF
772: INDEX BY BINARY_INTEGER;
773:
774:
775: TYPE t_bank_instr1_format_value IS TABLE OF
776: IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE
777: INDEX BY BINARY_INTEGER;
778:
779:
780: TYPE t_bank_instr2_format_value IS TABLE OF
777: INDEX BY BINARY_INTEGER;
778:
779:
780: TYPE t_bank_instr2_format_value IS TABLE OF
781: IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE
782: INDEX BY BINARY_INTEGER;
783:
784:
785: TYPE t_payment_profile_acct_name IS TABLE OF
782: INDEX BY BINARY_INTEGER;
783:
784:
785: TYPE t_payment_profile_acct_name IS TABLE OF
786: IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE
787: INDEX BY BINARY_INTEGER;
788:
789:
790: TYPE t_payment_profile_sys_name IS TABLE OF
787: INDEX BY BINARY_INTEGER;
788:
789:
790: TYPE t_payment_profile_sys_name IS TABLE OF
791: IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE
792: INDEX BY BINARY_INTEGER;
793:
794:
795: TYPE t_payment_reason_format_value IS TABLE OF
792: INDEX BY BINARY_INTEGER;
793:
794:
795: TYPE t_payment_reason_format_value IS TABLE OF
796: IBY_PAYMENTS_ALL.payment_reason_format_value%TYPE
797: INDEX BY BINARY_INTEGER;
798:
799: TYPE t_payment_process_request_name IS TABLE OF
800: IBY_PAYMENTS_ALL.payment_process_request_name%TYPE
796: IBY_PAYMENTS_ALL.payment_reason_format_value%TYPE
797: INDEX BY BINARY_INTEGER;
798:
799: TYPE t_payment_process_request_name IS TABLE OF
800: IBY_PAYMENTS_ALL.payment_process_request_name%TYPE
801: INDEX BY BINARY_INTEGER;
802:
803: TYPE t_org_name IS TABLE OF
804: IBY_PAYMENTS_ALL.org_name%TYPE
800: IBY_PAYMENTS_ALL.payment_process_request_name%TYPE
801: INDEX BY BINARY_INTEGER;
802:
803: TYPE t_org_name IS TABLE OF
804: IBY_PAYMENTS_ALL.org_name%TYPE
805: INDEX BY BINARY_INTEGER;
806:
807: TYPE t_del_channel_format_value IS TABLE OF
808: IBY_PAYMENTS_ALL.DELIVERY_CHANNEL_FORMAT_VALUE%TYPE
804: IBY_PAYMENTS_ALL.org_name%TYPE
805: INDEX BY BINARY_INTEGER;
806:
807: TYPE t_del_channel_format_value IS TABLE OF
808: IBY_PAYMENTS_ALL.DELIVERY_CHANNEL_FORMAT_VALUE%TYPE
809: INDEX BY BINARY_INTEGER;
810:
811:
812: TYPE t_source_product IS TABLE OF
809: INDEX BY BINARY_INTEGER;
810:
811:
812: TYPE t_source_product IS TABLE OF
813: IBY_PAYMENTS_ALL.source_product%TYPE
814: INDEX BY BINARY_INTEGER;
815:
816: TYPE t_payee_party_number IS TABLE OF
817: IBY_PAYMENTS_ALL.payee_party_number%TYPE
813: IBY_PAYMENTS_ALL.source_product%TYPE
814: INDEX BY BINARY_INTEGER;
815:
816: TYPE t_payee_party_number IS TABLE OF
817: IBY_PAYMENTS_ALL.payee_party_number%TYPE
818: INDEX BY BINARY_INTEGER;
819:
820: TYPE t_payee_party_name IS TABLE OF
821: IBY_PAYMENTS_ALL.payee_party_name%TYPE
817: IBY_PAYMENTS_ALL.payee_party_number%TYPE
818: INDEX BY BINARY_INTEGER;
819:
820: TYPE t_payee_party_name IS TABLE OF
821: IBY_PAYMENTS_ALL.payee_party_name%TYPE
822: INDEX BY BINARY_INTEGER;
823:
824: TYPE t_payee_alt_name IS TABLE OF
825: IBY_PAYMENTS_ALL.PAYEE_ALTERNATE_NAME%TYPE
821: IBY_PAYMENTS_ALL.payee_party_name%TYPE
822: INDEX BY BINARY_INTEGER;
823:
824: TYPE t_payee_alt_name IS TABLE OF
825: IBY_PAYMENTS_ALL.PAYEE_ALTERNATE_NAME%TYPE
826: INDEX BY BINARY_INTEGER;
827:
828: TYPE t_payee_party_atr_cat IS TABLE OF
829: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE
825: IBY_PAYMENTS_ALL.PAYEE_ALTERNATE_NAME%TYPE
826: INDEX BY BINARY_INTEGER;
827:
828: TYPE t_payee_party_atr_cat IS TABLE OF
829: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE
830: INDEX BY BINARY_INTEGER;
831:
832: TYPE t_payee_addressee IS TABLE OF -- not to be used on B-o-B for ATT
833: IBY_PAYMENTS_ALL.payee_addressee%TYPE
829: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE
830: INDEX BY BINARY_INTEGER;
831:
832: TYPE t_payee_addressee IS TABLE OF -- not to be used on B-o-B for ATT
833: IBY_PAYMENTS_ALL.payee_addressee%TYPE
834: INDEX BY BINARY_INTEGER;
835:
836: TYPE t_affects_rejection_level IS TABLE OF
837: IBY_PAYMENTS_ALL.affects_rejection_level%TYPE
833: IBY_PAYMENTS_ALL.payee_addressee%TYPE
834: INDEX BY BINARY_INTEGER;
835:
836: TYPE t_affects_rejection_level IS TABLE OF
837: IBY_PAYMENTS_ALL.affects_rejection_level%TYPE
838: INDEX BY BINARY_INTEGER;
839:
840:
841: TYPE payment_tab_type IS RECORD
1411: INDEX BY BINARY_INTEGER;
1412:
1413: --
1414: -- This record needs to be created because of the fact that
1415: -- there is no document id column in IBY_PAYMENTS_ALL table. So
1416: -- we cannot add the document id as a field in the paymentRecType
1417: -- record (adding this field to the record will cause a syntax
1418: -- error during the bulk update).
1419: --
1429: -- to these documents.
1430: --
1431: TYPE docsInPaymentRecType IS RECORD (
1432: payment_id
1433: IBY_PAYMENTS_ALL.payment_id%TYPE,
1434: document_id
1435: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1436: calling_app_id
1437: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1510: -- particular payment.
1511: --
1512: TYPE successDocsCountPerPmtRec IS RECORD (
1513: payment_id
1514: IBY_PAYMENTS_ALL.payment_id%TYPE,
1515: success_docs_count
1516: NUMBER(15)
1517: );
1518:
1792: IBY_REMIT_ADVICE_SETUP.document_count_limit%TYPE,
1793: pmt_details_len_limit
1794: IBY_REMIT_ADVICE_SETUP.payment_details_length_limit%TYPE,
1795: PAYMENT_DETAILS
1796: IBY_PAYMENTS_ALL.PAYMENT_DETAILS%TYPE,
1797: payment_id
1798: IBY_PAYMENTS_ALL.payment_id%TYPE,
1799: DOCUMENT_COUNT
1800: NUMBER
1794: IBY_REMIT_ADVICE_SETUP.payment_details_length_limit%TYPE,
1795: PAYMENT_DETAILS
1796: IBY_PAYMENTS_ALL.PAYMENT_DETAILS%TYPE,
1797: payment_id
1798: IBY_PAYMENTS_ALL.payment_id%TYPE,
1799: DOCUMENT_COUNT
1800: NUMBER
1801: );
1802:
1824:
1825: --
1826: -- Table of payment ids.
1827: --
1828: TYPE pmtIdsTab IS TABLE OF IBY_PAYMENTS_ALL.payment_id%TYPE
1829: INDEX BY BINARY_INTEGER;
1830:
1831: --
1832: -- Internal bank account with its corresponding legal entity id.
1832: -- Internal bank account with its corresponding legal entity id.
1833: --
1834: TYPE bankAccountLERecType IS RECORD (
1835: int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE,
1836: le_id IBY_PAYMENTS_ALL.legal_entity_id%TYPE
1837: );
1838:
1839: --
1840: -- Table of internal bank accounts each with its legal entity.
1844:
1845: --
1846: -- Stores the denormalized data related to the payer, payee,
1847: -- payer bank and payee bank. This data is stamped onto
1848: -- the payment in IBY_PAYMENTS_ALL table for audit purposes.
1849: --
1850: TYPE paymentAuditRecType IS RECORD (
1851:
1852: payment_id -- 01
1849: --
1850: TYPE paymentAuditRecType IS RECORD (
1851:
1852: payment_id -- 01
1853: IBY_PAYMENTS_ALL.payment_id%TYPE,
1854:
1855: /* PAYER RELATED */
1856: payer_party_number
1857: IBY_PAYMENTS_ALL.payer_party_number%TYPE,
1853: IBY_PAYMENTS_ALL.payment_id%TYPE,
1854:
1855: /* PAYER RELATED */
1856: payer_party_number
1857: IBY_PAYMENTS_ALL.payer_party_number%TYPE,
1858: payer_party_site_name
1859: IBY_PAYMENTS_ALL.payer_party_site_name%TYPE,
1860: payer_legal_name
1861: IBY_PAYMENTS_ALL.payer_legal_entity_name%TYPE,
1855: /* PAYER RELATED */
1856: payer_party_number
1857: IBY_PAYMENTS_ALL.payer_party_number%TYPE,
1858: payer_party_site_name
1859: IBY_PAYMENTS_ALL.payer_party_site_name%TYPE,
1860: payer_legal_name
1861: IBY_PAYMENTS_ALL.payer_legal_entity_name%TYPE,
1862: payer_tax_reg_number
1863: IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE,
1857: IBY_PAYMENTS_ALL.payer_party_number%TYPE,
1858: payer_party_site_name
1859: IBY_PAYMENTS_ALL.payer_party_site_name%TYPE,
1860: payer_legal_name
1861: IBY_PAYMENTS_ALL.payer_legal_entity_name%TYPE,
1862: payer_tax_reg_number
1863: IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE,
1864: payer_le_reg_number
1865: IBY_PAYMENTS_ALL.payer_le_registration_num%TYPE,
1859: IBY_PAYMENTS_ALL.payer_party_site_name%TYPE,
1860: payer_legal_name
1861: IBY_PAYMENTS_ALL.payer_legal_entity_name%TYPE,
1862: payer_tax_reg_number
1863: IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE,
1864: payer_le_reg_number
1865: IBY_PAYMENTS_ALL.payer_le_registration_num%TYPE,
1866: payer_party_id
1867: IBY_PAYMENTS_ALL.payer_party_id%TYPE,
1861: IBY_PAYMENTS_ALL.payer_legal_entity_name%TYPE,
1862: payer_tax_reg_number
1863: IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE,
1864: payer_le_reg_number
1865: IBY_PAYMENTS_ALL.payer_le_registration_num%TYPE,
1866: payer_party_id
1867: IBY_PAYMENTS_ALL.payer_party_id%TYPE,
1868: payer_location_id
1869: IBY_PAYMENTS_ALL.payer_location_id%TYPE,
1863: IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE,
1864: payer_le_reg_number
1865: IBY_PAYMENTS_ALL.payer_le_registration_num%TYPE,
1866: payer_party_id
1867: IBY_PAYMENTS_ALL.payer_party_id%TYPE,
1868: payer_location_id
1869: IBY_PAYMENTS_ALL.payer_location_id%TYPE,
1870: payer_party_attr_cat
1871: IBY_PAYMENTS_ALL.payer_party_attr_category%TYPE,
1865: IBY_PAYMENTS_ALL.payer_le_registration_num%TYPE,
1866: payer_party_id
1867: IBY_PAYMENTS_ALL.payer_party_id%TYPE,
1868: payer_location_id
1869: IBY_PAYMENTS_ALL.payer_location_id%TYPE,
1870: payer_party_attr_cat
1871: IBY_PAYMENTS_ALL.payer_party_attr_category%TYPE,
1872: payer_le_attr_cat -- 10
1873: IBY_PAYMENTS_ALL.payer_le_attr_category%TYPE,
1867: IBY_PAYMENTS_ALL.payer_party_id%TYPE,
1868: payer_location_id
1869: IBY_PAYMENTS_ALL.payer_location_id%TYPE,
1870: payer_party_attr_cat
1871: IBY_PAYMENTS_ALL.payer_party_attr_category%TYPE,
1872: payer_le_attr_cat -- 10
1873: IBY_PAYMENTS_ALL.payer_le_attr_category%TYPE,
1874:
1875: /* PAYER SPECIAL FIELDS */
1869: IBY_PAYMENTS_ALL.payer_location_id%TYPE,
1870: payer_party_attr_cat
1871: IBY_PAYMENTS_ALL.payer_party_attr_category%TYPE,
1872: payer_le_attr_cat -- 10
1873: IBY_PAYMENTS_ALL.payer_le_attr_category%TYPE,
1874:
1875: /* PAYER SPECIAL FIELDS */
1876: payer_abbrev_agency_code
1877: IBY_PAYMENTS_ALL.payer_abbreviated_agency_code%TYPE,
1873: IBY_PAYMENTS_ALL.payer_le_attr_category%TYPE,
1874:
1875: /* PAYER SPECIAL FIELDS */
1876: payer_abbrev_agency_code
1877: IBY_PAYMENTS_ALL.payer_abbreviated_agency_code%TYPE,
1878: payer_us_employer_id
1879: IBY_PAYMENTS_ALL.payer_federal_us_employer_id%TYPE,
1880:
1881: /* PAYER BANK RELATED */
1875: /* PAYER SPECIAL FIELDS */
1876: payer_abbrev_agency_code
1877: IBY_PAYMENTS_ALL.payer_abbreviated_agency_code%TYPE,
1878: payer_us_employer_id
1879: IBY_PAYMENTS_ALL.payer_federal_us_employer_id%TYPE,
1880:
1881: /* PAYER BANK RELATED */
1882: payer_bank_name
1883: IBY_PAYMENTS_ALL.int_bank_name%TYPE,
1879: IBY_PAYMENTS_ALL.payer_federal_us_employer_id%TYPE,
1880:
1881: /* PAYER BANK RELATED */
1882: payer_bank_name
1883: IBY_PAYMENTS_ALL.int_bank_name%TYPE,
1884: payer_bank_number
1885: IBY_PAYMENTS_ALL.int_bank_number%TYPE,
1886: payer_bank_branch_number
1887: IBY_PAYMENTS_ALL.int_bank_branch_number%TYPE,
1881: /* PAYER BANK RELATED */
1882: payer_bank_name
1883: IBY_PAYMENTS_ALL.int_bank_name%TYPE,
1884: payer_bank_number
1885: IBY_PAYMENTS_ALL.int_bank_number%TYPE,
1886: payer_bank_branch_number
1887: IBY_PAYMENTS_ALL.int_bank_branch_number%TYPE,
1888: payer_bank_branch_name
1889: IBY_PAYMENTS_ALL.int_bank_branch_name%TYPE,
1883: IBY_PAYMENTS_ALL.int_bank_name%TYPE,
1884: payer_bank_number
1885: IBY_PAYMENTS_ALL.int_bank_number%TYPE,
1886: payer_bank_branch_number
1887: IBY_PAYMENTS_ALL.int_bank_branch_number%TYPE,
1888: payer_bank_branch_name
1889: IBY_PAYMENTS_ALL.int_bank_branch_name%TYPE,
1890: payer_bank_swift_code
1891: IBY_PAYMENTS_ALL.int_eft_swift_code%TYPE,
1885: IBY_PAYMENTS_ALL.int_bank_number%TYPE,
1886: payer_bank_branch_number
1887: IBY_PAYMENTS_ALL.int_bank_branch_number%TYPE,
1888: payer_bank_branch_name
1889: IBY_PAYMENTS_ALL.int_bank_branch_name%TYPE,
1890: payer_bank_swift_code
1891: IBY_PAYMENTS_ALL.int_eft_swift_code%TYPE,
1892: payer_bank_acct_num
1893: IBY_PAYMENTS_ALL.int_bank_account_number%TYPE,
1887: IBY_PAYMENTS_ALL.int_bank_branch_number%TYPE,
1888: payer_bank_branch_name
1889: IBY_PAYMENTS_ALL.int_bank_branch_name%TYPE,
1890: payer_bank_swift_code
1891: IBY_PAYMENTS_ALL.int_eft_swift_code%TYPE,
1892: payer_bank_acct_num
1893: IBY_PAYMENTS_ALL.int_bank_account_number%TYPE,
1894: payer_bank_acct_name
1895: IBY_PAYMENTS_ALL.int_bank_account_name%TYPE,
1889: IBY_PAYMENTS_ALL.int_bank_branch_name%TYPE,
1890: payer_bank_swift_code
1891: IBY_PAYMENTS_ALL.int_eft_swift_code%TYPE,
1892: payer_bank_acct_num
1893: IBY_PAYMENTS_ALL.int_bank_account_number%TYPE,
1894: payer_bank_acct_name
1895: IBY_PAYMENTS_ALL.int_bank_account_name%TYPE,
1896: payer_bank_acct_iban -- 20
1897: IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE,
1891: IBY_PAYMENTS_ALL.int_eft_swift_code%TYPE,
1892: payer_bank_acct_num
1893: IBY_PAYMENTS_ALL.int_bank_account_number%TYPE,
1894: payer_bank_acct_name
1895: IBY_PAYMENTS_ALL.int_bank_account_name%TYPE,
1896: payer_bank_acct_iban -- 20
1897: IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE,
1898: payer_bank_agency_loc_code
1899: IBY_PAYMENTS_ALL.int_bank_acct_agency_loc_code%TYPE,
1893: IBY_PAYMENTS_ALL.int_bank_account_number%TYPE,
1894: payer_bank_acct_name
1895: IBY_PAYMENTS_ALL.int_bank_account_name%TYPE,
1896: payer_bank_acct_iban -- 20
1897: IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE,
1898: payer_bank_agency_loc_code
1899: IBY_PAYMENTS_ALL.int_bank_acct_agency_loc_code%TYPE,
1900: payer_bank_branch_party_id
1901: IBY_PAYMENTS_ALL.int_bank_branch_party_id%TYPE,
1895: IBY_PAYMENTS_ALL.int_bank_account_name%TYPE,
1896: payer_bank_acct_iban -- 20
1897: IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE,
1898: payer_bank_agency_loc_code
1899: IBY_PAYMENTS_ALL.int_bank_acct_agency_loc_code%TYPE,
1900: payer_bank_branch_party_id
1901: IBY_PAYMENTS_ALL.int_bank_branch_party_id%TYPE,
1902: payer_bank_alt_name
1903: IBY_PAYMENTS_ALL.int_bank_alt_name%TYPE,
1897: IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE,
1898: payer_bank_agency_loc_code
1899: IBY_PAYMENTS_ALL.int_bank_acct_agency_loc_code%TYPE,
1900: payer_bank_branch_party_id
1901: IBY_PAYMENTS_ALL.int_bank_branch_party_id%TYPE,
1902: payer_bank_alt_name
1903: IBY_PAYMENTS_ALL.int_bank_alt_name%TYPE,
1904: payer_bank_branch_alt_name
1905: IBY_PAYMENTS_ALL.int_bank_branch_alt_name%TYPE,
1899: IBY_PAYMENTS_ALL.int_bank_acct_agency_loc_code%TYPE,
1900: payer_bank_branch_party_id
1901: IBY_PAYMENTS_ALL.int_bank_branch_party_id%TYPE,
1902: payer_bank_alt_name
1903: IBY_PAYMENTS_ALL.int_bank_alt_name%TYPE,
1904: payer_bank_branch_alt_name
1905: IBY_PAYMENTS_ALL.int_bank_branch_alt_name%TYPE,
1906: payer_bank_alt_account_name
1907: IBY_PAYMENTS_ALL.int_bank_account_alt_name%TYPE,
1901: IBY_PAYMENTS_ALL.int_bank_branch_party_id%TYPE,
1902: payer_bank_alt_name
1903: IBY_PAYMENTS_ALL.int_bank_alt_name%TYPE,
1904: payer_bank_branch_alt_name
1905: IBY_PAYMENTS_ALL.int_bank_branch_alt_name%TYPE,
1906: payer_bank_alt_account_name
1907: IBY_PAYMENTS_ALL.int_bank_account_alt_name%TYPE,
1908: payer_bank_account_num_elec
1909: IBY_PAYMENTS_ALL.int_bank_account_num_elec%TYPE,
1903: IBY_PAYMENTS_ALL.int_bank_alt_name%TYPE,
1904: payer_bank_branch_alt_name
1905: IBY_PAYMENTS_ALL.int_bank_branch_alt_name%TYPE,
1906: payer_bank_alt_account_name
1907: IBY_PAYMENTS_ALL.int_bank_account_alt_name%TYPE,
1908: payer_bank_account_num_elec
1909: IBY_PAYMENTS_ALL.int_bank_account_num_elec%TYPE,
1910: payer_bank_branch_location_id
1911: IBY_PAYMENTS_ALL.int_bank_branch_location_id%TYPE,
1905: IBY_PAYMENTS_ALL.int_bank_branch_alt_name%TYPE,
1906: payer_bank_alt_account_name
1907: IBY_PAYMENTS_ALL.int_bank_account_alt_name%TYPE,
1908: payer_bank_account_num_elec
1909: IBY_PAYMENTS_ALL.int_bank_account_num_elec%TYPE,
1910: payer_bank_branch_location_id
1911: IBY_PAYMENTS_ALL.int_bank_branch_location_id%TYPE,
1912: payer_bank_branch_eft_user_num
1913: IBY_PAYMENTS_ALL.int_bank_branch_eft_user_num%TYPE,
1907: IBY_PAYMENTS_ALL.int_bank_account_alt_name%TYPE,
1908: payer_bank_account_num_elec
1909: IBY_PAYMENTS_ALL.int_bank_account_num_elec%TYPE,
1910: payer_bank_branch_location_id
1911: IBY_PAYMENTS_ALL.int_bank_branch_location_id%TYPE,
1912: payer_bank_branch_eft_user_num
1913: IBY_PAYMENTS_ALL.int_bank_branch_eft_user_num%TYPE,
1914:
1915:
1909: IBY_PAYMENTS_ALL.int_bank_account_num_elec%TYPE,
1910: payer_bank_branch_location_id
1911: IBY_PAYMENTS_ALL.int_bank_branch_location_id%TYPE,
1912: payer_bank_branch_eft_user_num
1913: IBY_PAYMENTS_ALL.int_bank_branch_eft_user_num%TYPE,
1914:
1915:
1916: /* PAYEE RELATED */
1917: payee_party_number
1914:
1915:
1916: /* PAYEE RELATED */
1917: payee_party_number
1918: IBY_PAYMENTS_ALL.payee_party_number%TYPE,
1919: payee_party_name -- 30
1920: IBY_PAYMENTS_ALL.payee_party_name%TYPE,
1921: payee_name
1922: IBY_PAYMENTS_ALL.payee_name%TYPE,
1916: /* PAYEE RELATED */
1917: payee_party_number
1918: IBY_PAYMENTS_ALL.payee_party_number%TYPE,
1919: payee_party_name -- 30
1920: IBY_PAYMENTS_ALL.payee_party_name%TYPE,
1921: payee_name
1922: IBY_PAYMENTS_ALL.payee_name%TYPE,
1923: payee_name_alternate
1924: IBY_PAYMENTS_ALL.payee_alternate_name%TYPE,
1918: IBY_PAYMENTS_ALL.payee_party_number%TYPE,
1919: payee_party_name -- 30
1920: IBY_PAYMENTS_ALL.payee_party_name%TYPE,
1921: payee_name
1922: IBY_PAYMENTS_ALL.payee_name%TYPE,
1923: payee_name_alternate
1924: IBY_PAYMENTS_ALL.payee_alternate_name%TYPE,
1925: payee_add_line_1
1926: IBY_PAYMENTS_ALL.payee_address1%TYPE,
1920: IBY_PAYMENTS_ALL.payee_party_name%TYPE,
1921: payee_name
1922: IBY_PAYMENTS_ALL.payee_name%TYPE,
1923: payee_name_alternate
1924: IBY_PAYMENTS_ALL.payee_alternate_name%TYPE,
1925: payee_add_line_1
1926: IBY_PAYMENTS_ALL.payee_address1%TYPE,
1927: payee_add_line_2
1928: IBY_PAYMENTS_ALL.payee_address2%TYPE,
1922: IBY_PAYMENTS_ALL.payee_name%TYPE,
1923: payee_name_alternate
1924: IBY_PAYMENTS_ALL.payee_alternate_name%TYPE,
1925: payee_add_line_1
1926: IBY_PAYMENTS_ALL.payee_address1%TYPE,
1927: payee_add_line_2
1928: IBY_PAYMENTS_ALL.payee_address2%TYPE,
1929: payee_add_line_3
1930: IBY_PAYMENTS_ALL.payee_address3%TYPE,
1924: IBY_PAYMENTS_ALL.payee_alternate_name%TYPE,
1925: payee_add_line_1
1926: IBY_PAYMENTS_ALL.payee_address1%TYPE,
1927: payee_add_line_2
1928: IBY_PAYMENTS_ALL.payee_address2%TYPE,
1929: payee_add_line_3
1930: IBY_PAYMENTS_ALL.payee_address3%TYPE,
1931: payee_add_line_4
1932: IBY_PAYMENTS_ALL.payee_address4%TYPE,
1926: IBY_PAYMENTS_ALL.payee_address1%TYPE,
1927: payee_add_line_2
1928: IBY_PAYMENTS_ALL.payee_address2%TYPE,
1929: payee_add_line_3
1930: IBY_PAYMENTS_ALL.payee_address3%TYPE,
1931: payee_add_line_4
1932: IBY_PAYMENTS_ALL.payee_address4%TYPE,
1933: payee_city
1934: IBY_PAYMENTS_ALL.payee_city%TYPE,
1928: IBY_PAYMENTS_ALL.payee_address2%TYPE,
1929: payee_add_line_3
1930: IBY_PAYMENTS_ALL.payee_address3%TYPE,
1931: payee_add_line_4
1932: IBY_PAYMENTS_ALL.payee_address4%TYPE,
1933: payee_city
1934: IBY_PAYMENTS_ALL.payee_city%TYPE,
1935: payee_county
1936: IBY_PAYMENTS_ALL.payee_county%TYPE,
1930: IBY_PAYMENTS_ALL.payee_address3%TYPE,
1931: payee_add_line_4
1932: IBY_PAYMENTS_ALL.payee_address4%TYPE,
1933: payee_city
1934: IBY_PAYMENTS_ALL.payee_city%TYPE,
1935: payee_county
1936: IBY_PAYMENTS_ALL.payee_county%TYPE,
1937: payee_province
1938: IBY_PAYMENTS_ALL.payee_province%TYPE,
1932: IBY_PAYMENTS_ALL.payee_address4%TYPE,
1933: payee_city
1934: IBY_PAYMENTS_ALL.payee_city%TYPE,
1935: payee_county
1936: IBY_PAYMENTS_ALL.payee_county%TYPE,
1937: payee_province
1938: IBY_PAYMENTS_ALL.payee_province%TYPE,
1939: payee_state -- 40
1940: IBY_PAYMENTS_ALL.payee_state%TYPE,
1934: IBY_PAYMENTS_ALL.payee_city%TYPE,
1935: payee_county
1936: IBY_PAYMENTS_ALL.payee_county%TYPE,
1937: payee_province
1938: IBY_PAYMENTS_ALL.payee_province%TYPE,
1939: payee_state -- 40
1940: IBY_PAYMENTS_ALL.payee_state%TYPE,
1941: payee_country
1942: IBY_PAYMENTS_ALL.payee_country%TYPE,
1936: IBY_PAYMENTS_ALL.payee_county%TYPE,
1937: payee_province
1938: IBY_PAYMENTS_ALL.payee_province%TYPE,
1939: payee_state -- 40
1940: IBY_PAYMENTS_ALL.payee_state%TYPE,
1941: payee_country
1942: IBY_PAYMENTS_ALL.payee_country%TYPE,
1943: payee_postal_code
1944: IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
1938: IBY_PAYMENTS_ALL.payee_province%TYPE,
1939: payee_state -- 40
1940: IBY_PAYMENTS_ALL.payee_state%TYPE,
1941: payee_country
1942: IBY_PAYMENTS_ALL.payee_country%TYPE,
1943: payee_postal_code
1944: IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
1945: payee_address_concat
1946: IBY_PAYMENTS_ALL.payee_address_concat%TYPE,
1940: IBY_PAYMENTS_ALL.payee_state%TYPE,
1941: payee_country
1942: IBY_PAYMENTS_ALL.payee_country%TYPE,
1943: payee_postal_code
1944: IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
1945: payee_address_concat
1946: IBY_PAYMENTS_ALL.payee_address_concat%TYPE,
1947: beneficiary_name
1948: IBY_PAYMENTS_ALL.beneficiary_name%TYPE,
1942: IBY_PAYMENTS_ALL.payee_country%TYPE,
1943: payee_postal_code
1944: IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
1945: payee_address_concat
1946: IBY_PAYMENTS_ALL.payee_address_concat%TYPE,
1947: beneficiary_name
1948: IBY_PAYMENTS_ALL.beneficiary_name%TYPE,
1949: payee_party_attr_cat
1950: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
1944: IBY_PAYMENTS_ALL.payee_postal_code%TYPE,
1945: payee_address_concat
1946: IBY_PAYMENTS_ALL.payee_address_concat%TYPE,
1947: beneficiary_name
1948: IBY_PAYMENTS_ALL.beneficiary_name%TYPE,
1949: payee_party_attr_cat
1950: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
1951: payee_supplier_site_attr_cat
1952: IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
1946: IBY_PAYMENTS_ALL.payee_address_concat%TYPE,
1947: beneficiary_name
1948: IBY_PAYMENTS_ALL.beneficiary_name%TYPE,
1949: payee_party_attr_cat
1950: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
1951: payee_supplier_site_attr_cat
1952: IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
1953: payee_supplier_site_name
1954: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
1948: IBY_PAYMENTS_ALL.beneficiary_name%TYPE,
1949: payee_party_attr_cat
1950: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
1951: payee_supplier_site_attr_cat
1952: IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
1953: payee_supplier_site_name
1954: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
1955: payee_party_site_name
1956: IBY_PAYMENTS_ALL.payee_party_site_name%TYPE,
1950: IBY_PAYMENTS_ALL.payee_party_attr_category%TYPE,
1951: payee_supplier_site_attr_cat
1952: IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
1953: payee_supplier_site_name
1954: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
1955: payee_party_site_name
1956: IBY_PAYMENTS_ALL.payee_party_site_name%TYPE,
1957: payee_addressee
1958: IBY_PAYMENTS_ALL.payee_addressee%TYPE,
1952: IBY_PAYMENTS_ALL.payee_spplr_site_attr_category%TYPE,
1953: payee_supplier_site_name
1954: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
1955: payee_party_site_name
1956: IBY_PAYMENTS_ALL.payee_party_site_name%TYPE,
1957: payee_addressee
1958: IBY_PAYMENTS_ALL.payee_addressee%TYPE,
1959:
1960: /* VENDOR RELATED */
1954: IBY_PAYMENTS_ALL.payee_supplier_site_name%TYPE,
1955: payee_party_site_name
1956: IBY_PAYMENTS_ALL.payee_party_site_name%TYPE,
1957: payee_addressee
1958: IBY_PAYMENTS_ALL.payee_addressee%TYPE,
1959:
1960: /* VENDOR RELATED */
1961: payee_site_name_alternate
1962: IBY_PAYMENTS_ALL.payee_site_alternate_name%TYPE,
1958: IBY_PAYMENTS_ALL.payee_addressee%TYPE,
1959:
1960: /* VENDOR RELATED */
1961: payee_site_name_alternate
1962: IBY_PAYMENTS_ALL.payee_site_alternate_name%TYPE,
1963: payee_supplier_number
1964: IBY_PAYMENTS_ALL.payee_supplier_number%TYPE,
1965: payee_first_party_ref -- 50
1966: IBY_PAYMENTS_ALL.payee_first_party_reference%TYPE,
1960: /* VENDOR RELATED */
1961: payee_site_name_alternate
1962: IBY_PAYMENTS_ALL.payee_site_alternate_name%TYPE,
1963: payee_supplier_number
1964: IBY_PAYMENTS_ALL.payee_supplier_number%TYPE,
1965: payee_first_party_ref -- 50
1966: IBY_PAYMENTS_ALL.payee_first_party_reference%TYPE,
1967: payee_supplier_attr_cat
1968: IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
1962: IBY_PAYMENTS_ALL.payee_site_alternate_name%TYPE,
1963: payee_supplier_number
1964: IBY_PAYMENTS_ALL.payee_supplier_number%TYPE,
1965: payee_first_party_ref -- 50
1966: IBY_PAYMENTS_ALL.payee_first_party_reference%TYPE,
1967: payee_supplier_attr_cat
1968: IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
1969: payee_supplier_id
1970: IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
1964: IBY_PAYMENTS_ALL.payee_supplier_number%TYPE,
1965: payee_first_party_ref -- 50
1966: IBY_PAYMENTS_ALL.payee_first_party_reference%TYPE,
1967: payee_supplier_attr_cat
1968: IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
1969: payee_supplier_id
1970: IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
1971:
1972: /* PAYEE SPECIAL FIELDS */
1966: IBY_PAYMENTS_ALL.payee_first_party_reference%TYPE,
1967: payee_supplier_attr_cat
1968: IBY_PAYMENTS_ALL.payee_supplier_attr_category%TYPE,
1969: payee_supplier_id
1970: IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
1971:
1972: /* PAYEE SPECIAL FIELDS */
1973: payee_tax_reg_number
1974: IBY_PAYMENTS_ALL.payee_tax_registration_num%TYPE,
1970: IBY_PAYMENTS_ALL.payee_supplier_id%TYPE,
1971:
1972: /* PAYEE SPECIAL FIELDS */
1973: payee_tax_reg_number
1974: IBY_PAYMENTS_ALL.payee_tax_registration_num%TYPE,
1975: payee_le_reg_number
1976: IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
1977:
1978: /* PAYEE BANK RELATED */
1972: /* PAYEE SPECIAL FIELDS */
1973: payee_tax_reg_number
1974: IBY_PAYMENTS_ALL.payee_tax_registration_num%TYPE,
1975: payee_le_reg_number
1976: IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
1977:
1978: /* PAYEE BANK RELATED */
1979: payee_bank_name
1980: IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
1976: IBY_PAYMENTS_ALL.payee_le_registration_num%TYPE,
1977:
1978: /* PAYEE BANK RELATED */
1979: payee_bank_name
1980: IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
1981: payee_bank_number
1982: IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
1983: payee_bank_branch_number
1984: IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
1978: /* PAYEE BANK RELATED */
1979: payee_bank_name
1980: IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
1981: payee_bank_number
1982: IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
1983: payee_bank_branch_number
1984: IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
1985: payee_bank_branch_name
1986: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
1980: IBY_PAYMENTS_ALL.ext_bank_name%TYPE,
1981: payee_bank_number
1982: IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
1983: payee_bank_branch_number
1984: IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
1985: payee_bank_branch_name
1986: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
1987: payee_bank_acct_number
1988: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
1982: IBY_PAYMENTS_ALL.ext_bank_number%TYPE,
1983: payee_bank_branch_number
1984: IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
1985: payee_bank_branch_name
1986: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
1987: payee_bank_acct_number
1988: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
1989: payee_bank_acct_name -- 60
1990: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
1984: IBY_PAYMENTS_ALL.ext_branch_number%TYPE,
1985: payee_bank_branch_name
1986: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
1987: payee_bank_acct_number
1988: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
1989: payee_bank_acct_name -- 60
1990: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
1991: payee_bank_acct_iban
1992: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
1986: IBY_PAYMENTS_ALL.ext_bank_branch_name%TYPE,
1987: payee_bank_acct_number
1988: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
1989: payee_bank_acct_name -- 60
1990: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
1991: payee_bank_acct_iban
1992: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
1993: payee_bank_swift_code
1994: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
1988: IBY_PAYMENTS_ALL.ext_bank_account_number%TYPE,
1989: payee_bank_acct_name -- 60
1990: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
1991: payee_bank_acct_iban
1992: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
1993: payee_bank_swift_code
1994: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
1995: payee_bank_acct_type
1996: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
1990: IBY_PAYMENTS_ALL.ext_bank_account_name%TYPE,
1991: payee_bank_acct_iban
1992: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
1993: payee_bank_swift_code
1994: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
1995: payee_bank_acct_type
1996: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
1997: payee_bank_payment_factor_flag
1998: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
1992: IBY_PAYMENTS_ALL.ext_bank_account_iban_number%TYPE,
1993: payee_bank_swift_code
1994: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
1995: payee_bank_acct_type
1996: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
1997: payee_bank_payment_factor_flag
1998: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
1999: payee_bank_owner_party_id
2000: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
1994: IBY_PAYMENTS_ALL.ext_eft_swift_code%TYPE,
1995: payee_bank_acct_type
1996: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
1997: payee_bank_payment_factor_flag
1998: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
1999: payee_bank_owner_party_id
2000: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
2001: payee_bank_branch_party_id
2002: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
1996: IBY_PAYMENTS_ALL.ext_bank_account_type%TYPE,
1997: payee_bank_payment_factor_flag
1998: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
1999: payee_bank_owner_party_id
2000: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
2001: payee_bank_branch_party_id
2002: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
2003: payee_bank_name_alt
2004: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
1998: IBY_PAYMENTS_ALL.ext_bank_acct_pmt_factor_flag%TYPE,
1999: payee_bank_owner_party_id
2000: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
2001: payee_bank_branch_party_id
2002: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
2003: payee_bank_name_alt
2004: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
2005: payee_bank_branch_name_alt
2006: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
2000: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_id%TYPE,
2001: payee_bank_branch_party_id
2002: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
2003: payee_bank_name_alt
2004: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
2005: payee_bank_branch_name_alt
2006: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
2007: payee_bank_alt_account_name
2008: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
2002: IBY_PAYMENTS_ALL.ext_bank_branch_party_id%TYPE,
2003: payee_bank_name_alt
2004: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
2005: payee_bank_branch_name_alt
2006: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
2007: payee_bank_alt_account_name
2008: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
2009: payee_bank_electronic_acct_num -- 70
2010: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
2004: IBY_PAYMENTS_ALL.ext_bank_alt_name%TYPE,
2005: payee_bank_branch_name_alt
2006: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
2007: payee_bank_alt_account_name
2008: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
2009: payee_bank_electronic_acct_num -- 70
2010: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
2011: payee_bank_branch_location_id
2012: IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
2006: IBY_PAYMENTS_ALL.ext_bank_branch_alt_name%TYPE,
2007: payee_bank_alt_account_name
2008: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
2009: payee_bank_electronic_acct_num -- 70
2010: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
2011: payee_bank_branch_location_id
2012: IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
2013: payee_bank_acct_owner_name
2014: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE,
2008: IBY_PAYMENTS_ALL.ext_bank_account_alt_name%TYPE,
2009: payee_bank_electronic_acct_num -- 70
2010: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
2011: payee_bank_branch_location_id
2012: IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
2013: payee_bank_acct_owner_name
2014: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE,
2015:
2016:
2010: IBY_PAYMENTS_ALL.ext_bank_account_num_elec%TYPE,
2011: payee_bank_branch_location_id
2012: IBY_PAYMENTS_ALL.ext_bank_branch_location_id%TYPE,
2013: payee_bank_acct_owner_name
2014: IBY_PAYMENTS_ALL.ext_bank_acct_owner_party_name%TYPE,
2015:
2016:
2017: /* REMITTANCE ADVICE RELATED */
2018: remit_advice_delivery_method
2015:
2016:
2017: /* REMITTANCE ADVICE RELATED */
2018: remit_advice_delivery_method
2019: IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
2020: remit_advice_email
2021: IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
2022: remit_advice_fax
2023: IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
2017: /* REMITTANCE ADVICE RELATED */
2018: remit_advice_delivery_method
2019: IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
2020: remit_advice_email
2021: IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
2022: remit_advice_fax
2023: IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
2024:
2025: /*
2019: IBY_PAYMENTS_ALL.remit_advice_delivery_method%TYPE,
2020: remit_advice_email
2021: IBY_PAYMENTS_ALL.remit_advice_email%TYPE,
2022: remit_advice_fax
2023: IBY_PAYMENTS_ALL.remit_advice_fax%TYPE,
2024:
2025: /*
2026: * Fix for bug 5522421:
2027: *
2029: * remit_advice_delivery_method and is
2030: * being obsoleted.
2031: */
2032: --remit_advice_delv_method
2033: -- IBY_PAYMENTS_ALL.sra_delivery_method%TYPE,
2034:
2035: /* DELIVERY CHANNEL RELATED */
2036: delivery_channel_format
2037: IBY_PAYMENTS_ALL.delivery_channel_format_value%TYPE,
2033: -- IBY_PAYMENTS_ALL.sra_delivery_method%TYPE,
2034:
2035: /* DELIVERY CHANNEL RELATED */
2036: delivery_channel_format
2037: IBY_PAYMENTS_ALL.delivery_channel_format_value%TYPE,
2038:
2039: /* DECLARATION REPORT RELATED */
2040: decl_curr_fx_rate_type
2041: IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
2037: IBY_PAYMENTS_ALL.delivery_channel_format_value%TYPE,
2038:
2039: /* DECLARATION REPORT RELATED */
2040: decl_curr_fx_rate_type
2041: IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
2042: declaration_format
2043: IBY_PAYMENTS_ALL.declaration_format%TYPE,
2044:
2045: /* PROFILE RELATED */
2039: /* DECLARATION REPORT RELATED */
2040: decl_curr_fx_rate_type
2041: IBY_PAYMENTS_ALL.declaration_exch_rate_type%TYPE,
2042: declaration_format
2043: IBY_PAYMENTS_ALL.declaration_format%TYPE,
2044:
2045: /* PROFILE RELATED */
2046: payment_acct_profile_name -- 80
2047: IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
2043: IBY_PAYMENTS_ALL.declaration_format%TYPE,
2044:
2045: /* PROFILE RELATED */
2046: payment_acct_profile_name -- 80
2047: IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
2048: payment_sys_profile_name
2049: IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE,
2050:
2051: /* PAYMENT REASON */
2045: /* PROFILE RELATED */
2046: payment_acct_profile_name -- 80
2047: IBY_PAYMENTS_ALL.payment_profile_acct_name%TYPE,
2048: payment_sys_profile_name
2049: IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE,
2050:
2051: /* PAYMENT REASON */
2052: payment_reason_format
2053: IBY_PAYMENTS_ALL.payment_reason_format_value%TYPE,
2049: IBY_PAYMENTS_ALL.payment_profile_sys_name%TYPE,
2050:
2051: /* PAYMENT REASON */
2052: payment_reason_format
2053: IBY_PAYMENTS_ALL.payment_reason_format_value%TYPE,
2054:
2055: /* BANK INSTRUCTION */
2056: bank_instr1_format
2057: IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
2053: IBY_PAYMENTS_ALL.payment_reason_format_value%TYPE,
2054:
2055: /* BANK INSTRUCTION */
2056: bank_instr1_format
2057: IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
2058: bank_instr2_format
2059: IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
2060:
2061: /* ORG */
2055: /* BANK INSTRUCTION */
2056: bank_instr1_format
2057: IBY_PAYMENTS_ALL.bank_instruction1_format_value%TYPE,
2058: bank_instr2_format
2059: IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
2060:
2061: /* ORG */
2062: org_name
2063: IBY_PAYMENTS_ALL.org_name%TYPE,
2059: IBY_PAYMENTS_ALL.bank_instruction2_format_value%TYPE,
2060:
2061: /* ORG */
2062: org_name
2063: IBY_PAYMENTS_ALL.org_name%TYPE,
2064:
2065: /* RFC */
2066: payer_bank_branch_rfc_id
2067: IBY_PAYMENTS_ALL.int_bank_branch_rfc_identifier%TYPE,
2063: IBY_PAYMENTS_ALL.org_name%TYPE,
2064:
2065: /* RFC */
2066: payer_bank_branch_rfc_id
2067: IBY_PAYMENTS_ALL.int_bank_branch_rfc_identifier%TYPE,
2068:
2069: /* REQUEST */
2070: ppr_name
2071: IBY_PAYMENTS_ALL.payment_process_request_name%TYPE,
2067: IBY_PAYMENTS_ALL.int_bank_branch_rfc_identifier%TYPE,
2068:
2069: /* REQUEST */
2070: ppr_name
2071: IBY_PAYMENTS_ALL.payment_process_request_name%TYPE,
2072: source_product -- 88
2073: IBY_PAYMENTS_ALL.source_product%TYPE,
2074: /*TPP-Start*/
2075:
2069: /* REQUEST */
2070: ppr_name
2071: IBY_PAYMENTS_ALL.payment_process_request_name%TYPE,
2072: source_product -- 88
2073: IBY_PAYMENTS_ALL.source_product%TYPE,
2074: /*TPP-Start*/
2075:
2076: inv_payee_name
2077: IBY_PAYMENTS_ALL.inv_payee_name%TYPE,
2073: IBY_PAYMENTS_ALL.source_product%TYPE,
2074: /*TPP-Start*/
2075:
2076: inv_payee_name
2077: IBY_PAYMENTS_ALL.inv_payee_name%TYPE,
2078: inv_payee_address1
2079: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE,
2080: inv_payee_address2
2081: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE,
2075:
2076: inv_payee_name
2077: IBY_PAYMENTS_ALL.inv_payee_name%TYPE,
2078: inv_payee_address1
2079: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE,
2080: inv_payee_address2
2081: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE,
2082: inv_payee_address3
2083: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE,
2077: IBY_PAYMENTS_ALL.inv_payee_name%TYPE,
2078: inv_payee_address1
2079: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE,
2080: inv_payee_address2
2081: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE,
2082: inv_payee_address3
2083: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE,
2084: inv_payee_address4
2085: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE,
2079: IBY_PAYMENTS_ALL.inv_payee_address1%TYPE,
2080: inv_payee_address2
2081: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE,
2082: inv_payee_address3
2083: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE,
2084: inv_payee_address4
2085: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE,
2086: inv_payee_city
2087: IBY_PAYMENTS_ALL.inv_payee_city%TYPE,
2081: IBY_PAYMENTS_ALL.inv_payee_address2%TYPE,
2082: inv_payee_address3
2083: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE,
2084: inv_payee_address4
2085: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE,
2086: inv_payee_city
2087: IBY_PAYMENTS_ALL.inv_payee_city%TYPE,
2088: inv_payee_postal_code
2089: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE,
2083: IBY_PAYMENTS_ALL.inv_payee_address3%TYPE,
2084: inv_payee_address4
2085: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE,
2086: inv_payee_city
2087: IBY_PAYMENTS_ALL.inv_payee_city%TYPE,
2088: inv_payee_postal_code
2089: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE,
2090: inv_payee_state
2091: IBY_PAYMENTS_ALL.inv_payee_state%TYPE,
2085: IBY_PAYMENTS_ALL.inv_payee_address4%TYPE,
2086: inv_payee_city
2087: IBY_PAYMENTS_ALL.inv_payee_city%TYPE,
2088: inv_payee_postal_code
2089: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE,
2090: inv_payee_state
2091: IBY_PAYMENTS_ALL.inv_payee_state%TYPE,
2092: inv_payee_province
2093: IBY_PAYMENTS_ALL.inv_payee_province%TYPE,
2087: IBY_PAYMENTS_ALL.inv_payee_city%TYPE,
2088: inv_payee_postal_code
2089: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE,
2090: inv_payee_state
2091: IBY_PAYMENTS_ALL.inv_payee_state%TYPE,
2092: inv_payee_province
2093: IBY_PAYMENTS_ALL.inv_payee_province%TYPE,
2094: inv_payee_county
2095: IBY_PAYMENTS_ALL.inv_payee_county%TYPE,
2089: IBY_PAYMENTS_ALL.inv_payee_postal_code%TYPE,
2090: inv_payee_state
2091: IBY_PAYMENTS_ALL.inv_payee_state%TYPE,
2092: inv_payee_province
2093: IBY_PAYMENTS_ALL.inv_payee_province%TYPE,
2094: inv_payee_county
2095: IBY_PAYMENTS_ALL.inv_payee_county%TYPE,
2096: inv_payee_country
2097: IBY_PAYMENTS_ALL.inv_payee_country%TYPE,
2091: IBY_PAYMENTS_ALL.inv_payee_state%TYPE,
2092: inv_payee_province
2093: IBY_PAYMENTS_ALL.inv_payee_province%TYPE,
2094: inv_payee_county
2095: IBY_PAYMENTS_ALL.inv_payee_county%TYPE,
2096: inv_payee_country
2097: IBY_PAYMENTS_ALL.inv_payee_country%TYPE,
2098: inv_payee_party_name
2099: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE,
2093: IBY_PAYMENTS_ALL.inv_payee_province%TYPE,
2094: inv_payee_county
2095: IBY_PAYMENTS_ALL.inv_payee_county%TYPE,
2096: inv_payee_country
2097: IBY_PAYMENTS_ALL.inv_payee_country%TYPE,
2098: inv_payee_party_name
2099: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE,
2100: inv_payee_le_reg_num
2101: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE,
2095: IBY_PAYMENTS_ALL.inv_payee_county%TYPE,
2096: inv_payee_country
2097: IBY_PAYMENTS_ALL.inv_payee_country%TYPE,
2098: inv_payee_party_name
2099: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE,
2100: inv_payee_le_reg_num
2101: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE,
2102: inv_payee_tax_reg_num
2103: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE,
2097: IBY_PAYMENTS_ALL.inv_payee_country%TYPE,
2098: inv_payee_party_name
2099: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE,
2100: inv_payee_le_reg_num
2101: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE,
2102: inv_payee_tax_reg_num
2103: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE,
2104: inv_payee_address_concat
2105: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE,
2099: IBY_PAYMENTS_ALL.inv_payee_party_name%TYPE,
2100: inv_payee_le_reg_num
2101: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE,
2102: inv_payee_tax_reg_num
2103: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE,
2104: inv_payee_address_concat
2105: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE,
2106: inv_beneficiary_name
2107: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE,
2101: IBY_PAYMENTS_ALL.inv_payee_le_reg_num%TYPE,
2102: inv_payee_tax_reg_num
2103: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE,
2104: inv_payee_address_concat
2105: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE,
2106: inv_beneficiary_name
2107: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE,
2108: inv_payee_party_number
2109: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE,
2103: IBY_PAYMENTS_ALL.inv_payee_tax_reg_num%TYPE,
2104: inv_payee_address_concat
2105: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE,
2106: inv_beneficiary_name
2107: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE,
2108: inv_payee_party_number
2109: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE,
2110: inv_payee_alternate_name
2111: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE,
2105: IBY_PAYMENTS_ALL.inv_payee_address_concat%TYPE,
2106: inv_beneficiary_name
2107: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE,
2108: inv_payee_party_number
2109: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE,
2110: inv_payee_alternate_name
2111: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE,
2112: inv_payee_site_alt_name
2113: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE,
2107: IBY_PAYMENTS_ALL.inv_beneficiary_name%TYPE,
2108: inv_payee_party_number
2109: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE,
2110: inv_payee_alternate_name
2111: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE,
2112: inv_payee_site_alt_name
2113: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE,
2114: inv_payee_supplier_number
2115: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE,
2109: IBY_PAYMENTS_ALL.inv_payee_party_number%TYPE,
2110: inv_payee_alternate_name
2111: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE,
2112: inv_payee_site_alt_name
2113: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE,
2114: inv_payee_supplier_number
2115: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE,
2116: inv_payee_first_party_ref
2117: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE,
2111: IBY_PAYMENTS_ALL.inv_payee_alternate_name%TYPE,
2112: inv_payee_site_alt_name
2113: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE,
2114: inv_payee_supplier_number
2115: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE,
2116: inv_payee_first_party_ref
2117: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE,
2118: ext_bnk_acct_ownr_inv_prty_id
2119: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE,
2113: IBY_PAYMENTS_ALL.inv_payee_site_alt_name%TYPE,
2114: inv_payee_supplier_number
2115: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE,
2116: inv_payee_first_party_ref
2117: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE,
2118: ext_bnk_acct_ownr_inv_prty_id
2119: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE,
2120: ext_bnk_branch_inv_prty_id
2121: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE,
2115: IBY_PAYMENTS_ALL.inv_payee_supplier_number%TYPE,
2116: inv_payee_first_party_ref
2117: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE,
2118: ext_bnk_acct_ownr_inv_prty_id
2119: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE,
2120: ext_bnk_branch_inv_prty_id
2121: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE,
2122: ext_bnk_acct_ownr_inv_prty_nme
2123: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE,
2117: IBY_PAYMENTS_ALL.inv_payee_first_party_ref%TYPE,
2118: ext_bnk_acct_ownr_inv_prty_id
2119: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE,
2120: ext_bnk_branch_inv_prty_id
2121: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE,
2122: ext_bnk_acct_ownr_inv_prty_nme
2123: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE,
2124: inv_payee_party_attr_cat
2125: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE,
2119: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_id%TYPE,
2120: ext_bnk_branch_inv_prty_id
2121: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE,
2122: ext_bnk_acct_ownr_inv_prty_nme
2123: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE,
2124: inv_payee_party_attr_cat
2125: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE,
2126: inv_payee_supplier_attr_cat
2127: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE,
2121: IBY_PAYMENTS_ALL.ext_bnk_branch_inv_prty_id%TYPE,
2122: ext_bnk_acct_ownr_inv_prty_nme
2123: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE,
2124: inv_payee_party_attr_cat
2125: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE,
2126: inv_payee_supplier_attr_cat
2127: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE,
2128: inv_payee_spplr_site_attr_cat
2129: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE,
2123: IBY_PAYMENTS_ALL.ext_bnk_acct_ownr_inv_prty_nme%TYPE,
2124: inv_payee_party_attr_cat
2125: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE,
2126: inv_payee_supplier_attr_cat
2127: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE,
2128: inv_payee_spplr_site_attr_cat
2129: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE,
2130: inv_payee_supplier_site_name
2131: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE,
2125: IBY_PAYMENTS_ALL.inv_payee_party_attr_cat%TYPE,
2126: inv_payee_supplier_attr_cat
2127: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE,
2128: inv_payee_spplr_site_attr_cat
2129: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE,
2130: inv_payee_supplier_site_name
2131: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE,
2132: inv_payee_spplr_site_alt_name
2133: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE,
2127: IBY_PAYMENTS_ALL.inv_payee_supplier_attr_cat%TYPE,
2128: inv_payee_spplr_site_attr_cat
2129: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE,
2130: inv_payee_supplier_site_name
2131: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE,
2132: inv_payee_spplr_site_alt_name
2133: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE,
2134: inv_payee_supplier_id
2135: IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
2129: IBY_PAYMENTS_ALL.inv_payee_spplr_site_attr_cat%TYPE,
2130: inv_payee_supplier_site_name
2131: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE,
2132: inv_payee_spplr_site_alt_name
2133: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE,
2134: inv_payee_supplier_id
2135: IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
2136: /*TPP-End*/
2137:
2131: IBY_PAYMENTS_ALL.inv_payee_supplier_site_name%TYPE,
2132: inv_payee_spplr_site_alt_name
2133: IBY_PAYMENTS_ALL.inv_payee_spplr_site_alt_name%TYPE,
2134: inv_payee_supplier_id
2135: IBY_PAYMENTS_ALL.inv_payee_supplier_id%TYPE
2136: /*TPP-End*/
2137:
2138: );
2139:
2146: --
2147: -- Central bank reporting record
2148: --
2149: TYPE centralBankReportRecType IS RECORD (
2150: payment_id IBY_PAYMENTS_ALL.
2151: payment_id%TYPE,
2152: decl_option IBY_PAYMENT_PROFILES.
2153: declaration_option%TYPE,
2154: decl_only_fx_flag IBY_PAYMENT_PROFILES.
2292: | NOTES: Mark for Removal after Dependencies Checking
2293: |
2294: *---------------------------------------------------------------------*/
2295: PROCEDURE insertDocIntoPayment(
2296: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
2297: x_paymentTab IN OUT NOCOPY paymentTabType,
2298: p_calcDocInfo IN VARCHAR2,
2299: p_newPaymentFlag IN BOOLEAN,
2300: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
2296: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
2297: x_paymentTab IN OUT NOCOPY paymentTabType,
2298: p_calcDocInfo IN VARCHAR2,
2299: p_newPaymentFlag IN BOOLEAN,
2300: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
2301: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2302: x_docsInPmtRec IN OUT NOCOPY docsInPaymentRecType,
2303: x_docsInPmtCount IN OUT NOCOPY NUMBER
2304: );
2321: | NOTES: Mark for Removal after Dependencies Checking
2322: |
2323: *---------------------------------------------------------------------*/
2324: PROCEDURE insertDocIntoPayment(
2325: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
2326: x_paymentTab IN OUT NOCOPY paymentTabType,
2327: p_calcDocInfo IN VARCHAR2,
2328: p_newPaymentFlag IN BOOLEAN,
2329: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
2325: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
2326: x_paymentTab IN OUT NOCOPY paymentTabType,
2327: p_calcDocInfo IN VARCHAR2,
2328: p_newPaymentFlag IN BOOLEAN,
2329: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
2330: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
2331: x_docsInPmtRec IN OUT NOCOPY docsInPaymentRecType,
2332: x_docsInPmtCount IN OUT NOCOPY NUMBER,
2333: x_commonAttributes IN OUT NOCOPY commonAttributesTabType
2353: | NOTES:
2354: |
2355: *---------------------------------------------------------------------*/
2356: PROCEDURE insertDocIntoPayment(
2357: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
2358: -- x_paymentTab IN OUT NOCOPY paymentTabType,
2359: p_calcDocInfo IN VARCHAR2,
2360: p_newPaymentFlag IN BOOLEAN,
2361: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
2357: x_paymentRec IN OUT NOCOPY IBY_PAYMENTS_ALL%ROWTYPE,
2358: -- x_paymentTab IN OUT NOCOPY paymentTabType,
2359: p_calcDocInfo IN VARCHAR2,
2360: p_newPaymentFlag IN BOOLEAN,
2361: x_currentPaymentId IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE,
2362: x_docsInPmtCount IN OUT NOCOPY NUMBER,
2363: x_commonAttributes IN OUT NOCOPY commonAttributesTabType,
2364: p_trx_line_index IN BINARY_INTEGER
2365: );
2417: | updatePayments
2418: |
2419: | PURPOSE:
2420: | Performs an update of all created payments from PLSQL
2421: | table into IBY_PAYMENTS_ALL table.
2422: |
2423: | The created payments have already been inserted into
2424: | IBY_PAYMENTS_ALL after grouping. So we only need to update
2425: | certain fields of the payment that have been changed
2420: | Performs an update of all created payments from PLSQL
2421: | table into IBY_PAYMENTS_ALL table.
2422: |
2423: | The created payments have already been inserted into
2424: | IBY_PAYMENTS_ALL after grouping. So we only need to update
2425: | certain fields of the payment that have been changed
2426: | after the grouping was performed.
2427: |
2428: | PARAMETERS:
2461: | NOTES:
2462: |
2463: *---------------------------------------------------------------------*/
2464: PROCEDURE getNextPaymentID(
2465: x_paymentID IN OUT NOCOPY IBY_PAYMENTS_ALL.payment_id%TYPE
2466: );
2467:
2468: /*--------------------------------------------------------------------
2469: | NAME:
3307: | NOTES: Mark for Removal after Dependencies Checking
3308: |
3309: *---------------------------------------------------------------------*/
3310: PROCEDURE failDocsOfPayment(
3311: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3312: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
3313: document_status%TYPE,
3314: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
3315: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3335: | NOTES:
3336: |
3337: *---------------------------------------------------------------------*/
3338: PROCEDURE failDocsOfPayment(
3339: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3340: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
3341: document_status%TYPE,
3342: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3343: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3473: | NOTES:
3474: |
3475: *---------------------------------------------------------------------*/
3476: FUNCTION checkIfPmtAlreadyFailed(
3477: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3478: p_paymentTab IN paymentTabType
3479: )
3480: RETURN BOOLEAN;
3481:
3499: | NOTES:
3500: |
3501: *---------------------------------------------------------------------*/
3502: FUNCTION checkIfPmtAlreadyAdded(
3503: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3504: p_paymentTab IN pmtIdsTab
3505: )
3506: RETURN BOOLEAN;
3507:
3649: | NOTES: Mark for Removal after Dependencies Checking
3650: |
3651: *---------------------------------------------------------------------*/
3652: FUNCTION getMaturityDaysForPmtMethod(
3653: p_pmt_method_code IN IBY_PAYMENTS_ALL.payment_method_code%TYPE,
3654: p_maturityDaysTab IN pmtMethodMaturityDaysTab
3655: ) RETURN NUMBER;
3656:
3657: /*--------------------------------------------------------------------
3673: | NOTES:
3674: |
3675: *---------------------------------------------------------------------*/
3676: FUNCTION getMaturityDaysForPmtMethod(
3677: p_pmt_method_code IN IBY_PAYMENTS_ALL.payment_method_code%TYPE
3678: ) RETURN NUMBER;
3679:
3680: /*--------------------------------------------------------------------
3681: | NAME:
3696: | NOTES:
3697: |
3698: *---------------------------------------------------------------------*/
3699: PROCEDURE refreshDocAndPmtAmounts(
3700: p_adjustedPmtId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3701: p_adjustedNegDocsTab IN docsInPaymentTabType,
3702: x_paymentTab IN OUT NOCOPY paymentTabType,
3703: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType
3704: );
4278:
4279:
4280:
4281: PROCEDURE populatepmtTable(
4282: ppr_id IN IBY_PAYMENTS_ALL.PAYMENT_SERVICE_REQUEST_ID%type
4283: );
4284:
4285: /*--------------------------------------------------------------------
4286: | NAME: