98: GLOBAL_LOCATION_NUMBER,
99: DUNS_NUMBER_C
100: )
101: VALUES (
102: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITES_S.NEXTVAL, NULL, HZ_PARTY_SITES_S.NEXTVAL, X_PARTY_SITE_ID ),
103: DECODE( X_PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), X_PARTY_SITE_NUMBER ),
104: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
105: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
99: DUNS_NUMBER_C
100: )
101: VALUES (
102: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITES_S.NEXTVAL, NULL, HZ_PARTY_SITES_S.NEXTVAL, X_PARTY_SITE_ID ),
103: DECODE( X_PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), X_PARTY_SITE_NUMBER ),
104: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
105: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
107: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
100: )
101: VALUES (
102: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITES_S.NEXTVAL, NULL, HZ_PARTY_SITES_S.NEXTVAL, X_PARTY_SITE_ID ),
103: DECODE( X_PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), X_PARTY_SITE_NUMBER ),
104: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
105: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
107: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
108: HZ_UTILITY_V2PUB.CREATION_DATE,
101: VALUES (
102: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITES_S.NEXTVAL, NULL, HZ_PARTY_SITES_S.NEXTVAL, X_PARTY_SITE_ID ),
103: DECODE( X_PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), X_PARTY_SITE_NUMBER ),
104: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
105: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
107: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
108: HZ_UTILITY_V2PUB.CREATION_DATE,
109: HZ_UTILITY_V2PUB.CREATED_BY,
111: HZ_UTILITY_V2PUB.REQUEST_ID,
112: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
113: HZ_UTILITY_V2PUB.PROGRAM_ID,
114: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
115: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
116: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
117: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
118: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
119: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
112: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
113: HZ_UTILITY_V2PUB.PROGRAM_ID,
114: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
115: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
116: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
117: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
118: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
119: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
120: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
113: HZ_UTILITY_V2PUB.PROGRAM_ID,
114: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
115: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
116: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
117: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
118: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
119: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
120: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
121: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
114: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
115: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
116: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
117: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
118: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
119: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
120: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
121: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
122: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
115: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
116: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
117: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
118: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
119: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
120: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
121: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
122: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
123: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
116: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
117: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
118: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
119: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
120: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
121: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
122: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
123: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
124: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
117: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
118: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
119: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
120: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
121: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
122: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
123: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
124: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
125: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
118: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
119: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
120: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
121: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
122: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
123: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
124: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
125: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
126: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
119: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
120: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
121: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
122: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
123: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
124: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
125: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
126: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
127: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
120: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
121: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
122: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
123: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
124: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
125: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
126: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
127: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
128: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
121: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
122: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
123: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
124: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
125: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
126: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
127: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
128: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
129: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
122: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
123: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
124: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
125: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
126: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
127: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
128: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
129: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
130: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
123: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
124: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
125: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
126: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
127: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
128: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
129: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
130: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
131: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
124: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
125: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
126: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
127: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
128: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
129: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
130: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
131: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
132: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
125: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
126: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
127: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
128: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
129: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
130: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
131: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
132: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
133: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
126: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
127: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
128: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
129: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
130: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
131: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
132: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
133: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
134: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
127: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
128: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
129: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
130: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
131: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
132: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
133: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
134: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
135: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
128: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
129: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
130: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
131: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
132: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
133: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
134: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
135: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
136: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
129: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
130: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
131: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
132: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
133: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
134: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
135: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
136: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
137: DECODE( X_MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
130: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
131: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
132: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
133: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
134: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
135: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
136: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
137: DECODE( X_MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
138: DECODE( X_IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
131: DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
132: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
133: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
134: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
135: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
136: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
137: DECODE( X_MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
138: DECODE( X_IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
139: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
132: DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
133: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
134: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
135: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
136: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
137: DECODE( X_MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
138: DECODE( X_IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
139: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
140: DECODE( X_PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
133: DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
134: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
135: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
136: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
137: DECODE( X_MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
138: DECODE( X_IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
139: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
140: DECODE( X_PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
141: DECODE( X_ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
134: DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
135: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
136: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
137: DECODE( X_MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
138: DECODE( X_IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
139: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
140: DECODE( X_PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
141: DECODE( X_ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
142: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
135: DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
136: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
137: DECODE( X_MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
138: DECODE( X_IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
139: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
140: DECODE( X_PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
141: DECODE( X_ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
142: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
136: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_PARTY_SITE_ID,HZ_PARTY_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
137: DECODE( X_MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
138: DECODE( X_IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
139: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
140: DECODE( X_PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
141: DECODE( X_ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
142: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
144: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
137: DECODE( X_MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
138: DECODE( X_IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
139: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
140: DECODE( X_PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
141: DECODE( X_ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
142: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
144: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
145: decode( X_ACTUAL_CONTENT_SOURCE,
138: DECODE( X_IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
139: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
140: DECODE( X_PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
141: DECODE( X_ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
142: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
144: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
145: decode( X_ACTUAL_CONTENT_SOURCE,
146: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
139: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
140: DECODE( X_PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
141: DECODE( X_ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
142: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
144: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
145: decode( X_ACTUAL_CONTENT_SOURCE,
146: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
147: NULL, G_MISS_CONTENT_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),
140: DECODE( X_PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
141: DECODE( X_ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
142: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
144: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
145: decode( X_ACTUAL_CONTENT_SOURCE,
146: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
147: NULL, G_MISS_CONTENT_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),
148: DECODE( X_GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
142: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
144: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
145: decode( X_ACTUAL_CONTENT_SOURCE,
146: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
147: NULL, G_MISS_CONTENT_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),
148: DECODE( X_GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
149: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )
150: ) RETURNING
144: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
145: decode( X_ACTUAL_CONTENT_SOURCE,
146: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
147: NULL, G_MISS_CONTENT_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),
148: DECODE( X_GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
149: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )
150: ) RETURNING
151: PARTY_SITE_ID,
152: PARTY_SITE_NUMBER
145: decode( X_ACTUAL_CONTENT_SOURCE,
146: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
147: NULL, G_MISS_CONTENT_SOURCE_TYPE, X_ACTUAL_CONTENT_SOURCE ),
148: DECODE( X_GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
149: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )
150: ) RETURNING
151: PARTY_SITE_ID,
152: PARTY_SITE_NUMBER
153: INTO
253:
254: BEGIN
255:
256: UPDATE HZ_PARTY_SITES SET
257: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
258: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
259: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
260: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
261: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),
254: BEGIN
255:
256: UPDATE HZ_PARTY_SITES SET
257: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
258: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
259: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
260: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
261: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),
262: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
255:
256: UPDATE HZ_PARTY_SITES SET
257: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
258: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
259: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
260: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
261: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),
262: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
263: CREATION_DATE = CREATION_DATE,
257: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
258: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
259: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
260: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
261: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),
262: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
263: CREATION_DATE = CREATION_DATE,
264: CREATED_BY = CREATED_BY,
265: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
266: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
267: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
271: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
272: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
273: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
274: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
267: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
271: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
272: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
273: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
274: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
275: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
271: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
272: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
273: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
274: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
275: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
276: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
271: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
272: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
273: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
274: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
275: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
276: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
277: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
270: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
271: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
272: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
273: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
274: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
275: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
276: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
277: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
278: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
271: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
272: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
273: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
274: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
275: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
276: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
277: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
278: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
279: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
272: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
273: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
274: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
275: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
276: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
277: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
278: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
279: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
280: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
273: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
274: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
275: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
276: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
277: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
278: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
279: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
280: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
281: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
274: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
275: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
276: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
277: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
278: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
279: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
280: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
281: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
282: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
275: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
276: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
277: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
278: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
279: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
280: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
281: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
282: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
283: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
276: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
277: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
278: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
279: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
280: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
281: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
282: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
283: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
284: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
277: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
278: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
279: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
280: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
281: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
282: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
283: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
284: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
285: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
278: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
279: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
280: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
281: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
282: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
283: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
284: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
285: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
286: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
279: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
280: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
281: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
282: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
283: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
284: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
285: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
286: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
287: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
280: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
281: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
282: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
283: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
284: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
285: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
286: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
287: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
288: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
281: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
282: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
283: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
284: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
285: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
286: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
287: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
288: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
289: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
282: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
283: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
284: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
285: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
286: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
287: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
288: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
289: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
290: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
283: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
284: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
285: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
286: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
287: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
288: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
289: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
290: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
291: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
284: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
285: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
286: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
287: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
288: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
289: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
290: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
291: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
292: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
285: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
286: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
287: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
288: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
289: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
290: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
291: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
292: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
293: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
286: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
287: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
288: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
289: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
290: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
291: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
292: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
293: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
294: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
287: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
288: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
289: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
290: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
291: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
292: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
293: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
294: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
295: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
288: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
289: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
290: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
291: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
292: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
293: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
294: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
295: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
296: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
289: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
290: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
291: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
292: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
293: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
294: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
295: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
296: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
290: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
291: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
292: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
293: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
294: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
295: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
296: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
291: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
292: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
293: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
294: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
295: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
296: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
292: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
293: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
294: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
295: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
296: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
293: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
294: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
295: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
296: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
301: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),
294: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
295: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
296: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
301: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),
302: GLOBAL_LOCATION_NUMBER = DECODE ( X_GLOBAL_LOCATION_NUMBER, NULL, GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
295: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
296: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
301: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),
302: GLOBAL_LOCATION_NUMBER = DECODE ( X_GLOBAL_LOCATION_NUMBER, NULL, GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
303: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )
297: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
301: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),
302: GLOBAL_LOCATION_NUMBER = DECODE ( X_GLOBAL_LOCATION_NUMBER, NULL, GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
303: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )
304: WHERE ROWID = X_RowId;
305:
298: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
301: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),
302: GLOBAL_LOCATION_NUMBER = DECODE ( X_GLOBAL_LOCATION_NUMBER, NULL, GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
303: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )
304: WHERE ROWID = X_RowId;
305:
306: IF ( SQL%NOTFOUND ) THEN
299: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
300: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
301: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),
302: GLOBAL_LOCATION_NUMBER = DECODE ( X_GLOBAL_LOCATION_NUMBER, NULL, GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
303: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )
304: WHERE ROWID = X_RowId;
305:
306: IF ( SQL%NOTFOUND ) THEN
307: RAISE NO_DATA_FOUND;
563:
564: BEGIN
565:
566: SELECT
567: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
568: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
569: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
570: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
571: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
564: BEGIN
565:
566: SELECT
567: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
568: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
569: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
570: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
571: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
572: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
565:
566: SELECT
567: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
568: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
569: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
570: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
571: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
572: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
573: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
566: SELECT
567: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
568: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
569: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
570: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
571: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
572: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
573: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
574: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
567: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
568: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
569: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
570: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
571: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
572: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
573: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
574: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
575: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
568: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
569: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
570: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
571: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
572: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
573: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
574: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
575: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
576: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
569: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
570: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
571: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
572: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
573: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
574: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
575: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
576: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
577: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
570: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
571: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
572: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
573: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
574: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
575: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
576: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
577: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
578: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
571: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
572: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
573: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
574: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
575: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
576: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
577: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
578: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
579: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
572: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
573: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
574: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
575: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
576: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
577: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
578: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
579: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
580: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
573: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
574: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
575: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
576: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
577: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
578: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
579: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
580: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
581: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
574: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
575: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
576: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
577: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
578: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
579: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
580: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
581: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
582: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
575: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
576: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
577: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
578: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
579: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
580: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
581: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
582: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
583: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
576: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
577: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
578: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
579: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
580: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
581: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
582: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
583: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
584: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
577: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
578: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
579: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
580: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
581: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
582: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
583: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
584: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
585: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
578: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
579: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
580: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
581: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
582: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
583: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
584: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
585: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
586: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
579: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
580: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
581: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
582: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
583: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
584: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
585: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
586: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
587: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
580: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
581: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
582: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
583: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
584: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
585: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
586: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
587: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
588: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
581: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
582: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
583: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
584: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
585: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
586: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
587: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
588: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
589: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
582: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
583: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
584: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
585: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
586: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
587: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
588: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
589: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
590: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
583: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
584: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
585: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
586: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
587: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
588: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
589: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
590: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
591: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
584: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
585: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
586: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
587: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
588: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
589: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
590: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
591: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
592: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
585: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
586: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
587: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
588: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
589: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
590: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
591: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
592: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
593: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
586: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
587: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
588: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
589: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
590: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
591: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
592: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
593: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
594: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
587: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
588: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
589: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
590: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
591: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
592: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
593: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
594: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
595: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
588: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
589: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
590: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
591: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
592: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
593: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
594: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
595: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
596: NVL( STATUS, FND_API.G_MISS_CHAR ),
589: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
590: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
591: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
592: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
593: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
594: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
595: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
596: NVL( STATUS, FND_API.G_MISS_CHAR ),
597: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
590: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
591: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
592: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
593: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
594: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
595: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
596: NVL( STATUS, FND_API.G_MISS_CHAR ),
597: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
598: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
591: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
592: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
593: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
594: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
595: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
596: NVL( STATUS, FND_API.G_MISS_CHAR ),
597: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
598: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
599: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
592: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
593: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
594: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
595: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
596: NVL( STATUS, FND_API.G_MISS_CHAR ),
597: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
598: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
599: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
600: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
593: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
594: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
595: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
596: NVL( STATUS, FND_API.G_MISS_CHAR ),
597: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
598: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
599: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
600: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
601: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
594: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
595: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
596: NVL( STATUS, FND_API.G_MISS_CHAR ),
597: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
598: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
599: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
600: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
601: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
602: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),
595: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
596: NVL( STATUS, FND_API.G_MISS_CHAR ),
597: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
598: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
599: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
600: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
601: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
602: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),
603: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR )
596: NVL( STATUS, FND_API.G_MISS_CHAR ),
597: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
598: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
599: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
600: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
601: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
602: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),
603: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR )
604: INTO
597: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
598: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
599: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
600: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
601: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
602: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),
603: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR )
604: INTO
605: X_PARTY_SITE_ID,
598: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
599: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
600: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
601: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
602: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),
603: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR )
604: INTO
605: X_PARTY_SITE_ID,
606: X_PARTY_ID,
599: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
600: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
601: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
602: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),
603: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR )
604: INTO
605: X_PARTY_SITE_ID,
606: X_PARTY_ID,
607: X_LOCATION_ID,
647: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
648: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party_site_rec');
649: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PARTY_SITE_ID ) );
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652:
653: END Select_Row;
654:
655: PROCEDURE Delete_Row (