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_STYLE_FMT_LOCALE_V2PUB SQL Statements

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

Line: 23


  PROCEDURE do_update_style_fmt_locale(
    p_style_fmt_locale_rec           IN OUT  NOCOPY style_fmt_locale_rec_type,
    p_object_version_number      IN OUT NOCOPY  NUMBER,
    x_return_status              IN OUT NOCOPY  VARCHAR2
  );

Line: 138


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

Line: 143


    HZ_STYLE_FMT_LOCALES_PKG.insert_row (
      X_ROWID                 => l_rowid,
      X_STYLE_FMT_LOCALE_ID   => p_style_fmt_locale_rec.style_fmt_locale_id,
      X_STYLE_FORMAT_CODE     => p_style_fmt_locale_rec.style_format_code,
      X_LANGUAGE_CODE         => p_style_fmt_locale_rec.language_code,
      X_TERRITORY_CODE        => p_style_fmt_locale_rec.territory_code,
      X_START_DATE_ACTIVE     => p_style_fmt_locale_rec.start_date_active,
      X_END_DATE_ACTIVE       => p_style_fmt_locale_rec.end_date_active,
      X_OBJECT_VERSION_NUMBER => 1
    );

Line: 156


	hz_utility_v2pub.debug(p_message=>'hz_style_fmt_locales_pkg.insert_row (-) ' ||
                                 'p_style_fmt_locale_rec.style_fmt_locale_id = ' || p_style_fmt_locale_rec.style_fmt_locale_id,
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 169


   * PRIVATE PROCEDURE do_update_style_fmt_locale
   *
   * DESCRIPTION
   *     update style format locale

   *   07-23-2001    Kate Shan      o Created.
   *
   */


  PROCEDURE do_update_style_fmt_locale(
    p_style_fmt_locale_rec           IN OUT  NOCOPY style_fmt_locale_rec_type,
    p_object_version_number      IN OUT NOCOPY  NUMBER,
    x_return_status              IN OUT NOCOPY  VARCHAR2
  ) IS
    l_object_version_number NUMBER;

Line: 192


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

Line: 200


        SELECT object_version_number, rowid
        INTO l_object_version_number, l_rowid
        FROM HZ_STYLE_FMT_LOCALES
        WHERE style_fmt_locale_id = p_style_fmt_locale_rec.style_fmt_locale_id
        FOR UPDATE of  style_fmt_locale_id NOWAIT;

Line: 241


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

Line: 247


    HZ_STYLE_FMT_LOCALES_PKG.Update_Row (
      X_STYLE_FMT_LOCALE_ID  => p_style_fmt_locale_rec.style_fmt_locale_id,
      X_STYLE_FORMAT_CODE    => p_style_fmt_locale_rec.style_format_code,
      X_LANGUAGE_CODE        => p_style_fmt_locale_rec.language_code,
      X_TERRITORY_CODE       => p_style_fmt_locale_rec.territory_code,
      X_START_DATE_ACTIVE    => p_style_fmt_locale_rec.start_date_active,
      X_END_DATE_ACTIVE      => p_style_fmt_locale_rec.end_date_active,
      X_OBJECT_VERSION_NUMBER=> p_object_version_number
    );

Line: 259


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

Line: 266


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

Line: 271


END do_update_style_fmt_locale;

Line: 454


 * PROCEDURE update_style_fmt_locale
 *
 * DESCRIPTION
 *     Updates style_fmt_locale.
 *
 * 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_style_fmt_locale_rec         Style format locale 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
 *
 *   17-Jul-2002    Kate Shan        o Created.
 *
 */

PROCEDURE update_style_fmt_locale (
    p_init_msg_list         IN         VARCHAR2 :=FND_API.G_FALSE,
    p_style_fmt_locale_rec  IN         STYLE_FMT_LOCALE_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_style_fmt_locale_rec           STYLE_FMT_LOCALE_REC_TYPE := p_style_fmt_locale_rec;

Line: 500


    SAVEPOINT update_style_fmt_locale;

Line: 507


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

Line: 521


    do_update_style_fmt_locale(
                       l_style_fmt_locale_rec,
                       p_object_version_number,
                       x_return_status);

Line: 540


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

Line: 550


        ROLLBACK TO update_style_fmt_locale;

Line: 565


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

Line: 574


        ROLLBACK TO update_style_fmt_locale;

Line: 589


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

Line: 598


        ROLLBACK TO update_style_fmt_locale;

Line: 618


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

Line: 627


END update_style_fmt_locale;

Line: 702


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

Line: 707


    hz_style_fmt_locales_pkg.select_row (
      X_STYLE_FMT_LOCALE_ID => x_style_fmt_locale_rec.style_fmt_locale_id,
      X_STYLE_FORMAT_CODE   => x_style_fmt_locale_rec.style_format_code,
      X_LANGUAGE_CODE 	    => x_style_fmt_locale_rec.language_code,
      X_TERRITORY_CODE	    => x_style_fmt_locale_rec.territory_code,
      X_START_DATE_ACTIVE   => x_style_fmt_locale_rec.start_date_active,
      X_END_DATE_ACTIVE	    => x_style_fmt_locale_rec.end_date_active
    );

Line: 718


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