73: DECODE(x_default_batch_size,
74: fnd_api.g_miss_num, NULL, x_default_batch_size),
75: DECODE(x_default_replace_status_level,
76: fnd_api.g_miss_char, NULL, x_default_replace_status_level),
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,
81: hz_utility_v2pub.last_update_login,
74: fnd_api.g_miss_num, NULL, x_default_batch_size),
75: DECODE(x_default_replace_status_level,
76: fnd_api.g_miss_char, NULL, x_default_replace_status_level),
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,
81: hz_utility_v2pub.last_update_login,
82: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number)
75: DECODE(x_default_replace_status_level,
76: fnd_api.g_miss_char, NULL, x_default_replace_status_level),
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,
81: hz_utility_v2pub.last_update_login,
82: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number)
83: ) RETURNING
76: fnd_api.g_miss_char, NULL, x_default_replace_status_level),
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,
81: hz_utility_v2pub.last_update_login,
82: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number)
83: ) RETURNING
84: adapter_id
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,
81: hz_utility_v2pub.last_update_login,
82: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number)
83: ) RETURNING
84: adapter_id
85: INTO
164: default_replace_status_level = DECODE(x_default_replace_status_level,
165: NULL, default_replace_status_level,
166: fnd_api.g_miss_char,
167: NULL, x_default_replace_status_level),
168: last_update_date = hz_utility_v2pub.last_update_date,
169: last_updated_by = hz_utility_v2pub.last_updated_by,
170: creation_date = creation_date,
171: created_by = created_by,
172: last_update_login = hz_utility_v2pub.last_update_login,
165: NULL, default_replace_status_level,
166: fnd_api.g_miss_char,
167: NULL, x_default_replace_status_level),
168: last_update_date = hz_utility_v2pub.last_update_date,
169: last_updated_by = hz_utility_v2pub.last_updated_by,
170: creation_date = creation_date,
171: created_by = created_by,
172: last_update_login = hz_utility_v2pub.last_update_login,
173: object_version_number = DECODE(x_object_version_number,
168: last_update_date = hz_utility_v2pub.last_update_date,
169: last_updated_by = hz_utility_v2pub.last_updated_by,
170: creation_date = creation_date,
171: created_by = created_by,
172: last_update_login = hz_utility_v2pub.last_update_login,
173: object_version_number = DECODE(x_object_version_number,
174: NULL, object_version_number,
175: fnd_api.g_miss_num, NULL,
176: x_object_version_number)