133: END IF;
134:
135: -- Debug info.
136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
137: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.insert_row (+)',
138: p_prefix=>l_debug_prefix,
139: p_msg_level=>fnd_log.level_procedure);
140: END IF;
141:
138: p_prefix=>l_debug_prefix,
139: p_msg_level=>fnd_log.level_procedure);
140: END IF;
141:
142: HZ_STYLE_FMT_VARIATIONS_PKG.insert_row (
143: X_ROWID => l_rowid,
144: X_STYLE_FORMAT_CODE => p_style_fmt_variation_rec.style_format_code,
145: X_VARIATION_NUMBER => p_style_fmt_variation_rec.variation_number,
146: X_VARIATION_RANK => p_style_fmt_variation_rec.variation_rank,
151: );
152:
153: -- Debug info.
154: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
155: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.insert_row (-) ' ||
156: 'p_style_fmt_variation_rec.style_format_code = ' || p_style_fmt_variation_rec.style_format_code ||
157: 'p_style_fmt_variation_rec.variation_number = ' || p_style_fmt_variation_rec.variation_number,
158: p_prefix=>l_debug_prefix,
159: p_msg_level=>fnd_log.level_procedure);
243: END IF;
244:
245: -- Debug info.
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (+)',
248: p_prefix=>l_debug_prefix,
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;
251:
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;
251:
252: -- call table handler to update a row
253: HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (
254: X_STYLE_FORMAT_CODE => p_style_fmt_variation_rec.style_format_code,
255: X_VARIATION_NUMBER => p_style_fmt_variation_rec.variation_number,
256: X_VARIATION_RANK => p_style_fmt_variation_rec.variation_rank,
257: X_SELECTION_CONDITION => p_style_fmt_variation_rec.selection_condition,
261: );
262:
263: -- Debug info.
264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
265: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (-)',
266: p_prefix=>l_debug_prefix,
267: p_msg_level=>fnd_log.level_procedure);
268: END IF;
269:
714: x_style_fmt_variation_rec.variation_number := p_variation_number;
715:
716: -- Debug info.
717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
718: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.Select_Row (+)',
719: p_prefix=>l_debug_prefix,
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722:
719: p_prefix=>l_debug_prefix,
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722:
723: hz_style_fmt_variations_pkg.select_row (
724: X_STYLE_FORMAT_CODE => x_style_fmt_variation_rec.style_format_code,
725: X_VARIATION_NUMBER => x_style_fmt_variation_rec.variation_number,
726: X_VARIATION_RANK => x_style_fmt_variation_rec.variation_rank,
727: X_SELECTION_CONDITION => x_style_fmt_variation_rec.selection_condition,
730: );
731:
732: -- Debug info.
733: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
734: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.select_row (-)',
735: p_prefix=>l_debug_prefix,
736: p_msg_level=>fnd_log.level_procedure);
737: END IF;
738: