90: x_party_id,
91: x_party_usage_code,
92: DECODE(x_effective_start_date,
93: NULL, trunc(sysdate),
94: FND_API.G_MISS_DATE, trunc(sysdate),
95: trunc(x_effective_start_date)),
96: DECODE(x_effective_end_date,
97: NULL, D_FUTURE_DATE,
98: FND_API.G_MISS_DATE, D_FUTURE_DATE,
94: FND_API.G_MISS_DATE, trunc(sysdate),
95: trunc(x_effective_start_date)),
96: DECODE(x_effective_end_date,
97: NULL, D_FUTURE_DATE,
98: FND_API.G_MISS_DATE, D_FUTURE_DATE,
99: trunc(x_effective_end_date)),
100: DECODE(x_status_flag,
101: NULL, 'A',
102: FND_API.G_MISS_CHAR, 'A',
98: FND_API.G_MISS_DATE, D_FUTURE_DATE,
99: trunc(x_effective_end_date)),
100: DECODE(x_status_flag,
101: NULL, 'A',
102: FND_API.G_MISS_CHAR, 'A',
103: x_status_flag),
104: DECODE(x_comments,
105: FND_API.G_MISS_CHAR, NULL,
106: x_comments),
101: NULL, 'A',
102: FND_API.G_MISS_CHAR, 'A',
103: x_status_flag),
104: DECODE(x_comments,
105: FND_API.G_MISS_CHAR, NULL,
106: x_comments),
107: DECODE(x_owner_table_name,
108: FND_API.G_MISS_CHAR, NULL,
109: x_owner_table_name),
104: DECODE(x_comments,
105: FND_API.G_MISS_CHAR, NULL,
106: x_comments),
107: DECODE(x_owner_table_name,
108: FND_API.G_MISS_CHAR, NULL,
109: x_owner_table_name),
110: DECODE(x_owner_table_id,
111: FND_API.G_MISS_NUM, NULL,
112: x_owner_table_id),
107: DECODE(x_owner_table_name,
108: FND_API.G_MISS_CHAR, NULL,
109: x_owner_table_name),
110: DECODE(x_owner_table_id,
111: FND_API.G_MISS_NUM, NULL,
112: x_owner_table_id),
113: DECODE(x_attribute_category,
114: FND_API.G_MISS_CHAR, NULL,
115: x_attribute_category),
110: DECODE(x_owner_table_id,
111: FND_API.G_MISS_NUM, NULL,
112: x_owner_table_id),
113: DECODE(x_attribute_category,
114: FND_API.G_MISS_CHAR, NULL,
115: x_attribute_category),
116: DECODE(x_attribute1,
117: FND_API.G_MISS_CHAR, NULL,
118: x_attribute1),
113: DECODE(x_attribute_category,
114: FND_API.G_MISS_CHAR, NULL,
115: x_attribute_category),
116: DECODE(x_attribute1,
117: FND_API.G_MISS_CHAR, NULL,
118: x_attribute1),
119: DECODE(x_attribute2,
120: FND_API.G_MISS_CHAR, NULL,
121: x_attribute2),
116: DECODE(x_attribute1,
117: FND_API.G_MISS_CHAR, NULL,
118: x_attribute1),
119: DECODE(x_attribute2,
120: FND_API.G_MISS_CHAR, NULL,
121: x_attribute2),
122: DECODE(x_attribute3,
123: FND_API.G_MISS_CHAR, NULL,
124: x_attribute3),
119: DECODE(x_attribute2,
120: FND_API.G_MISS_CHAR, NULL,
121: x_attribute2),
122: DECODE(x_attribute3,
123: FND_API.G_MISS_CHAR, NULL,
124: x_attribute3),
125: DECODE(x_attribute4,
126: FND_API.G_MISS_CHAR, NULL,
127: x_attribute4),
122: DECODE(x_attribute3,
123: FND_API.G_MISS_CHAR, NULL,
124: x_attribute3),
125: DECODE(x_attribute4,
126: FND_API.G_MISS_CHAR, NULL,
127: x_attribute4),
128: DECODE(x_attribute5,
129: FND_API.G_MISS_CHAR, NULL,
130: x_attribute5),
125: DECODE(x_attribute4,
126: FND_API.G_MISS_CHAR, NULL,
127: x_attribute4),
128: DECODE(x_attribute5,
129: FND_API.G_MISS_CHAR, NULL,
130: x_attribute5),
131: DECODE(x_attribute6,
132: FND_API.G_MISS_CHAR, NULL,
133: x_attribute6),
128: DECODE(x_attribute5,
129: FND_API.G_MISS_CHAR, NULL,
130: x_attribute5),
131: DECODE(x_attribute6,
132: FND_API.G_MISS_CHAR, NULL,
133: x_attribute6),
134: DECODE(x_attribute7,
135: FND_API.G_MISS_CHAR, NULL,
136: x_attribute7),
131: DECODE(x_attribute6,
132: FND_API.G_MISS_CHAR, NULL,
133: x_attribute6),
134: DECODE(x_attribute7,
135: FND_API.G_MISS_CHAR, NULL,
136: x_attribute7),
137: DECODE(x_attribute8,
138: FND_API.G_MISS_CHAR, NULL,
139: x_attribute8),
134: DECODE(x_attribute7,
135: FND_API.G_MISS_CHAR, NULL,
136: x_attribute7),
137: DECODE(x_attribute8,
138: FND_API.G_MISS_CHAR, NULL,
139: x_attribute8),
140: DECODE(x_attribute9,
141: FND_API.G_MISS_CHAR, NULL,
142: x_attribute9),
137: DECODE(x_attribute8,
138: FND_API.G_MISS_CHAR, NULL,
139: x_attribute8),
140: DECODE(x_attribute9,
141: FND_API.G_MISS_CHAR, NULL,
142: x_attribute9),
143: DECODE(x_attribute10,
144: FND_API.G_MISS_CHAR, NULL,
145: x_attribute10),
140: DECODE(x_attribute9,
141: FND_API.G_MISS_CHAR, NULL,
142: x_attribute9),
143: DECODE(x_attribute10,
144: FND_API.G_MISS_CHAR, NULL,
145: x_attribute10),
146: DECODE(x_attribute11,
147: FND_API.G_MISS_CHAR, NULL,
148: x_attribute11),
143: DECODE(x_attribute10,
144: FND_API.G_MISS_CHAR, NULL,
145: x_attribute10),
146: DECODE(x_attribute11,
147: FND_API.G_MISS_CHAR, NULL,
148: x_attribute11),
149: DECODE(x_attribute12,
150: FND_API.G_MISS_CHAR, NULL,
151: x_attribute12),
146: DECODE(x_attribute11,
147: FND_API.G_MISS_CHAR, NULL,
148: x_attribute11),
149: DECODE(x_attribute12,
150: FND_API.G_MISS_CHAR, NULL,
151: x_attribute12),
152: DECODE(x_attribute13,
153: FND_API.G_MISS_CHAR, NULL,
154: x_attribute13),
149: DECODE(x_attribute12,
150: FND_API.G_MISS_CHAR, NULL,
151: x_attribute12),
152: DECODE(x_attribute13,
153: FND_API.G_MISS_CHAR, NULL,
154: x_attribute13),
155: DECODE(x_attribute14,
156: FND_API.G_MISS_CHAR, NULL,
157: x_attribute14),
152: DECODE(x_attribute13,
153: FND_API.G_MISS_CHAR, NULL,
154: x_attribute13),
155: DECODE(x_attribute14,
156: FND_API.G_MISS_CHAR, NULL,
157: x_attribute14),
158: DECODE(x_attribute15,
159: FND_API.G_MISS_CHAR, NULL,
160: x_attribute15),
155: DECODE(x_attribute14,
156: FND_API.G_MISS_CHAR, NULL,
157: x_attribute14),
158: DECODE(x_attribute15,
159: FND_API.G_MISS_CHAR, NULL,
160: x_attribute15),
161: DECODE(x_attribute16,
162: FND_API.G_MISS_CHAR, NULL,
163: x_attribute16),
158: DECODE(x_attribute15,
159: FND_API.G_MISS_CHAR, NULL,
160: x_attribute15),
161: DECODE(x_attribute16,
162: FND_API.G_MISS_CHAR, NULL,
163: x_attribute16),
164: DECODE(x_attribute17,
165: FND_API.G_MISS_CHAR, NULL,
166: x_attribute17),
161: DECODE(x_attribute16,
162: FND_API.G_MISS_CHAR, NULL,
163: x_attribute16),
164: DECODE(x_attribute17,
165: FND_API.G_MISS_CHAR, NULL,
166: x_attribute17),
167: DECODE(x_attribute18,
168: FND_API.G_MISS_CHAR, NULL,
169: x_attribute18),
164: DECODE(x_attribute17,
165: FND_API.G_MISS_CHAR, NULL,
166: x_attribute17),
167: DECODE(x_attribute18,
168: FND_API.G_MISS_CHAR, NULL,
169: x_attribute18),
170: DECODE(x_attribute19,
171: FND_API.G_MISS_CHAR, NULL,
172: x_attribute19),
167: DECODE(x_attribute18,
168: FND_API.G_MISS_CHAR, NULL,
169: x_attribute18),
170: DECODE(x_attribute19,
171: FND_API.G_MISS_CHAR, NULL,
172: x_attribute19),
173: DECODE(x_attribute20,
174: FND_API.G_MISS_CHAR, NULL,
175: x_attribute20),
170: DECODE(x_attribute19,
171: FND_API.G_MISS_CHAR, NULL,
172: x_attribute19),
173: DECODE(x_attribute20,
174: FND_API.G_MISS_CHAR, NULL,
175: x_attribute20),
176: x_object_version_number,
177: x_created_by_module,
178: hz_utility_v2pub.application_id,
246: trunc(x_effective_start_date)),
247: effective_end_date =
248: DECODE(x_effective_end_date,
249: NULL, effective_end_date,
250: FND_API.G_MISS_DATE, D_FUTURE_DATE,
251: trunc(x_effective_end_date)),
252: status_flag =
253: DECODE(x_status_flag,
254: NULL, status_flag,
255: x_status_flag),
256: comments =
257: DECODE(x_comments,
258: NULL, comments,
259: FND_API.G_MISS_CHAR, NULL,
260: x_comments),
261: owner_table_name =
262: DECODE(x_owner_table_name,
263: NULL, owner_table_name,
260: x_comments),
261: owner_table_name =
262: DECODE(x_owner_table_name,
263: NULL, owner_table_name,
264: FND_API.G_MISS_CHAR, NULL,
265: x_owner_table_name),
266: owner_table_id =
267: DECODE(x_owner_table_id,
268: NULL, owner_table_id,
265: x_owner_table_name),
266: owner_table_id =
267: DECODE(x_owner_table_id,
268: NULL, owner_table_id,
269: FND_API.G_MISS_CHAR, NULL,
270: x_owner_table_id),
271: attribute_category =
272: DECODE(x_attribute_category,
273: NULL, attribute_category,
270: x_owner_table_id),
271: attribute_category =
272: DECODE(x_attribute_category,
273: NULL, attribute_category,
274: FND_API.G_MISS_CHAR, NULL,
275: x_attribute_category),
276: attribute1 =
277: DECODE(x_attribute1,
278: NULL, attribute1,
275: x_attribute_category),
276: attribute1 =
277: DECODE(x_attribute1,
278: NULL, attribute1,
279: FND_API.G_MISS_CHAR, NULL,
280: x_attribute1),
281: attribute2 =
282: DECODE(x_attribute2,
283: NULL, attribute2,
280: x_attribute1),
281: attribute2 =
282: DECODE(x_attribute2,
283: NULL, attribute2,
284: FND_API.G_MISS_CHAR, NULL,
285: x_attribute2),
286: attribute3 =
287: DECODE(x_attribute3,
288: NULL, attribute3,
285: x_attribute2),
286: attribute3 =
287: DECODE(x_attribute3,
288: NULL, attribute3,
289: FND_API.G_MISS_CHAR, NULL,
290: x_attribute3),
291: attribute4 =
292: DECODE(x_attribute4,
293: NULL, attribute4,
290: x_attribute3),
291: attribute4 =
292: DECODE(x_attribute4,
293: NULL, attribute4,
294: FND_API.G_MISS_CHAR, NULL,
295: x_attribute4),
296: attribute5 =
297: DECODE(x_attribute5,
298: NULL, attribute5,
295: x_attribute4),
296: attribute5 =
297: DECODE(x_attribute5,
298: NULL, attribute5,
299: FND_API.G_MISS_CHAR, NULL,
300: x_attribute5),
301: attribute6 =
302: DECODE(x_attribute6,
303: NULL, attribute6,
300: x_attribute5),
301: attribute6 =
302: DECODE(x_attribute6,
303: NULL, attribute6,
304: FND_API.G_MISS_CHAR, NULL,
305: x_attribute6),
306: attribute7 =
307: DECODE(x_attribute7,
308: NULL, attribute7,
305: x_attribute6),
306: attribute7 =
307: DECODE(x_attribute7,
308: NULL, attribute7,
309: FND_API.G_MISS_CHAR, NULL,
310: x_attribute7),
311: attribute8 =
312: DECODE(x_attribute8,
313: NULL, attribute8,
310: x_attribute7),
311: attribute8 =
312: DECODE(x_attribute8,
313: NULL, attribute8,
314: FND_API.G_MISS_CHAR, NULL,
315: x_attribute8),
316: attribute9 =
317: DECODE(x_attribute9,
318: NULL, attribute9,
315: x_attribute8),
316: attribute9 =
317: DECODE(x_attribute9,
318: NULL, attribute9,
319: FND_API.G_MISS_CHAR, NULL,
320: x_attribute9),
321: attribute10 =
322: DECODE(x_attribute10,
323: NULL, attribute10,
320: x_attribute9),
321: attribute10 =
322: DECODE(x_attribute10,
323: NULL, attribute10,
324: FND_API.G_MISS_CHAR, NULL,
325: x_attribute10),
326: attribute11 =
327: DECODE(x_attribute11,
328: NULL, attribute11,
325: x_attribute10),
326: attribute11 =
327: DECODE(x_attribute11,
328: NULL, attribute11,
329: FND_API.G_MISS_CHAR, NULL,
330: x_attribute11),
331: attribute12 =
332: DECODE(x_attribute12,
333: NULL, attribute12,
330: x_attribute11),
331: attribute12 =
332: DECODE(x_attribute12,
333: NULL, attribute12,
334: FND_API.G_MISS_CHAR, NULL,
335: x_attribute12),
336: attribute13 =
337: DECODE(x_attribute13,
338: NULL, attribute13,
335: x_attribute12),
336: attribute13 =
337: DECODE(x_attribute13,
338: NULL, attribute13,
339: FND_API.G_MISS_CHAR, NULL,
340: x_attribute13),
341: attribute14 =
342: DECODE(x_attribute14,
343: NULL, attribute14,
340: x_attribute13),
341: attribute14 =
342: DECODE(x_attribute14,
343: NULL, attribute14,
344: FND_API.G_MISS_CHAR, NULL,
345: x_attribute14),
346: attribute15 =
347: DECODE(x_attribute15,
348: NULL, attribute15,
345: x_attribute14),
346: attribute15 =
347: DECODE(x_attribute15,
348: NULL, attribute15,
349: FND_API.G_MISS_CHAR, NULL,
350: x_attribute15),
351: attribute16 =
352: DECODE(x_attribute16,
353: NULL, attribute16,
350: x_attribute15),
351: attribute16 =
352: DECODE(x_attribute16,
353: NULL, attribute16,
354: FND_API.G_MISS_CHAR, NULL,
355: x_attribute16),
356: attribute17 =
357: DECODE(x_attribute17,
358: NULL, attribute17,
355: x_attribute16),
356: attribute17 =
357: DECODE(x_attribute17,
358: NULL, attribute17,
359: FND_API.G_MISS_CHAR, NULL,
360: x_attribute17),
361: attribute18 =
362: DECODE(x_attribute18,
363: NULL, attribute18,
360: x_attribute17),
361: attribute18 =
362: DECODE(x_attribute18,
363: NULL, attribute18,
364: FND_API.G_MISS_CHAR, NULL,
365: x_attribute18),
366: attribute19 =
367: DECODE(x_attribute19,
368: NULL, attribute19,
365: x_attribute18),
366: attribute19 =
367: DECODE(x_attribute19,
368: NULL, attribute19,
369: FND_API.G_MISS_CHAR, NULL,
370: x_attribute19),
371: attribute20 =
372: DECODE(x_attribute20,
373: NULL, attribute20,
370: x_attribute19),
371: attribute20 =
372: DECODE(x_attribute20,
373: NULL, attribute20,
374: FND_API.G_MISS_CHAR, NULL,
375: x_attribute20),
376: object_version_number =
377: DECODE(x_object_version_number,
378: NULL, object_version_number,