19: )
20: VALUES (
21: x_condition_id,
22: x_assoc_cond_attrib_id,
23: hz_utility_v2pub.last_update_date,
24: hz_utility_v2pub.last_updated_by,
25: hz_utility_v2pub.creation_date,
26: hz_utility_v2pub.created_by,
27: hz_utility_v2pub.last_update_login,
20: VALUES (
21: x_condition_id,
22: x_assoc_cond_attrib_id,
23: hz_utility_v2pub.last_update_date,
24: hz_utility_v2pub.last_updated_by,
25: hz_utility_v2pub.creation_date,
26: hz_utility_v2pub.created_by,
27: hz_utility_v2pub.last_update_login,
28: DECODE(x_object_version_number,
21: x_condition_id,
22: x_assoc_cond_attrib_id,
23: hz_utility_v2pub.last_update_date,
24: hz_utility_v2pub.last_updated_by,
25: hz_utility_v2pub.creation_date,
26: hz_utility_v2pub.created_by,
27: hz_utility_v2pub.last_update_login,
28: DECODE(x_object_version_number,
29: FND_API.G_MISS_NUM, NULL,
22: x_assoc_cond_attrib_id,
23: hz_utility_v2pub.last_update_date,
24: hz_utility_v2pub.last_updated_by,
25: hz_utility_v2pub.creation_date,
26: hz_utility_v2pub.created_by,
27: hz_utility_v2pub.last_update_login,
28: DECODE(x_object_version_number,
29: FND_API.G_MISS_NUM, NULL,
30: x_object_version_number)
23: hz_utility_v2pub.last_update_date,
24: hz_utility_v2pub.last_updated_by,
25: hz_utility_v2pub.creation_date,
26: hz_utility_v2pub.created_by,
27: hz_utility_v2pub.last_update_login,
28: DECODE(x_object_version_number,
29: FND_API.G_MISS_NUM, NULL,
30: x_object_version_number)
31: ) ;
46:
47: UPDATE HZ_WORD_RPL_COND_ATTRIBS set
48: assoc_cond_attrib_id = x_new_cond_attrib_id,
49: object_version_number = p_object_version_number,
50: last_update_date = hz_utility_v2pub.last_update_date,
51: last_updated_by = hz_utility_v2pub.last_updated_by,
52: last_update_login = hz_utility_v2pub.last_update_login
53: where condition_id = x_condition_id and assoc_cond_attrib_id = x_assoc_cond_attrib_id ;
54:
47: UPDATE HZ_WORD_RPL_COND_ATTRIBS set
48: assoc_cond_attrib_id = x_new_cond_attrib_id,
49: object_version_number = p_object_version_number,
50: last_update_date = hz_utility_v2pub.last_update_date,
51: last_updated_by = hz_utility_v2pub.last_updated_by,
52: last_update_login = hz_utility_v2pub.last_update_login
53: where condition_id = x_condition_id and assoc_cond_attrib_id = x_assoc_cond_attrib_id ;
54:
55: if (sql%notfound) then
48: assoc_cond_attrib_id = x_new_cond_attrib_id,
49: object_version_number = p_object_version_number,
50: last_update_date = hz_utility_v2pub.last_update_date,
51: last_updated_by = hz_utility_v2pub.last_updated_by,
52: last_update_login = hz_utility_v2pub.last_update_login
53: where condition_id = x_condition_id and assoc_cond_attrib_id = x_assoc_cond_attrib_id ;
54:
55: if (sql%notfound) then
56: raise no_data_found;