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,
264: hz_utility_v2pub.last_update_date,
265: hz_utility_v2pub.last_update_login,
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,
264: hz_utility_v2pub.last_update_date,
265: hz_utility_v2pub.last_update_login,
266: DECODE(x_application_id,
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,
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,
260: x_timezone_code),
261: hz_utility_v2pub.last_updated_by,
262: hz_utility_v2pub.creation_date,
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),
261: hz_utility_v2pub.last_updated_by,
262: hz_utility_v2pub.creation_date,
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,
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,
272: x_program_login_id),
273: hz_utility_v2pub.program_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,
276: FND_API.G_MISS_CHAR, NULL,
277: x_attribute_category),
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,
276: FND_API.G_MISS_CHAR, NULL,
277: x_attribute_category),
278: DECODE(x_attribute1,
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,
635: last_update_date = hz_utility_v2pub.last_update_date,
636: last_update_login = hz_utility_v2pub.last_update_login,
631: x_timezone_code),
632: last_updated_by = hz_utility_v2pub.last_updated_by,
633: creation_date = creation_date,
634: created_by = created_by,
635: last_update_date = hz_utility_v2pub.last_update_date,
636: last_update_login = hz_utility_v2pub.last_update_login,
637: application_id =
638: DECODE(x_application_id,
639: NULL, application_id,
632: last_updated_by = hz_utility_v2pub.last_updated_by,
633: creation_date = creation_date,
634: created_by = created_by,
635: last_update_date = hz_utility_v2pub.last_update_date,
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,
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,
645: NULL, program_login_id,
646: FND_API.G_MISS_NUM, NULL,
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 =
651: DECODE(x_attribute_category,
652: NULL, attribute_category,
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 =
651: DECODE(x_attribute_category,
652: NULL, attribute_category,
653: FND_API.G_MISS_CHAR, NULL,