68: l_success VARCHAR2(1) := 'N';
69:
70: BEGIN
71:
72: IF X_CUST_ACCT_SITE_ID = FND_API.G_MISS_NUM THEN
73: X_CUST_ACCT_SITE_ID := NULL;
74: END IF;
75:
76: WHILE l_success = 'N' LOOP
146: APPLICATION_ID,
147: ORG_ID
148: )
149: VALUES (
150: DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCT_SITES_S.NEXTVAL, NULL, HZ_CUST_ACCT_SITES_S.NEXTVAL, X_CUST_ACCT_SITE_ID ),
151: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
152: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
153: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
154: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
147: ORG_ID
148: )
149: VALUES (
150: DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCT_SITES_S.NEXTVAL, NULL, HZ_CUST_ACCT_SITES_S.NEXTVAL, X_CUST_ACCT_SITE_ID ),
151: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
152: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
153: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
154: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
155: HZ_UTILITY_V2PUB.CREATION_DATE,
148: )
149: VALUES (
150: DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCT_SITES_S.NEXTVAL, NULL, HZ_CUST_ACCT_SITES_S.NEXTVAL, X_CUST_ACCT_SITE_ID ),
151: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
152: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
153: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
154: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
155: HZ_UTILITY_V2PUB.CREATION_DATE,
156: HZ_UTILITY_V2PUB.CREATED_BY,
158: HZ_UTILITY_V2PUB.REQUEST_ID,
159: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
160: HZ_UTILITY_V2PUB.PROGRAM_ID,
161: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
162: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
163: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
164: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
165: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
166: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
159: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
160: HZ_UTILITY_V2PUB.PROGRAM_ID,
161: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
162: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
163: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
164: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
165: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
166: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
167: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
160: HZ_UTILITY_V2PUB.PROGRAM_ID,
161: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
162: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
163: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
164: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
165: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
166: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
167: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
168: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
161: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
162: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
163: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
164: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
165: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
166: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
167: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
168: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
169: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
162: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
163: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
164: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
165: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
166: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
167: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
168: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
169: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
170: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
163: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
164: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
165: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
166: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
167: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
168: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
169: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
170: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
171: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
164: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
165: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
166: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
167: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
168: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
169: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
170: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
171: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
172: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
165: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
166: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
167: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
168: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
169: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
170: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
171: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
172: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
173: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
166: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
167: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
168: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
169: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
170: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
171: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
172: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
173: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
174: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
167: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
168: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
169: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
170: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
171: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
172: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
173: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
174: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
175: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
168: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
169: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
170: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
171: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
172: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
173: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
174: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
175: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
176: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
169: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
170: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
171: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
172: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
173: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
174: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
175: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
176: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
177: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
170: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
171: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
172: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
173: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
174: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
175: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
176: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
177: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
178: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
171: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
172: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
173: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
174: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
175: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
176: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
177: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
178: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
179: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
172: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
173: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
174: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
175: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
176: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
177: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
178: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
179: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
180: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
173: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
174: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
175: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
176: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
177: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
178: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
179: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
180: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
181: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
174: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
175: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
176: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
177: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
178: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
179: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
180: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
181: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
182: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
175: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
176: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
177: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
178: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
179: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
180: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
181: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
182: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
183: DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
176: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
177: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
178: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
179: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
180: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
181: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
182: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
183: DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
184: DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
177: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
178: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
179: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
180: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
181: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
182: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
183: DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
184: DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
185: DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
178: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
179: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
180: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
181: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
182: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
183: DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
184: DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
185: DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
186: DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
179: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
180: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
181: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
182: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
183: DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
184: DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
185: DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
186: DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
187: DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
180: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
181: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
182: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
183: DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
184: DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
185: DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
186: DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
187: DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
188: DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
181: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
182: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
183: DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
184: DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
185: DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
186: DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
187: DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
188: DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
189: DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
182: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
183: DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
184: DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
185: DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
186: DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
187: DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
188: DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
189: DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
190: DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
183: DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
184: DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
185: DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
186: DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
187: DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
188: DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
189: DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
190: DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
191: DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
184: DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
185: DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
186: DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
187: DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
188: DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
189: DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
190: DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
191: DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
192: DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
185: DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
186: DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
187: DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
188: DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
189: DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
190: DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
191: DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
192: DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
193: DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
186: DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
187: DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
188: DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
189: DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
190: DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
191: DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
192: DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
193: DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
194: DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
187: DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
188: DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
189: DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
190: DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
191: DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
192: DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
193: DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
194: DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
195: DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
188: DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
189: DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
190: DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
191: DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
192: DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
193: DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
194: DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
195: DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
196: DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
189: DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
190: DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
191: DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
192: DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
193: DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
194: DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
195: DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
196: DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
197: DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
190: DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
191: DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
192: DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
193: DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
194: DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
195: DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
196: DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
197: DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
198: DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
191: DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
192: DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
193: DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
194: DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
195: DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
196: DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
197: DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
198: DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
199: DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
192: DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
193: DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
194: DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
195: DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
196: DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
197: DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
198: DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
199: DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
200: DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
193: DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
194: DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
195: DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
196: DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
197: DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
198: DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
199: DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
200: DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
201: DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
194: DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
195: DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
196: DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
197: DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
198: DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
199: DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
200: DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
201: DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
202: DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
195: DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
196: DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
197: DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
198: DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
199: DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
200: DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
201: DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
202: DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
203: DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
196: DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
197: DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
198: DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
199: DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
200: DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
201: DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
202: DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
203: DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
204: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
197: DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
198: DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
199: DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
200: DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
201: DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
202: DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
203: DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
204: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
205: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
198: DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
199: DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
200: DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
201: DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
202: DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
203: DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
204: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
205: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
206: DECODE( X_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
199: DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
200: DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
201: DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
202: DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
203: DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
204: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
205: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
206: DECODE( X_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
207: DECODE( X_KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
200: DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
201: DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
202: DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
203: DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
204: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
205: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
206: DECODE( X_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
207: DECODE( X_KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
208: DECODE( X_TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
201: DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
202: DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
203: DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
204: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
205: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
206: DECODE( X_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
207: DECODE( X_KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
208: DECODE( X_TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
209: DECODE( X_ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
202: DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
203: DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
204: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
205: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
206: DECODE( X_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
207: DECODE( X_KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
208: DECODE( X_TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
209: DECODE( X_ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
210: DECODE( X_PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
203: DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
204: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
205: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
206: DECODE( X_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
207: DECODE( X_KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
208: DECODE( X_TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
209: DECODE( X_ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
210: DECODE( X_PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
211: DECODE( X_SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
204: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
205: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
206: DECODE( X_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
207: DECODE( X_KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
208: DECODE( X_TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
209: DECODE( X_ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
210: DECODE( X_PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
211: DECODE( X_SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
212: DECODE( X_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
205: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
206: DECODE( X_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
207: DECODE( X_KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
208: DECODE( X_TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
209: DECODE( X_ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
210: DECODE( X_PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
211: DECODE( X_SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
212: DECODE( X_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
213: DECODE( X_TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
206: DECODE( X_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
207: DECODE( X_KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
208: DECODE( X_TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
209: DECODE( X_ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
210: DECODE( X_PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
211: DECODE( X_SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
212: DECODE( X_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
213: DECODE( X_TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
214: DECODE( X_TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
207: DECODE( X_KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
208: DECODE( X_TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
209: DECODE( X_ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
210: DECODE( X_PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
211: DECODE( X_SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
212: DECODE( X_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
213: DECODE( X_TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
214: DECODE( X_TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
215: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
208: DECODE( X_TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
209: DECODE( X_ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
210: DECODE( X_PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
211: DECODE( X_SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
212: DECODE( X_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
213: DECODE( X_TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
214: DECODE( X_TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
215: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
216: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
209: DECODE( X_ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
210: DECODE( X_PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
211: DECODE( X_SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
212: DECODE( X_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
213: DECODE( X_TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
214: DECODE( X_TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
215: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
216: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
217: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
210: DECODE( X_PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
211: DECODE( X_SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
212: DECODE( X_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
213: DECODE( X_TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
214: DECODE( X_TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
215: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
216: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
217: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
218: -- Bug 3456489
211: DECODE( X_SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
212: DECODE( X_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
213: DECODE( X_TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
214: DECODE( X_TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
215: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
216: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
217: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
218: -- Bug 3456489
219: -- DECODE( X_ORG_ID, NULL, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))), X_ORG_ID)
212: DECODE( X_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
213: DECODE( X_TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
214: DECODE( X_TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
215: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
216: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
217: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
218: -- Bug 3456489
219: -- DECODE( X_ORG_ID, NULL, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))), X_ORG_ID)
220: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID)
213: DECODE( X_TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
214: DECODE( X_TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
215: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
216: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
217: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
218: -- Bug 3456489
219: -- DECODE( X_ORG_ID, NULL, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))), X_ORG_ID)
220: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID)
221: ) RETURNING
216: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
217: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
218: -- Bug 3456489
219: -- DECODE( X_ORG_ID, NULL, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))), X_ORG_ID)
220: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID)
221: ) RETURNING
222: CUST_ACCT_SITE_ID
223: INTO
224: X_CUST_ACCT_SITE_ID;
348:
349: BEGIN
350:
351: UPDATE HZ_CUST_ACCT_SITES_ALL SET
352: CUST_ACCT_SITE_ID = DECODE( X_CUST_ACCT_SITE_ID, NULL, CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
353: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
354: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
355: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
349: BEGIN
350:
351: UPDATE HZ_CUST_ACCT_SITES_ALL SET
352: CUST_ACCT_SITE_ID = DECODE( X_CUST_ACCT_SITE_ID, NULL, CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
353: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
354: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
355: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: CREATION_DATE = CREATION_DATE,
350:
351: UPDATE HZ_CUST_ACCT_SITES_ALL SET
352: CUST_ACCT_SITE_ID = DECODE( X_CUST_ACCT_SITE_ID, NULL, CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
353: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
354: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
355: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: CREATION_DATE = CREATION_DATE,
358: CREATED_BY = CREATED_BY,
360: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
361: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
362: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
363: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
364: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
365: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
366: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
367: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
368: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
361: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
362: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
363: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
364: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
365: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
366: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
367: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
368: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
369: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
362: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
363: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
364: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
365: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
366: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
367: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
368: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
369: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
370: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
363: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
364: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
365: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
366: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
367: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
368: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
369: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
370: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
371: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
364: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
365: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
366: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
367: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
368: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
369: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
370: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
371: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
372: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
365: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
366: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
367: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
368: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
369: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
370: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
371: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
372: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
373: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
366: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
367: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
368: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
369: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
370: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
371: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
372: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
373: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
374: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
367: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
368: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
369: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
370: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
371: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
372: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
373: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
374: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
375: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
368: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
369: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
370: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
371: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
372: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
373: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
374: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
375: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
376: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
369: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
370: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
371: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
372: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
373: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
374: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
375: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
376: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
377: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
370: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
371: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
372: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
373: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
374: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
375: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
376: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
377: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
378: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
371: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
372: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
373: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
374: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
375: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
376: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
377: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
378: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
379: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
372: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
373: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
374: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
375: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
376: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
377: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
378: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
379: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
380: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
373: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
374: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
375: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
376: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
377: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
378: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
379: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
380: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
381: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
374: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
375: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
376: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
377: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
378: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
379: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
380: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
381: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
382: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
375: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
376: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
377: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
378: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
379: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
380: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
381: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
382: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
383: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
376: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
377: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
378: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
379: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
380: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
381: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
382: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
383: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
384: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
377: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
378: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
379: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
380: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
381: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
382: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
383: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
384: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
385: GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
378: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
379: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
380: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
381: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
382: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
383: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
384: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
385: GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
386: GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
379: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
380: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
381: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
382: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
383: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
384: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
385: GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
386: GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
387: GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
380: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
381: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
382: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
383: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
384: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
385: GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
386: GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
387: GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
388: GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
381: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
382: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
383: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
384: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
385: GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
386: GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
387: GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
388: GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
389: GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
382: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
383: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
384: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
385: GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
386: GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
387: GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
388: GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
389: GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
390: GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
383: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
384: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
385: GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
386: GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
387: GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
388: GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
389: GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
390: GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
391: GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
384: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
385: GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
386: GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
387: GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
388: GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
389: GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
390: GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
391: GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
392: GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
385: GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
386: GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
387: GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
388: GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
389: GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
390: GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
391: GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
392: GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
393: GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
386: GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
387: GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
388: GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
389: GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
390: GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
391: GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
392: GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
393: GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
394: GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
387: GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
388: GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
389: GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
390: GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
391: GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
392: GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
393: GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
394: GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
395: GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
388: GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
389: GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
390: GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
391: GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
392: GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
393: GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
394: GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
395: GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
396: GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
389: GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
390: GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
391: GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
392: GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
393: GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
394: GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
395: GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
396: GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
397: GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
390: GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
391: GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
392: GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
393: GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
394: GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
395: GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
396: GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
397: GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
398: GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
391: GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
392: GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
393: GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
394: GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
395: GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
396: GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
397: GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
398: GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
399: GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
392: GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
393: GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
394: GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
395: GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
396: GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
397: GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
398: GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
399: GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
400: GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
393: GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
394: GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
395: GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
396: GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
397: GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
398: GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
399: GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
400: GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
401: GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
394: GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
395: GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
396: GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
397: GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
398: GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
399: GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
400: GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
401: GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
402: GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
395: GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
396: GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
397: GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
398: GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
399: GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
400: GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
401: GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
402: GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
403: GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
396: GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
397: GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
398: GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
399: GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
400: GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
401: GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
402: GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
403: GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
404: GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
397: GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
398: GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
399: GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
400: GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
401: GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
402: GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
403: GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
404: GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
405: GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
398: GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
399: GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
400: GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
401: GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
402: GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
403: GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
404: GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
405: GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
406: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
399: GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
400: GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
401: GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
402: GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
403: GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
404: GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
405: GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
406: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
407: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
400: GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
401: GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
402: GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
403: GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
404: GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
405: GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
406: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
407: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
408: CUSTOMER_CATEGORY_CODE = DECODE( X_CUSTOMER_CATEGORY_CODE, NULL, CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
401: GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
402: GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
403: GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
404: GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
405: GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
406: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
407: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
408: CUSTOMER_CATEGORY_CODE = DECODE( X_CUSTOMER_CATEGORY_CODE, NULL, CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
409: KEY_ACCOUNT_FLAG = DECODE( X_KEY_ACCOUNT_FLAG, NULL, KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
402: GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
403: GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
404: GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
405: GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
406: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
407: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
408: CUSTOMER_CATEGORY_CODE = DECODE( X_CUSTOMER_CATEGORY_CODE, NULL, CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
409: KEY_ACCOUNT_FLAG = DECODE( X_KEY_ACCOUNT_FLAG, NULL, KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
410: TP_HEADER_ID = DECODE( X_TP_HEADER_ID, NULL, TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
403: GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
404: GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
405: GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
406: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
407: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
408: CUSTOMER_CATEGORY_CODE = DECODE( X_CUSTOMER_CATEGORY_CODE, NULL, CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
409: KEY_ACCOUNT_FLAG = DECODE( X_KEY_ACCOUNT_FLAG, NULL, KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
410: TP_HEADER_ID = DECODE( X_TP_HEADER_ID, NULL, TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
411: ECE_TP_LOCATION_CODE = DECODE( X_ECE_TP_LOCATION_CODE, NULL, ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
404: GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
405: GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
406: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
407: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
408: CUSTOMER_CATEGORY_CODE = DECODE( X_CUSTOMER_CATEGORY_CODE, NULL, CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
409: KEY_ACCOUNT_FLAG = DECODE( X_KEY_ACCOUNT_FLAG, NULL, KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
410: TP_HEADER_ID = DECODE( X_TP_HEADER_ID, NULL, TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
411: ECE_TP_LOCATION_CODE = DECODE( X_ECE_TP_LOCATION_CODE, NULL, ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
412: PRIMARY_SPECIALIST_ID = DECODE( X_PRIMARY_SPECIALIST_ID, NULL, PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
405: GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
406: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
407: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
408: CUSTOMER_CATEGORY_CODE = DECODE( X_CUSTOMER_CATEGORY_CODE, NULL, CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
409: KEY_ACCOUNT_FLAG = DECODE( X_KEY_ACCOUNT_FLAG, NULL, KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
410: TP_HEADER_ID = DECODE( X_TP_HEADER_ID, NULL, TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
411: ECE_TP_LOCATION_CODE = DECODE( X_ECE_TP_LOCATION_CODE, NULL, ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
412: PRIMARY_SPECIALIST_ID = DECODE( X_PRIMARY_SPECIALIST_ID, NULL, PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
413: SECONDARY_SPECIALIST_ID = DECODE( X_SECONDARY_SPECIALIST_ID, NULL, SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
406: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
407: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
408: CUSTOMER_CATEGORY_CODE = DECODE( X_CUSTOMER_CATEGORY_CODE, NULL, CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
409: KEY_ACCOUNT_FLAG = DECODE( X_KEY_ACCOUNT_FLAG, NULL, KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
410: TP_HEADER_ID = DECODE( X_TP_HEADER_ID, NULL, TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
411: ECE_TP_LOCATION_CODE = DECODE( X_ECE_TP_LOCATION_CODE, NULL, ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
412: PRIMARY_SPECIALIST_ID = DECODE( X_PRIMARY_SPECIALIST_ID, NULL, PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
413: SECONDARY_SPECIALIST_ID = DECODE( X_SECONDARY_SPECIALIST_ID, NULL, SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
414: TERRITORY_ID = DECODE( X_TERRITORY_ID, NULL, TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
407: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
408: CUSTOMER_CATEGORY_CODE = DECODE( X_CUSTOMER_CATEGORY_CODE, NULL, CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
409: KEY_ACCOUNT_FLAG = DECODE( X_KEY_ACCOUNT_FLAG, NULL, KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
410: TP_HEADER_ID = DECODE( X_TP_HEADER_ID, NULL, TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
411: ECE_TP_LOCATION_CODE = DECODE( X_ECE_TP_LOCATION_CODE, NULL, ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
412: PRIMARY_SPECIALIST_ID = DECODE( X_PRIMARY_SPECIALIST_ID, NULL, PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
413: SECONDARY_SPECIALIST_ID = DECODE( X_SECONDARY_SPECIALIST_ID, NULL, SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
414: TERRITORY_ID = DECODE( X_TERRITORY_ID, NULL, TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
415: TERRITORY = DECODE( X_TERRITORY, NULL, TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
408: CUSTOMER_CATEGORY_CODE = DECODE( X_CUSTOMER_CATEGORY_CODE, NULL, CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
409: KEY_ACCOUNT_FLAG = DECODE( X_KEY_ACCOUNT_FLAG, NULL, KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
410: TP_HEADER_ID = DECODE( X_TP_HEADER_ID, NULL, TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
411: ECE_TP_LOCATION_CODE = DECODE( X_ECE_TP_LOCATION_CODE, NULL, ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
412: PRIMARY_SPECIALIST_ID = DECODE( X_PRIMARY_SPECIALIST_ID, NULL, PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
413: SECONDARY_SPECIALIST_ID = DECODE( X_SECONDARY_SPECIALIST_ID, NULL, SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
414: TERRITORY_ID = DECODE( X_TERRITORY_ID, NULL, TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
415: TERRITORY = DECODE( X_TERRITORY, NULL, TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
416: TRANSLATED_CUSTOMER_NAME = DECODE( X_TRANSLATED_CUSTOMER_NAME, NULL, TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
409: KEY_ACCOUNT_FLAG = DECODE( X_KEY_ACCOUNT_FLAG, NULL, KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
410: TP_HEADER_ID = DECODE( X_TP_HEADER_ID, NULL, TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
411: ECE_TP_LOCATION_CODE = DECODE( X_ECE_TP_LOCATION_CODE, NULL, ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
412: PRIMARY_SPECIALIST_ID = DECODE( X_PRIMARY_SPECIALIST_ID, NULL, PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
413: SECONDARY_SPECIALIST_ID = DECODE( X_SECONDARY_SPECIALIST_ID, NULL, SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
414: TERRITORY_ID = DECODE( X_TERRITORY_ID, NULL, TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
415: TERRITORY = DECODE( X_TERRITORY, NULL, TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
416: TRANSLATED_CUSTOMER_NAME = DECODE( X_TRANSLATED_CUSTOMER_NAME, NULL, TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
417: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
410: TP_HEADER_ID = DECODE( X_TP_HEADER_ID, NULL, TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
411: ECE_TP_LOCATION_CODE = DECODE( X_ECE_TP_LOCATION_CODE, NULL, ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
412: PRIMARY_SPECIALIST_ID = DECODE( X_PRIMARY_SPECIALIST_ID, NULL, PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
413: SECONDARY_SPECIALIST_ID = DECODE( X_SECONDARY_SPECIALIST_ID, NULL, SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
414: TERRITORY_ID = DECODE( X_TERRITORY_ID, NULL, TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
415: TERRITORY = DECODE( X_TERRITORY, NULL, TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
416: TRANSLATED_CUSTOMER_NAME = DECODE( X_TRANSLATED_CUSTOMER_NAME, NULL, TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
417: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
418: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
411: ECE_TP_LOCATION_CODE = DECODE( X_ECE_TP_LOCATION_CODE, NULL, ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR, NULL, X_ECE_TP_LOCATION_CODE ),
412: PRIMARY_SPECIALIST_ID = DECODE( X_PRIMARY_SPECIALIST_ID, NULL, PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
413: SECONDARY_SPECIALIST_ID = DECODE( X_SECONDARY_SPECIALIST_ID, NULL, SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
414: TERRITORY_ID = DECODE( X_TERRITORY_ID, NULL, TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
415: TERRITORY = DECODE( X_TERRITORY, NULL, TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
416: TRANSLATED_CUSTOMER_NAME = DECODE( X_TRANSLATED_CUSTOMER_NAME, NULL, TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
417: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
418: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
419: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
412: PRIMARY_SPECIALIST_ID = DECODE( X_PRIMARY_SPECIALIST_ID, NULL, PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SPECIALIST_ID ),
413: SECONDARY_SPECIALIST_ID = DECODE( X_SECONDARY_SPECIALIST_ID, NULL, SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
414: TERRITORY_ID = DECODE( X_TERRITORY_ID, NULL, TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
415: TERRITORY = DECODE( X_TERRITORY, NULL, TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
416: TRANSLATED_CUSTOMER_NAME = DECODE( X_TRANSLATED_CUSTOMER_NAME, NULL, TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
417: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
418: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
419: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
420: WHERE ROWID = X_RowId;
413: SECONDARY_SPECIALIST_ID = DECODE( X_SECONDARY_SPECIALIST_ID, NULL, SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM, NULL, X_SECONDARY_SPECIALIST_ID ),
414: TERRITORY_ID = DECODE( X_TERRITORY_ID, NULL, TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
415: TERRITORY = DECODE( X_TERRITORY, NULL, TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
416: TRANSLATED_CUSTOMER_NAME = DECODE( X_TRANSLATED_CUSTOMER_NAME, NULL, TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
417: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
418: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
419: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
420: WHERE ROWID = X_RowId;
421:
414: TERRITORY_ID = DECODE( X_TERRITORY_ID, NULL, TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
415: TERRITORY = DECODE( X_TERRITORY, NULL, TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
416: TRANSLATED_CUSTOMER_NAME = DECODE( X_TRANSLATED_CUSTOMER_NAME, NULL, TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
417: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
418: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
419: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
420: WHERE ROWID = X_RowId;
421:
422: IF ( SQL%NOTFOUND ) THEN
415: TERRITORY = DECODE( X_TERRITORY, NULL, TERRITORY, FND_API.G_MISS_CHAR, NULL, X_TERRITORY ),
416: TRANSLATED_CUSTOMER_NAME = DECODE( X_TRANSLATED_CUSTOMER_NAME, NULL, TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, X_TRANSLATED_CUSTOMER_NAME ),
417: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
418: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
419: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
420: WHERE ROWID = X_RowId;
421:
422: IF ( SQL%NOTFOUND ) THEN
423: RAISE NO_DATA_FOUND;
794:
795: BEGIN
796:
797: SELECT
798: NVL( CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM ),
799: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
800: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
801: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
802: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
795: BEGIN
796:
797: SELECT
798: NVL( CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM ),
799: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
800: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
801: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
802: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
803: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
796:
797: SELECT
798: NVL( CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM ),
799: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
800: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
801: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
802: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
803: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
804: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
797: SELECT
798: NVL( CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM ),
799: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
800: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
801: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
802: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
803: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
804: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
805: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
798: NVL( CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM ),
799: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
800: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
801: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
802: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
803: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
804: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
805: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
806: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
799: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
800: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
801: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
802: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
803: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
804: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
805: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
806: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
807: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
800: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
801: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
802: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
803: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
804: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
805: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
806: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
807: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
808: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
801: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
802: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
803: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
804: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
805: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
806: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
807: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
808: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
809: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
802: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
803: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
804: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
805: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
806: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
807: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
808: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
809: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
810: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
803: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
804: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
805: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
806: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
807: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
808: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
809: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
810: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
811: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
804: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
805: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
806: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
807: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
808: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
809: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
810: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
811: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
812: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
805: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
806: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
807: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
808: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
809: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
810: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
811: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
812: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
813: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
806: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
807: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
808: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
809: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
810: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
811: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
812: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
813: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
814: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
807: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
808: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
809: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
810: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
811: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
812: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
813: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
814: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
815: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
808: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
809: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
810: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
811: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
812: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
813: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
814: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
815: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
816: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
809: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
810: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
811: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
812: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
813: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
814: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
815: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
816: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
817: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
810: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
811: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
812: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
813: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
814: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
815: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
816: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
817: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
818: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
811: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
812: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
813: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
814: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
815: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
816: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
817: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
818: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
819: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
812: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
813: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
814: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
815: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
816: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
817: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
818: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
819: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
820: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
813: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
814: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
815: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
816: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
817: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
818: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
819: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
820: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
821: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
814: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
815: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
816: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
817: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
818: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
819: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
820: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
821: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
822: NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
815: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
816: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
817: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
818: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
819: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
820: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
821: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
822: NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
823: NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
816: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
817: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
818: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
819: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
820: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
821: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
822: NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
823: NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
824: NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
817: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
818: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
819: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
820: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
821: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
822: NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
823: NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
824: NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
825: NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
818: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
819: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
820: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
821: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
822: NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
823: NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
824: NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
825: NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
826: NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
819: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
820: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
821: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
822: NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
823: NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
824: NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
825: NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
826: NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
827: NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
820: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
821: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
822: NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
823: NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
824: NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
825: NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
826: NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
827: NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
828: NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
821: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
822: NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
823: NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
824: NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
825: NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
826: NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
827: NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
828: NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
829: NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
822: NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
823: NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
824: NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
825: NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
826: NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
827: NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
828: NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
829: NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
830: NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
823: NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
824: NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
825: NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
826: NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
827: NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
828: NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
829: NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
830: NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
831: NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
824: NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
825: NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
826: NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
827: NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
828: NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
829: NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
830: NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
831: NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
832: NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
825: NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
826: NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
827: NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
828: NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
829: NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
830: NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
831: NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
832: NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
833: NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
826: NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
827: NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
828: NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
829: NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
830: NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
831: NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
832: NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
833: NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
834: NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
827: NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
828: NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
829: NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
830: NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
831: NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
832: NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
833: NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
834: NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
835: NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
828: NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
829: NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
830: NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
831: NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
832: NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
833: NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
834: NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
835: NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
836: NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
829: NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
830: NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
831: NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
832: NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
833: NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
834: NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
835: NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
836: NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
837: NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
830: NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
831: NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
832: NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
833: NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
834: NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
835: NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
836: NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
837: NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
838: NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
831: NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
832: NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
833: NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
834: NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
835: NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
836: NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
837: NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
838: NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
839: NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
832: NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
833: NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
834: NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
835: NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
836: NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
837: NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
838: NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
839: NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
840: NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
833: NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
834: NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
835: NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
836: NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
837: NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
838: NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
839: NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
840: NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
841: NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
834: NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
835: NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
836: NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
837: NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
838: NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
839: NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
840: NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
841: NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
842: NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
835: NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
836: NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
837: NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
838: NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
839: NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
840: NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
841: NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
842: NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
843: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
836: NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
837: NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
838: NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
839: NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
840: NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
841: NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
842: NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
843: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
844: NVL( STATUS, FND_API.G_MISS_CHAR ),
837: NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
838: NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
839: NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
840: NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
841: NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
842: NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
843: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
844: NVL( STATUS, FND_API.G_MISS_CHAR ),
845: NVL( CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR ),
838: NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
839: NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
840: NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
841: NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
842: NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
843: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
844: NVL( STATUS, FND_API.G_MISS_CHAR ),
845: NVL( CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR ),
846: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
839: NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
840: NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
841: NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
842: NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
843: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
844: NVL( STATUS, FND_API.G_MISS_CHAR ),
845: NVL( CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR ),
846: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
847: NVL( KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR ),
840: NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
841: NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
842: NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
843: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
844: NVL( STATUS, FND_API.G_MISS_CHAR ),
845: NVL( CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR ),
846: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
847: NVL( KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR ),
848: NVL( TP_HEADER_ID, FND_API.G_MISS_NUM ),
841: NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
842: NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
843: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
844: NVL( STATUS, FND_API.G_MISS_CHAR ),
845: NVL( CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR ),
846: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
847: NVL( KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR ),
848: NVL( TP_HEADER_ID, FND_API.G_MISS_NUM ),
849: NVL( ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR ),
842: NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
843: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
844: NVL( STATUS, FND_API.G_MISS_CHAR ),
845: NVL( CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR ),
846: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
847: NVL( KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR ),
848: NVL( TP_HEADER_ID, FND_API.G_MISS_NUM ),
849: NVL( ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR ),
850: NVL( PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
843: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
844: NVL( STATUS, FND_API.G_MISS_CHAR ),
845: NVL( CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR ),
846: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
847: NVL( KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR ),
848: NVL( TP_HEADER_ID, FND_API.G_MISS_NUM ),
849: NVL( ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR ),
850: NVL( PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
851: NVL( SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
844: NVL( STATUS, FND_API.G_MISS_CHAR ),
845: NVL( CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR ),
846: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
847: NVL( KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR ),
848: NVL( TP_HEADER_ID, FND_API.G_MISS_NUM ),
849: NVL( ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR ),
850: NVL( PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
851: NVL( SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
852: NVL( TERRITORY_ID, FND_API.G_MISS_NUM ),
845: NVL( CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR ),
846: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
847: NVL( KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR ),
848: NVL( TP_HEADER_ID, FND_API.G_MISS_NUM ),
849: NVL( ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR ),
850: NVL( PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
851: NVL( SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
852: NVL( TERRITORY_ID, FND_API.G_MISS_NUM ),
853: NVL( TERRITORY, FND_API.G_MISS_CHAR ),
846: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
847: NVL( KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR ),
848: NVL( TP_HEADER_ID, FND_API.G_MISS_NUM ),
849: NVL( ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR ),
850: NVL( PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
851: NVL( SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
852: NVL( TERRITORY_ID, FND_API.G_MISS_NUM ),
853: NVL( TERRITORY, FND_API.G_MISS_CHAR ),
854: NVL( TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR ),
847: NVL( KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR ),
848: NVL( TP_HEADER_ID, FND_API.G_MISS_NUM ),
849: NVL( ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR ),
850: NVL( PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
851: NVL( SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
852: NVL( TERRITORY_ID, FND_API.G_MISS_NUM ),
853: NVL( TERRITORY, FND_API.G_MISS_CHAR ),
854: NVL( TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR ),
855: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
848: NVL( TP_HEADER_ID, FND_API.G_MISS_NUM ),
849: NVL( ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR ),
850: NVL( PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
851: NVL( SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
852: NVL( TERRITORY_ID, FND_API.G_MISS_NUM ),
853: NVL( TERRITORY, FND_API.G_MISS_CHAR ),
854: NVL( TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR ),
855: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
856: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
849: NVL( ECE_TP_LOCATION_CODE, FND_API.G_MISS_CHAR ),
850: NVL( PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
851: NVL( SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
852: NVL( TERRITORY_ID, FND_API.G_MISS_NUM ),
853: NVL( TERRITORY, FND_API.G_MISS_CHAR ),
854: NVL( TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR ),
855: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
856: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
857: NVL( ORG_ID, FND_API.G_MISS_NUM)
850: NVL( PRIMARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
851: NVL( SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
852: NVL( TERRITORY_ID, FND_API.G_MISS_NUM ),
853: NVL( TERRITORY, FND_API.G_MISS_CHAR ),
854: NVL( TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR ),
855: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
856: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
857: NVL( ORG_ID, FND_API.G_MISS_NUM)
858: INTO
851: NVL( SECONDARY_SPECIALIST_ID, FND_API.G_MISS_NUM ),
852: NVL( TERRITORY_ID, FND_API.G_MISS_NUM ),
853: NVL( TERRITORY, FND_API.G_MISS_CHAR ),
854: NVL( TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR ),
855: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
856: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
857: NVL( ORG_ID, FND_API.G_MISS_NUM)
858: INTO
859: X_CUST_ACCT_SITE_ID,
852: NVL( TERRITORY_ID, FND_API.G_MISS_NUM ),
853: NVL( TERRITORY, FND_API.G_MISS_CHAR ),
854: NVL( TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR ),
855: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
856: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
857: NVL( ORG_ID, FND_API.G_MISS_NUM)
858: INTO
859: X_CUST_ACCT_SITE_ID,
860: X_CUST_ACCOUNT_ID,
853: NVL( TERRITORY, FND_API.G_MISS_CHAR ),
854: NVL( TRANSLATED_CUSTOMER_NAME, FND_API.G_MISS_CHAR ),
855: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
856: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
857: NVL( ORG_ID, FND_API.G_MISS_NUM)
858: INTO
859: X_CUST_ACCT_SITE_ID,
860: X_CUST_ACCOUNT_ID,
861: X_PARTY_SITE_ID,
924: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
925: FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_acct_site_rec');
926: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCT_SITE_ID ) );
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_ERROR;
929:
930: END Select_Row;
931:
932: PROCEDURE Delete_Row (