421: l_last_updated_by NUMBER;
422:
423: BEGIN
424:
425: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
426: hz_utility_v2pub.debug(
427: p_prefix => l_debug_prefix,
428: p_message => 'copy_person_extent_data (+)',
429: p_msg_level => fnd_log.level_procedure);
425: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
426: hz_utility_v2pub.debug(
427: p_prefix => l_debug_prefix,
428: p_message => 'copy_person_extent_data (+)',
429: p_msg_level => fnd_log.level_procedure);
430: END IF;
431:
432: l_created_by := hz_utility_v2pub.created_by;
433: l_last_update_login := hz_utility_v2pub.last_update_login;
632: AND tl.extension_id = b.old_extension_id;
633: END IF;
634:
635:
636: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
637: hz_utility_v2pub.debug(
638: p_prefix => l_debug_prefix,
639: p_message => 'copy_person_extent_data (-)',
640: p_msg_level => fnd_log.level_procedure);
636: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
637: hz_utility_v2pub.debug(
638: p_prefix => l_debug_prefix,
639: p_message => 'copy_person_extent_data (-)',
640: p_msg_level => fnd_log.level_procedure);
641: END IF;
642:
643: END copy_person_extent_data;
644:
683: l_last_updated_by NUMBER;
684:
685: BEGIN
686:
687: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
688: hz_utility_v2pub.debug(
689: p_prefix => l_debug_prefix,
690: p_message => 'copy_org_extent_data (+)',
691: p_msg_level => fnd_log.level_procedure);
687: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
688: hz_utility_v2pub.debug(
689: p_prefix => l_debug_prefix,
690: p_message => 'copy_org_extent_data (+)',
691: p_msg_level => fnd_log.level_procedure);
692: END IF;
693:
694: l_created_by := hz_utility_v2pub.created_by;
695: l_last_update_login := hz_utility_v2pub.last_update_login;
893: WHERE b.organization_profile_id = p_new_profile_id
894: AND tl.extension_id = b.old_extension_id;
895: END IF;
896:
897: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
898: hz_utility_v2pub.debug(
899: p_prefix => l_debug_prefix,
900: p_message => 'copy_org_extent_data (-)',
901: p_msg_level => fnd_log.level_procedure);
897: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
898: hz_utility_v2pub.debug(
899: p_prefix => l_debug_prefix,
900: p_message => 'copy_org_extent_data (-)',
901: p_msg_level => fnd_log.level_procedure);
902: END IF;
903:
904: END copy_org_extent_data;
905: