The following lines contain the word 'select', 'insert', 'update' or 'delete':
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
);
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);
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
);
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);
* 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;
hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_layout (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
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;
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);
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
);
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);
hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_layout (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END do_update_style_fmt_layout;
* 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;
SAVEPOINT update_style_fmt_layout;
hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
do_update_style_fmt_layout(
l_style_fmt_layout_rec,
p_object_version_number,
x_return_status);
hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_style_fmt_layout;
hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_style_fmt_layout;
hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_style_fmt_layout;
hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END update_style_fmt_layout;
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);
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
);
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);