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_GEOGRAPHIES_PKG dependencies on FND_API

Line 149: FND_API.G_MISS_NUM, HZ_GEOGRAPHIES_S.NEXTVAL,

145: attribute20
146: )
147: VALUES (
148: DECODE(x_geography_id,
149: FND_API.G_MISS_NUM, HZ_GEOGRAPHIES_S.NEXTVAL,
150: NULL, HZ_GEOGRAPHIES_S.NEXTVAL,
151: x_geography_id),
152: DECODE(x_object_version_number,
153: FND_API.G_MISS_NUM, NULL,

Line 153: FND_API.G_MISS_NUM, NULL,

149: FND_API.G_MISS_NUM, HZ_GEOGRAPHIES_S.NEXTVAL,
150: NULL, HZ_GEOGRAPHIES_S.NEXTVAL,
151: x_geography_id),
152: DECODE(x_object_version_number,
153: FND_API.G_MISS_NUM, NULL,
154: x_object_version_number),
155: DECODE(x_geography_type,
156: FND_API.G_MISS_CHAR, NULL,
157: x_geography_type),

Line 156: FND_API.G_MISS_CHAR, NULL,

152: DECODE(x_object_version_number,
153: FND_API.G_MISS_NUM, NULL,
154: x_object_version_number),
155: DECODE(x_geography_type,
156: FND_API.G_MISS_CHAR, NULL,
157: x_geography_type),
158: DECODE(x_geography_name,
159: FND_API.G_MISS_CHAR, NULL,
160: x_geography_name),

Line 159: FND_API.G_MISS_CHAR, NULL,

155: DECODE(x_geography_type,
156: FND_API.G_MISS_CHAR, NULL,
157: x_geography_type),
158: DECODE(x_geography_name,
159: FND_API.G_MISS_CHAR, NULL,
160: x_geography_name),
161: DECODE(x_geography_use,
162: FND_API.G_MISS_CHAR, NULL,
163: x_geography_use),

Line 162: FND_API.G_MISS_CHAR, NULL,

158: DECODE(x_geography_name,
159: FND_API.G_MISS_CHAR, NULL,
160: x_geography_name),
161: DECODE(x_geography_use,
162: FND_API.G_MISS_CHAR, NULL,
163: x_geography_use),
164: DECODE(x_geography_code,
165: FND_API.G_MISS_CHAR, NULL,
166: x_geography_code),

Line 165: FND_API.G_MISS_CHAR, NULL,

161: DECODE(x_geography_use,
162: FND_API.G_MISS_CHAR, NULL,
163: x_geography_use),
164: DECODE(x_geography_code,
165: FND_API.G_MISS_CHAR, NULL,
166: x_geography_code),
167: DECODE(x_start_date,
168: FND_API.G_MISS_DATE, TO_DATE(NULL),
169: x_start_date),

Line 168: FND_API.G_MISS_DATE, TO_DATE(NULL),

164: DECODE(x_geography_code,
165: FND_API.G_MISS_CHAR, NULL,
166: x_geography_code),
167: DECODE(x_start_date,
168: FND_API.G_MISS_DATE, TO_DATE(NULL),
169: x_start_date),
170: DECODE(x_end_date,
171: FND_API.G_MISS_DATE, TO_DATE(NULL),
172: x_end_date),

Line 171: FND_API.G_MISS_DATE, TO_DATE(NULL),

167: DECODE(x_start_date,
168: FND_API.G_MISS_DATE, TO_DATE(NULL),
169: x_start_date),
170: DECODE(x_end_date,
171: FND_API.G_MISS_DATE, TO_DATE(NULL),
172: x_end_date),
173: DECODE(x_multiple_parent_flag,
174: FND_API.G_MISS_CHAR, NULL,
175: x_multiple_parent_flag),

Line 174: FND_API.G_MISS_CHAR, NULL,

170: DECODE(x_end_date,
171: FND_API.G_MISS_DATE, TO_DATE(NULL),
172: x_end_date),
173: DECODE(x_multiple_parent_flag,
174: FND_API.G_MISS_CHAR, NULL,
175: x_multiple_parent_flag),
176: DECODE(x_created_by_module,
177: FND_API.G_MISS_CHAR, NULL,
178: x_created_by_module),

Line 177: FND_API.G_MISS_CHAR, NULL,

173: DECODE(x_multiple_parent_flag,
174: FND_API.G_MISS_CHAR, NULL,
175: x_multiple_parent_flag),
176: DECODE(x_created_by_module,
177: FND_API.G_MISS_CHAR, NULL,
178: x_created_by_module),
179: DECODE(x_country_code,
180: FND_API.G_MISS_CHAR, NULL,
181: x_country_code),

Line 180: FND_API.G_MISS_CHAR, NULL,

176: DECODE(x_created_by_module,
177: FND_API.G_MISS_CHAR, NULL,
178: x_created_by_module),
179: DECODE(x_country_code,
180: FND_API.G_MISS_CHAR, NULL,
181: x_country_code),
182: DECODE(x_geography_element1,
183: FND_API.G_MISS_CHAR, NULL,
184: x_geography_element1),

Line 183: FND_API.G_MISS_CHAR, NULL,

179: DECODE(x_country_code,
180: FND_API.G_MISS_CHAR, NULL,
181: x_country_code),
182: DECODE(x_geography_element1,
183: FND_API.G_MISS_CHAR, NULL,
184: x_geography_element1),
185: DECODE(x_geography_element1_id,
186: FND_API.G_MISS_NUM, NULL,
187: x_geography_element1_id),

Line 186: FND_API.G_MISS_NUM, NULL,

182: DECODE(x_geography_element1,
183: FND_API.G_MISS_CHAR, NULL,
184: x_geography_element1),
185: DECODE(x_geography_element1_id,
186: FND_API.G_MISS_NUM, NULL,
187: x_geography_element1_id),
188: DECODE(x_geography_element1_code,
189: FND_API.G_MISS_CHAR, NULL,
190: x_geography_element1_code),

Line 189: FND_API.G_MISS_CHAR, NULL,

185: DECODE(x_geography_element1_id,
186: FND_API.G_MISS_NUM, NULL,
187: x_geography_element1_id),
188: DECODE(x_geography_element1_code,
189: FND_API.G_MISS_CHAR, NULL,
190: x_geography_element1_code),
191: DECODE(x_geography_element2,
192: FND_API.G_MISS_CHAR, NULL,
193: x_geography_element2),

Line 192: FND_API.G_MISS_CHAR, NULL,

188: DECODE(x_geography_element1_code,
189: FND_API.G_MISS_CHAR, NULL,
190: x_geography_element1_code),
191: DECODE(x_geography_element2,
192: FND_API.G_MISS_CHAR, NULL,
193: x_geography_element2),
194: DECODE(x_geography_element2_id,
195: FND_API.G_MISS_NUM, NULL,
196: x_geography_element2_id),

Line 195: FND_API.G_MISS_NUM, NULL,

191: DECODE(x_geography_element2,
192: FND_API.G_MISS_CHAR, NULL,
193: x_geography_element2),
194: DECODE(x_geography_element2_id,
195: FND_API.G_MISS_NUM, NULL,
196: x_geography_element2_id),
197: DECODE(x_geography_element2_code,
198: FND_API.G_MISS_CHAR, NULL,
199: x_geography_element2_code),

Line 198: FND_API.G_MISS_CHAR, NULL,

194: DECODE(x_geography_element2_id,
195: FND_API.G_MISS_NUM, NULL,
196: x_geography_element2_id),
197: DECODE(x_geography_element2_code,
198: FND_API.G_MISS_CHAR, NULL,
199: x_geography_element2_code),
200: DECODE(x_geography_element3,
201: FND_API.G_MISS_CHAR, NULL,
202: x_geography_element3),

Line 201: FND_API.G_MISS_CHAR, NULL,

197: DECODE(x_geography_element2_code,
198: FND_API.G_MISS_CHAR, NULL,
199: x_geography_element2_code),
200: DECODE(x_geography_element3,
201: FND_API.G_MISS_CHAR, NULL,
202: x_geography_element3),
203: DECODE(x_geography_element3_id,
204: FND_API.G_MISS_NUM, NULL,
205: x_geography_element3_id),

Line 204: FND_API.G_MISS_NUM, NULL,

200: DECODE(x_geography_element3,
201: FND_API.G_MISS_CHAR, NULL,
202: x_geography_element3),
203: DECODE(x_geography_element3_id,
204: FND_API.G_MISS_NUM, NULL,
205: x_geography_element3_id),
206: DECODE(x_geography_element3_code,
207: FND_API.G_MISS_CHAR, NULL,
208: x_geography_element3_code),

Line 207: FND_API.G_MISS_CHAR, NULL,

203: DECODE(x_geography_element3_id,
204: FND_API.G_MISS_NUM, NULL,
205: x_geography_element3_id),
206: DECODE(x_geography_element3_code,
207: FND_API.G_MISS_CHAR, NULL,
208: x_geography_element3_code),
209: DECODE(x_geography_element4,
210: FND_API.G_MISS_CHAR, NULL,
211: x_geography_element4),

Line 210: FND_API.G_MISS_CHAR, NULL,

206: DECODE(x_geography_element3_code,
207: FND_API.G_MISS_CHAR, NULL,
208: x_geography_element3_code),
209: DECODE(x_geography_element4,
210: FND_API.G_MISS_CHAR, NULL,
211: x_geography_element4),
212: DECODE(x_geography_element4_id,
213: FND_API.G_MISS_NUM, NULL,
214: x_geography_element4_id),

Line 213: FND_API.G_MISS_NUM, NULL,

209: DECODE(x_geography_element4,
210: FND_API.G_MISS_CHAR, NULL,
211: x_geography_element4),
212: DECODE(x_geography_element4_id,
213: FND_API.G_MISS_NUM, NULL,
214: x_geography_element4_id),
215: DECODE(x_geography_element4_code,
216: FND_API.G_MISS_CHAR, NULL,
217: x_geography_element4_code),

Line 216: FND_API.G_MISS_CHAR, NULL,

212: DECODE(x_geography_element4_id,
213: FND_API.G_MISS_NUM, NULL,
214: x_geography_element4_id),
215: DECODE(x_geography_element4_code,
216: FND_API.G_MISS_CHAR, NULL,
217: x_geography_element4_code),
218: DECODE(x_geography_element5,
219: FND_API.G_MISS_CHAR, NULL,
220: x_geography_element5),

Line 219: FND_API.G_MISS_CHAR, NULL,

215: DECODE(x_geography_element4_code,
216: FND_API.G_MISS_CHAR, NULL,
217: x_geography_element4_code),
218: DECODE(x_geography_element5,
219: FND_API.G_MISS_CHAR, NULL,
220: x_geography_element5),
221: DECODE(x_geography_element5_id,
222: FND_API.G_MISS_NUM, NULL,
223: x_geography_element5_id),

Line 222: FND_API.G_MISS_NUM, NULL,

218: DECODE(x_geography_element5,
219: FND_API.G_MISS_CHAR, NULL,
220: x_geography_element5),
221: DECODE(x_geography_element5_id,
222: FND_API.G_MISS_NUM, NULL,
223: x_geography_element5_id),
224: DECODE(x_geography_element5_code,
225: FND_API.G_MISS_CHAR, NULL,
226: x_geography_element5_code),

Line 225: FND_API.G_MISS_CHAR, NULL,

221: DECODE(x_geography_element5_id,
222: FND_API.G_MISS_NUM, NULL,
223: x_geography_element5_id),
224: DECODE(x_geography_element5_code,
225: FND_API.G_MISS_CHAR, NULL,
226: x_geography_element5_code),
227: DECODE(x_geography_element6,
228: FND_API.G_MISS_CHAR, NULL,
229: x_geography_element6),

Line 228: FND_API.G_MISS_CHAR, NULL,

224: DECODE(x_geography_element5_code,
225: FND_API.G_MISS_CHAR, NULL,
226: x_geography_element5_code),
227: DECODE(x_geography_element6,
228: FND_API.G_MISS_CHAR, NULL,
229: x_geography_element6),
230: DECODE(x_geography_element6_id,
231: FND_API.G_MISS_NUM, NULL,
232: x_geography_element6_id),

Line 231: FND_API.G_MISS_NUM, NULL,

227: DECODE(x_geography_element6,
228: FND_API.G_MISS_CHAR, NULL,
229: x_geography_element6),
230: DECODE(x_geography_element6_id,
231: FND_API.G_MISS_NUM, NULL,
232: x_geography_element6_id),
233: DECODE(x_geography_element7,
234: FND_API.G_MISS_CHAR, NULL,
235: x_geography_element7),

Line 234: FND_API.G_MISS_CHAR, NULL,

230: DECODE(x_geography_element6_id,
231: FND_API.G_MISS_NUM, NULL,
232: x_geography_element6_id),
233: DECODE(x_geography_element7,
234: FND_API.G_MISS_CHAR, NULL,
235: x_geography_element7),
236: DECODE(x_geography_element7_id,
237: FND_API.G_MISS_NUM, NULL,
238: x_geography_element7_id),

Line 237: FND_API.G_MISS_NUM, NULL,

233: DECODE(x_geography_element7,
234: FND_API.G_MISS_CHAR, NULL,
235: x_geography_element7),
236: DECODE(x_geography_element7_id,
237: FND_API.G_MISS_NUM, NULL,
238: x_geography_element7_id),
239: DECODE(x_geography_element8,
240: FND_API.G_MISS_CHAR, NULL,
241: x_geography_element8),

Line 240: FND_API.G_MISS_CHAR, NULL,

236: DECODE(x_geography_element7_id,
237: FND_API.G_MISS_NUM, NULL,
238: x_geography_element7_id),
239: DECODE(x_geography_element8,
240: FND_API.G_MISS_CHAR, NULL,
241: x_geography_element8),
242: DECODE(x_geography_element8_id,
243: FND_API.G_MISS_NUM, NULL,
244: x_geography_element8_id),

Line 243: FND_API.G_MISS_NUM, NULL,

239: DECODE(x_geography_element8,
240: FND_API.G_MISS_CHAR, NULL,
241: x_geography_element8),
242: DECODE(x_geography_element8_id,
243: FND_API.G_MISS_NUM, NULL,
244: x_geography_element8_id),
245: DECODE(x_geography_element9,
246: FND_API.G_MISS_CHAR, NULL,
247: x_geography_element9),

Line 246: FND_API.G_MISS_CHAR, NULL,

242: DECODE(x_geography_element8_id,
243: FND_API.G_MISS_NUM, NULL,
244: x_geography_element8_id),
245: DECODE(x_geography_element9,
246: FND_API.G_MISS_CHAR, NULL,
247: x_geography_element9),
248: DECODE(x_geography_element9_id,
249: FND_API.G_MISS_NUM, NULL,
250: x_geography_element9_id),

Line 249: FND_API.G_MISS_NUM, NULL,

245: DECODE(x_geography_element9,
246: FND_API.G_MISS_CHAR, NULL,
247: x_geography_element9),
248: DECODE(x_geography_element9_id,
249: FND_API.G_MISS_NUM, NULL,
250: x_geography_element9_id),
251: DECODE(x_geography_element10,
252: FND_API.G_MISS_CHAR, NULL,
253: x_geography_element10),

Line 252: FND_API.G_MISS_CHAR, NULL,

248: DECODE(x_geography_element9_id,
249: FND_API.G_MISS_NUM, NULL,
250: x_geography_element9_id),
251: DECODE(x_geography_element10,
252: FND_API.G_MISS_CHAR, NULL,
253: x_geography_element10),
254: DECODE(x_geography_element10_id,
255: FND_API.G_MISS_NUM, NULL,
256: x_geography_element10_id),

Line 255: FND_API.G_MISS_NUM, NULL,

251: DECODE(x_geography_element10,
252: FND_API.G_MISS_CHAR, NULL,
253: x_geography_element10),
254: DECODE(x_geography_element10_id,
255: FND_API.G_MISS_NUM, NULL,
256: x_geography_element10_id),
257: x_geometry,
258: DECODE(x_timezone_code,
259: FND_API.G_MISS_CHAR, NULL,

Line 259: FND_API.G_MISS_CHAR, NULL,

255: FND_API.G_MISS_NUM, NULL,
256: x_geography_element10_id),
257: x_geometry,
258: DECODE(x_timezone_code,
259: FND_API.G_MISS_CHAR, NULL,
260: x_timezone_code),
261: hz_utility_v2pub.last_updated_by,
262: hz_utility_v2pub.creation_date,
263: hz_utility_v2pub.created_by,

Line 267: FND_API.G_MISS_NUM, NULL,

263: hz_utility_v2pub.created_by,
264: hz_utility_v2pub.last_update_date,
265: hz_utility_v2pub.last_update_login,
266: DECODE(x_application_id,
267: FND_API.G_MISS_NUM, NULL,
268: x_application_id),
269: hz_utility_v2pub.program_id,
270: DECODE(x_program_login_id,
271: FND_API.G_MISS_NUM, NULL,

Line 271: FND_API.G_MISS_NUM, NULL,

267: FND_API.G_MISS_NUM, NULL,
268: x_application_id),
269: hz_utility_v2pub.program_id,
270: DECODE(x_program_login_id,
271: FND_API.G_MISS_NUM, NULL,
272: x_program_login_id),
273: hz_utility_v2pub.program_application_id,
274: hz_utility_v2pub.request_id,
275: DECODE(x_attribute_category,

Line 276: FND_API.G_MISS_CHAR, NULL,

272: x_program_login_id),
273: hz_utility_v2pub.program_application_id,
274: hz_utility_v2pub.request_id,
275: DECODE(x_attribute_category,
276: FND_API.G_MISS_CHAR, NULL,
277: x_attribute_category),
278: DECODE(x_attribute1,
279: FND_API.G_MISS_CHAR, NULL,
280: x_attribute1),

Line 279: FND_API.G_MISS_CHAR, NULL,

275: DECODE(x_attribute_category,
276: FND_API.G_MISS_CHAR, NULL,
277: x_attribute_category),
278: DECODE(x_attribute1,
279: FND_API.G_MISS_CHAR, NULL,
280: x_attribute1),
281: DECODE(x_attribute2,
282: FND_API.G_MISS_CHAR, NULL,
283: x_attribute2),

Line 282: FND_API.G_MISS_CHAR, NULL,

278: DECODE(x_attribute1,
279: FND_API.G_MISS_CHAR, NULL,
280: x_attribute1),
281: DECODE(x_attribute2,
282: FND_API.G_MISS_CHAR, NULL,
283: x_attribute2),
284: DECODE(x_attribute3,
285: FND_API.G_MISS_CHAR, NULL,
286: x_attribute3),

Line 285: FND_API.G_MISS_CHAR, NULL,

281: DECODE(x_attribute2,
282: FND_API.G_MISS_CHAR, NULL,
283: x_attribute2),
284: DECODE(x_attribute3,
285: FND_API.G_MISS_CHAR, NULL,
286: x_attribute3),
287: DECODE(x_attribute4,
288: FND_API.G_MISS_CHAR, NULL,
289: x_attribute4),

Line 288: FND_API.G_MISS_CHAR, NULL,

284: DECODE(x_attribute3,
285: FND_API.G_MISS_CHAR, NULL,
286: x_attribute3),
287: DECODE(x_attribute4,
288: FND_API.G_MISS_CHAR, NULL,
289: x_attribute4),
290: DECODE(x_attribute5,
291: FND_API.G_MISS_CHAR, NULL,
292: x_attribute5),

Line 291: FND_API.G_MISS_CHAR, NULL,

287: DECODE(x_attribute4,
288: FND_API.G_MISS_CHAR, NULL,
289: x_attribute4),
290: DECODE(x_attribute5,
291: FND_API.G_MISS_CHAR, NULL,
292: x_attribute5),
293: DECODE(x_attribute6,
294: FND_API.G_MISS_CHAR, NULL,
295: x_attribute6),

Line 294: FND_API.G_MISS_CHAR, NULL,

290: DECODE(x_attribute5,
291: FND_API.G_MISS_CHAR, NULL,
292: x_attribute5),
293: DECODE(x_attribute6,
294: FND_API.G_MISS_CHAR, NULL,
295: x_attribute6),
296: DECODE(x_attribute7,
297: FND_API.G_MISS_CHAR, NULL,
298: x_attribute7),

Line 297: FND_API.G_MISS_CHAR, NULL,

293: DECODE(x_attribute6,
294: FND_API.G_MISS_CHAR, NULL,
295: x_attribute6),
296: DECODE(x_attribute7,
297: FND_API.G_MISS_CHAR, NULL,
298: x_attribute7),
299: DECODE(x_attribute8,
300: FND_API.G_MISS_CHAR, NULL,
301: x_attribute8),

Line 300: FND_API.G_MISS_CHAR, NULL,

296: DECODE(x_attribute7,
297: FND_API.G_MISS_CHAR, NULL,
298: x_attribute7),
299: DECODE(x_attribute8,
300: FND_API.G_MISS_CHAR, NULL,
301: x_attribute8),
302: DECODE(x_attribute9,
303: FND_API.G_MISS_CHAR, NULL,
304: x_attribute9),

Line 303: FND_API.G_MISS_CHAR, NULL,

299: DECODE(x_attribute8,
300: FND_API.G_MISS_CHAR, NULL,
301: x_attribute8),
302: DECODE(x_attribute9,
303: FND_API.G_MISS_CHAR, NULL,
304: x_attribute9),
305: DECODE(x_attribute10,
306: FND_API.G_MISS_CHAR, NULL,
307: x_attribute10),

Line 306: FND_API.G_MISS_CHAR, NULL,

302: DECODE(x_attribute9,
303: FND_API.G_MISS_CHAR, NULL,
304: x_attribute9),
305: DECODE(x_attribute10,
306: FND_API.G_MISS_CHAR, NULL,
307: x_attribute10),
308: DECODE(x_attribute11,
309: FND_API.G_MISS_CHAR, NULL,
310: x_attribute11),

Line 309: FND_API.G_MISS_CHAR, NULL,

305: DECODE(x_attribute10,
306: FND_API.G_MISS_CHAR, NULL,
307: x_attribute10),
308: DECODE(x_attribute11,
309: FND_API.G_MISS_CHAR, NULL,
310: x_attribute11),
311: DECODE(x_attribute12,
312: FND_API.G_MISS_CHAR, NULL,
313: x_attribute12),

Line 312: FND_API.G_MISS_CHAR, NULL,

308: DECODE(x_attribute11,
309: FND_API.G_MISS_CHAR, NULL,
310: x_attribute11),
311: DECODE(x_attribute12,
312: FND_API.G_MISS_CHAR, NULL,
313: x_attribute12),
314: DECODE(x_attribute13,
315: FND_API.G_MISS_CHAR, NULL,
316: x_attribute13),

Line 315: FND_API.G_MISS_CHAR, NULL,

311: DECODE(x_attribute12,
312: FND_API.G_MISS_CHAR, NULL,
313: x_attribute12),
314: DECODE(x_attribute13,
315: FND_API.G_MISS_CHAR, NULL,
316: x_attribute13),
317: DECODE(x_attribute14,
318: FND_API.G_MISS_CHAR, NULL,
319: x_attribute14),

Line 318: FND_API.G_MISS_CHAR, NULL,

314: DECODE(x_attribute13,
315: FND_API.G_MISS_CHAR, NULL,
316: x_attribute13),
317: DECODE(x_attribute14,
318: FND_API.G_MISS_CHAR, NULL,
319: x_attribute14),
320: DECODE(x_attribute15,
321: FND_API.G_MISS_CHAR, NULL,
322: x_attribute15),

Line 321: FND_API.G_MISS_CHAR, NULL,

317: DECODE(x_attribute14,
318: FND_API.G_MISS_CHAR, NULL,
319: x_attribute14),
320: DECODE(x_attribute15,
321: FND_API.G_MISS_CHAR, NULL,
322: x_attribute15),
323: DECODE(x_attribute16,
324: FND_API.G_MISS_CHAR, NULL,
325: x_attribute16),

Line 324: FND_API.G_MISS_CHAR, NULL,

320: DECODE(x_attribute15,
321: FND_API.G_MISS_CHAR, NULL,
322: x_attribute15),
323: DECODE(x_attribute16,
324: FND_API.G_MISS_CHAR, NULL,
325: x_attribute16),
326: DECODE(x_attribute17,
327: FND_API.G_MISS_CHAR, NULL,
328: x_attribute17),

Line 327: FND_API.G_MISS_CHAR, NULL,

323: DECODE(x_attribute16,
324: FND_API.G_MISS_CHAR, NULL,
325: x_attribute16),
326: DECODE(x_attribute17,
327: FND_API.G_MISS_CHAR, NULL,
328: x_attribute17),
329: DECODE(x_attribute18,
330: FND_API.G_MISS_CHAR, NULL,
331: x_attribute18),

Line 330: FND_API.G_MISS_CHAR, NULL,

326: DECODE(x_attribute17,
327: FND_API.G_MISS_CHAR, NULL,
328: x_attribute17),
329: DECODE(x_attribute18,
330: FND_API.G_MISS_CHAR, NULL,
331: x_attribute18),
332: DECODE(x_attribute19,
333: FND_API.G_MISS_CHAR, NULL,
334: x_attribute19),

Line 333: FND_API.G_MISS_CHAR, NULL,

329: DECODE(x_attribute18,
330: FND_API.G_MISS_CHAR, NULL,
331: x_attribute18),
332: DECODE(x_attribute19,
333: FND_API.G_MISS_CHAR, NULL,
334: x_attribute19),
335: DECODE(x_attribute20,
336: FND_API.G_MISS_CHAR, NULL,
337: x_attribute20)

Line 336: FND_API.G_MISS_CHAR, NULL,

332: DECODE(x_attribute19,
333: FND_API.G_MISS_CHAR, NULL,
334: x_attribute19),
335: DECODE(x_attribute20,
336: FND_API.G_MISS_CHAR, NULL,
337: x_attribute20)
338: ) RETURNING
339: rowid,
340: geography_id

Line 449: FND_API.G_MISS_NUM, NULL,

445: SET
446: geography_id =
447: DECODE(x_geography_id,
448: NULL, geography_id,
449: FND_API.G_MISS_NUM, NULL,
450: x_geography_id),
451: object_version_number =
452: DECODE(x_object_version_number,
453: NULL, object_version_number,

Line 454: FND_API.G_MISS_NUM, NULL,

450: x_geography_id),
451: object_version_number =
452: DECODE(x_object_version_number,
453: NULL, object_version_number,
454: FND_API.G_MISS_NUM, NULL,
455: x_object_version_number),
456: geography_type =
457: DECODE(x_geography_type,
458: NULL, geography_type,

Line 459: FND_API.G_MISS_CHAR, NULL,

455: x_object_version_number),
456: geography_type =
457: DECODE(x_geography_type,
458: NULL, geography_type,
459: FND_API.G_MISS_CHAR, NULL,
460: x_geography_type),
461: geography_name =
462: DECODE(x_geography_name,
463: NULL, geography_name,

Line 464: FND_API.G_MISS_CHAR, NULL,

460: x_geography_type),
461: geography_name =
462: DECODE(x_geography_name,
463: NULL, geography_name,
464: FND_API.G_MISS_CHAR, NULL,
465: x_geography_name),
466: geography_use =
467: DECODE(x_geography_use,
468: NULL, geography_use,

Line 469: FND_API.G_MISS_CHAR, NULL,

465: x_geography_name),
466: geography_use =
467: DECODE(x_geography_use,
468: NULL, geography_use,
469: FND_API.G_MISS_CHAR, NULL,
470: x_geography_use),
471: geography_code =
472: DECODE(x_geography_code,
473: NULL, geography_code,

Line 474: FND_API.G_MISS_CHAR, NULL,

470: x_geography_use),
471: geography_code =
472: DECODE(x_geography_code,
473: NULL, geography_code,
474: FND_API.G_MISS_CHAR, NULL,
475: x_geography_code),
476: start_date =
477: DECODE(x_start_date,
478: NULL, start_date,

Line 479: FND_API.G_MISS_DATE, NULL,

475: x_geography_code),
476: start_date =
477: DECODE(x_start_date,
478: NULL, start_date,
479: FND_API.G_MISS_DATE, NULL,
480: x_start_date),
481: end_date =
482: DECODE(x_end_date,
483: NULL, end_date,

Line 484: FND_API.G_MISS_DATE, NULL,

480: x_start_date),
481: end_date =
482: DECODE(x_end_date,
483: NULL, end_date,
484: FND_API.G_MISS_DATE, NULL,
485: x_end_date),
486: multiple_parent_flag =
487: DECODE(x_multiple_parent_flag,
488: NULL, multiple_parent_flag,

Line 489: FND_API.G_MISS_CHAR, NULL,

485: x_end_date),
486: multiple_parent_flag =
487: DECODE(x_multiple_parent_flag,
488: NULL, multiple_parent_flag,
489: FND_API.G_MISS_CHAR, NULL,
490: x_multiple_parent_flag),
491: created_by_module =
492: DECODE(x_created_by_module,
493: NULL, created_by_module,

Line 494: FND_API.G_MISS_CHAR, NULL,

490: x_multiple_parent_flag),
491: created_by_module =
492: DECODE(x_created_by_module,
493: NULL, created_by_module,
494: FND_API.G_MISS_CHAR, NULL,
495: x_created_by_module),
496: country_code =
497: DECODE(x_country_code,
498: NULL, country_code,

Line 499: FND_API.G_MISS_CHAR, NULL,

495: x_created_by_module),
496: country_code =
497: DECODE(x_country_code,
498: NULL, country_code,
499: FND_API.G_MISS_CHAR, NULL,
500: x_country_code),
501: geography_element1 =
502: DECODE(x_geography_element1,
503: NULL, geography_element1,

Line 504: FND_API.G_MISS_CHAR, NULL,

500: x_country_code),
501: geography_element1 =
502: DECODE(x_geography_element1,
503: NULL, geography_element1,
504: FND_API.G_MISS_CHAR, NULL,
505: x_geography_element1),
506: geography_element1_id =
507: DECODE(x_geography_element1_id,
508: NULL, geography_element1_id,

Line 509: FND_API.G_MISS_NUM, NULL,

505: x_geography_element1),
506: geography_element1_id =
507: DECODE(x_geography_element1_id,
508: NULL, geography_element1_id,
509: FND_API.G_MISS_NUM, NULL,
510: x_geography_element1_id),
511: geography_element1_code =
512: DECODE(x_geography_element1_code,
513: NULL, geography_element1_code,

Line 514: FND_API.G_MISS_CHAR, NULL,

510: x_geography_element1_id),
511: geography_element1_code =
512: DECODE(x_geography_element1_code,
513: NULL, geography_element1_code,
514: FND_API.G_MISS_CHAR, NULL,
515: x_geography_element1_code),
516: geography_element2 =
517: DECODE(x_geography_element2,
518: NULL, geography_element2,

Line 519: FND_API.G_MISS_CHAR, NULL,

515: x_geography_element1_code),
516: geography_element2 =
517: DECODE(x_geography_element2,
518: NULL, geography_element2,
519: FND_API.G_MISS_CHAR, NULL,
520: x_geography_element2),
521: geography_element2_id =
522: DECODE(x_geography_element2_id,
523: NULL, geography_element2_id,

Line 524: FND_API.G_MISS_NUM, NULL,

520: x_geography_element2),
521: geography_element2_id =
522: DECODE(x_geography_element2_id,
523: NULL, geography_element2_id,
524: FND_API.G_MISS_NUM, NULL,
525: x_geography_element2_id),
526: geography_element2_code =
527: DECODE(x_geography_element2_code,
528: NULL, geography_element2_code,

Line 529: FND_API.G_MISS_CHAR, NULL,

525: x_geography_element2_id),
526: geography_element2_code =
527: DECODE(x_geography_element2_code,
528: NULL, geography_element2_code,
529: FND_API.G_MISS_CHAR, NULL,
530: x_geography_element2_code),
531: geography_element3 =
532: DECODE(x_geography_element3,
533: NULL, geography_element3,

Line 534: FND_API.G_MISS_CHAR, NULL,

530: x_geography_element2_code),
531: geography_element3 =
532: DECODE(x_geography_element3,
533: NULL, geography_element3,
534: FND_API.G_MISS_CHAR, NULL,
535: x_geography_element3),
536: geography_element3_id =
537: DECODE(x_geography_element3_id,
538: NULL, geography_element3_id,

Line 539: FND_API.G_MISS_NUM, NULL,

535: x_geography_element3),
536: geography_element3_id =
537: DECODE(x_geography_element3_id,
538: NULL, geography_element3_id,
539: FND_API.G_MISS_NUM, NULL,
540: x_geography_element3_id),
541: geography_element3_code =
542: DECODE(x_geography_element3_code,
543: NULL, geography_element3_code,

Line 544: FND_API.G_MISS_CHAR, NULL,

540: x_geography_element3_id),
541: geography_element3_code =
542: DECODE(x_geography_element3_code,
543: NULL, geography_element3_code,
544: FND_API.G_MISS_CHAR, NULL,
545: x_geography_element3_code),
546: geography_element4 =
547: DECODE(x_geography_element4,
548: NULL, geography_element4,

Line 549: FND_API.G_MISS_CHAR, NULL,

545: x_geography_element3_code),
546: geography_element4 =
547: DECODE(x_geography_element4,
548: NULL, geography_element4,
549: FND_API.G_MISS_CHAR, NULL,
550: x_geography_element4),
551: geography_element4_id =
552: DECODE(x_geography_element4_id,
553: NULL, geography_element4_id,

Line 554: FND_API.G_MISS_NUM, NULL,

550: x_geography_element4),
551: geography_element4_id =
552: DECODE(x_geography_element4_id,
553: NULL, geography_element4_id,
554: FND_API.G_MISS_NUM, NULL,
555: x_geography_element4_id),
556: geography_element4_code =
557: DECODE(x_geography_element4_code,
558: NULL, geography_element4_code,

Line 559: FND_API.G_MISS_CHAR, NULL,

555: x_geography_element4_id),
556: geography_element4_code =
557: DECODE(x_geography_element4_code,
558: NULL, geography_element4_code,
559: FND_API.G_MISS_CHAR, NULL,
560: x_geography_element4_code),
561: geography_element5 =
562: DECODE(x_geography_element5,
563: NULL, geography_element5,

Line 564: FND_API.G_MISS_CHAR, NULL,

560: x_geography_element4_code),
561: geography_element5 =
562: DECODE(x_geography_element5,
563: NULL, geography_element5,
564: FND_API.G_MISS_CHAR, NULL,
565: x_geography_element5),
566: geography_element5_id =
567: DECODE(x_geography_element5_id,
568: NULL, geography_element5_id,

Line 569: FND_API.G_MISS_NUM, NULL,

565: x_geography_element5),
566: geography_element5_id =
567: DECODE(x_geography_element5_id,
568: NULL, geography_element5_id,
569: FND_API.G_MISS_NUM, NULL,
570: x_geography_element5_id),
571: geography_element5_code =
572: DECODE(x_geography_element5_code,
573: NULL, geography_element5_code,

Line 574: FND_API.G_MISS_CHAR, NULL,

570: x_geography_element5_id),
571: geography_element5_code =
572: DECODE(x_geography_element5_code,
573: NULL, geography_element5_code,
574: FND_API.G_MISS_CHAR, NULL,
575: x_geography_element5_code),
576: geography_element6 =
577: DECODE(x_geography_element6,
578: NULL, geography_element6,

Line 579: FND_API.G_MISS_CHAR, NULL,

575: x_geography_element5_code),
576: geography_element6 =
577: DECODE(x_geography_element6,
578: NULL, geography_element6,
579: FND_API.G_MISS_CHAR, NULL,
580: x_geography_element6),
581: geography_element6_id =
582: DECODE(x_geography_element6_id,
583: NULL, geography_element6_id,

Line 584: FND_API.G_MISS_NUM, NULL,

580: x_geography_element6),
581: geography_element6_id =
582: DECODE(x_geography_element6_id,
583: NULL, geography_element6_id,
584: FND_API.G_MISS_NUM, NULL,
585: x_geography_element6_id),
586: geography_element7 =
587: DECODE(x_geography_element7,
588: NULL, geography_element7,

Line 589: FND_API.G_MISS_CHAR, NULL,

585: x_geography_element6_id),
586: geography_element7 =
587: DECODE(x_geography_element7,
588: NULL, geography_element7,
589: FND_API.G_MISS_CHAR, NULL,
590: x_geography_element7),
591: geography_element7_id =
592: DECODE(x_geography_element7_id,
593: NULL, geography_element7_id,

Line 594: FND_API.G_MISS_NUM, NULL,

590: x_geography_element7),
591: geography_element7_id =
592: DECODE(x_geography_element7_id,
593: NULL, geography_element7_id,
594: FND_API.G_MISS_NUM, NULL,
595: x_geography_element7_id),
596: geography_element8 =
597: DECODE(x_geography_element8,
598: NULL, geography_element8,

Line 599: FND_API.G_MISS_CHAR, NULL,

595: x_geography_element7_id),
596: geography_element8 =
597: DECODE(x_geography_element8,
598: NULL, geography_element8,
599: FND_API.G_MISS_CHAR, NULL,
600: x_geography_element8),
601: geography_element8_id =
602: DECODE(x_geography_element8_id,
603: NULL, geography_element8_id,

Line 604: FND_API.G_MISS_NUM, NULL,

600: x_geography_element8),
601: geography_element8_id =
602: DECODE(x_geography_element8_id,
603: NULL, geography_element8_id,
604: FND_API.G_MISS_NUM, NULL,
605: x_geography_element8_id),
606: geography_element9 =
607: DECODE(x_geography_element9,
608: NULL, geography_element9,

Line 609: FND_API.G_MISS_CHAR, NULL,

605: x_geography_element8_id),
606: geography_element9 =
607: DECODE(x_geography_element9,
608: NULL, geography_element9,
609: FND_API.G_MISS_CHAR, NULL,
610: x_geography_element9),
611: geography_element9_id =
612: DECODE(x_geography_element9_id,
613: NULL, geography_element9_id,

Line 614: FND_API.G_MISS_NUM, NULL,

610: x_geography_element9),
611: geography_element9_id =
612: DECODE(x_geography_element9_id,
613: NULL, geography_element9_id,
614: FND_API.G_MISS_NUM, NULL,
615: x_geography_element9_id),
616: geography_element10 =
617: DECODE(x_geography_element10,
618: NULL, geography_element10,

Line 619: FND_API.G_MISS_CHAR, NULL,

615: x_geography_element9_id),
616: geography_element10 =
617: DECODE(x_geography_element10,
618: NULL, geography_element10,
619: FND_API.G_MISS_CHAR, NULL,
620: x_geography_element10),
621: geography_element10_id =
622: DECODE(x_geography_element10_id,
623: NULL, geography_element10_id,

Line 624: FND_API.G_MISS_NUM, NULL,

620: x_geography_element10),
621: geography_element10_id =
622: DECODE(x_geography_element10_id,
623: NULL, geography_element10_id,
624: FND_API.G_MISS_NUM, NULL,
625: x_geography_element10_id),
626: geometry = geometry,
627: timezone_code =
628: DECODE(x_timezone_code,

Line 630: FND_API.G_MISS_CHAR, NULL,

626: geometry = geometry,
627: timezone_code =
628: DECODE(x_timezone_code,
629: NULL, timezone_code,
630: FND_API.G_MISS_CHAR, NULL,
631: x_timezone_code),
632: last_updated_by = hz_utility_v2pub.last_updated_by,
633: creation_date = creation_date,
634: created_by = created_by,

Line 640: FND_API.G_MISS_NUM, NULL,

636: last_update_login = hz_utility_v2pub.last_update_login,
637: application_id =
638: DECODE(x_application_id,
639: NULL, application_id,
640: FND_API.G_MISS_NUM, NULL,
641: x_application_id),
642: program_id = hz_utility_v2pub.program_id,
643: program_login_id =
644: DECODE(x_program_login_id,

Line 646: FND_API.G_MISS_NUM, NULL,

642: program_id = hz_utility_v2pub.program_id,
643: program_login_id =
644: DECODE(x_program_login_id,
645: NULL, program_login_id,
646: FND_API.G_MISS_NUM, NULL,
647: x_program_login_id),
648: program_application_id = hz_utility_v2pub.program_application_id,
649: request_id = hz_utility_v2pub.request_id,
650: attribute_category =

Line 653: FND_API.G_MISS_CHAR, NULL,

649: request_id = hz_utility_v2pub.request_id,
650: attribute_category =
651: DECODE(x_attribute_category,
652: NULL, attribute_category,
653: FND_API.G_MISS_CHAR, NULL,
654: x_attribute_category),
655: attribute1 =
656: DECODE(x_attribute1,
657: NULL, attribute1,

Line 658: FND_API.G_MISS_CHAR, NULL,

654: x_attribute_category),
655: attribute1 =
656: DECODE(x_attribute1,
657: NULL, attribute1,
658: FND_API.G_MISS_CHAR, NULL,
659: x_attribute1),
660: attribute2 =
661: DECODE(x_attribute2,
662: NULL, attribute2,

Line 663: FND_API.G_MISS_CHAR, NULL,

659: x_attribute1),
660: attribute2 =
661: DECODE(x_attribute2,
662: NULL, attribute2,
663: FND_API.G_MISS_CHAR, NULL,
664: x_attribute2),
665: attribute3 =
666: DECODE(x_attribute3,
667: NULL, attribute3,

Line 668: FND_API.G_MISS_CHAR, NULL,

664: x_attribute2),
665: attribute3 =
666: DECODE(x_attribute3,
667: NULL, attribute3,
668: FND_API.G_MISS_CHAR, NULL,
669: x_attribute3),
670: attribute4 =
671: DECODE(x_attribute4,
672: NULL, attribute4,

Line 673: FND_API.G_MISS_CHAR, NULL,

669: x_attribute3),
670: attribute4 =
671: DECODE(x_attribute4,
672: NULL, attribute4,
673: FND_API.G_MISS_CHAR, NULL,
674: x_attribute4),
675: attribute5 =
676: DECODE(x_attribute5,
677: NULL, attribute5,

Line 678: FND_API.G_MISS_CHAR, NULL,

674: x_attribute4),
675: attribute5 =
676: DECODE(x_attribute5,
677: NULL, attribute5,
678: FND_API.G_MISS_CHAR, NULL,
679: x_attribute5),
680: attribute6 =
681: DECODE(x_attribute6,
682: NULL, attribute6,

Line 683: FND_API.G_MISS_CHAR, NULL,

679: x_attribute5),
680: attribute6 =
681: DECODE(x_attribute6,
682: NULL, attribute6,
683: FND_API.G_MISS_CHAR, NULL,
684: x_attribute6),
685: attribute7 =
686: DECODE(x_attribute7,
687: NULL, attribute7,

Line 688: FND_API.G_MISS_CHAR, NULL,

684: x_attribute6),
685: attribute7 =
686: DECODE(x_attribute7,
687: NULL, attribute7,
688: FND_API.G_MISS_CHAR, NULL,
689: x_attribute7),
690: attribute8 =
691: DECODE(x_attribute8,
692: NULL, attribute8,

Line 693: FND_API.G_MISS_CHAR, NULL,

689: x_attribute7),
690: attribute8 =
691: DECODE(x_attribute8,
692: NULL, attribute8,
693: FND_API.G_MISS_CHAR, NULL,
694: x_attribute8),
695: attribute9 =
696: DECODE(x_attribute9,
697: NULL, attribute9,

Line 698: FND_API.G_MISS_CHAR, NULL,

694: x_attribute8),
695: attribute9 =
696: DECODE(x_attribute9,
697: NULL, attribute9,
698: FND_API.G_MISS_CHAR, NULL,
699: x_attribute9),
700: attribute10 =
701: DECODE(x_attribute10,
702: NULL, attribute10,

Line 703: FND_API.G_MISS_CHAR, NULL,

699: x_attribute9),
700: attribute10 =
701: DECODE(x_attribute10,
702: NULL, attribute10,
703: FND_API.G_MISS_CHAR, NULL,
704: x_attribute10),
705: attribute11 =
706: DECODE(x_attribute11,
707: NULL, attribute11,

Line 708: FND_API.G_MISS_CHAR, NULL,

704: x_attribute10),
705: attribute11 =
706: DECODE(x_attribute11,
707: NULL, attribute11,
708: FND_API.G_MISS_CHAR, NULL,
709: x_attribute11),
710: attribute12 =
711: DECODE(x_attribute12,
712: NULL, attribute12,

Line 713: FND_API.G_MISS_CHAR, NULL,

709: x_attribute11),
710: attribute12 =
711: DECODE(x_attribute12,
712: NULL, attribute12,
713: FND_API.G_MISS_CHAR, NULL,
714: x_attribute12),
715: attribute13 =
716: DECODE(x_attribute13,
717: NULL, attribute13,

Line 718: FND_API.G_MISS_CHAR, NULL,

714: x_attribute12),
715: attribute13 =
716: DECODE(x_attribute13,
717: NULL, attribute13,
718: FND_API.G_MISS_CHAR, NULL,
719: x_attribute13),
720: attribute14 =
721: DECODE(x_attribute14,
722: NULL, attribute14,

Line 723: FND_API.G_MISS_CHAR, NULL,

719: x_attribute13),
720: attribute14 =
721: DECODE(x_attribute14,
722: NULL, attribute14,
723: FND_API.G_MISS_CHAR, NULL,
724: x_attribute14),
725: attribute15 =
726: DECODE(x_attribute15,
727: NULL, attribute15,

Line 728: FND_API.G_MISS_CHAR, NULL,

724: x_attribute14),
725: attribute15 =
726: DECODE(x_attribute15,
727: NULL, attribute15,
728: FND_API.G_MISS_CHAR, NULL,
729: x_attribute15),
730: attribute16 =
731: DECODE(x_attribute16,
732: NULL, attribute16,

Line 733: FND_API.G_MISS_CHAR, NULL,

729: x_attribute15),
730: attribute16 =
731: DECODE(x_attribute16,
732: NULL, attribute16,
733: FND_API.G_MISS_CHAR, NULL,
734: x_attribute16),
735: attribute17 =
736: DECODE(x_attribute17,
737: NULL, attribute17,

Line 738: FND_API.G_MISS_CHAR, NULL,

734: x_attribute16),
735: attribute17 =
736: DECODE(x_attribute17,
737: NULL, attribute17,
738: FND_API.G_MISS_CHAR, NULL,
739: x_attribute17),
740: attribute18 =
741: DECODE(x_attribute18,
742: NULL, attribute18,

Line 743: FND_API.G_MISS_CHAR, NULL,

739: x_attribute17),
740: attribute18 =
741: DECODE(x_attribute18,
742: NULL, attribute18,
743: FND_API.G_MISS_CHAR, NULL,
744: x_attribute18),
745: attribute19 =
746: DECODE(x_attribute19,
747: NULL, attribute19,

Line 748: FND_API.G_MISS_CHAR, NULL,

744: x_attribute18),
745: attribute19 =
746: DECODE(x_attribute19,
747: NULL, attribute19,
748: FND_API.G_MISS_CHAR, NULL,
749: x_attribute19),
750: attribute20 =
751: DECODE(x_attribute20,
752: NULL, attribute20,

Line 753: FND_API.G_MISS_CHAR, NULL,

749: x_attribute19),
750: attribute20 =
751: DECODE(x_attribute20,
752: NULL, attribute20,
753: FND_API.G_MISS_CHAR, NULL,
754: x_attribute20)
755: WHERE rowid = x_rowid;
756:
757: IF ( SQL%NOTFOUND ) THEN

Line 1136: NVL(geography_id, FND_API.G_MISS_NUM),

1132: ) IS
1133: BEGIN
1134:
1135: SELECT
1136: NVL(geography_id, FND_API.G_MISS_NUM),
1137: NVL(geography_type, FND_API.G_MISS_CHAR),
1138: NVL(geography_name, FND_API.G_MISS_CHAR),
1139: NVL(geography_use, FND_API.G_MISS_CHAR),
1140: NVL(geography_code, FND_API.G_MISS_CHAR),

Line 1137: NVL(geography_type, FND_API.G_MISS_CHAR),

1133: BEGIN
1134:
1135: SELECT
1136: NVL(geography_id, FND_API.G_MISS_NUM),
1137: NVL(geography_type, FND_API.G_MISS_CHAR),
1138: NVL(geography_name, FND_API.G_MISS_CHAR),
1139: NVL(geography_use, FND_API.G_MISS_CHAR),
1140: NVL(geography_code, FND_API.G_MISS_CHAR),
1141: NVL(start_date, FND_API.G_MISS_DATE),

Line 1138: NVL(geography_name, FND_API.G_MISS_CHAR),

1134:
1135: SELECT
1136: NVL(geography_id, FND_API.G_MISS_NUM),
1137: NVL(geography_type, FND_API.G_MISS_CHAR),
1138: NVL(geography_name, FND_API.G_MISS_CHAR),
1139: NVL(geography_use, FND_API.G_MISS_CHAR),
1140: NVL(geography_code, FND_API.G_MISS_CHAR),
1141: NVL(start_date, FND_API.G_MISS_DATE),
1142: NVL(end_date, FND_API.G_MISS_DATE),

Line 1139: NVL(geography_use, FND_API.G_MISS_CHAR),

1135: SELECT
1136: NVL(geography_id, FND_API.G_MISS_NUM),
1137: NVL(geography_type, FND_API.G_MISS_CHAR),
1138: NVL(geography_name, FND_API.G_MISS_CHAR),
1139: NVL(geography_use, FND_API.G_MISS_CHAR),
1140: NVL(geography_code, FND_API.G_MISS_CHAR),
1141: NVL(start_date, FND_API.G_MISS_DATE),
1142: NVL(end_date, FND_API.G_MISS_DATE),
1143: NVL(multiple_parent_flag, FND_API.G_MISS_CHAR),

Line 1140: NVL(geography_code, FND_API.G_MISS_CHAR),

1136: NVL(geography_id, FND_API.G_MISS_NUM),
1137: NVL(geography_type, FND_API.G_MISS_CHAR),
1138: NVL(geography_name, FND_API.G_MISS_CHAR),
1139: NVL(geography_use, FND_API.G_MISS_CHAR),
1140: NVL(geography_code, FND_API.G_MISS_CHAR),
1141: NVL(start_date, FND_API.G_MISS_DATE),
1142: NVL(end_date, FND_API.G_MISS_DATE),
1143: NVL(multiple_parent_flag, FND_API.G_MISS_CHAR),
1144: NVL(created_by_module, FND_API.G_MISS_CHAR),

Line 1141: NVL(start_date, FND_API.G_MISS_DATE),

1137: NVL(geography_type, FND_API.G_MISS_CHAR),
1138: NVL(geography_name, FND_API.G_MISS_CHAR),
1139: NVL(geography_use, FND_API.G_MISS_CHAR),
1140: NVL(geography_code, FND_API.G_MISS_CHAR),
1141: NVL(start_date, FND_API.G_MISS_DATE),
1142: NVL(end_date, FND_API.G_MISS_DATE),
1143: NVL(multiple_parent_flag, FND_API.G_MISS_CHAR),
1144: NVL(created_by_module, FND_API.G_MISS_CHAR),
1145: NVL(country_code, FND_API.G_MISS_CHAR),

Line 1142: NVL(end_date, FND_API.G_MISS_DATE),

1138: NVL(geography_name, FND_API.G_MISS_CHAR),
1139: NVL(geography_use, FND_API.G_MISS_CHAR),
1140: NVL(geography_code, FND_API.G_MISS_CHAR),
1141: NVL(start_date, FND_API.G_MISS_DATE),
1142: NVL(end_date, FND_API.G_MISS_DATE),
1143: NVL(multiple_parent_flag, FND_API.G_MISS_CHAR),
1144: NVL(created_by_module, FND_API.G_MISS_CHAR),
1145: NVL(country_code, FND_API.G_MISS_CHAR),
1146: NVL(geography_element1, FND_API.G_MISS_CHAR),

Line 1143: NVL(multiple_parent_flag, FND_API.G_MISS_CHAR),

1139: NVL(geography_use, FND_API.G_MISS_CHAR),
1140: NVL(geography_code, FND_API.G_MISS_CHAR),
1141: NVL(start_date, FND_API.G_MISS_DATE),
1142: NVL(end_date, FND_API.G_MISS_DATE),
1143: NVL(multiple_parent_flag, FND_API.G_MISS_CHAR),
1144: NVL(created_by_module, FND_API.G_MISS_CHAR),
1145: NVL(country_code, FND_API.G_MISS_CHAR),
1146: NVL(geography_element1, FND_API.G_MISS_CHAR),
1147: NVL(geography_element1_id, FND_API.G_MISS_NUM),

Line 1144: NVL(created_by_module, FND_API.G_MISS_CHAR),

1140: NVL(geography_code, FND_API.G_MISS_CHAR),
1141: NVL(start_date, FND_API.G_MISS_DATE),
1142: NVL(end_date, FND_API.G_MISS_DATE),
1143: NVL(multiple_parent_flag, FND_API.G_MISS_CHAR),
1144: NVL(created_by_module, FND_API.G_MISS_CHAR),
1145: NVL(country_code, FND_API.G_MISS_CHAR),
1146: NVL(geography_element1, FND_API.G_MISS_CHAR),
1147: NVL(geography_element1_id, FND_API.G_MISS_NUM),
1148: NVL(geography_element1_code, FND_API.G_MISS_CHAR),

Line 1145: NVL(country_code, FND_API.G_MISS_CHAR),

1141: NVL(start_date, FND_API.G_MISS_DATE),
1142: NVL(end_date, FND_API.G_MISS_DATE),
1143: NVL(multiple_parent_flag, FND_API.G_MISS_CHAR),
1144: NVL(created_by_module, FND_API.G_MISS_CHAR),
1145: NVL(country_code, FND_API.G_MISS_CHAR),
1146: NVL(geography_element1, FND_API.G_MISS_CHAR),
1147: NVL(geography_element1_id, FND_API.G_MISS_NUM),
1148: NVL(geography_element1_code, FND_API.G_MISS_CHAR),
1149: NVL(geography_element2, FND_API.G_MISS_CHAR),

Line 1146: NVL(geography_element1, FND_API.G_MISS_CHAR),

1142: NVL(end_date, FND_API.G_MISS_DATE),
1143: NVL(multiple_parent_flag, FND_API.G_MISS_CHAR),
1144: NVL(created_by_module, FND_API.G_MISS_CHAR),
1145: NVL(country_code, FND_API.G_MISS_CHAR),
1146: NVL(geography_element1, FND_API.G_MISS_CHAR),
1147: NVL(geography_element1_id, FND_API.G_MISS_NUM),
1148: NVL(geography_element1_code, FND_API.G_MISS_CHAR),
1149: NVL(geography_element2, FND_API.G_MISS_CHAR),
1150: NVL(geography_element2_id, FND_API.G_MISS_NUM),

Line 1147: NVL(geography_element1_id, FND_API.G_MISS_NUM),

1143: NVL(multiple_parent_flag, FND_API.G_MISS_CHAR),
1144: NVL(created_by_module, FND_API.G_MISS_CHAR),
1145: NVL(country_code, FND_API.G_MISS_CHAR),
1146: NVL(geography_element1, FND_API.G_MISS_CHAR),
1147: NVL(geography_element1_id, FND_API.G_MISS_NUM),
1148: NVL(geography_element1_code, FND_API.G_MISS_CHAR),
1149: NVL(geography_element2, FND_API.G_MISS_CHAR),
1150: NVL(geography_element2_id, FND_API.G_MISS_NUM),
1151: NVL(geography_element2_code, FND_API.G_MISS_CHAR),

Line 1148: NVL(geography_element1_code, FND_API.G_MISS_CHAR),

1144: NVL(created_by_module, FND_API.G_MISS_CHAR),
1145: NVL(country_code, FND_API.G_MISS_CHAR),
1146: NVL(geography_element1, FND_API.G_MISS_CHAR),
1147: NVL(geography_element1_id, FND_API.G_MISS_NUM),
1148: NVL(geography_element1_code, FND_API.G_MISS_CHAR),
1149: NVL(geography_element2, FND_API.G_MISS_CHAR),
1150: NVL(geography_element2_id, FND_API.G_MISS_NUM),
1151: NVL(geography_element2_code, FND_API.G_MISS_CHAR),
1152: NVL(geography_element3, FND_API.G_MISS_CHAR),

Line 1149: NVL(geography_element2, FND_API.G_MISS_CHAR),

1145: NVL(country_code, FND_API.G_MISS_CHAR),
1146: NVL(geography_element1, FND_API.G_MISS_CHAR),
1147: NVL(geography_element1_id, FND_API.G_MISS_NUM),
1148: NVL(geography_element1_code, FND_API.G_MISS_CHAR),
1149: NVL(geography_element2, FND_API.G_MISS_CHAR),
1150: NVL(geography_element2_id, FND_API.G_MISS_NUM),
1151: NVL(geography_element2_code, FND_API.G_MISS_CHAR),
1152: NVL(geography_element3, FND_API.G_MISS_CHAR),
1153: NVL(geography_element3_id, FND_API.G_MISS_NUM),

Line 1150: NVL(geography_element2_id, FND_API.G_MISS_NUM),

1146: NVL(geography_element1, FND_API.G_MISS_CHAR),
1147: NVL(geography_element1_id, FND_API.G_MISS_NUM),
1148: NVL(geography_element1_code, FND_API.G_MISS_CHAR),
1149: NVL(geography_element2, FND_API.G_MISS_CHAR),
1150: NVL(geography_element2_id, FND_API.G_MISS_NUM),
1151: NVL(geography_element2_code, FND_API.G_MISS_CHAR),
1152: NVL(geography_element3, FND_API.G_MISS_CHAR),
1153: NVL(geography_element3_id, FND_API.G_MISS_NUM),
1154: NVL(geography_element3_code, FND_API.G_MISS_CHAR),

Line 1151: NVL(geography_element2_code, FND_API.G_MISS_CHAR),

1147: NVL(geography_element1_id, FND_API.G_MISS_NUM),
1148: NVL(geography_element1_code, FND_API.G_MISS_CHAR),
1149: NVL(geography_element2, FND_API.G_MISS_CHAR),
1150: NVL(geography_element2_id, FND_API.G_MISS_NUM),
1151: NVL(geography_element2_code, FND_API.G_MISS_CHAR),
1152: NVL(geography_element3, FND_API.G_MISS_CHAR),
1153: NVL(geography_element3_id, FND_API.G_MISS_NUM),
1154: NVL(geography_element3_code, FND_API.G_MISS_CHAR),
1155: NVL(geography_element4, FND_API.G_MISS_CHAR),

Line 1152: NVL(geography_element3, FND_API.G_MISS_CHAR),

1148: NVL(geography_element1_code, FND_API.G_MISS_CHAR),
1149: NVL(geography_element2, FND_API.G_MISS_CHAR),
1150: NVL(geography_element2_id, FND_API.G_MISS_NUM),
1151: NVL(geography_element2_code, FND_API.G_MISS_CHAR),
1152: NVL(geography_element3, FND_API.G_MISS_CHAR),
1153: NVL(geography_element3_id, FND_API.G_MISS_NUM),
1154: NVL(geography_element3_code, FND_API.G_MISS_CHAR),
1155: NVL(geography_element4, FND_API.G_MISS_CHAR),
1156: NVL(geography_element4_id, FND_API.G_MISS_NUM),

Line 1153: NVL(geography_element3_id, FND_API.G_MISS_NUM),

1149: NVL(geography_element2, FND_API.G_MISS_CHAR),
1150: NVL(geography_element2_id, FND_API.G_MISS_NUM),
1151: NVL(geography_element2_code, FND_API.G_MISS_CHAR),
1152: NVL(geography_element3, FND_API.G_MISS_CHAR),
1153: NVL(geography_element3_id, FND_API.G_MISS_NUM),
1154: NVL(geography_element3_code, FND_API.G_MISS_CHAR),
1155: NVL(geography_element4, FND_API.G_MISS_CHAR),
1156: NVL(geography_element4_id, FND_API.G_MISS_NUM),
1157: NVL(geography_element4_code, FND_API.G_MISS_CHAR),

Line 1154: NVL(geography_element3_code, FND_API.G_MISS_CHAR),

1150: NVL(geography_element2_id, FND_API.G_MISS_NUM),
1151: NVL(geography_element2_code, FND_API.G_MISS_CHAR),
1152: NVL(geography_element3, FND_API.G_MISS_CHAR),
1153: NVL(geography_element3_id, FND_API.G_MISS_NUM),
1154: NVL(geography_element3_code, FND_API.G_MISS_CHAR),
1155: NVL(geography_element4, FND_API.G_MISS_CHAR),
1156: NVL(geography_element4_id, FND_API.G_MISS_NUM),
1157: NVL(geography_element4_code, FND_API.G_MISS_CHAR),
1158: NVL(geography_element5, FND_API.G_MISS_CHAR),

Line 1155: NVL(geography_element4, FND_API.G_MISS_CHAR),

1151: NVL(geography_element2_code, FND_API.G_MISS_CHAR),
1152: NVL(geography_element3, FND_API.G_MISS_CHAR),
1153: NVL(geography_element3_id, FND_API.G_MISS_NUM),
1154: NVL(geography_element3_code, FND_API.G_MISS_CHAR),
1155: NVL(geography_element4, FND_API.G_MISS_CHAR),
1156: NVL(geography_element4_id, FND_API.G_MISS_NUM),
1157: NVL(geography_element4_code, FND_API.G_MISS_CHAR),
1158: NVL(geography_element5, FND_API.G_MISS_CHAR),
1159: NVL(geography_element5_id, FND_API.G_MISS_NUM),

Line 1156: NVL(geography_element4_id, FND_API.G_MISS_NUM),

1152: NVL(geography_element3, FND_API.G_MISS_CHAR),
1153: NVL(geography_element3_id, FND_API.G_MISS_NUM),
1154: NVL(geography_element3_code, FND_API.G_MISS_CHAR),
1155: NVL(geography_element4, FND_API.G_MISS_CHAR),
1156: NVL(geography_element4_id, FND_API.G_MISS_NUM),
1157: NVL(geography_element4_code, FND_API.G_MISS_CHAR),
1158: NVL(geography_element5, FND_API.G_MISS_CHAR),
1159: NVL(geography_element5_id, FND_API.G_MISS_NUM),
1160: NVL(geography_element5_code, FND_API.G_MISS_CHAR),

Line 1157: NVL(geography_element4_code, FND_API.G_MISS_CHAR),

1153: NVL(geography_element3_id, FND_API.G_MISS_NUM),
1154: NVL(geography_element3_code, FND_API.G_MISS_CHAR),
1155: NVL(geography_element4, FND_API.G_MISS_CHAR),
1156: NVL(geography_element4_id, FND_API.G_MISS_NUM),
1157: NVL(geography_element4_code, FND_API.G_MISS_CHAR),
1158: NVL(geography_element5, FND_API.G_MISS_CHAR),
1159: NVL(geography_element5_id, FND_API.G_MISS_NUM),
1160: NVL(geography_element5_code, FND_API.G_MISS_CHAR),
1161: NVL(geography_element6, FND_API.G_MISS_CHAR),

Line 1158: NVL(geography_element5, FND_API.G_MISS_CHAR),

1154: NVL(geography_element3_code, FND_API.G_MISS_CHAR),
1155: NVL(geography_element4, FND_API.G_MISS_CHAR),
1156: NVL(geography_element4_id, FND_API.G_MISS_NUM),
1157: NVL(geography_element4_code, FND_API.G_MISS_CHAR),
1158: NVL(geography_element5, FND_API.G_MISS_CHAR),
1159: NVL(geography_element5_id, FND_API.G_MISS_NUM),
1160: NVL(geography_element5_code, FND_API.G_MISS_CHAR),
1161: NVL(geography_element6, FND_API.G_MISS_CHAR),
1162: NVL(geography_element6_id, FND_API.G_MISS_NUM),

Line 1159: NVL(geography_element5_id, FND_API.G_MISS_NUM),

1155: NVL(geography_element4, FND_API.G_MISS_CHAR),
1156: NVL(geography_element4_id, FND_API.G_MISS_NUM),
1157: NVL(geography_element4_code, FND_API.G_MISS_CHAR),
1158: NVL(geography_element5, FND_API.G_MISS_CHAR),
1159: NVL(geography_element5_id, FND_API.G_MISS_NUM),
1160: NVL(geography_element5_code, FND_API.G_MISS_CHAR),
1161: NVL(geography_element6, FND_API.G_MISS_CHAR),
1162: NVL(geography_element6_id, FND_API.G_MISS_NUM),
1163: NVL(geography_element7, FND_API.G_MISS_CHAR),

Line 1160: NVL(geography_element5_code, FND_API.G_MISS_CHAR),

1156: NVL(geography_element4_id, FND_API.G_MISS_NUM),
1157: NVL(geography_element4_code, FND_API.G_MISS_CHAR),
1158: NVL(geography_element5, FND_API.G_MISS_CHAR),
1159: NVL(geography_element5_id, FND_API.G_MISS_NUM),
1160: NVL(geography_element5_code, FND_API.G_MISS_CHAR),
1161: NVL(geography_element6, FND_API.G_MISS_CHAR),
1162: NVL(geography_element6_id, FND_API.G_MISS_NUM),
1163: NVL(geography_element7, FND_API.G_MISS_CHAR),
1164: NVL(geography_element7_id, FND_API.G_MISS_NUM),

Line 1161: NVL(geography_element6, FND_API.G_MISS_CHAR),

1157: NVL(geography_element4_code, FND_API.G_MISS_CHAR),
1158: NVL(geography_element5, FND_API.G_MISS_CHAR),
1159: NVL(geography_element5_id, FND_API.G_MISS_NUM),
1160: NVL(geography_element5_code, FND_API.G_MISS_CHAR),
1161: NVL(geography_element6, FND_API.G_MISS_CHAR),
1162: NVL(geography_element6_id, FND_API.G_MISS_NUM),
1163: NVL(geography_element7, FND_API.G_MISS_CHAR),
1164: NVL(geography_element7_id, FND_API.G_MISS_NUM),
1165: NVL(geography_element8, FND_API.G_MISS_CHAR),

Line 1162: NVL(geography_element6_id, FND_API.G_MISS_NUM),

1158: NVL(geography_element5, FND_API.G_MISS_CHAR),
1159: NVL(geography_element5_id, FND_API.G_MISS_NUM),
1160: NVL(geography_element5_code, FND_API.G_MISS_CHAR),
1161: NVL(geography_element6, FND_API.G_MISS_CHAR),
1162: NVL(geography_element6_id, FND_API.G_MISS_NUM),
1163: NVL(geography_element7, FND_API.G_MISS_CHAR),
1164: NVL(geography_element7_id, FND_API.G_MISS_NUM),
1165: NVL(geography_element8, FND_API.G_MISS_CHAR),
1166: NVL(geography_element8_id, FND_API.G_MISS_NUM),

Line 1163: NVL(geography_element7, FND_API.G_MISS_CHAR),

1159: NVL(geography_element5_id, FND_API.G_MISS_NUM),
1160: NVL(geography_element5_code, FND_API.G_MISS_CHAR),
1161: NVL(geography_element6, FND_API.G_MISS_CHAR),
1162: NVL(geography_element6_id, FND_API.G_MISS_NUM),
1163: NVL(geography_element7, FND_API.G_MISS_CHAR),
1164: NVL(geography_element7_id, FND_API.G_MISS_NUM),
1165: NVL(geography_element8, FND_API.G_MISS_CHAR),
1166: NVL(geography_element8_id, FND_API.G_MISS_NUM),
1167: NVL(geography_element9, FND_API.G_MISS_CHAR),

Line 1164: NVL(geography_element7_id, FND_API.G_MISS_NUM),

1160: NVL(geography_element5_code, FND_API.G_MISS_CHAR),
1161: NVL(geography_element6, FND_API.G_MISS_CHAR),
1162: NVL(geography_element6_id, FND_API.G_MISS_NUM),
1163: NVL(geography_element7, FND_API.G_MISS_CHAR),
1164: NVL(geography_element7_id, FND_API.G_MISS_NUM),
1165: NVL(geography_element8, FND_API.G_MISS_CHAR),
1166: NVL(geography_element8_id, FND_API.G_MISS_NUM),
1167: NVL(geography_element9, FND_API.G_MISS_CHAR),
1168: NVL(geography_element9_id, FND_API.G_MISS_NUM),

Line 1165: NVL(geography_element8, FND_API.G_MISS_CHAR),

1161: NVL(geography_element6, FND_API.G_MISS_CHAR),
1162: NVL(geography_element6_id, FND_API.G_MISS_NUM),
1163: NVL(geography_element7, FND_API.G_MISS_CHAR),
1164: NVL(geography_element7_id, FND_API.G_MISS_NUM),
1165: NVL(geography_element8, FND_API.G_MISS_CHAR),
1166: NVL(geography_element8_id, FND_API.G_MISS_NUM),
1167: NVL(geography_element9, FND_API.G_MISS_CHAR),
1168: NVL(geography_element9_id, FND_API.G_MISS_NUM),
1169: NVL(geography_element10, FND_API.G_MISS_CHAR),

Line 1166: NVL(geography_element8_id, FND_API.G_MISS_NUM),

1162: NVL(geography_element6_id, FND_API.G_MISS_NUM),
1163: NVL(geography_element7, FND_API.G_MISS_CHAR),
1164: NVL(geography_element7_id, FND_API.G_MISS_NUM),
1165: NVL(geography_element8, FND_API.G_MISS_CHAR),
1166: NVL(geography_element8_id, FND_API.G_MISS_NUM),
1167: NVL(geography_element9, FND_API.G_MISS_CHAR),
1168: NVL(geography_element9_id, FND_API.G_MISS_NUM),
1169: NVL(geography_element10, FND_API.G_MISS_CHAR),
1170: NVL(geography_element10_id, FND_API.G_MISS_NUM),

Line 1167: NVL(geography_element9, FND_API.G_MISS_CHAR),

1163: NVL(geography_element7, FND_API.G_MISS_CHAR),
1164: NVL(geography_element7_id, FND_API.G_MISS_NUM),
1165: NVL(geography_element8, FND_API.G_MISS_CHAR),
1166: NVL(geography_element8_id, FND_API.G_MISS_NUM),
1167: NVL(geography_element9, FND_API.G_MISS_CHAR),
1168: NVL(geography_element9_id, FND_API.G_MISS_NUM),
1169: NVL(geography_element10, FND_API.G_MISS_CHAR),
1170: NVL(geography_element10_id, FND_API.G_MISS_NUM),
1171: geometry,

Line 1168: NVL(geography_element9_id, FND_API.G_MISS_NUM),

1164: NVL(geography_element7_id, FND_API.G_MISS_NUM),
1165: NVL(geography_element8, FND_API.G_MISS_CHAR),
1166: NVL(geography_element8_id, FND_API.G_MISS_NUM),
1167: NVL(geography_element9, FND_API.G_MISS_CHAR),
1168: NVL(geography_element9_id, FND_API.G_MISS_NUM),
1169: NVL(geography_element10, FND_API.G_MISS_CHAR),
1170: NVL(geography_element10_id, FND_API.G_MISS_NUM),
1171: geometry,
1172: NVL(timezone_code, FND_API.G_MISS_CHAR),

Line 1169: NVL(geography_element10, FND_API.G_MISS_CHAR),

1165: NVL(geography_element8, FND_API.G_MISS_CHAR),
1166: NVL(geography_element8_id, FND_API.G_MISS_NUM),
1167: NVL(geography_element9, FND_API.G_MISS_CHAR),
1168: NVL(geography_element9_id, FND_API.G_MISS_NUM),
1169: NVL(geography_element10, FND_API.G_MISS_CHAR),
1170: NVL(geography_element10_id, FND_API.G_MISS_NUM),
1171: geometry,
1172: NVL(timezone_code, FND_API.G_MISS_CHAR),
1173: NVL(application_id, FND_API.G_MISS_NUM),

Line 1170: NVL(geography_element10_id, FND_API.G_MISS_NUM),

1166: NVL(geography_element8_id, FND_API.G_MISS_NUM),
1167: NVL(geography_element9, FND_API.G_MISS_CHAR),
1168: NVL(geography_element9_id, FND_API.G_MISS_NUM),
1169: NVL(geography_element10, FND_API.G_MISS_CHAR),
1170: NVL(geography_element10_id, FND_API.G_MISS_NUM),
1171: geometry,
1172: NVL(timezone_code, FND_API.G_MISS_CHAR),
1173: NVL(application_id, FND_API.G_MISS_NUM),
1174: NVL(program_login_id, FND_API.G_MISS_NUM),

Line 1172: NVL(timezone_code, FND_API.G_MISS_CHAR),

1168: NVL(geography_element9_id, FND_API.G_MISS_NUM),
1169: NVL(geography_element10, FND_API.G_MISS_CHAR),
1170: NVL(geography_element10_id, FND_API.G_MISS_NUM),
1171: geometry,
1172: NVL(timezone_code, FND_API.G_MISS_CHAR),
1173: NVL(application_id, FND_API.G_MISS_NUM),
1174: NVL(program_login_id, FND_API.G_MISS_NUM),
1175: NVL(attribute_category, FND_API.G_MISS_CHAR),
1176: NVL(attribute1, FND_API.G_MISS_CHAR),

Line 1173: NVL(application_id, FND_API.G_MISS_NUM),

1169: NVL(geography_element10, FND_API.G_MISS_CHAR),
1170: NVL(geography_element10_id, FND_API.G_MISS_NUM),
1171: geometry,
1172: NVL(timezone_code, FND_API.G_MISS_CHAR),
1173: NVL(application_id, FND_API.G_MISS_NUM),
1174: NVL(program_login_id, FND_API.G_MISS_NUM),
1175: NVL(attribute_category, FND_API.G_MISS_CHAR),
1176: NVL(attribute1, FND_API.G_MISS_CHAR),
1177: NVL(attribute2, FND_API.G_MISS_CHAR),

Line 1174: NVL(program_login_id, FND_API.G_MISS_NUM),

1170: NVL(geography_element10_id, FND_API.G_MISS_NUM),
1171: geometry,
1172: NVL(timezone_code, FND_API.G_MISS_CHAR),
1173: NVL(application_id, FND_API.G_MISS_NUM),
1174: NVL(program_login_id, FND_API.G_MISS_NUM),
1175: NVL(attribute_category, FND_API.G_MISS_CHAR),
1176: NVL(attribute1, FND_API.G_MISS_CHAR),
1177: NVL(attribute2, FND_API.G_MISS_CHAR),
1178: NVL(attribute3, FND_API.G_MISS_CHAR),

Line 1175: NVL(attribute_category, FND_API.G_MISS_CHAR),

1171: geometry,
1172: NVL(timezone_code, FND_API.G_MISS_CHAR),
1173: NVL(application_id, FND_API.G_MISS_NUM),
1174: NVL(program_login_id, FND_API.G_MISS_NUM),
1175: NVL(attribute_category, FND_API.G_MISS_CHAR),
1176: NVL(attribute1, FND_API.G_MISS_CHAR),
1177: NVL(attribute2, FND_API.G_MISS_CHAR),
1178: NVL(attribute3, FND_API.G_MISS_CHAR),
1179: NVL(attribute4, FND_API.G_MISS_CHAR),

Line 1176: NVL(attribute1, FND_API.G_MISS_CHAR),

1172: NVL(timezone_code, FND_API.G_MISS_CHAR),
1173: NVL(application_id, FND_API.G_MISS_NUM),
1174: NVL(program_login_id, FND_API.G_MISS_NUM),
1175: NVL(attribute_category, FND_API.G_MISS_CHAR),
1176: NVL(attribute1, FND_API.G_MISS_CHAR),
1177: NVL(attribute2, FND_API.G_MISS_CHAR),
1178: NVL(attribute3, FND_API.G_MISS_CHAR),
1179: NVL(attribute4, FND_API.G_MISS_CHAR),
1180: NVL(attribute5, FND_API.G_MISS_CHAR),

Line 1177: NVL(attribute2, FND_API.G_MISS_CHAR),

1173: NVL(application_id, FND_API.G_MISS_NUM),
1174: NVL(program_login_id, FND_API.G_MISS_NUM),
1175: NVL(attribute_category, FND_API.G_MISS_CHAR),
1176: NVL(attribute1, FND_API.G_MISS_CHAR),
1177: NVL(attribute2, FND_API.G_MISS_CHAR),
1178: NVL(attribute3, FND_API.G_MISS_CHAR),
1179: NVL(attribute4, FND_API.G_MISS_CHAR),
1180: NVL(attribute5, FND_API.G_MISS_CHAR),
1181: NVL(attribute6, FND_API.G_MISS_CHAR),

Line 1178: NVL(attribute3, FND_API.G_MISS_CHAR),

1174: NVL(program_login_id, FND_API.G_MISS_NUM),
1175: NVL(attribute_category, FND_API.G_MISS_CHAR),
1176: NVL(attribute1, FND_API.G_MISS_CHAR),
1177: NVL(attribute2, FND_API.G_MISS_CHAR),
1178: NVL(attribute3, FND_API.G_MISS_CHAR),
1179: NVL(attribute4, FND_API.G_MISS_CHAR),
1180: NVL(attribute5, FND_API.G_MISS_CHAR),
1181: NVL(attribute6, FND_API.G_MISS_CHAR),
1182: NVL(attribute7, FND_API.G_MISS_CHAR),

Line 1179: NVL(attribute4, FND_API.G_MISS_CHAR),

1175: NVL(attribute_category, FND_API.G_MISS_CHAR),
1176: NVL(attribute1, FND_API.G_MISS_CHAR),
1177: NVL(attribute2, FND_API.G_MISS_CHAR),
1178: NVL(attribute3, FND_API.G_MISS_CHAR),
1179: NVL(attribute4, FND_API.G_MISS_CHAR),
1180: NVL(attribute5, FND_API.G_MISS_CHAR),
1181: NVL(attribute6, FND_API.G_MISS_CHAR),
1182: NVL(attribute7, FND_API.G_MISS_CHAR),
1183: NVL(attribute8, FND_API.G_MISS_CHAR),

Line 1180: NVL(attribute5, FND_API.G_MISS_CHAR),

1176: NVL(attribute1, FND_API.G_MISS_CHAR),
1177: NVL(attribute2, FND_API.G_MISS_CHAR),
1178: NVL(attribute3, FND_API.G_MISS_CHAR),
1179: NVL(attribute4, FND_API.G_MISS_CHAR),
1180: NVL(attribute5, FND_API.G_MISS_CHAR),
1181: NVL(attribute6, FND_API.G_MISS_CHAR),
1182: NVL(attribute7, FND_API.G_MISS_CHAR),
1183: NVL(attribute8, FND_API.G_MISS_CHAR),
1184: NVL(attribute9, FND_API.G_MISS_CHAR),

Line 1181: NVL(attribute6, FND_API.G_MISS_CHAR),

1177: NVL(attribute2, FND_API.G_MISS_CHAR),
1178: NVL(attribute3, FND_API.G_MISS_CHAR),
1179: NVL(attribute4, FND_API.G_MISS_CHAR),
1180: NVL(attribute5, FND_API.G_MISS_CHAR),
1181: NVL(attribute6, FND_API.G_MISS_CHAR),
1182: NVL(attribute7, FND_API.G_MISS_CHAR),
1183: NVL(attribute8, FND_API.G_MISS_CHAR),
1184: NVL(attribute9, FND_API.G_MISS_CHAR),
1185: NVL(attribute10, FND_API.G_MISS_CHAR),

Line 1182: NVL(attribute7, FND_API.G_MISS_CHAR),

1178: NVL(attribute3, FND_API.G_MISS_CHAR),
1179: NVL(attribute4, FND_API.G_MISS_CHAR),
1180: NVL(attribute5, FND_API.G_MISS_CHAR),
1181: NVL(attribute6, FND_API.G_MISS_CHAR),
1182: NVL(attribute7, FND_API.G_MISS_CHAR),
1183: NVL(attribute8, FND_API.G_MISS_CHAR),
1184: NVL(attribute9, FND_API.G_MISS_CHAR),
1185: NVL(attribute10, FND_API.G_MISS_CHAR),
1186: NVL(attribute11, FND_API.G_MISS_CHAR),

Line 1183: NVL(attribute8, FND_API.G_MISS_CHAR),

1179: NVL(attribute4, FND_API.G_MISS_CHAR),
1180: NVL(attribute5, FND_API.G_MISS_CHAR),
1181: NVL(attribute6, FND_API.G_MISS_CHAR),
1182: NVL(attribute7, FND_API.G_MISS_CHAR),
1183: NVL(attribute8, FND_API.G_MISS_CHAR),
1184: NVL(attribute9, FND_API.G_MISS_CHAR),
1185: NVL(attribute10, FND_API.G_MISS_CHAR),
1186: NVL(attribute11, FND_API.G_MISS_CHAR),
1187: NVL(attribute12, FND_API.G_MISS_CHAR),

Line 1184: NVL(attribute9, FND_API.G_MISS_CHAR),

1180: NVL(attribute5, FND_API.G_MISS_CHAR),
1181: NVL(attribute6, FND_API.G_MISS_CHAR),
1182: NVL(attribute7, FND_API.G_MISS_CHAR),
1183: NVL(attribute8, FND_API.G_MISS_CHAR),
1184: NVL(attribute9, FND_API.G_MISS_CHAR),
1185: NVL(attribute10, FND_API.G_MISS_CHAR),
1186: NVL(attribute11, FND_API.G_MISS_CHAR),
1187: NVL(attribute12, FND_API.G_MISS_CHAR),
1188: NVL(attribute13, FND_API.G_MISS_CHAR),

Line 1185: NVL(attribute10, FND_API.G_MISS_CHAR),

1181: NVL(attribute6, FND_API.G_MISS_CHAR),
1182: NVL(attribute7, FND_API.G_MISS_CHAR),
1183: NVL(attribute8, FND_API.G_MISS_CHAR),
1184: NVL(attribute9, FND_API.G_MISS_CHAR),
1185: NVL(attribute10, FND_API.G_MISS_CHAR),
1186: NVL(attribute11, FND_API.G_MISS_CHAR),
1187: NVL(attribute12, FND_API.G_MISS_CHAR),
1188: NVL(attribute13, FND_API.G_MISS_CHAR),
1189: NVL(attribute14, FND_API.G_MISS_CHAR),

Line 1186: NVL(attribute11, FND_API.G_MISS_CHAR),

1182: NVL(attribute7, FND_API.G_MISS_CHAR),
1183: NVL(attribute8, FND_API.G_MISS_CHAR),
1184: NVL(attribute9, FND_API.G_MISS_CHAR),
1185: NVL(attribute10, FND_API.G_MISS_CHAR),
1186: NVL(attribute11, FND_API.G_MISS_CHAR),
1187: NVL(attribute12, FND_API.G_MISS_CHAR),
1188: NVL(attribute13, FND_API.G_MISS_CHAR),
1189: NVL(attribute14, FND_API.G_MISS_CHAR),
1190: NVL(attribute15, FND_API.G_MISS_CHAR),

Line 1187: NVL(attribute12, FND_API.G_MISS_CHAR),

1183: NVL(attribute8, FND_API.G_MISS_CHAR),
1184: NVL(attribute9, FND_API.G_MISS_CHAR),
1185: NVL(attribute10, FND_API.G_MISS_CHAR),
1186: NVL(attribute11, FND_API.G_MISS_CHAR),
1187: NVL(attribute12, FND_API.G_MISS_CHAR),
1188: NVL(attribute13, FND_API.G_MISS_CHAR),
1189: NVL(attribute14, FND_API.G_MISS_CHAR),
1190: NVL(attribute15, FND_API.G_MISS_CHAR),
1191: NVL(attribute16, FND_API.G_MISS_CHAR),

Line 1188: NVL(attribute13, FND_API.G_MISS_CHAR),

1184: NVL(attribute9, FND_API.G_MISS_CHAR),
1185: NVL(attribute10, FND_API.G_MISS_CHAR),
1186: NVL(attribute11, FND_API.G_MISS_CHAR),
1187: NVL(attribute12, FND_API.G_MISS_CHAR),
1188: NVL(attribute13, FND_API.G_MISS_CHAR),
1189: NVL(attribute14, FND_API.G_MISS_CHAR),
1190: NVL(attribute15, FND_API.G_MISS_CHAR),
1191: NVL(attribute16, FND_API.G_MISS_CHAR),
1192: NVL(attribute17, FND_API.G_MISS_CHAR),

Line 1189: NVL(attribute14, FND_API.G_MISS_CHAR),

1185: NVL(attribute10, FND_API.G_MISS_CHAR),
1186: NVL(attribute11, FND_API.G_MISS_CHAR),
1187: NVL(attribute12, FND_API.G_MISS_CHAR),
1188: NVL(attribute13, FND_API.G_MISS_CHAR),
1189: NVL(attribute14, FND_API.G_MISS_CHAR),
1190: NVL(attribute15, FND_API.G_MISS_CHAR),
1191: NVL(attribute16, FND_API.G_MISS_CHAR),
1192: NVL(attribute17, FND_API.G_MISS_CHAR),
1193: NVL(attribute18, FND_API.G_MISS_CHAR),

Line 1190: NVL(attribute15, FND_API.G_MISS_CHAR),

1186: NVL(attribute11, FND_API.G_MISS_CHAR),
1187: NVL(attribute12, FND_API.G_MISS_CHAR),
1188: NVL(attribute13, FND_API.G_MISS_CHAR),
1189: NVL(attribute14, FND_API.G_MISS_CHAR),
1190: NVL(attribute15, FND_API.G_MISS_CHAR),
1191: NVL(attribute16, FND_API.G_MISS_CHAR),
1192: NVL(attribute17, FND_API.G_MISS_CHAR),
1193: NVL(attribute18, FND_API.G_MISS_CHAR),
1194: NVL(attribute19, FND_API.G_MISS_CHAR),

Line 1191: NVL(attribute16, FND_API.G_MISS_CHAR),

1187: NVL(attribute12, FND_API.G_MISS_CHAR),
1188: NVL(attribute13, FND_API.G_MISS_CHAR),
1189: NVL(attribute14, FND_API.G_MISS_CHAR),
1190: NVL(attribute15, FND_API.G_MISS_CHAR),
1191: NVL(attribute16, FND_API.G_MISS_CHAR),
1192: NVL(attribute17, FND_API.G_MISS_CHAR),
1193: NVL(attribute18, FND_API.G_MISS_CHAR),
1194: NVL(attribute19, FND_API.G_MISS_CHAR),
1195: NVL(attribute20, FND_API.G_MISS_CHAR)

Line 1192: NVL(attribute17, FND_API.G_MISS_CHAR),

1188: NVL(attribute13, FND_API.G_MISS_CHAR),
1189: NVL(attribute14, FND_API.G_MISS_CHAR),
1190: NVL(attribute15, FND_API.G_MISS_CHAR),
1191: NVL(attribute16, FND_API.G_MISS_CHAR),
1192: NVL(attribute17, FND_API.G_MISS_CHAR),
1193: NVL(attribute18, FND_API.G_MISS_CHAR),
1194: NVL(attribute19, FND_API.G_MISS_CHAR),
1195: NVL(attribute20, FND_API.G_MISS_CHAR)
1196: INTO

Line 1193: NVL(attribute18, FND_API.G_MISS_CHAR),

1189: NVL(attribute14, FND_API.G_MISS_CHAR),
1190: NVL(attribute15, FND_API.G_MISS_CHAR),
1191: NVL(attribute16, FND_API.G_MISS_CHAR),
1192: NVL(attribute17, FND_API.G_MISS_CHAR),
1193: NVL(attribute18, FND_API.G_MISS_CHAR),
1194: NVL(attribute19, FND_API.G_MISS_CHAR),
1195: NVL(attribute20, FND_API.G_MISS_CHAR)
1196: INTO
1197: x_geography_id,

Line 1194: NVL(attribute19, FND_API.G_MISS_CHAR),

1190: NVL(attribute15, FND_API.G_MISS_CHAR),
1191: NVL(attribute16, FND_API.G_MISS_CHAR),
1192: NVL(attribute17, FND_API.G_MISS_CHAR),
1193: NVL(attribute18, FND_API.G_MISS_CHAR),
1194: NVL(attribute19, FND_API.G_MISS_CHAR),
1195: NVL(attribute20, FND_API.G_MISS_CHAR)
1196: INTO
1197: x_geography_id,
1198: x_geography_type,

Line 1195: NVL(attribute20, FND_API.G_MISS_CHAR)

1191: NVL(attribute16, FND_API.G_MISS_CHAR),
1192: NVL(attribute17, FND_API.G_MISS_CHAR),
1193: NVL(attribute18, FND_API.G_MISS_CHAR),
1194: NVL(attribute19, FND_API.G_MISS_CHAR),
1195: NVL(attribute20, FND_API.G_MISS_CHAR)
1196: INTO
1197: x_geography_id,
1198: x_geography_type,
1199: x_geography_name,

Line 1266: RAISE FND_API.G_EXC_ERROR;

1262: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1263: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_geography_rec');
1264: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
1265: FND_MSG_PUB.ADD;
1266: RAISE FND_API.G_EXC_ERROR;
1267:
1268: END Select_Row;
1269:
1270: PROCEDURE Delete_Row (

Line 1344: RAISE FND_API.G_EXC_ERROR;

1340: WHEN NO_DATA_FOUND THEN
1341: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1342: fnd_message.set_token('COLUMN', 'geography_element_column,country_code');
1343: l_err_message := FND_MESSAGE.GET;
1344: RAISE FND_API.G_EXC_ERROR;
1345: END;
1346:
1347: ELSIF l_geography_type = 'COUNTRY' THEN
1348: l_geo_element_col:= 'GEOGRAPHY_ELEMENT1';

Line 1391: WHEN FND_API.G_EXC_ERROR THEN

1387: END IF;
1388: END IF;
1389:
1390: EXCEPTION
1391: WHEN FND_API.G_EXC_ERROR THEN
1392: fnd_file.put_line(fnd_file.log,l_err_message);
1393: retcode := '2'; -- Error
1394: errbuf := l_err_message;
1395: WHEN OTHERS THEN