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: iban iby_ext_bank_accounts.IBAN%TYPE,
126: check_digits iby_ext_bank_accounts.CHECK_DIGITS%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: iban iby_ext_bank_accounts.IBAN%TYPE,
126: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
127: multi_currency_allowed_flag varchar2(1),

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: iban iby_ext_bank_accounts.IBAN%TYPE,
126: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
127: multi_currency_allowed_flag varchar2(1),
128: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,

Line 125: iban iby_ext_bank_accounts.IBAN%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: iban iby_ext_bank_accounts.IBAN%TYPE,
126: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
127: multi_currency_allowed_flag varchar2(1),
128: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
129: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,

Line 126: check_digits iby_ext_bank_accounts.CHECK_DIGITS%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: iban iby_ext_bank_accounts.IBAN%TYPE,
126: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
127: multi_currency_allowed_flag varchar2(1),
128: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
129: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
130: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,

Line 128: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,

124: currency iby_ext_bank_accounts.CURRENCY_CODE%TYPE,
125: iban iby_ext_bank_accounts.IBAN%TYPE,
126: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
127: multi_currency_allowed_flag varchar2(1),
128: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
129: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
130: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
131: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
132: description iby_ext_bank_accounts.DESCRIPTION%TYPE,

Line 129: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,

125: iban iby_ext_bank_accounts.IBAN%TYPE,
126: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
127: multi_currency_allowed_flag varchar2(1),
128: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
129: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
130: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
131: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
132: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
133: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,

Line 130: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,

126: check_digits iby_ext_bank_accounts.CHECK_DIGITS%TYPE,
127: multi_currency_allowed_flag varchar2(1),
128: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
129: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
130: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
131: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
132: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
133: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
134: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,

Line 131: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,

127: multi_currency_allowed_flag varchar2(1),
128: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
129: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
130: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
131: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
132: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
133: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
134: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
135: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,

Line 132: description iby_ext_bank_accounts.DESCRIPTION%TYPE,

128: alternate_acct_name iby_ext_bank_accounts.BANK_ACCOUNT_NAME_ALT%TYPE,
129: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
130: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
131: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
132: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
133: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
134: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
135: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
136: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,

Line 133: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,

129: short_acct_name iby_ext_bank_accounts.SHORT_ACCT_NAME%TYPE,
130: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
131: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
132: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
133: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
134: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
135: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
136: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
137: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,

Line 134: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,

130: acct_type iby_ext_bank_accounts.BANK_ACCOUNT_TYPE%TYPE,
131: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
132: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
133: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
134: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
135: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
136: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
137: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
138: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,

Line 135: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,

131: acct_suffix iby_ext_bank_accounts.ACCOUNT_SUFFIX%TYPE,
132: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
133: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
134: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
135: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
136: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
137: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
138: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
139: status varchar2(1),

Line 136: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,

132: description iby_ext_bank_accounts.DESCRIPTION%TYPE,
133: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
134: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
135: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
136: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
137: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
138: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
139: status varchar2(1),
140: end_date iby_ext_bank_accounts.END_DATE%TYPE,

Line 137: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,

133: agency_location_code iby_ext_bank_accounts.AGENCY_LOCATION_CODE%TYPE,
134: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
135: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
136: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
137: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
138: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
139: status varchar2(1),
140: end_date iby_ext_bank_accounts.END_DATE%TYPE,
141: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,

Line 138: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,

134: foreign_payment_use_flag iby_ext_bank_accounts.FOREIGN_PAYMENT_USE_FLAG%TYPE,
135: exchange_rate_agreement_num iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_NUM%TYPE,
136: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
137: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
138: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
139: status varchar2(1),
140: end_date iby_ext_bank_accounts.END_DATE%TYPE,
141: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
142: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,

Line 140: end_date iby_ext_bank_accounts.END_DATE%TYPE,

136: exchange_rate_agreement_type iby_ext_bank_accounts.EXCHANGE_RATE_AGREEMENT_TYPE%TYPE,
137: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
138: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
139: status varchar2(1),
140: end_date iby_ext_bank_accounts.END_DATE%TYPE,
141: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
142: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
143: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
144: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,

Line 141: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,

137: exchange_rate iby_ext_bank_accounts.EXCHANGE_RATE%TYPE,
138: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
139: status varchar2(1),
140: end_date iby_ext_bank_accounts.END_DATE%TYPE,
141: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
142: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
143: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
144: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
145: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,

Line 142: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,

138: payment_factor_flag iby_ext_bank_accounts.PAYMENT_FACTOR_FLAG%TYPE,
139: status varchar2(1),
140: end_date iby_ext_bank_accounts.END_DATE%TYPE,
141: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
142: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
143: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
144: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
145: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
146: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,

Line 143: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,

139: status varchar2(1),
140: end_date iby_ext_bank_accounts.END_DATE%TYPE,
141: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
142: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
143: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
144: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
145: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
146: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
147: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,

Line 144: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,

140: end_date iby_ext_bank_accounts.END_DATE%TYPE,
141: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
142: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
143: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
144: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
145: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
146: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
147: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
148: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,

Line 145: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,

141: START_DATE iby_ext_bank_accounts.START_DATE%TYPE,
142: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
143: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
144: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
145: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
146: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
147: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
148: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
149: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,

Line 146: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,

142: hedging_contract_reference iby_ext_bank_accounts.HEDGING_CONTRACT_REFERENCE%TYPE,
143: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
144: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
145: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
146: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
147: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
148: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
149: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
150: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,

Line 147: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,

143: attribute_category iby_ext_bank_accounts.ATTRIBUTE_CATEGORY%TYPE,
144: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
145: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
146: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
147: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
148: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
149: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
150: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
151: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,

Line 148: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,

144: attribute1 iby_ext_bank_accounts.ATTRIBUTE1%TYPE,
145: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
146: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
147: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
148: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
149: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
150: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
151: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
152: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,

Line 149: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,

145: attribute2 iby_ext_bank_accounts.ATTRIBUTE2%TYPE,
146: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
147: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
148: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
149: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
150: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
151: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
152: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
153: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,

Line 150: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,

146: attribute3 iby_ext_bank_accounts.ATTRIBUTE3%TYPE,
147: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
148: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
149: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
150: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
151: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
152: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
153: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
154: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,

Line 151: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,

147: attribute4 iby_ext_bank_accounts.ATTRIBUTE4%TYPE,
148: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
149: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
150: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
151: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
152: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
153: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
154: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
155: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,

Line 152: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,

148: attribute5 iby_ext_bank_accounts.ATTRIBUTE5%TYPE,
149: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
150: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
151: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
152: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
153: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
154: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
155: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
156: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,

Line 153: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,

149: attribute6 iby_ext_bank_accounts.ATTRIBUTE6%TYPE,
150: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
151: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
152: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
153: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
154: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
155: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
156: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
157: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,

Line 154: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,

150: attribute7 iby_ext_bank_accounts.ATTRIBUTE7%TYPE,
151: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
152: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
153: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
154: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
155: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
156: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
157: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
158: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,

Line 155: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,

151: attribute8 iby_ext_bank_accounts.ATTRIBUTE8%TYPE,
152: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
153: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
154: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
155: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
156: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
157: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
158: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
159: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,

Line 156: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,

152: attribute9 iby_ext_bank_accounts.ATTRIBUTE9%TYPE,
153: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
154: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
155: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
156: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
157: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
158: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
159: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
160: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE -- Bug 7408747(Added New Parameter to save Secondary Account Reference)

Line 157: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,

153: attribute10 iby_ext_bank_accounts.ATTRIBUTE10%TYPE,
154: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
155: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
156: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
157: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
158: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
159: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
160: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE -- Bug 7408747(Added New Parameter to save Secondary Account Reference)
161: );

Line 158: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,

154: attribute11 iby_ext_bank_accounts.ATTRIBUTE11%TYPE,
155: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
156: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
157: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
158: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
159: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
160: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE -- Bug 7408747(Added New Parameter to save Secondary Account Reference)
161: );
162:

Line 159: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,

155: attribute12 iby_ext_bank_accounts.ATTRIBUTE12%TYPE,
156: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
157: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
158: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
159: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
160: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE -- Bug 7408747(Added New Parameter to save Secondary Account Reference)
161: );
162:
163: -- Intermediary Bank Account Record

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

156: attribute13 iby_ext_bank_accounts.ATTRIBUTE13%TYPE,
157: attribute14 iby_ext_bank_accounts.ATTRIBUTE14%TYPE,
158: attribute15 iby_ext_bank_accounts.ATTRIBUTE15%TYPE,
159: object_version_number iby_ext_bank_accounts.OBJECT_VERSION_NUMBER%TYPE,
160: secondary_account_reference iby_ext_bank_accounts.SECONDARY_ACCOUNT_REFERENCE%TYPE -- Bug 7408747(Added New Parameter to save Secondary Account Reference)
161: );
162:
163: -- Intermediary Bank Account Record
164: TYPE IntermediaryAcct_rec_type IS RECORD(

Line 710: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,

706: -- Purpose : Masks secured bank account attributes
707: --
708: FUNCTION Mask_Bank_Number
709: (p_bank_number IN VARCHAR2,
710: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
711: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
712: )
713: RETURN VARCHAR2;
714:

Line 711: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE

707: --
708: FUNCTION Mask_Bank_Number
709: (p_bank_number IN VARCHAR2,
710: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
711: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
712: )
713: RETURN VARCHAR2;
714:
715: --

Line 735: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,

731: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
732: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
733: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
734: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
735: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
736: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
737: )
738: RETURN VARCHAR2;
739:

Line 736: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE

732: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
733: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
734: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
735: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
736: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
737: )
738: RETURN VARCHAR2;
739:
740: -- 103. Remask_Accounts