185: hz_contact_points_s.CURRVAL)),
186: NULL, TO_CHAR(NVL(x_contact_point_id,
187: hz_contact_points_s.CURRVAL)),
188: x_orig_system_reference),
189: hz_utility_v2pub.last_update_date,
190: hz_utility_v2pub.last_updated_by,
191: hz_utility_v2pub.creation_date,
192: hz_utility_v2pub.created_by,
193: hz_utility_v2pub.last_update_login,
186: NULL, TO_CHAR(NVL(x_contact_point_id,
187: hz_contact_points_s.CURRVAL)),
188: x_orig_system_reference),
189: hz_utility_v2pub.last_update_date,
190: hz_utility_v2pub.last_updated_by,
191: hz_utility_v2pub.creation_date,
192: hz_utility_v2pub.created_by,
193: hz_utility_v2pub.last_update_login,
194: hz_utility_v2pub.request_id,
187: hz_contact_points_s.CURRVAL)),
188: x_orig_system_reference),
189: hz_utility_v2pub.last_update_date,
190: hz_utility_v2pub.last_updated_by,
191: hz_utility_v2pub.creation_date,
192: hz_utility_v2pub.created_by,
193: hz_utility_v2pub.last_update_login,
194: hz_utility_v2pub.request_id,
195: hz_utility_v2pub.program_application_id,
188: x_orig_system_reference),
189: hz_utility_v2pub.last_update_date,
190: hz_utility_v2pub.last_updated_by,
191: hz_utility_v2pub.creation_date,
192: hz_utility_v2pub.created_by,
193: hz_utility_v2pub.last_update_login,
194: hz_utility_v2pub.request_id,
195: hz_utility_v2pub.program_application_id,
196: hz_utility_v2pub.program_id,
189: hz_utility_v2pub.last_update_date,
190: hz_utility_v2pub.last_updated_by,
191: hz_utility_v2pub.creation_date,
192: hz_utility_v2pub.created_by,
193: hz_utility_v2pub.last_update_login,
194: hz_utility_v2pub.request_id,
195: hz_utility_v2pub.program_application_id,
196: hz_utility_v2pub.program_id,
197: hz_utility_v2pub.program_update_date,
190: hz_utility_v2pub.last_updated_by,
191: hz_utility_v2pub.creation_date,
192: hz_utility_v2pub.created_by,
193: hz_utility_v2pub.last_update_login,
194: hz_utility_v2pub.request_id,
195: hz_utility_v2pub.program_application_id,
196: hz_utility_v2pub.program_id,
197: hz_utility_v2pub.program_update_date,
198: DECODE(x_attribute_category,
191: hz_utility_v2pub.creation_date,
192: hz_utility_v2pub.created_by,
193: hz_utility_v2pub.last_update_login,
194: hz_utility_v2pub.request_id,
195: hz_utility_v2pub.program_application_id,
196: hz_utility_v2pub.program_id,
197: hz_utility_v2pub.program_update_date,
198: DECODE(x_attribute_category,
199: fnd_api.g_miss_char, NULL, x_attribute_category),
192: hz_utility_v2pub.created_by,
193: hz_utility_v2pub.last_update_login,
194: hz_utility_v2pub.request_id,
195: hz_utility_v2pub.program_application_id,
196: hz_utility_v2pub.program_id,
197: hz_utility_v2pub.program_update_date,
198: DECODE(x_attribute_category,
199: fnd_api.g_miss_char, NULL, x_attribute_category),
200: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
193: hz_utility_v2pub.last_update_login,
194: hz_utility_v2pub.request_id,
195: hz_utility_v2pub.program_application_id,
196: hz_utility_v2pub.program_id,
197: hz_utility_v2pub.program_update_date,
198: DECODE(x_attribute_category,
199: fnd_api.g_miss_char, NULL, x_attribute_category),
200: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
201: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
448: NULL, orig_system_reference,
449: fnd_api.g_miss_char,
450: TO_CHAR(x_contact_point_id),
451: x_orig_system_reference),
452: last_update_date = hz_utility_v2pub.last_update_date,
453: last_updated_by = hz_utility_v2pub.last_updated_by,
454: creation_date = creation_date,
455: created_by = created_by,
456: last_update_login = hz_utility_v2pub.last_update_login,
449: fnd_api.g_miss_char,
450: TO_CHAR(x_contact_point_id),
451: x_orig_system_reference),
452: last_update_date = hz_utility_v2pub.last_update_date,
453: last_updated_by = hz_utility_v2pub.last_updated_by,
454: creation_date = creation_date,
455: created_by = created_by,
456: last_update_login = hz_utility_v2pub.last_update_login,
457: request_id = hz_utility_v2pub.request_id,
452: last_update_date = hz_utility_v2pub.last_update_date,
453: last_updated_by = hz_utility_v2pub.last_updated_by,
454: creation_date = creation_date,
455: created_by = created_by,
456: last_update_login = hz_utility_v2pub.last_update_login,
457: request_id = hz_utility_v2pub.request_id,
458: program_application_id = hz_utility_v2pub.program_application_id,
459: program_id = hz_utility_v2pub.program_id,
460: program_update_date = hz_utility_v2pub.program_update_date,
453: last_updated_by = hz_utility_v2pub.last_updated_by,
454: creation_date = creation_date,
455: created_by = created_by,
456: last_update_login = hz_utility_v2pub.last_update_login,
457: request_id = hz_utility_v2pub.request_id,
458: program_application_id = hz_utility_v2pub.program_application_id,
459: program_id = hz_utility_v2pub.program_id,
460: program_update_date = hz_utility_v2pub.program_update_date,
461: attribute_category = DECODE(x_attribute_category,
454: creation_date = creation_date,
455: created_by = created_by,
456: last_update_login = hz_utility_v2pub.last_update_login,
457: request_id = hz_utility_v2pub.request_id,
458: program_application_id = hz_utility_v2pub.program_application_id,
459: program_id = hz_utility_v2pub.program_id,
460: program_update_date = hz_utility_v2pub.program_update_date,
461: attribute_category = DECODE(x_attribute_category,
462: NULL, attribute_category,
455: created_by = created_by,
456: last_update_login = hz_utility_v2pub.last_update_login,
457: request_id = hz_utility_v2pub.request_id,
458: program_application_id = hz_utility_v2pub.program_application_id,
459: program_id = hz_utility_v2pub.program_id,
460: program_update_date = hz_utility_v2pub.program_update_date,
461: attribute_category = DECODE(x_attribute_category,
462: NULL, attribute_category,
463: fnd_api.g_miss_char, NULL,
456: last_update_login = hz_utility_v2pub.last_update_login,
457: request_id = hz_utility_v2pub.request_id,
458: program_application_id = hz_utility_v2pub.program_application_id,
459: program_id = hz_utility_v2pub.program_id,
460: program_update_date = hz_utility_v2pub.program_update_date,
461: attribute_category = DECODE(x_attribute_category,
462: NULL, attribute_category,
463: fnd_api.g_miss_char, NULL,
464: x_attribute_category),