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.XTR_REPLICATE_BANK_ACCOUNTS_P dependencies on XTR_BANK_ACCOUNTS

Line 18: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

14: * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.
15: * This record type contains the Bank/Bank Branch
16: * related information about the bank attached with
17: * Bank Account.
18: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
19: * This record type contains the Bank Account
20: * related information.
21: * p_action_flag Indicates wether Bank account information needs
22: * to be inserted or updated.

Line 46: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

42: */
43:
44:
45: PROCEDURE REPLICATE_BANK_ACCOUNTS
46: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
47: p_action_flag IN VARCHAR2,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2)

Line 69: -- Verifies if the party_code in xtr_party_info is not same as the bank_code in xtr_bank_accounts

65: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors
66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68: --
69: -- Verifies if the party_code in xtr_party_info is not same as the bank_code in xtr_bank_accounts
70: IF ((NOT XTR_REPLICATE_BANK_BRANCHES_P.CHK_BANK_BRANCH(p_xtr_bank_account_rec.bank_branch_id))
71: ) THEN -- The Bank does not exist or not authorized in XTR
72:
73: OPEN c_branch_name;

Line 133: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,

129: END REPLICATE_BANK_ACCOUNTS;
130:
131: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
132: PROCEDURE REPLICATE_BANK_ACCOUNTS
133: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,
134: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
135: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
136: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
137: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,

Line 134: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,

130:
131: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
132: PROCEDURE REPLICATE_BANK_ACCOUNTS
133: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,
134: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
135: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
136: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
137: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
138: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,

Line 135: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,

131: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
132: PROCEDURE REPLICATE_BANK_ACCOUNTS
133: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,
134: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
135: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
136: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
137: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
138: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
139: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,

Line 136: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,

132: PROCEDURE REPLICATE_BANK_ACCOUNTS
133: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,
134: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
135: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
136: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
137: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
138: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
139: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
140: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,

Line 137: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,

133: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,
134: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
135: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
136: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
137: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
138: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
139: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
140: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
141: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,

Line 138: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,

134: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
135: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
136: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
137: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
138: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
139: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
140: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
141: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
142: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,

Line 139: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,

135: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
136: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
137: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
138: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
139: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
140: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
141: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
142: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
143: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,

Line 140: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,

136: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
137: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
138: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
139: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
140: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
141: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
142: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
143: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
144: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,

Line 141: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,

137: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
138: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
139: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
140: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
141: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
142: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
143: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
144: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
145: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,

Line 142: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,

138: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
139: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
140: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
141: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
142: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
143: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
144: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
145: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
146: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,

Line 143: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,

139: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
140: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
141: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
142: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
143: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
144: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
145: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
146: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
147: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,

Line 144: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,

140: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
141: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
142: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
143: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
144: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
145: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
146: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
147: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
148: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,

Line 145: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,

141: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
142: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
143: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
144: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
145: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
146: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
147: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
148: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
149: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,

Line 146: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,

142: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
143: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
144: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
145: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
146: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
147: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
148: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
149: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
150: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,

Line 147: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,

143: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
144: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
145: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
146: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
147: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
148: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
149: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
150: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
151: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,

Line 148: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,

144: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
145: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
146: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
147: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
148: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
149: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
150: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
151: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
152: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,

Line 149: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,

145: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
146: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
147: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
148: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
149: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
150: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
151: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
152: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
153: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,

Line 150: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,

146: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
147: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
148: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
149: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
150: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
151: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
152: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
153: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
154: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,

Line 151: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,

147: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
148: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
149: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
150: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
151: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
152: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
153: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
154: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
155: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,

Line 152: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,

148: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
149: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
150: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
151: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
152: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
153: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
154: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
155: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
156: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,

Line 153: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,

149: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
150: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
151: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
152: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
153: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
154: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
155: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
156: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
157: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,

Line 154: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,

150: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
151: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
152: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
153: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
154: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
155: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
156: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
157: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
158: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,

Line 155: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,

151: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
152: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
153: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
154: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
155: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
156: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
157: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
158: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
159: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,

Line 156: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,

152: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
153: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
154: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
155: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
156: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
157: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
158: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
159: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
160: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,

Line 157: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,

153: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
154: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
155: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
156: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
157: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
158: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
159: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
160: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
161: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,

Line 158: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,

154: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
155: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
156: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
157: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
158: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
159: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
160: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
161: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
162: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,

Line 159: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,

155: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
156: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
157: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
158: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
159: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
160: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
161: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
162: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
163: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,

Line 160: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,

156: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
157: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
158: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
159: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
160: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
161: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
162: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
163: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
164: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,

Line 161: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,

157: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
158: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
159: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
160: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
161: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
162: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
163: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
164: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
165: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,

Line 162: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,

158: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
159: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
160: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
161: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
162: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
163: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
164: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
165: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
166: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,

Line 163: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,

159: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
160: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
161: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
162: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
163: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
164: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
165: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
166: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
167: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,

Line 164: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,

160: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
161: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
162: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
163: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
164: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
165: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
166: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
167: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
168: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,

Line 165: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,

161: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
162: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
163: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
164: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
165: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
166: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
167: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
168: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
169: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,

Line 166: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,

162: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
163: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
164: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
165: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
166: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
167: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
168: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
169: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,
170: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,

Line 167: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,

163: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
164: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
165: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
166: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
167: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
168: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
169: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,
170: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,
171: p_action_flag IN VARCHAR2,

Line 168: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,

164: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
165: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
166: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
167: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
168: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
169: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,
170: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,
171: p_action_flag IN VARCHAR2,
172: x_return_status OUT NOCOPY VARCHAR2,

Line 169: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,

165: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
166: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
167: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
168: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
169: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,
170: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,
171: p_action_flag IN VARCHAR2,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,

Line 170: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,

166: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
167: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
168: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
169: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,
170: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,
171: p_action_flag IN VARCHAR2,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,

Line 175: p_iban_number IN XTR_BANK_ACCOUNTS.iban%TYPE --ER6391546

171: p_action_flag IN VARCHAR2,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_iban_number IN XTR_BANK_ACCOUNTS.iban%TYPE --ER6391546
176: ) IS
177: l_xtr_bank_accounts_rec XTR_BANK_ACCOUNTS%ROWTYPE;
178:
179: BEGIN

Line 177: l_xtr_bank_accounts_rec XTR_BANK_ACCOUNTS%ROWTYPE;

173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_iban_number IN XTR_BANK_ACCOUNTS.iban%TYPE --ER6391546
176: ) IS
177: l_xtr_bank_accounts_rec XTR_BANK_ACCOUNTS%ROWTYPE;
178:
179: BEGIN
180:
181: l_xtr_bank_accounts_rec.account_number := p_account_number;

Line 181: l_xtr_bank_accounts_rec.account_number := p_account_number;

177: l_xtr_bank_accounts_rec XTR_BANK_ACCOUNTS%ROWTYPE;
178:
179: BEGIN
180:
181: l_xtr_bank_accounts_rec.account_number := p_account_number;
182: l_xtr_bank_accounts_rec.authorised := p_authorised;
183: l_xtr_bank_accounts_rec.party_code := p_party_code;
184: l_xtr_bank_accounts_rec.party_type := p_party_type;
185: l_xtr_bank_accounts_rec.bank_code := p_bank_code;

Line 182: l_xtr_bank_accounts_rec.authorised := p_authorised;

178:
179: BEGIN
180:
181: l_xtr_bank_accounts_rec.account_number := p_account_number;
182: l_xtr_bank_accounts_rec.authorised := p_authorised;
183: l_xtr_bank_accounts_rec.party_code := p_party_code;
184: l_xtr_bank_accounts_rec.party_type := p_party_type;
185: l_xtr_bank_accounts_rec.bank_code := p_bank_code;
186: l_xtr_bank_accounts_rec.currency := p_currency;

Line 183: l_xtr_bank_accounts_rec.party_code := p_party_code;

179: BEGIN
180:
181: l_xtr_bank_accounts_rec.account_number := p_account_number;
182: l_xtr_bank_accounts_rec.authorised := p_authorised;
183: l_xtr_bank_accounts_rec.party_code := p_party_code;
184: l_xtr_bank_accounts_rec.party_type := p_party_type;
185: l_xtr_bank_accounts_rec.bank_code := p_bank_code;
186: l_xtr_bank_accounts_rec.currency := p_currency;
187: l_xtr_bank_accounts_rec.bank_short_code := p_bank_short_code;

Line 184: l_xtr_bank_accounts_rec.party_type := p_party_type;

180:
181: l_xtr_bank_accounts_rec.account_number := p_account_number;
182: l_xtr_bank_accounts_rec.authorised := p_authorised;
183: l_xtr_bank_accounts_rec.party_code := p_party_code;
184: l_xtr_bank_accounts_rec.party_type := p_party_type;
185: l_xtr_bank_accounts_rec.bank_code := p_bank_code;
186: l_xtr_bank_accounts_rec.currency := p_currency;
187: l_xtr_bank_accounts_rec.bank_short_code := p_bank_short_code;
188: l_xtr_bank_accounts_rec.default_acct := p_default_acct;

Line 185: l_xtr_bank_accounts_rec.bank_code := p_bank_code;

181: l_xtr_bank_accounts_rec.account_number := p_account_number;
182: l_xtr_bank_accounts_rec.authorised := p_authorised;
183: l_xtr_bank_accounts_rec.party_code := p_party_code;
184: l_xtr_bank_accounts_rec.party_type := p_party_type;
185: l_xtr_bank_accounts_rec.bank_code := p_bank_code;
186: l_xtr_bank_accounts_rec.currency := p_currency;
187: l_xtr_bank_accounts_rec.bank_short_code := p_bank_short_code;
188: l_xtr_bank_accounts_rec.default_acct := p_default_acct;
189: l_xtr_bank_accounts_rec.eft_script_name := p_eft_script_name;

Line 186: l_xtr_bank_accounts_rec.currency := p_currency;

182: l_xtr_bank_accounts_rec.authorised := p_authorised;
183: l_xtr_bank_accounts_rec.party_code := p_party_code;
184: l_xtr_bank_accounts_rec.party_type := p_party_type;
185: l_xtr_bank_accounts_rec.bank_code := p_bank_code;
186: l_xtr_bank_accounts_rec.currency := p_currency;
187: l_xtr_bank_accounts_rec.bank_short_code := p_bank_short_code;
188: l_xtr_bank_accounts_rec.default_acct := p_default_acct;
189: l_xtr_bank_accounts_rec.eft_script_name := p_eft_script_name;
190: l_xtr_bank_accounts_rec.code_combination_id := p_code_combination_id;

Line 187: l_xtr_bank_accounts_rec.bank_short_code := p_bank_short_code;

183: l_xtr_bank_accounts_rec.party_code := p_party_code;
184: l_xtr_bank_accounts_rec.party_type := p_party_type;
185: l_xtr_bank_accounts_rec.bank_code := p_bank_code;
186: l_xtr_bank_accounts_rec.currency := p_currency;
187: l_xtr_bank_accounts_rec.bank_short_code := p_bank_short_code;
188: l_xtr_bank_accounts_rec.default_acct := p_default_acct;
189: l_xtr_bank_accounts_rec.eft_script_name := p_eft_script_name;
190: l_xtr_bank_accounts_rec.code_combination_id := p_code_combination_id;
191: l_xtr_bank_accounts_rec.interest_calculation_basis := p_interest_calculation_basis;

Line 188: l_xtr_bank_accounts_rec.default_acct := p_default_acct;

184: l_xtr_bank_accounts_rec.party_type := p_party_type;
185: l_xtr_bank_accounts_rec.bank_code := p_bank_code;
186: l_xtr_bank_accounts_rec.currency := p_currency;
187: l_xtr_bank_accounts_rec.bank_short_code := p_bank_short_code;
188: l_xtr_bank_accounts_rec.default_acct := p_default_acct;
189: l_xtr_bank_accounts_rec.eft_script_name := p_eft_script_name;
190: l_xtr_bank_accounts_rec.code_combination_id := p_code_combination_id;
191: l_xtr_bank_accounts_rec.interest_calculation_basis := p_interest_calculation_basis;
192: l_xtr_bank_accounts_rec.location := p_location;

Line 189: l_xtr_bank_accounts_rec.eft_script_name := p_eft_script_name;

185: l_xtr_bank_accounts_rec.bank_code := p_bank_code;
186: l_xtr_bank_accounts_rec.currency := p_currency;
187: l_xtr_bank_accounts_rec.bank_short_code := p_bank_short_code;
188: l_xtr_bank_accounts_rec.default_acct := p_default_acct;
189: l_xtr_bank_accounts_rec.eft_script_name := p_eft_script_name;
190: l_xtr_bank_accounts_rec.code_combination_id := p_code_combination_id;
191: l_xtr_bank_accounts_rec.interest_calculation_basis := p_interest_calculation_basis;
192: l_xtr_bank_accounts_rec.location := p_location;
193: l_xtr_bank_accounts_rec.portfolio_code := p_portfolio_code;

Line 190: l_xtr_bank_accounts_rec.code_combination_id := p_code_combination_id;

186: l_xtr_bank_accounts_rec.currency := p_currency;
187: l_xtr_bank_accounts_rec.bank_short_code := p_bank_short_code;
188: l_xtr_bank_accounts_rec.default_acct := p_default_acct;
189: l_xtr_bank_accounts_rec.eft_script_name := p_eft_script_name;
190: l_xtr_bank_accounts_rec.code_combination_id := p_code_combination_id;
191: l_xtr_bank_accounts_rec.interest_calculation_basis := p_interest_calculation_basis;
192: l_xtr_bank_accounts_rec.location := p_location;
193: l_xtr_bank_accounts_rec.portfolio_code := p_portfolio_code;
194: l_xtr_bank_accounts_rec.primary_settlement_method := p_primary_settlement_method;

Line 191: l_xtr_bank_accounts_rec.interest_calculation_basis := p_interest_calculation_basis;

187: l_xtr_bank_accounts_rec.bank_short_code := p_bank_short_code;
188: l_xtr_bank_accounts_rec.default_acct := p_default_acct;
189: l_xtr_bank_accounts_rec.eft_script_name := p_eft_script_name;
190: l_xtr_bank_accounts_rec.code_combination_id := p_code_combination_id;
191: l_xtr_bank_accounts_rec.interest_calculation_basis := p_interest_calculation_basis;
192: l_xtr_bank_accounts_rec.location := p_location;
193: l_xtr_bank_accounts_rec.portfolio_code := p_portfolio_code;
194: l_xtr_bank_accounts_rec.primary_settlement_method := p_primary_settlement_method;
195: -- Bug 6119714 Start

Line 192: l_xtr_bank_accounts_rec.location := p_location;

188: l_xtr_bank_accounts_rec.default_acct := p_default_acct;
189: l_xtr_bank_accounts_rec.eft_script_name := p_eft_script_name;
190: l_xtr_bank_accounts_rec.code_combination_id := p_code_combination_id;
191: l_xtr_bank_accounts_rec.interest_calculation_basis := p_interest_calculation_basis;
192: l_xtr_bank_accounts_rec.location := p_location;
193: l_xtr_bank_accounts_rec.portfolio_code := p_portfolio_code;
194: l_xtr_bank_accounts_rec.primary_settlement_method := p_primary_settlement_method;
195: -- Bug 6119714 Start
196: l_xtr_bank_accounts_rec.street := SUBSTRB(p_street,1,35); -- Bug 11071158

Line 193: l_xtr_bank_accounts_rec.portfolio_code := p_portfolio_code;

189: l_xtr_bank_accounts_rec.eft_script_name := p_eft_script_name;
190: l_xtr_bank_accounts_rec.code_combination_id := p_code_combination_id;
191: l_xtr_bank_accounts_rec.interest_calculation_basis := p_interest_calculation_basis;
192: l_xtr_bank_accounts_rec.location := p_location;
193: l_xtr_bank_accounts_rec.portfolio_code := p_portfolio_code;
194: l_xtr_bank_accounts_rec.primary_settlement_method := p_primary_settlement_method;
195: -- Bug 6119714 Start
196: l_xtr_bank_accounts_rec.street := SUBSTRB(p_street,1,35); -- Bug 11071158
197: -- Bug 6119714 end

Line 194: l_xtr_bank_accounts_rec.primary_settlement_method := p_primary_settlement_method;

190: l_xtr_bank_accounts_rec.code_combination_id := p_code_combination_id;
191: l_xtr_bank_accounts_rec.interest_calculation_basis := p_interest_calculation_basis;
192: l_xtr_bank_accounts_rec.location := p_location;
193: l_xtr_bank_accounts_rec.portfolio_code := p_portfolio_code;
194: l_xtr_bank_accounts_rec.primary_settlement_method := p_primary_settlement_method;
195: -- Bug 6119714 Start
196: l_xtr_bank_accounts_rec.street := SUBSTRB(p_street,1,35); -- Bug 11071158
197: -- Bug 6119714 end
198: l_xtr_bank_accounts_rec.year_calc_type := p_year_calc_type;

Line 196: l_xtr_bank_accounts_rec.street := SUBSTRB(p_street,1,35); -- Bug 11071158

192: l_xtr_bank_accounts_rec.location := p_location;
193: l_xtr_bank_accounts_rec.portfolio_code := p_portfolio_code;
194: l_xtr_bank_accounts_rec.primary_settlement_method := p_primary_settlement_method;
195: -- Bug 6119714 Start
196: l_xtr_bank_accounts_rec.street := SUBSTRB(p_street,1,35); -- Bug 11071158
197: -- Bug 6119714 end
198: l_xtr_bank_accounts_rec.year_calc_type := p_year_calc_type;
199: l_xtr_bank_accounts_rec.swift_id := p_swift_id;
200: l_xtr_bank_accounts_rec.attribute_category := p_attribute_category;

Line 198: l_xtr_bank_accounts_rec.year_calc_type := p_year_calc_type;

194: l_xtr_bank_accounts_rec.primary_settlement_method := p_primary_settlement_method;
195: -- Bug 6119714 Start
196: l_xtr_bank_accounts_rec.street := SUBSTRB(p_street,1,35); -- Bug 11071158
197: -- Bug 6119714 end
198: l_xtr_bank_accounts_rec.year_calc_type := p_year_calc_type;
199: l_xtr_bank_accounts_rec.swift_id := p_swift_id;
200: l_xtr_bank_accounts_rec.attribute_category := p_attribute_category;
201: l_xtr_bank_accounts_rec.attribute1 := p_attribute1;
202: l_xtr_bank_accounts_rec.attribute2 := p_attribute2;

Line 199: l_xtr_bank_accounts_rec.swift_id := p_swift_id;

195: -- Bug 6119714 Start
196: l_xtr_bank_accounts_rec.street := SUBSTRB(p_street,1,35); -- Bug 11071158
197: -- Bug 6119714 end
198: l_xtr_bank_accounts_rec.year_calc_type := p_year_calc_type;
199: l_xtr_bank_accounts_rec.swift_id := p_swift_id;
200: l_xtr_bank_accounts_rec.attribute_category := p_attribute_category;
201: l_xtr_bank_accounts_rec.attribute1 := p_attribute1;
202: l_xtr_bank_accounts_rec.attribute2 := p_attribute2;
203: l_xtr_bank_accounts_rec.attribute3 := p_attribute3;

Line 200: l_xtr_bank_accounts_rec.attribute_category := p_attribute_category;

196: l_xtr_bank_accounts_rec.street := SUBSTRB(p_street,1,35); -- Bug 11071158
197: -- Bug 6119714 end
198: l_xtr_bank_accounts_rec.year_calc_type := p_year_calc_type;
199: l_xtr_bank_accounts_rec.swift_id := p_swift_id;
200: l_xtr_bank_accounts_rec.attribute_category := p_attribute_category;
201: l_xtr_bank_accounts_rec.attribute1 := p_attribute1;
202: l_xtr_bank_accounts_rec.attribute2 := p_attribute2;
203: l_xtr_bank_accounts_rec.attribute3 := p_attribute3;
204: l_xtr_bank_accounts_rec.attribute4 := p_attribute4;

Line 201: l_xtr_bank_accounts_rec.attribute1 := p_attribute1;

197: -- Bug 6119714 end
198: l_xtr_bank_accounts_rec.year_calc_type := p_year_calc_type;
199: l_xtr_bank_accounts_rec.swift_id := p_swift_id;
200: l_xtr_bank_accounts_rec.attribute_category := p_attribute_category;
201: l_xtr_bank_accounts_rec.attribute1 := p_attribute1;
202: l_xtr_bank_accounts_rec.attribute2 := p_attribute2;
203: l_xtr_bank_accounts_rec.attribute3 := p_attribute3;
204: l_xtr_bank_accounts_rec.attribute4 := p_attribute4;
205: l_xtr_bank_accounts_rec.attribute5 := p_attribute5;

Line 202: l_xtr_bank_accounts_rec.attribute2 := p_attribute2;

198: l_xtr_bank_accounts_rec.year_calc_type := p_year_calc_type;
199: l_xtr_bank_accounts_rec.swift_id := p_swift_id;
200: l_xtr_bank_accounts_rec.attribute_category := p_attribute_category;
201: l_xtr_bank_accounts_rec.attribute1 := p_attribute1;
202: l_xtr_bank_accounts_rec.attribute2 := p_attribute2;
203: l_xtr_bank_accounts_rec.attribute3 := p_attribute3;
204: l_xtr_bank_accounts_rec.attribute4 := p_attribute4;
205: l_xtr_bank_accounts_rec.attribute5 := p_attribute5;
206: l_xtr_bank_accounts_rec.attribute6 := p_attribute6;

Line 203: l_xtr_bank_accounts_rec.attribute3 := p_attribute3;

199: l_xtr_bank_accounts_rec.swift_id := p_swift_id;
200: l_xtr_bank_accounts_rec.attribute_category := p_attribute_category;
201: l_xtr_bank_accounts_rec.attribute1 := p_attribute1;
202: l_xtr_bank_accounts_rec.attribute2 := p_attribute2;
203: l_xtr_bank_accounts_rec.attribute3 := p_attribute3;
204: l_xtr_bank_accounts_rec.attribute4 := p_attribute4;
205: l_xtr_bank_accounts_rec.attribute5 := p_attribute5;
206: l_xtr_bank_accounts_rec.attribute6 := p_attribute6;
207: l_xtr_bank_accounts_rec.attribute7 := p_attribute7;

Line 204: l_xtr_bank_accounts_rec.attribute4 := p_attribute4;

200: l_xtr_bank_accounts_rec.attribute_category := p_attribute_category;
201: l_xtr_bank_accounts_rec.attribute1 := p_attribute1;
202: l_xtr_bank_accounts_rec.attribute2 := p_attribute2;
203: l_xtr_bank_accounts_rec.attribute3 := p_attribute3;
204: l_xtr_bank_accounts_rec.attribute4 := p_attribute4;
205: l_xtr_bank_accounts_rec.attribute5 := p_attribute5;
206: l_xtr_bank_accounts_rec.attribute6 := p_attribute6;
207: l_xtr_bank_accounts_rec.attribute7 := p_attribute7;
208: l_xtr_bank_accounts_rec.attribute8 := p_attribute8;

Line 205: l_xtr_bank_accounts_rec.attribute5 := p_attribute5;

201: l_xtr_bank_accounts_rec.attribute1 := p_attribute1;
202: l_xtr_bank_accounts_rec.attribute2 := p_attribute2;
203: l_xtr_bank_accounts_rec.attribute3 := p_attribute3;
204: l_xtr_bank_accounts_rec.attribute4 := p_attribute4;
205: l_xtr_bank_accounts_rec.attribute5 := p_attribute5;
206: l_xtr_bank_accounts_rec.attribute6 := p_attribute6;
207: l_xtr_bank_accounts_rec.attribute7 := p_attribute7;
208: l_xtr_bank_accounts_rec.attribute8 := p_attribute8;
209: l_xtr_bank_accounts_rec.attribute9 := p_attribute9;

Line 206: l_xtr_bank_accounts_rec.attribute6 := p_attribute6;

202: l_xtr_bank_accounts_rec.attribute2 := p_attribute2;
203: l_xtr_bank_accounts_rec.attribute3 := p_attribute3;
204: l_xtr_bank_accounts_rec.attribute4 := p_attribute4;
205: l_xtr_bank_accounts_rec.attribute5 := p_attribute5;
206: l_xtr_bank_accounts_rec.attribute6 := p_attribute6;
207: l_xtr_bank_accounts_rec.attribute7 := p_attribute7;
208: l_xtr_bank_accounts_rec.attribute8 := p_attribute8;
209: l_xtr_bank_accounts_rec.attribute9 := p_attribute9;
210: l_xtr_bank_accounts_rec.attribute10 := p_attribute10;

Line 207: l_xtr_bank_accounts_rec.attribute7 := p_attribute7;

203: l_xtr_bank_accounts_rec.attribute3 := p_attribute3;
204: l_xtr_bank_accounts_rec.attribute4 := p_attribute4;
205: l_xtr_bank_accounts_rec.attribute5 := p_attribute5;
206: l_xtr_bank_accounts_rec.attribute6 := p_attribute6;
207: l_xtr_bank_accounts_rec.attribute7 := p_attribute7;
208: l_xtr_bank_accounts_rec.attribute8 := p_attribute8;
209: l_xtr_bank_accounts_rec.attribute9 := p_attribute9;
210: l_xtr_bank_accounts_rec.attribute10 := p_attribute10;
211: l_xtr_bank_accounts_rec.attribute11 := p_attribute11;

Line 208: l_xtr_bank_accounts_rec.attribute8 := p_attribute8;

204: l_xtr_bank_accounts_rec.attribute4 := p_attribute4;
205: l_xtr_bank_accounts_rec.attribute5 := p_attribute5;
206: l_xtr_bank_accounts_rec.attribute6 := p_attribute6;
207: l_xtr_bank_accounts_rec.attribute7 := p_attribute7;
208: l_xtr_bank_accounts_rec.attribute8 := p_attribute8;
209: l_xtr_bank_accounts_rec.attribute9 := p_attribute9;
210: l_xtr_bank_accounts_rec.attribute10 := p_attribute10;
211: l_xtr_bank_accounts_rec.attribute11 := p_attribute11;
212: l_xtr_bank_accounts_rec.attribute12 := p_attribute12;

Line 209: l_xtr_bank_accounts_rec.attribute9 := p_attribute9;

205: l_xtr_bank_accounts_rec.attribute5 := p_attribute5;
206: l_xtr_bank_accounts_rec.attribute6 := p_attribute6;
207: l_xtr_bank_accounts_rec.attribute7 := p_attribute7;
208: l_xtr_bank_accounts_rec.attribute8 := p_attribute8;
209: l_xtr_bank_accounts_rec.attribute9 := p_attribute9;
210: l_xtr_bank_accounts_rec.attribute10 := p_attribute10;
211: l_xtr_bank_accounts_rec.attribute11 := p_attribute11;
212: l_xtr_bank_accounts_rec.attribute12 := p_attribute12;
213: l_xtr_bank_accounts_rec.attribute13 := p_attribute13;

Line 210: l_xtr_bank_accounts_rec.attribute10 := p_attribute10;

206: l_xtr_bank_accounts_rec.attribute6 := p_attribute6;
207: l_xtr_bank_accounts_rec.attribute7 := p_attribute7;
208: l_xtr_bank_accounts_rec.attribute8 := p_attribute8;
209: l_xtr_bank_accounts_rec.attribute9 := p_attribute9;
210: l_xtr_bank_accounts_rec.attribute10 := p_attribute10;
211: l_xtr_bank_accounts_rec.attribute11 := p_attribute11;
212: l_xtr_bank_accounts_rec.attribute12 := p_attribute12;
213: l_xtr_bank_accounts_rec.attribute13 := p_attribute13;
214: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;

Line 211: l_xtr_bank_accounts_rec.attribute11 := p_attribute11;

207: l_xtr_bank_accounts_rec.attribute7 := p_attribute7;
208: l_xtr_bank_accounts_rec.attribute8 := p_attribute8;
209: l_xtr_bank_accounts_rec.attribute9 := p_attribute9;
210: l_xtr_bank_accounts_rec.attribute10 := p_attribute10;
211: l_xtr_bank_accounts_rec.attribute11 := p_attribute11;
212: l_xtr_bank_accounts_rec.attribute12 := p_attribute12;
213: l_xtr_bank_accounts_rec.attribute13 := p_attribute13;
214: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;
215: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;

Line 212: l_xtr_bank_accounts_rec.attribute12 := p_attribute12;

208: l_xtr_bank_accounts_rec.attribute8 := p_attribute8;
209: l_xtr_bank_accounts_rec.attribute9 := p_attribute9;
210: l_xtr_bank_accounts_rec.attribute10 := p_attribute10;
211: l_xtr_bank_accounts_rec.attribute11 := p_attribute11;
212: l_xtr_bank_accounts_rec.attribute12 := p_attribute12;
213: l_xtr_bank_accounts_rec.attribute13 := p_attribute13;
214: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;
215: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;
216: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;

Line 213: l_xtr_bank_accounts_rec.attribute13 := p_attribute13;

209: l_xtr_bank_accounts_rec.attribute9 := p_attribute9;
210: l_xtr_bank_accounts_rec.attribute10 := p_attribute10;
211: l_xtr_bank_accounts_rec.attribute11 := p_attribute11;
212: l_xtr_bank_accounts_rec.attribute12 := p_attribute12;
213: l_xtr_bank_accounts_rec.attribute13 := p_attribute13;
214: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;
215: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;
216: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;
217: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;

Line 214: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;

210: l_xtr_bank_accounts_rec.attribute10 := p_attribute10;
211: l_xtr_bank_accounts_rec.attribute11 := p_attribute11;
212: l_xtr_bank_accounts_rec.attribute12 := p_attribute12;
213: l_xtr_bank_accounts_rec.attribute13 := p_attribute13;
214: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;
215: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;
216: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;
217: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;
218: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;

Line 215: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;

211: l_xtr_bank_accounts_rec.attribute11 := p_attribute11;
212: l_xtr_bank_accounts_rec.attribute12 := p_attribute12;
213: l_xtr_bank_accounts_rec.attribute13 := p_attribute13;
214: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;
215: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;
216: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;
217: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;
218: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;
219: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;

Line 216: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;

212: l_xtr_bank_accounts_rec.attribute12 := p_attribute12;
213: l_xtr_bank_accounts_rec.attribute13 := p_attribute13;
214: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;
215: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;
216: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;
217: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;
218: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;
219: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;
220: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;

Line 217: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;

213: l_xtr_bank_accounts_rec.attribute13 := p_attribute13;
214: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;
215: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;
216: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;
217: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;
218: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;
219: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;
220: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;
221: l_xtr_bank_accounts_rec.iban := p_iban_number; --ER6391546

Line 218: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;

214: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;
215: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;
216: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;
217: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;
218: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;
219: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;
220: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;
221: l_xtr_bank_accounts_rec.iban := p_iban_number; --ER6391546
222:

Line 219: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;

215: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;
216: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;
217: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;
218: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;
219: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;
220: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;
221: l_xtr_bank_accounts_rec.iban := p_iban_number; --ER6391546
222:
223:

Line 220: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;

216: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;
217: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;
218: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;
219: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;
220: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;
221: l_xtr_bank_accounts_rec.iban := p_iban_number; --ER6391546
222:
223:
224: REPLICATE_BANK_ACCOUNTS(l_xtr_bank_accounts_rec,p_action_flag,

Line 221: l_xtr_bank_accounts_rec.iban := p_iban_number; --ER6391546

217: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;
218: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;
219: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;
220: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;
221: l_xtr_bank_accounts_rec.iban := p_iban_number; --ER6391546
222:
223:
224: REPLICATE_BANK_ACCOUNTS(l_xtr_bank_accounts_rec,p_action_flag,
225: x_return_status,x_msg_count,x_msg_data);

Line 224: REPLICATE_BANK_ACCOUNTS(l_xtr_bank_accounts_rec,p_action_flag,

220: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;
221: l_xtr_bank_accounts_rec.iban := p_iban_number; --ER6391546
222:
223:
224: REPLICATE_BANK_ACCOUNTS(l_xtr_bank_accounts_rec,p_action_flag,
225: x_return_status,x_msg_count,x_msg_data);
226:
227: EXCEPTION
228: WHEN others THEN

Line 251: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

247: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
248: *
249: * ARGUMENTS
250: * IN:
251: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
252: * This record type contains the Bank Account
253: * related information.
254: * IN/OUT:
255: *

Line 272: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

268: */
269:
270:
271: PROCEDURE INSERT_BANK_ACCOUNTS
272: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
273: x_return_status OUT NOCOPY VARCHAR2
274: )
275:
276: IS

Line 320: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

316: *
317: * ARGUMENTS
318: * IN:
319: *
320: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
321: * This record type contains the Bank Account
322: * related information.
323: * IN/OUT:
324: *

Line 340: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

336: *
337: */
338:
339: PROCEDURE UPDATE_BANK_ACCOUNTS
340: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
341: x_return_status OUT NOCOPY VARCHAR2
342: )
343: IS
344:

Line 375: * it is inserted/updated into XTR_BANK_ACCOUNTS. This procedure will

371: /**
372: * PROCEDURE validate_bank_accounts
373: *
374: * This procedure is used to validate the Bank account related data before
375: * it is inserted/updated into XTR_BANK_ACCOUNTS. This procedure will
376: * perform the required validations and puts the corresponding error
377: * messages into list
378: *
379: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 383: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

379: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
380: *
381: * ARGUMENTS
382: * IN:
383: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
384: * This record type contains the Bank Account
385: * related information.
386: * IN/OUT:
387: *

Line 403: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

399: *
400: */
401:
402: PROCEDURE VALIDATE_BANK_ACCOUNTS
403: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
404: x_return_status IN OUT NOCOPY VARCHAR2
405: )
406: IS
407: -- This cursor verifies if the code combination id passed is defined in

Line 430: from xtr_bank_accounts

426: and party_type = 'C';
427: -- This cursor Verfies if A default account already exists for this company/currency combination.
428: cursor c_default_acct is
429: select default_acct,ce_bank_account_id -- Modified Bug 4764437
430: from xtr_bank_accounts
431: where party_code = p_xtr_bank_account_rec.party_code
432: and currency = p_xtr_bank_account_rec.currency
433: and default_acct = 'Y';
434:

Line 437: l_pm_authorized XTR_BANK_ACCOUNTS.PRICING_MODEL%TYPE;

433: and default_acct = 'Y';
434:
435:
436: l_cc_id VARCHAR2(2);
437: l_pm_authorized XTR_BANK_ACCOUNTS.PRICING_MODEL%TYPE;
438: l_valid_company VARCHAR2(2);
439: l_le_id XTR_PARTY_INFO.legal_entity_id%TYPE;
440: l_default_acct VARCHAR2(2);
441: l_chk_default XTR_BANK_ACCOUNTS.CE_BANK_ACCOUNT_ID%TYPE; -- Added Bug 4764437

Line 441: l_chk_default XTR_BANK_ACCOUNTS.CE_BANK_ACCOUNT_ID%TYPE; -- Added Bug 4764437

437: l_pm_authorized XTR_BANK_ACCOUNTS.PRICING_MODEL%TYPE;
438: l_valid_company VARCHAR2(2);
439: l_le_id XTR_PARTY_INFO.legal_entity_id%TYPE;
440: l_default_acct VARCHAR2(2);
441: l_chk_default XTR_BANK_ACCOUNTS.CE_BANK_ACCOUNT_ID%TYPE; -- Added Bug 4764437
442:
443: -- Enter the procedure variables here. As shown below
444: --variable_name datatype NOT NULL DEFAULT default_value;
445: BEGIN

Line 448: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null

444: --variable_name datatype NOT NULL DEFAULT default_value;
445: BEGIN
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447:
448: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null
449: IF(p_xtr_bank_account_rec.ce_bank_account_id is null) THEN
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
452: END IF;

Line 451: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');

447:
448: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null
449: IF(p_xtr_bank_account_rec.ce_bank_account_id is null) THEN
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
452: END IF;
453: -- Verifies if the bank_branch_id in XTR_BANK_ACCOUNTS is passed as null
454: IF(p_xtr_bank_account_rec.bank_branch_id is null) THEN
455: x_return_status := FND_API.G_RET_STS_ERROR;

Line 453: -- Verifies if the bank_branch_id in XTR_BANK_ACCOUNTS is passed as null

449: IF(p_xtr_bank_account_rec.ce_bank_account_id is null) THEN
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
452: END IF;
453: -- Verifies if the bank_branch_id in XTR_BANK_ACCOUNTS is passed as null
454: IF(p_xtr_bank_account_rec.bank_branch_id is null) THEN
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.BANK_BRANCH_ID');
457: END IF;

Line 456: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.BANK_BRANCH_ID');

452: END IF;
453: -- Verifies if the bank_branch_id in XTR_BANK_ACCOUNTS is passed as null
454: IF(p_xtr_bank_account_rec.bank_branch_id is null) THEN
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.BANK_BRANCH_ID');
457: END IF;
458: /* Removed the validation Bug 4582759
459: -- Verifies if the bank_acct_use_id in XTR_BANK_ACCOUNTS is passed as null
460: IF(p_xtr_bank_account_rec.bank_acct_use_id is null) THEN

Line 459: -- Verifies if the bank_acct_use_id in XTR_BANK_ACCOUNTS is passed as null

455: x_return_status := FND_API.G_RET_STS_ERROR;
456: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.BANK_BRANCH_ID');
457: END IF;
458: /* Removed the validation Bug 4582759
459: -- Verifies if the bank_acct_use_id in XTR_BANK_ACCOUNTS is passed as null
460: IF(p_xtr_bank_account_rec.bank_acct_use_id is null) THEN
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.BANK_ACCT_USE_ID');
463: END IF;

Line 462: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.BANK_ACCT_USE_ID');

458: /* Removed the validation Bug 4582759
459: -- Verifies if the bank_acct_use_id in XTR_BANK_ACCOUNTS is passed as null
460: IF(p_xtr_bank_account_rec.bank_acct_use_id is null) THEN
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.BANK_ACCT_USE_ID');
463: END IF;
464: */
465: -- Verifies if bank_short_code in XTR_BANK_ACCOUNTS is passed as null
466: IF(p_xtr_bank_account_rec.bank_short_code is null) THEN

Line 465: -- Verifies if bank_short_code in XTR_BANK_ACCOUNTS is passed as null

461: x_return_status := FND_API.G_RET_STS_ERROR;
462: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.BANK_ACCT_USE_ID');
463: END IF;
464: */
465: -- Verifies if bank_short_code in XTR_BANK_ACCOUNTS is passed as null
466: IF(p_xtr_bank_account_rec.bank_short_code is null) THEN
467: x_return_status := FND_API.G_RET_STS_ERROR;
468: LOG_ERR_MSG('XTR_ACCT_NAME_MANDATORY');
469: END IF;

Line 470: -- Verifies if currency in XTR_BANK_ACCOUNTS is passed as null

466: IF(p_xtr_bank_account_rec.bank_short_code is null) THEN
467: x_return_status := FND_API.G_RET_STS_ERROR;
468: LOG_ERR_MSG('XTR_ACCT_NAME_MANDATORY');
469: END IF;
470: -- Verifies if currency in XTR_BANK_ACCOUNTS is passed as null
471: IF(p_xtr_bank_account_rec.currency is null ) THEN
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: LOG_ERR_MSG('XTR_CURRENCY_MANDATORY');
474: END IF;

Line 475: -- Verifies if location in XTR_BANK_ACCOUNTS is passed as null

471: IF(p_xtr_bank_account_rec.currency is null ) THEN
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: LOG_ERR_MSG('XTR_CURRENCY_MANDATORY');
474: END IF;
475: -- Verifies if location in XTR_BANK_ACCOUNTS is passed as null
476: IF(p_xtr_bank_account_rec.location is null) THEN
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: LOG_ERR_MSG('XTR_LOCATION_MANDATORY');
479: END IF;

Line 480: -- Verifies if street in XTR_BANK_ACCOUNTS is passed as null

476: IF(p_xtr_bank_account_rec.location is null) THEN
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: LOG_ERR_MSG('XTR_LOCATION_MANDATORY');
479: END IF;
480: -- Verifies if street in XTR_BANK_ACCOUNTS is passed as null
481: IF(p_xtr_bank_account_rec.street is null) THEN
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: LOG_ERR_MSG('XTR_STREET_MANDATORY');
484: END IF;

Line 485: -- Verifies if party_code in XTR_BANK_ACCOUNTS is passed as null

481: IF(p_xtr_bank_account_rec.street is null) THEN
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: LOG_ERR_MSG('XTR_STREET_MANDATORY');
484: END IF;
485: -- Verifies if party_code in XTR_BANK_ACCOUNTS is passed as null
486: IF(p_xtr_bank_account_rec.party_code is null ) THEN
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: LOG_ERR_MSG('XTR_ACCT_OWNER_MANDATORY');
489: END IF;

Line 490: -- Verifies if account_number in XTR_BANK_ACCOUNTS is passed as null

486: IF(p_xtr_bank_account_rec.party_code is null ) THEN
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: LOG_ERR_MSG('XTR_ACCT_OWNER_MANDATORY');
489: END IF;
490: -- Verifies if account_number in XTR_BANK_ACCOUNTS is passed as null
491: IF(p_xtr_bank_account_rec.account_number is null ) THEN
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: LOG_ERR_MSG('XTR_ACCOUNT_MANDATORY_FIELD');
494: END IF;

Line 500: -- Verifies if pricing model in XTR_BANK_ACCOUNTS is authorized or not

496:
497: OPEN c_pm_authorized;
498: FETCH c_pm_authorized INTO l_pm_authorized;
499: CLOSE c_pm_authorized;
500: -- Verifies if pricing model in XTR_BANK_ACCOUNTS is authorized or not
501: IF(nvl(l_pm_authorized,'N') = 'N' AND p_xtr_bank_account_rec.pricing_model IS NOT NULL ) THEN
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: LOG_ERR_MSG('XTR_INV_TRS_PRICING_MODEL');
504: END IF;

Line 509: -- Verifies if code combination id in XTR_BANK_ACCOUNTS is authorized or not

505:
506: OPEN c_cc_id;
507: FETCH c_cc_id INTO l_cc_id;
508: CLOSE c_cc_id;
509: -- Verifies if code combination id in XTR_BANK_ACCOUNTS is authorized or not
510: IF(nvl(l_cc_id,'N') = 'N' AND p_xtr_bank_account_rec.code_combination_id IS NOT NULL
511: AND p_xtr_bank_account_rec.party_code IS NOT NULL) THEN
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: LOG_ERR_MSG('XTR_INV_CC_ID');

Line 568: * This procedure will insert/update XTR_BANK_ACCOUNTS table with the

564: /**
565: * PROCEDURE modify_bank_accounts
566: *
567: * DESCRIPTION
568: * This procedure will insert/update XTR_BANK_ACCOUNTS table with the
569: * Bank account data passed form CE. It will insert if p_action_flag = 'I'
570: * and update if p_action_flag = 'U'
571: *
572: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 576: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

572: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
573: *
574: * ARGUMENTS
575: * IN:
576: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
577: * This record type contains the Bank Account
578: * p_action_flag Indicates wether Bank account information needs
579: * to be inserted or updated.
580: * 'I' - Insert,'U' - Update related information.

Line 599: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

595: */
596:
597:
598: PROCEDURE MODIFY_BANK_ACCOUNTS
599: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
600: p_action_flag IN VARCHAR2,
601: x_return_status IN OUT NOCOPY VARCHAR2
602: )
603:

Line 608: FROM XTR_BANK_ACCOUNTS

604: IS
605: -- This cursor verifies if there is a lock on the row that user is trying to update
606: CURSOR c_chk_lock IS
607: SELECT ce_bank_account_id
608: FROM XTR_BANK_ACCOUNTS
609: WHERE ce_bank_account_id = p_xtr_bank_account_rec.ce_bank_account_id
610: FOR UPDATE NOWAIT;
611: record_lock EXCEPTION;
612: l_ce_bank_account_id XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE;

Line 612: l_ce_bank_account_id XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE;

608: FROM XTR_BANK_ACCOUNTS
609: WHERE ce_bank_account_id = p_xtr_bank_account_rec.ce_bank_account_id
610: FOR UPDATE NOWAIT;
611: record_lock EXCEPTION;
612: l_ce_bank_account_id XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE;
613:
614: BEGIN
615: -- Bug 5137819 Changed to insert the bank account in treasury while updation of treasury use
616: -- allowed flag in CE after the bank account is created for that bank branch.

Line 624: INSERT INTO XTR_BANK_ACCOUNTS

620: close c_chk_lock ;
621:
622: IF ( (p_action_flag = 'I') or (p_action_flag = 'U' and l_ce_bank_account_id Is Null )) THEN -- The bank account has to be inserted
623:
624: INSERT INTO XTR_BANK_ACCOUNTS
625: (account_number
626: ,authorised
627: ,party_code
628: ,party_type

Line 715: UPDATE XTR_BANK_ACCOUNTS

711: );
712:
713: ELSIF (p_action_flag = 'U' and l_ce_bank_account_id Is Not Null ) THEN -- The bank account has to be updated
714:
715: UPDATE XTR_BANK_ACCOUNTS
716: SET authorised = p_xtr_bank_account_rec.authorised
717: ,bank_code = p_xtr_bank_account_rec.bank_code
718: ,bank_short_code = p_xtr_bank_account_rec.bank_short_code
719: ,default_acct = p_xtr_bank_account_rec.default_acct

Line 952: * p_interest_rounding This is the ROUNDING_TYPE in XTR_BANK_ACCOUNTS.

948: * p_ce_bank_account_id This is the CE_BANK_ACCOUNT_ID in XTR_PARTY_INFO.
949: * CE will pass this parameter. This will tell us
950: * which Bank Account is attached with the interest
951: * schedule being updated.
952: * p_interest_rounding This is the ROUNDING_TYPE in XTR_BANK_ACCOUNTS.
953: * CE will pass this parameter. This will tell us
954: * what is the updated interest rounding.
955: * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.
956: * CE will pass this parameter. This will tell us

Line 955: * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.

951: * schedule being updated.
952: * p_interest_rounding This is the ROUNDING_TYPE in XTR_BANK_ACCOUNTS.
953: * CE will pass this parameter. This will tell us
954: * what is the updated interest rounding.
955: * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.
956: * CE will pass this parameter. This will tell us
957: * what is the updated Interest Includes.
958: * p_interest_calculation
959: * _basis This is the BASIS in XTR_BANK_ACCOUNTS.

Line 959: * _basis This is the BASIS in XTR_BANK_ACCOUNTS.

955: * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.
956: * CE will pass this parameter. This will tell us
957: * what is the updated Interest Includes.
958: * p_interest_calculation
959: * _basis This is the BASIS in XTR_BANK_ACCOUNTS.
960: * CE will pass this parameter. This will tell us
961: * what is the updated BASIS.
962: * p_day_count_basis This is the DAY_COUNT_BASIS in XTR_BANK_ACCOUNTS.
963: * CE will pass this parameter. This will tell us

Line 962: * p_day_count_basis This is the DAY_COUNT_BASIS in XTR_BANK_ACCOUNTS.

958: * p_interest_calculation
959: * _basis This is the BASIS in XTR_BANK_ACCOUNTS.
960: * CE will pass this parameter. This will tell us
961: * what is the updated BASIS.
962: * p_day_count_basis This is the DAY_COUNT_BASIS in XTR_BANK_ACCOUNTS.
963: * CE will pass this parameter. This will tell us
964: * what is the updated day count basis.
965: * IN/OUT:
966: *

Line 986: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id

982: *
983: */
984:
985: PROCEDURE REPLICATE_INTEREST_SCHEDULES
986: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
987: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
988: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
989: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
990: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,

Line 987: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,

983: */
984:
985: PROCEDURE REPLICATE_INTEREST_SCHEDULES
986: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
987: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
988: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
989: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
990: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
991: x_return_status OUT NOCOPY VARCHAR2,

Line 988: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,

984:
985: PROCEDURE REPLICATE_INTEREST_SCHEDULES
986: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
987: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
988: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
989: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
990: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
991: x_return_status OUT NOCOPY VARCHAR2,
992: x_msg_count OUT NOCOPY NUMBER,

Line 989: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,

985: PROCEDURE REPLICATE_INTEREST_SCHEDULES
986: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
987: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
988: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
989: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
990: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
991: x_return_status OUT NOCOPY VARCHAR2,
992: x_msg_count OUT NOCOPY NUMBER,
993: x_msg_data OUT NOCOPY VARCHAR2

Line 990: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,

986: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
987: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
988: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
989: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
990: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
991: x_return_status OUT NOCOPY VARCHAR2,
992: x_msg_count OUT NOCOPY NUMBER,
993: x_msg_data OUT NOCOPY VARCHAR2
994: )

Line 1000: FROM XTR_BANK_ACCOUNTS

996: IS
997:
998: CURSOR c_chk_lock_interest IS
999: SELECT ce_bank_account_id
1000: FROM XTR_BANK_ACCOUNTS
1001: WHERE ce_bank_account_id = p_ce_bank_account_id
1002: FOR UPDATE NOWAIT;
1003: l_ce_bank_account_id XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE;--change this
1004:

Line 1003: l_ce_bank_account_id XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE;--change this

999: SELECT ce_bank_account_id
1000: FROM XTR_BANK_ACCOUNTS
1001: WHERE ce_bank_account_id = p_ce_bank_account_id
1002: FOR UPDATE NOWAIT;
1003: l_ce_bank_account_id XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE;--change this
1004:
1005: BEGIN
1006: x_msg_count := NULL;
1007: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors

Line 1010: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null

1006: x_msg_count := NULL;
1007: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors
1008:
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null
1011: IF(p_ce_bank_account_id is null) THEN
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
1014: END IF;

Line 1013: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');

1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null
1011: IF(p_ce_bank_account_id is null) THEN
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
1014: END IF;
1015: -- Verifies if year calculated basis is '30/' and a day count basis type of Both Days for the same deal.
1016: IF(substr(p_day_count_basis,1,2) = '30' and p_interest_includes = 'B') THEN
1017: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1025: UPDATE XTR_BANK_ACCOUNTS

1021: OPEN c_chk_lock_interest;
1022: FETCH c_chk_lock_interest INTO l_ce_bank_account_id;
1023: IF c_chk_lock_interest%FOUND THEN
1024: CLOSE c_chk_lock_interest;
1025: UPDATE XTR_BANK_ACCOUNTS
1026: SET rounding_type = p_interest_rounding
1027: ,day_count_type = p_interest_includes
1028: ,year_calc_type = p_day_count_basis,
1029: interest_calculation_basis = p_interest_calculation_basis

Line 1042: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');

1038: ELSE
1039:
1040: CLOSE c_chk_lock_interest;
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
1043:
1044: END IF;
1045:
1046: END IF;