The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE do_update_contact_preference(
p_contact_preference_rec IN OUT NOCOPY CONTACT_PREFERENCE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
);
hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Insert_Row (+) ',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CONTACT_PREFERENCES_PKG.Insert_Row (
X_Rowid => l_rowid,
X_CONTACT_PREFERENCE_ID => p_contact_preference_rec.contact_preference_id,
X_CONTACT_LEVEL_TABLE => p_contact_preference_rec.contact_level_table,
X_CONTACT_LEVEL_TABLE_ID => p_contact_preference_rec.contact_level_table_id,
X_CONTACT_TYPE => p_contact_preference_rec.contact_type,
X_PREFERENCE_CODE => p_contact_preference_rec.preference_code,
X_PREFERENCE_TOPIC_TYPE => p_contact_preference_rec.preference_topic_type,
X_PREFERENCE_TOPIC_TYPE_ID => p_contact_preference_rec.preference_topic_type_id,
X_PREFERENCE_TOPIC_TYPE_CODE => p_contact_preference_rec.preference_topic_type_code,
X_PREFERENCE_START_DATE => p_contact_preference_rec.preference_start_date,
X_PREFERENCE_END_DATE => p_contact_preference_rec.preference_end_date,
X_PREFERENCE_START_TIME_HR => p_contact_preference_rec.preference_start_time_hr,
X_PREFERENCE_END_TIME_HR => p_contact_preference_rec.preference_end_time_hr,
X_PREFERENCE_START_TIME_MI => p_contact_preference_rec.preference_start_time_mi,
X_PREFERENCE_END_TIME_MI => p_contact_preference_rec.preference_end_time_mi,
X_MAX_NO_OF_INTERACTIONS => p_contact_preference_rec.max_no_of_interactions,
X_MAX_NO_OF_INTERACT_UOM_CODE => p_contact_preference_rec.max_no_of_interact_uom_code,
X_REQUESTED_BY => p_contact_preference_rec.requested_by,
X_REASON_CODE => p_contact_preference_rec.reason_code,
X_STATUS => p_contact_preference_rec.status,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_contact_preference_rec.created_by_module,
X_APPLICATION_ID => p_contact_preference_rec.application_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Insert_Row (-) ' ||
'x_contact_preference_id = ' || p_contact_preference_rec.contact_preference_id,
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
* do_update_contact_preference_
*
* DESCRIPTION
* Private procedure to update contact preference
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
* HZ_REGRISTRY_VALIDATE_V2PUB.validate_contact_preference
* HZ_CONTACT_PREFERENCES_PKG.Update_Row
*
* SCOPE - PRIVATE
*
* EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
*
* ARGUMENTS : IN:
* OUT:
* IN/ OUT:
* p_contact_preference_rec Contact preference record
* p_object_version_number Used for locking the being updated record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
*
* RETURNS : NONE
*
* NOTES
*
* MODIFICATION HISTORY
* 07-23-2001 Kate Shan o Created.
*
*
*/
PROCEDURE do_update_contact_preference(
p_contact_preference_rec IN OUT NOCOPY CONTACT_PREFERENCE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := ''; --'do_update_contact_preference';
hz_utility_v2pub.debug(p_message=>'do_update_contact_preference (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT rowid, object_version_number
INTO l_rowid, l_object_version_number
FROM HZ_CONTACT_PREFERENCES
WHERE contact_preference_id = p_contact_preference_rec.contact_preference_id
FOR UPDATE NOWAIT;
hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CONTACT_PREFERENCES_PKG.Update_Row (
X_Rowid => l_rowid,
X_CONTACT_PREFERENCE_ID => p_contact_preference_rec.contact_preference_id,
X_CONTACT_LEVEL_TABLE => p_contact_preference_rec.contact_level_table,
X_CONTACT_LEVEL_TABLE_ID => p_contact_preference_rec.contact_level_table_id,
X_CONTACT_TYPE => p_contact_preference_rec.contact_type,
X_PREFERENCE_CODE => p_contact_preference_rec.preference_code,
X_PREFERENCE_TOPIC_TYPE => p_contact_preference_rec.preference_topic_type,
X_PREFERENCE_TOPIC_TYPE_ID => p_contact_preference_rec.preference_topic_type_id,
X_PREFERENCE_TOPIC_TYPE_CODE => p_contact_preference_rec.preference_topic_type_code,
X_PREFERENCE_START_DATE => p_contact_preference_rec.preference_start_date,
X_PREFERENCE_END_DATE => p_contact_preference_rec.preference_end_date,
X_PREFERENCE_START_TIME_HR => p_contact_preference_rec.preference_start_time_hr,
X_PREFERENCE_END_TIME_HR => p_contact_preference_rec.preference_end_time_hr,
X_PREFERENCE_START_TIME_MI => p_contact_preference_rec.preference_start_time_mi,
X_PREFERENCE_END_TIME_MI => p_contact_preference_rec.preference_end_time_mi,
X_MAX_NO_OF_INTERACTIONS => p_contact_preference_rec.max_no_of_interactions,
X_MAX_NO_OF_INTERACT_UOM_CODE => p_contact_preference_rec.max_no_of_interact_uom_code,
X_REQUESTED_BY => p_contact_preference_rec.requested_by,
X_REASON_CODE => p_contact_preference_rec.reason_code,
X_STATUS => p_contact_preference_rec.status,
X_OBJECT_VERSION_NUMBER => p_object_version_number,
X_CREATED_BY_MODULE => p_contact_preference_rec.created_by_module,
X_APPLICATION_ID => p_contact_preference_rec.application_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'do_update_contact_preference (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END do_update_contact_preference;
* PROCEDURE update_contact_preference
*
* DESCRIPTION
* Updates contact preference
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_contact_preference_rec Contact Preference record.
* IN/OUT:
* p_object_version_number Used for locking the being updated record.
* OUT:
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Kate Shan o Created.
*
*/
PROCEDURE update_contact_preference(
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_contact_preference_rec IN CONTACT_PREFERENCE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_contact_preference_rec CONTACT_PREFERENCE_REC_TYPE := p_contact_preference_rec;
SAVEPOINT update_contact_preference_pub;
hz_utility_v2pub.debug(p_message=>'update_contact_preference (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
do_update_contact_preference(
l_contact_preference_rec,
p_object_version_number,
x_return_status);
HZ_BUSINESS_EVENT_V2PVT.update_contact_prefer_event (
l_contact_preference_rec , l_old_contact_preference_rec );
hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_contact_preference_pub;
hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_contact_preference_pub;
hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_contact_preference_pub;
hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END update_contact_preference;
hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CONTACT_PREFERENCES_PKG.Select_Row (
X_CONTACT_PREFERENCE_ID => x_contact_preference_rec.contact_preference_id,
X_CONTACT_LEVEL_TABLE => x_contact_preference_rec.contact_level_table,
X_CONTACT_LEVEL_TABLE_ID => x_contact_preference_rec.contact_level_table_id,
X_CONTACT_TYPE => x_contact_preference_rec.contact_type,
X_PREFERENCE_CODE => x_contact_preference_rec.preference_code,
X_PREFERENCE_TOPIC_TYPE => x_contact_preference_rec.preference_topic_type,
X_PREFERENCE_TOPIC_TYPE_ID => x_contact_preference_rec.preference_topic_type_id,
X_PREFERENCE_TOPIC_TYPE_CODE => x_contact_preference_rec.preference_topic_type_code,
X_PREFERENCE_START_DATE => x_contact_preference_rec.preference_start_date,
X_PREFERENCE_END_DATE => x_contact_preference_rec.preference_end_date,
X_PREFERENCE_START_TIME_HR => x_contact_preference_rec.preference_start_time_hr,
X_PREFERENCE_END_TIME_HR => x_contact_preference_rec.preference_end_time_hr,
X_PREFERENCE_START_TIME_MI => x_contact_preference_rec.preference_start_time_mi,
X_PREFERENCE_END_TIME_MI => x_contact_preference_rec.preference_end_time_mi,
X_MAX_NO_OF_INTERACTIONS => x_contact_preference_rec.max_no_of_interactions,
X_MAX_NO_OF_INTERACT_UOM_CODE => x_contact_preference_rec.max_no_of_interact_uom_code,
X_REQUESTED_BY => x_contact_preference_rec.requested_by,
X_REASON_CODE => x_contact_preference_rec.reason_code,
X_STATUS => x_contact_preference_rec.status,
X_CREATED_BY_MODULE => x_contact_preference_rec.created_by_module,
X_APPLICATION_ID => x_contact_preference_rec.application_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);