eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CONTACT_PREFERENCE_V2PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26


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
);

Line: 170


	hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Insert_Row (+) ',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 176


    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
    );

Line: 204


	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);

Line: 225


*               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';

Line: 274


	hz_utility_v2pub.debug(p_message=>'do_update_contact_preference (+)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 282


        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;

Line: 331


	hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (+)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 337


    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
    );

Line: 365


	hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 372


	hz_utility_v2pub.debug(p_message=>'do_update_contact_preference (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 377


END do_update_contact_preference;

Line: 572


 * 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;

Line: 618


    SAVEPOINT update_contact_preference_pub;

Line: 625


	hz_utility_v2pub.debug(p_message=>'update_contact_preference (+)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 653


    do_update_contact_preference(
        l_contact_preference_rec,
        p_object_version_number,
        x_return_status);

Line: 661


       HZ_BUSINESS_EVENT_V2PVT.update_contact_prefer_event (
         l_contact_preference_rec , l_old_contact_preference_rec  );

Line: 686


	hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 696


        ROLLBACK TO update_contact_preference_pub;

Line: 711


	    hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 720


        ROLLBACK TO update_contact_preference_pub;

Line: 735


	   hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 744


        ROLLBACK TO update_contact_preference_pub;

Line: 762


	    hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 770


END update_contact_preference;

Line: 844


	hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (+)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 849


    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
    );

Line: 874


	hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);