eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_EXT_BANKACCT_PUB dependencies on IBY_EXT_BANK_ACCOUNTS

Line 117: bank_account_id iby_ext_bank_accounts.EXT_BANK_ACCOUNT_ID%TYPE,

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,

Line 118: country_code iby_ext_bank_accounts.COUNTRY_CODE%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,

Line 119: branch_id iby_ext_bank_accounts.BRANCH_ID%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,

Line 120: bank_id iby_ext_bank_accounts.BANK_ID%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,

Line 122: bank_account_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME%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,

Line 123: bank_account_num iby_ext_bank_accounts.BANK_ACCOUNT_NUM%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,

Line 124: currency iby_ext_bank_accounts.CURRENCY_CODE%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,

Line 125: bank_account_num_hash1 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH1%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),

Line 126: bank_account_num_hash2 iby_ext_bank_accounts.BANK_ACCOUNT_NUM_HASH2%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),
130: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,

Line 127: iban iby_ext_bank_accounts.IBAN%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,

Line 128: check_digits iby_ext_bank_accounts.CHECK_DIGITS%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,

Line 130: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%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,

Line 131: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%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,

Line 132: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%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,

Line 133: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%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,

Line 134: description iby_ext_bank_accounts.DESCRIPTION%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,

Line 135: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%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,

Line 136: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%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,

Line 137: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%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),

Line 138: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%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),
142: end_date iby_ext_bank_accounts.END_DATE%TYPE,

Line 139: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%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,

Line 140: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%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,

Line 142: end_date iby_ext_bank_accounts.END_DATE%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,

Line 143: START_DATE iby_ext_bank_accounts.START_DATE%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,

Line 144: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%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,

Line 145: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%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,

Line 146: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%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,

Line 147: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%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,

Line 148: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%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,

Line 149: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%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,

Line 150: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%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,

Line 151: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%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,

Line 152: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%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,

Line 153: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%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,

Line 154: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%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,

Line 155: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%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,

Line 156: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%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,

Line 157: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%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,

Line 158: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%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),

Line 159: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%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),
163: contact_name iby_ext_bank_accounts.CONTACT_NAME%TYPE, -- New columns for CLM Reference Data Management uptake.

Line 160: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%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.
164: contact_phone iby_ext_bank_accounts.CONTACT_PHONE%TYPE,

Line 161: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%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,

Line 162: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE, -- Bug 7408747(Added New Parameter to save Secondary Account Reference),

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

Line 163: contact_name iby_ext_bank_accounts.CONTACT_NAME%TYPE, -- New columns for CLM Reference Data Management uptake.

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: );

Line 164: contact_phone iby_ext_bank_accounts.CONTACT_PHONE%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: );
168:

Line 165: contact_email iby_ext_bank_accounts.CONTACT_EMAIL%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:
169: -- Intermediary Bank Account Record

Line 166: contact_fax iby_ext_bank_accounts.CONTACT_FAX%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
170: TYPE IntermediaryAcct_rec_type IS RECORD(

Line 739: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,

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:

Line 740: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE

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: --

Line 764: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,

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:

Line 765: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%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:
769: -- 103. Remask_Accounts

Line 822: ( p_ext_bank_acct_id IN iby_ext_bank_accounts.ext_bank_account_id%TYPE

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 */

Line 828: p_ext_bank_acct_id IN iby_ext_bank_accounts.ext_bank_account_id%TYPE,

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;