[Home] [Help]
PACKAGE: APPS.HZ_PARTY_USG_ASSIGNMENT_PVT
Source
1 PACKAGE HZ_PARTY_USG_ASSIGNMENT_PVT AS
2 /*$Header: ARHPUAPS.pls 120.2 2005/10/04 16:19:57 ansingha noship $ */
3
4
5 --------------------------------------
6 -- declaration of type
7 --------------------------------------
8
9 TYPE party_usg_assignment_rec_type IS RECORD (
10 party_id NUMBER(15),
11 party_usage_code VARCHAR2(30),
12 effective_start_date DATE,
13 effective_end_date DATE,
14 comments VARCHAR2(240),
15 owner_table_name VARCHAR2(30),
16 owner_table_id NUMBER(15),
17 created_by_module VARCHAR2(150),
18 attribute_category VARCHAR2(30),
19 attribute1 VARCHAR2(150),
20 attribute2 VARCHAR2(150),
21 attribute3 VARCHAR2(150),
22 attribute4 VARCHAR2(150),
23 attribute5 VARCHAR2(150),
24 attribute6 VARCHAR2(150),
25 attribute7 VARCHAR2(150),
26 attribute8 VARCHAR2(150),
27 attribute9 VARCHAR2(150),
28 attribute10 VARCHAR2(150),
29 attribute11 VARCHAR2(150),
30 attribute12 VARCHAR2(150),
31 attribute13 VARCHAR2(150),
32 attribute14 VARCHAR2(150),
33 attribute15 VARCHAR2(150),
34 attribute16 VARCHAR2(150),
35 attribute17 VARCHAR2(150),
36 attribute18 VARCHAR2(150),
37 attribute19 VARCHAR2(150),
38 attribute20 VARCHAR2(150)
39 );
40
41 --------------------------------------
42 -- public variables
43 --------------------------------------
44
45
46 G_VALID_LEVEL_FULL CONSTANT NUMBER := 100;
47 G_VALID_LEVEL_HIGH CONSTANT NUMBER := 75;
48 G_VALID_LEVEL_THIRD_MEDIUM CONSTANT NUMBER := 74;
49 G_VALID_LEVEL_MEDIUM CONSTANT NUMBER := 50;
50 G_VALID_LEVEL_LOW CONSTANT NUMBER := 25;
51 G_VALID_LEVEL_NONE CONSTANT NUMBER := 0;
52
53 --------------------------------------
54 -- public procedures and functions
55 --------------------------------------
56
57 /**
58 * PROCEDURE assign_party_usage
59 *
60 * DESCRIPTION
61 * Creates party usage assignment.
62 *
63 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
64 *
65 * ARGUMENTS
66 * IN:
67 * p_init_msg_list Initialize message stack if it is set to
68 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
69 * p_validation_level Validation level. Default is full validation.
70 * p_party_usg_assignment_rec Party usage assignment record.
71 * IN/OUT:
72 * OUT:
73 * x_return_status Return status after the call. The status can
74 * be FND_API.G_RET_STS_SUCCESS (success),
75 * FND_API.G_RET_STS_ERROR (error),
76 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
77 * x_msg_count Number of messages in message stack.
78 * x_msg_data Message text if x_msg_count is 1.
79 *
80 * NOTES
81 *
82 * MODIFICATION HISTORY
83 *
84 * 05/01/05 Jianying Huang o Created.
85 *
86 */
87
88 PROCEDURE assign_party_usage (
89 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
90 p_validation_level IN NUMBER DEFAULT NULL,
91 p_party_usg_assignment_rec IN party_usg_assignment_rec_type,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2
95 );
96
97
98 /**
99 * PROCEDURE inactivate_usg_assignment
100 *
101 * DESCRIPTION
102 * Inactivates party usage assignment.
103 *
104 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
105 *
106 * ARGUMENTS
107 * IN:
108 * p_init_msg_list Initialize message stack if it is set to
109 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
110 * p_validation_level Validation level. Default is full validation.
111 * p_party_usg_assignment_id Party usage assignment Id.
112 * p_party_id Party Id
113 * p_party_usage_code Party usage code
114 * IN/OUT:
115 * OUT:
116 * x_return_status Return status after the call. The status can
117 * be FND_API.G_RET_STS_SUCCESS (success),
118 * FND_API.G_RET_STS_ERROR (error),
119 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
120 * x_msg_count Number of messages in message stack.
121 * x_msg_data Message text if x_msg_count is 1.
122 *
123 * NOTES
124 *
125 * MODIFICATION HISTORY
126 *
127 * 05/01/05 Jianying Huang o Created.
128 *
129 */
130
131 PROCEDURE inactivate_usg_assignment (
132 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
133 p_validation_level IN NUMBER DEFAULT NULL,
134 p_party_usg_assignment_id IN NUMBER DEFAULT NULL,
135 p_party_id IN NUMBER DEFAULT NULL,
136 p_party_usage_code IN VARCHAR2 DEFAULT NULL,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2
140 );
141
142
143 /**
144 * PROCEDURE update_usg_assignment
145 *
146 * DESCRIPTION
147 * Update party usage assignment.
148 *
149 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
150 *
151 * ARGUMENTS
152 * IN:
153 * p_init_msg_list Initialize message stack if it is set to
154 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
155 * p_validation_level Validation level. Default is full validation.
156 * p_party_usg_assignment_id Party usage assignment Id.
157 * p_party_usg_assignment_rec Party usage assignment record.
158 * IN/OUT:
159 * OUT:
160 * x_return_status Return status after the call. The status can
161 * be FND_API.G_RET_STS_SUCCESS (success),
162 * FND_API.G_RET_STS_ERROR (error),
163 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
164 * x_msg_count Number of messages in message stack.
165 * x_msg_data Message text if x_msg_count is 1.
166 *
167 * NOTES
168 *
169 * MODIFICATION HISTORY
170 *
171 * 05/01/05 Jianying Huang o Created.
172 *
173 */
174
175 PROCEDURE update_usg_assignment (
176 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
177 p_validation_level IN NUMBER DEFAULT NULL,
178 p_party_usg_assignment_id IN NUMBER DEFAULT NULL,
179 p_party_usg_assignment_rec IN party_usg_assignment_rec_type,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2
183 );
184
185
186 /**
187 * PROCEDURE refresh
188 *
189 * DESCRIPTION
190 * Refresh the cached setup. Need to be called when the party usage setup
191 * is changed via admin UI.
192 *
193 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
194 *
195 * NOTES
196 *
197 * MODIFICATION HISTORY
198 *
199 * 05/01/05 Jianying Huang o Created.
200 *
201 */
202
203 PROCEDURE refresh;
204
205
206 /**
207 * PROCEDURE set_calling_api
208 *
209 * DESCRIPTION
210 * Set calling api. Internal use only.
211 *
212 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
213 *
214 * NOTES
215 *
216 * MODIFICATION HISTORY
217 *
218 * 05/01/05 Jianying Huang o Created.
219 *
220 */
221
222 PROCEDURE set_calling_api (
223 p_calling_api IN VARCHAR2
224 );
225
226
227 /**
228 * FUNCTION allow_party_merge
229 *
230 * DESCRIPTION
231 * Created for party merge. Check party usage
232 * rules to determine if merge is allowed.
233 *
234 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
235 *
236 * NOTES
237 *
238 * MODIFICATION HISTORY
239 *
240 * 07/19/05 Jianying Huang o Created.
241 *
242 */
243
244 FUNCTION allow_party_merge (
245 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
246 p_from_party_id IN NUMBER,
247 p_to_party_id IN NUMBER,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2
250 ) RETURN VARCHAR2;
251
252
253 /**
254 * FUNCTION find_duplicates
255 *
256 * DESCRIPTION
257 * Created for party merge. Find duplicate assignment.
258 *
259 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
260 *
261 * NOTES
262 *
263 * MODIFICATION HISTORY
264 *
265 * 07/19/05 Jianying Huang o Created.
266 *
267 */
268
269 PROCEDURE find_duplicates (
270 p_from_assignment_id IN NUMBER,
271 p_to_party_id IN NUMBER,
272 x_to_assignment_id OUT NOCOPY NUMBER
273 );
274
275 --------------------------------Bug 4586451
276 /**
277 * PROCEDURE validate_supplier_name
278 *
279 * DESCRIPTION
280 * Validate supplier name.
281 *
282 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
283 *
284 * ARGUMENTS
285 * IN:
286 * p_party_id party id
287 * p_party_name party name
288 * x_return_status return status
289 *
290 * NOTES
291 *
292 * MODIFICATION HISTORY
293 */
294
295 PROCEDURE validate_supplier_name (
296 p_party_id IN NUMBER,
297 p_party_name IN VARCHAR2,
298 x_return_status IN OUT NOCOPY VARCHAR2
299 );
300 ----------------------------Bug 4586451
301
302
303 END HZ_PARTY_USG_ASSIGNMENT_PVT;