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,
187: hz_utility_v2pub.creation_date,
188: hz_utility_v2pub.created_by,
189: hz_utility_v2pub.last_update_login,
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,
187: hz_utility_v2pub.creation_date,
188: hz_utility_v2pub.created_by,
189: hz_utility_v2pub.last_update_login,
190: hz_utility_v2pub.request_id,
183: NULL, hr_locations_s.NEXTVAL,
184: x_location_id),
185: hz_utility_v2pub.last_update_date,
186: hz_utility_v2pub.last_updated_by,
187: hz_utility_v2pub.creation_date,
188: hz_utility_v2pub.created_by,
189: hz_utility_v2pub.last_update_login,
190: hz_utility_v2pub.request_id,
191: hz_utility_v2pub.program_application_id,
184: x_location_id),
185: hz_utility_v2pub.last_update_date,
186: hz_utility_v2pub.last_updated_by,
187: hz_utility_v2pub.creation_date,
188: hz_utility_v2pub.created_by,
189: hz_utility_v2pub.last_update_login,
190: hz_utility_v2pub.request_id,
191: hz_utility_v2pub.program_application_id,
192: hz_utility_v2pub.program_id,
185: hz_utility_v2pub.last_update_date,
186: hz_utility_v2pub.last_updated_by,
187: hz_utility_v2pub.creation_date,
188: hz_utility_v2pub.created_by,
189: hz_utility_v2pub.last_update_login,
190: hz_utility_v2pub.request_id,
191: hz_utility_v2pub.program_application_id,
192: hz_utility_v2pub.program_id,
193: hz_utility_v2pub.program_update_date,
186: hz_utility_v2pub.last_updated_by,
187: hz_utility_v2pub.creation_date,
188: hz_utility_v2pub.created_by,
189: hz_utility_v2pub.last_update_login,
190: hz_utility_v2pub.request_id,
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,
187: hz_utility_v2pub.creation_date,
188: hz_utility_v2pub.created_by,
189: hz_utility_v2pub.last_update_login,
190: hz_utility_v2pub.request_id,
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,
188: hz_utility_v2pub.created_by,
189: hz_utility_v2pub.last_update_login,
190: hz_utility_v2pub.request_id,
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),
189: hz_utility_v2pub.last_update_login,
190: hz_utility_v2pub.request_id,
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),
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,
424: created_by = created_by,
425: last_update_login = hz_utility_v2pub.last_update_login,
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,
424: created_by = created_by,
425: last_update_login = hz_utility_v2pub.last_update_login,
426: request_id = hz_utility_v2pub.request_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,
424: created_by = created_by,
425: last_update_login = hz_utility_v2pub.last_update_login,
426: request_id = hz_utility_v2pub.request_id,
427: program_application_id = hz_utility_v2pub.program_application_id,
428: program_id = hz_utility_v2pub.program_id,
429: program_update_date = hz_utility_v2pub.program_update_date,
422: last_updated_by = hz_utility_v2pub.last_updated_by,
423: creation_date = creation_date,
424: created_by = created_by,
425: last_update_login = hz_utility_v2pub.last_update_login,
426: request_id = hz_utility_v2pub.request_id,
427: program_application_id = hz_utility_v2pub.program_application_id,
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,
423: creation_date = creation_date,
424: created_by = created_by,
425: last_update_login = hz_utility_v2pub.last_update_login,
426: request_id = hz_utility_v2pub.request_id,
427: program_application_id = hz_utility_v2pub.program_application_id,
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,
424: created_by = created_by,
425: last_update_login = hz_utility_v2pub.last_update_login,
426: request_id = hz_utility_v2pub.request_id,
427: program_application_id = hz_utility_v2pub.program_application_id,
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,
425: last_update_login = hz_utility_v2pub.last_update_login,
426: request_id = hz_utility_v2pub.request_id,
427: program_application_id = hz_utility_v2pub.program_application_id,
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),