APPS.HZ_PARTY_SITES_PKG dependencies on FND_API

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

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,

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

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,

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

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,

Line 105: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),

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,

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

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

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 ),

Line 137: DECODE( X_MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),

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 ),

Line 138: DECODE( X_IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_IDENTIFYING_ADDRESS_FLAG ),

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 ),

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

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 ),

Line 140: DECODE( X_PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),

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 ),

Line 141: DECODE( X_ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),

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,

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

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,

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

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 ),

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

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),

Line 146: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

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

Line 148: DECODE( X_GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),

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

Line 149: DECODE( X_DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )

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

Line 209: RAISE FND_API.G_EXC_ERROR;

205:
206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
207: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');
208: FND_MSG_PUB.ADD;
209: RAISE FND_API.G_EXC_ERROR;
210: ELSE
211: l_count := 1;
212: WHILE l_count > 0 LOOP
213: SELECT TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL )

Line 281: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),

277:
278: BEGIN
279:
280: UPDATE HZ_PARTY_SITES SET
281: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
282: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
283: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
284: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
285: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),

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

278: BEGIN
279:
280: UPDATE HZ_PARTY_SITES SET
281: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
282: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
283: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
284: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
285: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),
286: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 283: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),

279:
280: UPDATE HZ_PARTY_SITES SET
281: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
282: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
283: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
284: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
285: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),
286: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
287: CREATION_DATE = CREATION_DATE,

Line 285: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),

281: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
282: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
283: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
284: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
285: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),
286: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
287: CREATION_DATE = CREATION_DATE,
288: CREATED_BY = CREATED_BY,
289: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

290: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
291: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
292: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
293: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
294: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
295: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
296: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
297: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
298: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

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

291: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
292: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
293: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
294: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
295: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
296: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
297: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
298: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
299: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

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

292: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
293: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
294: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
295: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
296: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
297: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
298: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
299: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
300: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

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

293: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
294: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
295: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
296: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
297: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
298: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
299: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
300: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
301: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

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

294: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
295: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
296: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
297: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
298: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
299: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
300: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
301: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
302: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

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

295: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
296: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
297: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
298: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
299: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
300: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
301: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
302: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
303: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

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

296: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
297: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
298: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
299: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
300: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
301: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
302: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
303: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
304: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

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

297: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
298: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
299: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
300: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
301: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
302: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
303: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
304: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
305: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

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

298: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
299: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
300: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
301: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
302: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
303: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
304: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
305: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
306: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

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

299: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
300: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
301: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
302: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
303: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
304: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
305: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
306: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
307: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

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

300: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
301: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
302: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
303: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
304: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
305: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
306: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
307: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
308: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

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

301: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
302: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
303: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
304: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
305: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
306: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
307: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
308: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
309: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

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

302: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
303: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
304: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
305: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
306: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
307: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
308: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
309: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
310: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),

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

303: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
304: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
305: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
306: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
307: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
308: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
309: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
310: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
311: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),

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

304: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
305: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
306: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
307: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
308: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
309: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
310: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
311: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
312: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),

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

305: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
306: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
307: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
308: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
309: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
310: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
311: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
312: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
313: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),

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

306: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
307: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
308: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
309: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
310: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
311: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
312: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
313: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
314: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),

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

307: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
308: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
309: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
310: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
311: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
312: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
313: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
314: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
315: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),

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

308: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
309: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
310: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
311: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
312: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
313: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
314: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
315: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
316: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),

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

309: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
310: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
311: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
312: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
313: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
314: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
315: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
316: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
317: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),

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

310: ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
311: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
312: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
313: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
314: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
315: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
316: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
317: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
318: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

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

311: ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
312: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
313: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
314: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
315: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
316: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
317: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
318: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
319: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),

Line 316: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),

312: ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
313: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
314: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
315: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
316: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
317: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
318: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
319: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
320: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),

Line 317: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),

313: ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
314: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
315: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
316: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
317: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
318: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
319: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
320: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
321: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

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

314: ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
315: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
316: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
317: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
318: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
319: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
320: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
321: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
322: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 319: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),

315: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
316: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
317: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
318: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
319: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
320: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
321: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
322: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
323: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

Line 320: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),

316: MAILSTOP = DECODE( X_MAILSTOP, NULL, MAILSTOP, FND_API.G_MISS_CHAR, NULL, X_MAILSTOP ),
317: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
318: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
319: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
320: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
321: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
322: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
323: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
324: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,

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

317: IDENTIFYING_ADDRESS_FLAG = DECODE( X_IDENTIFYING_ADDRESS_FLAG, NULL, IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR, 'N', X_IDENTIFYING_ADDRESS_FLAG ),
318: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
319: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
320: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
321: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
322: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
323: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
324: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
325: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),

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

318: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
319: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
320: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
321: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
322: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
323: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
324: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
325: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),
326: GLOBAL_LOCATION_NUMBER = DECODE ( X_GLOBAL_LOCATION_NUMBER, NULL, GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),

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

319: PARTY_SITE_NAME = DECODE( X_PARTY_SITE_NAME, NULL, PARTY_SITE_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NAME ),
320: ADDRESSEE = DECODE( X_ADDRESSEE, NULL, ADDRESSEE, FND_API.G_MISS_CHAR, NULL, X_ADDRESSEE ),
321: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
322: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
323: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
324: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
325: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),
326: GLOBAL_LOCATION_NUMBER = DECODE ( X_GLOBAL_LOCATION_NUMBER, NULL, GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
327: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )

Line 325: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),

321: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
322: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
323: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
324: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
325: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),
326: GLOBAL_LOCATION_NUMBER = DECODE ( X_GLOBAL_LOCATION_NUMBER, NULL, GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
327: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )
328: WHERE ROWID = X_RowId;
329:

Line 326: GLOBAL_LOCATION_NUMBER = DECODE ( X_GLOBAL_LOCATION_NUMBER, NULL, GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),

322: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
323: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
324: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
325: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),
326: GLOBAL_LOCATION_NUMBER = DECODE ( X_GLOBAL_LOCATION_NUMBER, NULL, GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
327: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )
328: WHERE ROWID = X_RowId;
329:
330: IF ( SQL%NOTFOUND ) THEN

Line 327: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )

323: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
324: ACTUAL_CONTENT_SOURCE = DECODE( x_ACTUAL_CONTENT_SOURCE, NULL, ACTUAL_CONTENT_SOURCE,
325: FND_API.G_MISS_CHAR, NULL, X_ACTUAL_CONTENT_SOURCE),
326: GLOBAL_LOCATION_NUMBER = DECODE ( X_GLOBAL_LOCATION_NUMBER, NULL, GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_LOCATION_NUMBER),
327: DUNS_NUMBER_C = DECODE( X_DUNS_NUMBER_C, NULL, DUNS_NUMBER_C, FND_API.G_MISS_CHAR, NULL, X_DUNS_NUMBER_C )
328: WHERE ROWID = X_RowId;
329:
330: IF ( SQL%NOTFOUND ) THEN
331: RAISE NO_DATA_FOUND;

Line 591: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),

587:
588: BEGIN
589:
590: SELECT
591: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
592: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
593: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
594: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
595: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),

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

588: BEGIN
589:
590: SELECT
591: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
592: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
593: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
594: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
595: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
596: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),

Line 593: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),

589:
590: SELECT
591: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
592: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
593: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
594: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
595: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
596: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
597: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),

Line 594: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),

590: SELECT
591: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
592: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
593: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
594: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
595: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
596: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
597: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
598: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),

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

591: NVL( PARTY_SITE_ID, FND_API.G_MISS_NUM ),
592: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
593: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
594: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
595: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
596: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
597: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
598: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
599: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),

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

592: NVL( PARTY_ID, FND_API.G_MISS_NUM ),
593: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
594: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
595: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
596: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
597: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
598: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
599: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
600: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),

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

593: NVL( LOCATION_ID, FND_API.G_MISS_NUM ),
594: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
595: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
596: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
597: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
598: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
599: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
600: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),

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

594: NVL( PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR ),
595: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
596: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
597: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
598: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
599: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
600: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),

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

595: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
596: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
597: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
598: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
599: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
600: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),

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

596: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
597: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
598: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
599: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
600: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),

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

597: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
598: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
599: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
600: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),

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

598: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
599: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
600: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),

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

599: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
600: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),

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

600: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
601: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),

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

601: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
602: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),

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

602: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
603: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),

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

603: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
604: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),

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

604: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
605: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),

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

605: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
606: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),

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

606: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
607: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),

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

607: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
608: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),

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

608: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
609: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
616: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),

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

609: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
610: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
616: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
617: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),

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

610: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
611: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
616: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
617: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
618: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),

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

611: NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
612: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
616: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
617: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
618: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
619: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),

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

612: NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
613: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
616: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
617: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
618: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
619: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
620: NVL( STATUS, FND_API.G_MISS_CHAR ),

Line 617: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),

613: NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
614: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
616: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
617: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
618: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
619: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
620: NVL( STATUS, FND_API.G_MISS_CHAR ),
621: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),

Line 618: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),

614: NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
615: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
616: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
617: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
618: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
619: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
620: NVL( STATUS, FND_API.G_MISS_CHAR ),
621: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
622: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),

Line 619: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),

615: NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
616: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
617: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
618: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
619: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
620: NVL( STATUS, FND_API.G_MISS_CHAR ),
621: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
622: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
623: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

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

616: NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
617: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
618: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
619: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
620: NVL( STATUS, FND_API.G_MISS_CHAR ),
621: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
622: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
623: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
624: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),

Line 621: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),

617: NVL( LANGUAGE, FND_API.G_MISS_CHAR ),
618: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
619: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
620: NVL( STATUS, FND_API.G_MISS_CHAR ),
621: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
622: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
623: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
624: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
625: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),

Line 622: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),

618: NVL( MAILSTOP, FND_API.G_MISS_CHAR ),
619: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
620: NVL( STATUS, FND_API.G_MISS_CHAR ),
621: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
622: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
623: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
624: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
625: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
626: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),

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

619: NVL( IDENTIFYING_ADDRESS_FLAG, FND_API.G_MISS_CHAR ),
620: NVL( STATUS, FND_API.G_MISS_CHAR ),
621: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
622: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
623: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
624: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
625: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
626: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),
627: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR )

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

620: NVL( STATUS, FND_API.G_MISS_CHAR ),
621: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
622: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
623: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
624: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
625: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
626: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),
627: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR )
628: INTO

Line 625: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),

621: NVL( PARTY_SITE_NAME, FND_API.G_MISS_CHAR ),
622: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
623: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
624: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
625: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
626: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),
627: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR )
628: INTO
629: X_PARTY_SITE_ID,

Line 626: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),

622: NVL( ADDRESSEE, FND_API.G_MISS_CHAR ),
623: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
624: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
625: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
626: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),
627: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR )
628: INTO
629: X_PARTY_SITE_ID,
630: X_PARTY_ID,

Line 627: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR )

623: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
624: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
625: NVL( ACTUAL_CONTENT_SOURCE, FND_API.G_MISS_CHAR ),
626: NVL( GLOBAL_LOCATION_NUMBER, FND_API.G_MISS_CHAR ),
627: NVL( DUNS_NUMBER_C, FND_API.G_MISS_CHAR )
628: INTO
629: X_PARTY_SITE_ID,
630: X_PARTY_ID,
631: X_LOCATION_ID,

Line 675: RAISE FND_API.G_EXC_ERROR;

671: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
672: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party_site_rec');
673: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PARTY_SITE_ID ) );
674: FND_MSG_PUB.ADD;
675: RAISE FND_API.G_EXC_ERROR;
676:
677: END Select_Row;
678:
679: PROCEDURE Delete_Row (