eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTIES_PKG dependencies on FND_API

Line 19: | p_duns_number_c <> FND_API.G_MISS_CHAR

15:
16: /* Bug 3435702.This check is done before calling this procedure and as such is redundant.
17: |
18: | IF p_duns_number_c IS NOT NULL AND
19: | p_duns_number_c <> FND_API.G_MISS_CHAR
20: | THEN
21: */
22: FOR i IN 1..LENGTHB(p_duns_number_c) LOOP
23: l_char := SUBSTRB(p_duns_number_c, i, 1);

Line 128: x_duns_number_c <> FND_API.G_MISS_CHAR

124: l_duns_number_c HZ_PARTIES.duns_number_c%type := X_DUNS_NUMBER_C;
125: BEGIN
126:
127: IF x_duns_number_c IS NOT NULL AND
128: x_duns_number_c <> FND_API.G_MISS_CHAR
129: THEN
130: l_duns_number := do_copy_duns_number(x_duns_number_c);
131: END IF;
132:

Line 134: x_duns_number_c <> FND_API.G_MISS_CHAR AND

130: l_duns_number := do_copy_duns_number(x_duns_number_c);
131: END IF;
132:
133: IF x_duns_number_c IS NOT NULL AND
134: x_duns_number_c <> FND_API.G_MISS_CHAR AND
135: LENGTHB(x_duns_number_c)<9
136: THEN
137: l_duns_number_c:=lpad(x_duns_number_c,9,'0');
138: END IF;

Line 239: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, HZ_PARTIES_S.NEXTVAL, NULL, HZ_PARTIES_S.NEXTVAL, X_PARTY_ID ),

235: CREATED_BY_MODULE,
236: APPLICATION_ID
237: )
238: VALUES (
239: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, HZ_PARTIES_S.NEXTVAL, NULL, HZ_PARTIES_S.NEXTVAL, X_PARTY_ID ),
240: DECODE( X_PARTY_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), X_PARTY_NUMBER ),
241: DECODE( X_PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
242: DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),

Line 240: DECODE( X_PARTY_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), X_PARTY_NUMBER ),

236: APPLICATION_ID
237: )
238: VALUES (
239: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, HZ_PARTIES_S.NEXTVAL, NULL, HZ_PARTIES_S.NEXTVAL, X_PARTY_ID ),
240: DECODE( X_PARTY_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), X_PARTY_NUMBER ),
241: DECODE( X_PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
242: DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),
244: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 241: DECODE( X_PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),

237: )
238: VALUES (
239: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, HZ_PARTIES_S.NEXTVAL, NULL, HZ_PARTIES_S.NEXTVAL, X_PARTY_ID ),
240: DECODE( X_PARTY_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), X_PARTY_NUMBER ),
241: DECODE( X_PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
242: DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),
244: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
245: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 242: DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),

238: VALUES (
239: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, HZ_PARTIES_S.NEXTVAL, NULL, HZ_PARTIES_S.NEXTVAL, X_PARTY_ID ),
240: DECODE( X_PARTY_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), X_PARTY_NUMBER ),
241: DECODE( X_PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
242: DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),
244: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
245: HZ_UTILITY_V2PUB.CREATION_DATE,
246: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),

239: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, HZ_PARTIES_S.NEXTVAL, NULL, HZ_PARTIES_S.NEXTVAL, X_PARTY_ID ),
240: DECODE( X_PARTY_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), X_PARTY_NUMBER ),
241: DECODE( X_PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
242: DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),
244: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
245: HZ_UTILITY_V2PUB.CREATION_DATE,
246: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
247: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 253: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

249: HZ_UTILITY_V2PUB.CREATED_BY,
250: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
251: HZ_UTILITY_V2PUB.PROGRAM_ID,
252: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
253: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
254: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
255: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
256: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
257: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

Line 254: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

250: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
251: HZ_UTILITY_V2PUB.PROGRAM_ID,
252: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
253: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
254: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
255: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
256: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
257: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
258: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

Line 255: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

251: HZ_UTILITY_V2PUB.PROGRAM_ID,
252: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
253: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
254: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
255: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
256: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
257: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
258: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
259: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

Line 256: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

252: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
253: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
254: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
255: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
256: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
257: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
258: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
259: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
260: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

Line 257: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

253: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
254: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
255: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
256: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
257: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
258: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
259: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
260: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
261: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

Line 258: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

254: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
255: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
256: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
257: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
258: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
259: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
260: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
261: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
262: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

Line 259: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

255: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
256: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
257: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
258: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
259: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
260: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
261: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
262: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
263: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

Line 260: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

256: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
257: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
258: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
259: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
260: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
261: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
262: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
263: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
264: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

Line 261: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

257: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
258: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
259: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
260: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
261: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
262: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
263: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
264: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
265: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

Line 262: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

258: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
259: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
260: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
261: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
262: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
263: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
264: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
265: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
266: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

Line 263: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

259: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
260: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
261: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
262: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
263: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
264: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
265: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
266: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
267: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

Line 264: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

260: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
261: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
262: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
263: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
264: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
265: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
266: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
267: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
268: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

Line 265: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

261: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
262: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
263: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
264: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
265: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
266: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
267: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
268: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
269: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),

Line 266: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

262: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
263: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
264: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
265: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
266: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
267: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
268: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
269: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
270: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),

Line 267: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

263: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
264: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
265: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
266: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
267: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
268: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
269: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
270: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
271: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),

Line 268: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

264: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
265: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
266: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
267: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
268: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
269: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
270: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
271: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
272: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

Line 269: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),

265: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
266: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
267: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
268: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
269: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
270: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
271: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
272: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
273: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),

Line 270: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),

266: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
267: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
268: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
269: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
270: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
271: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
272: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
273: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
274: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),

Line 271: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),

267: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
268: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
269: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
270: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
271: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
272: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
273: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
274: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
275: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),

Line 272: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

268: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
269: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
270: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
271: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
272: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
273: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
274: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
275: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
276: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),

Line 273: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),

269: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
270: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
271: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
272: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
273: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
274: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
275: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
276: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
277: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),

Line 274: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),

270: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
271: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
272: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
273: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
274: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
275: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
276: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
277: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

Line 275: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),

271: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
272: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
273: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
274: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
275: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
276: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
277: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
279: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),

Line 276: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),

272: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
273: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
274: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
275: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
276: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
277: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
279: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
280: DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),

Line 277: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),

273: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
274: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
275: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
276: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
277: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
279: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
280: DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
281: DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),

Line 278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

274: DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
275: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
276: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
277: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
279: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
280: DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
281: DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
282: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),

Line 279: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),

275: DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
276: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
277: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
279: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
280: DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
281: DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
282: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
283: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),

Line 280: DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),

276: DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
277: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
279: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
280: DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
281: DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
282: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
283: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
284: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),

Line 281: DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),

277: DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
279: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
280: DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
281: DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
282: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
283: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
284: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
285: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),

Line 282: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),

278: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_ID,HZ_PARTIES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
279: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
280: DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
281: DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
282: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
283: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
284: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
285: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
286: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),

Line 283: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),

279: DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
280: DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
281: DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
282: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
283: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
284: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
285: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
286: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
287: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),

Line 284: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),

280: DECODE( X_HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
281: DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
282: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
283: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
284: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
285: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
286: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
287: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
288: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),

Line 285: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),

281: DECODE( X_CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
282: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
283: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
284: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
285: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
286: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
287: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
288: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
289: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),

Line 286: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),

282: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
283: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
284: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
285: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
286: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
287: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
288: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
289: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
290: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),

Line 287: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),

283: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
284: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
285: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
286: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
287: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
288: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
289: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
290: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
291: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),

Line 288: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),

284: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
285: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
286: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
287: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
288: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
289: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
290: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
291: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
292: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),

Line 289: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),

285: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
286: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
287: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
288: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
289: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
290: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
291: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
292: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
293: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),

Line 290: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),

286: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
287: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
288: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
289: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
290: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
291: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
292: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
293: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
294: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),

Line 291: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),

287: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
288: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
289: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
290: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
291: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
292: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
293: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
294: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
295: DECODE( X_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),

Line 292: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),

288: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
289: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
290: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
291: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
292: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
293: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
294: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
295: DECODE( X_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
296: DECODE( X_COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),

Line 293: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),

289: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
290: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
291: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
292: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
293: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
294: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
295: DECODE( X_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
296: DECODE( X_COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
297: DECODE( X_ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),

Line 294: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),

290: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
291: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
292: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
293: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
294: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
295: DECODE( X_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
296: DECODE( X_COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
297: DECODE( X_ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
298: DECODE( X_ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),

Line 295: DECODE( X_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),

291: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
292: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
293: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
294: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
295: DECODE( X_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
296: DECODE( X_COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
297: DECODE( X_ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
298: DECODE( X_ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
299: DECODE( X_ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),

Line 296: DECODE( X_COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),

292: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
293: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
294: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
295: DECODE( X_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
296: DECODE( X_COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
297: DECODE( X_ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
298: DECODE( X_ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
299: DECODE( X_ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
300: DECODE( X_ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),

Line 297: DECODE( X_ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),

293: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
294: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
295: DECODE( X_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
296: DECODE( X_COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
297: DECODE( X_ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
298: DECODE( X_ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
299: DECODE( X_ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
300: DECODE( X_ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
301: DECODE( X_CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),

Line 298: DECODE( X_ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),

294: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
295: DECODE( X_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
296: DECODE( X_COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
297: DECODE( X_ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
298: DECODE( X_ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
299: DECODE( X_ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
300: DECODE( X_ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
301: DECODE( X_CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
302: DECODE( X_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),

Line 299: DECODE( X_ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),

295: DECODE( X_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
296: DECODE( X_COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
297: DECODE( X_ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
298: DECODE( X_ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
299: DECODE( X_ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
300: DECODE( X_ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
301: DECODE( X_CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
302: DECODE( X_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
303: DECODE( X_STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),

Line 300: DECODE( X_ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),

296: DECODE( X_COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
297: DECODE( X_ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
298: DECODE( X_ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
299: DECODE( X_ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
300: DECODE( X_ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
301: DECODE( X_CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
302: DECODE( X_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
303: DECODE( X_STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
304: DECODE( X_PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),

Line 301: DECODE( X_CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),

297: DECODE( X_ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
298: DECODE( X_ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
299: DECODE( X_ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
300: DECODE( X_ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
301: DECODE( X_CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
302: DECODE( X_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
303: DECODE( X_STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
304: DECODE( X_PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
305: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

Line 302: DECODE( X_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),

298: DECODE( X_ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
299: DECODE( X_ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
300: DECODE( X_ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
301: DECODE( X_CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
302: DECODE( X_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
303: DECODE( X_STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
304: DECODE( X_PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
305: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
306: DECODE( X_COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),

Line 303: DECODE( X_STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),

299: DECODE( X_ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
300: DECODE( X_ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
301: DECODE( X_CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
302: DECODE( X_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
303: DECODE( X_STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
304: DECODE( X_PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
305: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
306: DECODE( X_COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
307: DECODE( X_SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),

Line 304: DECODE( X_PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),

300: DECODE( X_ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
301: DECODE( X_CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
302: DECODE( X_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
303: DECODE( X_STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
304: DECODE( X_PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
305: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
306: DECODE( X_COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
307: DECODE( X_SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
308: DECODE( X_URL, FND_API.G_MISS_CHAR, NULL, X_URL ),

Line 305: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

301: DECODE( X_CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
302: DECODE( X_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
303: DECODE( X_STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
304: DECODE( X_PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
305: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
306: DECODE( X_COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
307: DECODE( X_SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
308: DECODE( X_URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
309: --Bug 4355133

Line 306: DECODE( X_COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),

302: DECODE( X_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
303: DECODE( X_STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
304: DECODE( X_PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
305: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
306: DECODE( X_COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
307: DECODE( X_SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
308: DECODE( X_URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
309: --Bug 4355133
310: SUBSTRB(DECODE( X_EMAIL_ADDRESS, FND_API.G_MISS_CHAR, NULL,

Line 307: DECODE( X_SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),

303: DECODE( X_STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
304: DECODE( X_PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
305: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
306: DECODE( X_COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
307: DECODE( X_SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
308: DECODE( X_URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
309: --Bug 4355133
310: SUBSTRB(DECODE( X_EMAIL_ADDRESS, FND_API.G_MISS_CHAR, NULL,
311: X_EMAIL_ADDRESS ),1,320),

Line 308: DECODE( X_URL, FND_API.G_MISS_CHAR, NULL, X_URL ),

304: DECODE( X_PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
305: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
306: DECODE( X_COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
307: DECODE( X_SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
308: DECODE( X_URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
309: --Bug 4355133
310: SUBSTRB(DECODE( X_EMAIL_ADDRESS, FND_API.G_MISS_CHAR, NULL,
311: X_EMAIL_ADDRESS ),1,320),
312: DECODE( X_ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),

Line 310: SUBSTRB(DECODE( X_EMAIL_ADDRESS, FND_API.G_MISS_CHAR, NULL,

306: DECODE( X_COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
307: DECODE( X_SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
308: DECODE( X_URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
309: --Bug 4355133
310: SUBSTRB(DECODE( X_EMAIL_ADDRESS, FND_API.G_MISS_CHAR, NULL,
311: X_EMAIL_ADDRESS ),1,320),
312: DECODE( X_ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
313: DECODE( X_FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
314: DECODE( X_EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),

Line 312: DECODE( X_ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),

308: DECODE( X_URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
309: --Bug 4355133
310: SUBSTRB(DECODE( X_EMAIL_ADDRESS, FND_API.G_MISS_CHAR, NULL,
311: X_EMAIL_ADDRESS ),1,320),
312: DECODE( X_ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
313: DECODE( X_FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
314: DECODE( X_EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
315: DECODE( X_CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
316: DECODE( X_NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),

Line 313: DECODE( X_FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),

309: --Bug 4355133
310: SUBSTRB(DECODE( X_EMAIL_ADDRESS, FND_API.G_MISS_CHAR, NULL,
311: X_EMAIL_ADDRESS ),1,320),
312: DECODE( X_ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
313: DECODE( X_FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
314: DECODE( X_EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
315: DECODE( X_CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
316: DECODE( X_NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
317: DECODE( X_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),

Line 314: DECODE( X_EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),

310: SUBSTRB(DECODE( X_EMAIL_ADDRESS, FND_API.G_MISS_CHAR, NULL,
311: X_EMAIL_ADDRESS ),1,320),
312: DECODE( X_ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
313: DECODE( X_FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
314: DECODE( X_EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
315: DECODE( X_CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
316: DECODE( X_NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
317: DECODE( X_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
318: DECODE( X_GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),

Line 315: DECODE( X_CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),

311: X_EMAIL_ADDRESS ),1,320),
312: DECODE( X_ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
313: DECODE( X_FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
314: DECODE( X_EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
315: DECODE( X_CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
316: DECODE( X_NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
317: DECODE( X_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
318: DECODE( X_GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
319: DECODE( X_MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),

Line 316: DECODE( X_NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),

312: DECODE( X_ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
313: DECODE( X_FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
314: DECODE( X_EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
315: DECODE( X_CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
316: DECODE( X_NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
317: DECODE( X_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
318: DECODE( X_GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
319: DECODE( X_MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
320: DECODE( X_ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),

Line 317: DECODE( X_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),

313: DECODE( X_FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
314: DECODE( X_EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
315: DECODE( X_CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
316: DECODE( X_NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
317: DECODE( X_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
318: DECODE( X_GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
319: DECODE( X_MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
320: DECODE( X_ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
321: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),

Line 318: DECODE( X_GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),

314: DECODE( X_EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
315: DECODE( X_CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
316: DECODE( X_NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
317: DECODE( X_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
318: DECODE( X_GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
319: DECODE( X_MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
320: DECODE( X_ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
321: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
322: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),

Line 319: DECODE( X_MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),

315: DECODE( X_CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
316: DECODE( X_NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
317: DECODE( X_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
318: DECODE( X_GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
319: DECODE( X_MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
320: DECODE( X_ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
321: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
322: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
323: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),

Line 320: DECODE( X_ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),

316: DECODE( X_NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
317: DECODE( X_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
318: DECODE( X_GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
319: DECODE( X_MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
320: DECODE( X_ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
321: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
322: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
323: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
324: DECODE( X_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),

Line 321: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),

317: DECODE( X_YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
318: DECODE( X_GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
319: DECODE( X_MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
320: DECODE( X_ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
321: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
322: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
323: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
324: DECODE( X_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
325: DECODE( X_SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),

Line 322: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),

318: DECODE( X_GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
319: DECODE( X_MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
320: DECODE( X_ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
321: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
322: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
323: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
324: DECODE( X_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
325: DECODE( X_SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
326: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),

Line 323: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),

319: DECODE( X_MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
320: DECODE( X_ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
321: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
322: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
323: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
324: DECODE( X_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
325: DECODE( X_SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
326: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
327: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),

Line 324: DECODE( X_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),

320: DECODE( X_ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
321: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
322: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
323: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
324: DECODE( X_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
325: DECODE( X_SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
326: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
327: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
328: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),

Line 325: DECODE( X_SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),

321: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
322: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
323: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
324: DECODE( X_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
325: DECODE( X_SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
326: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
327: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
328: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
329: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),

Line 326: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),

322: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
323: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
324: DECODE( X_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
325: DECODE( X_SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
326: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
327: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
328: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
329: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
330: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 327: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),

323: DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
324: DECODE( X_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
325: DECODE( X_SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
326: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
327: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
328: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
329: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
330: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
331: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),

Line 328: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),

324: DECODE( X_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
325: DECODE( X_SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
326: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
327: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
328: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
329: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
330: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
331: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),
332: /* Bug 3435702.This is replaced by l_duns_number as l_duns_number will be NULL if

Line 329: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),

325: DECODE( X_SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
326: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
327: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
328: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
329: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
330: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
331: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),
332: /* Bug 3435702.This is replaced by l_duns_number as l_duns_number will be NULL if
333: X_DUNS_NUMBER_C is NULL or is equal to FND_API.G_MISS_CHAR.

Line 330: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

326: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
327: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
328: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
329: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
330: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
331: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),
332: /* Bug 3435702.This is replaced by l_duns_number as l_duns_number will be NULL if
333: X_DUNS_NUMBER_C is NULL or is equal to FND_API.G_MISS_CHAR.
334: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, NULL, NULL, l_duns_number ),

Line 331: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/Bug 3435702/ UPPER(l_duns_number_c)),

327: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
328: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
329: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
330: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
331: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),
332: /* Bug 3435702.This is replaced by l_duns_number as l_duns_number will be NULL if
333: X_DUNS_NUMBER_C is NULL or is equal to FND_API.G_MISS_CHAR.
334: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, NULL, NULL, l_duns_number ),
335: */

Line 333: X_DUNS_NUMBER_C is NULL or is equal to FND_API.G_MISS_CHAR.

329: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
330: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
331: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),
332: /* Bug 3435702.This is replaced by l_duns_number as l_duns_number will be NULL if
333: X_DUNS_NUMBER_C is NULL or is equal to FND_API.G_MISS_CHAR.
334: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, NULL, NULL, l_duns_number ),
335: */
336: l_duns_number,
337: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 334: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, NULL, NULL, l_duns_number ),

330: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
331: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(l_duns_number_c)),
332: /* Bug 3435702.This is replaced by l_duns_number as l_duns_number will be NULL if
333: X_DUNS_NUMBER_C is NULL or is equal to FND_API.G_MISS_CHAR.
334: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, NULL, NULL, l_duns_number ),
335: */
336: l_duns_number,
337: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
338: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

Line 337: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

333: X_DUNS_NUMBER_C is NULL or is equal to FND_API.G_MISS_CHAR.
334: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, NULL, NULL, l_duns_number ),
335: */
336: l_duns_number,
337: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
338: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
339: ) RETURNING
340: PARTY_ID,
341: PARTY_NUMBER

Line 338: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

334: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, NULL, NULL, l_duns_number ),
335: */
336: l_duns_number,
337: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
338: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
339: ) RETURNING
340: PARTY_ID,
341: PARTY_NUMBER
342: INTO

Line 495: x_duns_number_c <> FND_API.G_MISS_CHAR

491: l_duns_number_c HZ_PARTIES.duns_number_c%type := X_DUNS_NUMBER_C;
492: BEGIN
493:
494: IF x_duns_number_c IS NOT NULL AND
495: x_duns_number_c <> FND_API.G_MISS_CHAR
496: THEN
497: l_duns_number := do_copy_duns_number(x_duns_number_c);
498: END IF;
499:

Line 501: x_duns_number_c <> FND_API.G_MISS_CHAR AND

497: l_duns_number := do_copy_duns_number(x_duns_number_c);
498: END IF;
499:
500: IF x_duns_number_c IS NOT NULL AND
501: x_duns_number_c <> FND_API.G_MISS_CHAR AND
502: LENGTHB(x_duns_number_c)<9
503: THEN
504: l_duns_number_c:=lpad(x_duns_number_c,9,'0');
505: END IF;

Line 508: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),

504: l_duns_number_c:=lpad(x_duns_number_c,9,'0');
505: END IF;
506:
507: UPDATE HZ_PARTIES SET
508: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
509: PARTY_NUMBER = DECODE( X_PARTY_NUMBER, NULL, PARTY_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_NUMBER ),
510: PARTY_NAME = DECODE( X_PARTY_NAME, NULL, PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
511: PARTY_TYPE = DECODE( X_PARTY_TYPE, NULL, PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
512: VALIDATED_FLAG = DECODE( X_VALIDATED_FLAG, NULL, VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', X_VALIDATED_FLAG ),

Line 509: PARTY_NUMBER = DECODE( X_PARTY_NUMBER, NULL, PARTY_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_NUMBER ),

505: END IF;
506:
507: UPDATE HZ_PARTIES SET
508: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
509: PARTY_NUMBER = DECODE( X_PARTY_NUMBER, NULL, PARTY_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_NUMBER ),
510: PARTY_NAME = DECODE( X_PARTY_NAME, NULL, PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
511: PARTY_TYPE = DECODE( X_PARTY_TYPE, NULL, PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
512: VALIDATED_FLAG = DECODE( X_VALIDATED_FLAG, NULL, VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', X_VALIDATED_FLAG ),
513: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 510: PARTY_NAME = DECODE( X_PARTY_NAME, NULL, PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),

506:
507: UPDATE HZ_PARTIES SET
508: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
509: PARTY_NUMBER = DECODE( X_PARTY_NUMBER, NULL, PARTY_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_NUMBER ),
510: PARTY_NAME = DECODE( X_PARTY_NAME, NULL, PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
511: PARTY_TYPE = DECODE( X_PARTY_TYPE, NULL, PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
512: VALIDATED_FLAG = DECODE( X_VALIDATED_FLAG, NULL, VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', X_VALIDATED_FLAG ),
513: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
514: CREATION_DATE = CREATION_DATE,

Line 511: PARTY_TYPE = DECODE( X_PARTY_TYPE, NULL, PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),

507: UPDATE HZ_PARTIES SET
508: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
509: PARTY_NUMBER = DECODE( X_PARTY_NUMBER, NULL, PARTY_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_NUMBER ),
510: PARTY_NAME = DECODE( X_PARTY_NAME, NULL, PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
511: PARTY_TYPE = DECODE( X_PARTY_TYPE, NULL, PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
512: VALIDATED_FLAG = DECODE( X_VALIDATED_FLAG, NULL, VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', X_VALIDATED_FLAG ),
513: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
514: CREATION_DATE = CREATION_DATE,
515: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 512: VALIDATED_FLAG = DECODE( X_VALIDATED_FLAG, NULL, VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', X_VALIDATED_FLAG ),

508: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
509: PARTY_NUMBER = DECODE( X_PARTY_NUMBER, NULL, PARTY_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_NUMBER ),
510: PARTY_NAME = DECODE( X_PARTY_NAME, NULL, PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
511: PARTY_TYPE = DECODE( X_PARTY_TYPE, NULL, PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
512: VALIDATED_FLAG = DECODE( X_VALIDATED_FLAG, NULL, VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', X_VALIDATED_FLAG ),
513: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
514: CREATION_DATE = CREATION_DATE,
515: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
516: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

Line 522: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

518: CREATED_BY = CREATED_BY,
519: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
520: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
521: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
522: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
523: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
524: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
525: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
526: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

Line 523: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

519: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
520: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
521: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
522: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
523: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
524: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
525: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
526: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
527: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

Line 524: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

520: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
521: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
522: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
523: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
524: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
525: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
526: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
527: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
528: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

Line 525: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

521: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
522: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
523: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
524: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
525: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
526: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
527: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
528: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
529: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

Line 526: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

522: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
523: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
524: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
525: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
526: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
527: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
528: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
529: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
530: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

Line 527: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

523: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
524: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
525: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
526: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
527: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
528: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
529: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
530: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
531: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

Line 528: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

524: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
525: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
526: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
527: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
528: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
529: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
530: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
531: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
532: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

Line 529: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

525: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
526: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
527: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
528: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
529: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
530: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
531: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
532: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
533: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

Line 530: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

526: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
527: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
528: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
529: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
530: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
531: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
532: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
533: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
534: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

Line 531: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

527: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
528: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
529: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
530: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
531: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
532: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
533: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
534: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
535: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

Line 532: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

528: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
529: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
530: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
531: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
532: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
533: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
534: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
535: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
536: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

Line 533: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

529: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
530: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
531: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
532: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
533: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
534: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
535: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
536: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
537: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

Line 534: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

530: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
531: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
532: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
533: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
534: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
535: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
536: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
537: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
538: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),

Line 535: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

531: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
532: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
533: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
534: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
535: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
536: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
537: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
538: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
539: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),

Line 536: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

532: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
533: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
534: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
535: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
536: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
537: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
538: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
539: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
540: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),

Line 537: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

533: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
534: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
535: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
536: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
537: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
538: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
539: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
540: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
541: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

Line 538: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),

534: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
535: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
536: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
537: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
538: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
539: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
540: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
541: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
542: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),

Line 539: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),

535: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
536: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
537: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
538: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
539: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
540: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
541: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
542: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
543: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),

Line 540: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),

536: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
537: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
538: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
539: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
540: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
541: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
542: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
543: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
544: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),

Line 541: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

537: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
538: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
539: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
540: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
541: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
542: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
543: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
544: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
545: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),

Line 542: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),

538: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
539: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
540: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
541: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
542: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
543: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
544: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
545: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
546: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),

Line 543: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),

539: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
540: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
541: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
542: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
543: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
544: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
545: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
546: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
547: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),

Line 544: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),

540: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
541: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
542: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
543: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
544: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
545: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
546: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
547: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
548: SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),

Line 545: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),

541: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
542: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
543: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
544: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
545: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
546: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
547: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
548: SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
549: HQ_BRANCH_IND = DECODE( X_HQ_BRANCH_IND, NULL, HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),

Line 546: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),

542: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
543: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
544: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
545: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
546: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
547: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
548: SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
549: HQ_BRANCH_IND = DECODE( X_HQ_BRANCH_IND, NULL, HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
550: CUSTOMER_KEY = DECODE( X_CUSTOMER_KEY, NULL, CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),

Line 547: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),

543: ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
544: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
545: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
546: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
547: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
548: SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
549: HQ_BRANCH_IND = DECODE( X_HQ_BRANCH_IND, NULL, HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
550: CUSTOMER_KEY = DECODE( X_CUSTOMER_KEY, NULL, CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
551: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),

Line 548: SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),

544: ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
545: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
546: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
547: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
548: SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
549: HQ_BRANCH_IND = DECODE( X_HQ_BRANCH_IND, NULL, HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
550: CUSTOMER_KEY = DECODE( X_CUSTOMER_KEY, NULL, CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
551: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
552: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),

Line 549: HQ_BRANCH_IND = DECODE( X_HQ_BRANCH_IND, NULL, HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),

545: ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
546: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
547: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
548: SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
549: HQ_BRANCH_IND = DECODE( X_HQ_BRANCH_IND, NULL, HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
550: CUSTOMER_KEY = DECODE( X_CUSTOMER_KEY, NULL, CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
551: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
552: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
553: PERSON_PRE_NAME_ADJUNCT = DECODE( X_PERSON_PRE_NAME_ADJUNCT, NULL, PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),

Line 550: CUSTOMER_KEY = DECODE( X_CUSTOMER_KEY, NULL, CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),

546: ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
547: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
548: SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
549: HQ_BRANCH_IND = DECODE( X_HQ_BRANCH_IND, NULL, HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
550: CUSTOMER_KEY = DECODE( X_CUSTOMER_KEY, NULL, CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
551: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
552: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
553: PERSON_PRE_NAME_ADJUNCT = DECODE( X_PERSON_PRE_NAME_ADJUNCT, NULL, PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
554: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),

Line 551: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),

547: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
548: SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
549: HQ_BRANCH_IND = DECODE( X_HQ_BRANCH_IND, NULL, HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
550: CUSTOMER_KEY = DECODE( X_CUSTOMER_KEY, NULL, CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
551: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
552: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
553: PERSON_PRE_NAME_ADJUNCT = DECODE( X_PERSON_PRE_NAME_ADJUNCT, NULL, PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
554: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
555: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),

Line 552: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),

548: SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
549: HQ_BRANCH_IND = DECODE( X_HQ_BRANCH_IND, NULL, HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
550: CUSTOMER_KEY = DECODE( X_CUSTOMER_KEY, NULL, CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
551: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
552: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
553: PERSON_PRE_NAME_ADJUNCT = DECODE( X_PERSON_PRE_NAME_ADJUNCT, NULL, PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
554: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
555: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
556: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),

Line 553: PERSON_PRE_NAME_ADJUNCT = DECODE( X_PERSON_PRE_NAME_ADJUNCT, NULL, PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),

549: HQ_BRANCH_IND = DECODE( X_HQ_BRANCH_IND, NULL, HQ_BRANCH_IND, FND_API.G_MISS_CHAR, NULL, X_HQ_BRANCH_IND ),
550: CUSTOMER_KEY = DECODE( X_CUSTOMER_KEY, NULL, CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
551: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
552: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
553: PERSON_PRE_NAME_ADJUNCT = DECODE( X_PERSON_PRE_NAME_ADJUNCT, NULL, PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
554: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
555: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
556: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
557: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),

Line 554: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),

550: CUSTOMER_KEY = DECODE( X_CUSTOMER_KEY, NULL, CUSTOMER_KEY, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_KEY ),
551: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
552: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
553: PERSON_PRE_NAME_ADJUNCT = DECODE( X_PERSON_PRE_NAME_ADJUNCT, NULL, PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
554: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
555: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
556: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
557: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
558: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),

Line 555: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),

551: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
552: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
553: PERSON_PRE_NAME_ADJUNCT = DECODE( X_PERSON_PRE_NAME_ADJUNCT, NULL, PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
554: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
555: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
556: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
557: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
558: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
559: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),

Line 556: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),

552: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
553: PERSON_PRE_NAME_ADJUNCT = DECODE( X_PERSON_PRE_NAME_ADJUNCT, NULL, PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
554: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
555: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
556: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
557: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
558: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
559: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
560: PERSON_PREVIOUS_LAST_NAME = DECODE( X_PERSON_PREVIOUS_LAST_NAME, NULL, PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),

Line 557: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),

553: PERSON_PRE_NAME_ADJUNCT = DECODE( X_PERSON_PRE_NAME_ADJUNCT, NULL, PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
554: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
555: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
556: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
557: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
558: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
559: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
560: PERSON_PREVIOUS_LAST_NAME = DECODE( X_PERSON_PREVIOUS_LAST_NAME, NULL, PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
561: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),

Line 558: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),

554: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
555: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
556: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
557: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
558: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
559: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
560: PERSON_PREVIOUS_LAST_NAME = DECODE( X_PERSON_PREVIOUS_LAST_NAME, NULL, PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
561: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
562: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),

Line 559: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),

555: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
556: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
557: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
558: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
559: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
560: PERSON_PREVIOUS_LAST_NAME = DECODE( X_PERSON_PREVIOUS_LAST_NAME, NULL, PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
561: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
562: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
563: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),

Line 560: PERSON_PREVIOUS_LAST_NAME = DECODE( X_PERSON_PREVIOUS_LAST_NAME, NULL, PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),

556: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
557: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
558: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
559: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
560: PERSON_PREVIOUS_LAST_NAME = DECODE( X_PERSON_PREVIOUS_LAST_NAME, NULL, PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
561: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
562: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
563: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
564: GROUP_TYPE = DECODE( X_GROUP_TYPE, NULL, GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),

Line 561: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),

557: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
558: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
559: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
560: PERSON_PREVIOUS_LAST_NAME = DECODE( X_PERSON_PREVIOUS_LAST_NAME, NULL, PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
561: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
562: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
563: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
564: GROUP_TYPE = DECODE( X_GROUP_TYPE, NULL, GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
565: COUNTRY = DECODE( X_COUNTRY, NULL, COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),

Line 562: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),

558: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
559: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
560: PERSON_PREVIOUS_LAST_NAME = DECODE( X_PERSON_PREVIOUS_LAST_NAME, NULL, PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
561: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
562: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
563: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
564: GROUP_TYPE = DECODE( X_GROUP_TYPE, NULL, GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
565: COUNTRY = DECODE( X_COUNTRY, NULL, COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
566: ADDRESS1 = DECODE( X_ADDRESS1, NULL, ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),

Line 563: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),

559: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
560: PERSON_PREVIOUS_LAST_NAME = DECODE( X_PERSON_PREVIOUS_LAST_NAME, NULL, PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
561: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
562: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
563: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
564: GROUP_TYPE = DECODE( X_GROUP_TYPE, NULL, GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
565: COUNTRY = DECODE( X_COUNTRY, NULL, COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
566: ADDRESS1 = DECODE( X_ADDRESS1, NULL, ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
567: ADDRESS2 = DECODE( X_ADDRESS2, NULL, ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),

Line 564: GROUP_TYPE = DECODE( X_GROUP_TYPE, NULL, GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),

560: PERSON_PREVIOUS_LAST_NAME = DECODE( X_PERSON_PREVIOUS_LAST_NAME, NULL, PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
561: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
562: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
563: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
564: GROUP_TYPE = DECODE( X_GROUP_TYPE, NULL, GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
565: COUNTRY = DECODE( X_COUNTRY, NULL, COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
566: ADDRESS1 = DECODE( X_ADDRESS1, NULL, ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
567: ADDRESS2 = DECODE( X_ADDRESS2, NULL, ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
568: ADDRESS3 = DECODE( X_ADDRESS3, NULL, ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),

Line 565: COUNTRY = DECODE( X_COUNTRY, NULL, COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),

561: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
562: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
563: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
564: GROUP_TYPE = DECODE( X_GROUP_TYPE, NULL, GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
565: COUNTRY = DECODE( X_COUNTRY, NULL, COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
566: ADDRESS1 = DECODE( X_ADDRESS1, NULL, ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
567: ADDRESS2 = DECODE( X_ADDRESS2, NULL, ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
568: ADDRESS3 = DECODE( X_ADDRESS3, NULL, ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
569: ADDRESS4 = DECODE( X_ADDRESS4, NULL, ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),

Line 566: ADDRESS1 = DECODE( X_ADDRESS1, NULL, ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),

562: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
563: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
564: GROUP_TYPE = DECODE( X_GROUP_TYPE, NULL, GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
565: COUNTRY = DECODE( X_COUNTRY, NULL, COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
566: ADDRESS1 = DECODE( X_ADDRESS1, NULL, ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
567: ADDRESS2 = DECODE( X_ADDRESS2, NULL, ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
568: ADDRESS3 = DECODE( X_ADDRESS3, NULL, ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
569: ADDRESS4 = DECODE( X_ADDRESS4, NULL, ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
570: CITY = DECODE( X_CITY, NULL, CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),

Line 567: ADDRESS2 = DECODE( X_ADDRESS2, NULL, ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),

563: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
564: GROUP_TYPE = DECODE( X_GROUP_TYPE, NULL, GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
565: COUNTRY = DECODE( X_COUNTRY, NULL, COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
566: ADDRESS1 = DECODE( X_ADDRESS1, NULL, ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
567: ADDRESS2 = DECODE( X_ADDRESS2, NULL, ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
568: ADDRESS3 = DECODE( X_ADDRESS3, NULL, ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
569: ADDRESS4 = DECODE( X_ADDRESS4, NULL, ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
570: CITY = DECODE( X_CITY, NULL, CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
571: POSTAL_CODE = DECODE( X_POSTAL_CODE, NULL, POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),

Line 568: ADDRESS3 = DECODE( X_ADDRESS3, NULL, ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),

564: GROUP_TYPE = DECODE( X_GROUP_TYPE, NULL, GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, X_GROUP_TYPE ),
565: COUNTRY = DECODE( X_COUNTRY, NULL, COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
566: ADDRESS1 = DECODE( X_ADDRESS1, NULL, ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
567: ADDRESS2 = DECODE( X_ADDRESS2, NULL, ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
568: ADDRESS3 = DECODE( X_ADDRESS3, NULL, ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
569: ADDRESS4 = DECODE( X_ADDRESS4, NULL, ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
570: CITY = DECODE( X_CITY, NULL, CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
571: POSTAL_CODE = DECODE( X_POSTAL_CODE, NULL, POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
572: STATE = DECODE( X_STATE, NULL, STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),

Line 569: ADDRESS4 = DECODE( X_ADDRESS4, NULL, ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),

565: COUNTRY = DECODE( X_COUNTRY, NULL, COUNTRY, FND_API.G_MISS_CHAR, NULL, X_COUNTRY ),
566: ADDRESS1 = DECODE( X_ADDRESS1, NULL, ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
567: ADDRESS2 = DECODE( X_ADDRESS2, NULL, ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
568: ADDRESS3 = DECODE( X_ADDRESS3, NULL, ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
569: ADDRESS4 = DECODE( X_ADDRESS4, NULL, ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
570: CITY = DECODE( X_CITY, NULL, CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
571: POSTAL_CODE = DECODE( X_POSTAL_CODE, NULL, POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
572: STATE = DECODE( X_STATE, NULL, STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
573: PROVINCE = DECODE( X_PROVINCE, NULL, PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),

Line 570: CITY = DECODE( X_CITY, NULL, CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),

566: ADDRESS1 = DECODE( X_ADDRESS1, NULL, ADDRESS1, FND_API.G_MISS_CHAR, NULL, X_ADDRESS1 ),
567: ADDRESS2 = DECODE( X_ADDRESS2, NULL, ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
568: ADDRESS3 = DECODE( X_ADDRESS3, NULL, ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
569: ADDRESS4 = DECODE( X_ADDRESS4, NULL, ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
570: CITY = DECODE( X_CITY, NULL, CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
571: POSTAL_CODE = DECODE( X_POSTAL_CODE, NULL, POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
572: STATE = DECODE( X_STATE, NULL, STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
573: PROVINCE = DECODE( X_PROVINCE, NULL, PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
574: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

Line 571: POSTAL_CODE = DECODE( X_POSTAL_CODE, NULL, POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),

567: ADDRESS2 = DECODE( X_ADDRESS2, NULL, ADDRESS2, FND_API.G_MISS_CHAR, NULL, X_ADDRESS2 ),
568: ADDRESS3 = DECODE( X_ADDRESS3, NULL, ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
569: ADDRESS4 = DECODE( X_ADDRESS4, NULL, ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
570: CITY = DECODE( X_CITY, NULL, CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
571: POSTAL_CODE = DECODE( X_POSTAL_CODE, NULL, POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
572: STATE = DECODE( X_STATE, NULL, STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
573: PROVINCE = DECODE( X_PROVINCE, NULL, PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
574: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
575: COUNTY = DECODE( X_COUNTY, NULL, COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),

Line 572: STATE = DECODE( X_STATE, NULL, STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),

568: ADDRESS3 = DECODE( X_ADDRESS3, NULL, ADDRESS3, FND_API.G_MISS_CHAR, NULL, X_ADDRESS3 ),
569: ADDRESS4 = DECODE( X_ADDRESS4, NULL, ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
570: CITY = DECODE( X_CITY, NULL, CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
571: POSTAL_CODE = DECODE( X_POSTAL_CODE, NULL, POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
572: STATE = DECODE( X_STATE, NULL, STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
573: PROVINCE = DECODE( X_PROVINCE, NULL, PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
574: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
575: COUNTY = DECODE( X_COUNTY, NULL, COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
576: SIC_CODE_TYPE = DECODE( X_SIC_CODE_TYPE, NULL, SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),

Line 573: PROVINCE = DECODE( X_PROVINCE, NULL, PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),

569: ADDRESS4 = DECODE( X_ADDRESS4, NULL, ADDRESS4, FND_API.G_MISS_CHAR, NULL, X_ADDRESS4 ),
570: CITY = DECODE( X_CITY, NULL, CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
571: POSTAL_CODE = DECODE( X_POSTAL_CODE, NULL, POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
572: STATE = DECODE( X_STATE, NULL, STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
573: PROVINCE = DECODE( X_PROVINCE, NULL, PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
574: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
575: COUNTY = DECODE( X_COUNTY, NULL, COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
576: SIC_CODE_TYPE = DECODE( X_SIC_CODE_TYPE, NULL, SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
577: URL = DECODE( X_URL, NULL, URL, FND_API.G_MISS_CHAR, NULL, X_URL ),

Line 574: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

570: CITY = DECODE( X_CITY, NULL, CITY, FND_API.G_MISS_CHAR, NULL, X_CITY ),
571: POSTAL_CODE = DECODE( X_POSTAL_CODE, NULL, POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
572: STATE = DECODE( X_STATE, NULL, STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
573: PROVINCE = DECODE( X_PROVINCE, NULL, PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
574: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
575: COUNTY = DECODE( X_COUNTY, NULL, COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
576: SIC_CODE_TYPE = DECODE( X_SIC_CODE_TYPE, NULL, SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
577: URL = DECODE( X_URL, NULL, URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
578: --Bug 4355133

Line 575: COUNTY = DECODE( X_COUNTY, NULL, COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),

571: POSTAL_CODE = DECODE( X_POSTAL_CODE, NULL, POSTAL_CODE, FND_API.G_MISS_CHAR, NULL, X_POSTAL_CODE ),
572: STATE = DECODE( X_STATE, NULL, STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
573: PROVINCE = DECODE( X_PROVINCE, NULL, PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
574: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
575: COUNTY = DECODE( X_COUNTY, NULL, COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
576: SIC_CODE_TYPE = DECODE( X_SIC_CODE_TYPE, NULL, SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
577: URL = DECODE( X_URL, NULL, URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
578: --Bug 4355133
579: EMAIL_ADDRESS = SUBSTRB(DECODE( X_EMAIL_ADDRESS, NULL, EMAIL_ADDRESS,

Line 576: SIC_CODE_TYPE = DECODE( X_SIC_CODE_TYPE, NULL, SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),

572: STATE = DECODE( X_STATE, NULL, STATE, FND_API.G_MISS_CHAR, NULL, X_STATE ),
573: PROVINCE = DECODE( X_PROVINCE, NULL, PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
574: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
575: COUNTY = DECODE( X_COUNTY, NULL, COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
576: SIC_CODE_TYPE = DECODE( X_SIC_CODE_TYPE, NULL, SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
577: URL = DECODE( X_URL, NULL, URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
578: --Bug 4355133
579: EMAIL_ADDRESS = SUBSTRB(DECODE( X_EMAIL_ADDRESS, NULL, EMAIL_ADDRESS,
580: FND_API.G_MISS_CHAR, NULL, X_EMAIL_ADDRESS ),1,320),

Line 577: URL = DECODE( X_URL, NULL, URL, FND_API.G_MISS_CHAR, NULL, X_URL ),

573: PROVINCE = DECODE( X_PROVINCE, NULL, PROVINCE, FND_API.G_MISS_CHAR, NULL, X_PROVINCE ),
574: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
575: COUNTY = DECODE( X_COUNTY, NULL, COUNTY, FND_API.G_MISS_CHAR, NULL, X_COUNTY ),
576: SIC_CODE_TYPE = DECODE( X_SIC_CODE_TYPE, NULL, SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
577: URL = DECODE( X_URL, NULL, URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
578: --Bug 4355133
579: EMAIL_ADDRESS = SUBSTRB(DECODE( X_EMAIL_ADDRESS, NULL, EMAIL_ADDRESS,
580: FND_API.G_MISS_CHAR, NULL, X_EMAIL_ADDRESS ),1,320),
581: ANALYSIS_FY = DECODE( X_ANALYSIS_FY, NULL, ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),

Line 580: FND_API.G_MISS_CHAR, NULL, X_EMAIL_ADDRESS ),1,320),

576: SIC_CODE_TYPE = DECODE( X_SIC_CODE_TYPE, NULL, SIC_CODE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE_TYPE ),
577: URL = DECODE( X_URL, NULL, URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
578: --Bug 4355133
579: EMAIL_ADDRESS = SUBSTRB(DECODE( X_EMAIL_ADDRESS, NULL, EMAIL_ADDRESS,
580: FND_API.G_MISS_CHAR, NULL, X_EMAIL_ADDRESS ),1,320),
581: ANALYSIS_FY = DECODE( X_ANALYSIS_FY, NULL, ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
582: FISCAL_YEAREND_MONTH = DECODE( X_FISCAL_YEAREND_MONTH, NULL, FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
583: EMPLOYEES_TOTAL = DECODE( X_EMPLOYEES_TOTAL, NULL, EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
584: CURR_FY_POTENTIAL_REVENUE = DECODE( X_CURR_FY_POTENTIAL_REVENUE, NULL, CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),

Line 581: ANALYSIS_FY = DECODE( X_ANALYSIS_FY, NULL, ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),

577: URL = DECODE( X_URL, NULL, URL, FND_API.G_MISS_CHAR, NULL, X_URL ),
578: --Bug 4355133
579: EMAIL_ADDRESS = SUBSTRB(DECODE( X_EMAIL_ADDRESS, NULL, EMAIL_ADDRESS,
580: FND_API.G_MISS_CHAR, NULL, X_EMAIL_ADDRESS ),1,320),
581: ANALYSIS_FY = DECODE( X_ANALYSIS_FY, NULL, ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
582: FISCAL_YEAREND_MONTH = DECODE( X_FISCAL_YEAREND_MONTH, NULL, FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
583: EMPLOYEES_TOTAL = DECODE( X_EMPLOYEES_TOTAL, NULL, EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
584: CURR_FY_POTENTIAL_REVENUE = DECODE( X_CURR_FY_POTENTIAL_REVENUE, NULL, CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
585: NEXT_FY_POTENTIAL_REVENUE = DECODE( X_NEXT_FY_POTENTIAL_REVENUE, NULL, NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),

Line 582: FISCAL_YEAREND_MONTH = DECODE( X_FISCAL_YEAREND_MONTH, NULL, FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),

578: --Bug 4355133
579: EMAIL_ADDRESS = SUBSTRB(DECODE( X_EMAIL_ADDRESS, NULL, EMAIL_ADDRESS,
580: FND_API.G_MISS_CHAR, NULL, X_EMAIL_ADDRESS ),1,320),
581: ANALYSIS_FY = DECODE( X_ANALYSIS_FY, NULL, ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
582: FISCAL_YEAREND_MONTH = DECODE( X_FISCAL_YEAREND_MONTH, NULL, FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
583: EMPLOYEES_TOTAL = DECODE( X_EMPLOYEES_TOTAL, NULL, EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
584: CURR_FY_POTENTIAL_REVENUE = DECODE( X_CURR_FY_POTENTIAL_REVENUE, NULL, CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
585: NEXT_FY_POTENTIAL_REVENUE = DECODE( X_NEXT_FY_POTENTIAL_REVENUE, NULL, NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
586: YEAR_ESTABLISHED = DECODE( X_YEAR_ESTABLISHED, NULL, YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),

Line 583: EMPLOYEES_TOTAL = DECODE( X_EMPLOYEES_TOTAL, NULL, EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),

579: EMAIL_ADDRESS = SUBSTRB(DECODE( X_EMAIL_ADDRESS, NULL, EMAIL_ADDRESS,
580: FND_API.G_MISS_CHAR, NULL, X_EMAIL_ADDRESS ),1,320),
581: ANALYSIS_FY = DECODE( X_ANALYSIS_FY, NULL, ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
582: FISCAL_YEAREND_MONTH = DECODE( X_FISCAL_YEAREND_MONTH, NULL, FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
583: EMPLOYEES_TOTAL = DECODE( X_EMPLOYEES_TOTAL, NULL, EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
584: CURR_FY_POTENTIAL_REVENUE = DECODE( X_CURR_FY_POTENTIAL_REVENUE, NULL, CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
585: NEXT_FY_POTENTIAL_REVENUE = DECODE( X_NEXT_FY_POTENTIAL_REVENUE, NULL, NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
586: YEAR_ESTABLISHED = DECODE( X_YEAR_ESTABLISHED, NULL, YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
587: GSA_INDICATOR_FLAG = DECODE( X_GSA_INDICATOR_FLAG, NULL, GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),

Line 584: CURR_FY_POTENTIAL_REVENUE = DECODE( X_CURR_FY_POTENTIAL_REVENUE, NULL, CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),

580: FND_API.G_MISS_CHAR, NULL, X_EMAIL_ADDRESS ),1,320),
581: ANALYSIS_FY = DECODE( X_ANALYSIS_FY, NULL, ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
582: FISCAL_YEAREND_MONTH = DECODE( X_FISCAL_YEAREND_MONTH, NULL, FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
583: EMPLOYEES_TOTAL = DECODE( X_EMPLOYEES_TOTAL, NULL, EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
584: CURR_FY_POTENTIAL_REVENUE = DECODE( X_CURR_FY_POTENTIAL_REVENUE, NULL, CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
585: NEXT_FY_POTENTIAL_REVENUE = DECODE( X_NEXT_FY_POTENTIAL_REVENUE, NULL, NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
586: YEAR_ESTABLISHED = DECODE( X_YEAR_ESTABLISHED, NULL, YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
587: GSA_INDICATOR_FLAG = DECODE( X_GSA_INDICATOR_FLAG, NULL, GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
588: MISSION_STATEMENT = DECODE( X_MISSION_STATEMENT, NULL, MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),

Line 585: NEXT_FY_POTENTIAL_REVENUE = DECODE( X_NEXT_FY_POTENTIAL_REVENUE, NULL, NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),

581: ANALYSIS_FY = DECODE( X_ANALYSIS_FY, NULL, ANALYSIS_FY, FND_API.G_MISS_CHAR, NULL, X_ANALYSIS_FY ),
582: FISCAL_YEAREND_MONTH = DECODE( X_FISCAL_YEAREND_MONTH, NULL, FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
583: EMPLOYEES_TOTAL = DECODE( X_EMPLOYEES_TOTAL, NULL, EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
584: CURR_FY_POTENTIAL_REVENUE = DECODE( X_CURR_FY_POTENTIAL_REVENUE, NULL, CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
585: NEXT_FY_POTENTIAL_REVENUE = DECODE( X_NEXT_FY_POTENTIAL_REVENUE, NULL, NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
586: YEAR_ESTABLISHED = DECODE( X_YEAR_ESTABLISHED, NULL, YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
587: GSA_INDICATOR_FLAG = DECODE( X_GSA_INDICATOR_FLAG, NULL, GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
588: MISSION_STATEMENT = DECODE( X_MISSION_STATEMENT, NULL, MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
589: ORGANIZATION_NAME_PHONETIC = DECODE( X_ORGANIZATION_NAME_PHONETIC, NULL, ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),

Line 586: YEAR_ESTABLISHED = DECODE( X_YEAR_ESTABLISHED, NULL, YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),

582: FISCAL_YEAREND_MONTH = DECODE( X_FISCAL_YEAREND_MONTH, NULL, FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR, NULL, X_FISCAL_YEAREND_MONTH ),
583: EMPLOYEES_TOTAL = DECODE( X_EMPLOYEES_TOTAL, NULL, EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
584: CURR_FY_POTENTIAL_REVENUE = DECODE( X_CURR_FY_POTENTIAL_REVENUE, NULL, CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
585: NEXT_FY_POTENTIAL_REVENUE = DECODE( X_NEXT_FY_POTENTIAL_REVENUE, NULL, NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
586: YEAR_ESTABLISHED = DECODE( X_YEAR_ESTABLISHED, NULL, YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
587: GSA_INDICATOR_FLAG = DECODE( X_GSA_INDICATOR_FLAG, NULL, GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
588: MISSION_STATEMENT = DECODE( X_MISSION_STATEMENT, NULL, MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
589: ORGANIZATION_NAME_PHONETIC = DECODE( X_ORGANIZATION_NAME_PHONETIC, NULL, ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
590: PERSON_FIRST_NAME_PHONETIC = DECODE( X_PERSON_FIRST_NAME_PHONETIC, NULL, PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),

Line 587: GSA_INDICATOR_FLAG = DECODE( X_GSA_INDICATOR_FLAG, NULL, GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),

583: EMPLOYEES_TOTAL = DECODE( X_EMPLOYEES_TOTAL, NULL, EMPLOYEES_TOTAL, FND_API.G_MISS_NUM, NULL, X_EMPLOYEES_TOTAL ),
584: CURR_FY_POTENTIAL_REVENUE = DECODE( X_CURR_FY_POTENTIAL_REVENUE, NULL, CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
585: NEXT_FY_POTENTIAL_REVENUE = DECODE( X_NEXT_FY_POTENTIAL_REVENUE, NULL, NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
586: YEAR_ESTABLISHED = DECODE( X_YEAR_ESTABLISHED, NULL, YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
587: GSA_INDICATOR_FLAG = DECODE( X_GSA_INDICATOR_FLAG, NULL, GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
588: MISSION_STATEMENT = DECODE( X_MISSION_STATEMENT, NULL, MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
589: ORGANIZATION_NAME_PHONETIC = DECODE( X_ORGANIZATION_NAME_PHONETIC, NULL, ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
590: PERSON_FIRST_NAME_PHONETIC = DECODE( X_PERSON_FIRST_NAME_PHONETIC, NULL, PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
591: PERSON_LAST_NAME_PHONETIC = DECODE( X_PERSON_LAST_NAME_PHONETIC, NULL, PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),

Line 588: MISSION_STATEMENT = DECODE( X_MISSION_STATEMENT, NULL, MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),

584: CURR_FY_POTENTIAL_REVENUE = DECODE( X_CURR_FY_POTENTIAL_REVENUE, NULL, CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_CURR_FY_POTENTIAL_REVENUE ),
585: NEXT_FY_POTENTIAL_REVENUE = DECODE( X_NEXT_FY_POTENTIAL_REVENUE, NULL, NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
586: YEAR_ESTABLISHED = DECODE( X_YEAR_ESTABLISHED, NULL, YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
587: GSA_INDICATOR_FLAG = DECODE( X_GSA_INDICATOR_FLAG, NULL, GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
588: MISSION_STATEMENT = DECODE( X_MISSION_STATEMENT, NULL, MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
589: ORGANIZATION_NAME_PHONETIC = DECODE( X_ORGANIZATION_NAME_PHONETIC, NULL, ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
590: PERSON_FIRST_NAME_PHONETIC = DECODE( X_PERSON_FIRST_NAME_PHONETIC, NULL, PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
591: PERSON_LAST_NAME_PHONETIC = DECODE( X_PERSON_LAST_NAME_PHONETIC, NULL, PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
592: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),

Line 589: ORGANIZATION_NAME_PHONETIC = DECODE( X_ORGANIZATION_NAME_PHONETIC, NULL, ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),

585: NEXT_FY_POTENTIAL_REVENUE = DECODE( X_NEXT_FY_POTENTIAL_REVENUE, NULL, NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM, NULL, X_NEXT_FY_POTENTIAL_REVENUE ),
586: YEAR_ESTABLISHED = DECODE( X_YEAR_ESTABLISHED, NULL, YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
587: GSA_INDICATOR_FLAG = DECODE( X_GSA_INDICATOR_FLAG, NULL, GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
588: MISSION_STATEMENT = DECODE( X_MISSION_STATEMENT, NULL, MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
589: ORGANIZATION_NAME_PHONETIC = DECODE( X_ORGANIZATION_NAME_PHONETIC, NULL, ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
590: PERSON_FIRST_NAME_PHONETIC = DECODE( X_PERSON_FIRST_NAME_PHONETIC, NULL, PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
591: PERSON_LAST_NAME_PHONETIC = DECODE( X_PERSON_LAST_NAME_PHONETIC, NULL, PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
592: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
593: CATEGORY_CODE = DECODE( X_CATEGORY_CODE, NULL, CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),

Line 590: PERSON_FIRST_NAME_PHONETIC = DECODE( X_PERSON_FIRST_NAME_PHONETIC, NULL, PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),

586: YEAR_ESTABLISHED = DECODE( X_YEAR_ESTABLISHED, NULL, YEAR_ESTABLISHED, FND_API.G_MISS_NUM, NULL, X_YEAR_ESTABLISHED ),
587: GSA_INDICATOR_FLAG = DECODE( X_GSA_INDICATOR_FLAG, NULL, GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
588: MISSION_STATEMENT = DECODE( X_MISSION_STATEMENT, NULL, MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
589: ORGANIZATION_NAME_PHONETIC = DECODE( X_ORGANIZATION_NAME_PHONETIC, NULL, ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
590: PERSON_FIRST_NAME_PHONETIC = DECODE( X_PERSON_FIRST_NAME_PHONETIC, NULL, PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
591: PERSON_LAST_NAME_PHONETIC = DECODE( X_PERSON_LAST_NAME_PHONETIC, NULL, PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
592: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
593: CATEGORY_CODE = DECODE( X_CATEGORY_CODE, NULL, CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
594: SALUTATION = DECODE( X_SALUTATION, NULL, SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),

Line 591: PERSON_LAST_NAME_PHONETIC = DECODE( X_PERSON_LAST_NAME_PHONETIC, NULL, PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),

587: GSA_INDICATOR_FLAG = DECODE( X_GSA_INDICATOR_FLAG, NULL, GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR, NULL, X_GSA_INDICATOR_FLAG ),
588: MISSION_STATEMENT = DECODE( X_MISSION_STATEMENT, NULL, MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
589: ORGANIZATION_NAME_PHONETIC = DECODE( X_ORGANIZATION_NAME_PHONETIC, NULL, ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
590: PERSON_FIRST_NAME_PHONETIC = DECODE( X_PERSON_FIRST_NAME_PHONETIC, NULL, PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
591: PERSON_LAST_NAME_PHONETIC = DECODE( X_PERSON_LAST_NAME_PHONETIC, NULL, PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
592: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
593: CATEGORY_CODE = DECODE( X_CATEGORY_CODE, NULL, CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
594: SALUTATION = DECODE( X_SALUTATION, NULL, SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
595: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),

Line 592: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),

588: MISSION_STATEMENT = DECODE( X_MISSION_STATEMENT, NULL, MISSION_STATEMENT, FND_API.G_MISS_CHAR, NULL, X_MISSION_STATEMENT ),
589: ORGANIZATION_NAME_PHONETIC = DECODE( X_ORGANIZATION_NAME_PHONETIC, NULL, ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
590: PERSON_FIRST_NAME_PHONETIC = DECODE( X_PERSON_FIRST_NAME_PHONETIC, NULL, PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
591: PERSON_LAST_NAME_PHONETIC = DECODE( X_PERSON_LAST_NAME_PHONETIC, NULL, PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
592: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
593: CATEGORY_CODE = DECODE( X_CATEGORY_CODE, NULL, CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
594: SALUTATION = DECODE( X_SALUTATION, NULL, SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
595: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
596: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),

Line 593: CATEGORY_CODE = DECODE( X_CATEGORY_CODE, NULL, CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),

589: ORGANIZATION_NAME_PHONETIC = DECODE( X_ORGANIZATION_NAME_PHONETIC, NULL, ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_ORGANIZATION_NAME_PHONETIC ),
590: PERSON_FIRST_NAME_PHONETIC = DECODE( X_PERSON_FIRST_NAME_PHONETIC, NULL, PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
591: PERSON_LAST_NAME_PHONETIC = DECODE( X_PERSON_LAST_NAME_PHONETIC, NULL, PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
592: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
593: CATEGORY_CODE = DECODE( X_CATEGORY_CODE, NULL, CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
594: SALUTATION = DECODE( X_SALUTATION, NULL, SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
595: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
596: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
597: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),

Line 594: SALUTATION = DECODE( X_SALUTATION, NULL, SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),

590: PERSON_FIRST_NAME_PHONETIC = DECODE( X_PERSON_FIRST_NAME_PHONETIC, NULL, PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
591: PERSON_LAST_NAME_PHONETIC = DECODE( X_PERSON_LAST_NAME_PHONETIC, NULL, PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
592: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
593: CATEGORY_CODE = DECODE( X_CATEGORY_CODE, NULL, CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
594: SALUTATION = DECODE( X_SALUTATION, NULL, SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
595: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
596: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
597: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
598: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),

Line 595: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),

591: PERSON_LAST_NAME_PHONETIC = DECODE( X_PERSON_LAST_NAME_PHONETIC, NULL, PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
592: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
593: CATEGORY_CODE = DECODE( X_CATEGORY_CODE, NULL, CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
594: SALUTATION = DECODE( X_SALUTATION, NULL, SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
595: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
596: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
597: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
598: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
599: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 596: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),

592: LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
593: CATEGORY_CODE = DECODE( X_CATEGORY_CODE, NULL, CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
594: SALUTATION = DECODE( X_SALUTATION, NULL, SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
595: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
596: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
597: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
598: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
599: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
600: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(L_DUNS_NUMBER_C)),

Line 597: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),

593: CATEGORY_CODE = DECODE( X_CATEGORY_CODE, NULL, CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CATEGORY_CODE ),
594: SALUTATION = DECODE( X_SALUTATION, NULL, SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
595: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
596: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
597: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
598: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
599: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
600: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(L_DUNS_NUMBER_C)),
601: DUNS_NUMBER = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER,/* Bug 3435702 FND_API.G_MISS_CHAR, NULL,*/ l_duns_number ),

Line 598: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),

594: SALUTATION = DECODE( X_SALUTATION, NULL, SALUTATION, FND_API.G_MISS_CHAR, NULL, X_SALUTATION ),
595: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
596: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
597: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
598: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
599: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
600: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(L_DUNS_NUMBER_C)),
601: DUNS_NUMBER = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER,/* Bug 3435702 FND_API.G_MISS_CHAR, NULL,*/ l_duns_number ),
602: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 599: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

595: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
596: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
597: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
598: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
599: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
600: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(L_DUNS_NUMBER_C)),
601: DUNS_NUMBER = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER,/* Bug 3435702 FND_API.G_MISS_CHAR, NULL,*/ l_duns_number ),
602: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
603: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

Line 600: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/Bug 3435702/ UPPER(L_DUNS_NUMBER_C)),

596: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
597: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
598: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
599: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
600: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(L_DUNS_NUMBER_C)),
601: DUNS_NUMBER = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER,/* Bug 3435702 FND_API.G_MISS_CHAR, NULL,*/ l_duns_number ),
602: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
603: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
604: WHERE ROWID = X_RowId;

Line 601: DUNS_NUMBER = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER,/* Bug 3435702 FND_API.G_MISS_CHAR, NULL,*/ l_duns_number ),

597: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
598: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
599: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
600: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(L_DUNS_NUMBER_C)),
601: DUNS_NUMBER = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER,/* Bug 3435702 FND_API.G_MISS_CHAR, NULL,*/ l_duns_number ),
602: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
603: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
604: WHERE ROWID = X_RowId;
605:

Line 602: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

598: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
599: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
600: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(L_DUNS_NUMBER_C)),
601: DUNS_NUMBER = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER,/* Bug 3435702 FND_API.G_MISS_CHAR, NULL,*/ l_duns_number ),
602: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
603: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
604: WHERE ROWID = X_RowId;
605:
606: IF ( SQL%NOTFOUND ) THEN

Line 603: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

599: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
600: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL,/*Bug 3435702*/ UPPER(L_DUNS_NUMBER_C)),
601: DUNS_NUMBER = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER,/* Bug 3435702 FND_API.G_MISS_CHAR, NULL,*/ l_duns_number ),
602: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
603: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
604: WHERE ROWID = X_RowId;
605:
606: IF ( SQL%NOTFOUND ) THEN
607: RAISE NO_DATA_FOUND;

Line 1104: NVL( PARTY_ID, FND_API.G_MISS_NUM ),

1100:
1101: BEGIN
1102:
1103: SELECT
1104: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
1105: NVL( PARTY_NUMBER, FND_API.G_MISS_CHAR ),
1106: NVL( PARTY_NAME, FND_API.G_MISS_CHAR ),
1107: NVL( PARTY_TYPE, FND_API.G_MISS_CHAR ),
1108: NVL( VALIDATED_FLAG, FND_API.G_MISS_CHAR ),

Line 1105: NVL( PARTY_NUMBER, FND_API.G_MISS_CHAR ),

1101: BEGIN
1102:
1103: SELECT
1104: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
1105: NVL( PARTY_NUMBER, FND_API.G_MISS_CHAR ),
1106: NVL( PARTY_NAME, FND_API.G_MISS_CHAR ),
1107: NVL( PARTY_TYPE, FND_API.G_MISS_CHAR ),
1108: NVL( VALIDATED_FLAG, FND_API.G_MISS_CHAR ),
1109: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),

Line 1106: NVL( PARTY_NAME, FND_API.G_MISS_CHAR ),

1102:
1103: SELECT
1104: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
1105: NVL( PARTY_NUMBER, FND_API.G_MISS_CHAR ),
1106: NVL( PARTY_NAME, FND_API.G_MISS_CHAR ),
1107: NVL( PARTY_TYPE, FND_API.G_MISS_CHAR ),
1108: NVL( VALIDATED_FLAG, FND_API.G_MISS_CHAR ),
1109: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1110: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),

Line 1107: NVL( PARTY_TYPE, FND_API.G_MISS_CHAR ),

1103: SELECT
1104: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
1105: NVL( PARTY_NUMBER, FND_API.G_MISS_CHAR ),
1106: NVL( PARTY_NAME, FND_API.G_MISS_CHAR ),
1107: NVL( PARTY_TYPE, FND_API.G_MISS_CHAR ),
1108: NVL( VALIDATED_FLAG, FND_API.G_MISS_CHAR ),
1109: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1110: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1111: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),

Line 1108: NVL( VALIDATED_FLAG, FND_API.G_MISS_CHAR ),

1104: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
1105: NVL( PARTY_NUMBER, FND_API.G_MISS_CHAR ),
1106: NVL( PARTY_NAME, FND_API.G_MISS_CHAR ),
1107: NVL( PARTY_TYPE, FND_API.G_MISS_CHAR ),
1108: NVL( VALIDATED_FLAG, FND_API.G_MISS_CHAR ),
1109: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1110: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1111: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1112: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),

Line 1109: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),

1105: NVL( PARTY_NUMBER, FND_API.G_MISS_CHAR ),
1106: NVL( PARTY_NAME, FND_API.G_MISS_CHAR ),
1107: NVL( PARTY_TYPE, FND_API.G_MISS_CHAR ),
1108: NVL( VALIDATED_FLAG, FND_API.G_MISS_CHAR ),
1109: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1110: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1111: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1112: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1113: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),

Line 1110: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),

1106: NVL( PARTY_NAME, FND_API.G_MISS_CHAR ),
1107: NVL( PARTY_TYPE, FND_API.G_MISS_CHAR ),
1108: NVL( VALIDATED_FLAG, FND_API.G_MISS_CHAR ),
1109: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1110: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1111: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1112: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1113: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1114: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),

Line 1111: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),

1107: NVL( PARTY_TYPE, FND_API.G_MISS_CHAR ),
1108: NVL( VALIDATED_FLAG, FND_API.G_MISS_CHAR ),
1109: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1110: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1111: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1112: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1113: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1114: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1115: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),

Line 1112: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),

1108: NVL( VALIDATED_FLAG, FND_API.G_MISS_CHAR ),
1109: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1110: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1111: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1112: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1113: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1114: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1115: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1116: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),

Line 1113: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),

1109: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
1110: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1111: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1112: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1113: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1114: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1115: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1116: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1117: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),

Line 1114: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),

1110: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
1111: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1112: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1113: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1114: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1115: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1116: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1117: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1118: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),

Line 1115: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),

1111: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
1112: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1113: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1114: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1115: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1116: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1117: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1118: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1119: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),

Line 1116: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),

1112: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
1113: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1114: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1115: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1116: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1117: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1118: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1119: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1120: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),

Line 1117: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),

1113: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
1114: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1115: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1116: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1117: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1118: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1119: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1120: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1121: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),

Line 1118: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),

1114: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
1115: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1116: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1117: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1118: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1119: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1120: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1121: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1122: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),

Line 1119: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),

1115: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
1116: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1117: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1118: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1119: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1120: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1121: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1122: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1123: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),

Line 1120: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),

1116: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
1117: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1118: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1119: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1120: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1121: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1122: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1123: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1124: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),

Line 1121: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),

1117: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
1118: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1119: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1120: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1121: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1122: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1123: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1124: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1125: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),

Line 1122: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),

1118: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
1119: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1120: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1121: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1122: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1123: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1124: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1125: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1126: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),

Line 1123: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),

1119: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
1120: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1121: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1122: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1123: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1124: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1125: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1126: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1127: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),

Line 1124: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),

1120: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
1121: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1122: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1123: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1124: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1125: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1126: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1127: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1128: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),

Line 1125: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),

1121: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
1122: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1123: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1124: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1125: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1126: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1127: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1128: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1129: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),

Line 1126: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),

1122: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
1123: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1124: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1125: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1126: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1127: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1128: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1129: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1130: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),

Line 1127: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),

1123: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
1124: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1125: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1126: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1127: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1128: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1129: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1130: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
1131: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),

Line 1128: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),

1124: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
1125: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1126: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1127: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1128: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1129: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1130: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
1131: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
1132: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),

Line 1129: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),

1125: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
1126: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1127: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1128: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1129: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1130: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
1131: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
1132: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
1133: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),

Line 1130: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),

1126: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
1127: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1128: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1129: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1130: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
1131: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
1132: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
1133: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
1134: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),

Line 1131: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),

1127: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
1128: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1129: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1130: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
1131: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
1132: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
1133: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
1134: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
1135: NVL( SIC_CODE, FND_API.G_MISS_CHAR ),

Line 1132: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),

1128: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
1129: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1130: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
1131: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
1132: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
1133: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
1134: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
1135: NVL( SIC_CODE, FND_API.G_MISS_CHAR ),
1136: NVL( HQ_BRANCH_IND, FND_API.G_MISS_CHAR ),

Line 1133: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),

1129: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
1130: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
1131: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
1132: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
1133: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
1134: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
1135: NVL( SIC_CODE, FND_API.G_MISS_CHAR ),
1136: NVL( HQ_BRANCH_IND, FND_API.G_MISS_CHAR ),
1137: NVL( CUSTOMER_KEY, FND_API.G_MISS_CHAR ),

Line 1134: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),

1130: NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
1131: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
1132: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
1133: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
1134: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
1135: NVL( SIC_CODE, FND_API.G_MISS_CHAR ),
1136: NVL( HQ_BRANCH_IND, FND_API.G_MISS_CHAR ),
1137: NVL( CUSTOMER_KEY, FND_API.G_MISS_CHAR ),
1138: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),

Line 1135: NVL( SIC_CODE, FND_API.G_MISS_CHAR ),

1131: NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
1132: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
1133: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
1134: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
1135: NVL( SIC_CODE, FND_API.G_MISS_CHAR ),
1136: NVL( HQ_BRANCH_IND, FND_API.G_MISS_CHAR ),
1137: NVL( CUSTOMER_KEY, FND_API.G_MISS_CHAR ),
1138: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
1139: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),

Line 1136: NVL( HQ_BRANCH_IND, FND_API.G_MISS_CHAR ),

1132: NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
1133: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
1134: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
1135: NVL( SIC_CODE, FND_API.G_MISS_CHAR ),
1136: NVL( HQ_BRANCH_IND, FND_API.G_MISS_CHAR ),
1137: NVL( CUSTOMER_KEY, FND_API.G_MISS_CHAR ),
1138: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
1139: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
1140: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),

Line 1137: NVL( CUSTOMER_KEY, FND_API.G_MISS_CHAR ),

1133: NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
1134: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
1135: NVL( SIC_CODE, FND_API.G_MISS_CHAR ),
1136: NVL( HQ_BRANCH_IND, FND_API.G_MISS_CHAR ),
1137: NVL( CUSTOMER_KEY, FND_API.G_MISS_CHAR ),
1138: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
1139: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
1140: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
1141: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),

Line 1138: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),

1134: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
1135: NVL( SIC_CODE, FND_API.G_MISS_CHAR ),
1136: NVL( HQ_BRANCH_IND, FND_API.G_MISS_CHAR ),
1137: NVL( CUSTOMER_KEY, FND_API.G_MISS_CHAR ),
1138: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
1139: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
1140: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
1141: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
1142: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),

Line 1139: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),

1135: NVL( SIC_CODE, FND_API.G_MISS_CHAR ),
1136: NVL( HQ_BRANCH_IND, FND_API.G_MISS_CHAR ),
1137: NVL( CUSTOMER_KEY, FND_API.G_MISS_CHAR ),
1138: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
1139: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
1140: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
1141: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
1142: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
1143: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),

Line 1140: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),

1136: NVL( HQ_BRANCH_IND, FND_API.G_MISS_CHAR ),
1137: NVL( CUSTOMER_KEY, FND_API.G_MISS_CHAR ),
1138: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
1139: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
1140: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
1141: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
1142: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
1143: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
1144: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),

Line 1141: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),

1137: NVL( CUSTOMER_KEY, FND_API.G_MISS_CHAR ),
1138: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
1139: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
1140: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
1141: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
1142: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
1143: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
1144: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
1145: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),

Line 1142: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),

1138: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
1139: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
1140: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
1141: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
1142: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
1143: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
1144: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
1145: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
1146: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),

Line 1143: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),

1139: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
1140: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
1141: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
1142: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
1143: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
1144: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
1145: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
1146: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
1147: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),

Line 1144: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),

1140: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
1141: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
1142: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
1143: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
1144: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
1145: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
1146: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
1147: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
1148: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),

Line 1145: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),

1141: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
1142: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
1143: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
1144: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
1145: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
1146: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
1147: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
1148: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
1149: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),

Line 1146: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),

1142: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
1143: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
1144: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
1145: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
1146: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
1147: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
1148: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
1149: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
1150: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),

Line 1147: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),

1143: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
1144: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
1145: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
1146: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
1147: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
1148: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
1149: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
1150: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
1151: NVL( GROUP_TYPE, FND_API.G_MISS_CHAR ),

Line 1148: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),

1144: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
1145: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
1146: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
1147: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
1148: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
1149: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
1150: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
1151: NVL( GROUP_TYPE, FND_API.G_MISS_CHAR ),
1152: NVL( COUNTRY, FND_API.G_MISS_CHAR ),

Line 1149: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),

1145: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
1146: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
1147: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
1148: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
1149: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
1150: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
1151: NVL( GROUP_TYPE, FND_API.G_MISS_CHAR ),
1152: NVL( COUNTRY, FND_API.G_MISS_CHAR ),
1153: NVL( ADDRESS1, FND_API.G_MISS_CHAR ),

Line 1150: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),

1146: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
1147: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
1148: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
1149: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
1150: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
1151: NVL( GROUP_TYPE, FND_API.G_MISS_CHAR ),
1152: NVL( COUNTRY, FND_API.G_MISS_CHAR ),
1153: NVL( ADDRESS1, FND_API.G_MISS_CHAR ),
1154: NVL( ADDRESS2, FND_API.G_MISS_CHAR ),

Line 1151: NVL( GROUP_TYPE, FND_API.G_MISS_CHAR ),

1147: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
1148: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
1149: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
1150: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
1151: NVL( GROUP_TYPE, FND_API.G_MISS_CHAR ),
1152: NVL( COUNTRY, FND_API.G_MISS_CHAR ),
1153: NVL( ADDRESS1, FND_API.G_MISS_CHAR ),
1154: NVL( ADDRESS2, FND_API.G_MISS_CHAR ),
1155: NVL( ADDRESS3, FND_API.G_MISS_CHAR ),

Line 1152: NVL( COUNTRY, FND_API.G_MISS_CHAR ),

1148: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
1149: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
1150: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
1151: NVL( GROUP_TYPE, FND_API.G_MISS_CHAR ),
1152: NVL( COUNTRY, FND_API.G_MISS_CHAR ),
1153: NVL( ADDRESS1, FND_API.G_MISS_CHAR ),
1154: NVL( ADDRESS2, FND_API.G_MISS_CHAR ),
1155: NVL( ADDRESS3, FND_API.G_MISS_CHAR ),
1156: NVL( ADDRESS4, FND_API.G_MISS_CHAR ),

Line 1153: NVL( ADDRESS1, FND_API.G_MISS_CHAR ),

1149: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
1150: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
1151: NVL( GROUP_TYPE, FND_API.G_MISS_CHAR ),
1152: NVL( COUNTRY, FND_API.G_MISS_CHAR ),
1153: NVL( ADDRESS1, FND_API.G_MISS_CHAR ),
1154: NVL( ADDRESS2, FND_API.G_MISS_CHAR ),
1155: NVL( ADDRESS3, FND_API.G_MISS_CHAR ),
1156: NVL( ADDRESS4, FND_API.G_MISS_CHAR ),
1157: NVL( CITY, FND_API.G_MISS_CHAR ),

Line 1154: NVL( ADDRESS2, FND_API.G_MISS_CHAR ),

1150: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
1151: NVL( GROUP_TYPE, FND_API.G_MISS_CHAR ),
1152: NVL( COUNTRY, FND_API.G_MISS_CHAR ),
1153: NVL( ADDRESS1, FND_API.G_MISS_CHAR ),
1154: NVL( ADDRESS2, FND_API.G_MISS_CHAR ),
1155: NVL( ADDRESS3, FND_API.G_MISS_CHAR ),
1156: NVL( ADDRESS4, FND_API.G_MISS_CHAR ),
1157: NVL( CITY, FND_API.G_MISS_CHAR ),
1158: NVL( POSTAL_CODE, FND_API.G_MISS_CHAR ),

Line 1155: NVL( ADDRESS3, FND_API.G_MISS_CHAR ),

1151: NVL( GROUP_TYPE, FND_API.G_MISS_CHAR ),
1152: NVL( COUNTRY, FND_API.G_MISS_CHAR ),
1153: NVL( ADDRESS1, FND_API.G_MISS_CHAR ),
1154: NVL( ADDRESS2, FND_API.G_MISS_CHAR ),
1155: NVL( ADDRESS3, FND_API.G_MISS_CHAR ),
1156: NVL( ADDRESS4, FND_API.G_MISS_CHAR ),
1157: NVL( CITY, FND_API.G_MISS_CHAR ),
1158: NVL( POSTAL_CODE, FND_API.G_MISS_CHAR ),
1159: NVL( STATE, FND_API.G_MISS_CHAR ),

Line 1156: NVL( ADDRESS4, FND_API.G_MISS_CHAR ),

1152: NVL( COUNTRY, FND_API.G_MISS_CHAR ),
1153: NVL( ADDRESS1, FND_API.G_MISS_CHAR ),
1154: NVL( ADDRESS2, FND_API.G_MISS_CHAR ),
1155: NVL( ADDRESS3, FND_API.G_MISS_CHAR ),
1156: NVL( ADDRESS4, FND_API.G_MISS_CHAR ),
1157: NVL( CITY, FND_API.G_MISS_CHAR ),
1158: NVL( POSTAL_CODE, FND_API.G_MISS_CHAR ),
1159: NVL( STATE, FND_API.G_MISS_CHAR ),
1160: NVL( PROVINCE, FND_API.G_MISS_CHAR ),

Line 1157: NVL( CITY, FND_API.G_MISS_CHAR ),

1153: NVL( ADDRESS1, FND_API.G_MISS_CHAR ),
1154: NVL( ADDRESS2, FND_API.G_MISS_CHAR ),
1155: NVL( ADDRESS3, FND_API.G_MISS_CHAR ),
1156: NVL( ADDRESS4, FND_API.G_MISS_CHAR ),
1157: NVL( CITY, FND_API.G_MISS_CHAR ),
1158: NVL( POSTAL_CODE, FND_API.G_MISS_CHAR ),
1159: NVL( STATE, FND_API.G_MISS_CHAR ),
1160: NVL( PROVINCE, FND_API.G_MISS_CHAR ),
1161: NVL( STATUS, FND_API.G_MISS_CHAR ),

Line 1158: NVL( POSTAL_CODE, FND_API.G_MISS_CHAR ),

1154: NVL( ADDRESS2, FND_API.G_MISS_CHAR ),
1155: NVL( ADDRESS3, FND_API.G_MISS_CHAR ),
1156: NVL( ADDRESS4, FND_API.G_MISS_CHAR ),
1157: NVL( CITY, FND_API.G_MISS_CHAR ),
1158: NVL( POSTAL_CODE, FND_API.G_MISS_CHAR ),
1159: NVL( STATE, FND_API.G_MISS_CHAR ),
1160: NVL( PROVINCE, FND_API.G_MISS_CHAR ),
1161: NVL( STATUS, FND_API.G_MISS_CHAR ),
1162: NVL( COUNTY, FND_API.G_MISS_CHAR ),

Line 1159: NVL( STATE, FND_API.G_MISS_CHAR ),

1155: NVL( ADDRESS3, FND_API.G_MISS_CHAR ),
1156: NVL( ADDRESS4, FND_API.G_MISS_CHAR ),
1157: NVL( CITY, FND_API.G_MISS_CHAR ),
1158: NVL( POSTAL_CODE, FND_API.G_MISS_CHAR ),
1159: NVL( STATE, FND_API.G_MISS_CHAR ),
1160: NVL( PROVINCE, FND_API.G_MISS_CHAR ),
1161: NVL( STATUS, FND_API.G_MISS_CHAR ),
1162: NVL( COUNTY, FND_API.G_MISS_CHAR ),
1163: NVL( SIC_CODE_TYPE, FND_API.G_MISS_CHAR ),

Line 1160: NVL( PROVINCE, FND_API.G_MISS_CHAR ),

1156: NVL( ADDRESS4, FND_API.G_MISS_CHAR ),
1157: NVL( CITY, FND_API.G_MISS_CHAR ),
1158: NVL( POSTAL_CODE, FND_API.G_MISS_CHAR ),
1159: NVL( STATE, FND_API.G_MISS_CHAR ),
1160: NVL( PROVINCE, FND_API.G_MISS_CHAR ),
1161: NVL( STATUS, FND_API.G_MISS_CHAR ),
1162: NVL( COUNTY, FND_API.G_MISS_CHAR ),
1163: NVL( SIC_CODE_TYPE, FND_API.G_MISS_CHAR ),
1164: NVL( URL, FND_API.G_MISS_CHAR ),

Line 1161: NVL( STATUS, FND_API.G_MISS_CHAR ),

1157: NVL( CITY, FND_API.G_MISS_CHAR ),
1158: NVL( POSTAL_CODE, FND_API.G_MISS_CHAR ),
1159: NVL( STATE, FND_API.G_MISS_CHAR ),
1160: NVL( PROVINCE, FND_API.G_MISS_CHAR ),
1161: NVL( STATUS, FND_API.G_MISS_CHAR ),
1162: NVL( COUNTY, FND_API.G_MISS_CHAR ),
1163: NVL( SIC_CODE_TYPE, FND_API.G_MISS_CHAR ),
1164: NVL( URL, FND_API.G_MISS_CHAR ),
1165: NVL( EMAIL_ADDRESS, FND_API.G_MISS_CHAR ),

Line 1162: NVL( COUNTY, FND_API.G_MISS_CHAR ),

1158: NVL( POSTAL_CODE, FND_API.G_MISS_CHAR ),
1159: NVL( STATE, FND_API.G_MISS_CHAR ),
1160: NVL( PROVINCE, FND_API.G_MISS_CHAR ),
1161: NVL( STATUS, FND_API.G_MISS_CHAR ),
1162: NVL( COUNTY, FND_API.G_MISS_CHAR ),
1163: NVL( SIC_CODE_TYPE, FND_API.G_MISS_CHAR ),
1164: NVL( URL, FND_API.G_MISS_CHAR ),
1165: NVL( EMAIL_ADDRESS, FND_API.G_MISS_CHAR ),
1166: NVL( ANALYSIS_FY, FND_API.G_MISS_CHAR ),

Line 1163: NVL( SIC_CODE_TYPE, FND_API.G_MISS_CHAR ),

1159: NVL( STATE, FND_API.G_MISS_CHAR ),
1160: NVL( PROVINCE, FND_API.G_MISS_CHAR ),
1161: NVL( STATUS, FND_API.G_MISS_CHAR ),
1162: NVL( COUNTY, FND_API.G_MISS_CHAR ),
1163: NVL( SIC_CODE_TYPE, FND_API.G_MISS_CHAR ),
1164: NVL( URL, FND_API.G_MISS_CHAR ),
1165: NVL( EMAIL_ADDRESS, FND_API.G_MISS_CHAR ),
1166: NVL( ANALYSIS_FY, FND_API.G_MISS_CHAR ),
1167: NVL( FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR ),

Line 1164: NVL( URL, FND_API.G_MISS_CHAR ),

1160: NVL( PROVINCE, FND_API.G_MISS_CHAR ),
1161: NVL( STATUS, FND_API.G_MISS_CHAR ),
1162: NVL( COUNTY, FND_API.G_MISS_CHAR ),
1163: NVL( SIC_CODE_TYPE, FND_API.G_MISS_CHAR ),
1164: NVL( URL, FND_API.G_MISS_CHAR ),
1165: NVL( EMAIL_ADDRESS, FND_API.G_MISS_CHAR ),
1166: NVL( ANALYSIS_FY, FND_API.G_MISS_CHAR ),
1167: NVL( FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR ),
1168: NVL( EMPLOYEES_TOTAL, FND_API.G_MISS_NUM ),

Line 1165: NVL( EMAIL_ADDRESS, FND_API.G_MISS_CHAR ),

1161: NVL( STATUS, FND_API.G_MISS_CHAR ),
1162: NVL( COUNTY, FND_API.G_MISS_CHAR ),
1163: NVL( SIC_CODE_TYPE, FND_API.G_MISS_CHAR ),
1164: NVL( URL, FND_API.G_MISS_CHAR ),
1165: NVL( EMAIL_ADDRESS, FND_API.G_MISS_CHAR ),
1166: NVL( ANALYSIS_FY, FND_API.G_MISS_CHAR ),
1167: NVL( FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR ),
1168: NVL( EMPLOYEES_TOTAL, FND_API.G_MISS_NUM ),
1169: NVL( CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),

Line 1166: NVL( ANALYSIS_FY, FND_API.G_MISS_CHAR ),

1162: NVL( COUNTY, FND_API.G_MISS_CHAR ),
1163: NVL( SIC_CODE_TYPE, FND_API.G_MISS_CHAR ),
1164: NVL( URL, FND_API.G_MISS_CHAR ),
1165: NVL( EMAIL_ADDRESS, FND_API.G_MISS_CHAR ),
1166: NVL( ANALYSIS_FY, FND_API.G_MISS_CHAR ),
1167: NVL( FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR ),
1168: NVL( EMPLOYEES_TOTAL, FND_API.G_MISS_NUM ),
1169: NVL( CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1170: NVL( NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),

Line 1167: NVL( FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR ),

1163: NVL( SIC_CODE_TYPE, FND_API.G_MISS_CHAR ),
1164: NVL( URL, FND_API.G_MISS_CHAR ),
1165: NVL( EMAIL_ADDRESS, FND_API.G_MISS_CHAR ),
1166: NVL( ANALYSIS_FY, FND_API.G_MISS_CHAR ),
1167: NVL( FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR ),
1168: NVL( EMPLOYEES_TOTAL, FND_API.G_MISS_NUM ),
1169: NVL( CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1170: NVL( NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1171: NVL( YEAR_ESTABLISHED, FND_API.G_MISS_NUM ),

Line 1168: NVL( EMPLOYEES_TOTAL, FND_API.G_MISS_NUM ),

1164: NVL( URL, FND_API.G_MISS_CHAR ),
1165: NVL( EMAIL_ADDRESS, FND_API.G_MISS_CHAR ),
1166: NVL( ANALYSIS_FY, FND_API.G_MISS_CHAR ),
1167: NVL( FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR ),
1168: NVL( EMPLOYEES_TOTAL, FND_API.G_MISS_NUM ),
1169: NVL( CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1170: NVL( NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1171: NVL( YEAR_ESTABLISHED, FND_API.G_MISS_NUM ),
1172: NVL( GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR ),

Line 1169: NVL( CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),

1165: NVL( EMAIL_ADDRESS, FND_API.G_MISS_CHAR ),
1166: NVL( ANALYSIS_FY, FND_API.G_MISS_CHAR ),
1167: NVL( FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR ),
1168: NVL( EMPLOYEES_TOTAL, FND_API.G_MISS_NUM ),
1169: NVL( CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1170: NVL( NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1171: NVL( YEAR_ESTABLISHED, FND_API.G_MISS_NUM ),
1172: NVL( GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR ),
1173: NVL( MISSION_STATEMENT, FND_API.G_MISS_CHAR ),

Line 1170: NVL( NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),

1166: NVL( ANALYSIS_FY, FND_API.G_MISS_CHAR ),
1167: NVL( FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR ),
1168: NVL( EMPLOYEES_TOTAL, FND_API.G_MISS_NUM ),
1169: NVL( CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1170: NVL( NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1171: NVL( YEAR_ESTABLISHED, FND_API.G_MISS_NUM ),
1172: NVL( GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR ),
1173: NVL( MISSION_STATEMENT, FND_API.G_MISS_CHAR ),
1174: NVL( ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

Line 1171: NVL( YEAR_ESTABLISHED, FND_API.G_MISS_NUM ),

1167: NVL( FISCAL_YEAREND_MONTH, FND_API.G_MISS_CHAR ),
1168: NVL( EMPLOYEES_TOTAL, FND_API.G_MISS_NUM ),
1169: NVL( CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1170: NVL( NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1171: NVL( YEAR_ESTABLISHED, FND_API.G_MISS_NUM ),
1172: NVL( GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR ),
1173: NVL( MISSION_STATEMENT, FND_API.G_MISS_CHAR ),
1174: NVL( ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1175: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

Line 1172: NVL( GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR ),

1168: NVL( EMPLOYEES_TOTAL, FND_API.G_MISS_NUM ),
1169: NVL( CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1170: NVL( NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1171: NVL( YEAR_ESTABLISHED, FND_API.G_MISS_NUM ),
1172: NVL( GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR ),
1173: NVL( MISSION_STATEMENT, FND_API.G_MISS_CHAR ),
1174: NVL( ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1175: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1176: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

Line 1173: NVL( MISSION_STATEMENT, FND_API.G_MISS_CHAR ),

1169: NVL( CURR_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1170: NVL( NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1171: NVL( YEAR_ESTABLISHED, FND_API.G_MISS_NUM ),
1172: NVL( GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR ),
1173: NVL( MISSION_STATEMENT, FND_API.G_MISS_CHAR ),
1174: NVL( ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1175: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1176: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1177: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),

Line 1174: NVL( ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

1170: NVL( NEXT_FY_POTENTIAL_REVENUE, FND_API.G_MISS_NUM ),
1171: NVL( YEAR_ESTABLISHED, FND_API.G_MISS_NUM ),
1172: NVL( GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR ),
1173: NVL( MISSION_STATEMENT, FND_API.G_MISS_CHAR ),
1174: NVL( ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1175: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1176: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1177: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
1178: NVL( CATEGORY_CODE, FND_API.G_MISS_CHAR ),

Line 1175: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

1171: NVL( YEAR_ESTABLISHED, FND_API.G_MISS_NUM ),
1172: NVL( GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR ),
1173: NVL( MISSION_STATEMENT, FND_API.G_MISS_CHAR ),
1174: NVL( ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1175: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1176: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1177: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
1178: NVL( CATEGORY_CODE, FND_API.G_MISS_CHAR ),
1179: NVL( SALUTATION, FND_API.G_MISS_CHAR ),

Line 1176: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

1172: NVL( GSA_INDICATOR_FLAG, FND_API.G_MISS_CHAR ),
1173: NVL( MISSION_STATEMENT, FND_API.G_MISS_CHAR ),
1174: NVL( ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1175: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1176: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1177: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
1178: NVL( CATEGORY_CODE, FND_API.G_MISS_CHAR ),
1179: NVL( SALUTATION, FND_API.G_MISS_CHAR ),
1180: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),

Line 1177: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),

1173: NVL( MISSION_STATEMENT, FND_API.G_MISS_CHAR ),
1174: NVL( ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1175: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1176: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1177: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
1178: NVL( CATEGORY_CODE, FND_API.G_MISS_CHAR ),
1179: NVL( SALUTATION, FND_API.G_MISS_CHAR ),
1180: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
1181: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),

Line 1178: NVL( CATEGORY_CODE, FND_API.G_MISS_CHAR ),

1174: NVL( ORGANIZATION_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1175: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1176: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1177: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
1178: NVL( CATEGORY_CODE, FND_API.G_MISS_CHAR ),
1179: NVL( SALUTATION, FND_API.G_MISS_CHAR ),
1180: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
1181: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
1182: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),

Line 1179: NVL( SALUTATION, FND_API.G_MISS_CHAR ),

1175: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1176: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1177: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
1178: NVL( CATEGORY_CODE, FND_API.G_MISS_CHAR ),
1179: NVL( SALUTATION, FND_API.G_MISS_CHAR ),
1180: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
1181: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
1182: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
1183: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),

Line 1180: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),

1176: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
1177: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
1178: NVL( CATEGORY_CODE, FND_API.G_MISS_CHAR ),
1179: NVL( SALUTATION, FND_API.G_MISS_CHAR ),
1180: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
1181: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
1182: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
1183: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
1184: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR ),

Line 1181: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),

1177: NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
1178: NVL( CATEGORY_CODE, FND_API.G_MISS_CHAR ),
1179: NVL( SALUTATION, FND_API.G_MISS_CHAR ),
1180: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
1181: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
1182: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
1183: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
1184: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR ),
1185: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

Line 1182: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),

1178: NVL( CATEGORY_CODE, FND_API.G_MISS_CHAR ),
1179: NVL( SALUTATION, FND_API.G_MISS_CHAR ),
1180: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
1181: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
1182: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
1183: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
1184: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR ),
1185: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
1186: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

Line 1183: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),

1179: NVL( SALUTATION, FND_API.G_MISS_CHAR ),
1180: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
1181: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
1182: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
1183: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
1184: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR ),
1185: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
1186: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
1187: INTO

Line 1184: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR ),

1180: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
1181: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
1182: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
1183: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
1184: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR ),
1185: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
1186: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
1187: INTO
1188: X_PARTY_ID,

Line 1185: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

1181: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
1182: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
1183: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
1184: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR ),
1185: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
1186: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
1187: INTO
1188: X_PARTY_ID,
1189: X_PARTY_NUMBER,

Line 1186: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

1182: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
1183: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
1184: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR ),
1185: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
1186: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
1187: INTO
1188: X_PARTY_ID,
1189: X_PARTY_NUMBER,
1190: X_PARTY_NAME,

Line 1280: RAISE FND_API.G_EXC_ERROR;

1276: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1277: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party_rec');
1278: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PARTY_ID ) );
1279: FND_MSG_PUB.ADD;
1280: RAISE FND_API.G_EXC_ERROR;
1281:
1282: END Select_Row;
1283:
1284: PROCEDURE Delete_Row (