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 176: l_xtr_bank_accounts_rec XTR_BANK_ACCOUNTS%ROWTYPE;

172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2
175: ) IS
176: l_xtr_bank_accounts_rec XTR_BANK_ACCOUNTS%ROWTYPE;
177:
178: BEGIN
179:
180: l_xtr_bank_accounts_rec.account_number := p_account_number;

Line 180: l_xtr_bank_accounts_rec.account_number := p_account_number;

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

Line 181: l_xtr_bank_accounts_rec.authorised := p_authorised;

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

Line 182: l_xtr_bank_accounts_rec.party_code := p_party_code;

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

Line 183: l_xtr_bank_accounts_rec.party_type := p_party_type;

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

Line 184: l_xtr_bank_accounts_rec.bank_code := p_bank_code;

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

Line 185: l_xtr_bank_accounts_rec.currency := p_currency;

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

Line 186: l_xtr_bank_accounts_rec.bank_short_code := p_bank_short_code;

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

Line 187: l_xtr_bank_accounts_rec.default_acct := p_default_acct;

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

Line 188: l_xtr_bank_accounts_rec.eft_script_name := p_eft_script_name;

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

Line 189: l_xtr_bank_accounts_rec.code_combination_id := p_code_combination_id;

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

Line 190: l_xtr_bank_accounts_rec.interest_calculation_basis := p_interest_calculation_basis;

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

Line 191: l_xtr_bank_accounts_rec.location := p_location;

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

Line 192: l_xtr_bank_accounts_rec.portfolio_code := p_portfolio_code;

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

Line 193: l_xtr_bank_accounts_rec.primary_settlement_method := p_primary_settlement_method;

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

Line 195: l_xtr_bank_accounts_rec.street := SUBSTR(p_street,1,35);

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

Line 197: l_xtr_bank_accounts_rec.year_calc_type := p_year_calc_type;

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

Line 198: l_xtr_bank_accounts_rec.swift_id := p_swift_id;

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

Line 199: l_xtr_bank_accounts_rec.attribute_category := p_attribute_category;

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

Line 200: l_xtr_bank_accounts_rec.attribute1 := p_attribute1;

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

Line 201: l_xtr_bank_accounts_rec.attribute2 := p_attribute2;

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

Line 202: l_xtr_bank_accounts_rec.attribute3 := p_attribute3;

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

Line 203: l_xtr_bank_accounts_rec.attribute4 := p_attribute4;

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

Line 204: l_xtr_bank_accounts_rec.attribute5 := p_attribute5;

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

Line 205: l_xtr_bank_accounts_rec.attribute6 := p_attribute6;

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

Line 206: l_xtr_bank_accounts_rec.attribute7 := p_attribute7;

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

Line 207: l_xtr_bank_accounts_rec.attribute8 := p_attribute8;

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

Line 208: l_xtr_bank_accounts_rec.attribute9 := p_attribute9;

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

Line 209: l_xtr_bank_accounts_rec.attribute10 := p_attribute10;

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

Line 210: l_xtr_bank_accounts_rec.attribute11 := p_attribute11;

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

Line 211: l_xtr_bank_accounts_rec.attribute12 := p_attribute12;

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

Line 212: l_xtr_bank_accounts_rec.attribute13 := p_attribute13;

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

Line 213: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;

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

Line 214: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;

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

Line 215: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;

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

Line 216: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;

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

Line 217: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;

213: l_xtr_bank_accounts_rec.attribute14 := p_attribute14;
214: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;
215: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;
216: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;
217: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;
218: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;
219: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;
220:
221: REPLICATE_BANK_ACCOUNTS(l_xtr_bank_accounts_rec,p_action_flag,

Line 218: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;

214: l_xtr_bank_accounts_rec.attribute15 := p_attribute15;
215: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;
216: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;
217: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;
218: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;
219: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;
220:
221: REPLICATE_BANK_ACCOUNTS(l_xtr_bank_accounts_rec,p_action_flag,
222: x_return_status,x_msg_count,x_msg_data);

Line 219: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;

215: l_xtr_bank_accounts_rec.pricing_model := p_pricing_model;
216: l_xtr_bank_accounts_rec.legal_account_name := p_legal_account_name;
217: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;
218: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;
219: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;
220:
221: REPLICATE_BANK_ACCOUNTS(l_xtr_bank_accounts_rec,p_action_flag,
222: x_return_status,x_msg_count,x_msg_data);
223:

Line 221: REPLICATE_BANK_ACCOUNTS(l_xtr_bank_accounts_rec,p_action_flag,

217: l_xtr_bank_accounts_rec.ce_bank_account_id := p_ce_bank_account_id;
218: l_xtr_bank_accounts_rec.bank_branch_id := p_bank_branch_id;
219: l_xtr_bank_accounts_rec.bank_acct_use_id := p_bank_acct_use_id;
220:
221: REPLICATE_BANK_ACCOUNTS(l_xtr_bank_accounts_rec,p_action_flag,
222: x_return_status,x_msg_count,x_msg_data);
223:
224: EXCEPTION
225: WHEN others THEN

Line 248: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

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

Line 269: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

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

Line 317: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

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

Line 337: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

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

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

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

Line 380: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

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

Line 400: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

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

Line 427: from xtr_bank_accounts

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

Line 434: l_pm_authorized XTR_BANK_ACCOUNTS.PRICING_MODEL%TYPE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 573: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

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

Line 596: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

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

Line 605: FROM XTR_BANK_ACCOUNTS

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

Line 609: l_ce_bank_account_id XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE;

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

Line 621: INSERT INTO XTR_BANK_ACCOUNTS

617: close c_chk_lock ;
618:
619: 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
620:
621: INSERT INTO XTR_BANK_ACCOUNTS
622: (account_number
623: ,authorised
624: ,party_code
625: ,party_type

Line 710: UPDATE XTR_BANK_ACCOUNTS

706: );
707:
708: ELSIF (p_action_flag = 'U' and l_ce_bank_account_id Is Not Null ) THEN -- The bank account has to be updated
709:
710: UPDATE XTR_BANK_ACCOUNTS
711: SET authorised = p_xtr_bank_account_rec.authorised
712: ,bank_code = p_xtr_bank_account_rec.bank_code
713: ,bank_short_code = p_xtr_bank_account_rec.bank_short_code
714: ,default_acct = p_xtr_bank_account_rec.default_acct

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

942: * p_ce_bank_account_id This is the CE_BANK_ACCOUNT_ID in XTR_PARTY_INFO.
943: * CE will pass this parameter. This will tell us
944: * which Bank Account is attached with the interest
945: * schedule being updated.
946: * p_interest_rounding This is the ROUNDING_TYPE in XTR_BANK_ACCOUNTS.
947: * CE will pass this parameter. This will tell us
948: * what is the updated interest rounding.
949: * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.
950: * CE will pass this parameter. This will tell us

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

945: * schedule being updated.
946: * p_interest_rounding This is the ROUNDING_TYPE in XTR_BANK_ACCOUNTS.
947: * CE will pass this parameter. This will tell us
948: * what is the updated interest rounding.
949: * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.
950: * CE will pass this parameter. This will tell us
951: * what is the updated Interest Includes.
952: * p_interest_calculation
953: * _basis This is the BASIS in XTR_BANK_ACCOUNTS.

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

949: * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.
950: * CE will pass this parameter. This will tell us
951: * what is the updated Interest Includes.
952: * p_interest_calculation
953: * _basis This is the BASIS in XTR_BANK_ACCOUNTS.
954: * CE will pass this parameter. This will tell us
955: * what is the updated BASIS.
956: * p_day_count_basis This is the DAY_COUNT_BASIS in XTR_BANK_ACCOUNTS.
957: * CE will pass this parameter. This will tell us

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

952: * p_interest_calculation
953: * _basis This is the BASIS in XTR_BANK_ACCOUNTS.
954: * CE will pass this parameter. This will tell us
955: * what is the updated BASIS.
956: * p_day_count_basis This is the DAY_COUNT_BASIS in XTR_BANK_ACCOUNTS.
957: * CE will pass this parameter. This will tell us
958: * what is the updated day count basis.
959: * IN/OUT:
960: *

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

976: *
977: */
978:
979: PROCEDURE REPLICATE_INTEREST_SCHEDULES
980: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
981: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
982: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
983: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
984: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,

Line 981: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,

977: */
978:
979: PROCEDURE REPLICATE_INTEREST_SCHEDULES
980: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
981: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
982: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
983: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
984: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
985: x_return_status OUT NOCOPY VARCHAR2,

Line 982: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,

978:
979: PROCEDURE REPLICATE_INTEREST_SCHEDULES
980: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
981: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
982: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
983: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
984: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
985: x_return_status OUT NOCOPY VARCHAR2,
986: x_msg_count OUT NOCOPY NUMBER,

Line 983: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,

979: PROCEDURE REPLICATE_INTEREST_SCHEDULES
980: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
981: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
982: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
983: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
984: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
985: x_return_status OUT NOCOPY VARCHAR2,
986: x_msg_count OUT NOCOPY NUMBER,
987: x_msg_data OUT NOCOPY VARCHAR2

Line 984: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,

980: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
981: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
982: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
983: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
984: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
985: x_return_status OUT NOCOPY VARCHAR2,
986: x_msg_count OUT NOCOPY NUMBER,
987: x_msg_data OUT NOCOPY VARCHAR2
988: )

Line 994: FROM XTR_BANK_ACCOUNTS

990: IS
991:
992: CURSOR c_chk_lock_interest IS
993: SELECT ce_bank_account_id
994: FROM XTR_BANK_ACCOUNTS
995: WHERE ce_bank_account_id = p_ce_bank_account_id
996: FOR UPDATE NOWAIT;
997: l_ce_bank_account_id XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE;--change this
998:

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

993: SELECT ce_bank_account_id
994: FROM XTR_BANK_ACCOUNTS
995: WHERE ce_bank_account_id = p_ce_bank_account_id
996: FOR UPDATE NOWAIT;
997: l_ce_bank_account_id XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE;--change this
998:
999: BEGIN
1000: x_msg_count := NULL;
1001: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors

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

1000: x_msg_count := NULL;
1001: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors
1002:
1003: x_return_status := FND_API.G_RET_STS_SUCCESS;
1004: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null
1005: IF(p_ce_bank_account_id is null) THEN
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
1008: END IF;

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

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

Line 1019: UPDATE XTR_BANK_ACCOUNTS

1015: OPEN c_chk_lock_interest;
1016: FETCH c_chk_lock_interest INTO l_ce_bank_account_id;
1017: IF c_chk_lock_interest%FOUND THEN
1018: CLOSE c_chk_lock_interest;
1019: UPDATE XTR_BANK_ACCOUNTS
1020: SET rounding_type = p_interest_rounding
1021: ,day_count_type = p_interest_includes
1022: ,year_calc_type = p_day_count_basis,
1023: interest_calculation_basis = p_interest_calculation_basis

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

1032: ELSE
1033:
1034: CLOSE c_chk_lock_interest;
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: LOG_ERR_MSG('XTR_INV_PARAM','XTR_BANK_ACCOUNTS.ce_bank_account_id');
1037:
1038: END IF;
1039:
1040: END IF;