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.

[Home] [Help]

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: DATE_OF_BIRTH = DECODE( TO_CHAR(X_DATE_OF_BIRTH,'DD/MM/YYYY'), NULL, DATE_OF_BIRTH, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/YYYY'), NULL, X_DATE_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: DATE_OF_BIRTH = DECODE( TO_CHAR(X_DATE_OF_BIRTH,'DD/MM/YYYY'), NULL, DATE_OF_BIRTH, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/YYYY'), NULL, X_DATE_OF_BIRTH ),
415: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),

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: DATE_OF_BIRTH = DECODE( TO_CHAR(X_DATE_OF_BIRTH,'DD/MM/YYYY'), NULL, DATE_OF_BIRTH, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/YYYY'), NULL, X_DATE_OF_BIRTH ),
415: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
416: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),

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: DATE_OF_BIRTH = DECODE( TO_CHAR(X_DATE_OF_BIRTH,'DD/MM/YYYY'), NULL, DATE_OF_BIRTH, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/YYYY'), NULL, X_DATE_OF_BIRTH ),
415: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
416: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
417: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),

Line 414: DATE_OF_BIRTH = DECODE( TO_CHAR(X_DATE_OF_BIRTH,'DD/MM/YYYY'), NULL, DATE_OF_BIRTH, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/YYYY'), NULL, X_DATE_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: DATE_OF_BIRTH = DECODE( TO_CHAR(X_DATE_OF_BIRTH,'DD/MM/YYYY'), NULL, DATE_OF_BIRTH, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/YYYY'), NULL, X_DATE_OF_BIRTH ),
415: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
416: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
417: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
418: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),

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

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: DATE_OF_BIRTH = DECODE( TO_CHAR(X_DATE_OF_BIRTH,'DD/MM/YYYY'), NULL, DATE_OF_BIRTH, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/YYYY'), NULL, X_DATE_OF_BIRTH ),
415: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
416: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
417: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
418: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
419: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),

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

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: DATE_OF_BIRTH = DECODE( TO_CHAR(X_DATE_OF_BIRTH,'DD/MM/YYYY'), NULL, DATE_OF_BIRTH, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/YYYY'), NULL, X_DATE_OF_BIRTH ),
415: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
416: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
417: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
418: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
419: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
420: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),

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

413: -- DATE_OF_BIRTH = DECODE( X_DATE_OF_BIRTH, NULL, DATE_OF_BIRTH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_BIRTH ),
414: DATE_OF_BIRTH = DECODE( TO_CHAR(X_DATE_OF_BIRTH,'DD/MM/YYYY'), NULL, DATE_OF_BIRTH, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/YYYY'), NULL, X_DATE_OF_BIRTH ),
415: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
416: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
417: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
418: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
419: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
420: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
421: 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 418: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),

414: DATE_OF_BIRTH = DECODE( TO_CHAR(X_DATE_OF_BIRTH,'DD/MM/YYYY'), NULL, DATE_OF_BIRTH, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/YYYY'), NULL, X_DATE_OF_BIRTH ),
415: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
416: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
417: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
418: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
419: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
420: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
421: 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 ),
422: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),

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

415: PLACE_OF_BIRTH = DECODE( X_PLACE_OF_BIRTH, NULL, PLACE_OF_BIRTH, FND_API.G_MISS_CHAR, NULL, X_PLACE_OF_BIRTH ),
416: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
417: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
418: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
419: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
420: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
421: 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 ),
422: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
423: 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 420: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),

416: DATE_OF_DEATH = DECODE( X_DATE_OF_DEATH, NULL, DATE_OF_DEATH, FND_API.G_MISS_DATE, NULL, X_DATE_OF_DEATH ),
417: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
418: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
419: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
420: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
421: 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 ),
422: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
423: 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 ),
424: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),

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

417: DECEASED_FLAG = DECODE( X_DECEASED_FLAG, NULL, DECEASED_FLAG, FND_API.G_MISS_CHAR, NULL, X_DECEASED_FLAG ),
418: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
419: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
420: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
421: 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 ),
422: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
423: 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 ),
424: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
425: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),

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

418: GENDER = DECODE( X_GENDER, NULL, GENDER, FND_API.G_MISS_CHAR, NULL, X_GENDER ),
419: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
420: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
421: 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 ),
422: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
423: 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 ),
424: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
425: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
426: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),

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

419: DECLARED_ETHNICITY = DECODE( X_DECLARED_ETHNICITY, NULL, DECLARED_ETHNICITY, FND_API.G_MISS_CHAR, NULL, X_DECLARED_ETHNICITY ),
420: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
421: 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 ),
422: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
423: 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 ),
424: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
425: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
426: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
427: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),

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

420: MARITAL_STATUS = DECODE( X_MARITAL_STATUS, NULL, MARITAL_STATUS, FND_API.G_MISS_CHAR, NULL, X_MARITAL_STATUS ),
421: 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 ),
422: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
423: 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 ),
424: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
425: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
426: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
427: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
428: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),

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

421: 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 ),
422: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
423: 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 ),
424: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
425: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
426: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
427: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
428: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),
429: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),

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

422: PERSONAL_INCOME = DECODE( X_PERSONAL_INCOME, NULL, PERSONAL_INCOME, FND_API.G_MISS_NUM, NULL, X_PERSONAL_INCOME ),
423: 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 ),
424: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
425: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
426: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
427: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
428: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),
429: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),
430: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),

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

423: 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 ),
424: HOUSEHOLD_INCOME = DECODE( X_HOUSEHOLD_INCOME, NULL, HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
425: HOUSEHOLD_SIZE = DECODE( X_HOUSEHOLD_SIZE, NULL, HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
426: RENT_OWN_IND = DECODE( X_RENT_OWN_IND, NULL, RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
427: LAST_KNOWN_GPS = DECODE( X_LAST_KNOWN_GPS, NULL, LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
428: EFFECTIVE_START_DATE = DECODE( X_EFFECTIVE_START_DATE, NULL, EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_START_DATE ),
429: EFFECTIVE_END_DATE = DECODE( X_EFFECTIVE_END_DATE, NULL, EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, NULL, X_EFFECTIVE_END_DATE ),
430: CONTENT_SOURCE_TYPE = DECODE( X_CONTENT_SOURCE_TYPE, NULL, CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, X_CONTENT_SOURCE_TYPE ),
431: KNOWN_AS2 = DECODE( X_KNOWN_AS2, NULL, KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 921: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR )

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

Line 998: RAISE FND_API.G_EXC_ERROR;

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