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

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

Line: 23


  PROCEDURE do_update_style_fmt_layout(
    p_style_fmt_layout_rec       IN OUT  NOCOPY style_fmt_layout_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_layouts_pkg.insert_row (+)',
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 142


    HZ_STYLE_FMT_LAYOUTS_PKG.insert_row (
      X_ROWID                    => l_rowid,
      X_STYLE_FMT_LAYOUT_ID      => p_style_fmt_layout_rec.style_fmt_layout_id,
      X_STYLE_FORMAT_CODE        => p_style_fmt_layout_rec.style_format_code,
      X_VARIATION_NUMBER         => p_style_fmt_layout_rec.variation_number,
      X_ATTRIBUTE_CODE           => p_style_fmt_layout_rec.attribute_code,
      X_ATTRIBUTE_APPLICATION_ID => p_style_fmt_layout_rec.attribute_application_id,
      X_LINE_NUMBER              => p_style_fmt_layout_rec.line_number,
      X_POSITION                 => p_style_fmt_layout_rec.position,
      X_MANDATORY_FLAG           => p_style_fmt_layout_rec.mandatory_flag,
      X_USE_INITIAL_FLAG         => p_style_fmt_layout_rec.use_initial_flag,
      X_UPPERCASE_FLAG           => p_style_fmt_layout_rec.uppercase_flag,
      X_TRANSFORM_FUNCTION       => p_style_fmt_layout_rec.transform_function,
      X_DELIMITER_BEFORE         => p_style_fmt_layout_rec.delimiter_before,
      X_DELIMITER_AFTER          => p_style_fmt_layout_rec.delimiter_after,
      X_BLANK_LINES_BEFORE       => p_style_fmt_layout_rec.blank_lines_before,
      X_BLANK_LINES_AFTER        => p_style_fmt_layout_rec.blank_lines_after,
      X_PROMPT                   => p_style_fmt_layout_rec.prompt,
      X_START_DATE_ACTIVE        => p_style_fmt_layout_rec.start_date_active,
      X_END_DATE_ACTIVE          => p_style_fmt_layout_rec.end_date_active,
      X_OBJECT_VERSION_NUMBER    => 1
    );

Line: 167


	hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.insert_row (-) ' ||
                                 'p_style_fmt_layout_rec.style_fmt_layout_id = ' || p_style_fmt_layout_rec.style_fmt_layout_id,
	                       p_prefix=>l_debug_prefix,
			       p_msg_level=>fnd_log.level_procedure);

Line: 179


   * PRIVATE PROCEDURE do_update_style_fmt_layout
   *
   * DESCRIPTION
   *     update style format layout

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


  PROCEDURE do_update_style_fmt_layout(
    p_style_fmt_layout_rec           IN OUT  NOCOPY style_fmt_layout_rec_type,
    p_object_version_number      IN OUT NOCOPY  NUMBER,
    x_return_status              IN OUT NOCOPY  VARCHAR2
  ) IS
    l_object_version_number NUMBER;

Line: 202


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

Line: 210


        SELECT object_version_number, rowid
        INTO l_object_version_number, l_rowid
        FROM HZ_STYLE_FMT_LAYOUTS_B
        WHERE style_fmt_layout_id = p_style_fmt_layout_rec.style_fmt_layout_id
        FOR UPDATE of  style_fmt_layout_id NOWAIT;

Line: 251


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

Line: 257


    HZ_STYLE_FMT_LAYOUTS_PKG.Update_Row (
      X_STYLE_FMT_LAYOUT_ID      => p_style_fmt_layout_rec.style_fmt_layout_id,
      X_STYLE_FORMAT_CODE        => p_style_fmt_layout_rec.style_format_code,
      X_VARIATION_NUMBER         => p_style_fmt_layout_rec.variation_number,
      X_ATTRIBUTE_CODE           => p_style_fmt_layout_rec.attribute_code,
      X_ATTRIBUTE_APPLICATION_ID => p_style_fmt_layout_rec.attribute_application_id,
      X_LINE_NUMBER              => p_style_fmt_layout_rec.line_number,
      X_POSITION                 => p_style_fmt_layout_rec.position,
      X_MANDATORY_FLAG           => p_style_fmt_layout_rec.mandatory_flag,
      X_USE_INITIAL_FLAG         => p_style_fmt_layout_rec.use_initial_flag,
      X_UPPERCASE_FLAG           => p_style_fmt_layout_rec.uppercase_flag,
      X_TRANSFORM_FUNCTION       => p_style_fmt_layout_rec.transform_function,
      X_DELIMITER_BEFORE         => p_style_fmt_layout_rec.delimiter_before,
      X_DELIMITER_AFTER          => p_style_fmt_layout_rec.delimiter_after,
      X_BLANK_LINES_BEFORE       => p_style_fmt_layout_rec.blank_lines_before,
      X_BLANK_LINES_AFTER        => p_style_fmt_layout_rec.blank_lines_after,
      X_PROMPT                   => p_style_fmt_layout_rec.prompt,
      X_START_DATE_ACTIVE        => p_style_fmt_layout_rec.start_date_active,
      X_END_DATE_ACTIVE          => p_style_fmt_layout_rec.end_date_active,
      X_OBJECT_VERSION_NUMBER    => p_object_version_number
    );

Line: 281


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

Line: 288


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

Line: 293


END do_update_style_fmt_layout;

Line: 475


 * PROCEDURE update_style_fmt_layout
 *
 * DESCRIPTION
 *     Updates style_fmt_layout.
 *
 * 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_layout_rec         Style format layout  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_layout  (
    p_init_msg_list              IN      VARCHAR2 :=FND_API.G_FALSE,
    p_style_fmt_layout_rec       IN      STYLE_FMT_LAYOUT_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_layout_rec           STYLE_FMT_LAYOUT_REC_TYPE := p_style_fmt_layout_rec;

Line: 521


    SAVEPOINT update_style_fmt_layout;

Line: 528


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

Line: 542


    do_update_style_fmt_layout(
                       l_style_fmt_layout_rec,
                       p_object_version_number,
                       x_return_status);

Line: 561


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

Line: 571


        ROLLBACK TO update_style_fmt_layout;

Line: 586


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

Line: 595


        ROLLBACK TO update_style_fmt_layout;

Line: 610


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

Line: 619


        ROLLBACK TO update_style_fmt_layout;

Line: 639


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

Line: 648


END update_style_fmt_layout;

Line: 724


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

Line: 729


    hz_style_fmt_layouts_pkg.select_row (
      X_STYLE_FMT_LAYOUT_ID      => x_style_fmt_layout_rec.style_fmt_layout_id,
      X_STYLE_FORMAT_CODE        => x_style_fmt_layout_rec.style_format_code,
      X_VARIATION_NUMBER         => x_style_fmt_layout_rec.variation_number,
      X_ATTRIBUTE_CODE           => x_style_fmt_layout_rec.attribute_code,
      X_ATTRIBUTE_APPLICATION_ID => x_style_fmt_layout_rec.attribute_application_id,
      X_LINE_NUMBER              => x_style_fmt_layout_rec.line_number,
      X_POSITION                 => x_style_fmt_layout_rec.position,
      X_MANDATORY_FLAG           => x_style_fmt_layout_rec.mandatory_flag,
      X_USE_INITIAL_FLAG         => x_style_fmt_layout_rec.use_initial_flag,
      X_UPPERCASE_FLAG           => x_style_fmt_layout_rec.uppercase_flag,
      X_TRANSFORM_FUNCTION       => x_style_fmt_layout_rec.transform_function,
      X_DELIMITER_BEFORE         => x_style_fmt_layout_rec.delimiter_before,
      X_DELIMITER_AFTER          => x_style_fmt_layout_rec.delimiter_after,
      X_BLANK_LINES_BEFORE       => x_style_fmt_layout_rec.blank_lines_before,
      X_BLANK_LINES_AFTER        => x_style_fmt_layout_rec.blank_lines_after,
      X_PROMPT                   => x_style_fmt_layout_rec.prompt,
      X_START_DATE_ACTIVE        => x_style_fmt_layout_rec.start_date_active,
      X_END_DATE_ACTIVE	         => x_style_fmt_layout_rec.end_date_active
    );

Line: 752


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