DBA Data[Home] [Help]

APPS.HZ_STYLE_FMT_VARIATION_V2PUB SQL Statements

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

Line: 24

  PROCEDURE do_update_style_fmt_variation(
    p_style_fmt_variation_rec    IN OUT  NOCOPY style_fmt_variation_rec_type,
    p_object_version_number      IN OUT NOCOPY  NUMBER,
    x_return_status              IN OUT NOCOPY  VARCHAR2
  );
Line: 137

	hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.insert_row (+)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 142

    HZ_STYLE_FMT_VARIATIONS_PKG.insert_row (
      X_ROWID               => l_rowid,
      X_STYLE_FORMAT_CODE   => p_style_fmt_variation_rec.style_format_code,
      X_VARIATION_NUMBER    => p_style_fmt_variation_rec.variation_number,
      X_VARIATION_RANK      => p_style_fmt_variation_rec.variation_rank,
      X_SELECTION_CONDITION => p_style_fmt_variation_rec.selection_condition,
      X_START_DATE_ACTIVE   => p_style_fmt_variation_rec.start_date_active,
      X_END_DATE_ACTIVE     => p_style_fmt_variation_rec.end_date_active,
      X_OBJECT_VERSION_NUMBER => 1
    );
Line: 155

	hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.insert_row (-) ' ||
					 'p_style_fmt_variation_rec.style_format_code = ' || p_style_fmt_variation_rec.style_format_code ||
					 'p_style_fmt_variation_rec.variation_number = ' || p_style_fmt_variation_rec.variation_number,
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 168

   * PRIVATE PROCEDURE do_update_style_fmt_variation
   *
   * DESCRIPTION
   *     update style format variation

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


  PROCEDURE do_update_style_fmt_variation(
    p_style_fmt_variation_rec    IN OUT  NOCOPY style_fmt_variation_rec_type,
    p_object_version_number      IN OUT NOCOPY  NUMBER,
    x_return_status              IN OUT NOCOPY  VARCHAR2
  ) IS
    l_object_version_number NUMBER;
Line: 194

	hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_variation (+)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 202

        SELECT object_version_number, rowid,
	       style_format_code, variation_number
        INTO l_object_version_number, l_rowid,
	     l_style_format_code, l_variation_number
        FROM HZ_STYLE_FMT_VARIATIONS
        WHERE style_format_code = p_style_fmt_variation_rec.style_format_code
	  AND variation_number = p_style_fmt_variation_rec.variation_number
        FOR UPDATE of  style_format_code, variation_number NOWAIT;
Line: 247

	hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (+)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 253

    HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (
      X_STYLE_FORMAT_CODE    => p_style_fmt_variation_rec.style_format_code,
      X_VARIATION_NUMBER     => p_style_fmt_variation_rec.variation_number,
      X_VARIATION_RANK       => p_style_fmt_variation_rec.variation_rank,
      X_SELECTION_CONDITION  => p_style_fmt_variation_rec.selection_condition,
      X_START_DATE_ACTIVE    => p_style_fmt_variation_rec.start_date_active,
      X_END_DATE_ACTIVE      => p_style_fmt_variation_rec.end_date_active,
      X_OBJECT_VERSION_NUMBER => p_object_version_number
    );
Line: 265

	hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 273

       update hz_style_fmt_layouts_b
       set end_date_active = p_style_fmt_variation_rec.end_date_active
       where style_format_code=l_style_format_code AND
             variation_number = l_variation_number;
Line: 282

	hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_variation (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 287

END do_update_style_fmt_variation;
Line: 466

 * PROCEDURE update_style_fmt_variation
 *
 * DESCRIPTION
 *     Updates style_fmt_variation.
 *
 * 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_variation_rec      Style format variation 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_variation  (
    p_init_msg_list             IN      VARCHAR2 :=FND_API.G_FALSE,
    p_style_fmt_variation_rec   IN      STYLE_FMT_VARIATION_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_variation_rec           STYLE_FMT_VARIATION_REC_TYPE := p_style_fmt_variation_rec;
Line: 512

    SAVEPOINT update_style_fmt_variation;
Line: 519

	hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (+)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 533

    do_update_style_fmt_variation(
                       l_style_fmt_variation_rec,
                       p_object_version_number,
                       x_return_status);
Line: 552

	hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 562

        ROLLBACK TO update_style_fmt_variation;
Line: 577

	    hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 586

        ROLLBACK TO update_style_fmt_variation;
Line: 601

	   hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 610

        ROLLBACK TO update_style_fmt_variation;
Line: 630

	    hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 639

END update_style_fmt_variation;
Line: 718

	hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.Select_Row (+)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);
Line: 723

    hz_style_fmt_variations_pkg.select_row (
      X_STYLE_FORMAT_CODE   => x_style_fmt_variation_rec.style_format_code,
      X_VARIATION_NUMBER    => x_style_fmt_variation_rec.variation_number,
      X_VARIATION_RANK 	    => x_style_fmt_variation_rec.variation_rank,
      X_SELECTION_CONDITION => x_style_fmt_variation_rec.selection_condition,
      X_START_DATE_ACTIVE   => x_style_fmt_variation_rec.start_date_active,
      X_END_DATE_ACTIVE	    => x_style_fmt_variation_rec.end_date_active
    );
Line: 734

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