[Home] [Help]
PACKAGE BODY: APPS.HZ_RELATIONSHIPS_PKG
Source
1 PACKAGE BODY HZ_RELATIONSHIPS_PKG AS
2 /*$Header: ARHRELTB.pls 120.5 2010/07/28 13:20:51 rgokavar ship $ */
3
4 G_MISS_CONTENT_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'USER_ENTERED';
5
6 PROCEDURE Insert_Row (
7 X_RELATIONSHIP_ID IN OUT NOCOPY NUMBER,
8 X_SUBJECT_ID IN NUMBER,
9 X_SUBJECT_TYPE IN VARCHAR2,
10 X_SUBJECT_TABLE_NAME IN VARCHAR2,
11 X_OBJECT_ID IN NUMBER,
12 X_OBJECT_TYPE IN VARCHAR2,
13 X_OBJECT_TABLE_NAME IN VARCHAR2,
14 X_PARTY_ID IN NUMBER,
15 X_RELATIONSHIP_CODE IN VARCHAR2,
16 X_DIRECTIONAL_FLAG IN VARCHAR2,
17 X_COMMENTS IN VARCHAR2,
18 X_START_DATE IN DATE,
19 X_END_DATE IN DATE,
20 X_STATUS IN VARCHAR2,
21 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
22 X_ATTRIBUTE1 IN VARCHAR2,
23 X_ATTRIBUTE2 IN VARCHAR2,
24 X_ATTRIBUTE3 IN VARCHAR2,
25 X_ATTRIBUTE4 IN VARCHAR2,
26 X_ATTRIBUTE5 IN VARCHAR2,
27 X_ATTRIBUTE6 IN VARCHAR2,
28 X_ATTRIBUTE7 IN VARCHAR2,
29 X_ATTRIBUTE8 IN VARCHAR2,
30 X_ATTRIBUTE9 IN VARCHAR2,
31 X_ATTRIBUTE10 IN VARCHAR2,
32 X_ATTRIBUTE11 IN VARCHAR2,
33 X_ATTRIBUTE12 IN VARCHAR2,
34 X_ATTRIBUTE13 IN VARCHAR2,
35 X_ATTRIBUTE14 IN VARCHAR2,
36 X_ATTRIBUTE15 IN VARCHAR2,
37 X_ATTRIBUTE16 IN VARCHAR2,
38 X_ATTRIBUTE17 IN VARCHAR2,
39 X_ATTRIBUTE18 IN VARCHAR2,
40 X_ATTRIBUTE19 IN VARCHAR2,
41 X_ATTRIBUTE20 IN VARCHAR2,
42 X_CONTENT_SOURCE_TYPE IN VARCHAR2,
43 X_RELATIONSHIP_TYPE IN VARCHAR2,
44 X_OBJECT_VERSION_NUMBER IN NUMBER,
45 X_CREATED_BY_MODULE IN VARCHAR2,
46 X_APPLICATION_ID IN NUMBER,
47 X_ADDITIONAL_INFORMATION1 IN VARCHAR2,
48 X_ADDITIONAL_INFORMATION2 IN VARCHAR2,
49 X_ADDITIONAL_INFORMATION3 IN VARCHAR2,
50 X_ADDITIONAL_INFORMATION4 IN VARCHAR2,
51 X_ADDITIONAL_INFORMATION5 IN VARCHAR2,
52 X_ADDITIONAL_INFORMATION6 IN VARCHAR2,
53 X_ADDITIONAL_INFORMATION7 IN VARCHAR2,
54 X_ADDITIONAL_INFORMATION8 IN VARCHAR2,
55 X_ADDITIONAL_INFORMATION9 IN VARCHAR2,
56 X_ADDITIONAL_INFORMATION10 IN VARCHAR2,
57 X_ADDITIONAL_INFORMATION11 IN VARCHAR2,
58 X_ADDITIONAL_INFORMATION12 IN VARCHAR2,
59 X_ADDITIONAL_INFORMATION13 IN VARCHAR2,
60 X_ADDITIONAL_INFORMATION14 IN VARCHAR2,
61 X_ADDITIONAL_INFORMATION15 IN VARCHAR2,
62 X_ADDITIONAL_INFORMATION16 IN VARCHAR2,
63 X_ADDITIONAL_INFORMATION17 IN VARCHAR2,
64 X_ADDITIONAL_INFORMATION18 IN VARCHAR2,
65 X_ADDITIONAL_INFORMATION19 IN VARCHAR2,
66 X_ADDITIONAL_INFORMATION20 IN VARCHAR2,
67 X_ADDITIONAL_INFORMATION21 IN VARCHAR2,
68 X_ADDITIONAL_INFORMATION22 IN VARCHAR2,
69 X_ADDITIONAL_INFORMATION23 IN VARCHAR2,
70 X_ADDITIONAL_INFORMATION24 IN VARCHAR2,
71 X_ADDITIONAL_INFORMATION25 IN VARCHAR2,
72 X_ADDITIONAL_INFORMATION26 IN VARCHAR2,
73 X_ADDITIONAL_INFORMATION27 IN VARCHAR2,
74 X_ADDITIONAL_INFORMATION28 IN VARCHAR2,
75 X_ADDITIONAL_INFORMATION29 IN VARCHAR2,
76 X_ADDITIONAL_INFORMATION30 IN VARCHAR2,
77 X_DIRECTION_CODE IN VARCHAR2,
78 X_PERCENTAGE_OWNERSHIP IN NUMBER,
79 X_ACTUAL_CONTENT_SOURCE IN VARCHAR2
80 ) IS
81
82 BEGIN
83
84 INSERT INTO HZ_RELATIONSHIPS (
85 RELATIONSHIP_ID,
86 SUBJECT_ID,
87 SUBJECT_TYPE,
88 SUBJECT_TABLE_NAME,
89 OBJECT_ID,
90 OBJECT_TYPE,
91 OBJECT_TABLE_NAME,
92 PARTY_ID,
93 RELATIONSHIP_CODE,
94 DIRECTIONAL_FLAG,
95 COMMENTS,
96 START_DATE,
97 END_DATE,
98 STATUS,
99 CREATED_BY,
100 CREATION_DATE,
101 LAST_UPDATED_BY,
102 LAST_UPDATE_DATE,
103 LAST_UPDATE_LOGIN,
104 REQUEST_ID,
105 PROGRAM_APPLICATION_ID,
106 PROGRAM_ID,
107 PROGRAM_UPDATE_DATE,
108 ATTRIBUTE_CATEGORY,
109 ATTRIBUTE1,
110 ATTRIBUTE2,
111 ATTRIBUTE3,
112 ATTRIBUTE4,
113 ATTRIBUTE5,
114 ATTRIBUTE6,
115 ATTRIBUTE7,
116 ATTRIBUTE8,
117 ATTRIBUTE9,
118 ATTRIBUTE10,
119 ATTRIBUTE11,
120 ATTRIBUTE12,
121 ATTRIBUTE13,
122 ATTRIBUTE14,
123 ATTRIBUTE15,
124 ATTRIBUTE16,
125 ATTRIBUTE17,
126 ATTRIBUTE18,
127 ATTRIBUTE19,
128 ATTRIBUTE20,
129 CONTENT_SOURCE_TYPE,
130 RELATIONSHIP_TYPE,
131 OBJECT_VERSION_NUMBER,
132 CREATED_BY_MODULE,
133 APPLICATION_ID,
134 ADDITIONAL_INFORMATION1,
135 ADDITIONAL_INFORMATION2,
136 ADDITIONAL_INFORMATION3,
137 ADDITIONAL_INFORMATION4,
138 ADDITIONAL_INFORMATION5,
139 ADDITIONAL_INFORMATION6,
140 ADDITIONAL_INFORMATION7,
141 ADDITIONAL_INFORMATION8,
142 ADDITIONAL_INFORMATION9,
143 ADDITIONAL_INFORMATION10,
144 ADDITIONAL_INFORMATION11,
145 ADDITIONAL_INFORMATION12,
146 ADDITIONAL_INFORMATION13,
147 ADDITIONAL_INFORMATION14,
148 ADDITIONAL_INFORMATION15,
149 ADDITIONAL_INFORMATION16,
150 ADDITIONAL_INFORMATION17,
151 ADDITIONAL_INFORMATION18,
152 ADDITIONAL_INFORMATION19,
153 ADDITIONAL_INFORMATION20,
154 ADDITIONAL_INFORMATION21,
155 ADDITIONAL_INFORMATION22,
156 ADDITIONAL_INFORMATION23,
157 ADDITIONAL_INFORMATION24,
158 ADDITIONAL_INFORMATION25,
159 ADDITIONAL_INFORMATION26,
160 ADDITIONAL_INFORMATION27,
161 ADDITIONAL_INFORMATION28,
162 ADDITIONAL_INFORMATION29,
163 ADDITIONAL_INFORMATION30,
164 DIRECTION_CODE,
165 PERCENTAGE_OWNERSHIP,
166 ACTUAL_CONTENT_SOURCE
167 )
168 VALUES (
169 DECODE( X_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_RELATIONSHIP_ID ),
170 DECODE( X_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, X_SUBJECT_ID ),
171 DECODE( X_SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, X_SUBJECT_TYPE ),
172 DECODE( X_SUBJECT_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_SUBJECT_TABLE_NAME ),
173 DECODE( X_OBJECT_ID, FND_API.G_MISS_NUM, NULL, X_OBJECT_ID ),
174 DECODE( X_OBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, X_OBJECT_TYPE ),
175 DECODE( X_OBJECT_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OBJECT_TABLE_NAME ),
176 DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
177 DECODE( X_RELATIONSHIP_CODE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_CODE ),
178 DECODE( X_DIRECTIONAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_DIRECTIONAL_FLAG ),
179 DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
180 DECODE( TO_CHAR(X_START_DATE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), SYSDATE, NULL,SYSDATE,X_START_DATE ),
181 DECODE( TO_CHAR(X_END_DATE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), NULL, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
182 DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
183 HZ_UTILITY_V2PUB.CREATED_BY,
184 HZ_UTILITY_V2PUB.CREATION_DATE,
185 HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186 HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187 HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188 HZ_UTILITY_V2PUB.REQUEST_ID,
189 HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190 HZ_UTILITY_V2PUB.PROGRAM_ID,
191 HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
192 DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
193 DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
194 DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
195 DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
196 DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
197 DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
198 DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
199 DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
200 DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
201 DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
202 DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
203 DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
204 DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
205 DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
206 DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
207 DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
208 DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
209 DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
210 DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
211 DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
212 DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
213 DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
214 DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
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 DECODE( X_ADDITIONAL_INFORMATION1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION1 ),
219 DECODE( X_ADDITIONAL_INFORMATION2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION2 ),
220 DECODE( X_ADDITIONAL_INFORMATION3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION3 ),
221 DECODE( X_ADDITIONAL_INFORMATION4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION4 ),
222 DECODE( X_ADDITIONAL_INFORMATION5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION5 ),
223 DECODE( X_ADDITIONAL_INFORMATION6, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION6 ),
224 DECODE( X_ADDITIONAL_INFORMATION7, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION7 ),
225 DECODE( X_ADDITIONAL_INFORMATION8, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION8 ),
226 DECODE( X_ADDITIONAL_INFORMATION9, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION9 ),
227 DECODE( X_ADDITIONAL_INFORMATION10, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION10 ),
228 DECODE( X_ADDITIONAL_INFORMATION11, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION11 ),
229 DECODE( X_ADDITIONAL_INFORMATION12, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION12 ),
230 DECODE( X_ADDITIONAL_INFORMATION13, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION13 ),
231 DECODE( X_ADDITIONAL_INFORMATION14, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION14 ),
232 DECODE( X_ADDITIONAL_INFORMATION15, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION15 ),
233 DECODE( X_ADDITIONAL_INFORMATION16, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION16 ),
234 DECODE( X_ADDITIONAL_INFORMATION17, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION17 ),
235 DECODE( X_ADDITIONAL_INFORMATION18, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION18 ),
236 DECODE( X_ADDITIONAL_INFORMATION19, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION19 ),
237 DECODE( X_ADDITIONAL_INFORMATION20, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION20 ),
238 DECODE( X_ADDITIONAL_INFORMATION21, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION21 ),
239 DECODE( X_ADDITIONAL_INFORMATION22, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION22 ),
240 DECODE( X_ADDITIONAL_INFORMATION23, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION23 ),
241 DECODE( X_ADDITIONAL_INFORMATION24, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION24 ),
242 DECODE( X_ADDITIONAL_INFORMATION25, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION25 ),
243 DECODE( X_ADDITIONAL_INFORMATION26, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION26 ),
244 DECODE( X_ADDITIONAL_INFORMATION27, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION27 ),
245 DECODE( X_ADDITIONAL_INFORMATION28, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION28 ),
249 DECODE( X_PERCENTAGE_OWNERSHIP, FND_API.G_MISS_NUM, NULL, X_PERCENTAGE_OWNERSHIP ),
246 DECODE( X_ADDITIONAL_INFORMATION29, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION29 ),
247 DECODE( X_ADDITIONAL_INFORMATION30, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION30 ),
248 DECODE( X_DIRECTION_CODE, FND_API.G_MISS_CHAR, NULL, X_DIRECTION_CODE ),
250 DECODE( X_ACTUAL_CONTENT_SOURCE,
251 FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
252 NULL, G_MISS_CONTENT_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE )
253 ) RETURNING
254 RELATIONSHIP_ID
255 INTO
256 X_RELATIONSHIP_ID;
257
258 END Insert_Row;
259
260 PROCEDURE Update_Row (
261 X_Rowid IN OUT NOCOPY VARCHAR2,
262 X_RELATIONSHIP_ID IN NUMBER,
263 X_SUBJECT_ID IN NUMBER,
264 X_SUBJECT_TYPE IN VARCHAR2,
265 X_SUBJECT_TABLE_NAME IN VARCHAR2,
266 X_OBJECT_ID IN NUMBER,
267 X_OBJECT_TYPE IN VARCHAR2,
268 X_OBJECT_TABLE_NAME IN VARCHAR2,
269 X_PARTY_ID IN NUMBER,
270 X_RELATIONSHIP_CODE IN VARCHAR2,
271 X_DIRECTIONAL_FLAG IN VARCHAR2,
272 X_COMMENTS IN VARCHAR2,
273 X_START_DATE IN DATE,
274 X_END_DATE IN DATE,
275 X_STATUS IN VARCHAR2,
276 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
277 X_ATTRIBUTE1 IN VARCHAR2,
278 X_ATTRIBUTE2 IN VARCHAR2,
279 X_ATTRIBUTE3 IN VARCHAR2,
280 X_ATTRIBUTE4 IN VARCHAR2,
281 X_ATTRIBUTE5 IN VARCHAR2,
282 X_ATTRIBUTE6 IN VARCHAR2,
283 X_ATTRIBUTE7 IN VARCHAR2,
284 X_ATTRIBUTE8 IN VARCHAR2,
285 X_ATTRIBUTE9 IN VARCHAR2,
286 X_ATTRIBUTE10 IN VARCHAR2,
287 X_ATTRIBUTE11 IN VARCHAR2,
288 X_ATTRIBUTE12 IN VARCHAR2,
289 X_ATTRIBUTE13 IN VARCHAR2,
290 X_ATTRIBUTE14 IN VARCHAR2,
291 X_ATTRIBUTE15 IN VARCHAR2,
292 X_ATTRIBUTE16 IN VARCHAR2,
293 X_ATTRIBUTE17 IN VARCHAR2,
294 X_ATTRIBUTE18 IN VARCHAR2,
295 X_ATTRIBUTE19 IN VARCHAR2,
296 X_ATTRIBUTE20 IN VARCHAR2,
297 X_CONTENT_SOURCE_TYPE IN VARCHAR2,
298 X_RELATIONSHIP_TYPE IN VARCHAR2,
299 X_OBJECT_VERSION_NUMBER IN NUMBER,
300 X_CREATED_BY_MODULE IN VARCHAR2,
301 X_APPLICATION_ID IN NUMBER,
302 X_ADDITIONAL_INFORMATION1 IN VARCHAR2,
303 X_ADDITIONAL_INFORMATION2 IN VARCHAR2,
304 X_ADDITIONAL_INFORMATION3 IN VARCHAR2,
305 X_ADDITIONAL_INFORMATION4 IN VARCHAR2,
306 X_ADDITIONAL_INFORMATION5 IN VARCHAR2,
307 X_ADDITIONAL_INFORMATION6 IN VARCHAR2,
308 X_ADDITIONAL_INFORMATION7 IN VARCHAR2,
309 X_ADDITIONAL_INFORMATION8 IN VARCHAR2,
310 X_ADDITIONAL_INFORMATION9 IN VARCHAR2,
311 X_ADDITIONAL_INFORMATION10 IN VARCHAR2,
312 X_ADDITIONAL_INFORMATION11 IN VARCHAR2,
313 X_ADDITIONAL_INFORMATION12 IN VARCHAR2,
314 X_ADDITIONAL_INFORMATION13 IN VARCHAR2,
315 X_ADDITIONAL_INFORMATION14 IN VARCHAR2,
316 X_ADDITIONAL_INFORMATION15 IN VARCHAR2,
317 X_ADDITIONAL_INFORMATION16 IN VARCHAR2,
318 X_ADDITIONAL_INFORMATION17 IN VARCHAR2,
319 X_ADDITIONAL_INFORMATION18 IN VARCHAR2,
320 X_ADDITIONAL_INFORMATION19 IN VARCHAR2,
321 X_ADDITIONAL_INFORMATION20 IN VARCHAR2,
322 X_ADDITIONAL_INFORMATION21 IN VARCHAR2,
323 X_ADDITIONAL_INFORMATION22 IN VARCHAR2,
324 X_ADDITIONAL_INFORMATION23 IN VARCHAR2,
325 X_ADDITIONAL_INFORMATION24 IN VARCHAR2,
326 X_ADDITIONAL_INFORMATION25 IN VARCHAR2,
327 X_ADDITIONAL_INFORMATION26 IN VARCHAR2,
328 X_ADDITIONAL_INFORMATION27 IN VARCHAR2,
329 X_ADDITIONAL_INFORMATION28 IN VARCHAR2,
330 X_ADDITIONAL_INFORMATION29 IN VARCHAR2,
331 X_ADDITIONAL_INFORMATION30 IN VARCHAR2,
332 X_DIRECTION_CODE IN VARCHAR2,
333 X_PERCENTAGE_OWNERSHIP IN NUMBER,
334 X_ACTUAL_CONTENT_SOURCE IN VARCHAR2
335 ) IS
336
337 BEGIN
338
339 UPDATE HZ_RELATIONSHIPS SET
340 RELATIONSHIP_ID = DECODE( X_RELATIONSHIP_ID, NULL, RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, X_RELATIONSHIP_ID ),
341 SUBJECT_ID = DECODE( X_SUBJECT_ID, NULL, SUBJECT_ID, FND_API.G_MISS_NUM, NULL, X_SUBJECT_ID ),
342 SUBJECT_TYPE = DECODE( X_SUBJECT_TYPE, NULL, SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, X_SUBJECT_TYPE ),
343 SUBJECT_TABLE_NAME = DECODE( X_SUBJECT_TABLE_NAME, NULL, SUBJECT_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_SUBJECT_TABLE_NAME ),
344 OBJECT_ID = DECODE( X_OBJECT_ID, NULL, OBJECT_ID, FND_API.G_MISS_NUM, NULL, X_OBJECT_ID ),
348 RELATIONSHIP_CODE = DECODE( X_RELATIONSHIP_CODE, NULL, RELATIONSHIP_CODE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_CODE ),
345 OBJECT_TYPE = DECODE( X_OBJECT_TYPE, NULL, OBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, X_OBJECT_TYPE ),
346 OBJECT_TABLE_NAME = DECODE( X_OBJECT_TABLE_NAME, NULL, OBJECT_TABLE_NAME, FND_API.G_MISS_CHAR, NULL, X_OBJECT_TABLE_NAME ),
347 PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
349 DIRECTIONAL_FLAG = DECODE( X_DIRECTIONAL_FLAG, NULL, DIRECTIONAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_DIRECTIONAL_FLAG ),
350 COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
351 START_DATE = DECODE( TO_CHAR(X_START_DATE,'DD/MM/RRRR'), NULL, START_DATE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), NULL, X_START_DATE ),
352 END_DATE = DECODE( TO_CHAR(X_END_DATE,'DD/MM/RRRR'), NULL, END_DATE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
353 STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
354 CREATED_BY = CREATED_BY,
355 CREATION_DATE = CREATION_DATE,
356 LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357 LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358 LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359 REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360 PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361 PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
362 PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
363 ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
364 ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
365 ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
366 ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
367 ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
368 ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
369 ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
370 ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
371 ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
372 ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
373 ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
374 ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
375 ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
376 ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
377 ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
378 ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
379 ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
380 ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
381 ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
382 ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
383 ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
384 CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
385 RELATIONSHIP_TYPE = DECODE( X_RELATIONSHIP_TYPE, NULL, RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
386 OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
387 CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
388 APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
389 ADDITIONAL_INFORMATION1 = DECODE( X_ADDITIONAL_INFORMATION1, NULL, ADDITIONAL_INFORMATION1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION1 ),
390 ADDITIONAL_INFORMATION2 = DECODE( X_ADDITIONAL_INFORMATION2, NULL, ADDITIONAL_INFORMATION2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION2 ),
391 ADDITIONAL_INFORMATION3 = DECODE( X_ADDITIONAL_INFORMATION3, NULL, ADDITIONAL_INFORMATION3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION3 ),
392 ADDITIONAL_INFORMATION4 = DECODE( X_ADDITIONAL_INFORMATION4, NULL, ADDITIONAL_INFORMATION4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION4 ),
393 ADDITIONAL_INFORMATION5 = DECODE( X_ADDITIONAL_INFORMATION5, NULL, ADDITIONAL_INFORMATION5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION5 ),
394 ADDITIONAL_INFORMATION6 = DECODE( X_ADDITIONAL_INFORMATION6, NULL, ADDITIONAL_INFORMATION6, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION6 ),
395 ADDITIONAL_INFORMATION7 = DECODE( X_ADDITIONAL_INFORMATION7, NULL, ADDITIONAL_INFORMATION7, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION7 ),
396 ADDITIONAL_INFORMATION8 = DECODE( X_ADDITIONAL_INFORMATION8, NULL, ADDITIONAL_INFORMATION8, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION8 ),
397 ADDITIONAL_INFORMATION9 = DECODE( X_ADDITIONAL_INFORMATION9, NULL, ADDITIONAL_INFORMATION9, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION9 ),
398 ADDITIONAL_INFORMATION10 = DECODE( X_ADDITIONAL_INFORMATION10, NULL, ADDITIONAL_INFORMATION10, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION10 ),
399 ADDITIONAL_INFORMATION11 = DECODE( X_ADDITIONAL_INFORMATION11, NULL, ADDITIONAL_INFORMATION11, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION11 ),
400 ADDITIONAL_INFORMATION12 = DECODE( X_ADDITIONAL_INFORMATION12, NULL, ADDITIONAL_INFORMATION12, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION12 ),
404 ADDITIONAL_INFORMATION16 = DECODE( X_ADDITIONAL_INFORMATION16, NULL, ADDITIONAL_INFORMATION16, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION16 ),
401 ADDITIONAL_INFORMATION13 = DECODE( X_ADDITIONAL_INFORMATION13, NULL, ADDITIONAL_INFORMATION13, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION13 ),
402 ADDITIONAL_INFORMATION14 = DECODE( X_ADDITIONAL_INFORMATION14, NULL, ADDITIONAL_INFORMATION14, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION14 ),
403 ADDITIONAL_INFORMATION15 = DECODE( X_ADDITIONAL_INFORMATION15, NULL, ADDITIONAL_INFORMATION15, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION15 ),
405 ADDITIONAL_INFORMATION17 = DECODE( X_ADDITIONAL_INFORMATION17, NULL, ADDITIONAL_INFORMATION17, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION17 ),
406 ADDITIONAL_INFORMATION18 = DECODE( X_ADDITIONAL_INFORMATION18, NULL, ADDITIONAL_INFORMATION18, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION18 ),
407 ADDITIONAL_INFORMATION19 = DECODE( X_ADDITIONAL_INFORMATION19, NULL, ADDITIONAL_INFORMATION19, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION19 ),
408 ADDITIONAL_INFORMATION20 = DECODE( X_ADDITIONAL_INFORMATION20, NULL, ADDITIONAL_INFORMATION20, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION20 ),
409 ADDITIONAL_INFORMATION21 = DECODE( X_ADDITIONAL_INFORMATION21, NULL, ADDITIONAL_INFORMATION21, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION21 ),
410 ADDITIONAL_INFORMATION22 = DECODE( X_ADDITIONAL_INFORMATION22, NULL, ADDITIONAL_INFORMATION22, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION22 ),
411 ADDITIONAL_INFORMATION23 = DECODE( X_ADDITIONAL_INFORMATION23, NULL, ADDITIONAL_INFORMATION23, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION23 ),
412 ADDITIONAL_INFORMATION24 = DECODE( X_ADDITIONAL_INFORMATION24, NULL, ADDITIONAL_INFORMATION24, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION24 ),
413 ADDITIONAL_INFORMATION25 = DECODE( X_ADDITIONAL_INFORMATION25, NULL, ADDITIONAL_INFORMATION25, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION25 ),
414 ADDITIONAL_INFORMATION26 = DECODE( X_ADDITIONAL_INFORMATION26, NULL, ADDITIONAL_INFORMATION26, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION26 ),
415 ADDITIONAL_INFORMATION27 = DECODE( X_ADDITIONAL_INFORMATION27, NULL, ADDITIONAL_INFORMATION27, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION27 ),
416 ADDITIONAL_INFORMATION28 = DECODE( X_ADDITIONAL_INFORMATION28, NULL, ADDITIONAL_INFORMATION28, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION28 ),
417 ADDITIONAL_INFORMATION29 = DECODE( X_ADDITIONAL_INFORMATION29, NULL, ADDITIONAL_INFORMATION29, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION29 ),
418 ADDITIONAL_INFORMATION30 = DECODE( X_ADDITIONAL_INFORMATION30, NULL, ADDITIONAL_INFORMATION30, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_INFORMATION30 ),
419 DIRECTION_CODE = DECODE( X_DIRECTION_CODE, NULL, DIRECTION_CODE, FND_API.G_MISS_CHAR, NULL, X_DIRECTION_CODE ),
420 PERCENTAGE_OWNERSHIP = DECODE( X_PERCENTAGE_OWNERSHIP, NULL, PERCENTAGE_OWNERSHIP, FND_API.G_MISS_NUM, NULL, X_PERCENTAGE_OWNERSHIP )/*,
421
422 ** SSM SST Integration and Extension
423 ** actual_content_source will not be updateable for non-SSM enabled entities.
424
425 ACTUAL_CONTENT_SOURCE = DECODE( X_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE)*/
426 WHERE ROWID = X_RowId;
427
428 IF ( SQL%NOTFOUND ) THEN
429 RAISE NO_DATA_FOUND;
430 END IF;
431
432 END Update_Row;
433
434 PROCEDURE Lock_Row (
435 X_Rowid IN OUT NOCOPY VARCHAR2,
436 X_RELATIONSHIP_ID IN NUMBER,
437 X_SUBJECT_ID IN NUMBER,
438 X_SUBJECT_TYPE IN VARCHAR2,
439 X_SUBJECT_TABLE_NAME IN VARCHAR2,
440 X_OBJECT_ID IN NUMBER,
441 X_OBJECT_TYPE IN VARCHAR2,
442 X_OBJECT_TABLE_NAME IN VARCHAR2,
443 X_PARTY_ID IN NUMBER,
444 X_RELATIONSHIP_CODE IN VARCHAR2,
445 X_DIRECTIONAL_FLAG IN VARCHAR2,
446 X_COMMENTS IN VARCHAR2,
447 X_START_DATE IN DATE,
448 X_END_DATE IN DATE,
449 X_STATUS IN VARCHAR2,
450 X_CREATED_BY IN NUMBER,
451 X_CREATION_DATE IN DATE,
452 X_LAST_UPDATED_BY IN NUMBER,
453 X_LAST_UPDATE_DATE IN DATE,
454 X_LAST_UPDATE_LOGIN IN NUMBER,
455 X_REQUEST_ID IN NUMBER,
456 X_PROGRAM_APPLICATION_ID IN NUMBER,
457 X_PROGRAM_ID IN NUMBER,
458 X_PROGRAM_UPDATE_DATE IN DATE,
459 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
460 X_ATTRIBUTE1 IN VARCHAR2,
461 X_ATTRIBUTE2 IN VARCHAR2,
462 X_ATTRIBUTE3 IN VARCHAR2,
463 X_ATTRIBUTE4 IN VARCHAR2,
464 X_ATTRIBUTE5 IN VARCHAR2,
465 X_ATTRIBUTE6 IN VARCHAR2,
466 X_ATTRIBUTE7 IN VARCHAR2,
467 X_ATTRIBUTE8 IN VARCHAR2,
468 X_ATTRIBUTE9 IN VARCHAR2,
469 X_ATTRIBUTE10 IN VARCHAR2,
470 X_ATTRIBUTE11 IN VARCHAR2,
471 X_ATTRIBUTE12 IN VARCHAR2,
472 X_ATTRIBUTE13 IN VARCHAR2,
473 X_ATTRIBUTE14 IN VARCHAR2,
474 X_ATTRIBUTE15 IN VARCHAR2,
475 X_ATTRIBUTE16 IN VARCHAR2,
476 X_ATTRIBUTE17 IN VARCHAR2,
480 X_CONTENT_SOURCE_TYPE IN VARCHAR2,
477 X_ATTRIBUTE18 IN VARCHAR2,
478 X_ATTRIBUTE19 IN VARCHAR2,
479 X_ATTRIBUTE20 IN VARCHAR2,
481 X_RELATIONSHIP_TYPE IN VARCHAR2,
482 X_OBJECT_VERSION_NUMBER IN NUMBER,
483 X_CREATED_BY_MODULE IN VARCHAR2,
484 X_APPLICATION_ID IN NUMBER,
485 X_ADDITIONAL_INFORMATION1 IN VARCHAR2,
486 X_ADDITIONAL_INFORMATION2 IN VARCHAR2,
487 X_ADDITIONAL_INFORMATION3 IN VARCHAR2,
488 X_ADDITIONAL_INFORMATION4 IN VARCHAR2,
489 X_ADDITIONAL_INFORMATION5 IN VARCHAR2,
490 X_ADDITIONAL_INFORMATION6 IN VARCHAR2,
491 X_ADDITIONAL_INFORMATION7 IN VARCHAR2,
492 X_ADDITIONAL_INFORMATION8 IN VARCHAR2,
493 X_ADDITIONAL_INFORMATION9 IN VARCHAR2,
494 X_ADDITIONAL_INFORMATION10 IN VARCHAR2,
495 X_ADDITIONAL_INFORMATION11 IN VARCHAR2,
496 X_ADDITIONAL_INFORMATION12 IN VARCHAR2,
497 X_ADDITIONAL_INFORMATION13 IN VARCHAR2,
498 X_ADDITIONAL_INFORMATION14 IN VARCHAR2,
499 X_ADDITIONAL_INFORMATION15 IN VARCHAR2,
500 X_ADDITIONAL_INFORMATION16 IN VARCHAR2,
501 X_ADDITIONAL_INFORMATION17 IN VARCHAR2,
502 X_ADDITIONAL_INFORMATION18 IN VARCHAR2,
503 X_ADDITIONAL_INFORMATION19 IN VARCHAR2,
504 X_ADDITIONAL_INFORMATION20 IN VARCHAR2,
505 X_ADDITIONAL_INFORMATION21 IN VARCHAR2,
506 X_ADDITIONAL_INFORMATION22 IN VARCHAR2,
507 X_ADDITIONAL_INFORMATION23 IN VARCHAR2,
508 X_ADDITIONAL_INFORMATION24 IN VARCHAR2,
509 X_ADDITIONAL_INFORMATION25 IN VARCHAR2,
510 X_ADDITIONAL_INFORMATION26 IN VARCHAR2,
511 X_ADDITIONAL_INFORMATION27 IN VARCHAR2,
512 X_ADDITIONAL_INFORMATION28 IN VARCHAR2,
513 X_ADDITIONAL_INFORMATION29 IN VARCHAR2,
514 X_ADDITIONAL_INFORMATION30 IN VARCHAR2,
515 X_DIRECTION_CODE IN VARCHAR2,
516 X_PERCENTAGE_OWNERSHIP IN NUMBER,
517 X_ACTUAL_CONTENT_SOURCE IN VARCHAR2
518 ) IS
519
520 CURSOR C IS
521 SELECT * FROM HZ_RELATIONSHIPS
522 WHERE ROWID = x_Rowid
523 FOR UPDATE NOWAIT;
524 Recinfo C%ROWTYPE;
525
526 BEGIN
527
528 OPEN C;
529 FETCH C INTO Recinfo;
530 IF ( C%NOTFOUND ) THEN
531 CLOSE C;
532 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
533 APP_EXCEPTION.RAISE_EXCEPTION;
534 END IF;
535 CLOSE C;
536
537 IF (
538 ( ( Recinfo.RELATIONSHIP_ID = X_RELATIONSHIP_ID )
539 OR ( ( Recinfo.RELATIONSHIP_ID IS NULL )
540 AND ( X_RELATIONSHIP_ID IS NULL ) ) )
541 AND ( ( Recinfo.SUBJECT_ID = X_SUBJECT_ID )
542 OR ( ( Recinfo.SUBJECT_ID IS NULL )
543 AND ( X_SUBJECT_ID IS NULL ) ) )
544 AND ( ( Recinfo.SUBJECT_TYPE = X_SUBJECT_TYPE )
545 OR ( ( Recinfo.SUBJECT_TYPE IS NULL )
546 AND ( X_SUBJECT_TYPE IS NULL ) ) )
547 AND ( ( Recinfo.SUBJECT_TABLE_NAME = X_SUBJECT_TABLE_NAME )
548 OR ( ( Recinfo.SUBJECT_TABLE_NAME IS NULL )
549 AND ( X_SUBJECT_TABLE_NAME IS NULL ) ) )
550 AND ( ( Recinfo.OBJECT_ID = X_OBJECT_ID )
551 OR ( ( Recinfo.OBJECT_ID IS NULL )
552 AND ( X_OBJECT_ID IS NULL ) ) )
553 AND ( ( Recinfo.OBJECT_TYPE = X_OBJECT_TYPE )
554 OR ( ( Recinfo.OBJECT_TYPE IS NULL )
555 AND ( X_OBJECT_TYPE IS NULL ) ) )
556 AND ( ( Recinfo.OBJECT_TABLE_NAME = X_OBJECT_TABLE_NAME )
557 OR ( ( Recinfo.OBJECT_TABLE_NAME IS NULL )
558 AND ( X_OBJECT_TABLE_NAME IS NULL ) ) )
559 AND ( ( Recinfo.PARTY_ID = X_PARTY_ID )
560 OR ( ( Recinfo.PARTY_ID IS NULL )
561 AND ( X_PARTY_ID IS NULL ) ) )
562 AND ( ( Recinfo.RELATIONSHIP_CODE = X_RELATIONSHIP_CODE )
563 OR ( ( Recinfo.RELATIONSHIP_CODE IS NULL )
564 AND ( X_RELATIONSHIP_CODE IS NULL ) ) )
565 AND ( ( Recinfo.DIRECTIONAL_FLAG = X_DIRECTIONAL_FLAG )
566 OR ( ( Recinfo.DIRECTIONAL_FLAG IS NULL )
567 AND ( X_DIRECTIONAL_FLAG IS NULL ) ) )
568 AND ( ( Recinfo.COMMENTS = X_COMMENTS )
569 OR ( ( Recinfo.COMMENTS IS NULL )
570 AND ( X_COMMENTS IS NULL ) ) )
571 AND ( ( Recinfo.START_DATE = X_START_DATE )
572 OR ( ( Recinfo.START_DATE IS NULL )
573 AND ( X_START_DATE IS NULL ) ) )
574 AND ( ( Recinfo.END_DATE = X_END_DATE )
575 OR ( ( Recinfo.END_DATE IS NULL )
576 AND ( X_END_DATE IS NULL ) ) )
577 AND ( ( Recinfo.STATUS = X_STATUS )
578 OR ( ( Recinfo.STATUS IS NULL )
579 AND ( X_STATUS IS NULL ) ) )
580 AND ( ( Recinfo.CREATED_BY = X_CREATED_BY )
581 OR ( ( Recinfo.CREATED_BY IS NULL )
582 AND ( X_CREATED_BY IS NULL ) ) )
583 AND ( ( Recinfo.CREATION_DATE = X_CREATION_DATE )
584 OR ( ( Recinfo.CREATION_DATE IS NULL )
585 AND ( X_CREATION_DATE IS NULL ) ) )
586 AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY )
587 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
588 AND ( X_LAST_UPDATED_BY IS NULL ) ) )
589 AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE )
590 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
591 AND ( X_LAST_UPDATE_DATE IS NULL ) ) )
595 AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
592 AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN )
593 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
594 AND ( X_LAST_UPDATE_LOGIN IS NULL ) ) )
596 OR ( ( Recinfo.REQUEST_ID IS NULL )
597 AND ( X_REQUEST_ID IS NULL ) ) )
598 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID )
599 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
600 AND ( X_PROGRAM_APPLICATION_ID IS NULL ) ) )
601 AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID )
602 OR ( ( Recinfo.PROGRAM_ID IS NULL )
603 AND ( X_PROGRAM_ID IS NULL ) ) )
604 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE )
605 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
606 AND ( X_PROGRAM_UPDATE_DATE IS NULL ) ) )
607 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY )
608 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
609 AND ( X_ATTRIBUTE_CATEGORY IS NULL ) ) )
610 AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
611 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
612 AND ( X_ATTRIBUTE1 IS NULL ) ) )
613 AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
614 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
615 AND ( X_ATTRIBUTE2 IS NULL ) ) )
616 AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
617 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
618 AND ( X_ATTRIBUTE3 IS NULL ) ) )
619 AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
620 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
621 AND ( X_ATTRIBUTE4 IS NULL ) ) )
622 AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
623 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
624 AND ( X_ATTRIBUTE5 IS NULL ) ) )
625 AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
626 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
627 AND ( X_ATTRIBUTE6 IS NULL ) ) )
628 AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
629 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
630 AND ( X_ATTRIBUTE7 IS NULL ) ) )
631 AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
632 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
633 AND ( X_ATTRIBUTE8 IS NULL ) ) )
634 AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
635 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
636 AND ( X_ATTRIBUTE9 IS NULL ) ) )
637 AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
638 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
639 AND ( X_ATTRIBUTE10 IS NULL ) ) )
640 AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
641 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
642 AND ( X_ATTRIBUTE11 IS NULL ) ) )
643 AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
644 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
645 AND ( X_ATTRIBUTE12 IS NULL ) ) )
646 AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
647 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
648 AND ( X_ATTRIBUTE13 IS NULL ) ) )
649 AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
650 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
651 AND ( X_ATTRIBUTE14 IS NULL ) ) )
652 AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
653 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
654 AND ( X_ATTRIBUTE15 IS NULL ) ) )
655 AND ( ( Recinfo.ATTRIBUTE16 = X_ATTRIBUTE16 )
656 OR ( ( Recinfo.ATTRIBUTE16 IS NULL )
657 AND ( X_ATTRIBUTE16 IS NULL ) ) )
658 AND ( ( Recinfo.ATTRIBUTE17 = X_ATTRIBUTE17 )
659 OR ( ( Recinfo.ATTRIBUTE17 IS NULL )
660 AND ( X_ATTRIBUTE17 IS NULL ) ) )
661 AND ( ( Recinfo.ATTRIBUTE18 = X_ATTRIBUTE18 )
662 OR ( ( Recinfo.ATTRIBUTE18 IS NULL )
663 AND ( X_ATTRIBUTE18 IS NULL ) ) )
664 AND ( ( Recinfo.ATTRIBUTE19 = X_ATTRIBUTE19 )
665 OR ( ( Recinfo.ATTRIBUTE19 IS NULL )
666 AND ( X_ATTRIBUTE19 IS NULL ) ) )
667 AND ( ( Recinfo.ATTRIBUTE20 = X_ATTRIBUTE20 )
668 OR ( ( Recinfo.ATTRIBUTE20 IS NULL )
669 AND ( X_ATTRIBUTE20 IS NULL ) ) )
670 AND ( ( Recinfo.CONTENT_SOURCE_TYPE = X_CONTENT_SOURCE_TYPE )
671 OR ( ( Recinfo.CONTENT_SOURCE_TYPE IS NULL )
672 AND ( X_CONTENT_SOURCE_TYPE IS NULL ) ) )
673 AND ( ( Recinfo.RELATIONSHIP_TYPE = X_RELATIONSHIP_TYPE )
674 OR ( ( Recinfo.RELATIONSHIP_TYPE IS NULL )
675 AND ( X_RELATIONSHIP_TYPE IS NULL ) ) )
676 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER )
677 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
678 AND ( X_OBJECT_VERSION_NUMBER IS NULL ) ) )
679 AND ( ( Recinfo.CREATED_BY_MODULE = X_CREATED_BY_MODULE )
680 OR ( ( Recinfo.CREATED_BY_MODULE IS NULL )
681 AND ( X_CREATED_BY_MODULE IS NULL ) ) )
682 AND ( ( Recinfo.APPLICATION_ID = X_APPLICATION_ID )
683 OR ( ( Recinfo.APPLICATION_ID IS NULL )
684 AND ( X_APPLICATION_ID IS NULL ) ) )
685 AND ( ( Recinfo.ADDITIONAL_INFORMATION1 = X_ADDITIONAL_INFORMATION1 )
686 OR ( ( Recinfo.ADDITIONAL_INFORMATION1 IS NULL )
687 AND ( X_ADDITIONAL_INFORMATION1 IS NULL ) ) )
688 AND ( ( Recinfo.ADDITIONAL_INFORMATION2 = X_ADDITIONAL_INFORMATION2 )
689 OR ( ( Recinfo.ADDITIONAL_INFORMATION2 IS NULL )
690 AND ( X_ADDITIONAL_INFORMATION2 IS NULL ) ) )
691 AND ( ( Recinfo.ADDITIONAL_INFORMATION3 = X_ADDITIONAL_INFORMATION3 )
692 OR ( ( Recinfo.ADDITIONAL_INFORMATION3 IS NULL )
693 AND ( X_ADDITIONAL_INFORMATION3 IS NULL ) ) )
694 AND ( ( Recinfo.ADDITIONAL_INFORMATION4 = X_ADDITIONAL_INFORMATION4 )
695 OR ( ( Recinfo.ADDITIONAL_INFORMATION4 IS NULL )
696 AND ( X_ADDITIONAL_INFORMATION4 IS NULL ) ) )
697 AND ( ( Recinfo.ADDITIONAL_INFORMATION5 = X_ADDITIONAL_INFORMATION5 )
698 OR ( ( Recinfo.ADDITIONAL_INFORMATION5 IS NULL )
699 AND ( X_ADDITIONAL_INFORMATION5 IS NULL ) ) )
700 AND ( ( Recinfo.ADDITIONAL_INFORMATION6 = X_ADDITIONAL_INFORMATION6 )
704 OR ( ( Recinfo.ADDITIONAL_INFORMATION7 IS NULL )
701 OR ( ( Recinfo.ADDITIONAL_INFORMATION6 IS NULL )
702 AND ( X_ADDITIONAL_INFORMATION6 IS NULL ) ) )
703 AND ( ( Recinfo.ADDITIONAL_INFORMATION7 = X_ADDITIONAL_INFORMATION7 )
705 AND ( X_ADDITIONAL_INFORMATION7 IS NULL ) ) )
706 AND ( ( Recinfo.ADDITIONAL_INFORMATION8 = X_ADDITIONAL_INFORMATION8 )
707 OR ( ( Recinfo.ADDITIONAL_INFORMATION8 IS NULL )
708 AND ( X_ADDITIONAL_INFORMATION8 IS NULL ) ) )
709 AND ( ( Recinfo.ADDITIONAL_INFORMATION9 = X_ADDITIONAL_INFORMATION9 )
710 OR ( ( Recinfo.ADDITIONAL_INFORMATION9 IS NULL )
711 AND ( X_ADDITIONAL_INFORMATION9 IS NULL ) ) )
712 AND ( ( Recinfo.ADDITIONAL_INFORMATION10 = X_ADDITIONAL_INFORMATION10 )
713 OR ( ( Recinfo.ADDITIONAL_INFORMATION10 IS NULL )
714 AND ( X_ADDITIONAL_INFORMATION10 IS NULL ) ) )
715 AND ( ( Recinfo.ADDITIONAL_INFORMATION11 = X_ADDITIONAL_INFORMATION11 )
716 OR ( ( Recinfo.ADDITIONAL_INFORMATION11 IS NULL )
717 AND ( X_ADDITIONAL_INFORMATION11 IS NULL ) ) )
718 AND ( ( Recinfo.ADDITIONAL_INFORMATION12 = X_ADDITIONAL_INFORMATION12 )
719 OR ( ( Recinfo.ADDITIONAL_INFORMATION12 IS NULL )
720 AND ( X_ADDITIONAL_INFORMATION12 IS NULL ) ) )
721 AND ( ( Recinfo.ADDITIONAL_INFORMATION13 = X_ADDITIONAL_INFORMATION13 )
722 OR ( ( Recinfo.ADDITIONAL_INFORMATION13 IS NULL )
723 AND ( X_ADDITIONAL_INFORMATION13 IS NULL ) ) )
724 AND ( ( Recinfo.ADDITIONAL_INFORMATION14 = X_ADDITIONAL_INFORMATION14 )
725 OR ( ( Recinfo.ADDITIONAL_INFORMATION14 IS NULL )
726 AND ( X_ADDITIONAL_INFORMATION14 IS NULL ) ) )
727 AND ( ( Recinfo.ADDITIONAL_INFORMATION15 = X_ADDITIONAL_INFORMATION15 )
728 OR ( ( Recinfo.ADDITIONAL_INFORMATION15 IS NULL )
729 AND ( X_ADDITIONAL_INFORMATION15 IS NULL ) ) )
730 AND ( ( Recinfo.ADDITIONAL_INFORMATION16 = X_ADDITIONAL_INFORMATION16 )
731 OR ( ( Recinfo.ADDITIONAL_INFORMATION16 IS NULL )
732 AND ( X_ADDITIONAL_INFORMATION16 IS NULL ) ) )
733 AND ( ( Recinfo.ADDITIONAL_INFORMATION17 = X_ADDITIONAL_INFORMATION17 )
734 OR ( ( Recinfo.ADDITIONAL_INFORMATION17 IS NULL )
735 AND ( X_ADDITIONAL_INFORMATION17 IS NULL ) ) )
736 AND ( ( Recinfo.ADDITIONAL_INFORMATION18 = X_ADDITIONAL_INFORMATION18 )
737 OR ( ( Recinfo.ADDITIONAL_INFORMATION18 IS NULL )
738 AND ( X_ADDITIONAL_INFORMATION18 IS NULL ) ) )
739 AND ( ( Recinfo.ADDITIONAL_INFORMATION19 = X_ADDITIONAL_INFORMATION19 )
740 OR ( ( Recinfo.ADDITIONAL_INFORMATION19 IS NULL )
741 AND ( X_ADDITIONAL_INFORMATION19 IS NULL ) ) )
742 AND ( ( Recinfo.ADDITIONAL_INFORMATION20 = X_ADDITIONAL_INFORMATION20 )
743 OR ( ( Recinfo.ADDITIONAL_INFORMATION20 IS NULL )
744 AND ( X_ADDITIONAL_INFORMATION20 IS NULL ) ) )
745 AND ( ( Recinfo.ADDITIONAL_INFORMATION21 = X_ADDITIONAL_INFORMATION21 )
746 OR ( ( Recinfo.ADDITIONAL_INFORMATION21 IS NULL )
747 AND ( X_ADDITIONAL_INFORMATION21 IS NULL ) ) )
748 AND ( ( Recinfo.ADDITIONAL_INFORMATION22 = X_ADDITIONAL_INFORMATION22 )
749 OR ( ( Recinfo.ADDITIONAL_INFORMATION22 IS NULL )
750 AND ( X_ADDITIONAL_INFORMATION22 IS NULL ) ) )
751 AND ( ( Recinfo.ADDITIONAL_INFORMATION23 = X_ADDITIONAL_INFORMATION23 )
752 OR ( ( Recinfo.ADDITIONAL_INFORMATION23 IS NULL )
753 AND ( X_ADDITIONAL_INFORMATION23 IS NULL ) ) )
754 AND ( ( Recinfo.ADDITIONAL_INFORMATION24 = X_ADDITIONAL_INFORMATION24 )
755 OR ( ( Recinfo.ADDITIONAL_INFORMATION24 IS NULL )
756 AND ( X_ADDITIONAL_INFORMATION24 IS NULL ) ) )
757 AND ( ( Recinfo.ADDITIONAL_INFORMATION25 = X_ADDITIONAL_INFORMATION25 )
758 OR ( ( Recinfo.ADDITIONAL_INFORMATION25 IS NULL )
759 AND ( X_ADDITIONAL_INFORMATION25 IS NULL ) ) )
760 AND ( ( Recinfo.ADDITIONAL_INFORMATION26 = X_ADDITIONAL_INFORMATION26 )
761 OR ( ( Recinfo.ADDITIONAL_INFORMATION26 IS NULL )
762 AND ( X_ADDITIONAL_INFORMATION26 IS NULL ) ) )
763 AND ( ( Recinfo.ADDITIONAL_INFORMATION27 = X_ADDITIONAL_INFORMATION27 )
764 OR ( ( Recinfo.ADDITIONAL_INFORMATION27 IS NULL )
765 AND ( X_ADDITIONAL_INFORMATION27 IS NULL ) ) )
766 AND ( ( Recinfo.ADDITIONAL_INFORMATION28 = X_ADDITIONAL_INFORMATION28 )
767 OR ( ( Recinfo.ADDITIONAL_INFORMATION28 IS NULL )
768 AND ( X_ADDITIONAL_INFORMATION28 IS NULL ) ) )
769 AND ( ( Recinfo.ADDITIONAL_INFORMATION29 = X_ADDITIONAL_INFORMATION29 )
770 OR ( ( Recinfo.ADDITIONAL_INFORMATION29 IS NULL )
771 AND ( X_ADDITIONAL_INFORMATION29 IS NULL ) ) )
772 AND ( ( Recinfo.ADDITIONAL_INFORMATION30 = X_ADDITIONAL_INFORMATION30 )
773 OR ( ( Recinfo.ADDITIONAL_INFORMATION30 IS NULL )
774 AND ( X_ADDITIONAL_INFORMATION30 IS NULL ) ) )
775 AND ( ( Recinfo.DIRECTION_CODE = X_DIRECTION_CODE )
776 OR ( ( Recinfo.DIRECTION_CODE IS NULL )
777 AND ( X_DIRECTION_CODE IS NULL ) ) )
778 AND ( ( Recinfo.PERCENTAGE_OWNERSHIP = X_PERCENTAGE_OWNERSHIP )
779 OR ( ( Recinfo.PERCENTAGE_OWNERSHIP IS NULL )
780 AND ( X_PERCENTAGE_OWNERSHIP IS NULL ) ) )
781 AND ( ( Recinfo.ACTUAL_CONTENT_SOURCE = X_ACTUAL_CONTENT_SOURCE )
782 OR ( ( Recinfo.ACTUAL_CONTENT_SOURCE IS NULL )
783 AND ( X_ACTUAL_CONTENT_SOURCE IS NULL ) ) )
784 ) THEN
785 RETURN;
786 ELSE
787 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
788 APP_EXCEPTION.RAISE_EXCEPTION;
789 END IF;
790
791 END Lock_Row;
792
793 PROCEDURE Select_Row (
794 X_RELATIONSHIP_ID IN OUT NOCOPY NUMBER,
795 X_DIRECTIONAL_FLAG IN OUT NOCOPY VARCHAR2,
796 X_SUBJECT_ID OUT NOCOPY NUMBER,
797 X_SUBJECT_TYPE OUT NOCOPY VARCHAR2,
798 X_SUBJECT_TABLE_NAME OUT NOCOPY VARCHAR2,
802 X_PARTY_ID OUT NOCOPY NUMBER,
799 X_OBJECT_ID OUT NOCOPY NUMBER,
800 X_OBJECT_TYPE OUT NOCOPY VARCHAR2,
801 X_OBJECT_TABLE_NAME OUT NOCOPY VARCHAR2,
803 X_RELATIONSHIP_CODE OUT NOCOPY VARCHAR2,
804 X_COMMENTS OUT NOCOPY VARCHAR2,
805 X_START_DATE OUT NOCOPY DATE,
806 X_END_DATE OUT NOCOPY DATE,
807 X_STATUS OUT NOCOPY VARCHAR2,
808 X_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
809 X_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
810 X_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
811 X_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
812 X_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
813 X_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
814 X_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
815 X_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
816 X_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
817 X_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
818 X_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
819 X_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
820 X_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
821 X_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
822 X_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
823 X_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
824 X_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
825 X_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
826 X_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
827 X_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
828 X_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
829 X_CONTENT_SOURCE_TYPE OUT NOCOPY VARCHAR2,
830 X_RELATIONSHIP_TYPE OUT NOCOPY VARCHAR2,
831 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
832 X_APPLICATION_ID OUT NOCOPY NUMBER,
833 X_ADDITIONAL_INFORMATION1 OUT NOCOPY VARCHAR2,
834 X_ADDITIONAL_INFORMATION2 OUT NOCOPY VARCHAR2,
835 X_ADDITIONAL_INFORMATION3 OUT NOCOPY VARCHAR2,
836 X_ADDITIONAL_INFORMATION4 OUT NOCOPY VARCHAR2,
837 X_ADDITIONAL_INFORMATION5 OUT NOCOPY VARCHAR2,
838 X_ADDITIONAL_INFORMATION6 OUT NOCOPY VARCHAR2,
839 X_ADDITIONAL_INFORMATION7 OUT NOCOPY VARCHAR2,
840 X_ADDITIONAL_INFORMATION8 OUT NOCOPY VARCHAR2,
841 X_ADDITIONAL_INFORMATION9 OUT NOCOPY VARCHAR2,
842 X_ADDITIONAL_INFORMATION10 OUT NOCOPY VARCHAR2,
843 X_ADDITIONAL_INFORMATION11 OUT NOCOPY VARCHAR2,
844 X_ADDITIONAL_INFORMATION12 OUT NOCOPY VARCHAR2,
845 X_ADDITIONAL_INFORMATION13 OUT NOCOPY VARCHAR2,
846 X_ADDITIONAL_INFORMATION14 OUT NOCOPY VARCHAR2,
847 X_ADDITIONAL_INFORMATION15 OUT NOCOPY VARCHAR2,
848 X_ADDITIONAL_INFORMATION16 OUT NOCOPY VARCHAR2,
849 X_ADDITIONAL_INFORMATION17 OUT NOCOPY VARCHAR2,
850 X_ADDITIONAL_INFORMATION18 OUT NOCOPY VARCHAR2,
851 X_ADDITIONAL_INFORMATION19 OUT NOCOPY VARCHAR2,
852 X_ADDITIONAL_INFORMATION20 OUT NOCOPY VARCHAR2,
853 X_ADDITIONAL_INFORMATION21 OUT NOCOPY VARCHAR2,
854 X_ADDITIONAL_INFORMATION22 OUT NOCOPY VARCHAR2,
855 X_ADDITIONAL_INFORMATION23 OUT NOCOPY VARCHAR2,
856 X_ADDITIONAL_INFORMATION24 OUT NOCOPY VARCHAR2,
857 X_ADDITIONAL_INFORMATION25 OUT NOCOPY VARCHAR2,
858 X_ADDITIONAL_INFORMATION26 OUT NOCOPY VARCHAR2,
859 X_ADDITIONAL_INFORMATION27 OUT NOCOPY VARCHAR2,
860 X_ADDITIONAL_INFORMATION28 OUT NOCOPY VARCHAR2,
861 X_ADDITIONAL_INFORMATION29 OUT NOCOPY VARCHAR2,
862 X_ADDITIONAL_INFORMATION30 OUT NOCOPY VARCHAR2,
863 X_DIRECTION_CODE OUT NOCOPY VARCHAR2,
864 X_PERCENTAGE_OWNERSHIP OUT NOCOPY NUMBER,
865 X_ACTUAL_CONTENT_SOURCE OUT NOCOPY VARCHAR2
866 ) IS
867
868 BEGIN
869
870 SELECT
871 NVL( RELATIONSHIP_ID, FND_API.G_MISS_NUM ),
872 NVL( SUBJECT_ID, FND_API.G_MISS_NUM ),
873 NVL( SUBJECT_TYPE, FND_API.G_MISS_CHAR ),
874 NVL( SUBJECT_TABLE_NAME, FND_API.G_MISS_CHAR ),
875 NVL( OBJECT_ID, FND_API.G_MISS_NUM ),
876 NVL( OBJECT_TYPE, FND_API.G_MISS_CHAR ),
877 NVL( OBJECT_TABLE_NAME, FND_API.G_MISS_CHAR ),
878 NVL( PARTY_ID, FND_API.G_MISS_NUM ),
879 NVL( RELATIONSHIP_CODE, FND_API.G_MISS_CHAR ),
880 NVL( DIRECTIONAL_FLAG, FND_API.G_MISS_CHAR ),
881 NVL( COMMENTS, FND_API.G_MISS_CHAR ),
882 NVL( START_DATE, FND_API.G_MISS_DATE ),
883 NVL( END_DATE, FND_API.G_MISS_DATE ),
884 NVL( STATUS, FND_API.G_MISS_CHAR ),
885 NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
886 NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
887 NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
888 NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
889 NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
890 NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
891 NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
892 NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
893 NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
894 NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
895 NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
899 NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
896 NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
897 NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
898 NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
900 NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
901 NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
902 NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
903 NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
904 NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
905 NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
906 NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
907 NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
908 NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
909 NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
910 NVL( ADDITIONAL_INFORMATION1, FND_API.G_MISS_CHAR ),
911 NVL( ADDITIONAL_INFORMATION2, FND_API.G_MISS_CHAR ),
912 NVL( ADDITIONAL_INFORMATION3, FND_API.G_MISS_CHAR ),
913 NVL( ADDITIONAL_INFORMATION4, FND_API.G_MISS_CHAR ),
914 NVL( ADDITIONAL_INFORMATION5, FND_API.G_MISS_CHAR ),
915 NVL( ADDITIONAL_INFORMATION6, FND_API.G_MISS_CHAR ),
916 NVL( ADDITIONAL_INFORMATION7, FND_API.G_MISS_CHAR ),
917 NVL( ADDITIONAL_INFORMATION8, FND_API.G_MISS_CHAR ),
918 NVL( ADDITIONAL_INFORMATION9, FND_API.G_MISS_CHAR ),
919 NVL( ADDITIONAL_INFORMATION10, FND_API.G_MISS_CHAR ),
920 NVL( ADDITIONAL_INFORMATION11, FND_API.G_MISS_CHAR ),
921 NVL( ADDITIONAL_INFORMATION12, FND_API.G_MISS_CHAR ),
922 NVL( ADDITIONAL_INFORMATION13, FND_API.G_MISS_CHAR ),
923 NVL( ADDITIONAL_INFORMATION14, FND_API.G_MISS_CHAR ),
924 NVL( ADDITIONAL_INFORMATION15, FND_API.G_MISS_CHAR ),
925 NVL( ADDITIONAL_INFORMATION16, FND_API.G_MISS_CHAR ),
926 NVL( ADDITIONAL_INFORMATION17, FND_API.G_MISS_CHAR ),
927 NVL( ADDITIONAL_INFORMATION18, FND_API.G_MISS_CHAR ),
928 NVL( ADDITIONAL_INFORMATION19, FND_API.G_MISS_CHAR ),
929 NVL( ADDITIONAL_INFORMATION20, FND_API.G_MISS_CHAR ),
930 NVL( ADDITIONAL_INFORMATION21, FND_API.G_MISS_CHAR ),
931 NVL( ADDITIONAL_INFORMATION22, FND_API.G_MISS_CHAR ),
932 NVL( ADDITIONAL_INFORMATION23, FND_API.G_MISS_CHAR ),
933 NVL( ADDITIONAL_INFORMATION24, FND_API.G_MISS_CHAR ),
934 NVL( ADDITIONAL_INFORMATION25, FND_API.G_MISS_CHAR ),
935 NVL( ADDITIONAL_INFORMATION26, FND_API.G_MISS_CHAR ),
936 NVL( ADDITIONAL_INFORMATION27, FND_API.G_MISS_CHAR ),
937 NVL( ADDITIONAL_INFORMATION28, FND_API.G_MISS_CHAR ),
938 NVL( ADDITIONAL_INFORMATION29, FND_API.G_MISS_CHAR ),
939 NVL( ADDITIONAL_INFORMATION30, FND_API.G_MISS_CHAR ),
940 NVL( DIRECTION_CODE, FND_API.G_MISS_CHAR ),
941 NVL( PERCENTAGE_OWNERSHIP, FND_API.G_MISS_NUM ),
942 NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR )
943 INTO
944 X_RELATIONSHIP_ID,
945 X_SUBJECT_ID,
946 X_SUBJECT_TYPE,
947 X_SUBJECT_TABLE_NAME,
948 X_OBJECT_ID,
949 X_OBJECT_TYPE,
950 X_OBJECT_TABLE_NAME,
951 X_PARTY_ID,
952 X_RELATIONSHIP_CODE,
953 X_DIRECTIONAL_FLAG,
954 X_COMMENTS,
955 X_START_DATE,
956 X_END_DATE,
957 X_STATUS,
958 X_ATTRIBUTE_CATEGORY,
959 X_ATTRIBUTE1,
960 X_ATTRIBUTE2,
961 X_ATTRIBUTE3,
962 X_ATTRIBUTE4,
963 X_ATTRIBUTE5,
964 X_ATTRIBUTE6,
965 X_ATTRIBUTE7,
966 X_ATTRIBUTE8,
967 X_ATTRIBUTE9,
968 X_ATTRIBUTE10,
969 X_ATTRIBUTE11,
970 X_ATTRIBUTE12,
971 X_ATTRIBUTE13,
972 X_ATTRIBUTE14,
973 X_ATTRIBUTE15,
974 X_ATTRIBUTE16,
975 X_ATTRIBUTE17,
976 X_ATTRIBUTE18,
977 X_ATTRIBUTE19,
978 X_ATTRIBUTE20,
979 X_CONTENT_SOURCE_TYPE,
980 X_RELATIONSHIP_TYPE,
981 X_CREATED_BY_MODULE,
982 X_APPLICATION_ID,
983 X_ADDITIONAL_INFORMATION1,
984 X_ADDITIONAL_INFORMATION2,
985 X_ADDITIONAL_INFORMATION3,
986 X_ADDITIONAL_INFORMATION4,
987 X_ADDITIONAL_INFORMATION5,
988 X_ADDITIONAL_INFORMATION6,
989 X_ADDITIONAL_INFORMATION7,
990 X_ADDITIONAL_INFORMATION8,
991 X_ADDITIONAL_INFORMATION9,
992 X_ADDITIONAL_INFORMATION10,
993 X_ADDITIONAL_INFORMATION11,
994 X_ADDITIONAL_INFORMATION12,
995 X_ADDITIONAL_INFORMATION13,
996 X_ADDITIONAL_INFORMATION14,
997 X_ADDITIONAL_INFORMATION15,
998 X_ADDITIONAL_INFORMATION16,
999 X_ADDITIONAL_INFORMATION17,
1000 X_ADDITIONAL_INFORMATION18,
1001 X_ADDITIONAL_INFORMATION19,
1002 X_ADDITIONAL_INFORMATION20,
1003 X_ADDITIONAL_INFORMATION21,
1004 X_ADDITIONAL_INFORMATION22,
1005 X_ADDITIONAL_INFORMATION23,
1006 X_ADDITIONAL_INFORMATION24,
1007 X_ADDITIONAL_INFORMATION25,
1008 X_ADDITIONAL_INFORMATION26,
1009 X_ADDITIONAL_INFORMATION27,
1010 X_ADDITIONAL_INFORMATION28,
1011 X_ADDITIONAL_INFORMATION29,
1012 X_ADDITIONAL_INFORMATION30,
1013 X_DIRECTION_CODE,
1014 X_PERCENTAGE_OWNERSHIP,
1015 X_ACTUAL_CONTENT_SOURCE
1016 FROM HZ_RELATIONSHIPS
1017 WHERE RELATIONSHIP_ID = X_RELATIONSHIP_ID
1018 AND DIRECTIONAL_FLAG = X_DIRECTIONAL_FLAG;
1019
1020 EXCEPTION
1021 WHEN NO_DATA_FOUND THEN
1022 FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1023 FND_MESSAGE.SET_TOKEN( 'RECORD', 'relationship_rec');
1024 FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_RELATIONSHIP_ID ) );
1025 FND_MSG_PUB.ADD;
1026 RAISE FND_API.G_EXC_ERROR;
1027
1028 END Select_Row;
1029
1033
1030 PROCEDURE Delete_Row (
1031 X_RELATIONSHIP_ID IN NUMBER
1032 ) IS
1034 BEGIN
1035
1036 DELETE FROM HZ_RELATIONSHIPS
1037 WHERE RELATIONSHIP_ID = X_RELATIONSHIP_ID;
1038
1039 IF ( SQL%NOTFOUND ) THEN
1040 RAISE NO_DATA_FOUND;
1041 END IF;
1042
1043 END Delete_Row;
1044
1045 END HZ_RELATIONSHIPS_PKG;