APPS.HZ_STYLE_V2PUB SQL Statements

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

Line: 24

  PROCEDURE do_update_style(
    p_style_rec                  IN OUT  NOCOPY style_rec_type,
    p_object_version_number      IN OUT NOCOPY  NUMBER,
    x_return_status              IN OUT NOCOPY  VARCHAR2
  );

Line: 132

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

Line: 137

    hz_styles_pkg.insert_row (
      X_ROWID                 => l_rowid,
      X_STYLE_CODE            => p_style_rec.style_code,
      X_DATABASE_OBJECT_NAME  => p_style_rec.database_object_name,
      X_STYLE_NAME            => p_style_rec.style_name,
      X_DESCRIPTION           => p_style_rec.description,
      x_object_version_number => 1
    );

Line: 148

	hz_utility_v2pub.debug(p_message=>'hz_styles_pkg.insert_row (-) ' ||
                                 'p_style_rec.style_code = ' || p_style_rec.style_code,
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 156

   * PRIVATE PROCEDURE do_update_style
   *
   * DESCRIPTION
   *     update style

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


  PROCEDURE do_update_style(
    p_style_rec                  IN OUT  NOCOPY style_rec_type,
    p_object_version_number      IN OUT NOCOPY  NUMBER,
    x_return_status              IN OUT NOCOPY  VARCHAR2
  ) IS
    l_object_version_number NUMBER;

Line: 179

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

Line: 187

        SELECT object_version_number, rowid
        INTO l_object_version_number, l_rowid
        FROM HZ_STYLES_B
        WHERE style_code = p_style_rec.style_code
        FOR UPDATE of  style_code NOWAIT;

Line: 228

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

Line: 234

    HZ_STYLES_PKG.Update_Row (
      x_style_code            => p_style_rec.style_code,
      x_database_object_name  => p_style_rec.database_object_name,
      x_style_name            => p_style_rec.style_name,
      x_description           => p_style_rec.description,
      x_object_version_number => p_object_version_number
    );

Line: 244

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

Line: 251

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

Line: 256

END do_update_style;

Line: 434

 * PROCEDURE update_style
 *
 * DESCRIPTION
 *     Updates style.
 *
 * 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_rec                 Style 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 (
    p_init_msg_list         IN         VARCHAR2 :=FND_API.G_FALSE,
    p_style_rec             IN         STYLE_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_rec           STYLE_REC_TYPE := p_style_rec;

Line: 480

    SAVEPOINT update_style;

Line: 487

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

Line: 501

    do_update_style(
                       l_style_rec,
                       p_object_version_number,
                       x_return_status);

Line: 520

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

Line: 530

        ROLLBACK TO update_style;

Line: 545

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

Line: 554

        ROLLBACK TO update_style;

Line: 569

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

Line: 578

        ROLLBACK TO update_style;

Line: 598

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

Line: 607

END update_style;

Line: 681

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

Line: 686

    hz_styles_pkg.select_row (
      x_style_code            => x_style_rec.style_code,
      x_database_object_name  => x_style_rec.database_object_name,
      x_style_name            => x_style_rec.style_name,
      x_description           => x_style_rec.description
    );

Line: 695

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