1 PACKAGE XTR_REPLICATE_BANK_BRANCHES_P AS
2 /* | $Header: xtrrbkbs.pls 120.4 2005/07/29 08:01:04 badiredd noship $ | */
3
4 /* This package is used to replicate the Bank Branches created in CE into XTR tables.
5 */
6 /**
7 * PROCEDURE update_bank_branchess
8 *
9 * DESCRIPTION
10 * This procedure is called directly by CE to update
11 * the bank branch related data into XTR tables.
12 *
13 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
14 *
15 * ARGUMENTS
16 * IN:
17 *
18 * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.
19 * This record type contains the Bank/Bank Branch
20 * related information about the bank attached with
21 * Bank Account.
22 * IN/OUT:
23 *
24 * OUT:
25 * x_return_status Return status after the call. The
26 * status can be
27 * FND_API.G_RET_STS_SUCCESS - for success
28 * FND_API.G_RET_STS_ERR - for expected error
29 * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
30 * x_msg_count To return the number of error messages
31 * in stack
32 * x_msg_data To return the error message if
33 * x_msg_count = 1.
34 * NOTES
35 *
36 * MODIFICATION HISTORY
37 *
38 * 06-17-2005 Bhargav Adireddy o Created.
39 *
40 */
41
42 PROCEDURE UPDATE_BANK_BRANCHES
43 ( p_xtr_party_info_rec IN XTR_PARTY_INFO%ROWTYPE,
44 p_update_type IN NUMBER,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2
48 );
49
50
51 /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
52 PROCEDURE UPDATE_BANK_BRANCHES
53 ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
54 p_short_name IN XTR_PARTY_INFO.short_name%TYPE,
55 p_full_name IN XTR_PARTY_INFO.full_name%TYPE,
56 p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62
63 /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
64 PROCEDURE UPDATE_BANK_BRANCHES
65 ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
66 p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
67 p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
68 p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
69 p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
70 p_country_code IN XTR_PARTY_INFO.country_code%TYPE,
71 p_state_code IN XTR_PARTY_INFO.state_code%TYPE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2
75 );
76
77
78 /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
79 PROCEDURE UPDATE_BANK_BRANCHES
80 ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
81 p_contact_name IN XTR_PARTY_INFO.contact_name%TYPE,
82 p_email_address IN XTR_PARTY_INFO.email_address%TYPE,
83 p_fax_number IN XTR_PARTY_INFO.fax_number%TYPE,
84 p_phone_number IN XTR_PARTY_INFO.phone_number%TYPE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2
88 );
89
90
91 /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
92 PROCEDURE UPDATE_BANK_BRANCHES
93 ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
94 p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
95 p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
96 p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
97 p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
98 p_p_address_1 IN XTR_PARTY_INFO.p_address_1%TYPE,
99 p_p_address_2 IN XTR_PARTY_INFO.p_address_2%TYPE,
100 p_p_address_3 IN XTR_PARTY_INFO.p_address_3%TYPE,
101 p_p_address_4 IN XTR_PARTY_INFO.p_address_4%TYPE,
102 p_state_code IN XTR_PARTY_INFO.state_code%TYPE,
103 p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2
107 );
108
109
110
111
112
113 /**
114 * PROCEDURE validate_bank_branch
115 *
116 * DESCRIPTION
117 * This procedure is used to validate the Bank/Bank Branch related data
118 * before it is inserted into XTR_PARTY_INFO. This procedure will perform the
119 * required validations and puts the corresponding error messages into list
120 *
121 *
122 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
123 *
124 * ARGUMENTS
125 * IN:
126 * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.
127 * This record type contains the Bank/Bank Branch
128 * related information about the bank attached with
129 * Bank Account.
130 * IN/OUT:
131 *
132 * OUT:
133 * x_return_status Return status after the call. The
134 * status can be
135 * FND_API.G_RET_STS_SUCCESS - for success
136 * FND_API.G_RET_STS_ERR - for expected error
137 * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
138 * NOTES
139 *
140 * MODIFICATION HISTORY
141 *
142 * 06-17-2005 Bhargav Adireddy o Created.
143 *
144 */
145
146 PROCEDURE VALIDATE_BANK_BRANCH
147 ( p_xtr_party_info_rec IN XTR_PARTY_INFO%ROWTYPE,
148 p_update_type IN NUMBER,
149 x_return_status IN OUT NOCOPY VARCHAR2
150 );
151
152 /**
153 * PROCEDURE modify_bank_branch
154 *
155 * DESCRIPTION
156 * This procedure will update XTR_PARTY_INFO table with the
157 * Bank Branch data passed form CE.
158 *
159 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
160 *
161 * ARGUMENTS
162 * IN:
163 * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.
164 * This record type contains the Bank/Bank Branch
165 * related information about the bank attached with
166 * Bank Account. related information.
167 * IN/OUT:
168 *
169 * OUT:
170 * x_return_status Return status after the call. The
171 * status can be
172 * FND_API.G_RET_STS_SUCCESS - for success
173 * FND_API.G_RET_STS_ERR - for expected error
174 * FND_API.G_RET_STS_UNEXP_ERR - for unexpected error
175 * NOTES
176 *
177 * MODIFICATION HISTORY
178 *
179 * 05-19-2005 Bhargav Adireddy o Created.
180 *
181 */
182
183
184 PROCEDURE MODIFY_BANK_BRANCH
185 ( p_xtr_party_info_rec IN XTR_PARTY_INFO%ROWTYPE,
186 p_update_type IN NUMBER,
187 x_return_status IN OUT NOCOPY VARCHAR2
188 );
189
190 /**
191 * FUNCTION chk_bank_branch
192 *
193 * DESCRIPTION
194 * This Function will verify if a particular bank_branch_id exists in
195 * XTR_PARTY_INFO table with the Bank Branch ID passed form CE. This returns
196 * a BOOLEAN
197 *
198 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
199 * XTR_REPLICATE_BANK_ACCOUNTS_P.LOG_ERR_MSG()
200 * ARGUMENTS
201 * IN:
202 * p_ce_bank_branch_id This is type of CE_BANK_BRANCH_ID present in
203 * XTR_PARTY_INFO. CE will pass the Bank Branch
204 * id for which it is going to create an account.
205 * IN/OUT:
206 *
207 * OUT:
208 * This Function returns a Boolean. TRUE if the Bank Branch exists in
209 * XTR_PARTY_INFO and FALSE if the Bank Branch does not exist in
210 * XTR_PARTY_INFO
211 * NOTES
212 *
213 * MODIFICATION HISTORY
214 *
215 * 06-17-2005 Bhargav Adireddy o Created.
216 *
217 */
218
219 FUNCTION CHK_BANK_BRANCH
220 ( p_ce_bank_branch_id IN XTR_PARTY_INFO.CE_BANK_BRANCH_ID%TYPE)
221 RETURN BOOLEAN;
222
223 END XTR_REPLICATE_BANK_BRANCHES_P; -- Package spec
224