[Home] [Help]
PACKAGE BODY: APPS.HZ_CUST_ACCT_SITES_PKG
Source
1 PACKAGE BODY HZ_CUST_ACCT_SITES_PKG AS
2 /*$Header: ARHASTTB.pls 120.4.12000000.2 2007/04/18 09:29:17 idali ship $ */
3
4 PROCEDURE Insert_Row (
5 X_CUST_ACCT_SITE_ID IN OUT NOCOPY NUMBER,
6 X_CUST_ACCOUNT_ID IN NUMBER,
7 X_PARTY_SITE_ID IN NUMBER,
8 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
9 X_ATTRIBUTE1 IN VARCHAR2,
10 X_ATTRIBUTE2 IN VARCHAR2,
11 X_ATTRIBUTE3 IN VARCHAR2,
12 X_ATTRIBUTE4 IN VARCHAR2,
13 X_ATTRIBUTE5 IN VARCHAR2,
14 X_ATTRIBUTE6 IN VARCHAR2,
15 X_ATTRIBUTE7 IN VARCHAR2,
16 X_ATTRIBUTE8 IN VARCHAR2,
17 X_ATTRIBUTE9 IN VARCHAR2,
18 X_ATTRIBUTE10 IN VARCHAR2,
19 X_ATTRIBUTE11 IN VARCHAR2,
20 X_ATTRIBUTE12 IN VARCHAR2,
21 X_ATTRIBUTE13 IN VARCHAR2,
22 X_ATTRIBUTE14 IN VARCHAR2,
23 X_ATTRIBUTE15 IN VARCHAR2,
24 X_ATTRIBUTE16 IN VARCHAR2,
25 X_ATTRIBUTE17 IN VARCHAR2,
26 X_ATTRIBUTE18 IN VARCHAR2,
27 X_ATTRIBUTE19 IN VARCHAR2,
28 X_ATTRIBUTE20 IN VARCHAR2,
29 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
30 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
31 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
32 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
33 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
34 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
35 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
36 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
37 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
38 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
39 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
40 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
41 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
42 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
43 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
44 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
45 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
46 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
47 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
48 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
49 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
50 X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
51 X_STATUS IN VARCHAR2,
52 X_CUSTOMER_CATEGORY_CODE IN VARCHAR2,
53 X_LANGUAGE IN VARCHAR2,
54 X_KEY_ACCOUNT_FLAG IN VARCHAR2,
55 X_TP_HEADER_ID IN NUMBER,
56 X_ECE_TP_LOCATION_CODE IN VARCHAR2,
57 X_PRIMARY_SPECIALIST_ID IN NUMBER,
58 X_SECONDARY_SPECIALIST_ID IN NUMBER,
59 X_TERRITORY_ID IN NUMBER,
60 X_TERRITORY IN VARCHAR2,
61 X_TRANSLATED_CUSTOMER_NAME IN VARCHAR2,
62 X_OBJECT_VERSION_NUMBER IN NUMBER,
63 X_CREATED_BY_MODULE IN VARCHAR2,
64 X_APPLICATION_ID IN NUMBER,
65 X_ORG_ID IN NUMBER /* DEFAULT NULL (Commented out in Bug 3456489) */
66 ) IS
67
68 l_success VARCHAR2(1) := 'N';
69
70 BEGIN
71
72 IF X_CUST_ACCT_SITE_ID = FND_API.G_MISS_NUM THEN
73 X_CUST_ACCT_SITE_ID := NULL;
74 END IF;
75
76 WHILE l_success = 'N' LOOP
77 BEGIN
78 INSERT INTO HZ_CUST_ACCT_SITES_ALL ( -- Bug 3456489
79 CUST_ACCT_SITE_ID,
80 CUST_ACCOUNT_ID,
81 PARTY_SITE_ID,
82 LAST_UPDATE_DATE,
83 LAST_UPDATED_BY,
84 CREATION_DATE,
85 CREATED_BY,
86 LAST_UPDATE_LOGIN,
87 REQUEST_ID,
88 PROGRAM_APPLICATION_ID,
89 PROGRAM_ID,
90 PROGRAM_UPDATE_DATE,
91 ATTRIBUTE_CATEGORY,
92 ATTRIBUTE1,
93 ATTRIBUTE2,
94 ATTRIBUTE3,
95 ATTRIBUTE4,
96 ATTRIBUTE5,
97 ATTRIBUTE6,
98 ATTRIBUTE7,
99 ATTRIBUTE8,
100 ATTRIBUTE9,
101 ATTRIBUTE10,
102 ATTRIBUTE11,
103 ATTRIBUTE12,
104 ATTRIBUTE13,
105 ATTRIBUTE14,
106 ATTRIBUTE15,
107 ATTRIBUTE16,
108 ATTRIBUTE17,
109 ATTRIBUTE18,
110 ATTRIBUTE19,
111 ATTRIBUTE20,
112 GLOBAL_ATTRIBUTE_CATEGORY,
113 GLOBAL_ATTRIBUTE1,
114 GLOBAL_ATTRIBUTE2,
115 GLOBAL_ATTRIBUTE3,
116 GLOBAL_ATTRIBUTE4,
117 GLOBAL_ATTRIBUTE5,
118 GLOBAL_ATTRIBUTE6,
119 GLOBAL_ATTRIBUTE7,
120 GLOBAL_ATTRIBUTE8,
121 GLOBAL_ATTRIBUTE9,
122 GLOBAL_ATTRIBUTE10,
123 GLOBAL_ATTRIBUTE11,
124 GLOBAL_ATTRIBUTE12,
125 GLOBAL_ATTRIBUTE13,
126 GLOBAL_ATTRIBUTE14,
127 GLOBAL_ATTRIBUTE15,
128 GLOBAL_ATTRIBUTE16,
129 GLOBAL_ATTRIBUTE17,
130 GLOBAL_ATTRIBUTE18,
131 GLOBAL_ATTRIBUTE19,
132 GLOBAL_ATTRIBUTE20,
133 ORIG_SYSTEM_REFERENCE,
134 STATUS,
135 CUSTOMER_CATEGORY_CODE,
136 KEY_ACCOUNT_FLAG,
137 TP_HEADER_ID,
138 ECE_TP_LOCATION_CODE,
139 PRIMARY_SPECIALIST_ID,
140 SECONDARY_SPECIALIST_ID,
141 TERRITORY_ID,
142 TERRITORY,
143 TRANSLATED_CUSTOMER_NAME,
144 OBJECT_VERSION_NUMBER,
145 CREATED_BY_MODULE,
146 APPLICATION_ID,
147 ORG_ID
148 )
149 VALUES (
150 DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCT_SITES_S.NEXTVAL, NULL, HZ_CUST_ACCT_SITES_S.NEXTVAL, X_CUST_ACCT_SITE_ID ),
151 DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
152 DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
153 HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
154 HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
155 HZ_UTILITY_V2PUB.CREATION_DATE,
156 HZ_UTILITY_V2PUB.CREATED_BY,
157 HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
158 HZ_UTILITY_V2PUB.REQUEST_ID,
159 HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
160 HZ_UTILITY_V2PUB.PROGRAM_ID,
161 HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
162 DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
163 DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
164 DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
165 DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
166 DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
167 DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
168 DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
169 DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
170 DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
171 DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
172 DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
173 DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
174 DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
175 DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
176 DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
177 DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
178 DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
179 DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
180 DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
181 DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
182 DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
183 DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
184 DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
185 DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
186 DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
187 DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
188 DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
189 DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
190 DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
191 DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
192 DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
193 DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
194 DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
195 DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
196 DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
197 DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
198 DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
199 DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
200 DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
201 DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
202 DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
203 DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
204 DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
205 DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
206 DECODE( X_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
207 DECODE( X_KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
208 DECODE( X_TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
209 DECODE( X_ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
210 DECODE( X_PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
211 DECODE( X_SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
212 DECODE( X_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
213 DECODE( X_TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
214 DECODE( X_TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
215 DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
216 DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
217 DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
218 -- Bug 3456489
219 -- DECODE( X_ORG_ID, NULL, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))), X_ORG_ID)
220 DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID)
221 ) RETURNING
222 CUST_ACCT_SITE_ID
223 INTO
224 X_CUST_ACCT_SITE_ID;
225
226 l_success := 'Y';
227
228 EXCEPTION
229 WHEN DUP_VAL_ON_INDEX THEN
230 IF INSTRB( SQLERRM, 'HZ_CUST_ACCT_SITES_U1' ) <> 0 OR
231 INSTRB( SQLERRM, 'HZ_CUST_ACCT_SITES_PK' ) <> 0
232 THEN
233 DECLARE
234 l_count NUMBER;
235 l_dummy VARCHAR2(1);
236 BEGIN
237 l_count := 1;
238 WHILE l_count > 0 LOOP
239 SELECT HZ_CUST_ACCT_SITES_S.NEXTVAL
240 INTO X_CUST_ACCT_SITE_ID FROM dual;
241 BEGIN
242 SELECT 'Y' INTO l_dummy
243 FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
244 WHERE CUST_ACCT_SITE_ID = X_CUST_ACCT_SITE_ID;
245 l_count := 1;
246 EXCEPTION
247 WHEN NO_DATA_FOUND THEN
248 l_count := 0;
249 END;
250 END LOOP;
251 END;
252 ELSIF INSTRB( SQLERRM, 'HZ_CUST_ACCT_SITES_U2' ) <> 0 AND
253 X_ORIG_SYSTEM_REFERENCE IS NULL
254 THEN
255 DECLARE
256 l_count NUMBER;
257 l_dummy VARCHAR2(1);
258 BEGIN
259 l_count := 1;
260 WHILE l_count > 0 LOOP
261 SELECT HZ_CUST_ACCT_SITES_S.NEXTVAL
262 INTO X_CUST_ACCT_SITE_ID FROM dual;
263 BEGIN
264 SELECT 'Y' INTO l_dummy
265 FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
266 WHERE ORIG_SYSTEM_REFERENCE = to_char(X_CUST_ACCT_SITE_ID)
267 AND ORG_ID = X_ORG_ID; -- Bug 3456489
268
269 l_count := 1;
270 EXCEPTION
271 WHEN NO_DATA_FOUND THEN
272 l_count := 0;
273 END;
274 END LOOP;
275 END;
276 ELSE
277 RAISE;
278 END IF;
279
280 END;
281 END LOOP;
282
283 END Insert_Row;
284
285 PROCEDURE Update_Row (
286 X_Rowid IN OUT NOCOPY VARCHAR2,
287 X_CUST_ACCT_SITE_ID IN NUMBER,
288 X_CUST_ACCOUNT_ID IN NUMBER,
289 X_PARTY_SITE_ID IN NUMBER,
290 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
291 X_ATTRIBUTE1 IN VARCHAR2,
292 X_ATTRIBUTE2 IN VARCHAR2,
293 X_ATTRIBUTE3 IN VARCHAR2,
294 X_ATTRIBUTE4 IN VARCHAR2,
295 X_ATTRIBUTE5 IN VARCHAR2,
296 X_ATTRIBUTE6 IN VARCHAR2,
297 X_ATTRIBUTE7 IN VARCHAR2,
298 X_ATTRIBUTE8 IN VARCHAR2,
299 X_ATTRIBUTE9 IN VARCHAR2,
300 X_ATTRIBUTE10 IN VARCHAR2,
301 X_ATTRIBUTE11 IN VARCHAR2,
302 X_ATTRIBUTE12 IN VARCHAR2,
303 X_ATTRIBUTE13 IN VARCHAR2,
304 X_ATTRIBUTE14 IN VARCHAR2,
305 X_ATTRIBUTE15 IN VARCHAR2,
306 X_ATTRIBUTE16 IN VARCHAR2,
307 X_ATTRIBUTE17 IN VARCHAR2,
308 X_ATTRIBUTE18 IN VARCHAR2,
309 X_ATTRIBUTE19 IN VARCHAR2,
310 X_ATTRIBUTE20 IN VARCHAR2,
311 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
312 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
313 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
314 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
315 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
316 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
317 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
318 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
319 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
320 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
321 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
322 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
323 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
324 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
325 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
326 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
327 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
328 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
329 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
330 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
331 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
332 X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
333 X_STATUS IN VARCHAR2,
334 X_CUSTOMER_CATEGORY_CODE IN VARCHAR2,
335 X_LANGUAGE IN VARCHAR2,
336 X_KEY_ACCOUNT_FLAG IN VARCHAR2,
337 X_TP_HEADER_ID IN NUMBER,
338 X_ECE_TP_LOCATION_CODE IN VARCHAR2,
339 X_PRIMARY_SPECIALIST_ID IN NUMBER,
340 X_SECONDARY_SPECIALIST_ID IN NUMBER,
341 X_TERRITORY_ID IN NUMBER,
342 X_TERRITORY IN VARCHAR2,
343 X_TRANSLATED_CUSTOMER_NAME IN VARCHAR2,
344 X_OBJECT_VERSION_NUMBER IN NUMBER,
345 X_CREATED_BY_MODULE IN VARCHAR2,
346 X_APPLICATION_ID IN NUMBER
347 ) IS
348
349 BEGIN
350
351 UPDATE HZ_CUST_ACCT_SITES_ALL SET
352 CUST_ACCT_SITE_ID = DECODE( X_CUST_ACCT_SITE_ID, NULL, CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
353 CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
354 PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
355 LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
356 LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357 CREATION_DATE = CREATION_DATE,
358 CREATED_BY = CREATED_BY,
359 LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
360 REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
361 PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
362 PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
363 PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
364 ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
365 ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
366 ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
367 ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
368 ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
369 ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
370 ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
371 ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
372 ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
373 ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
374 ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
375 ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
376 ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
377 ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
378 ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
379 ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
380 ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
381 ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
382 ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
383 ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
384 ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
385 GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
386 GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
387 GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
388 GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
389 GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
390 GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
391 GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
392 GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
393 GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
394 GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
395 GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
396 GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
397 GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
398 GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
399 GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
400 GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
401 GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
402 GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
403 GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
404 GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
405 GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
406 ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
407 STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
408 CUSTOMER_CATEGORY_CODE = DECODE( X_CUSTOMER_CATEGORY_CODE, NULL, CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
409 KEY_ACCOUNT_FLAG = DECODE( X_KEY_ACCOUNT_FLAG, NULL, KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
410 TP_HEADER_ID = DECODE( X_TP_HEADER_ID, NULL, TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
411 ECE_TP_LOCATION_CODE = DECODE( X_ECE_TP_LOCATION_CODE, NULL, ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
412 PRIMARY_SPECIALIST_ID = DECODE( X_PRIMARY_SPECIALIST_ID, NULL, PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
413 SECONDARY_SPECIALIST_ID = DECODE( X_SECONDARY_SPECIALIST_ID, NULL, SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
414 TERRITORY_ID = DECODE( X_TERRITORY_ID, NULL, TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
415 TERRITORY = DECODE( X_TERRITORY, NULL, TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
416 TRANSLATED_CUSTOMER_NAME = DECODE( X_TRANSLATED_CUSTOMER_NAME, NULL, TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
417 OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
418 CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
419 APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
420 WHERE ROWID = X_RowId;
421
422 IF ( SQL%NOTFOUND ) THEN
423 RAISE NO_DATA_FOUND;
424 END IF;
425
426 END Update_Row;
427
428 PROCEDURE Lock_Row (
429 X_Rowid IN OUT NOCOPY VARCHAR2,
430 X_CUST_ACCT_SITE_ID IN NUMBER,
431 X_CUST_ACCOUNT_ID IN NUMBER,
432 X_PARTY_SITE_ID IN NUMBER,
433 X_LAST_UPDATE_DATE IN DATE,
434 X_LAST_UPDATED_BY IN NUMBER,
435 X_CREATION_DATE IN DATE,
436 X_CREATED_BY IN NUMBER,
437 X_LAST_UPDATE_LOGIN IN NUMBER,
438 X_REQUEST_ID IN NUMBER,
439 X_PROGRAM_APPLICATION_ID IN NUMBER,
440 X_PROGRAM_ID IN NUMBER,
441 X_PROGRAM_UPDATE_DATE IN DATE,
442 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
443 X_ATTRIBUTE1 IN VARCHAR2,
444 X_ATTRIBUTE2 IN VARCHAR2,
445 X_ATTRIBUTE3 IN VARCHAR2,
446 X_ATTRIBUTE4 IN VARCHAR2,
447 X_ATTRIBUTE5 IN VARCHAR2,
448 X_ATTRIBUTE6 IN VARCHAR2,
449 X_ATTRIBUTE7 IN VARCHAR2,
450 X_ATTRIBUTE8 IN VARCHAR2,
451 X_ATTRIBUTE9 IN VARCHAR2,
452 X_ATTRIBUTE10 IN VARCHAR2,
453 X_ATTRIBUTE11 IN VARCHAR2,
454 X_ATTRIBUTE12 IN VARCHAR2,
455 X_ATTRIBUTE13 IN VARCHAR2,
456 X_ATTRIBUTE14 IN VARCHAR2,
457 X_ATTRIBUTE15 IN VARCHAR2,
458 X_ATTRIBUTE16 IN VARCHAR2,
459 X_ATTRIBUTE17 IN VARCHAR2,
460 X_ATTRIBUTE18 IN VARCHAR2,
461 X_ATTRIBUTE19 IN VARCHAR2,
462 X_ATTRIBUTE20 IN VARCHAR2,
463 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
464 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
465 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
466 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
467 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
468 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
469 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
470 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
471 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
472 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
473 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
474 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
475 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
476 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
477 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
478 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
479 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
480 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
481 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
482 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
483 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
484 X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
485 X_STATUS IN VARCHAR2,
486 X_CUSTOMER_CATEGORY_CODE IN VARCHAR2,
487 X_LANGUAGE IN VARCHAR2,
488 X_KEY_ACCOUNT_FLAG IN VARCHAR2,
489 X_TP_HEADER_ID IN NUMBER,
490 X_ECE_TP_LOCATION_CODE IN VARCHAR2,
491 X_PRIMARY_SPECIALIST_ID IN NUMBER,
492 X_SECONDARY_SPECIALIST_ID IN NUMBER,
493 X_TERRITORY_ID IN NUMBER,
494 X_TERRITORY IN VARCHAR2,
495 X_TRANSLATED_CUSTOMER_NAME IN VARCHAR2,
496 X_OBJECT_VERSION_NUMBER IN NUMBER,
497 X_CREATED_BY_MODULE IN VARCHAR2,
498 X_APPLICATION_ID IN NUMBER
499 ) IS
500
501 CURSOR C IS
502 SELECT * FROM HZ_CUST_ACCT_SITES
503 WHERE ROWID = x_Rowid
504 FOR UPDATE NOWAIT;
505 Recinfo C%ROWTYPE;
506
507 BEGIN
508
509 OPEN C;
510 FETCH C INTO Recinfo;
511 IF ( C%NOTFOUND ) THEN
512 CLOSE C;
513 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
514 APP_EXCEPTION.RAISE_EXCEPTION;
515 END IF;
516 CLOSE C;
517
518 IF (
519 ( ( Recinfo.CUST_ACCT_SITE_ID = X_CUST_ACCT_SITE_ID )
520 OR ( ( Recinfo.CUST_ACCT_SITE_ID IS NULL )
521 AND ( X_CUST_ACCT_SITE_ID IS NULL ) ) )
522 AND ( ( Recinfo.CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID )
523 OR ( ( Recinfo.CUST_ACCOUNT_ID IS NULL )
524 AND ( X_CUST_ACCOUNT_ID IS NULL ) ) )
525 AND ( ( Recinfo.PARTY_SITE_ID = X_PARTY_SITE_ID )
526 OR ( ( Recinfo.PARTY_SITE_ID IS NULL )
527 AND ( X_PARTY_SITE_ID IS NULL ) ) )
528 AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE )
529 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
530 AND ( X_LAST_UPDATE_DATE IS NULL ) ) )
531 AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY )
532 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
533 AND ( X_LAST_UPDATED_BY IS NULL ) ) )
534 AND ( ( Recinfo.CREATION_DATE = X_CREATION_DATE )
535 OR ( ( Recinfo.CREATION_DATE IS NULL )
536 AND ( X_CREATION_DATE IS NULL ) ) )
537 AND ( ( Recinfo.CREATED_BY = X_CREATED_BY )
538 OR ( ( Recinfo.CREATED_BY IS NULL )
539 AND ( X_CREATED_BY IS NULL ) ) )
540 AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN )
541 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
542 AND ( X_LAST_UPDATE_LOGIN IS NULL ) ) )
543 AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
544 OR ( ( Recinfo.REQUEST_ID IS NULL )
545 AND ( X_REQUEST_ID IS NULL ) ) )
546 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID )
547 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
548 AND ( X_PROGRAM_APPLICATION_ID IS NULL ) ) )
549 AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID )
550 OR ( ( Recinfo.PROGRAM_ID IS NULL )
551 AND ( X_PROGRAM_ID IS NULL ) ) )
552 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE )
553 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
554 AND ( X_PROGRAM_UPDATE_DATE IS NULL ) ) )
555 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY )
556 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
557 AND ( X_ATTRIBUTE_CATEGORY IS NULL ) ) )
558 AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
559 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
560 AND ( X_ATTRIBUTE1 IS NULL ) ) )
561 AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
562 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
563 AND ( X_ATTRIBUTE2 IS NULL ) ) )
564 AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
565 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
566 AND ( X_ATTRIBUTE3 IS NULL ) ) )
567 AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
568 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
569 AND ( X_ATTRIBUTE4 IS NULL ) ) )
570 AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
571 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
572 AND ( X_ATTRIBUTE5 IS NULL ) ) )
573 AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
574 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
575 AND ( X_ATTRIBUTE6 IS NULL ) ) )
576 AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
577 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
578 AND ( X_ATTRIBUTE7 IS NULL ) ) )
579 AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
580 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
581 AND ( X_ATTRIBUTE8 IS NULL ) ) )
582 AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
583 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
584 AND ( X_ATTRIBUTE9 IS NULL ) ) )
585 AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
586 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
587 AND ( X_ATTRIBUTE10 IS NULL ) ) )
588 AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
589 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
590 AND ( X_ATTRIBUTE11 IS NULL ) ) )
591 AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
592 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
593 AND ( X_ATTRIBUTE12 IS NULL ) ) )
594 AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
595 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
596 AND ( X_ATTRIBUTE13 IS NULL ) ) )
597 AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
598 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
599 AND ( X_ATTRIBUTE14 IS NULL ) ) )
600 AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
601 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
602 AND ( X_ATTRIBUTE15 IS NULL ) ) )
603 AND ( ( Recinfo.ATTRIBUTE16 = X_ATTRIBUTE16 )
604 OR ( ( Recinfo.ATTRIBUTE16 IS NULL )
605 AND ( X_ATTRIBUTE16 IS NULL ) ) )
606 AND ( ( Recinfo.ATTRIBUTE17 = X_ATTRIBUTE17 )
607 OR ( ( Recinfo.ATTRIBUTE17 IS NULL )
608 AND ( X_ATTRIBUTE17 IS NULL ) ) )
609 AND ( ( Recinfo.ATTRIBUTE18 = X_ATTRIBUTE18 )
610 OR ( ( Recinfo.ATTRIBUTE18 IS NULL )
611 AND ( X_ATTRIBUTE18 IS NULL ) ) )
612 AND ( ( Recinfo.ATTRIBUTE19 = X_ATTRIBUTE19 )
613 OR ( ( Recinfo.ATTRIBUTE19 IS NULL )
614 AND ( X_ATTRIBUTE19 IS NULL ) ) )
615 AND ( ( Recinfo.ATTRIBUTE20 = X_ATTRIBUTE20 )
616 OR ( ( Recinfo.ATTRIBUTE20 IS NULL )
617 AND ( X_ATTRIBUTE20 IS NULL ) ) )
618 AND ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY )
619 OR ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY IS NULL )
620 AND ( X_GLOBAL_ATTRIBUTE_CATEGORY IS NULL ) ) )
621 AND ( ( Recinfo.GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1 )
622 OR ( ( Recinfo.GLOBAL_ATTRIBUTE1 IS NULL )
623 AND ( X_GLOBAL_ATTRIBUTE1 IS NULL ) ) )
624 AND ( ( Recinfo.GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2 )
625 OR ( ( Recinfo.GLOBAL_ATTRIBUTE2 IS NULL )
626 AND ( X_GLOBAL_ATTRIBUTE2 IS NULL ) ) )
627 AND ( ( Recinfo.GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3 )
628 OR ( ( Recinfo.GLOBAL_ATTRIBUTE3 IS NULL )
629 AND ( X_GLOBAL_ATTRIBUTE3 IS NULL ) ) )
630 AND ( ( Recinfo.GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4 )
631 OR ( ( Recinfo.GLOBAL_ATTRIBUTE4 IS NULL )
632 AND ( X_GLOBAL_ATTRIBUTE4 IS NULL ) ) )
633 AND ( ( Recinfo.GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5 )
634 OR ( ( Recinfo.GLOBAL_ATTRIBUTE5 IS NULL )
635 AND ( X_GLOBAL_ATTRIBUTE5 IS NULL ) ) )
636 AND ( ( Recinfo.GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6 )
637 OR ( ( Recinfo.GLOBAL_ATTRIBUTE6 IS NULL )
638 AND ( X_GLOBAL_ATTRIBUTE6 IS NULL ) ) )
639 AND ( ( Recinfo.GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7 )
640 OR ( ( Recinfo.GLOBAL_ATTRIBUTE7 IS NULL )
641 AND ( X_GLOBAL_ATTRIBUTE7 IS NULL ) ) )
642 AND ( ( Recinfo.GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8 )
643 OR ( ( Recinfo.GLOBAL_ATTRIBUTE8 IS NULL )
644 AND ( X_GLOBAL_ATTRIBUTE8 IS NULL ) ) )
645 AND ( ( Recinfo.GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9 )
646 OR ( ( Recinfo.GLOBAL_ATTRIBUTE9 IS NULL )
647 AND ( X_GLOBAL_ATTRIBUTE9 IS NULL ) ) )
648 AND ( ( Recinfo.GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10 )
649 OR ( ( Recinfo.GLOBAL_ATTRIBUTE10 IS NULL )
650 AND ( X_GLOBAL_ATTRIBUTE10 IS NULL ) ) )
651 AND ( ( Recinfo.GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11 )
652 OR ( ( Recinfo.GLOBAL_ATTRIBUTE11 IS NULL )
653 AND ( X_GLOBAL_ATTRIBUTE11 IS NULL ) ) )
654 AND ( ( Recinfo.GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12 )
655 OR ( ( Recinfo.GLOBAL_ATTRIBUTE12 IS NULL )
656 AND ( X_GLOBAL_ATTRIBUTE12 IS NULL ) ) )
657 AND ( ( Recinfo.GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13 )
658 OR ( ( Recinfo.GLOBAL_ATTRIBUTE13 IS NULL )
659 AND ( X_GLOBAL_ATTRIBUTE13 IS NULL ) ) )
660 AND ( ( Recinfo.GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14 )
661 OR ( ( Recinfo.GLOBAL_ATTRIBUTE14 IS NULL )
662 AND ( X_GLOBAL_ATTRIBUTE14 IS NULL ) ) )
663 AND ( ( Recinfo.GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15 )
664 OR ( ( Recinfo.GLOBAL_ATTRIBUTE15 IS NULL )
665 AND ( X_GLOBAL_ATTRIBUTE15 IS NULL ) ) )
666 AND ( ( Recinfo.GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16 )
667 OR ( ( Recinfo.GLOBAL_ATTRIBUTE16 IS NULL )
668 AND ( X_GLOBAL_ATTRIBUTE16 IS NULL ) ) )
669 AND ( ( Recinfo.GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17 )
670 OR ( ( Recinfo.GLOBAL_ATTRIBUTE17 IS NULL )
671 AND ( X_GLOBAL_ATTRIBUTE17 IS NULL ) ) )
672 AND ( ( Recinfo.GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18 )
673 OR ( ( Recinfo.GLOBAL_ATTRIBUTE18 IS NULL )
674 AND ( X_GLOBAL_ATTRIBUTE18 IS NULL ) ) )
675 AND ( ( Recinfo.GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19 )
676 OR ( ( Recinfo.GLOBAL_ATTRIBUTE19 IS NULL )
677 AND ( X_GLOBAL_ATTRIBUTE19 IS NULL ) ) )
678 AND ( ( Recinfo.GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20 )
679 OR ( ( Recinfo.GLOBAL_ATTRIBUTE20 IS NULL )
680 AND ( X_GLOBAL_ATTRIBUTE20 IS NULL ) ) )
681 AND ( ( Recinfo.ORIG_SYSTEM_REFERENCE = X_ORIG_SYSTEM_REFERENCE )
682 OR ( ( Recinfo.ORIG_SYSTEM_REFERENCE IS NULL )
683 AND ( X_ORIG_SYSTEM_REFERENCE IS NULL ) ) )
684 AND ( ( Recinfo.STATUS = X_STATUS )
685 OR ( ( Recinfo.STATUS IS NULL )
686 AND ( X_STATUS IS NULL ) ) )
687 AND ( ( Recinfo.CUSTOMER_CATEGORY_CODE = X_CUSTOMER_CATEGORY_CODE )
688 OR ( ( Recinfo.CUSTOMER_CATEGORY_CODE IS NULL )
689 AND ( X_CUSTOMER_CATEGORY_CODE IS NULL ) ) )
690 AND ( ( Recinfo.KEY_ACCOUNT_FLAG = X_KEY_ACCOUNT_FLAG )
691 OR ( ( Recinfo.KEY_ACCOUNT_FLAG IS NULL )
692 AND ( X_KEY_ACCOUNT_FLAG IS NULL ) ) )
693 AND ( ( Recinfo.TP_HEADER_ID = X_TP_HEADER_ID )
694 OR ( ( Recinfo.TP_HEADER_ID IS NULL )
695 AND ( X_TP_HEADER_ID IS NULL ) ) )
696 AND ( ( Recinfo.ECE_TP_LOCATION_CODE = X_ECE_TP_LOCATION_CODE )
697 OR ( ( Recinfo.ECE_TP_LOCATION_CODE IS NULL )
698 AND ( X_ECE_TP_LOCATION_CODE IS NULL ) ) )
699 AND ( ( Recinfo.PRIMARY_SPECIALIST_ID = X_PRIMARY_SPECIALIST_ID )
700 OR ( ( Recinfo.PRIMARY_SPECIALIST_ID IS NULL )
701 AND ( X_PRIMARY_SPECIALIST_ID IS NULL ) ) )
702 AND ( ( Recinfo.SECONDARY_SPECIALIST_ID = X_SECONDARY_SPECIALIST_ID )
703 OR ( ( Recinfo.SECONDARY_SPECIALIST_ID IS NULL )
704 AND ( X_SECONDARY_SPECIALIST_ID IS NULL ) ) )
705 AND ( ( Recinfo.TERRITORY_ID = X_TERRITORY_ID )
706 OR ( ( Recinfo.TERRITORY_ID IS NULL )
707 AND ( X_TERRITORY_ID IS NULL ) ) )
708 AND ( ( Recinfo.TERRITORY = X_TERRITORY )
709 OR ( ( Recinfo.TERRITORY IS NULL )
710 AND ( X_TERRITORY IS NULL ) ) )
711 AND ( ( Recinfo.TRANSLATED_CUSTOMER_NAME = X_TRANSLATED_CUSTOMER_NAME )
712 OR ( ( Recinfo.TRANSLATED_CUSTOMER_NAME IS NULL )
713 AND ( X_TRANSLATED_CUSTOMER_NAME IS NULL ) ) )
714 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER )
715 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
716 AND ( X_OBJECT_VERSION_NUMBER IS NULL ) ) )
717 AND ( ( Recinfo.CREATED_BY_MODULE = X_CREATED_BY_MODULE )
718 OR ( ( Recinfo.CREATED_BY_MODULE IS NULL )
719 AND ( X_CREATED_BY_MODULE IS NULL ) ) )
720 AND ( ( Recinfo.APPLICATION_ID = X_APPLICATION_ID )
721 OR ( ( Recinfo.APPLICATION_ID IS NULL )
722 AND ( X_APPLICATION_ID IS NULL ) ) )
723 ) THEN
724 RETURN;
725 ELSE
726 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
727 APP_EXCEPTION.RAISE_EXCEPTION;
728 END IF;
729
730 END Lock_Row;
731
732 PROCEDURE Select_Row (
733 X_CUST_ACCT_SITE_ID IN OUT NOCOPY NUMBER,
734 X_CUST_ACCOUNT_ID OUT NOCOPY NUMBER,
735 X_PARTY_SITE_ID OUT NOCOPY NUMBER,
736 X_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
737 X_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
738 X_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
739 X_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
740 X_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
741 X_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
742 X_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
743 X_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
744 X_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
745 X_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
746 X_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
747 X_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
748 X_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
749 X_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
750 X_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
751 X_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
752 X_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
753 X_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
754 X_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
755 X_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
756 X_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
757 X_GLOBAL_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
758 X_GLOBAL_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
759 X_GLOBAL_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
760 X_GLOBAL_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
761 X_GLOBAL_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
762 X_GLOBAL_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
763 X_GLOBAL_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
764 X_GLOBAL_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
765 X_GLOBAL_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
766 X_GLOBAL_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
767 X_GLOBAL_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
768 X_GLOBAL_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
769 X_GLOBAL_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
770 X_GLOBAL_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
771 X_GLOBAL_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
772 X_GLOBAL_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
773 X_GLOBAL_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
774 X_GLOBAL_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
775 X_GLOBAL_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
776 X_GLOBAL_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
777 X_GLOBAL_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
778 X_ORIG_SYSTEM_REFERENCE OUT NOCOPY VARCHAR2,
779 X_STATUS OUT NOCOPY VARCHAR2,
780 X_CUSTOMER_CATEGORY_CODE OUT NOCOPY VARCHAR2,
781 X_LANGUAGE OUT NOCOPY VARCHAR2,
782 X_KEY_ACCOUNT_FLAG OUT NOCOPY VARCHAR2,
783 X_TP_HEADER_ID OUT NOCOPY NUMBER,
784 X_ECE_TP_LOCATION_CODE OUT NOCOPY VARCHAR2,
785 X_PRIMARY_SPECIALIST_ID OUT NOCOPY NUMBER,
786 X_SECONDARY_SPECIALIST_ID OUT NOCOPY NUMBER,
787 X_TERRITORY_ID OUT NOCOPY NUMBER,
788 X_TERRITORY OUT NOCOPY VARCHAR2,
789 X_TRANSLATED_CUSTOMER_NAME OUT NOCOPY VARCHAR2,
790 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
791 X_APPLICATION_ID OUT NOCOPY NUMBER,
792 X_ORG_ID OUT NOCOPY NUMBER -- Bug 3456489
793 ) IS
794
795 BEGIN
796
797 SELECT
798 NVL( CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM ),
799 NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
800 NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
801 NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
802 NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
803 NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
804 NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
805 NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
806 NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
807 NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
808 NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
809 NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
810 NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
811 NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
812 NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
813 NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
814 NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
815 NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
816 NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
817 NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
818 NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
819 NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
820 NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
821 NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
822 NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
823 NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
824 NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
825 NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
826 NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
827 NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
828 NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
829 NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
830 NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
831 NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
832 NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
833 NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
834 NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
835 NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
836 NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
837 NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
838 NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
839 NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
840 NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
841 NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
842 NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
843 NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
844 NVL( STATUS, FND_API.G_MISS_CHAR ),
845 NVL( CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR ),
846 NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
847 NVL( KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR ),
848 NVL( TP_HEADER_ID, FND_API.G_MISS_NUM ),
849 NVL( ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR ),
850 NVL( PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
851 NVL( SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
852 NVL( TERRITORY_ID, FND_API.G_MISS_NUM ),
853 NVL( TERRITORY, FND_API.G_MISS_CHAR ),
854 NVL( TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR ),
855 NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
856 NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
857 NVL( ORG_ID, FND_API.G_MISS_NUM)
858 INTO
859 X_CUST_ACCT_SITE_ID,
860 X_CUST_ACCOUNT_ID,
861 X_PARTY_SITE_ID,
862 X_ATTRIBUTE_CATEGORY,
863 X_ATTRIBUTE1,
864 X_ATTRIBUTE2,
865 X_ATTRIBUTE3,
866 X_ATTRIBUTE4,
867 X_ATTRIBUTE5,
868 X_ATTRIBUTE6,
869 X_ATTRIBUTE7,
870 X_ATTRIBUTE8,
871 X_ATTRIBUTE9,
872 X_ATTRIBUTE10,
873 X_ATTRIBUTE11,
874 X_ATTRIBUTE12,
875 X_ATTRIBUTE13,
876 X_ATTRIBUTE14,
877 X_ATTRIBUTE15,
878 X_ATTRIBUTE16,
879 X_ATTRIBUTE17,
880 X_ATTRIBUTE18,
881 X_ATTRIBUTE19,
882 X_ATTRIBUTE20,
883 X_GLOBAL_ATTRIBUTE_CATEGORY,
884 X_GLOBAL_ATTRIBUTE1,
885 X_GLOBAL_ATTRIBUTE2,
886 X_GLOBAL_ATTRIBUTE3,
887 X_GLOBAL_ATTRIBUTE4,
888 X_GLOBAL_ATTRIBUTE5,
889 X_GLOBAL_ATTRIBUTE6,
890 X_GLOBAL_ATTRIBUTE7,
891 X_GLOBAL_ATTRIBUTE8,
892 X_GLOBAL_ATTRIBUTE9,
893 X_GLOBAL_ATTRIBUTE10,
894 X_GLOBAL_ATTRIBUTE11,
895 X_GLOBAL_ATTRIBUTE12,
896 X_GLOBAL_ATTRIBUTE13,
897 X_GLOBAL_ATTRIBUTE14,
898 X_GLOBAL_ATTRIBUTE15,
899 X_GLOBAL_ATTRIBUTE16,
900 X_GLOBAL_ATTRIBUTE17,
901 X_GLOBAL_ATTRIBUTE18,
902 X_GLOBAL_ATTRIBUTE19,
903 X_GLOBAL_ATTRIBUTE20,
904 X_ORIG_SYSTEM_REFERENCE,
905 X_STATUS,
906 X_CUSTOMER_CATEGORY_CODE,
907 X_LANGUAGE,
908 X_KEY_ACCOUNT_FLAG,
909 X_TP_HEADER_ID,
910 X_ECE_TP_LOCATION_CODE,
911 X_PRIMARY_SPECIALIST_ID,
912 X_SECONDARY_SPECIALIST_ID,
913 X_TERRITORY_ID,
914 X_TERRITORY,
915 X_TRANSLATED_CUSTOMER_NAME,
916 X_CREATED_BY_MODULE,
917 X_APPLICATION_ID,
918 X_ORG_ID
919 FROM HZ_CUST_ACCT_SITES_ALL
920 WHERE CUST_ACCT_SITE_ID = X_CUST_ACCT_SITE_ID;
921
922 EXCEPTION
923 WHEN NO_DATA_FOUND THEN
924 FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
925 FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_acct_site_rec');
926 FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCT_SITE_ID ) );
927 FND_MSG_PUB.ADD;
928 RAISE FND_API.G_EXC_ERROR;
929
930 END Select_Row;
931
932 PROCEDURE Delete_Row (
933 X_CUST_ACCT_SITE_ID IN NUMBER
934 ) IS
935
936 BEGIN
937
938 DELETE FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
939 WHERE CUST_ACCT_SITE_ID = X_CUST_ACCT_SITE_ID;
940
941 IF ( SQL%NOTFOUND ) THEN
942 RAISE NO_DATA_FOUND;
943 END IF;
944
945 END Delete_Row;
946
947 END HZ_CUST_ACCT_SITES_PKG;