113: );
114:
115: -- External Bank Account Record
116: TYPE ExtBankAcct_rec_type IS RECORD (
117: bank_account_id iby_ext_bank_accounts.EXT_BANK_ACCOUNT_ID%TYPE,
118: country_code iby_ext_bank_accounts.COUNTRY_CODE%TYPE,
119: branch_id iby_ext_bank_accounts.BRANCH_ID%TYPE,
120: bank_id iby_ext_bank_accounts.BANK_ID%TYPE,
121: acct_owner_party_id iby_account_owners.ACCOUNT_OWNER_PARTY_ID%TYPE,
114:
115: -- External Bank Account Record
116: TYPE ExtBankAcct_rec_type IS RECORD (
117: bank_account_id iby_ext_bank_accounts.EXT_BANK_ACCOUNT_ID%TYPE,
118: country_code iby_ext_bank_accounts.COUNTRY_CODE%TYPE,
119: branch_id iby_ext_bank_accounts.BRANCH_ID%TYPE,
120: bank_id iby_ext_bank_accounts.BANK_ID%TYPE,
121: acct_owner_party_id iby_account_owners.ACCOUNT_OWNER_PARTY_ID%TYPE,
122: bank_account_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%TYPE,
115: -- External Bank Account Record
116: TYPE ExtBankAcct_rec_type IS RECORD (
117: bank_account_id iby_ext_bank_accounts.EXT_BANK_ACCOUNT_ID%TYPE,
118: country_code iby_ext_bank_accounts.COUNTRY_CODE%TYPE,
119: branch_id iby_ext_bank_accounts.BRANCH_ID%TYPE,
120: bank_id iby_ext_bank_accounts.BANK_ID%TYPE,
121: acct_owner_party_id iby_account_owners.ACCOUNT_OWNER_PARTY_ID%TYPE,
122: bank_account_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%TYPE,
123: bank_account_num iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
116: TYPE ExtBankAcct_rec_type IS RECORD (
117: bank_account_id iby_ext_bank_accounts.EXT_BANK_ACCOUNT_ID%TYPE,
118: country_code iby_ext_bank_accounts.COUNTRY_CODE%TYPE,
119: branch_id iby_ext_bank_accounts.BRANCH_ID%TYPE,
120: bank_id iby_ext_bank_accounts.BANK_ID%TYPE,
121: acct_owner_party_id iby_account_owners.ACCOUNT_OWNER_PARTY_ID%TYPE,
122: bank_account_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%TYPE,
123: bank_account_num iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
124: currency iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
118: country_code iby_ext_bank_accounts.COUNTRY_CODE%TYPE,
119: branch_id iby_ext_bank_accounts.BRANCH_ID%TYPE,
120: bank_id iby_ext_bank_accounts.BANK_ID%TYPE,
121: acct_owner_party_id iby_account_owners.ACCOUNT_OWNER_PARTY_ID%TYPE,
122: bank_account_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%TYPE,
123: bank_account_num iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
124: currency iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
125: bank_account_num_hash1 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH1%TYPE,
126: bank_account_num_hash2 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH2%TYPE,
119: branch_id iby_ext_bank_accounts.BRANCH_ID%TYPE,
120: bank_id iby_ext_bank_accounts.BANK_ID%TYPE,
121: acct_owner_party_id iby_account_owners.ACCOUNT_OWNER_PARTY_ID%TYPE,
122: bank_account_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%TYPE,
123: bank_account_num iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
124: currency iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
125: bank_account_num_hash1 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH1%TYPE,
126: bank_account_num_hash2 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH2%TYPE,
127: iban iby_ext_bank_accounts.IBAN%TYPE,
120: bank_id iby_ext_bank_accounts.BANK_ID%TYPE,
121: acct_owner_party_id iby_account_owners.ACCOUNT_OWNER_PARTY_ID%TYPE,
122: bank_account_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%TYPE,
123: bank_account_num iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
124: currency iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
125: bank_account_num_hash1 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH1%TYPE,
126: bank_account_num_hash2 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH2%TYPE,
127: iban iby_ext_bank_accounts.IBAN%TYPE,
128: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
121: acct_owner_party_id iby_account_owners.ACCOUNT_OWNER_PARTY_ID%TYPE,
122: bank_account_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%TYPE,
123: bank_account_num iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
124: currency iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
125: bank_account_num_hash1 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH1%TYPE,
126: bank_account_num_hash2 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH2%TYPE,
127: iban iby_ext_bank_accounts.IBAN%TYPE,
128: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
129: multi_currency_allowed_flag varchar2(1),
122: bank_account_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%TYPE,
123: bank_account_num iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
124: currency iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
125: bank_account_num_hash1 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH1%TYPE,
126: bank_account_num_hash2 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH2%TYPE,
127: iban iby_ext_bank_accounts.IBAN%TYPE,
128: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
129: multi_currency_allowed_flag varchar2(1),
130: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
123: bank_account_num iby_ext_bank_accounts.BANK_ACCOUNT_NUM%TYPE,
124: currency iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
125: bank_account_num_hash1 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH1%TYPE,
126: bank_account_num_hash2 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH2%TYPE,
127: iban iby_ext_bank_accounts.IBAN%TYPE,
128: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
129: multi_currency_allowed_flag varchar2(1),
130: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
131: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
124: currency iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
125: bank_account_num_hash1 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH1%TYPE,
126: bank_account_num_hash2 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH2%TYPE,
127: iban iby_ext_bank_accounts.IBAN%TYPE,
128: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
129: multi_currency_allowed_flag varchar2(1),
130: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
131: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
132: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
126: bank_account_num_hash2 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH2%TYPE,
127: iban iby_ext_bank_accounts.IBAN%TYPE,
128: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
129: multi_currency_allowed_flag varchar2(1),
130: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
131: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
132: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
133: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
134: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
127: iban iby_ext_bank_accounts.IBAN%TYPE,
128: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
129: multi_currency_allowed_flag varchar2(1),
130: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
131: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
132: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
133: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
134: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
135: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
128: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
129: multi_currency_allowed_flag varchar2(1),
130: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
131: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
132: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
133: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
134: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
135: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
136: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
129: multi_currency_allowed_flag varchar2(1),
130: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
131: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
132: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
133: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
134: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
135: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
136: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
137: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
130: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
131: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
132: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
133: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
134: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
135: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
136: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
137: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
138: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
131: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
132: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
133: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
134: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
135: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
136: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
137: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
138: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
139: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
132: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
133: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
134: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
135: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
136: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
137: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
138: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
139: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
140: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
133: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
134: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
135: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
136: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
137: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
138: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
139: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
140: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
141: status varchar2(1),
134: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
135: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
136: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
137: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
138: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
139: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
140: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
141: status varchar2(1),
142: end_date iby_ext_bank_accounts.END_DATE%TYPE,
135: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
136: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
137: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
138: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
139: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
140: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
141: status varchar2(1),
142: end_date iby_ext_bank_accounts.END_DATE%TYPE,
143: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
136: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
137: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
138: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
139: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
140: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
141: status varchar2(1),
142: end_date iby_ext_bank_accounts.END_DATE%TYPE,
143: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
144: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
138: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
139: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
140: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
141: status varchar2(1),
142: end_date iby_ext_bank_accounts.END_DATE%TYPE,
143: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
144: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
145: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
146: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
139: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
140: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
141: status varchar2(1),
142: end_date iby_ext_bank_accounts.END_DATE%TYPE,
143: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
144: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
145: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
146: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
147: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
140: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
141: status varchar2(1),
142: end_date iby_ext_bank_accounts.END_DATE%TYPE,
143: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
144: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
145: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
146: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
147: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
148: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
141: status varchar2(1),
142: end_date iby_ext_bank_accounts.END_DATE%TYPE,
143: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
144: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
145: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
146: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
147: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
148: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
149: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
142: end_date iby_ext_bank_accounts.END_DATE%TYPE,
143: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
144: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
145: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
146: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
147: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
148: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
149: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
150: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
143: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
144: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
145: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
146: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
147: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
148: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
149: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
150: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
151: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
144: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
145: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
146: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
147: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
148: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
149: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
150: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
151: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
152: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
145: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
146: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
147: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
148: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
149: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
150: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
151: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
152: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
153: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
146: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
147: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
148: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
149: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
150: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
151: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
152: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
153: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
154: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
147: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
148: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
149: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
150: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
151: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
152: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
153: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
154: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
155: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
148: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
149: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
150: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
151: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
152: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
153: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
154: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
155: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
156: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
149: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
150: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
151: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
152: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
153: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
154: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
155: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
156: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
157: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
150: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
151: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
152: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
153: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
154: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
155: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
156: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
157: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
158: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
151: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
152: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
153: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
154: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
155: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
156: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
157: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
158: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
159: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
152: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
153: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
154: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
155: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
156: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
157: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
158: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
159: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
160: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
153: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
154: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
155: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
156: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
157: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
158: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
159: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
160: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
161: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
154: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
155: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
156: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
157: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
158: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
159: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
160: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
161: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
162: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE, -- Bug 7408747(Added New Parameter to save Secondary Account Reference),
155: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
156: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
157: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
158: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
159: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
160: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
161: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
162: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE, -- Bug 7408747(Added New Parameter to save Secondary Account Reference),
163: contact_name iby_ext_bank_accounts.CONTACT_NAME%TYPE, -- New columns for CLM Reference Data Management uptake.
156: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
157: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
158: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
159: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
160: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
161: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
162: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE, -- Bug 7408747(Added New Parameter to save Secondary Account Reference),
163: contact_name iby_ext_bank_accounts.CONTACT_NAME%TYPE, -- New columns for CLM Reference Data Management uptake.
164: contact_phone iby_ext_bank_accounts.CONTACT_PHONE%TYPE,
157: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
158: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
159: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
160: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
161: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
162: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE, -- Bug 7408747(Added New Parameter to save Secondary Account Reference),
163: contact_name iby_ext_bank_accounts.CONTACT_NAME%TYPE, -- New columns for CLM Reference Data Management uptake.
164: contact_phone iby_ext_bank_accounts.CONTACT_PHONE%TYPE,
165: contact_email iby_ext_bank_accounts.CONTACT_EMAIL%TYPE,
158: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
159: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
160: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
161: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
162: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE, -- Bug 7408747(Added New Parameter to save Secondary Account Reference),
163: contact_name iby_ext_bank_accounts.CONTACT_NAME%TYPE, -- New columns for CLM Reference Data Management uptake.
164: contact_phone iby_ext_bank_accounts.CONTACT_PHONE%TYPE,
165: contact_email iby_ext_bank_accounts.CONTACT_EMAIL%TYPE,
166: contact_fax iby_ext_bank_accounts.CONTACT_FAX%TYPE
159: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
160: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
161: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
162: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE, -- Bug 7408747(Added New Parameter to save Secondary Account Reference),
163: contact_name iby_ext_bank_accounts.CONTACT_NAME%TYPE, -- New columns for CLM Reference Data Management uptake.
164: contact_phone iby_ext_bank_accounts.CONTACT_PHONE%TYPE,
165: contact_email iby_ext_bank_accounts.CONTACT_EMAIL%TYPE,
166: contact_fax iby_ext_bank_accounts.CONTACT_FAX%TYPE
167: );
160: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
161: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
162: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE, -- Bug 7408747(Added New Parameter to save Secondary Account Reference),
163: contact_name iby_ext_bank_accounts.CONTACT_NAME%TYPE, -- New columns for CLM Reference Data Management uptake.
164: contact_phone iby_ext_bank_accounts.CONTACT_PHONE%TYPE,
165: contact_email iby_ext_bank_accounts.CONTACT_EMAIL%TYPE,
166: contact_fax iby_ext_bank_accounts.CONTACT_FAX%TYPE
167: );
168:
161: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
162: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE, -- Bug 7408747(Added New Parameter to save Secondary Account Reference),
163: contact_name iby_ext_bank_accounts.CONTACT_NAME%TYPE, -- New columns for CLM Reference Data Management uptake.
164: contact_phone iby_ext_bank_accounts.CONTACT_PHONE%TYPE,
165: contact_email iby_ext_bank_accounts.CONTACT_EMAIL%TYPE,
166: contact_fax iby_ext_bank_accounts.CONTACT_FAX%TYPE
167: );
168:
169: -- Intermediary Bank Account Record
162: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE, -- Bug 7408747(Added New Parameter to save Secondary Account Reference),
163: contact_name iby_ext_bank_accounts.CONTACT_NAME%TYPE, -- New columns for CLM Reference Data Management uptake.
164: contact_phone iby_ext_bank_accounts.CONTACT_PHONE%TYPE,
165: contact_email iby_ext_bank_accounts.CONTACT_EMAIL%TYPE,
166: contact_fax iby_ext_bank_accounts.CONTACT_FAX%TYPE
167: );
168:
169: -- Intermediary Bank Account Record
170: TYPE IntermediaryAcct_rec_type IS RECORD(
735: -- Purpose : Masks secured bank account attributes
736: --
737: FUNCTION Mask_Bank_Number
738: (p_bank_number IN VARCHAR2,
739: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
740: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
741: )
742: RETURN VARCHAR2;
743:
736: --
737: FUNCTION Mask_Bank_Number
738: (p_bank_number IN VARCHAR2,
739: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
740: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
741: )
742: RETURN VARCHAR2;
743:
744: --
760: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
761: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
762: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
763: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
764: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
765: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
766: )
767: RETURN VARCHAR2;
768:
761: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
762: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
763: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
764: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
765: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
766: )
767: RETURN VARCHAR2;
768:
769: -- 103. Remask_Accounts
818:
819:
820: --
821: FUNCTION find_assignment_OU
822: ( p_ext_bank_acct_id IN iby_ext_bank_accounts.ext_bank_account_id%TYPE
823: )
824: RETURN NUMBER;
825: /*Bug 14456128 Introduced new procedure Uncipher_Bank_ACCT_Number for
826: decrypting Bank Account Number */
824: RETURN NUMBER;
825: /*Bug 14456128 Introduced new procedure Uncipher_Bank_ACCT_Number for
826: decrypting Bank Account Number */
827: FUNCTION Uncipher_Bank_ACCT_Number(
828: p_ext_bank_acct_id IN iby_ext_bank_accounts.ext_bank_account_id%TYPE,
829: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE )
830: RETURN VARCHAR2;
831:
832: END IBY_EXT_BANKACCT_PUB;