eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_LOCATIONS_PKG dependencies on FND_API

Line 93: x_location_id <> fnd_api.g_miss_num

89: -- and raise corresponding exception. We donot need to do anything
90: -- for those tables without polity functions.
91:
92: IF x_location_id IS NOT NULL AND
93: x_location_id <> fnd_api.g_miss_num
94: THEN
95: l_primary_key_passed := TRUE;
96: END IF;
97:

Line 98: IF x_geometry.sdo_gtype <> FND_API.G_MISS_NUM OR

94: THEN
95: l_primary_key_passed := TRUE;
96: END IF;
97:
98: IF x_geometry.sdo_gtype <> FND_API.G_MISS_NUM OR
99: x_geometry.sdo_srid <> FND_API.G_MISS_NUM OR
100: x_geometry.sdo_point IS NOT NULL OR
101: x_geometry.sdo_elem_info IS NOT NULL OR
102: x_geometry.sdo_ordinates IS NOT NULL

Line 99: x_geometry.sdo_srid <> FND_API.G_MISS_NUM OR

95: l_primary_key_passed := TRUE;
96: END IF;
97:
98: IF x_geometry.sdo_gtype <> FND_API.G_MISS_NUM OR
99: x_geometry.sdo_srid <> FND_API.G_MISS_NUM OR
100: x_geometry.sdo_point IS NOT NULL OR
101: x_geometry.sdo_elem_info IS NOT NULL OR
102: x_geometry.sdo_ordinates IS NOT NULL
103: THEN

Line 182: fnd_api.g_miss_num, hr_locations_s.NEXTVAL,

178: delivery_point_code
179: )
180: VALUES (
181: DECODE(x_location_id,
182: fnd_api.g_miss_num, hr_locations_s.NEXTVAL,
183: NULL, hr_locations_s.NEXTVAL,
184: x_location_id),
185: hz_utility_v2pub.last_update_date,
186: hz_utility_v2pub.last_updated_by,

Line 195: fnd_api.g_miss_char, NULL,

191: hz_utility_v2pub.program_application_id,
192: hz_utility_v2pub.program_id,
193: hz_utility_v2pub.program_update_date,
194: DECODE(x_attribute_category,
195: fnd_api.g_miss_char, NULL,
196: x_attribute_category),
197: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
198: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
199: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),

Line 197: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),

193: hz_utility_v2pub.program_update_date,
194: DECODE(x_attribute_category,
195: fnd_api.g_miss_char, NULL,
196: x_attribute_category),
197: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
198: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
199: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
200: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
201: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),

Line 198: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),

194: DECODE(x_attribute_category,
195: fnd_api.g_miss_char, NULL,
196: x_attribute_category),
197: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
198: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
199: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
200: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
201: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
202: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),

Line 199: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),

195: fnd_api.g_miss_char, NULL,
196: x_attribute_category),
197: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
198: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
199: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
200: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
201: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
202: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
203: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),

Line 200: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),

196: x_attribute_category),
197: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
198: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
199: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
200: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
201: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
202: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
203: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
204: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),

Line 201: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),

197: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
198: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
199: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
200: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
201: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
202: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
203: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
204: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
205: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),

Line 202: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),

198: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
199: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
200: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
201: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
202: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
203: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
204: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
205: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
206: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),

Line 203: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),

199: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
200: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
201: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
202: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
203: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
204: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
205: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
206: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
207: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),

Line 204: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),

200: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
201: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
202: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
203: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
204: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
205: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
206: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
207: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
208: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),

Line 205: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),

201: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
202: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
203: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
204: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
205: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
206: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
207: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
208: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
209: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),

Line 206: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),

202: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
203: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
204: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
205: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
206: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
207: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
208: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
209: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
210: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),

Line 207: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),

203: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
204: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
205: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
206: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
207: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
208: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
209: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
210: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
211: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),

Line 208: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),

204: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
205: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
206: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
207: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
208: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
209: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
210: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
211: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
212: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),

Line 209: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),

205: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
206: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
207: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
208: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
209: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
210: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
211: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
212: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
213: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),

Line 210: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),

206: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
207: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
208: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
209: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
210: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
211: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
212: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
213: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
214: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),

Line 211: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),

207: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
208: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
209: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
210: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
211: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
212: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
213: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
214: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
215: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),

Line 212: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),

208: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
209: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
210: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
211: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
212: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
213: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
214: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
215: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
216: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),

Line 213: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),

209: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
210: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
211: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
212: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
213: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
214: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
215: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
216: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
217: DECODE(x_orig_system_reference,

Line 214: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),

210: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
211: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
212: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
213: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
214: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
215: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
216: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
217: DECODE(x_orig_system_reference,
218: fnd_api.g_miss_char, TO_CHAR(NVL(x_location_id,

Line 215: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),

211: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
212: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
213: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
214: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
215: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
216: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
217: DECODE(x_orig_system_reference,
218: fnd_api.g_miss_char, TO_CHAR(NVL(x_location_id,
219: hr_locations_s.CURRVAL)),

Line 216: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),

212: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
213: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
214: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
215: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
216: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
217: DECODE(x_orig_system_reference,
218: fnd_api.g_miss_char, TO_CHAR(NVL(x_location_id,
219: hr_locations_s.CURRVAL)),
220: NULL, TO_CHAR(NVL(x_location_id, hr_locations_s.CURRVAL)),

Line 218: fnd_api.g_miss_char, TO_CHAR(NVL(x_location_id,

214: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
215: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
216: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
217: DECODE(x_orig_system_reference,
218: fnd_api.g_miss_char, TO_CHAR(NVL(x_location_id,
219: hr_locations_s.CURRVAL)),
220: NULL, TO_CHAR(NVL(x_location_id, hr_locations_s.CURRVAL)),
221: x_orig_system_reference),
222: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),

Line 222: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),

218: fnd_api.g_miss_char, TO_CHAR(NVL(x_location_id,
219: hr_locations_s.CURRVAL)),
220: NULL, TO_CHAR(NVL(x_location_id, hr_locations_s.CURRVAL)),
221: x_orig_system_reference),
222: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),
223: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
224: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
225: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
226: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),

Line 223: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),

219: hr_locations_s.CURRVAL)),
220: NULL, TO_CHAR(NVL(x_location_id, hr_locations_s.CURRVAL)),
221: x_orig_system_reference),
222: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),
223: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
224: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
225: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
226: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
227: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),

Line 224: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),

220: NULL, TO_CHAR(NVL(x_location_id, hr_locations_s.CURRVAL)),
221: x_orig_system_reference),
222: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),
223: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
224: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
225: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
226: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
227: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
228: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),

Line 225: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),

221: x_orig_system_reference),
222: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),
223: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
224: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
225: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
226: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
227: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
228: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
229: DECODE(x_state, fnd_api.g_miss_char, NULL, x_state),

Line 226: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),

222: DECODE(x_country, fnd_api.g_miss_char, NULL, x_country),
223: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
224: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
225: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
226: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
227: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
228: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
229: DECODE(x_state, fnd_api.g_miss_char, NULL, x_state),
230: DECODE(x_province, fnd_api.g_miss_char, NULL, x_province),

Line 227: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),

223: DECODE(x_address1, fnd_api.g_miss_char, NULL, x_address1),
224: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
225: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
226: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
227: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
228: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
229: DECODE(x_state, fnd_api.g_miss_char, NULL, x_state),
230: DECODE(x_province, fnd_api.g_miss_char, NULL, x_province),
231: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),

Line 228: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),

224: DECODE(x_address2, fnd_api.g_miss_char, NULL, x_address2),
225: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
226: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
227: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
228: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
229: DECODE(x_state, fnd_api.g_miss_char, NULL, x_state),
230: DECODE(x_province, fnd_api.g_miss_char, NULL, x_province),
231: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
232: DECODE(x_address_key, fnd_api.g_miss_char, NULL, x_address_key),

Line 229: DECODE(x_state, fnd_api.g_miss_char, NULL, x_state),

225: DECODE(x_address3, fnd_api.g_miss_char, NULL, x_address3),
226: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
227: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
228: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
229: DECODE(x_state, fnd_api.g_miss_char, NULL, x_state),
230: DECODE(x_province, fnd_api.g_miss_char, NULL, x_province),
231: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
232: DECODE(x_address_key, fnd_api.g_miss_char, NULL, x_address_key),
233: DECODE(x_address_style, fnd_api.g_miss_char, NULL, x_address_style),

Line 230: DECODE(x_province, fnd_api.g_miss_char, NULL, x_province),

226: DECODE(x_address4, fnd_api.g_miss_char, NULL, x_address4),
227: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
228: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
229: DECODE(x_state, fnd_api.g_miss_char, NULL, x_state),
230: DECODE(x_province, fnd_api.g_miss_char, NULL, x_province),
231: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
232: DECODE(x_address_key, fnd_api.g_miss_char, NULL, x_address_key),
233: DECODE(x_address_style, fnd_api.g_miss_char, NULL, x_address_style),
234: DECODE(x_validated_flag,

Line 231: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),

227: DECODE(x_city, fnd_api.g_miss_char, NULL, x_city),
228: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
229: DECODE(x_state, fnd_api.g_miss_char, NULL, x_state),
230: DECODE(x_province, fnd_api.g_miss_char, NULL, x_province),
231: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
232: DECODE(x_address_key, fnd_api.g_miss_char, NULL, x_address_key),
233: DECODE(x_address_style, fnd_api.g_miss_char, NULL, x_address_style),
234: DECODE(x_validated_flag,
235: fnd_api.g_miss_char, 'N',

Line 232: DECODE(x_address_key, fnd_api.g_miss_char, NULL, x_address_key),

228: DECODE(x_postal_code, fnd_api.g_miss_char, NULL, x_postal_code),
229: DECODE(x_state, fnd_api.g_miss_char, NULL, x_state),
230: DECODE(x_province, fnd_api.g_miss_char, NULL, x_province),
231: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
232: DECODE(x_address_key, fnd_api.g_miss_char, NULL, x_address_key),
233: DECODE(x_address_style, fnd_api.g_miss_char, NULL, x_address_style),
234: DECODE(x_validated_flag,
235: fnd_api.g_miss_char, 'N',
236: NULL, 'N',

Line 233: DECODE(x_address_style, fnd_api.g_miss_char, NULL, x_address_style),

229: DECODE(x_state, fnd_api.g_miss_char, NULL, x_state),
230: DECODE(x_province, fnd_api.g_miss_char, NULL, x_province),
231: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
232: DECODE(x_address_key, fnd_api.g_miss_char, NULL, x_address_key),
233: DECODE(x_address_style, fnd_api.g_miss_char, NULL, x_address_style),
234: DECODE(x_validated_flag,
235: fnd_api.g_miss_char, 'N',
236: NULL, 'N',
237: x_validated_flag),

Line 235: fnd_api.g_miss_char, 'N',

231: DECODE(x_county, fnd_api.g_miss_char, NULL, x_county),
232: DECODE(x_address_key, fnd_api.g_miss_char, NULL, x_address_key),
233: DECODE(x_address_style, fnd_api.g_miss_char, NULL, x_address_style),
234: DECODE(x_validated_flag,
235: fnd_api.g_miss_char, 'N',
236: NULL, 'N',
237: x_validated_flag),
238: DECODE(x_address_lines_phonetic,
239: fnd_api.g_miss_char, NULL,

Line 239: fnd_api.g_miss_char, NULL,

235: fnd_api.g_miss_char, 'N',
236: NULL, 'N',
237: x_validated_flag),
238: DECODE(x_address_lines_phonetic,
239: fnd_api.g_miss_char, NULL,
240: x_address_lines_phonetic),
241: DECODE(x_postal_plus4_code,
242: fnd_api.g_miss_char, NULL,
243: x_postal_plus4_code),

Line 242: fnd_api.g_miss_char, NULL,

238: DECODE(x_address_lines_phonetic,
239: fnd_api.g_miss_char, NULL,
240: x_address_lines_phonetic),
241: DECODE(x_postal_plus4_code,
242: fnd_api.g_miss_char, NULL,
243: x_postal_plus4_code),
244: DECODE(x_position, fnd_api.g_miss_char, NULL, x_position),
245: DECODE(x_location_directions,
246: fnd_api.g_miss_char, NULL,

Line 244: DECODE(x_position, fnd_api.g_miss_char, NULL, x_position),

240: x_address_lines_phonetic),
241: DECODE(x_postal_plus4_code,
242: fnd_api.g_miss_char, NULL,
243: x_postal_plus4_code),
244: DECODE(x_position, fnd_api.g_miss_char, NULL, x_position),
245: DECODE(x_location_directions,
246: fnd_api.g_miss_char, NULL,
247: x_location_directions),
248: DECODE(x_address_effective_date,

Line 246: fnd_api.g_miss_char, NULL,

242: fnd_api.g_miss_char, NULL,
243: x_postal_plus4_code),
244: DECODE(x_position, fnd_api.g_miss_char, NULL, x_position),
245: DECODE(x_location_directions,
246: fnd_api.g_miss_char, NULL,
247: x_location_directions),
248: DECODE(x_address_effective_date,
249: fnd_api.g_miss_date, TO_DATE(NULL),
250: x_address_effective_date),

Line 249: fnd_api.g_miss_date, TO_DATE(NULL),

245: DECODE(x_location_directions,
246: fnd_api.g_miss_char, NULL,
247: x_location_directions),
248: DECODE(x_address_effective_date,
249: fnd_api.g_miss_date, TO_DATE(NULL),
250: x_address_effective_date),
251: DECODE(x_address_expiration_date,
252: fnd_api.g_miss_date, TO_DATE(NULL),
253: x_address_expiration_date),

Line 252: fnd_api.g_miss_date, TO_DATE(NULL),

248: DECODE(x_address_effective_date,
249: fnd_api.g_miss_date, TO_DATE(NULL),
250: x_address_effective_date),
251: DECODE(x_address_expiration_date,
252: fnd_api.g_miss_date, TO_DATE(NULL),
253: x_address_expiration_date),
254: DECODE(x_clli_code, fnd_api.g_miss_char, NULL, x_clli_code),
255: DECODE(x_language, fnd_api.g_miss_char, NULL, x_language),
256: DECODE(x_short_description,

Line 254: DECODE(x_clli_code, fnd_api.g_miss_char, NULL, x_clli_code),

250: x_address_effective_date),
251: DECODE(x_address_expiration_date,
252: fnd_api.g_miss_date, TO_DATE(NULL),
253: x_address_expiration_date),
254: DECODE(x_clli_code, fnd_api.g_miss_char, NULL, x_clli_code),
255: DECODE(x_language, fnd_api.g_miss_char, NULL, x_language),
256: DECODE(x_short_description,
257: fnd_api.g_miss_char, NULL,
258: x_short_description),

Line 255: DECODE(x_language, fnd_api.g_miss_char, NULL, x_language),

251: DECODE(x_address_expiration_date,
252: fnd_api.g_miss_date, TO_DATE(NULL),
253: x_address_expiration_date),
254: DECODE(x_clli_code, fnd_api.g_miss_char, NULL, x_clli_code),
255: DECODE(x_language, fnd_api.g_miss_char, NULL, x_language),
256: DECODE(x_short_description,
257: fnd_api.g_miss_char, NULL,
258: x_short_description),
259: DECODE(x_description, fnd_api.g_miss_char, NULL, x_description),

Line 257: fnd_api.g_miss_char, NULL,

253: x_address_expiration_date),
254: DECODE(x_clli_code, fnd_api.g_miss_char, NULL, x_clli_code),
255: DECODE(x_language, fnd_api.g_miss_char, NULL, x_language),
256: DECODE(x_short_description,
257: fnd_api.g_miss_char, NULL,
258: x_short_description),
259: DECODE(x_description, fnd_api.g_miss_char, NULL, x_description),
260: DECODE(x_content_source_type,
261: fnd_api.g_miss_char, g_miss_content_source_type,

Line 259: DECODE(x_description, fnd_api.g_miss_char, NULL, x_description),

255: DECODE(x_language, fnd_api.g_miss_char, NULL, x_language),
256: DECODE(x_short_description,
257: fnd_api.g_miss_char, NULL,
258: x_short_description),
259: DECODE(x_description, fnd_api.g_miss_char, NULL, x_description),
260: DECODE(x_content_source_type,
261: fnd_api.g_miss_char, g_miss_content_source_type,
262: NULL, g_miss_content_source_type,
263: x_content_source_type),

Line 261: fnd_api.g_miss_char, g_miss_content_source_type,

257: fnd_api.g_miss_char, NULL,
258: x_short_description),
259: DECODE(x_description, fnd_api.g_miss_char, NULL, x_description),
260: DECODE(x_content_source_type,
261: fnd_api.g_miss_char, g_miss_content_source_type,
262: NULL, g_miss_content_source_type,
263: x_content_source_type),
264: DECODE(x_loc_hierarchy_id,
265: fnd_api.g_miss_num, NULL,

Line 265: fnd_api.g_miss_num, NULL,

261: fnd_api.g_miss_char, g_miss_content_source_type,
262: NULL, g_miss_content_source_type,
263: x_content_source_type),
264: DECODE(x_loc_hierarchy_id,
265: fnd_api.g_miss_num, NULL,
266: x_loc_hierarchy_id),
267: DECODE(x_sales_tax_geocode,
268: fnd_api.g_miss_char, NULL,
269: x_sales_tax_geocode),

Line 268: fnd_api.g_miss_char, NULL,

264: DECODE(x_loc_hierarchy_id,
265: fnd_api.g_miss_num, NULL,
266: x_loc_hierarchy_id),
267: DECODE(x_sales_tax_geocode,
268: fnd_api.g_miss_char, NULL,
269: x_sales_tax_geocode),
270: DECODE(x_sales_tax_inside_city_limits,
271: fnd_api.g_miss_char, '1',
272: NULL, '1',

Line 271: fnd_api.g_miss_char, '1',

267: DECODE(x_sales_tax_geocode,
268: fnd_api.g_miss_char, NULL,
269: x_sales_tax_geocode),
270: DECODE(x_sales_tax_inside_city_limits,
271: fnd_api.g_miss_char, '1',
272: NULL, '1',
273: x_sales_tax_inside_city_limits),
274: DECODE(x_fa_location_id, fnd_api.g_miss_num, NULL, x_fa_location_id),
275: l_geometry,

Line 274: DECODE(x_fa_location_id, fnd_api.g_miss_num, NULL, x_fa_location_id),

270: DECODE(x_sales_tax_inside_city_limits,
271: fnd_api.g_miss_char, '1',
272: NULL, '1',
273: x_sales_tax_inside_city_limits),
274: DECODE(x_fa_location_id, fnd_api.g_miss_num, NULL, x_fa_location_id),
275: l_geometry,
276: DECODE(x_object_version_number,
277: fnd_api.g_miss_num, NULL,
278: x_object_version_number),

Line 277: fnd_api.g_miss_num, NULL,

273: x_sales_tax_inside_city_limits),
274: DECODE(x_fa_location_id, fnd_api.g_miss_num, NULL, x_fa_location_id),
275: l_geometry,
276: DECODE(x_object_version_number,
277: fnd_api.g_miss_num, NULL,
278: x_object_version_number),
279: DECODE(x_timezone_id, fnd_api.g_miss_num, NULL, x_timezone_id),
280: DECODE(x_created_by_module,
281: fnd_api.g_miss_char, NULL,

Line 279: DECODE(x_timezone_id, fnd_api.g_miss_num, NULL, x_timezone_id),

275: l_geometry,
276: DECODE(x_object_version_number,
277: fnd_api.g_miss_num, NULL,
278: x_object_version_number),
279: DECODE(x_timezone_id, fnd_api.g_miss_num, NULL, x_timezone_id),
280: DECODE(x_created_by_module,
281: fnd_api.g_miss_char, NULL,
282: x_created_by_module),
283: DECODE(x_application_id, fnd_api.g_miss_num, NULL, x_application_id),

Line 281: fnd_api.g_miss_char, NULL,

277: fnd_api.g_miss_num, NULL,
278: x_object_version_number),
279: DECODE(x_timezone_id, fnd_api.g_miss_num, NULL, x_timezone_id),
280: DECODE(x_created_by_module,
281: fnd_api.g_miss_char, NULL,
282: x_created_by_module),
283: DECODE(x_application_id, fnd_api.g_miss_num, NULL, x_application_id),
284: DECODE(x_actual_content_source,
285: fnd_api.g_miss_char, g_miss_content_source_type,

Line 283: DECODE(x_application_id, fnd_api.g_miss_num, NULL, x_application_id),

279: DECODE(x_timezone_id, fnd_api.g_miss_num, NULL, x_timezone_id),
280: DECODE(x_created_by_module,
281: fnd_api.g_miss_char, NULL,
282: x_created_by_module),
283: DECODE(x_application_id, fnd_api.g_miss_num, NULL, x_application_id),
284: DECODE(x_actual_content_source,
285: fnd_api.g_miss_char, g_miss_content_source_type,
286: NULL, g_miss_content_source_type,
287: x_actual_content_source),

Line 285: fnd_api.g_miss_char, g_miss_content_source_type,

281: fnd_api.g_miss_char, NULL,
282: x_created_by_module),
283: DECODE(x_application_id, fnd_api.g_miss_num, NULL, x_application_id),
284: DECODE(x_actual_content_source,
285: fnd_api.g_miss_char, g_miss_content_source_type,
286: NULL, g_miss_content_source_type,
287: x_actual_content_source),
288: DECODE(x_geometry_status_code,
289: NULL, g_default_geometry_status_code,

Line 290: fnd_api.g_miss_char, NULL,

286: NULL, g_miss_content_source_type,
287: x_actual_content_source),
288: DECODE(x_geometry_status_code,
289: NULL, g_default_geometry_status_code,
290: fnd_api.g_miss_char, NULL,
291: x_geometry_status_code),
292: -- Bug 2670546.
293: DECODE(x_delivery_point_code,
294: fnd_api.g_miss_char,

Line 294: fnd_api.g_miss_char,

290: fnd_api.g_miss_char, NULL,
291: x_geometry_status_code),
292: -- Bug 2670546.
293: DECODE(x_delivery_point_code,
294: fnd_api.g_miss_char,
295: NULL,
296: x_delivery_point_code)
297: ) RETURNING
298: location_id

Line 313: RAISE fnd_api.g_exc_error;

309: IF l_primary_key_passed THEN
310: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
311: fnd_message.set_token('COLUMN', 'location_id');
312: fnd_msg_pub.add;
313: RAISE fnd_api.g_exc_error;
314: END IF;
315:
316: DECLARE
317: l_count NUMBER;

Line 419: fnd_api.g_miss_num, NULL,

415: BEGIN
416: UPDATE hz_locations
417: SET location_id = DECODE(x_location_id,
418: NULL, location_id,
419: fnd_api.g_miss_num, NULL,
420: x_location_id),
421: last_update_date = hz_utility_v2pub.last_update_date,
422: last_updated_by = hz_utility_v2pub.last_updated_by,
423: creation_date = creation_date,

Line 432: fnd_api.g_miss_char, NULL,

428: program_id = hz_utility_v2pub.program_id,
429: program_update_date = hz_utility_v2pub.program_update_date,
430: attribute_category = DECODE(x_attribute_category,
431: NULL, attribute_category,
432: fnd_api.g_miss_char, NULL,
433: x_attribute_category),
434: attribute1 = DECODE(x_attribute1,
435: NULL, attribute1,
436: fnd_api.g_miss_char, NULL,

Line 436: fnd_api.g_miss_char, NULL,

432: fnd_api.g_miss_char, NULL,
433: x_attribute_category),
434: attribute1 = DECODE(x_attribute1,
435: NULL, attribute1,
436: fnd_api.g_miss_char, NULL,
437: x_attribute1),
438: attribute2 = DECODE(x_attribute2,
439: NULL, attribute2,
440: fnd_api.g_miss_char, NULL,

Line 440: fnd_api.g_miss_char, NULL,

436: fnd_api.g_miss_char, NULL,
437: x_attribute1),
438: attribute2 = DECODE(x_attribute2,
439: NULL, attribute2,
440: fnd_api.g_miss_char, NULL,
441: x_attribute2),
442: attribute3 = DECODE(x_attribute3,
443: NULL, attribute3,
444: fnd_api.g_miss_char, NULL,

Line 444: fnd_api.g_miss_char, NULL,

440: fnd_api.g_miss_char, NULL,
441: x_attribute2),
442: attribute3 = DECODE(x_attribute3,
443: NULL, attribute3,
444: fnd_api.g_miss_char, NULL,
445: x_attribute3),
446: attribute4 = DECODE(x_attribute4,
447: NULL, attribute4,
448: fnd_api.g_miss_char, NULL,

Line 448: fnd_api.g_miss_char, NULL,

444: fnd_api.g_miss_char, NULL,
445: x_attribute3),
446: attribute4 = DECODE(x_attribute4,
447: NULL, attribute4,
448: fnd_api.g_miss_char, NULL,
449: x_attribute4),
450: attribute5 = DECODE(x_attribute5,
451: NULL, attribute5,
452: fnd_api.g_miss_char, NULL,

Line 452: fnd_api.g_miss_char, NULL,

448: fnd_api.g_miss_char, NULL,
449: x_attribute4),
450: attribute5 = DECODE(x_attribute5,
451: NULL, attribute5,
452: fnd_api.g_miss_char, NULL,
453: x_attribute5),
454: attribute6 = DECODE(x_attribute6,
455: NULL, attribute6,
456: fnd_api.g_miss_char, NULL,

Line 456: fnd_api.g_miss_char, NULL,

452: fnd_api.g_miss_char, NULL,
453: x_attribute5),
454: attribute6 = DECODE(x_attribute6,
455: NULL, attribute6,
456: fnd_api.g_miss_char, NULL,
457: x_attribute6),
458: attribute7 = DECODE(x_attribute7,
459: NULL, attribute7,
460: fnd_api.g_miss_char, NULL,

Line 460: fnd_api.g_miss_char, NULL,

456: fnd_api.g_miss_char, NULL,
457: x_attribute6),
458: attribute7 = DECODE(x_attribute7,
459: NULL, attribute7,
460: fnd_api.g_miss_char, NULL,
461: x_attribute7),
462: attribute8 = DECODE(x_attribute8,
463: NULL, attribute8,
464: fnd_api.g_miss_char, NULL,

Line 464: fnd_api.g_miss_char, NULL,

460: fnd_api.g_miss_char, NULL,
461: x_attribute7),
462: attribute8 = DECODE(x_attribute8,
463: NULL, attribute8,
464: fnd_api.g_miss_char, NULL,
465: x_attribute8),
466: attribute9 = DECODE(x_attribute9,
467: NULL, attribute9,
468: fnd_api.g_miss_char, NULL,

Line 468: fnd_api.g_miss_char, NULL,

464: fnd_api.g_miss_char, NULL,
465: x_attribute8),
466: attribute9 = DECODE(x_attribute9,
467: NULL, attribute9,
468: fnd_api.g_miss_char, NULL,
469: x_attribute9),
470: attribute10 = DECODE(x_attribute10,
471: NULL, attribute10,
472: fnd_api.g_miss_char, NULL,

Line 472: fnd_api.g_miss_char, NULL,

468: fnd_api.g_miss_char, NULL,
469: x_attribute9),
470: attribute10 = DECODE(x_attribute10,
471: NULL, attribute10,
472: fnd_api.g_miss_char, NULL,
473: x_attribute10),
474: attribute11 = DECODE(x_attribute11,
475: NULL, attribute11,
476: fnd_api.g_miss_char, NULL,

Line 476: fnd_api.g_miss_char, NULL,

472: fnd_api.g_miss_char, NULL,
473: x_attribute10),
474: attribute11 = DECODE(x_attribute11,
475: NULL, attribute11,
476: fnd_api.g_miss_char, NULL,
477: x_attribute11),
478: attribute12 = DECODE(x_attribute12,
479: NULL, attribute12,
480: fnd_api.g_miss_char, NULL,

Line 480: fnd_api.g_miss_char, NULL,

476: fnd_api.g_miss_char, NULL,
477: x_attribute11),
478: attribute12 = DECODE(x_attribute12,
479: NULL, attribute12,
480: fnd_api.g_miss_char, NULL,
481: x_attribute12),
482: attribute13 = DECODE(x_attribute13,
483: NULL, attribute13,
484: fnd_api.g_miss_char, NULL,

Line 484: fnd_api.g_miss_char, NULL,

480: fnd_api.g_miss_char, NULL,
481: x_attribute12),
482: attribute13 = DECODE(x_attribute13,
483: NULL, attribute13,
484: fnd_api.g_miss_char, NULL,
485: x_attribute13),
486: attribute14 = DECODE(x_attribute14,
487: NULL, attribute14,
488: fnd_api.g_miss_char, NULL,

Line 488: fnd_api.g_miss_char, NULL,

484: fnd_api.g_miss_char, NULL,
485: x_attribute13),
486: attribute14 = DECODE(x_attribute14,
487: NULL, attribute14,
488: fnd_api.g_miss_char, NULL,
489: x_attribute14),
490: attribute15 = DECODE(x_attribute15,
491: NULL, attribute15,
492: fnd_api.g_miss_char, NULL,

Line 492: fnd_api.g_miss_char, NULL,

488: fnd_api.g_miss_char, NULL,
489: x_attribute14),
490: attribute15 = DECODE(x_attribute15,
491: NULL, attribute15,
492: fnd_api.g_miss_char, NULL,
493: x_attribute15),
494: attribute16 = DECODE(x_attribute16,
495: NULL, attribute16,
496: fnd_api.g_miss_char, NULL,

Line 496: fnd_api.g_miss_char, NULL,

492: fnd_api.g_miss_char, NULL,
493: x_attribute15),
494: attribute16 = DECODE(x_attribute16,
495: NULL, attribute16,
496: fnd_api.g_miss_char, NULL,
497: x_attribute16),
498: attribute17 = DECODE(x_attribute17,
499: NULL, attribute17,
500: fnd_api.g_miss_char, NULL,

Line 500: fnd_api.g_miss_char, NULL,

496: fnd_api.g_miss_char, NULL,
497: x_attribute16),
498: attribute17 = DECODE(x_attribute17,
499: NULL, attribute17,
500: fnd_api.g_miss_char, NULL,
501: x_attribute17),
502: attribute18 = DECODE(x_attribute18,
503: NULL, attribute18,
504: fnd_api.g_miss_char, NULL,

Line 504: fnd_api.g_miss_char, NULL,

500: fnd_api.g_miss_char, NULL,
501: x_attribute17),
502: attribute18 = DECODE(x_attribute18,
503: NULL, attribute18,
504: fnd_api.g_miss_char, NULL,
505: x_attribute18),
506: attribute19 = DECODE(x_attribute19,
507: NULL, attribute19,
508: fnd_api.g_miss_char, NULL,

Line 508: fnd_api.g_miss_char, NULL,

504: fnd_api.g_miss_char, NULL,
505: x_attribute18),
506: attribute19 = DECODE(x_attribute19,
507: NULL, attribute19,
508: fnd_api.g_miss_char, NULL,
509: x_attribute19),
510: attribute20 = DECODE(x_attribute20,
511: NULL, attribute20,
512: fnd_api.g_miss_char, NULL,

Line 512: fnd_api.g_miss_char, NULL,

508: fnd_api.g_miss_char, NULL,
509: x_attribute19),
510: attribute20 = DECODE(x_attribute20,
511: NULL, attribute20,
512: fnd_api.g_miss_char, NULL,
513: x_attribute20),
514: orig_system_reference
515: = DECODE(x_orig_system_reference,
516: NULL, orig_system_reference,

Line 517: fnd_api.g_miss_char, orig_system_reference,

513: x_attribute20),
514: orig_system_reference
515: = DECODE(x_orig_system_reference,
516: NULL, orig_system_reference,
517: fnd_api.g_miss_char, orig_system_reference,
518: x_orig_system_reference),
519: country = DECODE(x_country,
520: NULL, country,
521: fnd_api.g_miss_char, NULL,

Line 521: fnd_api.g_miss_char, NULL,

517: fnd_api.g_miss_char, orig_system_reference,
518: x_orig_system_reference),
519: country = DECODE(x_country,
520: NULL, country,
521: fnd_api.g_miss_char, NULL,
522: x_country),
523: address1 = DECODE(x_address1,
524: NULL, address1,
525: fnd_api.g_miss_char, NULL,

Line 525: fnd_api.g_miss_char, NULL,

521: fnd_api.g_miss_char, NULL,
522: x_country),
523: address1 = DECODE(x_address1,
524: NULL, address1,
525: fnd_api.g_miss_char, NULL,
526: x_address1),
527: address2 = DECODE(x_address2,
528: NULL, address2,
529: fnd_api.g_miss_char, NULL,

Line 529: fnd_api.g_miss_char, NULL,

525: fnd_api.g_miss_char, NULL,
526: x_address1),
527: address2 = DECODE(x_address2,
528: NULL, address2,
529: fnd_api.g_miss_char, NULL,
530: x_address2),
531: address3 = DECODE(x_address3,
532: NULL, address3,
533: fnd_api.g_miss_char, NULL,

Line 533: fnd_api.g_miss_char, NULL,

529: fnd_api.g_miss_char, NULL,
530: x_address2),
531: address3 = DECODE(x_address3,
532: NULL, address3,
533: fnd_api.g_miss_char, NULL,
534: x_address3),
535: address4 = DECODE(x_address4,
536: NULL, address4,
537: fnd_api.g_miss_char, NULL,

Line 537: fnd_api.g_miss_char, NULL,

533: fnd_api.g_miss_char, NULL,
534: x_address3),
535: address4 = DECODE(x_address4,
536: NULL, address4,
537: fnd_api.g_miss_char, NULL,
538: x_address4),
539: city = DECODE(x_city,
540: NULL, city,
541: fnd_api.g_miss_char, NULL,

Line 541: fnd_api.g_miss_char, NULL,

537: fnd_api.g_miss_char, NULL,
538: x_address4),
539: city = DECODE(x_city,
540: NULL, city,
541: fnd_api.g_miss_char, NULL,
542: x_city),
543: postal_code = DECODE(x_postal_code,
544: NULL, postal_code,
545: fnd_api.g_miss_char, NULL,

Line 545: fnd_api.g_miss_char, NULL,

541: fnd_api.g_miss_char, NULL,
542: x_city),
543: postal_code = DECODE(x_postal_code,
544: NULL, postal_code,
545: fnd_api.g_miss_char, NULL,
546: x_postal_code),
547: state = DECODE(x_state,
548: NULL, state,
549: fnd_api.g_miss_char, NULL,

Line 549: fnd_api.g_miss_char, NULL,

545: fnd_api.g_miss_char, NULL,
546: x_postal_code),
547: state = DECODE(x_state,
548: NULL, state,
549: fnd_api.g_miss_char, NULL,
550: x_state),
551: province = DECODE(x_province,
552: NULL, province,
553: fnd_api.g_miss_char, NULL,

Line 553: fnd_api.g_miss_char, NULL,

549: fnd_api.g_miss_char, NULL,
550: x_state),
551: province = DECODE(x_province,
552: NULL, province,
553: fnd_api.g_miss_char, NULL,
554: x_province),
555: county = DECODE(x_county,
556: NULL, county,
557: fnd_api.g_miss_char, NULL,

Line 557: fnd_api.g_miss_char, NULL,

553: fnd_api.g_miss_char, NULL,
554: x_province),
555: county = DECODE(x_county,
556: NULL, county,
557: fnd_api.g_miss_char, NULL,
558: x_county),
559: address_key = DECODE(x_address_key,
560: NULL, address_key,
561: fnd_api.g_miss_char, NULL,

Line 561: fnd_api.g_miss_char, NULL,

557: fnd_api.g_miss_char, NULL,
558: x_county),
559: address_key = DECODE(x_address_key,
560: NULL, address_key,
561: fnd_api.g_miss_char, NULL,
562: x_address_key),
563: address_style = DECODE(x_address_style,
564: NULL, address_style,
565: fnd_api.g_miss_char, NULL,

Line 565: fnd_api.g_miss_char, NULL,

561: fnd_api.g_miss_char, NULL,
562: x_address_key),
563: address_style = DECODE(x_address_style,
564: NULL, address_style,
565: fnd_api.g_miss_char, NULL,
566: x_address_style),
567: validated_flag = DECODE(x_validated_flag,
568: NULL, validated_flag,
569: fnd_api.g_miss_char, 'N',

Line 569: fnd_api.g_miss_char, 'N',

565: fnd_api.g_miss_char, NULL,
566: x_address_style),
567: validated_flag = DECODE(x_validated_flag,
568: NULL, validated_flag,
569: fnd_api.g_miss_char, 'N',
570: x_validated_flag),
571: address_lines_phonetic = DECODE(x_address_lines_phonetic,
572: NULL, address_lines_phonetic,
573: fnd_api.g_miss_char, NULL,

Line 573: fnd_api.g_miss_char, NULL,

569: fnd_api.g_miss_char, 'N',
570: x_validated_flag),
571: address_lines_phonetic = DECODE(x_address_lines_phonetic,
572: NULL, address_lines_phonetic,
573: fnd_api.g_miss_char, NULL,
574: x_address_lines_phonetic),
575: postal_plus4_code = DECODE(x_postal_plus4_code,
576: NULL, postal_plus4_code,
577: fnd_api.g_miss_char, NULL,

Line 577: fnd_api.g_miss_char, NULL,

573: fnd_api.g_miss_char, NULL,
574: x_address_lines_phonetic),
575: postal_plus4_code = DECODE(x_postal_plus4_code,
576: NULL, postal_plus4_code,
577: fnd_api.g_miss_char, NULL,
578: x_postal_plus4_code),
579: position = DECODE(x_position,
580: NULL, position,
581: fnd_api.g_miss_char, NULL,

Line 581: fnd_api.g_miss_char, NULL,

577: fnd_api.g_miss_char, NULL,
578: x_postal_plus4_code),
579: position = DECODE(x_position,
580: NULL, position,
581: fnd_api.g_miss_char, NULL,
582: x_position),
583: location_directions = DECODE(x_location_directions,
584: NULL, location_directions,
585: fnd_api.g_miss_char, NULL,

Line 585: fnd_api.g_miss_char, NULL,

581: fnd_api.g_miss_char, NULL,
582: x_position),
583: location_directions = DECODE(x_location_directions,
584: NULL, location_directions,
585: fnd_api.g_miss_char, NULL,
586: x_location_directions),
587: address_effective_date = DECODE(x_address_effective_date,
588: NULL, address_effective_date,
589: fnd_api.g_miss_date, NULL,

Line 589: fnd_api.g_miss_date, NULL,

585: fnd_api.g_miss_char, NULL,
586: x_location_directions),
587: address_effective_date = DECODE(x_address_effective_date,
588: NULL, address_effective_date,
589: fnd_api.g_miss_date, NULL,
590: x_address_effective_date),
591: address_expiration_date = DECODE(x_address_expiration_date,
592: NULL, address_expiration_date,
593: fnd_api.g_miss_date, NULL,

Line 593: fnd_api.g_miss_date, NULL,

589: fnd_api.g_miss_date, NULL,
590: x_address_effective_date),
591: address_expiration_date = DECODE(x_address_expiration_date,
592: NULL, address_expiration_date,
593: fnd_api.g_miss_date, NULL,
594: x_address_expiration_date),
595: clli_code = DECODE(x_clli_code,
596: NULL, clli_code,
597: fnd_api.g_miss_char, NULL,

Line 597: fnd_api.g_miss_char, NULL,

593: fnd_api.g_miss_date, NULL,
594: x_address_expiration_date),
595: clli_code = DECODE(x_clli_code,
596: NULL, clli_code,
597: fnd_api.g_miss_char, NULL,
598: x_clli_code),
599: language = DECODE(x_language,
600: NULL, language,
601: fnd_api.g_miss_char, NULL,

Line 601: fnd_api.g_miss_char, NULL,

597: fnd_api.g_miss_char, NULL,
598: x_clli_code),
599: language = DECODE(x_language,
600: NULL, language,
601: fnd_api.g_miss_char, NULL,
602: x_language),
603: short_description = DECODE(x_short_description,
604: NULL, short_description,
605: fnd_api.g_miss_char, NULL,

Line 605: fnd_api.g_miss_char, NULL,

601: fnd_api.g_miss_char, NULL,
602: x_language),
603: short_description = DECODE(x_short_description,
604: NULL, short_description,
605: fnd_api.g_miss_char, NULL,
606: x_short_description),
607: description = DECODE(x_description,
608: NULL, description,
609: fnd_api.g_miss_char, NULL,

Line 609: fnd_api.g_miss_char, NULL,

605: fnd_api.g_miss_char, NULL,
606: x_short_description),
607: description = DECODE(x_description,
608: NULL, description,
609: fnd_api.g_miss_char, NULL,
610: x_description),
611: content_source_type = DECODE(x_content_source_type,
612: NULL, content_source_type,
613: fnd_api.g_miss_char, NULL,

Line 613: fnd_api.g_miss_char, NULL,

609: fnd_api.g_miss_char, NULL,
610: x_description),
611: content_source_type = DECODE(x_content_source_type,
612: NULL, content_source_type,
613: fnd_api.g_miss_char, NULL,
614: x_content_source_type),
615: loc_hierarchy_id = DECODE(x_loc_hierarchy_id,
616: NULL, loc_hierarchy_id,
617: fnd_api.g_miss_num, NULL,

Line 617: fnd_api.g_miss_num, NULL,

613: fnd_api.g_miss_char, NULL,
614: x_content_source_type),
615: loc_hierarchy_id = DECODE(x_loc_hierarchy_id,
616: NULL, loc_hierarchy_id,
617: fnd_api.g_miss_num, NULL,
618: x_loc_hierarchy_id),
619: sales_tax_geocode = DECODE(x_sales_tax_geocode,
620: NULL, sales_tax_geocode,
621: fnd_api.g_miss_char, NULL,

Line 621: fnd_api.g_miss_char, NULL,

617: fnd_api.g_miss_num, NULL,
618: x_loc_hierarchy_id),
619: sales_tax_geocode = DECODE(x_sales_tax_geocode,
620: NULL, sales_tax_geocode,
621: fnd_api.g_miss_char, NULL,
622: x_sales_tax_geocode),
623: sales_tax_inside_city_limits
624: = DECODE(x_sales_tax_inside_city_limits,
625: NULL, sales_tax_inside_city_limits,

Line 626: fnd_api.g_miss_char, '1',

622: x_sales_tax_geocode),
623: sales_tax_inside_city_limits
624: = DECODE(x_sales_tax_inside_city_limits,
625: NULL, sales_tax_inside_city_limits,
626: fnd_api.g_miss_char, '1',
627: x_sales_tax_inside_city_limits),
628: fa_location_id = DECODE(x_fa_location_id,
629: NULL, fa_location_id,
630: fnd_api.g_miss_num, NULL,

Line 630: fnd_api.g_miss_num, NULL,

626: fnd_api.g_miss_char, '1',
627: x_sales_tax_inside_city_limits),
628: fa_location_id = DECODE(x_fa_location_id,
629: NULL, fa_location_id,
630: fnd_api.g_miss_num, NULL,
631: x_fa_location_id),
632: geometry = x_geometry,
633: object_version_number = DECODE(x_object_version_number,
634: NULL, object_version_number,

Line 635: fnd_api.g_miss_num, NULL,

631: x_fa_location_id),
632: geometry = x_geometry,
633: object_version_number = DECODE(x_object_version_number,
634: NULL, object_version_number,
635: fnd_api.g_miss_num, NULL,
636: x_object_version_number),
637: timezone_id = DECODE(x_timezone_id,
638: NULL, timezone_id,
639: fnd_api.g_miss_num, NULL,

Line 639: fnd_api.g_miss_num, NULL,

635: fnd_api.g_miss_num, NULL,
636: x_object_version_number),
637: timezone_id = DECODE(x_timezone_id,
638: NULL, timezone_id,
639: fnd_api.g_miss_num, NULL,
640: x_timezone_id),
641: created_by_module = DECODE(x_created_by_module,
642: NULL, created_by_module,
643: fnd_api.g_miss_char, NULL,

Line 643: fnd_api.g_miss_char, NULL,

639: fnd_api.g_miss_num, NULL,
640: x_timezone_id),
641: created_by_module = DECODE(x_created_by_module,
642: NULL, created_by_module,
643: fnd_api.g_miss_char, NULL,
644: x_created_by_module),
645: application_id = DECODE(x_application_id,
646: NULL, application_id,
647: fnd_api.g_miss_num, NULL,

Line 647: fnd_api.g_miss_num, NULL,

643: fnd_api.g_miss_char, NULL,
644: x_created_by_module),
645: application_id = DECODE(x_application_id,
646: NULL, application_id,
647: fnd_api.g_miss_num, NULL,
648: x_application_id),
649: actual_content_source = DECODE(x_actual_content_source,
650: NULL, actual_content_source,
651: fnd_api.g_miss_char, NULL,

Line 651: fnd_api.g_miss_char, NULL,

647: fnd_api.g_miss_num, NULL,
648: x_application_id),
649: actual_content_source = DECODE(x_actual_content_source,
650: NULL, actual_content_source,
651: fnd_api.g_miss_char, NULL,
652: x_actual_content_source),
653: geometry_status_code = DECODE(x_geometry_status_code,
654: NULL, geometry_status_code,
655: fnd_api.g_miss_char, NULL,

Line 655: fnd_api.g_miss_char, NULL,

651: fnd_api.g_miss_char, NULL,
652: x_actual_content_source),
653: geometry_status_code = DECODE(x_geometry_status_code,
654: NULL, geometry_status_code,
655: fnd_api.g_miss_char, NULL,
656: x_geometry_status_code),
657: -- Bug 2670546.
658: delivery_point_code = DECODE(x_delivery_point_code,
659: NULL,delivery_point_code,

Line 660: fnd_api.g_miss_char,NULL,

656: x_geometry_status_code),
657: -- Bug 2670546.
658: delivery_point_code = DECODE(x_delivery_point_code,
659: NULL,delivery_point_code,
660: fnd_api.g_miss_char,NULL,
661: x_delivery_point_code)
662: WHERE ROWID = x_rowid;
663:
664: IF (SQL%NOTFOUND) THEN

Line 1048: SELECT NVL(location_id, fnd_api.g_miss_num),

1044: -- Bug 2670546
1045: x_delivery_point_code OUT NOCOPY VARCHAR2
1046: ) IS
1047: BEGIN
1048: SELECT NVL(location_id, fnd_api.g_miss_num),
1049: NVL(attribute_category, fnd_api.g_miss_char),
1050: NVL(attribute1, fnd_api.g_miss_char),
1051: NVL(attribute2, fnd_api.g_miss_char),
1052: NVL(attribute3, fnd_api.g_miss_char),

Line 1049: NVL(attribute_category, fnd_api.g_miss_char),

1045: x_delivery_point_code OUT NOCOPY VARCHAR2
1046: ) IS
1047: BEGIN
1048: SELECT NVL(location_id, fnd_api.g_miss_num),
1049: NVL(attribute_category, fnd_api.g_miss_char),
1050: NVL(attribute1, fnd_api.g_miss_char),
1051: NVL(attribute2, fnd_api.g_miss_char),
1052: NVL(attribute3, fnd_api.g_miss_char),
1053: NVL(attribute4, fnd_api.g_miss_char),

Line 1050: NVL(attribute1, fnd_api.g_miss_char),

1046: ) IS
1047: BEGIN
1048: SELECT NVL(location_id, fnd_api.g_miss_num),
1049: NVL(attribute_category, fnd_api.g_miss_char),
1050: NVL(attribute1, fnd_api.g_miss_char),
1051: NVL(attribute2, fnd_api.g_miss_char),
1052: NVL(attribute3, fnd_api.g_miss_char),
1053: NVL(attribute4, fnd_api.g_miss_char),
1054: NVL(attribute5, fnd_api.g_miss_char),

Line 1051: NVL(attribute2, fnd_api.g_miss_char),

1047: BEGIN
1048: SELECT NVL(location_id, fnd_api.g_miss_num),
1049: NVL(attribute_category, fnd_api.g_miss_char),
1050: NVL(attribute1, fnd_api.g_miss_char),
1051: NVL(attribute2, fnd_api.g_miss_char),
1052: NVL(attribute3, fnd_api.g_miss_char),
1053: NVL(attribute4, fnd_api.g_miss_char),
1054: NVL(attribute5, fnd_api.g_miss_char),
1055: NVL(attribute6, fnd_api.g_miss_char),

Line 1052: NVL(attribute3, fnd_api.g_miss_char),

1048: SELECT NVL(location_id, fnd_api.g_miss_num),
1049: NVL(attribute_category, fnd_api.g_miss_char),
1050: NVL(attribute1, fnd_api.g_miss_char),
1051: NVL(attribute2, fnd_api.g_miss_char),
1052: NVL(attribute3, fnd_api.g_miss_char),
1053: NVL(attribute4, fnd_api.g_miss_char),
1054: NVL(attribute5, fnd_api.g_miss_char),
1055: NVL(attribute6, fnd_api.g_miss_char),
1056: NVL(attribute7, fnd_api.g_miss_char),

Line 1053: NVL(attribute4, fnd_api.g_miss_char),

1049: NVL(attribute_category, fnd_api.g_miss_char),
1050: NVL(attribute1, fnd_api.g_miss_char),
1051: NVL(attribute2, fnd_api.g_miss_char),
1052: NVL(attribute3, fnd_api.g_miss_char),
1053: NVL(attribute4, fnd_api.g_miss_char),
1054: NVL(attribute5, fnd_api.g_miss_char),
1055: NVL(attribute6, fnd_api.g_miss_char),
1056: NVL(attribute7, fnd_api.g_miss_char),
1057: NVL(attribute8, fnd_api.g_miss_char),

Line 1054: NVL(attribute5, fnd_api.g_miss_char),

1050: NVL(attribute1, fnd_api.g_miss_char),
1051: NVL(attribute2, fnd_api.g_miss_char),
1052: NVL(attribute3, fnd_api.g_miss_char),
1053: NVL(attribute4, fnd_api.g_miss_char),
1054: NVL(attribute5, fnd_api.g_miss_char),
1055: NVL(attribute6, fnd_api.g_miss_char),
1056: NVL(attribute7, fnd_api.g_miss_char),
1057: NVL(attribute8, fnd_api.g_miss_char),
1058: NVL(attribute9, fnd_api.g_miss_char),

Line 1055: NVL(attribute6, fnd_api.g_miss_char),

1051: NVL(attribute2, fnd_api.g_miss_char),
1052: NVL(attribute3, fnd_api.g_miss_char),
1053: NVL(attribute4, fnd_api.g_miss_char),
1054: NVL(attribute5, fnd_api.g_miss_char),
1055: NVL(attribute6, fnd_api.g_miss_char),
1056: NVL(attribute7, fnd_api.g_miss_char),
1057: NVL(attribute8, fnd_api.g_miss_char),
1058: NVL(attribute9, fnd_api.g_miss_char),
1059: NVL(attribute10, fnd_api.g_miss_char),

Line 1056: NVL(attribute7, fnd_api.g_miss_char),

1052: NVL(attribute3, fnd_api.g_miss_char),
1053: NVL(attribute4, fnd_api.g_miss_char),
1054: NVL(attribute5, fnd_api.g_miss_char),
1055: NVL(attribute6, fnd_api.g_miss_char),
1056: NVL(attribute7, fnd_api.g_miss_char),
1057: NVL(attribute8, fnd_api.g_miss_char),
1058: NVL(attribute9, fnd_api.g_miss_char),
1059: NVL(attribute10, fnd_api.g_miss_char),
1060: NVL(attribute11, fnd_api.g_miss_char),

Line 1057: NVL(attribute8, fnd_api.g_miss_char),

1053: NVL(attribute4, fnd_api.g_miss_char),
1054: NVL(attribute5, fnd_api.g_miss_char),
1055: NVL(attribute6, fnd_api.g_miss_char),
1056: NVL(attribute7, fnd_api.g_miss_char),
1057: NVL(attribute8, fnd_api.g_miss_char),
1058: NVL(attribute9, fnd_api.g_miss_char),
1059: NVL(attribute10, fnd_api.g_miss_char),
1060: NVL(attribute11, fnd_api.g_miss_char),
1061: NVL(attribute12, fnd_api.g_miss_char),

Line 1058: NVL(attribute9, fnd_api.g_miss_char),

1054: NVL(attribute5, fnd_api.g_miss_char),
1055: NVL(attribute6, fnd_api.g_miss_char),
1056: NVL(attribute7, fnd_api.g_miss_char),
1057: NVL(attribute8, fnd_api.g_miss_char),
1058: NVL(attribute9, fnd_api.g_miss_char),
1059: NVL(attribute10, fnd_api.g_miss_char),
1060: NVL(attribute11, fnd_api.g_miss_char),
1061: NVL(attribute12, fnd_api.g_miss_char),
1062: NVL(attribute13, fnd_api.g_miss_char),

Line 1059: NVL(attribute10, fnd_api.g_miss_char),

1055: NVL(attribute6, fnd_api.g_miss_char),
1056: NVL(attribute7, fnd_api.g_miss_char),
1057: NVL(attribute8, fnd_api.g_miss_char),
1058: NVL(attribute9, fnd_api.g_miss_char),
1059: NVL(attribute10, fnd_api.g_miss_char),
1060: NVL(attribute11, fnd_api.g_miss_char),
1061: NVL(attribute12, fnd_api.g_miss_char),
1062: NVL(attribute13, fnd_api.g_miss_char),
1063: NVL(attribute14, fnd_api.g_miss_char),

Line 1060: NVL(attribute11, fnd_api.g_miss_char),

1056: NVL(attribute7, fnd_api.g_miss_char),
1057: NVL(attribute8, fnd_api.g_miss_char),
1058: NVL(attribute9, fnd_api.g_miss_char),
1059: NVL(attribute10, fnd_api.g_miss_char),
1060: NVL(attribute11, fnd_api.g_miss_char),
1061: NVL(attribute12, fnd_api.g_miss_char),
1062: NVL(attribute13, fnd_api.g_miss_char),
1063: NVL(attribute14, fnd_api.g_miss_char),
1064: NVL(attribute15, fnd_api.g_miss_char),

Line 1061: NVL(attribute12, fnd_api.g_miss_char),

1057: NVL(attribute8, fnd_api.g_miss_char),
1058: NVL(attribute9, fnd_api.g_miss_char),
1059: NVL(attribute10, fnd_api.g_miss_char),
1060: NVL(attribute11, fnd_api.g_miss_char),
1061: NVL(attribute12, fnd_api.g_miss_char),
1062: NVL(attribute13, fnd_api.g_miss_char),
1063: NVL(attribute14, fnd_api.g_miss_char),
1064: NVL(attribute15, fnd_api.g_miss_char),
1065: NVL(attribute16, fnd_api.g_miss_char),

Line 1062: NVL(attribute13, fnd_api.g_miss_char),

1058: NVL(attribute9, fnd_api.g_miss_char),
1059: NVL(attribute10, fnd_api.g_miss_char),
1060: NVL(attribute11, fnd_api.g_miss_char),
1061: NVL(attribute12, fnd_api.g_miss_char),
1062: NVL(attribute13, fnd_api.g_miss_char),
1063: NVL(attribute14, fnd_api.g_miss_char),
1064: NVL(attribute15, fnd_api.g_miss_char),
1065: NVL(attribute16, fnd_api.g_miss_char),
1066: NVL(attribute17, fnd_api.g_miss_char),

Line 1063: NVL(attribute14, fnd_api.g_miss_char),

1059: NVL(attribute10, fnd_api.g_miss_char),
1060: NVL(attribute11, fnd_api.g_miss_char),
1061: NVL(attribute12, fnd_api.g_miss_char),
1062: NVL(attribute13, fnd_api.g_miss_char),
1063: NVL(attribute14, fnd_api.g_miss_char),
1064: NVL(attribute15, fnd_api.g_miss_char),
1065: NVL(attribute16, fnd_api.g_miss_char),
1066: NVL(attribute17, fnd_api.g_miss_char),
1067: NVL(attribute18, fnd_api.g_miss_char),

Line 1064: NVL(attribute15, fnd_api.g_miss_char),

1060: NVL(attribute11, fnd_api.g_miss_char),
1061: NVL(attribute12, fnd_api.g_miss_char),
1062: NVL(attribute13, fnd_api.g_miss_char),
1063: NVL(attribute14, fnd_api.g_miss_char),
1064: NVL(attribute15, fnd_api.g_miss_char),
1065: NVL(attribute16, fnd_api.g_miss_char),
1066: NVL(attribute17, fnd_api.g_miss_char),
1067: NVL(attribute18, fnd_api.g_miss_char),
1068: NVL(attribute19, fnd_api.g_miss_char),

Line 1065: NVL(attribute16, fnd_api.g_miss_char),

1061: NVL(attribute12, fnd_api.g_miss_char),
1062: NVL(attribute13, fnd_api.g_miss_char),
1063: NVL(attribute14, fnd_api.g_miss_char),
1064: NVL(attribute15, fnd_api.g_miss_char),
1065: NVL(attribute16, fnd_api.g_miss_char),
1066: NVL(attribute17, fnd_api.g_miss_char),
1067: NVL(attribute18, fnd_api.g_miss_char),
1068: NVL(attribute19, fnd_api.g_miss_char),
1069: NVL(attribute20, fnd_api.g_miss_char),

Line 1066: NVL(attribute17, fnd_api.g_miss_char),

1062: NVL(attribute13, fnd_api.g_miss_char),
1063: NVL(attribute14, fnd_api.g_miss_char),
1064: NVL(attribute15, fnd_api.g_miss_char),
1065: NVL(attribute16, fnd_api.g_miss_char),
1066: NVL(attribute17, fnd_api.g_miss_char),
1067: NVL(attribute18, fnd_api.g_miss_char),
1068: NVL(attribute19, fnd_api.g_miss_char),
1069: NVL(attribute20, fnd_api.g_miss_char),
1070: NVL(orig_system_reference, fnd_api.g_miss_char),

Line 1067: NVL(attribute18, fnd_api.g_miss_char),

1063: NVL(attribute14, fnd_api.g_miss_char),
1064: NVL(attribute15, fnd_api.g_miss_char),
1065: NVL(attribute16, fnd_api.g_miss_char),
1066: NVL(attribute17, fnd_api.g_miss_char),
1067: NVL(attribute18, fnd_api.g_miss_char),
1068: NVL(attribute19, fnd_api.g_miss_char),
1069: NVL(attribute20, fnd_api.g_miss_char),
1070: NVL(orig_system_reference, fnd_api.g_miss_char),
1071: NVL(country, fnd_api.g_miss_char),

Line 1068: NVL(attribute19, fnd_api.g_miss_char),

1064: NVL(attribute15, fnd_api.g_miss_char),
1065: NVL(attribute16, fnd_api.g_miss_char),
1066: NVL(attribute17, fnd_api.g_miss_char),
1067: NVL(attribute18, fnd_api.g_miss_char),
1068: NVL(attribute19, fnd_api.g_miss_char),
1069: NVL(attribute20, fnd_api.g_miss_char),
1070: NVL(orig_system_reference, fnd_api.g_miss_char),
1071: NVL(country, fnd_api.g_miss_char),
1072: NVL(address1, fnd_api.g_miss_char),

Line 1069: NVL(attribute20, fnd_api.g_miss_char),

1065: NVL(attribute16, fnd_api.g_miss_char),
1066: NVL(attribute17, fnd_api.g_miss_char),
1067: NVL(attribute18, fnd_api.g_miss_char),
1068: NVL(attribute19, fnd_api.g_miss_char),
1069: NVL(attribute20, fnd_api.g_miss_char),
1070: NVL(orig_system_reference, fnd_api.g_miss_char),
1071: NVL(country, fnd_api.g_miss_char),
1072: NVL(address1, fnd_api.g_miss_char),
1073: NVL(address2, fnd_api.g_miss_char),

Line 1070: NVL(orig_system_reference, fnd_api.g_miss_char),

1066: NVL(attribute17, fnd_api.g_miss_char),
1067: NVL(attribute18, fnd_api.g_miss_char),
1068: NVL(attribute19, fnd_api.g_miss_char),
1069: NVL(attribute20, fnd_api.g_miss_char),
1070: NVL(orig_system_reference, fnd_api.g_miss_char),
1071: NVL(country, fnd_api.g_miss_char),
1072: NVL(address1, fnd_api.g_miss_char),
1073: NVL(address2, fnd_api.g_miss_char),
1074: NVL(address3, fnd_api.g_miss_char),

Line 1071: NVL(country, fnd_api.g_miss_char),

1067: NVL(attribute18, fnd_api.g_miss_char),
1068: NVL(attribute19, fnd_api.g_miss_char),
1069: NVL(attribute20, fnd_api.g_miss_char),
1070: NVL(orig_system_reference, fnd_api.g_miss_char),
1071: NVL(country, fnd_api.g_miss_char),
1072: NVL(address1, fnd_api.g_miss_char),
1073: NVL(address2, fnd_api.g_miss_char),
1074: NVL(address3, fnd_api.g_miss_char),
1075: NVL(address4, fnd_api.g_miss_char),

Line 1072: NVL(address1, fnd_api.g_miss_char),

1068: NVL(attribute19, fnd_api.g_miss_char),
1069: NVL(attribute20, fnd_api.g_miss_char),
1070: NVL(orig_system_reference, fnd_api.g_miss_char),
1071: NVL(country, fnd_api.g_miss_char),
1072: NVL(address1, fnd_api.g_miss_char),
1073: NVL(address2, fnd_api.g_miss_char),
1074: NVL(address3, fnd_api.g_miss_char),
1075: NVL(address4, fnd_api.g_miss_char),
1076: NVL(city, fnd_api.g_miss_char),

Line 1073: NVL(address2, fnd_api.g_miss_char),

1069: NVL(attribute20, fnd_api.g_miss_char),
1070: NVL(orig_system_reference, fnd_api.g_miss_char),
1071: NVL(country, fnd_api.g_miss_char),
1072: NVL(address1, fnd_api.g_miss_char),
1073: NVL(address2, fnd_api.g_miss_char),
1074: NVL(address3, fnd_api.g_miss_char),
1075: NVL(address4, fnd_api.g_miss_char),
1076: NVL(city, fnd_api.g_miss_char),
1077: NVL(postal_code, fnd_api.g_miss_char),

Line 1074: NVL(address3, fnd_api.g_miss_char),

1070: NVL(orig_system_reference, fnd_api.g_miss_char),
1071: NVL(country, fnd_api.g_miss_char),
1072: NVL(address1, fnd_api.g_miss_char),
1073: NVL(address2, fnd_api.g_miss_char),
1074: NVL(address3, fnd_api.g_miss_char),
1075: NVL(address4, fnd_api.g_miss_char),
1076: NVL(city, fnd_api.g_miss_char),
1077: NVL(postal_code, fnd_api.g_miss_char),
1078: NVL(state, fnd_api.g_miss_char),

Line 1075: NVL(address4, fnd_api.g_miss_char),

1071: NVL(country, fnd_api.g_miss_char),
1072: NVL(address1, fnd_api.g_miss_char),
1073: NVL(address2, fnd_api.g_miss_char),
1074: NVL(address3, fnd_api.g_miss_char),
1075: NVL(address4, fnd_api.g_miss_char),
1076: NVL(city, fnd_api.g_miss_char),
1077: NVL(postal_code, fnd_api.g_miss_char),
1078: NVL(state, fnd_api.g_miss_char),
1079: NVL(province, fnd_api.g_miss_char),

Line 1076: NVL(city, fnd_api.g_miss_char),

1072: NVL(address1, fnd_api.g_miss_char),
1073: NVL(address2, fnd_api.g_miss_char),
1074: NVL(address3, fnd_api.g_miss_char),
1075: NVL(address4, fnd_api.g_miss_char),
1076: NVL(city, fnd_api.g_miss_char),
1077: NVL(postal_code, fnd_api.g_miss_char),
1078: NVL(state, fnd_api.g_miss_char),
1079: NVL(province, fnd_api.g_miss_char),
1080: NVL(county, fnd_api.g_miss_char),

Line 1077: NVL(postal_code, fnd_api.g_miss_char),

1073: NVL(address2, fnd_api.g_miss_char),
1074: NVL(address3, fnd_api.g_miss_char),
1075: NVL(address4, fnd_api.g_miss_char),
1076: NVL(city, fnd_api.g_miss_char),
1077: NVL(postal_code, fnd_api.g_miss_char),
1078: NVL(state, fnd_api.g_miss_char),
1079: NVL(province, fnd_api.g_miss_char),
1080: NVL(county, fnd_api.g_miss_char),
1081: NVL(address_key, fnd_api.g_miss_char),

Line 1078: NVL(state, fnd_api.g_miss_char),

1074: NVL(address3, fnd_api.g_miss_char),
1075: NVL(address4, fnd_api.g_miss_char),
1076: NVL(city, fnd_api.g_miss_char),
1077: NVL(postal_code, fnd_api.g_miss_char),
1078: NVL(state, fnd_api.g_miss_char),
1079: NVL(province, fnd_api.g_miss_char),
1080: NVL(county, fnd_api.g_miss_char),
1081: NVL(address_key, fnd_api.g_miss_char),
1082: NVL(address_style, fnd_api.g_miss_char),

Line 1079: NVL(province, fnd_api.g_miss_char),

1075: NVL(address4, fnd_api.g_miss_char),
1076: NVL(city, fnd_api.g_miss_char),
1077: NVL(postal_code, fnd_api.g_miss_char),
1078: NVL(state, fnd_api.g_miss_char),
1079: NVL(province, fnd_api.g_miss_char),
1080: NVL(county, fnd_api.g_miss_char),
1081: NVL(address_key, fnd_api.g_miss_char),
1082: NVL(address_style, fnd_api.g_miss_char),
1083: NVL(validated_flag, fnd_api.g_miss_char),

Line 1080: NVL(county, fnd_api.g_miss_char),

1076: NVL(city, fnd_api.g_miss_char),
1077: NVL(postal_code, fnd_api.g_miss_char),
1078: NVL(state, fnd_api.g_miss_char),
1079: NVL(province, fnd_api.g_miss_char),
1080: NVL(county, fnd_api.g_miss_char),
1081: NVL(address_key, fnd_api.g_miss_char),
1082: NVL(address_style, fnd_api.g_miss_char),
1083: NVL(validated_flag, fnd_api.g_miss_char),
1084: NVL(address_lines_phonetic, fnd_api.g_miss_char),

Line 1081: NVL(address_key, fnd_api.g_miss_char),

1077: NVL(postal_code, fnd_api.g_miss_char),
1078: NVL(state, fnd_api.g_miss_char),
1079: NVL(province, fnd_api.g_miss_char),
1080: NVL(county, fnd_api.g_miss_char),
1081: NVL(address_key, fnd_api.g_miss_char),
1082: NVL(address_style, fnd_api.g_miss_char),
1083: NVL(validated_flag, fnd_api.g_miss_char),
1084: NVL(address_lines_phonetic, fnd_api.g_miss_char),
1085: NVL(po_box_number, fnd_api.g_miss_char),

Line 1082: NVL(address_style, fnd_api.g_miss_char),

1078: NVL(state, fnd_api.g_miss_char),
1079: NVL(province, fnd_api.g_miss_char),
1080: NVL(county, fnd_api.g_miss_char),
1081: NVL(address_key, fnd_api.g_miss_char),
1082: NVL(address_style, fnd_api.g_miss_char),
1083: NVL(validated_flag, fnd_api.g_miss_char),
1084: NVL(address_lines_phonetic, fnd_api.g_miss_char),
1085: NVL(po_box_number, fnd_api.g_miss_char),
1086: NVL(house_number, fnd_api.g_miss_char),

Line 1083: NVL(validated_flag, fnd_api.g_miss_char),

1079: NVL(province, fnd_api.g_miss_char),
1080: NVL(county, fnd_api.g_miss_char),
1081: NVL(address_key, fnd_api.g_miss_char),
1082: NVL(address_style, fnd_api.g_miss_char),
1083: NVL(validated_flag, fnd_api.g_miss_char),
1084: NVL(address_lines_phonetic, fnd_api.g_miss_char),
1085: NVL(po_box_number, fnd_api.g_miss_char),
1086: NVL(house_number, fnd_api.g_miss_char),
1087: NVL(street_suffix, fnd_api.g_miss_char),

Line 1084: NVL(address_lines_phonetic, fnd_api.g_miss_char),

1080: NVL(county, fnd_api.g_miss_char),
1081: NVL(address_key, fnd_api.g_miss_char),
1082: NVL(address_style, fnd_api.g_miss_char),
1083: NVL(validated_flag, fnd_api.g_miss_char),
1084: NVL(address_lines_phonetic, fnd_api.g_miss_char),
1085: NVL(po_box_number, fnd_api.g_miss_char),
1086: NVL(house_number, fnd_api.g_miss_char),
1087: NVL(street_suffix, fnd_api.g_miss_char),
1088: NVL(street, fnd_api.g_miss_char),

Line 1085: NVL(po_box_number, fnd_api.g_miss_char),

1081: NVL(address_key, fnd_api.g_miss_char),
1082: NVL(address_style, fnd_api.g_miss_char),
1083: NVL(validated_flag, fnd_api.g_miss_char),
1084: NVL(address_lines_phonetic, fnd_api.g_miss_char),
1085: NVL(po_box_number, fnd_api.g_miss_char),
1086: NVL(house_number, fnd_api.g_miss_char),
1087: NVL(street_suffix, fnd_api.g_miss_char),
1088: NVL(street, fnd_api.g_miss_char),
1089: NVL(street_number, fnd_api.g_miss_char),

Line 1086: NVL(house_number, fnd_api.g_miss_char),

1082: NVL(address_style, fnd_api.g_miss_char),
1083: NVL(validated_flag, fnd_api.g_miss_char),
1084: NVL(address_lines_phonetic, fnd_api.g_miss_char),
1085: NVL(po_box_number, fnd_api.g_miss_char),
1086: NVL(house_number, fnd_api.g_miss_char),
1087: NVL(street_suffix, fnd_api.g_miss_char),
1088: NVL(street, fnd_api.g_miss_char),
1089: NVL(street_number, fnd_api.g_miss_char),
1090: NVL(floor, fnd_api.g_miss_char),

Line 1087: NVL(street_suffix, fnd_api.g_miss_char),

1083: NVL(validated_flag, fnd_api.g_miss_char),
1084: NVL(address_lines_phonetic, fnd_api.g_miss_char),
1085: NVL(po_box_number, fnd_api.g_miss_char),
1086: NVL(house_number, fnd_api.g_miss_char),
1087: NVL(street_suffix, fnd_api.g_miss_char),
1088: NVL(street, fnd_api.g_miss_char),
1089: NVL(street_number, fnd_api.g_miss_char),
1090: NVL(floor, fnd_api.g_miss_char),
1091: NVL(suite, fnd_api.g_miss_char),

Line 1088: NVL(street, fnd_api.g_miss_char),

1084: NVL(address_lines_phonetic, fnd_api.g_miss_char),
1085: NVL(po_box_number, fnd_api.g_miss_char),
1086: NVL(house_number, fnd_api.g_miss_char),
1087: NVL(street_suffix, fnd_api.g_miss_char),
1088: NVL(street, fnd_api.g_miss_char),
1089: NVL(street_number, fnd_api.g_miss_char),
1090: NVL(floor, fnd_api.g_miss_char),
1091: NVL(suite, fnd_api.g_miss_char),
1092: NVL(postal_plus4_code, fnd_api.g_miss_char),

Line 1089: NVL(street_number, fnd_api.g_miss_char),

1085: NVL(po_box_number, fnd_api.g_miss_char),
1086: NVL(house_number, fnd_api.g_miss_char),
1087: NVL(street_suffix, fnd_api.g_miss_char),
1088: NVL(street, fnd_api.g_miss_char),
1089: NVL(street_number, fnd_api.g_miss_char),
1090: NVL(floor, fnd_api.g_miss_char),
1091: NVL(suite, fnd_api.g_miss_char),
1092: NVL(postal_plus4_code, fnd_api.g_miss_char),
1093: NVL(position, fnd_api.g_miss_char),

Line 1090: NVL(floor, fnd_api.g_miss_char),

1086: NVL(house_number, fnd_api.g_miss_char),
1087: NVL(street_suffix, fnd_api.g_miss_char),
1088: NVL(street, fnd_api.g_miss_char),
1089: NVL(street_number, fnd_api.g_miss_char),
1090: NVL(floor, fnd_api.g_miss_char),
1091: NVL(suite, fnd_api.g_miss_char),
1092: NVL(postal_plus4_code, fnd_api.g_miss_char),
1093: NVL(position, fnd_api.g_miss_char),
1094: NVL(location_directions, fnd_api.g_miss_char),

Line 1091: NVL(suite, fnd_api.g_miss_char),

1087: NVL(street_suffix, fnd_api.g_miss_char),
1088: NVL(street, fnd_api.g_miss_char),
1089: NVL(street_number, fnd_api.g_miss_char),
1090: NVL(floor, fnd_api.g_miss_char),
1091: NVL(suite, fnd_api.g_miss_char),
1092: NVL(postal_plus4_code, fnd_api.g_miss_char),
1093: NVL(position, fnd_api.g_miss_char),
1094: NVL(location_directions, fnd_api.g_miss_char),
1095: NVL(address_effective_date, fnd_api.g_miss_date),

Line 1092: NVL(postal_plus4_code, fnd_api.g_miss_char),

1088: NVL(street, fnd_api.g_miss_char),
1089: NVL(street_number, fnd_api.g_miss_char),
1090: NVL(floor, fnd_api.g_miss_char),
1091: NVL(suite, fnd_api.g_miss_char),
1092: NVL(postal_plus4_code, fnd_api.g_miss_char),
1093: NVL(position, fnd_api.g_miss_char),
1094: NVL(location_directions, fnd_api.g_miss_char),
1095: NVL(address_effective_date, fnd_api.g_miss_date),
1096: NVL(address_expiration_date, fnd_api.g_miss_date),

Line 1093: NVL(position, fnd_api.g_miss_char),

1089: NVL(street_number, fnd_api.g_miss_char),
1090: NVL(floor, fnd_api.g_miss_char),
1091: NVL(suite, fnd_api.g_miss_char),
1092: NVL(postal_plus4_code, fnd_api.g_miss_char),
1093: NVL(position, fnd_api.g_miss_char),
1094: NVL(location_directions, fnd_api.g_miss_char),
1095: NVL(address_effective_date, fnd_api.g_miss_date),
1096: NVL(address_expiration_date, fnd_api.g_miss_date),
1097: NVL(clli_code, fnd_api.g_miss_char),

Line 1094: NVL(location_directions, fnd_api.g_miss_char),

1090: NVL(floor, fnd_api.g_miss_char),
1091: NVL(suite, fnd_api.g_miss_char),
1092: NVL(postal_plus4_code, fnd_api.g_miss_char),
1093: NVL(position, fnd_api.g_miss_char),
1094: NVL(location_directions, fnd_api.g_miss_char),
1095: NVL(address_effective_date, fnd_api.g_miss_date),
1096: NVL(address_expiration_date, fnd_api.g_miss_date),
1097: NVL(clli_code, fnd_api.g_miss_char),
1098: NVL(language, fnd_api.g_miss_char),

Line 1095: NVL(address_effective_date, fnd_api.g_miss_date),

1091: NVL(suite, fnd_api.g_miss_char),
1092: NVL(postal_plus4_code, fnd_api.g_miss_char),
1093: NVL(position, fnd_api.g_miss_char),
1094: NVL(location_directions, fnd_api.g_miss_char),
1095: NVL(address_effective_date, fnd_api.g_miss_date),
1096: NVL(address_expiration_date, fnd_api.g_miss_date),
1097: NVL(clli_code, fnd_api.g_miss_char),
1098: NVL(language, fnd_api.g_miss_char),
1099: NVL(short_description, fnd_api.g_miss_char),

Line 1096: NVL(address_expiration_date, fnd_api.g_miss_date),

1092: NVL(postal_plus4_code, fnd_api.g_miss_char),
1093: NVL(position, fnd_api.g_miss_char),
1094: NVL(location_directions, fnd_api.g_miss_char),
1095: NVL(address_effective_date, fnd_api.g_miss_date),
1096: NVL(address_expiration_date, fnd_api.g_miss_date),
1097: NVL(clli_code, fnd_api.g_miss_char),
1098: NVL(language, fnd_api.g_miss_char),
1099: NVL(short_description, fnd_api.g_miss_char),
1100: NVL(description, fnd_api.g_miss_char),

Line 1097: NVL(clli_code, fnd_api.g_miss_char),

1093: NVL(position, fnd_api.g_miss_char),
1094: NVL(location_directions, fnd_api.g_miss_char),
1095: NVL(address_effective_date, fnd_api.g_miss_date),
1096: NVL(address_expiration_date, fnd_api.g_miss_date),
1097: NVL(clli_code, fnd_api.g_miss_char),
1098: NVL(language, fnd_api.g_miss_char),
1099: NVL(short_description, fnd_api.g_miss_char),
1100: NVL(description, fnd_api.g_miss_char),
1101: NVL(content_source_type, fnd_api.g_miss_char),

Line 1098: NVL(language, fnd_api.g_miss_char),

1094: NVL(location_directions, fnd_api.g_miss_char),
1095: NVL(address_effective_date, fnd_api.g_miss_date),
1096: NVL(address_expiration_date, fnd_api.g_miss_date),
1097: NVL(clli_code, fnd_api.g_miss_char),
1098: NVL(language, fnd_api.g_miss_char),
1099: NVL(short_description, fnd_api.g_miss_char),
1100: NVL(description, fnd_api.g_miss_char),
1101: NVL(content_source_type, fnd_api.g_miss_char),
1102: NVL(loc_hierarchy_id, fnd_api.g_miss_num),

Line 1099: NVL(short_description, fnd_api.g_miss_char),

1095: NVL(address_effective_date, fnd_api.g_miss_date),
1096: NVL(address_expiration_date, fnd_api.g_miss_date),
1097: NVL(clli_code, fnd_api.g_miss_char),
1098: NVL(language, fnd_api.g_miss_char),
1099: NVL(short_description, fnd_api.g_miss_char),
1100: NVL(description, fnd_api.g_miss_char),
1101: NVL(content_source_type, fnd_api.g_miss_char),
1102: NVL(loc_hierarchy_id, fnd_api.g_miss_num),
1103: sales_tax_geocode,

Line 1100: NVL(description, fnd_api.g_miss_char),

1096: NVL(address_expiration_date, fnd_api.g_miss_date),
1097: NVL(clli_code, fnd_api.g_miss_char),
1098: NVL(language, fnd_api.g_miss_char),
1099: NVL(short_description, fnd_api.g_miss_char),
1100: NVL(description, fnd_api.g_miss_char),
1101: NVL(content_source_type, fnd_api.g_miss_char),
1102: NVL(loc_hierarchy_id, fnd_api.g_miss_num),
1103: sales_tax_geocode,
1104: NVL(sales_tax_inside_city_limits, fnd_api.g_miss_char),

Line 1101: NVL(content_source_type, fnd_api.g_miss_char),

1097: NVL(clli_code, fnd_api.g_miss_char),
1098: NVL(language, fnd_api.g_miss_char),
1099: NVL(short_description, fnd_api.g_miss_char),
1100: NVL(description, fnd_api.g_miss_char),
1101: NVL(content_source_type, fnd_api.g_miss_char),
1102: NVL(loc_hierarchy_id, fnd_api.g_miss_num),
1103: sales_tax_geocode,
1104: NVL(sales_tax_inside_city_limits, fnd_api.g_miss_char),
1105: NVL(fa_location_id, fnd_api.g_miss_num),

Line 1102: NVL(loc_hierarchy_id, fnd_api.g_miss_num),

1098: NVL(language, fnd_api.g_miss_char),
1099: NVL(short_description, fnd_api.g_miss_char),
1100: NVL(description, fnd_api.g_miss_char),
1101: NVL(content_source_type, fnd_api.g_miss_char),
1102: NVL(loc_hierarchy_id, fnd_api.g_miss_num),
1103: sales_tax_geocode,
1104: NVL(sales_tax_inside_city_limits, fnd_api.g_miss_char),
1105: NVL(fa_location_id, fnd_api.g_miss_num),
1106: geometry,

Line 1104: NVL(sales_tax_inside_city_limits, fnd_api.g_miss_char),

1100: NVL(description, fnd_api.g_miss_char),
1101: NVL(content_source_type, fnd_api.g_miss_char),
1102: NVL(loc_hierarchy_id, fnd_api.g_miss_num),
1103: sales_tax_geocode,
1104: NVL(sales_tax_inside_city_limits, fnd_api.g_miss_char),
1105: NVL(fa_location_id, fnd_api.g_miss_num),
1106: geometry,
1107: NVL(timezone_id, fnd_api.g_miss_num),
1108: NVL(created_by_module, fnd_api.g_miss_char),

Line 1105: NVL(fa_location_id, fnd_api.g_miss_num),

1101: NVL(content_source_type, fnd_api.g_miss_char),
1102: NVL(loc_hierarchy_id, fnd_api.g_miss_num),
1103: sales_tax_geocode,
1104: NVL(sales_tax_inside_city_limits, fnd_api.g_miss_char),
1105: NVL(fa_location_id, fnd_api.g_miss_num),
1106: geometry,
1107: NVL(timezone_id, fnd_api.g_miss_num),
1108: NVL(created_by_module, fnd_api.g_miss_char),
1109: NVL(application_id, fnd_api.g_miss_num),

Line 1107: NVL(timezone_id, fnd_api.g_miss_num),

1103: sales_tax_geocode,
1104: NVL(sales_tax_inside_city_limits, fnd_api.g_miss_char),
1105: NVL(fa_location_id, fnd_api.g_miss_num),
1106: geometry,
1107: NVL(timezone_id, fnd_api.g_miss_num),
1108: NVL(created_by_module, fnd_api.g_miss_char),
1109: NVL(application_id, fnd_api.g_miss_num),
1110: NVL(actual_content_source, fnd_api.g_miss_char),
1111: NVL(geometry_status_code, fnd_api.g_miss_char),

Line 1108: NVL(created_by_module, fnd_api.g_miss_char),

1104: NVL(sales_tax_inside_city_limits, fnd_api.g_miss_char),
1105: NVL(fa_location_id, fnd_api.g_miss_num),
1106: geometry,
1107: NVL(timezone_id, fnd_api.g_miss_num),
1108: NVL(created_by_module, fnd_api.g_miss_char),
1109: NVL(application_id, fnd_api.g_miss_num),
1110: NVL(actual_content_source, fnd_api.g_miss_char),
1111: NVL(geometry_status_code, fnd_api.g_miss_char),
1112: -- Bug 2670546

Line 1109: NVL(application_id, fnd_api.g_miss_num),

1105: NVL(fa_location_id, fnd_api.g_miss_num),
1106: geometry,
1107: NVL(timezone_id, fnd_api.g_miss_num),
1108: NVL(created_by_module, fnd_api.g_miss_char),
1109: NVL(application_id, fnd_api.g_miss_num),
1110: NVL(actual_content_source, fnd_api.g_miss_char),
1111: NVL(geometry_status_code, fnd_api.g_miss_char),
1112: -- Bug 2670546
1113: NVL(delivery_point_code,fnd_api.g_miss_char)

Line 1110: NVL(actual_content_source, fnd_api.g_miss_char),

1106: geometry,
1107: NVL(timezone_id, fnd_api.g_miss_num),
1108: NVL(created_by_module, fnd_api.g_miss_char),
1109: NVL(application_id, fnd_api.g_miss_num),
1110: NVL(actual_content_source, fnd_api.g_miss_char),
1111: NVL(geometry_status_code, fnd_api.g_miss_char),
1112: -- Bug 2670546
1113: NVL(delivery_point_code,fnd_api.g_miss_char)
1114: INTO x_location_id,

Line 1111: NVL(geometry_status_code, fnd_api.g_miss_char),

1107: NVL(timezone_id, fnd_api.g_miss_num),
1108: NVL(created_by_module, fnd_api.g_miss_char),
1109: NVL(application_id, fnd_api.g_miss_num),
1110: NVL(actual_content_source, fnd_api.g_miss_char),
1111: NVL(geometry_status_code, fnd_api.g_miss_char),
1112: -- Bug 2670546
1113: NVL(delivery_point_code,fnd_api.g_miss_char)
1114: INTO x_location_id,
1115: x_attribute_category,

Line 1113: NVL(delivery_point_code,fnd_api.g_miss_char)

1109: NVL(application_id, fnd_api.g_miss_num),
1110: NVL(actual_content_source, fnd_api.g_miss_char),
1111: NVL(geometry_status_code, fnd_api.g_miss_char),
1112: -- Bug 2670546
1113: NVL(delivery_point_code,fnd_api.g_miss_char)
1114: INTO x_location_id,
1115: x_attribute_category,
1116: x_attribute1,
1117: x_attribute2,

Line 1188: RAISE fnd_api.g_exc_error;

1184: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1185: fnd_message.set_token('RECORD', 'location_rec');
1186: fnd_message.set_token('VALUE', TO_CHAR(x_location_id));
1187: fnd_msg_pub.add;
1188: RAISE fnd_api.g_exc_error;
1189: END select_row;
1190:
1191: PROCEDURE delete_row (x_location_id IN NUMBER) IS
1192: BEGIN