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_PERSON_PROFILES_PKG dependencies on FND_API

Line 167: DECODE( X_PERSON_PROFILE_ID, FND_API.G_MISS_NUM, HZ_PERSON_PROFILES_S.NEXTVAL, NULL, HZ_PERSON_PROFILES_S.NEXTVAL, X_PERSON_PROFILE_ID ),

163: ACTUAL_CONTENT_SOURCE,
164: VERSION_NUMBER
165: )
166: VALUES (
167: DECODE( X_PERSON_PROFILE_ID, FND_API.G_MISS_NUM, HZ_PERSON_PROFILES_S.NEXTVAL, NULL, HZ_PERSON_PROFILES_S.NEXTVAL, X_PERSON_PROFILE_ID ),
168: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
169: DECODE( X_PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME ),
170: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
171: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 168: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),

164: VERSION_NUMBER
165: )
166: VALUES (
167: DECODE( X_PERSON_PROFILE_ID, FND_API.G_MISS_NUM, HZ_PERSON_PROFILES_S.NEXTVAL, NULL, HZ_PERSON_PROFILES_S.NEXTVAL, X_PERSON_PROFILE_ID ),
168: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
169: DECODE( X_PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME ),
170: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
171: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
172: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 169: DECODE( X_PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME ),

165: )
166: VALUES (
167: DECODE( X_PERSON_PROFILE_ID, FND_API.G_MISS_NUM, HZ_PERSON_PROFILES_S.NEXTVAL, NULL, HZ_PERSON_PROFILES_S.NEXTVAL, X_PERSON_PROFILE_ID ),
168: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
169: DECODE( X_PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME ),
170: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
171: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
172: HZ_UTILITY_V2PUB.CREATION_DATE,
173: HZ_UTILITY_V2PUB.CREATED_BY,

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

175: HZ_UTILITY_V2PUB.REQUEST_ID,
176: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
177: HZ_UTILITY_V2PUB.PROGRAM_ID,
178: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
179: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
180: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
181: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
182: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
183: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

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

176: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
177: HZ_UTILITY_V2PUB.PROGRAM_ID,
178: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
179: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
180: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
181: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
182: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
183: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
184: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

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

177: HZ_UTILITY_V2PUB.PROGRAM_ID,
178: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
179: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
180: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
181: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
182: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
183: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
184: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
185: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

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

178: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
179: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
180: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
181: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
182: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
183: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
184: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
185: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
186: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

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

179: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
180: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
181: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
182: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
183: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
184: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
185: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
186: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
187: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

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

180: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
181: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
182: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
183: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
184: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
185: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
186: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
187: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
188: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

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

181: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
182: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
183: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
184: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
185: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
186: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
187: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
188: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
189: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

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

182: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
183: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
184: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
185: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
186: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
187: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
188: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
189: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
190: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

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

183: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
184: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
185: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
186: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
187: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
188: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
189: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
190: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
191: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

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

184: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
185: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
186: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
187: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
188: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
189: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
190: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
191: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
192: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

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

185: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
186: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
187: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
188: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
189: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
190: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
191: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
192: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
193: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

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

186: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
187: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
188: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
189: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
190: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
191: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
192: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
193: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
194: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

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

187: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
188: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
189: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
190: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
191: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
192: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
193: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
194: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
195: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),

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

188: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
189: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
190: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
191: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
192: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
193: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
194: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
195: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
196: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),

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

189: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
190: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
191: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
192: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
193: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
194: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
195: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
196: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
197: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),

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

190: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
191: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
192: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
193: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
194: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
195: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
196: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
197: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
198: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

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

191: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
192: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
193: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
194: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
195: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
196: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
197: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
198: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
199: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),

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

192: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
193: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
194: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
195: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
196: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
197: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
198: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
199: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
200: DECODE( X_INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),

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

193: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
194: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
195: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
196: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
197: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
198: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
199: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
200: DECODE( X_INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
201: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),

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

194: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
195: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
196: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
197: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
198: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
199: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
200: DECODE( X_INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
201: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
202: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),

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

195: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
196: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
197: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
198: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
199: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
200: DECODE( X_INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
201: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
202: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
203: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),

Line 200: DECODE( X_INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),

196: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
197: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
198: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
199: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
200: DECODE( X_INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
201: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
202: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
203: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
204: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),

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

197: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
198: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
199: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
200: DECODE( X_INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
201: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
202: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
203: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
204: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
205: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),

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

198: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
199: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
200: DECODE( X_INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
201: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
202: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
203: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
204: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
205: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
206: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),

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

199: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
200: DECODE( X_INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
201: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
202: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
203: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
204: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
205: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
206: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
207: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),

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

200: DECODE( X_INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
201: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
202: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
203: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
204: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
205: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
206: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
207: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
208: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),

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

201: DECODE( X_PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR, NULL, X_PERSON_PRE_NAME_ADJUNCT ),
202: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
203: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
204: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
205: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
206: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
207: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
208: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
209: DECODE( X_PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),

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

202: DECODE( X_PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
203: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
204: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
205: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
206: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
207: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
208: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
209: DECODE( X_PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
210: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),

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

203: DECODE( X_PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
204: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
205: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
206: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
207: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
208: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
209: DECODE( X_PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
210: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
211: DECODE( X_PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),

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

204: DECODE( X_PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
205: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
206: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
207: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
208: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
209: DECODE( X_PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
210: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
211: DECODE( X_PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
212: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),

Line 209: DECODE( X_PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),

205: DECODE( X_PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
206: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
207: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
208: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
209: DECODE( X_PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
210: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
211: DECODE( X_PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
212: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
213: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),

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

206: DECODE( X_PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
207: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
208: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
209: DECODE( X_PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
210: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
211: DECODE( X_PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
212: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
213: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
214: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),

Line 211: DECODE( X_PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),

207: DECODE( X_PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
208: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
209: DECODE( X_PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
210: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
211: DECODE( X_PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
212: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
213: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
214: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
215: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),

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

208: DECODE( X_PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_PREVIOUS_LAST_NAME ),
209: DECODE( X_PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
210: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
211: DECODE( X_PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
212: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
213: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
214: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
215: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
216: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),

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

209: DECODE( X_PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
210: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
211: DECODE( X_PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
212: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
213: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
214: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
215: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
216: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
217: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),

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

210: DECODE( X_KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
211: DECODE( X_PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
212: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
213: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
214: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
215: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
216: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
217: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
218: DECODE( X_DATE_OF_BIRTH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_BIRTH ),

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

211: DECODE( X_PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
212: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
213: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
214: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
215: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
216: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
217: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
218: DECODE( X_DATE_OF_BIRTH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_BIRTH ),
219: DECODE( X_PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),

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

212: DECODE( X_PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME_PHONETIC ),
213: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
214: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
215: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
216: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
217: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
218: DECODE( X_DATE_OF_BIRTH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_BIRTH ),
219: DECODE( X_PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
220: DECODE( X_DATE_OF_DEATH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_DEATH ),

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

213: DECODE( X_PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME_PHONETIC ),
214: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
215: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
216: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
217: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
218: DECODE( X_DATE_OF_BIRTH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_BIRTH ),
219: DECODE( X_PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
220: DECODE( X_DATE_OF_DEATH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_DEATH ),
221: DECODE( X_DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),

Line 218: DECODE( X_DATE_OF_BIRTH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_BIRTH ),

214: DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
215: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
216: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
217: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
218: DECODE( X_DATE_OF_BIRTH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_BIRTH ),
219: DECODE( X_PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
220: DECODE( X_DATE_OF_DEATH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_DEATH ),
221: DECODE( X_DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
222: DECODE( X_GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),

Line 219: DECODE( X_PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),

215: DECODE( X_JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
216: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
217: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
218: DECODE( X_DATE_OF_BIRTH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_BIRTH ),
219: DECODE( X_PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
220: DECODE( X_DATE_OF_DEATH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_DEATH ),
221: DECODE( X_DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
222: DECODE( X_GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
223: DECODE( X_DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),

Line 220: DECODE( X_DATE_OF_DEATH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_DEATH ),

216: DECODE( X_PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
217: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
218: DECODE( X_DATE_OF_BIRTH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_BIRTH ),
219: DECODE( X_PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
220: DECODE( X_DATE_OF_DEATH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_DEATH ),
221: DECODE( X_DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
222: DECODE( X_GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
223: DECODE( X_DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
224: DECODE( X_MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),

Line 221: DECODE( X_DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),

217: DECODE( X_PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
218: DECODE( X_DATE_OF_BIRTH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_BIRTH ),
219: DECODE( X_PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
220: DECODE( X_DATE_OF_DEATH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_DEATH ),
221: DECODE( X_DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
222: DECODE( X_GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
223: DECODE( X_DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
224: DECODE( X_MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
225: DECODE( X_MARITAL_STATUS_EFF_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_MARITAL_STATUS_EFF_DATE ),

Line 222: DECODE( X_GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),

218: DECODE( X_DATE_OF_BIRTH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_BIRTH ),
219: DECODE( X_PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
220: DECODE( X_DATE_OF_DEATH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_DEATH ),
221: DECODE( X_DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
222: DECODE( X_GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
223: DECODE( X_DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
224: DECODE( X_MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
225: DECODE( X_MARITAL_STATUS_EFF_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_MARITAL_STATUS_EFF_DATE ),
226: DECODE( X_PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),

Line 223: DECODE( X_DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),

219: DECODE( X_PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
220: DECODE( X_DATE_OF_DEATH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_DEATH ),
221: DECODE( X_DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
222: DECODE( X_GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
223: DECODE( X_DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
224: DECODE( X_MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
225: DECODE( X_MARITAL_STATUS_EFF_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_MARITAL_STATUS_EFF_DATE ),
226: DECODE( X_PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
227: DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),

Line 224: DECODE( X_MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),

220: DECODE( X_DATE_OF_DEATH, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_DATE_OF_DEATH ),
221: DECODE( X_DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
222: DECODE( X_GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
223: DECODE( X_DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
224: DECODE( X_MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
225: DECODE( X_MARITAL_STATUS_EFF_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_MARITAL_STATUS_EFF_DATE ),
226: DECODE( X_PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
227: DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
228: DECODE( X_HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),

Line 225: DECODE( X_MARITAL_STATUS_EFF_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_MARITAL_STATUS_EFF_DATE ),

221: DECODE( X_DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
222: DECODE( X_GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
223: DECODE( X_DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
224: DECODE( X_MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
225: DECODE( X_MARITAL_STATUS_EFF_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_MARITAL_STATUS_EFF_DATE ),
226: DECODE( X_PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
227: DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
228: DECODE( X_HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
229: DECODE( X_HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),

Line 226: DECODE( X_PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),

222: DECODE( X_GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
223: DECODE( X_DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
224: DECODE( X_MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
225: DECODE( X_MARITAL_STATUS_EFF_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_MARITAL_STATUS_EFF_DATE ),
226: DECODE( X_PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
227: DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
228: DECODE( X_HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
229: DECODE( X_HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
230: DECODE( X_RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),

Line 227: DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),

223: DECODE( X_DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
224: DECODE( X_MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
225: DECODE( X_MARITAL_STATUS_EFF_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_MARITAL_STATUS_EFF_DATE ),
226: DECODE( X_PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
227: DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
228: DECODE( X_HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
229: DECODE( X_HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
230: DECODE( X_RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
231: DECODE( X_LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),

Line 228: DECODE( X_HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),

224: DECODE( X_MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
225: DECODE( X_MARITAL_STATUS_EFF_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_MARITAL_STATUS_EFF_DATE ),
226: DECODE( X_PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
227: DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
228: DECODE( X_HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
229: DECODE( X_HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
230: DECODE( X_RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
231: DECODE( X_LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),

Line 229: DECODE( X_HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),

225: DECODE( X_MARITAL_STATUS_EFF_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_MARITAL_STATUS_EFF_DATE ),
226: DECODE( X_PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
227: DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
228: DECODE( X_HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
229: DECODE( X_HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
230: DECODE( X_RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
231: DECODE( X_LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),
233: DECODE( X_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EFFECTIVE_END_DATE ),

Line 230: DECODE( X_RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),

226: DECODE( X_PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
227: DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
228: DECODE( X_HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
229: DECODE( X_HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
230: DECODE( X_RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
231: DECODE( X_LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),
233: DECODE( X_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EFFECTIVE_END_DATE ),
234: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),

Line 231: DECODE( X_LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),

227: DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
228: DECODE( X_HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
229: DECODE( X_HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
230: DECODE( X_RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
231: DECODE( X_LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),
233: DECODE( X_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EFFECTIVE_END_DATE ),
234: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
235: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),

Line 232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),

228: DECODE( X_HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
229: DECODE( X_HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
230: DECODE( X_RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
231: DECODE( X_LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),
233: DECODE( X_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EFFECTIVE_END_DATE ),
234: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
235: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
236: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),

Line 233: DECODE( X_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EFFECTIVE_END_DATE ),

229: DECODE( X_HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
230: DECODE( X_RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
231: DECODE( X_LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),
233: DECODE( X_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EFFECTIVE_END_DATE ),
234: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
235: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
236: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
237: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),

Line 234: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),

230: DECODE( X_RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
231: DECODE( X_LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),
233: DECODE( X_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EFFECTIVE_END_DATE ),
234: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
235: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
236: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
237: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
238: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),

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

231: DECODE( X_LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),
233: DECODE( X_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EFFECTIVE_END_DATE ),
234: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
235: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
236: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
237: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
238: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
239: DECODE( X_MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),

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

232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),
233: DECODE( X_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EFFECTIVE_END_DATE ),
234: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
235: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
236: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
237: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
238: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
239: DECODE( X_MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
240: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

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

233: DECODE( X_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EFFECTIVE_END_DATE ),
234: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
235: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
236: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
237: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
238: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
239: DECODE( X_MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
240: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
241: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

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

234: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
235: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
236: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
237: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
238: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
239: DECODE( X_MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
240: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
241: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
242: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

Line 239: DECODE( X_MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),

235: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
236: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
237: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
238: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
239: DECODE( X_MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
240: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
241: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
242: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
243: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_SST_SOURCE_TYPE, NULL, G_SST_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),

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

236: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
237: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
238: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
239: DECODE( X_MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
240: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
241: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
242: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
243: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_SST_SOURCE_TYPE, NULL, G_SST_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),
244: DECODE( X_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )

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

237: DECODE( X_KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
238: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
239: DECODE( X_MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
240: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
241: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
242: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
243: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_SST_SOURCE_TYPE, NULL, G_SST_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),
244: DECODE( X_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )
245:

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

238: DECODE( X_KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
239: DECODE( X_MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
240: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
241: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
242: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
243: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_SST_SOURCE_TYPE, NULL, G_SST_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),
244: DECODE( X_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )
245:
246: ) RETURNING

Line 243: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_SST_SOURCE_TYPE, NULL, G_SST_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),

239: DECODE( X_MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
240: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
241: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
242: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
243: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_SST_SOURCE_TYPE, NULL, G_SST_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),
244: DECODE( X_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )
245:
246: ) RETURNING
247: ROWID, PERSON_PROFILE_ID

Line 244: DECODE( X_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )

240: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
241: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
242: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
243: DECODE( X_ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, G_SST_SOURCE_TYPE, NULL, G_SST_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),
244: DECODE( X_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )
245:
246: ) RETURNING
247: ROWID, PERSON_PROFILE_ID
248: INTO

Line 362: PERSON_PROFILE_ID = DECODE( X_PERSON_PROFILE_ID, NULL, PERSON_PROFILE_ID, FND_API.G_MISS_NUM, NULL, X_PERSON_PROFILE_ID ),

358:
359: BEGIN
360:
361: UPDATE HZ_PERSON_PROFILES SET
362: PERSON_PROFILE_ID = DECODE( X_PERSON_PROFILE_ID, NULL, PERSON_PROFILE_ID, FND_API.G_MISS_NUM, NULL, X_PERSON_PROFILE_ID ),
363: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
364: PERSON_NAME = DECODE( X_PERSON_NAME, NULL, PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME),
365: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
366: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

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

359: BEGIN
360:
361: UPDATE HZ_PERSON_PROFILES SET
362: PERSON_PROFILE_ID = DECODE( X_PERSON_PROFILE_ID, NULL, PERSON_PROFILE_ID, FND_API.G_MISS_NUM, NULL, X_PERSON_PROFILE_ID ),
363: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
364: PERSON_NAME = DECODE( X_PERSON_NAME, NULL, PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME),
365: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
366: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
367: CREATION_DATE = CREATION_DATE,

Line 364: PERSON_NAME = DECODE( X_PERSON_NAME, NULL, PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME),

360:
361: UPDATE HZ_PERSON_PROFILES SET
362: PERSON_PROFILE_ID = DECODE( X_PERSON_PROFILE_ID, NULL, PERSON_PROFILE_ID, FND_API.G_MISS_NUM, NULL, X_PERSON_PROFILE_ID ),
363: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
364: PERSON_NAME = DECODE( X_PERSON_NAME, NULL, PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME),
365: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
366: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
367: CREATION_DATE = CREATION_DATE,
368: CREATED_BY = CREATED_BY,

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

370: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
371: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
372: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
373: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
374: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
375: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
377: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
378: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

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

371: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
372: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
373: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
374: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
375: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
377: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
378: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
379: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

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

372: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
373: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
374: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
375: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
377: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
378: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
379: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
380: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

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

373: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
374: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
375: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
377: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
378: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
379: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
380: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
381: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

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

374: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
375: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
377: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
378: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
379: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
380: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
381: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
382: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

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

375: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
377: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
378: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
379: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
380: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
381: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
382: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
383: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

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

376: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
377: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
378: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
379: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
380: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
381: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
382: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
383: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
384: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

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

377: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
378: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
379: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
380: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
381: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
382: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
383: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
384: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
385: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

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

378: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
379: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
380: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
381: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
382: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
383: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
384: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
385: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
386: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

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

379: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
380: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
381: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
382: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
383: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
384: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
385: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
386: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
387: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

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

380: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
381: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
382: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
383: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
384: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
385: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
386: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
387: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
388: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

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

381: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
382: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
383: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
384: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
385: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
386: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
387: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
388: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
389: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

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

382: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
383: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
384: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
385: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
386: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
387: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
388: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
389: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
390: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),

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

383: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
384: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
385: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
386: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
387: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
388: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
389: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
390: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
391: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),

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

384: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
385: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
386: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
387: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
388: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
389: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
390: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
391: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
392: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),

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

385: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
386: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
387: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
388: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
389: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
390: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
391: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
392: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
393: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

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

386: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
387: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
388: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
389: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
390: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
391: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
392: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
393: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
394: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),

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

387: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
388: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
389: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
390: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
391: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
392: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
393: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
394: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
395: INTERNAL_FLAG = DECODE( X_INTERNAL_FLAG, NULL, INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),

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

388: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
389: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
390: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
391: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
392: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
393: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
394: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
395: INTERNAL_FLAG = DECODE( X_INTERNAL_FLAG, NULL, INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
396: 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 393: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

389: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
390: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
391: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
392: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
393: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
394: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
395: INTERNAL_FLAG = DECODE( X_INTERNAL_FLAG, NULL, INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
396: 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 ),
397: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),

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

390: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
391: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
392: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
393: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
394: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
395: INTERNAL_FLAG = DECODE( X_INTERNAL_FLAG, NULL, INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
396: 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 ),
397: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
398: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),

Line 395: INTERNAL_FLAG = DECODE( X_INTERNAL_FLAG, NULL, INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),

391: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
392: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
393: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
394: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
395: INTERNAL_FLAG = DECODE( X_INTERNAL_FLAG, NULL, INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
396: 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 ),
397: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
398: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
399: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),

Line 396: 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 ),

392: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
393: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
394: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
395: INTERNAL_FLAG = DECODE( X_INTERNAL_FLAG, NULL, INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
396: 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 ),
397: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
398: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
399: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
400: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),

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

393: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
394: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
395: INTERNAL_FLAG = DECODE( X_INTERNAL_FLAG, NULL, INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
396: 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 ),
397: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
398: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
399: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
400: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
401: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),

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

394: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
395: INTERNAL_FLAG = DECODE( X_INTERNAL_FLAG, NULL, INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
396: 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 ),
397: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
398: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
399: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
400: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
401: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
402: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),

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

395: INTERNAL_FLAG = DECODE( X_INTERNAL_FLAG, NULL, INTERNAL_FLAG, FND_API.G_MISS_CHAR, NULL, X_INTERNAL_FLAG ),
396: 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 ),
397: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
398: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
399: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
400: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
401: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
402: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
403: 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 400: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),

396: 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 ),
397: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
398: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
399: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
400: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
401: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
402: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
403: 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 ),
404: PERSON_INITIALS = DECODE( X_PERSON_INITIALS, NULL, PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),

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

397: PERSON_FIRST_NAME = DECODE( X_PERSON_FIRST_NAME, NULL, PERSON_FIRST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_FIRST_NAME ),
398: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
399: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
400: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
401: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
402: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
403: 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 ),
404: PERSON_INITIALS = DECODE( X_PERSON_INITIALS, NULL, PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
405: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),

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

398: PERSON_MIDDLE_NAME = DECODE( X_PERSON_MIDDLE_NAME, NULL, PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_MIDDLE_NAME ),
399: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
400: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
401: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
402: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
403: 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 ),
404: PERSON_INITIALS = DECODE( X_PERSON_INITIALS, NULL, PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
405: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
406: PERSON_NAME_PHONETIC = DECODE( X_PERSON_NAME_PHONETIC, NULL, PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),

Line 403: 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 ),

399: PERSON_LAST_NAME = DECODE( X_PERSON_LAST_NAME, NULL, PERSON_LAST_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_LAST_NAME ),
400: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
401: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
402: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
403: 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 ),
404: PERSON_INITIALS = DECODE( X_PERSON_INITIALS, NULL, PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
405: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
406: PERSON_NAME_PHONETIC = DECODE( X_PERSON_NAME_PHONETIC, NULL, PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
407: 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 404: PERSON_INITIALS = DECODE( X_PERSON_INITIALS, NULL, PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),

400: PERSON_NAME_SUFFIX = DECODE( X_PERSON_NAME_SUFFIX, NULL, PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_SUFFIX ),
401: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
402: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
403: 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 ),
404: PERSON_INITIALS = DECODE( X_PERSON_INITIALS, NULL, PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
405: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
406: PERSON_NAME_PHONETIC = DECODE( X_PERSON_NAME_PHONETIC, NULL, PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
407: 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 ),
408: 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 405: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),

401: PERSON_TITLE = DECODE( X_PERSON_TITLE, NULL, PERSON_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_TITLE ),
402: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
403: 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 ),
404: PERSON_INITIALS = DECODE( X_PERSON_INITIALS, NULL, PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
405: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
406: PERSON_NAME_PHONETIC = DECODE( X_PERSON_NAME_PHONETIC, NULL, PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
407: 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 ),
408: 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 ),
409: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),

Line 406: PERSON_NAME_PHONETIC = DECODE( X_PERSON_NAME_PHONETIC, NULL, PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),

402: PERSON_ACADEMIC_TITLE = DECODE( X_PERSON_ACADEMIC_TITLE, NULL, PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR, NULL, X_PERSON_ACADEMIC_TITLE ),
403: 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 ),
404: PERSON_INITIALS = DECODE( X_PERSON_INITIALS, NULL, PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
405: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
406: PERSON_NAME_PHONETIC = DECODE( X_PERSON_NAME_PHONETIC, NULL, PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
407: 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 ),
408: 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 ),
409: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
410: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),

Line 407: 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 ),

403: 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 ),
404: PERSON_INITIALS = DECODE( X_PERSON_INITIALS, NULL, PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
405: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
406: PERSON_NAME_PHONETIC = DECODE( X_PERSON_NAME_PHONETIC, NULL, PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
407: 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 ),
408: 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 ),
409: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
410: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
411: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),

Line 408: 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 ),

404: PERSON_INITIALS = DECODE( X_PERSON_INITIALS, NULL, PERSON_INITIALS, FND_API.G_MISS_CHAR, NULL, X_PERSON_INITIALS ),
405: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
406: PERSON_NAME_PHONETIC = DECODE( X_PERSON_NAME_PHONETIC, NULL, PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
407: 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 ),
408: 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 ),
409: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
410: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
411: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
412: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),

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

405: KNOWN_AS = DECODE( X_KNOWN_AS, NULL, KNOWN_AS, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS ),
406: PERSON_NAME_PHONETIC = DECODE( X_PERSON_NAME_PHONETIC, NULL, PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
407: 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 ),
408: 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 ),
409: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
410: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
411: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
412: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
413: DATE_OF_BIRTH = DECODE( X_DATE_OF_BIRTH, NULL, DATE_OF_BIRTH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_BIRTH ),

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

406: PERSON_NAME_PHONETIC = DECODE( X_PERSON_NAME_PHONETIC, NULL, PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME_PHONETIC ),
407: 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 ),
408: 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 ),
409: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
410: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
411: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
412: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
413: DATE_OF_BIRTH = DECODE( X_DATE_OF_BIRTH, NULL, DATE_OF_BIRTH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_BIRTH ),
414: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),

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

407: 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 ),
408: 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 ),
409: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
410: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
411: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
412: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
413: DATE_OF_BIRTH = DECODE( X_DATE_OF_BIRTH, NULL, DATE_OF_BIRTH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_BIRTH ),
414: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
415: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),

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

408: 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 ),
409: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
410: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
411: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
412: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
413: DATE_OF_BIRTH = DECODE( X_DATE_OF_BIRTH, NULL, DATE_OF_BIRTH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_BIRTH ),
414: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
415: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
416: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),

Line 413: DATE_OF_BIRTH = DECODE( X_DATE_OF_BIRTH, NULL, DATE_OF_BIRTH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_BIRTH ),

409: TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
410: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
411: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
412: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
413: DATE_OF_BIRTH = DECODE( X_DATE_OF_BIRTH, NULL, DATE_OF_BIRTH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_BIRTH ),
414: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
415: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
416: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
417: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),

Line 414: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),

410: JGZZ_FISCAL_CODE = DECODE( X_JGZZ_FISCAL_CODE, NULL, JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR, NULL, X_JGZZ_FISCAL_CODE ),
411: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
412: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
413: DATE_OF_BIRTH = DECODE( X_DATE_OF_BIRTH, NULL, DATE_OF_BIRTH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_BIRTH ),
414: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
415: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
416: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
417: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
418: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),

Line 415: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),

411: PERSON_IDEN_TYPE = DECODE( X_PERSON_IDEN_TYPE, NULL, PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDEN_TYPE ),
412: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
413: DATE_OF_BIRTH = DECODE( X_DATE_OF_BIRTH, NULL, DATE_OF_BIRTH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_BIRTH ),
414: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
415: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
416: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
417: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
418: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
419: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),

Line 416: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),

412: PERSON_IDENTIFIER = DECODE( X_PERSON_IDENTIFIER, NULL, PERSON_IDENTIFIER, FND_API.G_MISS_CHAR, NULL, X_PERSON_IDENTIFIER ),
413: DATE_OF_BIRTH = DECODE( X_DATE_OF_BIRTH, NULL, DATE_OF_BIRTH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_BIRTH ),
414: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
415: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
416: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
417: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
418: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
419: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
420: MARITAL_STATUS_EFFECTIVE_DATE = DECODE( X_MARITAL_STATUS_EFF_DATE, NULL, MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, X_MARITAL_STATUS_EFF_DATE ),

Line 417: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),

413: DATE_OF_BIRTH = DECODE( X_DATE_OF_BIRTH, NULL, DATE_OF_BIRTH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_BIRTH ),
414: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
415: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
416: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
417: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
418: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
419: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
420: MARITAL_STATUS_EFFECTIVE_DATE = DECODE( X_MARITAL_STATUS_EFF_DATE, NULL, MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, X_MARITAL_STATUS_EFF_DATE ),
421: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),

Line 418: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),

414: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
415: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
416: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
417: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
418: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
419: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
420: MARITAL_STATUS_EFFECTIVE_DATE = DECODE( X_MARITAL_STATUS_EFF_DATE, NULL, MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, X_MARITAL_STATUS_EFF_DATE ),
421: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
422: HEAD_OF_HOUSEHOLD_FLAG = DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, NULL, HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),

Line 419: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),

415: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
416: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
417: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
418: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
419: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
420: MARITAL_STATUS_EFFECTIVE_DATE = DECODE( X_MARITAL_STATUS_EFF_DATE, NULL, MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, X_MARITAL_STATUS_EFF_DATE ),
421: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
422: HEAD_OF_HOUSEHOLD_FLAG = DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, NULL, HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
423: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),

Line 420: MARITAL_STATUS_EFFECTIVE_DATE = DECODE( X_MARITAL_STATUS_EFF_DATE, NULL, MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, X_MARITAL_STATUS_EFF_DATE ),

416: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
417: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
418: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
419: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
420: MARITAL_STATUS_EFFECTIVE_DATE = DECODE( X_MARITAL_STATUS_EFF_DATE, NULL, MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, X_MARITAL_STATUS_EFF_DATE ),
421: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
422: HEAD_OF_HOUSEHOLD_FLAG = DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, NULL, HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
423: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
424: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),

Line 421: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),

417: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
418: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
419: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
420: MARITAL_STATUS_EFFECTIVE_DATE = DECODE( X_MARITAL_STATUS_EFF_DATE, NULL, MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, X_MARITAL_STATUS_EFF_DATE ),
421: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
422: HEAD_OF_HOUSEHOLD_FLAG = DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, NULL, HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
423: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
424: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
425: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),

Line 422: HEAD_OF_HOUSEHOLD_FLAG = DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, NULL, HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),

418: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
419: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
420: MARITAL_STATUS_EFFECTIVE_DATE = DECODE( X_MARITAL_STATUS_EFF_DATE, NULL, MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, X_MARITAL_STATUS_EFF_DATE ),
421: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
422: HEAD_OF_HOUSEHOLD_FLAG = DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, NULL, HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
423: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
424: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
425: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
426: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),

Line 423: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),

419: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
420: MARITAL_STATUS_EFFECTIVE_DATE = DECODE( X_MARITAL_STATUS_EFF_DATE, NULL, MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, X_MARITAL_STATUS_EFF_DATE ),
421: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
422: HEAD_OF_HOUSEHOLD_FLAG = DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, NULL, HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
423: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
424: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
425: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
426: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
427: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),

Line 424: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),

420: MARITAL_STATUS_EFFECTIVE_DATE = DECODE( X_MARITAL_STATUS_EFF_DATE, NULL, MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE, NULL, X_MARITAL_STATUS_EFF_DATE ),
421: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
422: HEAD_OF_HOUSEHOLD_FLAG = DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, NULL, HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
423: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
424: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
425: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
426: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
427: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),
428: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),

Line 425: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),

421: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
422: HEAD_OF_HOUSEHOLD_FLAG = DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, NULL, HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
423: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
424: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
425: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
426: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
427: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),
428: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),
429: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),

Line 426: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),

422: HEAD_OF_HOUSEHOLD_FLAG = DECODE( X_HEAD_OF_HOUSEHOLD_FLAG, NULL, HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR, 'N', X_HEAD_OF_HOUSEHOLD_FLAG ),
423: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
424: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
425: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
426: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
427: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),
428: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),
429: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
430: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),

Line 427: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),

423: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
424: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
425: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
426: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
427: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),
428: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),
429: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
430: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
431: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),

Line 428: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),

424: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
425: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
426: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
427: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),
428: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),
429: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
430: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
431: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
432: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),

Line 429: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),

425: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
426: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
427: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),
428: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),
429: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
430: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
431: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
432: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
433: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),

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

426: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
427: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),
428: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),
429: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
430: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
431: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
432: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
433: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
434: MIDDLE_NAME_PHONETIC = DECODE( X_MIDDLE_NAME_PHONETIC, NULL, MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),

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

427: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),
428: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),
429: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
430: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
431: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
432: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
433: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
434: MIDDLE_NAME_PHONETIC = DECODE( X_MIDDLE_NAME_PHONETIC, NULL, MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
435: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

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

428: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),
429: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
430: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
431: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
432: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
433: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
434: MIDDLE_NAME_PHONETIC = DECODE( X_MIDDLE_NAME_PHONETIC, NULL, MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
435: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
436: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

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

429: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
430: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
431: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
432: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
433: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
434: MIDDLE_NAME_PHONETIC = DECODE( X_MIDDLE_NAME_PHONETIC, NULL, MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
435: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
436: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
437: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

Line 434: MIDDLE_NAME_PHONETIC = DECODE( X_MIDDLE_NAME_PHONETIC, NULL, MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),

430: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
431: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
432: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
433: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
434: MIDDLE_NAME_PHONETIC = DECODE( X_MIDDLE_NAME_PHONETIC, NULL, MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
435: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
436: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
437: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
438: ACTUAL_CONTENT_SOURCE = DECODE( X_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE ),

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

431: KNOWN_AS3 = DECODE( X_KNOWN_AS3, NULL, KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),
432: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
433: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
434: MIDDLE_NAME_PHONETIC = DECODE( X_MIDDLE_NAME_PHONETIC, NULL, MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
435: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
436: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
437: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
438: ACTUAL_CONTENT_SOURCE = DECODE( X_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE ),
439: VERSION_NUMBER = DECODE( X_VERSION_NUMBER, NULL, VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )

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

432: KNOWN_AS4 = DECODE( X_KNOWN_AS4, NULL, KNOWN_AS4, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS4 ),
433: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
434: MIDDLE_NAME_PHONETIC = DECODE( X_MIDDLE_NAME_PHONETIC, NULL, MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
435: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
436: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
437: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
438: ACTUAL_CONTENT_SOURCE = DECODE( X_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE ),
439: VERSION_NUMBER = DECODE( X_VERSION_NUMBER, NULL, VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )
440: WHERE ROWID = X_RowId;

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

433: KNOWN_AS5 = DECODE( X_KNOWN_AS5, NULL, KNOWN_AS5, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS5 ),
434: MIDDLE_NAME_PHONETIC = DECODE( X_MIDDLE_NAME_PHONETIC, NULL, MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
435: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
436: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
437: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
438: ACTUAL_CONTENT_SOURCE = DECODE( X_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE ),
439: VERSION_NUMBER = DECODE( X_VERSION_NUMBER, NULL, VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )
440: WHERE ROWID = X_RowId;
441:

Line 438: ACTUAL_CONTENT_SOURCE = DECODE( X_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE ),

434: MIDDLE_NAME_PHONETIC = DECODE( X_MIDDLE_NAME_PHONETIC, NULL, MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR, NULL, X_MIDDLE_NAME_PHONETIC ),
435: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
436: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
437: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
438: ACTUAL_CONTENT_SOURCE = DECODE( X_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE ),
439: VERSION_NUMBER = DECODE( X_VERSION_NUMBER, NULL, VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )
440: WHERE ROWID = X_RowId;
441:
442: IF ( SQL%NOTFOUND ) THEN

Line 439: VERSION_NUMBER = DECODE( X_VERSION_NUMBER, NULL, VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )

435: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
436: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
437: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
438: ACTUAL_CONTENT_SOURCE = DECODE( X_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE ),
439: VERSION_NUMBER = DECODE( X_VERSION_NUMBER, NULL, VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_VERSION_NUMBER )
440: WHERE ROWID = X_RowId;
441:
442: IF ( SQL%NOTFOUND ) THEN
443: RAISE NO_DATA_FOUND;

Line 855: NVL( PERSON_PROFILE_ID, FND_API.G_MISS_NUM ),

851:
852: BEGIN
853:
854: SELECT
855: NVL( PERSON_PROFILE_ID, FND_API.G_MISS_NUM ),
856: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
857: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
858: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
859: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),

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

852: BEGIN
853:
854: SELECT
855: NVL( PERSON_PROFILE_ID, FND_API.G_MISS_NUM ),
856: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
857: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
858: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
859: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
860: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),

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

853:
854: SELECT
855: NVL( PERSON_PROFILE_ID, FND_API.G_MISS_NUM ),
856: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
857: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
858: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
859: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
860: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
861: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),

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

854: SELECT
855: NVL( PERSON_PROFILE_ID, FND_API.G_MISS_NUM ),
856: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
857: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
858: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
859: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
860: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
861: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
862: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),

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

855: NVL( PERSON_PROFILE_ID, FND_API.G_MISS_NUM ),
856: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
857: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
858: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
859: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
860: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
861: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
862: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
863: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),

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

856: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
857: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
858: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
859: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
860: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
861: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
862: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
863: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
864: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),

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

857: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
858: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
859: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
860: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
861: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
862: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
863: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
864: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
865: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),

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

858: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
859: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
860: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
861: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
862: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
863: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
864: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
865: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
866: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),

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

859: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
860: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
861: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
862: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
863: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
864: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
865: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
866: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
867: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),

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

860: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
861: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
862: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
863: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
864: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
865: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
866: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
867: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
868: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),

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

861: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
862: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
863: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
864: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
865: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
866: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
867: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
868: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
869: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),

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

862: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
863: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
864: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
865: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
866: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
867: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
868: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
869: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
870: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),

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

863: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
864: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
865: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
866: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
867: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
868: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
869: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
870: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
871: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),

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

864: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
865: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
866: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
867: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
868: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
869: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
870: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
871: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
872: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),

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

865: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
866: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
867: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
868: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
869: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
870: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
871: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
872: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
873: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),

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

866: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
867: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
868: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
869: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
870: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
871: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
872: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
873: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
874: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),

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

867: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
868: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
869: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
870: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
871: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
872: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
873: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
874: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
875: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),

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

868: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
869: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
870: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
871: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
872: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
873: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
874: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
875: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
876: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),

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

869: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
870: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
871: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
872: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
873: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
874: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
875: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
876: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
877: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),

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

870: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
871: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
872: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
873: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
874: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
875: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
876: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
877: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
878: NVL( INTERNAL_FLAG, FND_API.G_MISS_CHAR ),

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

871: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
872: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
873: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
874: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
875: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
876: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
877: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
878: NVL( INTERNAL_FLAG, FND_API.G_MISS_CHAR ),
879: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),

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

872: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
873: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
874: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
875: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
876: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
877: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
878: NVL( INTERNAL_FLAG, FND_API.G_MISS_CHAR ),
879: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
880: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),

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

873: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
874: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
875: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
876: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
877: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
878: NVL( INTERNAL_FLAG, FND_API.G_MISS_CHAR ),
879: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
880: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
881: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),

Line 878: NVL( INTERNAL_FLAG, FND_API.G_MISS_CHAR ),

874: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
875: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
876: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
877: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
878: NVL( INTERNAL_FLAG, FND_API.G_MISS_CHAR ),
879: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
880: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
881: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
882: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),

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

875: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
876: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
877: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
878: NVL( INTERNAL_FLAG, FND_API.G_MISS_CHAR ),
879: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
880: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
881: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
882: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
883: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),

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

876: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
877: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
878: NVL( INTERNAL_FLAG, FND_API.G_MISS_CHAR ),
879: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
880: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
881: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
882: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
883: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
884: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),

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

877: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
878: NVL( INTERNAL_FLAG, FND_API.G_MISS_CHAR ),
879: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
880: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
881: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
882: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
883: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
884: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
885: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),

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

878: NVL( INTERNAL_FLAG, FND_API.G_MISS_CHAR ),
879: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
880: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
881: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
882: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
883: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
884: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
885: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
886: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),

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

879: NVL( PERSON_PRE_NAME_ADJUNCT, FND_API.G_MISS_CHAR ),
880: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
881: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
882: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
883: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
884: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
885: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
886: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
887: NVL( PERSON_INITIALS, FND_API.G_MISS_CHAR ),

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

880: NVL( PERSON_FIRST_NAME, FND_API.G_MISS_CHAR ),
881: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
882: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
883: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
884: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
885: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
886: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
887: NVL( PERSON_INITIALS, FND_API.G_MISS_CHAR ),
888: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),

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

881: NVL( PERSON_MIDDLE_NAME, FND_API.G_MISS_CHAR ),
882: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
883: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
884: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
885: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
886: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
887: NVL( PERSON_INITIALS, FND_API.G_MISS_CHAR ),
888: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
889: NVL( PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

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

882: NVL( PERSON_LAST_NAME, FND_API.G_MISS_CHAR ),
883: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
884: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
885: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
886: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
887: NVL( PERSON_INITIALS, FND_API.G_MISS_CHAR ),
888: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
889: NVL( PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
890: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

Line 887: NVL( PERSON_INITIALS, FND_API.G_MISS_CHAR ),

883: NVL( PERSON_NAME_SUFFIX, FND_API.G_MISS_CHAR ),
884: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
885: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
886: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
887: NVL( PERSON_INITIALS, FND_API.G_MISS_CHAR ),
888: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
889: NVL( PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
890: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
891: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

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

884: NVL( PERSON_TITLE, FND_API.G_MISS_CHAR ),
885: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
886: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
887: NVL( PERSON_INITIALS, FND_API.G_MISS_CHAR ),
888: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
889: NVL( PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
890: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
891: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
892: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),

Line 889: NVL( PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

885: NVL( PERSON_ACADEMIC_TITLE, FND_API.G_MISS_CHAR ),
886: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
887: NVL( PERSON_INITIALS, FND_API.G_MISS_CHAR ),
888: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
889: NVL( PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
890: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
891: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
892: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
893: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),

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

886: NVL( PERSON_PREVIOUS_LAST_NAME, FND_API.G_MISS_CHAR ),
887: NVL( PERSON_INITIALS, FND_API.G_MISS_CHAR ),
888: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
889: NVL( PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
890: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
891: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
892: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
893: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
894: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),

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

887: NVL( PERSON_INITIALS, FND_API.G_MISS_CHAR ),
888: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
889: NVL( PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
890: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
891: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
892: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
893: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
894: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
895: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),

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

888: NVL( KNOWN_AS, FND_API.G_MISS_CHAR ),
889: NVL( PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
890: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
891: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
892: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
893: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
894: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
895: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
896: NVL( DATE_OF_BIRTH, FND_API.G_MISS_DATE ),

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

889: NVL( PERSON_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
890: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
891: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
892: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
893: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
894: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
895: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
896: NVL( DATE_OF_BIRTH, FND_API.G_MISS_DATE ),
897: NVL( PLACE_OF_BIRTH, FND_API.G_MISS_CHAR ),

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

890: NVL( PERSON_FIRST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
891: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
892: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
893: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
894: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
895: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
896: NVL( DATE_OF_BIRTH, FND_API.G_MISS_DATE ),
897: NVL( PLACE_OF_BIRTH, FND_API.G_MISS_CHAR ),
898: NVL( DATE_OF_DEATH, FND_API.G_MISS_DATE ),

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

891: NVL( PERSON_LAST_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
892: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
893: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
894: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
895: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
896: NVL( DATE_OF_BIRTH, FND_API.G_MISS_DATE ),
897: NVL( PLACE_OF_BIRTH, FND_API.G_MISS_CHAR ),
898: NVL( DATE_OF_DEATH, FND_API.G_MISS_DATE ),
899: NVL( DECEASED_FLAG, FND_API.G_MISS_CHAR ),

Line 896: NVL( DATE_OF_BIRTH, FND_API.G_MISS_DATE ),

892: NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
893: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
894: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
895: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
896: NVL( DATE_OF_BIRTH, FND_API.G_MISS_DATE ),
897: NVL( PLACE_OF_BIRTH, FND_API.G_MISS_CHAR ),
898: NVL( DATE_OF_DEATH, FND_API.G_MISS_DATE ),
899: NVL( DECEASED_FLAG, FND_API.G_MISS_CHAR ),
900: NVL( GENDER, FND_API.G_MISS_CHAR ),

Line 897: NVL( PLACE_OF_BIRTH, FND_API.G_MISS_CHAR ),

893: NVL( JGZZ_FISCAL_CODE, FND_API.G_MISS_CHAR ),
894: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
895: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
896: NVL( DATE_OF_BIRTH, FND_API.G_MISS_DATE ),
897: NVL( PLACE_OF_BIRTH, FND_API.G_MISS_CHAR ),
898: NVL( DATE_OF_DEATH, FND_API.G_MISS_DATE ),
899: NVL( DECEASED_FLAG, FND_API.G_MISS_CHAR ),
900: NVL( GENDER, FND_API.G_MISS_CHAR ),
901: NVL( DECLARED_ETHNICITY, FND_API.G_MISS_CHAR ),

Line 898: NVL( DATE_OF_DEATH, FND_API.G_MISS_DATE ),

894: NVL( PERSON_IDEN_TYPE, FND_API.G_MISS_CHAR ),
895: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
896: NVL( DATE_OF_BIRTH, FND_API.G_MISS_DATE ),
897: NVL( PLACE_OF_BIRTH, FND_API.G_MISS_CHAR ),
898: NVL( DATE_OF_DEATH, FND_API.G_MISS_DATE ),
899: NVL( DECEASED_FLAG, FND_API.G_MISS_CHAR ),
900: NVL( GENDER, FND_API.G_MISS_CHAR ),
901: NVL( DECLARED_ETHNICITY, FND_API.G_MISS_CHAR ),
902: NVL( MARITAL_STATUS, FND_API.G_MISS_CHAR ),

Line 899: NVL( DECEASED_FLAG, FND_API.G_MISS_CHAR ),

895: NVL( PERSON_IDENTIFIER, FND_API.G_MISS_CHAR ),
896: NVL( DATE_OF_BIRTH, FND_API.G_MISS_DATE ),
897: NVL( PLACE_OF_BIRTH, FND_API.G_MISS_CHAR ),
898: NVL( DATE_OF_DEATH, FND_API.G_MISS_DATE ),
899: NVL( DECEASED_FLAG, FND_API.G_MISS_CHAR ),
900: NVL( GENDER, FND_API.G_MISS_CHAR ),
901: NVL( DECLARED_ETHNICITY, FND_API.G_MISS_CHAR ),
902: NVL( MARITAL_STATUS, FND_API.G_MISS_CHAR ),
903: NVL( MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE ),

Line 900: NVL( GENDER, FND_API.G_MISS_CHAR ),

896: NVL( DATE_OF_BIRTH, FND_API.G_MISS_DATE ),
897: NVL( PLACE_OF_BIRTH, FND_API.G_MISS_CHAR ),
898: NVL( DATE_OF_DEATH, FND_API.G_MISS_DATE ),
899: NVL( DECEASED_FLAG, FND_API.G_MISS_CHAR ),
900: NVL( GENDER, FND_API.G_MISS_CHAR ),
901: NVL( DECLARED_ETHNICITY, FND_API.G_MISS_CHAR ),
902: NVL( MARITAL_STATUS, FND_API.G_MISS_CHAR ),
903: NVL( MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE ),
904: NVL( PERSONAL_INCOME, FND_API.G_MISS_NUM ),

Line 901: NVL( DECLARED_ETHNICITY, FND_API.G_MISS_CHAR ),

897: NVL( PLACE_OF_BIRTH, FND_API.G_MISS_CHAR ),
898: NVL( DATE_OF_DEATH, FND_API.G_MISS_DATE ),
899: NVL( DECEASED_FLAG, FND_API.G_MISS_CHAR ),
900: NVL( GENDER, FND_API.G_MISS_CHAR ),
901: NVL( DECLARED_ETHNICITY, FND_API.G_MISS_CHAR ),
902: NVL( MARITAL_STATUS, FND_API.G_MISS_CHAR ),
903: NVL( MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE ),
904: NVL( PERSONAL_INCOME, FND_API.G_MISS_NUM ),
905: NVL( HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR ),

Line 902: NVL( MARITAL_STATUS, FND_API.G_MISS_CHAR ),

898: NVL( DATE_OF_DEATH, FND_API.G_MISS_DATE ),
899: NVL( DECEASED_FLAG, FND_API.G_MISS_CHAR ),
900: NVL( GENDER, FND_API.G_MISS_CHAR ),
901: NVL( DECLARED_ETHNICITY, FND_API.G_MISS_CHAR ),
902: NVL( MARITAL_STATUS, FND_API.G_MISS_CHAR ),
903: NVL( MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE ),
904: NVL( PERSONAL_INCOME, FND_API.G_MISS_NUM ),
905: NVL( HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR ),
906: NVL( HOUSEHOLD_INCOME, FND_API.G_MISS_NUM ),

Line 903: NVL( MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE ),

899: NVL( DECEASED_FLAG, FND_API.G_MISS_CHAR ),
900: NVL( GENDER, FND_API.G_MISS_CHAR ),
901: NVL( DECLARED_ETHNICITY, FND_API.G_MISS_CHAR ),
902: NVL( MARITAL_STATUS, FND_API.G_MISS_CHAR ),
903: NVL( MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE ),
904: NVL( PERSONAL_INCOME, FND_API.G_MISS_NUM ),
905: NVL( HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR ),
906: NVL( HOUSEHOLD_INCOME, FND_API.G_MISS_NUM ),
907: NVL( HOUSEHOLD_SIZE, FND_API.G_MISS_NUM ),

Line 904: NVL( PERSONAL_INCOME, FND_API.G_MISS_NUM ),

900: NVL( GENDER, FND_API.G_MISS_CHAR ),
901: NVL( DECLARED_ETHNICITY, FND_API.G_MISS_CHAR ),
902: NVL( MARITAL_STATUS, FND_API.G_MISS_CHAR ),
903: NVL( MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE ),
904: NVL( PERSONAL_INCOME, FND_API.G_MISS_NUM ),
905: NVL( HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR ),
906: NVL( HOUSEHOLD_INCOME, FND_API.G_MISS_NUM ),
907: NVL( HOUSEHOLD_SIZE, FND_API.G_MISS_NUM ),
908: NVL( RENT_OWN_IND, FND_API.G_MISS_CHAR ),

Line 905: NVL( HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR ),

901: NVL( DECLARED_ETHNICITY, FND_API.G_MISS_CHAR ),
902: NVL( MARITAL_STATUS, FND_API.G_MISS_CHAR ),
903: NVL( MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE ),
904: NVL( PERSONAL_INCOME, FND_API.G_MISS_NUM ),
905: NVL( HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR ),
906: NVL( HOUSEHOLD_INCOME, FND_API.G_MISS_NUM ),
907: NVL( HOUSEHOLD_SIZE, FND_API.G_MISS_NUM ),
908: NVL( RENT_OWN_IND, FND_API.G_MISS_CHAR ),
909: NVL( LAST_KNOWN_GPS, FND_API.G_MISS_CHAR ),

Line 906: NVL( HOUSEHOLD_INCOME, FND_API.G_MISS_NUM ),

902: NVL( MARITAL_STATUS, FND_API.G_MISS_CHAR ),
903: NVL( MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE ),
904: NVL( PERSONAL_INCOME, FND_API.G_MISS_NUM ),
905: NVL( HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR ),
906: NVL( HOUSEHOLD_INCOME, FND_API.G_MISS_NUM ),
907: NVL( HOUSEHOLD_SIZE, FND_API.G_MISS_NUM ),
908: NVL( RENT_OWN_IND, FND_API.G_MISS_CHAR ),
909: NVL( LAST_KNOWN_GPS, FND_API.G_MISS_CHAR ),
910: NVL( EFFECTIVE_START_DATE, FND_API.G_MISS_DATE ),

Line 907: NVL( HOUSEHOLD_SIZE, FND_API.G_MISS_NUM ),

903: NVL( MARITAL_STATUS_EFFECTIVE_DATE, FND_API.G_MISS_DATE ),
904: NVL( PERSONAL_INCOME, FND_API.G_MISS_NUM ),
905: NVL( HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR ),
906: NVL( HOUSEHOLD_INCOME, FND_API.G_MISS_NUM ),
907: NVL( HOUSEHOLD_SIZE, FND_API.G_MISS_NUM ),
908: NVL( RENT_OWN_IND, FND_API.G_MISS_CHAR ),
909: NVL( LAST_KNOWN_GPS, FND_API.G_MISS_CHAR ),
910: NVL( EFFECTIVE_START_DATE, FND_API.G_MISS_DATE ),
911: NVL( EFFECTIVE_END_DATE, FND_API.G_MISS_DATE ),

Line 908: NVL( RENT_OWN_IND, FND_API.G_MISS_CHAR ),

904: NVL( PERSONAL_INCOME, FND_API.G_MISS_NUM ),
905: NVL( HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR ),
906: NVL( HOUSEHOLD_INCOME, FND_API.G_MISS_NUM ),
907: NVL( HOUSEHOLD_SIZE, FND_API.G_MISS_NUM ),
908: NVL( RENT_OWN_IND, FND_API.G_MISS_CHAR ),
909: NVL( LAST_KNOWN_GPS, FND_API.G_MISS_CHAR ),
910: NVL( EFFECTIVE_START_DATE, FND_API.G_MISS_DATE ),
911: NVL( EFFECTIVE_END_DATE, FND_API.G_MISS_DATE ),
912: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),

Line 909: NVL( LAST_KNOWN_GPS, FND_API.G_MISS_CHAR ),

905: NVL( HEAD_OF_HOUSEHOLD_FLAG, FND_API.G_MISS_CHAR ),
906: NVL( HOUSEHOLD_INCOME, FND_API.G_MISS_NUM ),
907: NVL( HOUSEHOLD_SIZE, FND_API.G_MISS_NUM ),
908: NVL( RENT_OWN_IND, FND_API.G_MISS_CHAR ),
909: NVL( LAST_KNOWN_GPS, FND_API.G_MISS_CHAR ),
910: NVL( EFFECTIVE_START_DATE, FND_API.G_MISS_DATE ),
911: NVL( EFFECTIVE_END_DATE, FND_API.G_MISS_DATE ),
912: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
913: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),

Line 910: NVL( EFFECTIVE_START_DATE, FND_API.G_MISS_DATE ),

906: NVL( HOUSEHOLD_INCOME, FND_API.G_MISS_NUM ),
907: NVL( HOUSEHOLD_SIZE, FND_API.G_MISS_NUM ),
908: NVL( RENT_OWN_IND, FND_API.G_MISS_CHAR ),
909: NVL( LAST_KNOWN_GPS, FND_API.G_MISS_CHAR ),
910: NVL( EFFECTIVE_START_DATE, FND_API.G_MISS_DATE ),
911: NVL( EFFECTIVE_END_DATE, FND_API.G_MISS_DATE ),
912: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
913: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
914: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),

Line 911: NVL( EFFECTIVE_END_DATE, FND_API.G_MISS_DATE ),

907: NVL( HOUSEHOLD_SIZE, FND_API.G_MISS_NUM ),
908: NVL( RENT_OWN_IND, FND_API.G_MISS_CHAR ),
909: NVL( LAST_KNOWN_GPS, FND_API.G_MISS_CHAR ),
910: NVL( EFFECTIVE_START_DATE, FND_API.G_MISS_DATE ),
911: NVL( EFFECTIVE_END_DATE, FND_API.G_MISS_DATE ),
912: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
913: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
914: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
915: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),

Line 912: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),

908: NVL( RENT_OWN_IND, FND_API.G_MISS_CHAR ),
909: NVL( LAST_KNOWN_GPS, FND_API.G_MISS_CHAR ),
910: NVL( EFFECTIVE_START_DATE, FND_API.G_MISS_DATE ),
911: NVL( EFFECTIVE_END_DATE, FND_API.G_MISS_DATE ),
912: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
913: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
914: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
915: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
916: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),

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

909: NVL( LAST_KNOWN_GPS, FND_API.G_MISS_CHAR ),
910: NVL( EFFECTIVE_START_DATE, FND_API.G_MISS_DATE ),
911: NVL( EFFECTIVE_END_DATE, FND_API.G_MISS_DATE ),
912: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
913: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
914: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
915: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
916: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
917: NVL( MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

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

910: NVL( EFFECTIVE_START_DATE, FND_API.G_MISS_DATE ),
911: NVL( EFFECTIVE_END_DATE, FND_API.G_MISS_DATE ),
912: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
913: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
914: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
915: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
916: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
917: NVL( MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
918: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

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

911: NVL( EFFECTIVE_END_DATE, FND_API.G_MISS_DATE ),
912: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
913: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
914: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
915: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
916: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
917: NVL( MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
918: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
919: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),

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

912: NVL( CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR ),
913: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
914: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
915: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
916: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
917: NVL( MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
918: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
919: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
920: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR )

Line 917: NVL( MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR ),

913: NVL( KNOWN_AS2, FND_API.G_MISS_CHAR ),
914: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
915: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
916: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
917: NVL( MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
918: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
919: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
920: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR )
921: INTO

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

914: NVL( KNOWN_AS3, FND_API.G_MISS_CHAR ),
915: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
916: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
917: NVL( MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
918: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
919: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
920: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR )
921: INTO
922: X_PERSON_PROFILE_ID,

Line 919: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),

915: NVL( KNOWN_AS4, FND_API.G_MISS_CHAR ),
916: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
917: NVL( MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
918: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
919: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
920: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR )
921: INTO
922: X_PERSON_PROFILE_ID,
923: X_PARTY_ID,

Line 920: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR )

916: NVL( KNOWN_AS5, FND_API.G_MISS_CHAR ),
917: NVL( MIDDLE_NAME_PHONETIC, FND_API.G_MISS_CHAR ),
918: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
919: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
920: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR )
921: INTO
922: X_PERSON_PROFILE_ID,
923: X_PARTY_ID,
924: X_ATTRIBUTE_CATEGORY,

Line 997: RAISE FND_API.G_EXC_ERROR;

993: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
994: FND_MESSAGE.SET_TOKEN( 'RECORD', 'person_profile_rec');
995: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PERSON_PROFILE_ID ) );
996: FND_MSG_PUB.ADD;
997: RAISE FND_API.G_EXC_ERROR;
998:
999: END Select_Row;
1000:
1001: PROCEDURE Delete_Row (