[Home] [Help]
PACKAGE BODY: APPS.HZ_PARTIES_PKG
Source
1 PACKAGE BODY HZ_PARTIES_PKG AS
2 /*$Header: ARHPTYTB.pls 120.6 2006/05/05 09:20:42 pkasturi ship $ */
3
4 FUNCTION do_copy_duns_number(
5 p_duns_number_c IN VARCHAR2
6 ) RETURN NUMBER IS
7
8 l_char VARCHAR2(1);
9 l_str HZ_PARTIES.DUNS_NUMBER_C%TYPE;
10
11 BEGIN
12
13 -- if duns_number is null and duns_number_c is not null then get the
14 -- value of duns_number_c, convert it to number and copy it to duns_number
15
16 /* Bug 3435702.This check is done before calling this procedure and as such is redundant.
17 |
18 | IF p_duns_number_c IS NOT NULL AND
19 | p_duns_number_c <> FND_API.G_MISS_CHAR
20 | THEN
21 */
22 FOR i IN 1..LENGTHB(p_duns_number_c) LOOP
23 l_char := SUBSTRB(p_duns_number_c, i, 1);
24 IF (l_char >= '0' AND l_char <= '9') THEN
25 l_str := l_str || l_char;
26 END IF;
27 END LOOP;
28 RETURN TO_NUMBER(l_str);
29 /* END IF;*/
30
31 RETURN NULL;
32
33 END do_copy_duns_number;
34
35 PROCEDURE Insert_Row (
36 X_PARTY_ID IN OUT NOCOPY NUMBER,
37 X_PARTY_NUMBER IN OUT NOCOPY VARCHAR2,
38 X_PARTY_NAME IN VARCHAR2,
39 X_PARTY_TYPE IN VARCHAR2,
40 X_VALIDATED_FLAG IN VARCHAR2,
41 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
42 X_ATTRIBUTE1 IN VARCHAR2,
43 X_ATTRIBUTE2 IN VARCHAR2,
44 X_ATTRIBUTE3 IN VARCHAR2,
45 X_ATTRIBUTE4 IN VARCHAR2,
46 X_ATTRIBUTE5 IN VARCHAR2,
47 X_ATTRIBUTE6 IN VARCHAR2,
48 X_ATTRIBUTE7 IN VARCHAR2,
49 X_ATTRIBUTE8 IN VARCHAR2,
50 X_ATTRIBUTE9 IN VARCHAR2,
51 X_ATTRIBUTE10 IN VARCHAR2,
52 X_ATTRIBUTE11 IN VARCHAR2,
53 X_ATTRIBUTE12 IN VARCHAR2,
54 X_ATTRIBUTE13 IN VARCHAR2,
55 X_ATTRIBUTE14 IN VARCHAR2,
56 X_ATTRIBUTE15 IN VARCHAR2,
57 X_ATTRIBUTE16 IN VARCHAR2,
58 X_ATTRIBUTE17 IN VARCHAR2,
59 X_ATTRIBUTE18 IN VARCHAR2,
60 X_ATTRIBUTE19 IN VARCHAR2,
61 X_ATTRIBUTE20 IN VARCHAR2,
62 X_ATTRIBUTE21 IN VARCHAR2,
63 X_ATTRIBUTE22 IN VARCHAR2,
64 X_ATTRIBUTE23 IN VARCHAR2,
65 X_ATTRIBUTE24 IN VARCHAR2,
66 X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
67 X_SIC_CODE IN VARCHAR2,
68 X_HQ_BRANCH_IND IN VARCHAR2,
69 X_CUSTOMER_KEY IN VARCHAR2,
70 X_TAX_REFERENCE IN VARCHAR2,
71 X_JGZZ_FISCAL_CODE IN VARCHAR2,
72 X_PERSON_PRE_NAME_ADJUNCT IN VARCHAR2,
73 X_PERSON_FIRST_NAME IN VARCHAR2,
74 X_PERSON_MIDDLE_NAME IN VARCHAR2,
75 X_PERSON_LAST_NAME IN VARCHAR2,
76 X_PERSON_NAME_SUFFIX IN VARCHAR2,
77 X_PERSON_TITLE IN VARCHAR2,
78 X_PERSON_ACADEMIC_TITLE IN VARCHAR2,
79 X_PERSON_PREVIOUS_LAST_NAME IN VARCHAR2,
80 X_KNOWN_AS IN VARCHAR2,
81 X_PERSON_IDEN_TYPE IN VARCHAR2,
82 X_PERSON_IDENTIFIER IN VARCHAR2,
83 X_GROUP_TYPE IN VARCHAR2,
84 X_COUNTRY IN VARCHAR2,
85 X_ADDRESS1 IN VARCHAR2,
86 X_ADDRESS2 IN VARCHAR2,
87 X_ADDRESS3 IN VARCHAR2,
88 X_ADDRESS4 IN VARCHAR2,
89 X_CITY IN VARCHAR2,
90 X_POSTAL_CODE IN VARCHAR2,
91 X_STATE IN VARCHAR2,
92 X_PROVINCE IN VARCHAR2,
93 X_STATUS IN VARCHAR2,
94 X_COUNTY IN VARCHAR2,
95 X_SIC_CODE_TYPE IN VARCHAR2,
96 X_URL IN VARCHAR2,
97 X_EMAIL_ADDRESS IN VARCHAR2,
98 X_ANALYSIS_FY IN VARCHAR2,
99 X_FISCAL_YEAREND_MONTH IN VARCHAR2,
100 X_EMPLOYEES_TOTAL IN NUMBER,
101 X_CURR_FY_POTENTIAL_REVENUE IN NUMBER,
102 X_NEXT_FY_POTENTIAL_REVENUE IN NUMBER,
103 X_YEAR_ESTABLISHED IN NUMBER,
104 X_GSA_INDICATOR_FLAG IN VARCHAR2,
105 X_MISSION_STATEMENT IN VARCHAR2,
106 X_ORGANIZATION_NAME_PHONETIC IN VARCHAR2,
107 X_PERSON_FIRST_NAME_PHONETIC IN VARCHAR2,
108 X_PERSON_LAST_NAME_PHONETIC IN VARCHAR2,
109 X_LANGUAGE_NAME IN VARCHAR2,
110 X_CATEGORY_CODE IN VARCHAR2,
111 X_SALUTATION IN VARCHAR2,
112 X_KNOWN_AS2 IN VARCHAR2,
113 X_KNOWN_AS3 IN VARCHAR2,
114 X_KNOWN_AS4 IN VARCHAR2,
115 X_KNOWN_AS5 IN VARCHAR2,
116 X_OBJECT_VERSION_NUMBER IN NUMBER,
117 X_DUNS_NUMBER_C IN VARCHAR2,
118 X_CREATED_BY_MODULE IN VARCHAR2,
119 X_APPLICATION_ID IN NUMBER
120 ) IS
121
122 l_duns_number NUMBER;
123 l_success VARCHAR2(1) := 'N';
124 l_duns_number_c HZ_PARTIES.duns_number_c%type := X_DUNS_NUMBER_C;
125 BEGIN
126
127 IF x_duns_number_c IS NOT NULL AND
128 x_duns_number_c <> FND_API.G_MISS_CHAR
129 THEN
130 l_duns_number := do_copy_duns_number(x_duns_number_c);
131 END IF;
132
133 IF x_duns_number_c IS NOT NULL AND
134 x_duns_number_c <> FND_API.G_MISS_CHAR AND
135 LENGTHB(x_duns_number_c)<9
136 THEN
137 l_duns_number_c:=lpad(x_duns_number_c,9,'0');
138 END IF;
139
140 WHILE l_success = 'N' LOOP
141 BEGIN
142 INSERT INTO HZ_PARTIES (
143 PARTY_ID,
144 PARTY_NUMBER,
145 PARTY_NAME,
146 PARTY_TYPE,
147 VALIDATED_FLAG,
148 LAST_UPDATED_BY,
149 CREATION_DATE,
150 LAST_UPDATE_LOGIN,
151 REQUEST_ID,
152 PROGRAM_APPLICATION_ID,
153 CREATED_BY,
154 LAST_UPDATE_DATE,
155 PROGRAM_ID,
156 PROGRAM_UPDATE_DATE,
157 ATTRIBUTE_CATEGORY,
158 ATTRIBUTE1,
159 ATTRIBUTE2,
160 ATTRIBUTE3,
161 ATTRIBUTE4,
162 ATTRIBUTE5,
163 ATTRIBUTE6,
164 ATTRIBUTE7,
165 ATTRIBUTE8,
166 ATTRIBUTE9,
167 ATTRIBUTE10,
168 ATTRIBUTE11,
169 ATTRIBUTE12,
170 ATTRIBUTE13,
171 ATTRIBUTE14,
172 ATTRIBUTE15,
173 ATTRIBUTE16,
174 ATTRIBUTE17,
175 ATTRIBUTE18,
176 ATTRIBUTE19,
177 ATTRIBUTE20,
178 ATTRIBUTE21,
179 ATTRIBUTE22,
180 ATTRIBUTE23,
181 ATTRIBUTE24,
182 ORIG_SYSTEM_REFERENCE,
183 SIC_CODE,
184 HQ_BRANCH_IND,
185 CUSTOMER_KEY,
186 TAX_REFERENCE,
187 JGZZ_FISCAL_CODE,
188 PERSON_PRE_NAME_ADJUNCT,
189 PERSON_FIRST_NAME,
190 PERSON_MIDDLE_NAME,
191 PERSON_LAST_NAME,
192 PERSON_NAME_SUFFIX,
193 PERSON_TITLE,
194 PERSON_ACADEMIC_TITLE,
195 PERSON_PREVIOUS_LAST_NAME,
196 KNOWN_AS,
197 PERSON_IDEN_TYPE,
198 PERSON_IDENTIFIER,
199 GROUP_TYPE,
200 COUNTRY,
201 ADDRESS1,
202 ADDRESS2,
203 ADDRESS3,
204 ADDRESS4,
205 CITY,
206 POSTAL_CODE,
207 STATE,
208 PROVINCE,
209 STATUS,
210 COUNTY,
211 SIC_CODE_TYPE,
212 URL,
213 EMAIL_ADDRESS,
214 ANALYSIS_FY,
215 FISCAL_YEAREND_MONTH,
216 EMPLOYEES_TOTAL,
217 CURR_FY_POTENTIAL_REVENUE,
218 NEXT_FY_POTENTIAL_REVENUE,
219 YEAR_ESTABLISHED,
220 GSA_INDICATOR_FLAG,
221 MISSION_STATEMENT,
222 ORGANIZATION_NAME_PHONETIC,
223 PERSON_FIRST_NAME_PHONETIC,
224 PERSON_LAST_NAME_PHONETIC,
225 LANGUAGE_NAME,
226 CATEGORY_CODE,
227 SALUTATION,
228 KNOWN_AS2,
229 KNOWN_AS3,
230 KNOWN_AS4,
231 KNOWN_AS5,
232 OBJECT_VERSION_NUMBER,
233 DUNS_NUMBER_C,
234 DUNS_NUMBER,
235 CREATED_BY_MODULE,
236 APPLICATION_ID
237 )
238 VALUES (
239 DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, HZ_PARTIES_S.NEXTVAL, NULL, HZ_PARTIES_S.NEXTVAL, X_PARTY_ID ),
240 DECODE( X_PARTY_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), X_PARTY_NUMBER ),
241 DECODE( X_PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
242 DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
243 DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),
244 HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
245 HZ_UTILITY_V2PUB.CREATION_DATE,
246 HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
247 HZ_UTILITY_V2PUB.REQUEST_ID,
248 HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
249 HZ_UTILITY_V2PUB.CREATED_BY,
250 HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
251 HZ_UTILITY_V2PUB.PROGRAM_ID,
252 HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
253 DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
254 DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
255 DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
256 DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
257 DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
258 DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
259 DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
260 DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
261 DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
262 DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
263 DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
264 DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
265 DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
266 DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
267 DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
268 DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
269 DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
270 DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
271 DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
272 DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
273 DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
274 DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
275 DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
276 DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
277 DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
278 DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
279 DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
280 DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
281 DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
282 DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
283 DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
284 DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
285 DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
286 DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
287 DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
288 DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
289 DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
290 DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
291 DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
292 DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
293 DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
294 DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
295 DECODE( X_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
296 DECODE( X_COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
297 DECODE( X_ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
298 DECODE( X_ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
299 DECODE( X_ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
300 DECODE( X_ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
301 DECODE( X_CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
302 DECODE( X_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
303 DECODE( X_STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
304 DECODE( X_PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
305 DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
306 DECODE( X_COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
307 DECODE( X_SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
308 DECODE( X_URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
309 --Bug 4355133
310 SUBSTRB(DECODE( X_EMAIL_ADDRESS, FND_API.G_MISS_CHAR, NULL,
311 X_EMAIL_ADDRESS ),1,320),
312 DECODE( X_ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
313 DECODE( X_FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
314 DECODE( X_EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
315 DECODE( X_CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
316 DECODE( X_NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
317 DECODE( X_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
318 DECODE( X_GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
319 DECODE( X_MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
320 DECODE( X_ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
321 DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
322 DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
323 DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
324 DECODE( X_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
325 DECODE( X_SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
326 DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
327 DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
328 DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
329 DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
330 DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
331 DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),
332 /* Bug 3435702.This is replaced by l_duns_number as l_duns_number will be NULL if
333 X_DUNS_NUMBER_C is NULL or is equal to FND_API.G_MISS_CHAR.
334 DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, NULL, NULL, l_duns_number ),
335 */
336 l_duns_number,
337 DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
338 DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
339 ) RETURNING
340 PARTY_ID,
341 PARTY_NUMBER
342 INTO
343 X_PARTY_ID,
344 X_PARTY_NUMBER;
345
346 l_success := 'Y';
347
348 EXCEPTION
349 WHEN DUP_VAL_ON_INDEX THEN
350 IF INSTRB( SQLERRM, 'HZ_PARTIES_U1' ) <> 0 OR
351 INSTRB( SQLERRM, 'HZ_PARTIES_PK' ) <> 0
352 THEN
353 DECLARE
354 l_count NUMBER;
355 l_dummy VARCHAR2(1);
356 BEGIN
357 l_count := 1;
358 WHILE l_count > 0 LOOP
359 SELECT HZ_PARTIES_S.NEXTVAL
360 INTO X_PARTY_ID FROM dual;
361 BEGIN
362 SELECT 'Y' INTO l_dummy
363 FROM HZ_PARTIES
364 WHERE PARTY_ID = X_PARTY_ID;
365 l_count := 1;
366 EXCEPTION
367 WHEN NO_DATA_FOUND THEN
368 l_count := 0;
369 END;
370 END LOOP;
371 END;
372 ELSIF INSTRB( SQLERRM, 'HZ_PARTIES_U2' ) <> 0 THEN
373 DECLARE
374 l_count NUMBER;
375 l_dummy VARCHAR2(1);
376 BEGIN
377 l_count := 1;
378 WHILE l_count > 0 LOOP
379 SELECT TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL )
380 INTO X_PARTY_NUMBER FROM dual;
381 BEGIN
382 SELECT 'Y' INTO l_dummy
383 FROM HZ_PARTIES
384 WHERE PARTY_NUMBER = X_PARTY_NUMBER;
385 l_count := 1;
386 EXCEPTION
387 WHEN NO_DATA_FOUND THEN
388 l_count := 0;
389 END;
390 END LOOP;
391 END;
392 ELSE
393 RAISE;
394 END IF;
395
396 END;
397 END LOOP;
398
399 END Insert_Row;
400
401 PROCEDURE Update_Row (
402 X_Rowid IN OUT NOCOPY VARCHAR2,
403 X_PARTY_ID IN NUMBER,
404 X_PARTY_NUMBER IN VARCHAR2,
405 X_PARTY_NAME IN VARCHAR2,
406 X_PARTY_TYPE IN VARCHAR2,
407 X_VALIDATED_FLAG IN VARCHAR2,
408 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
409 X_ATTRIBUTE1 IN VARCHAR2,
410 X_ATTRIBUTE2 IN VARCHAR2,
411 X_ATTRIBUTE3 IN VARCHAR2,
412 X_ATTRIBUTE4 IN VARCHAR2,
413 X_ATTRIBUTE5 IN VARCHAR2,
414 X_ATTRIBUTE6 IN VARCHAR2,
415 X_ATTRIBUTE7 IN VARCHAR2,
416 X_ATTRIBUTE8 IN VARCHAR2,
417 X_ATTRIBUTE9 IN VARCHAR2,
418 X_ATTRIBUTE10 IN VARCHAR2,
419 X_ATTRIBUTE11 IN VARCHAR2,
420 X_ATTRIBUTE12 IN VARCHAR2,
421 X_ATTRIBUTE13 IN VARCHAR2,
422 X_ATTRIBUTE14 IN VARCHAR2,
423 X_ATTRIBUTE15 IN VARCHAR2,
424 X_ATTRIBUTE16 IN VARCHAR2,
425 X_ATTRIBUTE17 IN VARCHAR2,
426 X_ATTRIBUTE18 IN VARCHAR2,
427 X_ATTRIBUTE19 IN VARCHAR2,
428 X_ATTRIBUTE20 IN VARCHAR2,
429 X_ATTRIBUTE21 IN VARCHAR2,
430 X_ATTRIBUTE22 IN VARCHAR2,
431 X_ATTRIBUTE23 IN VARCHAR2,
432 X_ATTRIBUTE24 IN VARCHAR2,
433 X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
434 X_SIC_CODE IN VARCHAR2,
435 X_HQ_BRANCH_IND IN VARCHAR2,
436 X_CUSTOMER_KEY IN VARCHAR2,
437 X_TAX_REFERENCE IN VARCHAR2,
438 X_JGZZ_FISCAL_CODE IN VARCHAR2,
439 X_PERSON_PRE_NAME_ADJUNCT IN VARCHAR2,
440 X_PERSON_FIRST_NAME IN VARCHAR2,
441 X_PERSON_MIDDLE_NAME IN VARCHAR2,
442 X_PERSON_LAST_NAME IN VARCHAR2,
443 X_PERSON_NAME_SUFFIX IN VARCHAR2,
444 X_PERSON_TITLE IN VARCHAR2,
445 X_PERSON_ACADEMIC_TITLE IN VARCHAR2,
446 X_PERSON_PREVIOUS_LAST_NAME IN VARCHAR2,
447 X_KNOWN_AS IN VARCHAR2,
448 X_PERSON_IDEN_TYPE IN VARCHAR2,
449 X_PERSON_IDENTIFIER IN VARCHAR2,
450 X_GROUP_TYPE IN VARCHAR2,
451 X_COUNTRY IN VARCHAR2,
452 X_ADDRESS1 IN VARCHAR2,
453 X_ADDRESS2 IN VARCHAR2,
454 X_ADDRESS3 IN VARCHAR2,
455 X_ADDRESS4 IN VARCHAR2,
456 X_CITY IN VARCHAR2,
457 X_POSTAL_CODE IN VARCHAR2,
458 X_STATE IN VARCHAR2,
459 X_PROVINCE IN VARCHAR2,
460 X_STATUS IN VARCHAR2,
461 X_COUNTY IN VARCHAR2,
462 X_SIC_CODE_TYPE IN VARCHAR2,
463 X_URL IN VARCHAR2,
464 X_EMAIL_ADDRESS IN VARCHAR2,
465 X_ANALYSIS_FY IN VARCHAR2,
466 X_FISCAL_YEAREND_MONTH IN VARCHAR2,
467 X_EMPLOYEES_TOTAL IN NUMBER,
468 X_CURR_FY_POTENTIAL_REVENUE IN NUMBER,
469 X_NEXT_FY_POTENTIAL_REVENUE IN NUMBER,
470 X_YEAR_ESTABLISHED IN NUMBER,
471 X_GSA_INDICATOR_FLAG IN VARCHAR2,
472 X_MISSION_STATEMENT IN VARCHAR2,
473 X_ORGANIZATION_NAME_PHONETIC IN VARCHAR2,
474 X_PERSON_FIRST_NAME_PHONETIC IN VARCHAR2,
475 X_PERSON_LAST_NAME_PHONETIC IN VARCHAR2,
476 X_LANGUAGE_NAME IN VARCHAR2,
477 X_CATEGORY_CODE IN VARCHAR2,
478 X_SALUTATION IN VARCHAR2,
479 X_KNOWN_AS2 IN VARCHAR2,
480 X_KNOWN_AS3 IN VARCHAR2,
481 X_KNOWN_AS4 IN VARCHAR2,
482 X_KNOWN_AS5 IN VARCHAR2,
483 X_OBJECT_VERSION_NUMBER IN NUMBER,
484 X_DUNS_NUMBER_C IN VARCHAR2,
485 X_CREATED_BY_MODULE IN VARCHAR2,
486 X_APPLICATION_ID IN NUMBER
487 ) IS
488
489 l_duns_number NUMBER;
490
491 l_duns_number_c HZ_PARTIES.duns_number_c%type := X_DUNS_NUMBER_C;
492 BEGIN
493
494 IF x_duns_number_c IS NOT NULL AND
495 x_duns_number_c <> FND_API.G_MISS_CHAR
496 THEN
497 l_duns_number := do_copy_duns_number(x_duns_number_c);
498 END IF;
499
500 IF x_duns_number_c IS NOT NULL AND
501 x_duns_number_c <> FND_API.G_MISS_CHAR AND
502 LENGTHB(x_duns_number_c)<9
503 THEN
504 l_duns_number_c:=lpad(x_duns_number_c,9,'0');
505 END IF;
506
507 UPDATE HZ_PARTIES SET
508 PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
509 PARTY_NUMBER = DECODE( X_PARTY_NUMBER, NULL, PARTY_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_NUMBER ),
510 PARTY_NAME = DECODE( X_PARTY_NAME, NULL, PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
511 PARTY_TYPE = DECODE( X_PARTY_TYPE, NULL, PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
512 VALIDATED_FLAG = DECODE( X_VALIDATED_FLAG, NULL, VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', X_VALIDATED_FLAG ),
513 LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
514 CREATION_DATE = CREATION_DATE,
515 LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
516 REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
517 PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
518 CREATED_BY = CREATED_BY,
519 LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
520 PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
521 PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
522 ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
523 ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
524 ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
525 ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
526 ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
527 ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
528 ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
529 ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
530 ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
531 ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
532 ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
533 ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
534 ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
535 ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
536 ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
537 ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
538 ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
539 ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
540 ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
541 ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
542 ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
543 ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
544 ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
545 ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
546 ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
547 ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
548 SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
549 HQ_BRANCH_IND = DECODE( X_HQ_BRANCH_IND, NULL, HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
550 CUSTOMER_KEY = DECODE( X_CUSTOMER_KEY, NULL, CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
551 TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
552 JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
553 PERSON_PRE_NAME_ADJUNCT = DECODE( X_PERSON_PRE_NAME_ADJUNCT, NULL, PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
554 PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
555 PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
556 PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
557 PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
558 PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
559 PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
560 PERSON_PREVIOUS_LAST_NAME = DECODE( X_PERSON_PREVIOUS_LAST_NAME, NULL, PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
561 KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
562 PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
563 PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
564 GROUP_TYPE = DECODE( X_GROUP_TYPE, NULL, GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
565 COUNTRY = DECODE( X_COUNTRY, NULL, COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
566 ADDRESS1 = DECODE( X_ADDRESS1, NULL, ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
567 ADDRESS2 = DECODE( X_ADDRESS2, NULL, ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
568 ADDRESS3 = DECODE( X_ADDRESS3, NULL, ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
569 ADDRESS4 = DECODE( X_ADDRESS4, NULL, ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
570 CITY = DECODE( X_CITY, NULL, CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
571 POSTAL_CODE = DECODE( X_POSTAL_CODE, NULL, POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
572 STATE = DECODE( X_STATE, NULL, STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
573 PROVINCE = DECODE( X_PROVINCE, NULL, PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
574 STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
575 COUNTY = DECODE( X_COUNTY, NULL, COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
576 SIC_CODE_TYPE = DECODE( X_SIC_CODE_TYPE, NULL, SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
577 URL = DECODE( X_URL, NULL, URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
578 --Bug 4355133
579 EMAIL_ADDRESS = SUBSTRB(DECODE( X_EMAIL_ADDRESS, NULL, EMAIL_ADDRESS,
580 FND_API.G_MISS_CHAR, NULL, X_EMAIL_ADDRESS ),1,320),
581 ANALYSIS_FY = DECODE( X_ANALYSIS_FY, NULL, ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
582 FISCAL_YEAREND_MONTH = DECODE( X_FISCAL_YEAREND_MONTH, NULL, FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
583 EMPLOYEES_TOTAL = DECODE( X_EMPLOYEES_TOTAL, NULL, EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
584 CURR_FY_POTENTIAL_REVENUE = DECODE( X_CURR_FY_POTENTIAL_REVENUE, NULL, CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
585 NEXT_FY_POTENTIAL_REVENUE = DECODE( X_NEXT_FY_POTENTIAL_REVENUE, NULL, NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
586 YEAR_ESTABLISHED = DECODE( X_YEAR_ESTABLISHED, NULL, YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
587 GSA_INDICATOR_FLAG = DECODE( X_GSA_INDICATOR_FLAG, NULL, GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
588 MISSION_STATEMENT = DECODE( X_MISSION_STATEMENT, NULL, MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
589 ORGANIZATION_NAME_PHONETIC = DECODE( X_ORGANIZATION_NAME_PHONETIC, NULL, ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
590 PERSON_FIRST_NAME_PHONETIC = DECODE( X_PERSON_FIRST_NAME_PHONETIC, NULL, PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
591 PERSON_LAST_NAME_PHONETIC = DECODE( X_PERSON_LAST_NAME_PHONETIC, NULL, PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
592 LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
593 CATEGORY_CODE = DECODE( X_CATEGORY_CODE, NULL, CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
594 SALUTATION = DECODE( X_SALUTATION, NULL, SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
595 KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
596 KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
597 KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
598 KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
599 OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
600 DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(L_DUNS_NUMBER_C)),
601 DUNS_NUMBER = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER,/* Bug 3435702 FND_API.G_MISS_CHAR, NULL,*/ l_duns_number ),
602 CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
603 APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
604 WHERE ROWID = X_RowId;
605
606 IF ( SQL%NOTFOUND ) THEN
607 RAISE NO_DATA_FOUND;
608 END IF;
609
610 END Update_Row;
611
612 PROCEDURE Lock_Row (
613 X_Rowid IN OUT NOCOPY VARCHAR2,
614 X_PARTY_ID IN NUMBER,
615 X_PARTY_NUMBER IN VARCHAR2,
616 X_PARTY_NAME IN VARCHAR2,
617 X_PARTY_TYPE IN VARCHAR2,
618 X_VALIDATED_FLAG IN VARCHAR2,
619 X_LAST_UPDATED_BY IN NUMBER,
620 X_CREATION_DATE IN DATE,
621 X_LAST_UPDATE_LOGIN IN NUMBER,
622 X_REQUEST_ID IN NUMBER,
623 X_PROGRAM_APPLICATION_ID IN NUMBER,
624 X_CREATED_BY IN NUMBER,
625 X_LAST_UPDATE_DATE IN DATE,
626 X_PROGRAM_ID IN NUMBER,
627 X_PROGRAM_UPDATE_DATE IN DATE,
628 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
629 X_ATTRIBUTE1 IN VARCHAR2,
630 X_ATTRIBUTE2 IN VARCHAR2,
631 X_ATTRIBUTE3 IN VARCHAR2,
632 X_ATTRIBUTE4 IN VARCHAR2,
633 X_ATTRIBUTE5 IN VARCHAR2,
634 X_ATTRIBUTE6 IN VARCHAR2,
635 X_ATTRIBUTE7 IN VARCHAR2,
636 X_ATTRIBUTE8 IN VARCHAR2,
637 X_ATTRIBUTE9 IN VARCHAR2,
638 X_ATTRIBUTE10 IN VARCHAR2,
639 X_ATTRIBUTE11 IN VARCHAR2,
640 X_ATTRIBUTE12 IN VARCHAR2,
641 X_ATTRIBUTE13 IN VARCHAR2,
642 X_ATTRIBUTE14 IN VARCHAR2,
643 X_ATTRIBUTE15 IN VARCHAR2,
644 X_ATTRIBUTE16 IN VARCHAR2,
645 X_ATTRIBUTE17 IN VARCHAR2,
646 X_ATTRIBUTE18 IN VARCHAR2,
647 X_ATTRIBUTE19 IN VARCHAR2,
648 X_ATTRIBUTE20 IN VARCHAR2,
649 X_ATTRIBUTE21 IN VARCHAR2,
650 X_ATTRIBUTE22 IN VARCHAR2,
651 X_ATTRIBUTE23 IN VARCHAR2,
652 X_ATTRIBUTE24 IN VARCHAR2,
653 X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
654 X_SIC_CODE IN VARCHAR2,
655 X_HQ_BRANCH_IND IN VARCHAR2,
656 X_CUSTOMER_KEY IN VARCHAR2,
657 X_TAX_REFERENCE IN VARCHAR2,
658 X_JGZZ_FISCAL_CODE IN VARCHAR2,
659 X_PERSON_PRE_NAME_ADJUNCT IN VARCHAR2,
660 X_PERSON_FIRST_NAME IN VARCHAR2,
661 X_PERSON_MIDDLE_NAME IN VARCHAR2,
662 X_PERSON_LAST_NAME IN VARCHAR2,
663 X_PERSON_NAME_SUFFIX IN VARCHAR2,
664 X_PERSON_TITLE IN VARCHAR2,
665 X_PERSON_ACADEMIC_TITLE IN VARCHAR2,
666 X_PERSON_PREVIOUS_LAST_NAME IN VARCHAR2,
667 X_KNOWN_AS IN VARCHAR2,
668 X_PERSON_IDEN_TYPE IN VARCHAR2,
669 X_PERSON_IDENTIFIER IN VARCHAR2,
670 X_GROUP_TYPE IN VARCHAR2,
671 X_COUNTRY IN VARCHAR2,
672 X_ADDRESS1 IN VARCHAR2,
673 X_ADDRESS2 IN VARCHAR2,
674 X_ADDRESS3 IN VARCHAR2,
675 X_ADDRESS4 IN VARCHAR2,
676 X_CITY IN VARCHAR2,
677 X_POSTAL_CODE IN VARCHAR2,
678 X_STATE IN VARCHAR2,
679 X_PROVINCE IN VARCHAR2,
680 X_STATUS IN VARCHAR2,
681 X_COUNTY IN VARCHAR2,
682 X_SIC_CODE_TYPE IN VARCHAR2,
683 X_URL IN VARCHAR2,
684 X_EMAIL_ADDRESS IN VARCHAR2,
685 X_ANALYSIS_FY IN VARCHAR2,
686 X_FISCAL_YEAREND_MONTH IN VARCHAR2,
687 X_EMPLOYEES_TOTAL IN NUMBER,
688 X_CURR_FY_POTENTIAL_REVENUE IN NUMBER,
689 X_NEXT_FY_POTENTIAL_REVENUE IN NUMBER,
690 X_YEAR_ESTABLISHED IN NUMBER,
691 X_GSA_INDICATOR_FLAG IN VARCHAR2,
692 X_MISSION_STATEMENT IN VARCHAR2,
693 X_ORGANIZATION_NAME_PHONETIC IN VARCHAR2,
694 X_PERSON_FIRST_NAME_PHONETIC IN VARCHAR2,
695 X_PERSON_LAST_NAME_PHONETIC IN VARCHAR2,
696 X_LANGUAGE_NAME IN VARCHAR2,
697 X_CATEGORY_CODE IN VARCHAR2,
698 X_SALUTATION IN VARCHAR2,
699 X_KNOWN_AS2 IN VARCHAR2,
700 X_KNOWN_AS3 IN VARCHAR2,
701 X_KNOWN_AS4 IN VARCHAR2,
702 X_KNOWN_AS5 IN VARCHAR2,
703 X_OBJECT_VERSION_NUMBER IN NUMBER,
704 X_DUNS_NUMBER_C IN VARCHAR2,
705 X_CREATED_BY_MODULE IN VARCHAR2,
706 X_APPLICATION_ID IN NUMBER
707 ) IS
708
709 CURSOR C IS
710 SELECT * FROM HZ_PARTIES
711 WHERE ROWID = x_Rowid
712 FOR UPDATE NOWAIT;
713 Recinfo C%ROWTYPE;
714
715 BEGIN
716
717 OPEN C;
718 FETCH C INTO Recinfo;
719 IF ( C%NOTFOUND ) THEN
720 CLOSE C;
721 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
722 APP_EXCEPTION.RAISE_EXCEPTION;
723 END IF;
724 CLOSE C;
725
726 IF (
727 ( ( Recinfo.PARTY_ID = X_PARTY_ID )
728 OR ( ( Recinfo.PARTY_ID IS NULL )
729 AND ( X_PARTY_ID IS NULL ) ) )
730 AND ( ( Recinfo.PARTY_NUMBER = X_PARTY_NUMBER )
731 OR ( ( Recinfo.PARTY_NUMBER IS NULL )
732 AND ( X_PARTY_NUMBER IS NULL ) ) )
733 AND ( ( Recinfo.PARTY_NAME = X_PARTY_NAME )
734 OR ( ( Recinfo.PARTY_NAME IS NULL )
735 AND ( X_PARTY_NAME IS NULL ) ) )
736 AND ( ( Recinfo.PARTY_TYPE = X_PARTY_TYPE )
737 OR ( ( Recinfo.PARTY_TYPE IS NULL )
738 AND ( X_PARTY_TYPE IS NULL ) ) )
739 AND ( ( Recinfo.VALIDATED_FLAG = X_VALIDATED_FLAG )
740 OR ( ( Recinfo.VALIDATED_FLAG IS NULL )
741 AND ( X_VALIDATED_FLAG IS NULL ) ) )
742 AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY )
743 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
744 AND ( X_LAST_UPDATED_BY IS NULL ) ) )
745 AND ( ( Recinfo.CREATION_DATE = X_CREATION_DATE )
746 OR ( ( Recinfo.CREATION_DATE IS NULL )
747 AND ( X_CREATION_DATE IS NULL ) ) )
748 AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN )
749 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
750 AND ( X_LAST_UPDATE_LOGIN IS NULL ) ) )
751 AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
752 OR ( ( Recinfo.REQUEST_ID IS NULL )
753 AND ( X_REQUEST_ID IS NULL ) ) )
754 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID )
755 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
756 AND ( X_PROGRAM_APPLICATION_ID IS NULL ) ) )
757 AND ( ( Recinfo.CREATED_BY = X_CREATED_BY )
758 OR ( ( Recinfo.CREATED_BY IS NULL )
759 AND ( X_CREATED_BY IS NULL ) ) )
760 AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE )
761 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
762 AND ( X_LAST_UPDATE_DATE IS NULL ) ) )
763 AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID )
764 OR ( ( Recinfo.PROGRAM_ID IS NULL )
765 AND ( X_PROGRAM_ID IS NULL ) ) )
766 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE )
767 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
768 AND ( X_PROGRAM_UPDATE_DATE IS NULL ) ) )
769 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY )
770 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
771 AND ( X_ATTRIBUTE_CATEGORY IS NULL ) ) )
772 AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
773 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
774 AND ( X_ATTRIBUTE1 IS NULL ) ) )
775 AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
776 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
777 AND ( X_ATTRIBUTE2 IS NULL ) ) )
778 AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
779 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
780 AND ( X_ATTRIBUTE3 IS NULL ) ) )
781 AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
782 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
783 AND ( X_ATTRIBUTE4 IS NULL ) ) )
784 AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
785 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
786 AND ( X_ATTRIBUTE5 IS NULL ) ) )
787 AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
788 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
789 AND ( X_ATTRIBUTE6 IS NULL ) ) )
790 AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
791 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
792 AND ( X_ATTRIBUTE7 IS NULL ) ) )
793 AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
794 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
795 AND ( X_ATTRIBUTE8 IS NULL ) ) )
796 AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
797 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
798 AND ( X_ATTRIBUTE9 IS NULL ) ) )
799 AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
800 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
801 AND ( X_ATTRIBUTE10 IS NULL ) ) )
802 AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
803 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
804 AND ( X_ATTRIBUTE11 IS NULL ) ) )
805 AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
806 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
807 AND ( X_ATTRIBUTE12 IS NULL ) ) )
808 AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
809 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
810 AND ( X_ATTRIBUTE13 IS NULL ) ) )
811 AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
812 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
813 AND ( X_ATTRIBUTE14 IS NULL ) ) )
814 AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
815 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
816 AND ( X_ATTRIBUTE15 IS NULL ) ) )
817 AND ( ( Recinfo.ATTRIBUTE16 = X_ATTRIBUTE16 )
818 OR ( ( Recinfo.ATTRIBUTE16 IS NULL )
819 AND ( X_ATTRIBUTE16 IS NULL ) ) )
820 AND ( ( Recinfo.ATTRIBUTE17 = X_ATTRIBUTE17 )
821 OR ( ( Recinfo.ATTRIBUTE17 IS NULL )
822 AND ( X_ATTRIBUTE17 IS NULL ) ) )
823 AND ( ( Recinfo.ATTRIBUTE18 = X_ATTRIBUTE18 )
824 OR ( ( Recinfo.ATTRIBUTE18 IS NULL )
825 AND ( X_ATTRIBUTE18 IS NULL ) ) )
826 AND ( ( Recinfo.ATTRIBUTE19 = X_ATTRIBUTE19 )
827 OR ( ( Recinfo.ATTRIBUTE19 IS NULL )
828 AND ( X_ATTRIBUTE19 IS NULL ) ) )
829 AND ( ( Recinfo.ATTRIBUTE20 = X_ATTRIBUTE20 )
830 OR ( ( Recinfo.ATTRIBUTE20 IS NULL )
831 AND ( X_ATTRIBUTE20 IS NULL ) ) )
832 AND ( ( Recinfo.ATTRIBUTE21 = X_ATTRIBUTE21 )
833 OR ( ( Recinfo.ATTRIBUTE21 IS NULL )
834 AND ( X_ATTRIBUTE21 IS NULL ) ) )
835 AND ( ( Recinfo.ATTRIBUTE22 = X_ATTRIBUTE22 )
836 OR ( ( Recinfo.ATTRIBUTE22 IS NULL )
837 AND ( X_ATTRIBUTE22 IS NULL ) ) )
838 AND ( ( Recinfo.ATTRIBUTE23 = X_ATTRIBUTE23 )
839 OR ( ( Recinfo.ATTRIBUTE23 IS NULL )
840 AND ( X_ATTRIBUTE23 IS NULL ) ) )
841 AND ( ( Recinfo.ATTRIBUTE24 = X_ATTRIBUTE24 )
842 OR ( ( Recinfo.ATTRIBUTE24 IS NULL )
843 AND ( X_ATTRIBUTE24 IS NULL ) ) )
844 AND ( ( Recinfo.ORIG_SYSTEM_REFERENCE = X_ORIG_SYSTEM_REFERENCE )
845 OR ( ( Recinfo.ORIG_SYSTEM_REFERENCE IS NULL )
846 AND ( X_ORIG_SYSTEM_REFERENCE IS NULL ) ) )
847 AND ( ( Recinfo.SIC_CODE = X_SIC_CODE )
848 OR ( ( Recinfo.SIC_CODE IS NULL )
849 AND ( X_SIC_CODE IS NULL ) ) )
850 AND ( ( Recinfo.HQ_BRANCH_IND = X_HQ_BRANCH_IND )
851 OR ( ( Recinfo.HQ_BRANCH_IND IS NULL )
852 AND ( X_HQ_BRANCH_IND IS NULL ) ) )
853 AND ( ( Recinfo.CUSTOMER_KEY = X_CUSTOMER_KEY )
854 OR ( ( Recinfo.CUSTOMER_KEY IS NULL )
855 AND ( X_CUSTOMER_KEY IS NULL ) ) )
856 AND ( ( Recinfo.TAX_REFERENCE = X_TAX_REFERENCE )
857 OR ( ( Recinfo.TAX_REFERENCE IS NULL )
858 AND ( X_TAX_REFERENCE IS NULL ) ) )
859 AND ( ( Recinfo.JGZZ_FISCAL_CODE = X_JGZZ_FISCAL_CODE )
860 OR ( ( Recinfo.JGZZ_FISCAL_CODE IS NULL )
861 AND ( X_JGZZ_FISCAL_CODE IS NULL ) ) )
862 AND ( ( Recinfo.PERSON_PRE_NAME_ADJUNCT = X_PERSON_PRE_NAME_ADJUNCT )
863 OR ( ( Recinfo.PERSON_PRE_NAME_ADJUNCT IS NULL )
864 AND ( X_PERSON_PRE_NAME_ADJUNCT IS NULL ) ) )
865 AND ( ( Recinfo.PERSON_FIRST_NAME = X_PERSON_FIRST_NAME )
866 OR ( ( Recinfo.PERSON_FIRST_NAME IS NULL )
867 AND ( X_PERSON_FIRST_NAME IS NULL ) ) )
868 AND ( ( Recinfo.PERSON_MIDDLE_NAME = X_PERSON_MIDDLE_NAME )
869 OR ( ( Recinfo.PERSON_MIDDLE_NAME IS NULL )
870 AND ( X_PERSON_MIDDLE_NAME IS NULL ) ) )
871 AND ( ( Recinfo.PERSON_LAST_NAME = X_PERSON_LAST_NAME )
872 OR ( ( Recinfo.PERSON_LAST_NAME IS NULL )
873 AND ( X_PERSON_LAST_NAME IS NULL ) ) )
874 AND ( ( Recinfo.PERSON_NAME_SUFFIX = X_PERSON_NAME_SUFFIX )
875 OR ( ( Recinfo.PERSON_NAME_SUFFIX IS NULL )
876 AND ( X_PERSON_NAME_SUFFIX IS NULL ) ) )
877 AND ( ( Recinfo.PERSON_TITLE = X_PERSON_TITLE )
878 OR ( ( Recinfo.PERSON_TITLE IS NULL )
879 AND ( X_PERSON_TITLE IS NULL ) ) )
880 AND ( ( Recinfo.PERSON_ACADEMIC_TITLE = X_PERSON_ACADEMIC_TITLE )
881 OR ( ( Recinfo.PERSON_ACADEMIC_TITLE IS NULL )
882 AND ( X_PERSON_ACADEMIC_TITLE IS NULL ) ) )
883 AND ( ( Recinfo.PERSON_PREVIOUS_LAST_NAME = X_PERSON_PREVIOUS_LAST_NAME )
884 OR ( ( Recinfo.PERSON_PREVIOUS_LAST_NAME IS NULL )
885 AND ( X_PERSON_PREVIOUS_LAST_NAME IS NULL ) ) )
886 AND ( ( Recinfo.KNOWN_AS = X_KNOWN_AS )
887 OR ( ( Recinfo.KNOWN_AS IS NULL )
888 AND ( X_KNOWN_AS IS NULL ) ) )
889 AND ( ( Recinfo.PERSON_IDEN_TYPE = X_PERSON_IDEN_TYPE )
890 OR ( ( Recinfo.PERSON_IDEN_TYPE IS NULL )
891 AND ( X_PERSON_IDEN_TYPE IS NULL ) ) )
892 AND ( ( Recinfo.PERSON_IDENTIFIER = X_PERSON_IDENTIFIER )
893 OR ( ( Recinfo.PERSON_IDENTIFIER IS NULL )
894 AND ( X_PERSON_IDENTIFIER IS NULL ) ) )
895 AND ( ( Recinfo.GROUP_TYPE = X_GROUP_TYPE )
896 OR ( ( Recinfo.GROUP_TYPE IS NULL )
897 AND ( X_GROUP_TYPE IS NULL ) ) )
898 AND ( ( Recinfo.COUNTRY = X_COUNTRY )
899 OR ( ( Recinfo.COUNTRY IS NULL )
900 AND ( X_COUNTRY IS NULL ) ) )
901 AND ( ( Recinfo.ADDRESS1 = X_ADDRESS1 )
902 OR ( ( Recinfo.ADDRESS1 IS NULL )
903 AND ( X_ADDRESS1 IS NULL ) ) )
904 AND ( ( Recinfo.ADDRESS2 = X_ADDRESS2 )
905 OR ( ( Recinfo.ADDRESS2 IS NULL )
906 AND ( X_ADDRESS2 IS NULL ) ) )
907 AND ( ( Recinfo.ADDRESS3 = X_ADDRESS3 )
908 OR ( ( Recinfo.ADDRESS3 IS NULL )
909 AND ( X_ADDRESS3 IS NULL ) ) )
910 AND ( ( Recinfo.ADDRESS4 = X_ADDRESS4 )
911 OR ( ( Recinfo.ADDRESS4 IS NULL )
912 AND ( X_ADDRESS4 IS NULL ) ) )
913 AND ( ( Recinfo.CITY = X_CITY )
914 OR ( ( Recinfo.CITY IS NULL )
915 AND ( X_CITY IS NULL ) ) )
916 AND ( ( Recinfo.POSTAL_CODE = X_POSTAL_CODE )
917 OR ( ( Recinfo.POSTAL_CODE IS NULL )
918 AND ( X_POSTAL_CODE IS NULL ) ) )
919 AND ( ( Recinfo.STATE = X_STATE )
920 OR ( ( Recinfo.STATE IS NULL )
921 AND ( X_STATE IS NULL ) ) )
922 AND ( ( Recinfo.PROVINCE = X_PROVINCE )
923 OR ( ( Recinfo.PROVINCE IS NULL )
924 AND ( X_PROVINCE IS NULL ) ) )
925 AND ( ( Recinfo.STATUS = X_STATUS )
926 OR ( ( Recinfo.STATUS IS NULL )
927 AND ( X_STATUS IS NULL ) ) )
928 AND ( ( Recinfo.COUNTY = X_COUNTY )
929 OR ( ( Recinfo.COUNTY IS NULL )
930 AND ( X_COUNTY IS NULL ) ) )
931 AND ( ( Recinfo.SIC_CODE_TYPE = X_SIC_CODE_TYPE )
932 OR ( ( Recinfo.SIC_CODE_TYPE IS NULL )
933 AND ( X_SIC_CODE_TYPE IS NULL ) ) )
934 AND ( ( Recinfo.URL = X_URL )
935 OR ( ( Recinfo.URL IS NULL )
936 AND ( X_URL IS NULL ) ) )
937 AND ( ( Recinfo.EMAIL_ADDRESS = X_EMAIL_ADDRESS )
938 OR ( ( Recinfo.EMAIL_ADDRESS IS NULL )
939 AND ( X_EMAIL_ADDRESS IS NULL ) ) )
940 AND ( ( Recinfo.ANALYSIS_FY = X_ANALYSIS_FY )
941 OR ( ( Recinfo.ANALYSIS_FY IS NULL )
942 AND ( X_ANALYSIS_FY IS NULL ) ) )
943 AND ( ( Recinfo.FISCAL_YEAREND_MONTH = X_FISCAL_YEAREND_MONTH )
944 OR ( ( Recinfo.FISCAL_YEAREND_MONTH IS NULL )
945 AND ( X_FISCAL_YEAREND_MONTH IS NULL ) ) )
946 AND ( ( Recinfo.EMPLOYEES_TOTAL = X_EMPLOYEES_TOTAL )
947 OR ( ( Recinfo.EMPLOYEES_TOTAL IS NULL )
948 AND ( X_EMPLOYEES_TOTAL IS NULL ) ) )
949 AND ( ( Recinfo.CURR_FY_POTENTIAL_REVENUE = X_CURR_FY_POTENTIAL_REVENUE )
950 OR ( ( Recinfo.CURR_FY_POTENTIAL_REVENUE IS NULL )
951 AND ( X_CURR_FY_POTENTIAL_REVENUE IS NULL ) ) )
952 AND ( ( Recinfo.NEXT_FY_POTENTIAL_REVENUE = X_NEXT_FY_POTENTIAL_REVENUE )
953 OR ( ( Recinfo.NEXT_FY_POTENTIAL_REVENUE IS NULL )
954 AND ( X_NEXT_FY_POTENTIAL_REVENUE IS NULL ) ) )
955 AND ( ( Recinfo.YEAR_ESTABLISHED = X_YEAR_ESTABLISHED )
956 OR ( ( Recinfo.YEAR_ESTABLISHED IS NULL )
957 AND ( X_YEAR_ESTABLISHED IS NULL ) ) )
958 AND ( ( Recinfo.GSA_INDICATOR_FLAG = X_GSA_INDICATOR_FLAG )
959 OR ( ( Recinfo.GSA_INDICATOR_FLAG IS NULL )
960 AND ( X_GSA_INDICATOR_FLAG IS NULL ) ) )
961 AND ( ( Recinfo.MISSION_STATEMENT = X_MISSION_STATEMENT )
962 OR ( ( Recinfo.MISSION_STATEMENT IS NULL )
963 AND ( X_MISSION_STATEMENT IS NULL ) ) )
964 AND ( ( Recinfo.ORGANIZATION_NAME_PHONETIC = X_ORGANIZATION_NAME_PHONETIC )
965 OR ( ( Recinfo.ORGANIZATION_NAME_PHONETIC IS NULL )
966 AND ( X_ORGANIZATION_NAME_PHONETIC IS NULL ) ) )
967 AND ( ( Recinfo.PERSON_FIRST_NAME_PHONETIC = X_PERSON_FIRST_NAME_PHONETIC )
968 OR ( ( Recinfo.PERSON_FIRST_NAME_PHONETIC IS NULL )
969 AND ( X_PERSON_FIRST_NAME_PHONETIC IS NULL ) ) )
970 AND ( ( Recinfo.PERSON_LAST_NAME_PHONETIC = X_PERSON_LAST_NAME_PHONETIC )
971 OR ( ( Recinfo.PERSON_LAST_NAME_PHONETIC IS NULL )
972 AND ( X_PERSON_LAST_NAME_PHONETIC IS NULL ) ) )
973 AND ( ( Recinfo.LANGUAGE_NAME = X_LANGUAGE_NAME )
974 OR ( ( Recinfo.LANGUAGE_NAME IS NULL )
975 AND ( X_LANGUAGE_NAME IS NULL ) ) )
976 AND ( ( Recinfo.CATEGORY_CODE = X_CATEGORY_CODE )
977 OR ( ( Recinfo.CATEGORY_CODE IS NULL )
978 AND ( X_CATEGORY_CODE IS NULL ) ) )
979 AND ( ( Recinfo.SALUTATION = X_SALUTATION )
980 OR ( ( Recinfo.SALUTATION IS NULL )
981 AND ( X_SALUTATION IS NULL ) ) )
982 AND ( ( Recinfo.KNOWN_AS2 = X_KNOWN_AS2 )
983 OR ( ( Recinfo.KNOWN_AS2 IS NULL )
984 AND ( X_KNOWN_AS2 IS NULL ) ) )
985 AND ( ( Recinfo.KNOWN_AS3 = X_KNOWN_AS3 )
986 OR ( ( Recinfo.KNOWN_AS3 IS NULL )
987 AND ( X_KNOWN_AS3 IS NULL ) ) )
988 AND ( ( Recinfo.KNOWN_AS4 = X_KNOWN_AS4 )
989 OR ( ( Recinfo.KNOWN_AS4 IS NULL )
990 AND ( X_KNOWN_AS4 IS NULL ) ) )
991 AND ( ( Recinfo.KNOWN_AS5 = X_KNOWN_AS5 )
992 OR ( ( Recinfo.KNOWN_AS5 IS NULL )
993 AND ( X_KNOWN_AS5 IS NULL ) ) )
994 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER )
995 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
996 AND ( X_OBJECT_VERSION_NUMBER IS NULL ) ) )
997 AND ( ( Recinfo.DUNS_NUMBER_C = X_DUNS_NUMBER_C )
998 OR ( ( Recinfo.DUNS_NUMBER_C IS NULL )
999 AND ( X_DUNS_NUMBER_C IS NULL ) ) )
1000 AND ( ( Recinfo.CREATED_BY_MODULE = X_CREATED_BY_MODULE )
1001 OR ( ( Recinfo.CREATED_BY_MODULE IS NULL )
1002 AND ( X_CREATED_BY_MODULE IS NULL ) ) )
1003 AND ( ( Recinfo.APPLICATION_ID = X_APPLICATION_ID )
1004 OR ( ( Recinfo.APPLICATION_ID IS NULL )
1005 AND ( X_APPLICATION_ID IS NULL ) ) )
1006 ) THEN
1007 RETURN;
1008 ELSE
1009 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1010 APP_EXCEPTION.RAISE_EXCEPTION;
1011 END IF;
1012
1013 END Lock_Row;
1014
1015 PROCEDURE Select_Row (
1016 X_PARTY_ID IN OUT NOCOPY NUMBER,
1017 X_PARTY_NUMBER OUT NOCOPY VARCHAR2,
1018 X_PARTY_NAME OUT NOCOPY VARCHAR2,
1019 X_PARTY_TYPE OUT NOCOPY VARCHAR2,
1020 X_VALIDATED_FLAG OUT NOCOPY VARCHAR2,
1021 X_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
1022 X_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
1023 X_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
1024 X_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
1025 X_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
1026 X_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
1027 X_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
1028 X_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
1029 X_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
1030 X_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
1031 X_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
1032 X_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
1033 X_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
1034 X_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
1035 X_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
1036 X_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
1037 X_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
1038 X_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
1039 X_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
1040 X_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
1041 X_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
1042 X_ATTRIBUTE21 OUT NOCOPY VARCHAR2,
1043 X_ATTRIBUTE22 OUT NOCOPY VARCHAR2,
1044 X_ATTRIBUTE23 OUT NOCOPY VARCHAR2,
1045 X_ATTRIBUTE24 OUT NOCOPY VARCHAR2,
1046 X_ORIG_SYSTEM_REFERENCE OUT NOCOPY VARCHAR2,
1047 X_SIC_CODE OUT NOCOPY VARCHAR2,
1048 X_HQ_BRANCH_IND OUT NOCOPY VARCHAR2,
1049 X_CUSTOMER_KEY OUT NOCOPY VARCHAR2,
1050 X_TAX_REFERENCE OUT NOCOPY VARCHAR2,
1051 X_JGZZ_FISCAL_CODE OUT NOCOPY VARCHAR2,
1052 X_PERSON_PRE_NAME_ADJUNCT OUT NOCOPY VARCHAR2,
1053 X_PERSON_FIRST_NAME OUT NOCOPY VARCHAR2,
1054 X_PERSON_MIDDLE_NAME OUT NOCOPY VARCHAR2,
1055 X_PERSON_LAST_NAME OUT NOCOPY VARCHAR2,
1056 X_PERSON_NAME_SUFFIX OUT NOCOPY VARCHAR2,
1057 X_PERSON_TITLE OUT NOCOPY VARCHAR2,
1058 X_PERSON_ACADEMIC_TITLE OUT NOCOPY VARCHAR2,
1059 X_PERSON_PREVIOUS_LAST_NAME OUT NOCOPY VARCHAR2,
1060 X_KNOWN_AS OUT NOCOPY VARCHAR2,
1061 X_PERSON_IDEN_TYPE OUT NOCOPY VARCHAR2,
1062 X_PERSON_IDENTIFIER OUT NOCOPY VARCHAR2,
1063 X_GROUP_TYPE OUT NOCOPY VARCHAR2,
1064 X_COUNTRY OUT NOCOPY VARCHAR2,
1065 X_ADDRESS1 OUT NOCOPY VARCHAR2,
1066 X_ADDRESS2 OUT NOCOPY VARCHAR2,
1067 X_ADDRESS3 OUT NOCOPY VARCHAR2,
1068 X_ADDRESS4 OUT NOCOPY VARCHAR2,
1069 X_CITY OUT NOCOPY VARCHAR2,
1070 X_POSTAL_CODE OUT NOCOPY VARCHAR2,
1071 X_STATE OUT NOCOPY VARCHAR2,
1072 X_PROVINCE OUT NOCOPY VARCHAR2,
1073 X_STATUS OUT NOCOPY VARCHAR2,
1074 X_COUNTY OUT NOCOPY VARCHAR2,
1075 X_SIC_CODE_TYPE OUT NOCOPY VARCHAR2,
1076 X_URL OUT NOCOPY VARCHAR2,
1077 X_EMAIL_ADDRESS OUT NOCOPY VARCHAR2,
1078 X_ANALYSIS_FY OUT NOCOPY VARCHAR2,
1079 X_FISCAL_YEAREND_MONTH OUT NOCOPY VARCHAR2,
1080 X_EMPLOYEES_TOTAL OUT NOCOPY NUMBER,
1081 X_CURR_FY_POTENTIAL_REVENUE OUT NOCOPY NUMBER,
1082 X_NEXT_FY_POTENTIAL_REVENUE OUT NOCOPY NUMBER,
1083 X_YEAR_ESTABLISHED OUT NOCOPY NUMBER,
1084 X_GSA_INDICATOR_FLAG OUT NOCOPY VARCHAR2,
1085 X_MISSION_STATEMENT OUT NOCOPY VARCHAR2,
1086 X_ORGANIZATION_NAME_PHONETIC OUT NOCOPY VARCHAR2,
1087 X_PERSON_FIRST_NAME_PHONETIC OUT NOCOPY VARCHAR2,
1088 X_PERSON_LAST_NAME_PHONETIC OUT NOCOPY VARCHAR2,
1089 X_LANGUAGE_NAME OUT NOCOPY VARCHAR2,
1090 X_CATEGORY_CODE OUT NOCOPY VARCHAR2,
1091 X_SALUTATION OUT NOCOPY VARCHAR2,
1092 X_KNOWN_AS2 OUT NOCOPY VARCHAR2,
1093 X_KNOWN_AS3 OUT NOCOPY VARCHAR2,
1094 X_KNOWN_AS4 OUT NOCOPY VARCHAR2,
1095 X_KNOWN_AS5 OUT NOCOPY VARCHAR2,
1096 X_DUNS_NUMBER_C OUT NOCOPY VARCHAR2,
1097 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
1098 X_APPLICATION_ID OUT NOCOPY NUMBER
1099 ) IS
1100
1101 BEGIN
1102
1103 SELECT
1104 NVL( PARTY_ID, FND_API.G_MISS_NUM ),
1105 NVL( PARTY_NUMBER, FND_API.G_MISS_CHAR ),
1106 NVL( PARTY_NAME, FND_API.G_MISS_CHAR ),
1107 NVL( PARTY_TYPE, FND_API.G_MISS_CHAR ),
1108 NVL( VALIDATED_FLAG, FND_API.G_MISS_CHAR ),
1109 NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1110 NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1111 NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1112 NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1113 NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1114 NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1115 NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1116 NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1117 NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1118 NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1119 NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1120 NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1121 NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1122 NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1123 NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1124 NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1125 NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1126 NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1127 NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1128 NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1129 NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1130 NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
1131 NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
1132 NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
1133 NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
1134 NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
1135 NVL( SIC_CODE, FND_API.G_MISS_CHAR ),
1136 NVL( HQ_BRANCH_IND, FND_API.G_MISS_CHAR ),
1137 NVL( CUSTOMER_KEY, FND_API.G_MISS_CHAR ),
1138 NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
1139 NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
1140 NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
1141 NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
1142 NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
1143 NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
1144 NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
1145 NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
1146 NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
1147 NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
1148 NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
1149 NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
1150 NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
1151 NVL( GROUP_TYPE, FND_API.G_MISS_CHAR ),
1152 NVL( COUNTRY, FND_API.G_MISS_CHAR ),
1153 NVL( ADDRESS1, FND_API.G_MISS_CHAR ),
1154 NVL( ADDRESS2, FND_API.G_MISS_CHAR ),
1155 NVL( ADDRESS3, FND_API.G_MISS_CHAR ),
1156 NVL( ADDRESS4, FND_API.G_MISS_CHAR ),
1157 NVL( CITY, FND_API.G_MISS_CHAR ),
1158 NVL( POSTAL_CODE, FND_API.G_MISS_CHAR ),
1159 NVL( STATE, FND_API.G_MISS_CHAR ),
1160 NVL( PROVINCE, FND_API.G_MISS_CHAR ),
1161 NVL( STATUS, FND_API.G_MISS_CHAR ),
1162 NVL( COUNTY, FND_API.G_MISS_CHAR ),
1163 NVL( SIC_CODE_TYPE, FND_API.G_MISS_CHAR ),
1164 NVL( URL, FND_API.G_MISS_CHAR ),
1165 NVL( EMAIL_ADDRESS, FND_API.G_MISS_CHAR ),
1166 NVL( ANALYSIS_FY, FND_API.G_MISS_CHAR ),
1167 NVL( FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR ),
1168 NVL( EMPLOYEES_TOTAL, FND_API.G_MISS_NUM ),
1169 NVL( CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1170 NVL( NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1171 NVL( YEAR_ESTABLISHED, FND_API.G_MISS_NUM ),
1172 NVL( GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR ),
1173 NVL( MISSION_STATEMENT, FND_API.G_MISS_CHAR ),
1174 NVL( ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1175 NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1176 NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1177 NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
1178 NVL( CATEGORY_CODE, FND_API.G_MISS_CHAR ),
1179 NVL( SALUTATION, FND_API.G_MISS_CHAR ),
1180 NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
1181 NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
1182 NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
1183 NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
1184 NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR ),
1185 NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
1186 NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
1187 INTO
1188 X_PARTY_ID,
1189 X_PARTY_NUMBER,
1190 X_PARTY_NAME,
1191 X_PARTY_TYPE,
1192 X_VALIDATED_FLAG,
1193 X_ATTRIBUTE_CATEGORY,
1194 X_ATTRIBUTE1,
1195 X_ATTRIBUTE2,
1196 X_ATTRIBUTE3,
1197 X_ATTRIBUTE4,
1198 X_ATTRIBUTE5,
1199 X_ATTRIBUTE6,
1200 X_ATTRIBUTE7,
1201 X_ATTRIBUTE8,
1202 X_ATTRIBUTE9,
1203 X_ATTRIBUTE10,
1204 X_ATTRIBUTE11,
1205 X_ATTRIBUTE12,
1206 X_ATTRIBUTE13,
1207 X_ATTRIBUTE14,
1208 X_ATTRIBUTE15,
1209 X_ATTRIBUTE16,
1210 X_ATTRIBUTE17,
1211 X_ATTRIBUTE18,
1212 X_ATTRIBUTE19,
1213 X_ATTRIBUTE20,
1214 X_ATTRIBUTE21,
1215 X_ATTRIBUTE22,
1216 X_ATTRIBUTE23,
1217 X_ATTRIBUTE24,
1218 X_ORIG_SYSTEM_REFERENCE,
1219 X_SIC_CODE,
1220 X_HQ_BRANCH_IND,
1221 X_CUSTOMER_KEY,
1222 X_TAX_REFERENCE,
1223 X_JGZZ_FISCAL_CODE,
1224 X_PERSON_PRE_NAME_ADJUNCT,
1225 X_PERSON_FIRST_NAME,
1226 X_PERSON_MIDDLE_NAME,
1227 X_PERSON_LAST_NAME,
1228 X_PERSON_NAME_SUFFIX,
1229 X_PERSON_TITLE,
1230 X_PERSON_ACADEMIC_TITLE,
1231 X_PERSON_PREVIOUS_LAST_NAME,
1232 X_KNOWN_AS,
1233 X_PERSON_IDEN_TYPE,
1234 X_PERSON_IDENTIFIER,
1235 X_GROUP_TYPE,
1236 X_COUNTRY,
1237 X_ADDRESS1,
1238 X_ADDRESS2,
1239 X_ADDRESS3,
1240 X_ADDRESS4,
1241 X_CITY,
1242 X_POSTAL_CODE,
1243 X_STATE,
1244 X_PROVINCE,
1245 X_STATUS,
1246 X_COUNTY,
1247 X_SIC_CODE_TYPE,
1248 X_URL,
1249 X_EMAIL_ADDRESS,
1250 X_ANALYSIS_FY,
1251 X_FISCAL_YEAREND_MONTH,
1252 X_EMPLOYEES_TOTAL,
1253 X_CURR_FY_POTENTIAL_REVENUE,
1254 X_NEXT_FY_POTENTIAL_REVENUE,
1255 X_YEAR_ESTABLISHED,
1256 X_GSA_INDICATOR_FLAG,
1257 X_MISSION_STATEMENT,
1258 X_ORGANIZATION_NAME_PHONETIC,
1259 X_PERSON_FIRST_NAME_PHONETIC,
1260 X_PERSON_LAST_NAME_PHONETIC,
1261 X_LANGUAGE_NAME,
1262 X_CATEGORY_CODE,
1263 X_SALUTATION,
1264 X_KNOWN_AS2,
1265 X_KNOWN_AS3,
1266 X_KNOWN_AS4,
1267 X_KNOWN_AS5,
1268 X_DUNS_NUMBER_C,
1269 X_CREATED_BY_MODULE,
1270 X_APPLICATION_ID
1271 FROM HZ_PARTIES
1272 WHERE PARTY_ID = X_PARTY_ID;
1273
1274 EXCEPTION
1275 WHEN NO_DATA_FOUND THEN
1276 FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1277 FND_MESSAGE.SET_TOKEN( 'RECORD', 'party_rec');
1278 FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PARTY_ID ) );
1279 FND_MSG_PUB.ADD;
1280 RAISE FND_API.G_EXC_ERROR;
1281
1282 END Select_Row;
1283
1284 PROCEDURE Delete_Row (
1285 X_PARTY_ID IN NUMBER
1286 ) IS
1287
1288 BEGIN
1289
1290 DELETE FROM HZ_PARTIES
1291 WHERE PARTY_ID = X_PARTY_ID;
1292
1293 IF ( SQL%NOTFOUND ) THEN
1294 RAISE NO_DATA_FOUND;
1295 END IF;
1296
1297 END Delete_Row;
1298
1299 END HZ_PARTIES_PKG;