[Home] [Help]
PACKAGE: APPS.HZ_ACCOUNT_VALIDATE_V2PUB
Source
1 PACKAGE HZ_ACCOUNT_VALIDATE_V2PUB AS
2 /*$Header: ARH2ACVS.pls 120.2 2005/08/12 07:17:02 idali ship $ */
3
4 --------------------------------------
5 -- declaration of public procedures and functions
6 --------------------------------------
7
8 /**
9 * PROCEDURE validate_cust_account
10 *
11 * DESCRIPTION
12 * Validates customer account record. Checks for
13 * uniqueness
14 * lookup types
15 * mandatory columns
16 * non-updateable fields
17 * foreign key validations
18 * other validations
19 *
20 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
21 *
22 * ARGUMENTS
23 * IN:
24 * p_create_update_flag Create update flag. 'C' = create. 'U' = update.
25 * p_cust_account_rec Customer account record.
26 * p_rowid Rowid of the record (used only in update mode).
27 * IN/OUT:
28 * x_return_status Return status after the call. The status can
29 * be FND_API.G_RET_STS_SUCCESS (success),
30 * FND_API.G_RET_STS_ERROR (error),
31 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
32 *
33 * NOTES
34 *
35 * MODIFICATION HISTORY
36 *
37 * 07-23-2001 Jianying Huang o Created.
38 *
39 */
40
41 PROCEDURE validate_cust_account (
42 p_create_update_flag IN VARCHAR2,
43 p_cust_account_rec IN HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE,
44 p_rowid IN ROWID,
45 x_return_status IN OUT NOCOPY VARCHAR2
46 );
47
48 /**
49 * PROCEDURE validate_cust_acct_relate
50 *
51 * DESCRIPTION
52 * Validates customer account relate record. Checks for
53 * uniqueness
54 * lookup types
55 * mandatory columns
56 * non-updateable fields
57 * foreign key validations
58 * other validations
59 *
60 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
61 *
62 * ARGUMENTS
63 * IN:
64 * p_create_update_flag Create update flag. 'C' = create. 'U' = update.
65 * p_cust_account_rec Customer account relate record.
66 * p_rowid Rowid of the record (used only in update mode).
67 * IN/OUT:
68 * x_return_status Return status after the call. The status can
69 * be FND_API.G_RET_STS_SUCCESS (success),
70 * FND_API.G_RET_STS_ERROR (error),
71 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
72 *
73 * NOTES
74 *
75 * MODIFICATION HISTORY
76 *
77 * 07-23-2001 Jianying Huang o Created.
78 * 08-12-2005 Idris Ali o Bug 4529413:Replaced parameter rowid with cust_acct_relate_id.
79 *
80 */
81
82 PROCEDURE validate_cust_acct_relate (
83 p_create_update_flag IN VARCHAR2,
84 p_cust_acct_relate_rec IN HZ_CUST_ACCOUNT_V2PUB.CUST_ACCT_RELATE_REC_TYPE,
85 p_cust_acct_relate_id IN NUMBER, -- Bug 4529413
86 x_return_status IN OUT NOCOPY VARCHAR2
87 );
88
89 /**
90 * PROCEDURE validate_customer_profile
91 *
92 * DESCRIPTION
93 * Validates customer profile record. Checks for
94 * uniqueness
95 * lookup types
96 * mandatory columns
97 * non-updateable fields
98 * foreign key validations
99 * other validations
100 *
101 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
102 *
103 * ARGUMENTS
104 * IN:
105 * p_create_update_flag Create update flag. 'C' = create. 'U' = update.
106 * p_customer_profile_rec Customer profile record.
107 * p_rowid Rowid of the record (used only in update mode).
108 * IN/OUT:
109 * x_return_status Return status after the call. The status can
110 * be FND_API.G_RET_STS_SUCCESS (success),
111 * FND_API.G_RET_STS_ERROR (error),
112 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
113 *
114 * NOTES
115 *
116 * MODIFICATION HISTORY
117 *
118 * 07-23-2001 Jianying Huang o Created.
119 *
120 */
121
122 PROCEDURE validate_customer_profile (
123 p_create_update_flag IN VARCHAR2,
124 p_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
125 p_rowid IN ROWID,
126 x_return_status IN OUT NOCOPY VARCHAR2
127 );
128
129 /**
130 * PROCEDURE validate_cust_profile_amt
131 *
132 * DESCRIPTION
133 * Validates customer profile amount record. Checks for
134 * uniqueness
135 * lookup types
136 * mandatory columns
137 * non-updateable fields
138 * foreign key validations
139 * other validations
140 *
141 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
142 *
143 * ARGUMENTS
144 * IN:
145 * p_create_update_flag Create update flag. 'C' = create. 'U' = update.
146 * p_check_foreign_key If do foreign key checking on cust_account_id
147 * and cust_account_profile_id or not.
148 * p_cust_profile_amt_rec Customer profile amount record.
149 * p_rowid Rowid of the record (used only in update mode).
150 * IN/OUT:
151 * x_return_status Return status after the call. The status can
152 * be FND_API.G_RET_STS_SUCCESS (success),
153 * FND_API.G_RET_STS_ERROR (error),
154 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
155 *
156 * NOTES
157 *
158 * MODIFICATION HISTORY
159 *
160 * 07-23-2001 Jianying Huang o Created.
161 *
162 */
163
164 PROCEDURE validate_cust_profile_amt (
165 p_create_update_flag IN VARCHAR2,
166 p_check_foreign_key IN VARCHAR2,
167 p_cust_profile_amt_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,
168 p_rowid IN ROWID,
169 x_return_status IN OUT NOCOPY VARCHAR2
170 );
171
172 /**
173 * PROCEDURE validate_cust_acct_site
174 *
175 * DESCRIPTION
176 * Validates customer account site record. Checks for
177 * uniqueness
178 * lookup types
179 * mandatory columns
180 * non-updateable fields
181 * foreign key validations
182 * other validations
183 *
184 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
185 *
186 * ARGUMENTS
187 * IN:
188 * p_create_update_flag Create update flag. 'C' = create. 'U' = update.
189 * p_cust_acct_site_rec Customer account site record.
190 * p_rowid Rowid of the record (used only in update mode).
191 * IN/OUT:
192 * x_return_status Return status after the call. The status can
193 * be FND_API.G_RET_STS_SUCCESS (success),
194 * FND_API.G_RET_STS_ERROR (error),
195 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
196 *
197 * NOTES
198 *
199 * MODIFICATION HISTORY
200 *
201 * 07-23-2001 Jianying Huang o Created.
202 *
203 */
204
205 PROCEDURE validate_cust_acct_site (
206 p_create_update_flag IN VARCHAR2,
207 p_cust_acct_site_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE,
208 p_rowid IN ROWID,
209 x_return_status IN OUT NOCOPY VARCHAR2
210 );
211
212 /**
213 * PROCEDURE validate_cust_site_use
214 *
215 * DESCRIPTION
216 * Validates customer account site use record. Checks for
217 * uniqueness
218 * lookup types
219 * mandatory columns
220 * non-updateable fields
221 * foreign key validations
222 * other validations
223 *
224 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
225 *
226 * ARGUMENTS
227 * IN:
228 * p_create_update_flag Create update flag. 'C' = create. 'U' = update.
229 * p_cust_site_use_rec Customer account site use record.
230 * p_rowid Rowid of the record (used only in update mode).
231 * IN/OUT:
232 * x_return_status Return status after the call. The status can
233 * be FND_API.G_RET_STS_SUCCESS (success),
234 * FND_API.G_RET_STS_ERROR (error),
235 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
236 *
237 * NOTES
238 *
239 * MODIFICATION HISTORY
240 *
241 * 07-23-2001 Jianying Huang o Created.
242 *
243 */
244
245 PROCEDURE validate_cust_site_use (
246 p_create_update_flag IN VARCHAR2,
247 p_cust_site_use_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
248 p_rowid IN ROWID,
249 x_return_status IN OUT NOCOPY VARCHAR2
250 );
251
252 /**
253 * PROCEDURE validate_cust_account_role
254 *
255 * DESCRIPTION
256 * Validates customer account role record. Checks for
257 * uniqueness
258 * lookup types
259 * mandatory columns
260 * non-updateable fields
261 * foreign key validations
262 * other validations
263 *
264 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
265 *
266 * ARGUMENTS
267 * IN:
268 * p_create_update_flag Create update flag. 'C' = create. 'U' = update.
269 * p_cust_account_role_rec Customer account role record.
270 * p_rowid Rowid of the record (used only in update mode).
271 * IN/OUT:
272 * x_return_status Return status after the call. The status can
273 * be FND_API.G_RET_STS_SUCCESS (success),
274 * FND_API.G_RET_STS_ERROR (error),
275 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
276 *
277 * NOTES
278 *
279 * MODIFICATION HISTORY
280 *
281 * 07-23-2001 Jianying Huang o Created.
282 *
283 */
284
285 PROCEDURE validate_cust_account_role (
286 p_create_update_flag IN VARCHAR2,
287 p_cust_account_role_rec IN HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE,
288 p_rowid IN ROWID,
289 x_return_status IN OUT NOCOPY VARCHAR2
290 );
291
292 /**
293 * PROCEDURE validate_role_responsibility
294 *
295 * DESCRIPTION
296 * Validates customer account role responsibility record. Checks for
297 * uniqueness
298 * lookup types
299 * mandatory columns
300 * non-updateable fields
301 * foreign key validations
302 * other validations
303 *
304 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
305 *
306 * ARGUMENTS
307 * IN:
308 * p_create_update_flag Create update flag. 'C' = create. 'U' = update.
309 * p_role_responsibility_rec Customer account role responsibility record.
310 * p_rowid Rowid of the record (used only in update mode).
311 * IN/OUT:
312 * x_return_status Return status after the call. The status can
313 * be FND_API.G_RET_STS_SUCCESS (success),
314 * FND_API.G_RET_STS_ERROR (error),
315 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
316 *
317 * NOTES
318 *
319 * MODIFICATION HISTORY
320 *
321 * 07-23-2001 Jianying Huang o Created.
322 *
323 */
324
325 PROCEDURE validate_role_responsibility (
326 p_create_update_flag IN VARCHAR2,
327 p_role_responsibility_rec IN HZ_CUST_ACCOUNT_ROLE_V2PUB.ROLE_RESPONSIBILITY_REC_TYPE,
328 p_rowid IN ROWID,
329 x_return_status IN OUT NOCOPY VARCHAR2
330 );
331
332 END HZ_ACCOUNT_VALIDATE_V2PUB;