238: program_update_date = p_program_update_date,
239: location_id =
240: DECODE (p_location_id,
241: NULL, location_id,
242: fnd_api.g_miss_char, NULL,
243: p_location_id
244: ),
245: override_flag =
246: DECODE (p_override_flag,
244: ),
245: override_flag =
246: DECODE (p_override_flag,
247: NULL, override_flag,
248: fnd_api.g_miss_char, NULL,
249: p_override_flag
250: ),
251: validated_flag =
252: DECODE (p_validated_flag,
250: ),
251: validated_flag =
252: DECODE (p_validated_flag,
253: NULL, validated_flag,
254: fnd_api.g_miss_char, NULL,
255: p_validated_flag
256: ),
257: log_detail_short =
258: DECODE (p_log_detail_short,
256: ),
257: log_detail_short =
258: DECODE (p_log_detail_short,
259: NULL, log_detail_short,
260: fnd_api.g_miss_char, NULL,
261: p_log_detail_short
262: ),
263: log_detail_long =
264: DECODE (p_log_detail_long,
262: ),
263: log_detail_long =
264: DECODE (p_log_detail_long,
265: NULL, log_detail_long,
266: fnd_api.g_miss_char, NULL,
267: p_log_detail_long
268: )
269: WHERE location_id = p_location_id;
270:
308: program_update_date = p_program_update_date,
309: address1 =
310: DECODE (p_address1,
311: NULL, address1,
312: fnd_api.g_miss_char, NULL,
313: p_address1
314: ),
315: address2 = p_address2,
316: address3 = p_address3,
323: country = p_country,
324: validated_flag =
325: DECODE (p_validated_flag,
326: NULL, validated_flag,
327: fnd_api.g_miss_char, NULL,
328: p_validated_flag
329: ),
330: timezone_id =
331: DECODE (p_timezone_id,
329: ),
330: timezone_id =
331: DECODE (p_timezone_id,
332: NULL, timezone_id,
333: fnd_api.g_miss_num, NULL,
334: p_timezone_id)
335: WHERE location_id = p_location_id;
336:
337: IF (SQL%NOTFOUND)