APPS.HZ_ORIG_SYSTEM_REF_BO_PUB SQL Statements

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

Line: 335

  PROCEDURE update_orig_sys_refs_bo(
    p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
    p_orig_sys_refs       IN            HZ_ORIG_SYS_REF_OBJ_TBL,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_msg_count           OUT NOCOPY    NUMBER,
    x_msg_data            OUT NOCOPY    VARCHAR2
  ) IS
    l_otn                 VARCHAR2(30);

Line: 348

    SAVEPOINT update_osr_bo_pub;

Line: 360

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

Line: 400

      HZ_ORIG_SYSTEM_REF_PUB.update_orig_system_reference(
        p_orig_sys_reference_rec => l_ososr_rec,
        p_object_version_number  => l_ovn,
        x_return_status          => x_return_status,
        x_msg_count              => x_msg_count,
        x_msg_data               => x_msg_data
      );

Line: 420

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

Line: 426

      ROLLBACK TO update_osr_bo_pub;

Line: 444

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

Line: 450

      ROLLBACK TO update_osr_bo_pub;

Line: 465

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

Line: 470

      ROLLBACK TO update_osr_bo_pub;

Line: 489

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

Line: 493

  END update_orig_sys_refs_bo;

Line: 495

  PROCEDURE update_orig_sys_refs_bo(
    p_orig_sys_refs       IN            HZ_ORIG_SYS_REF_OBJ_TBL,
    x_return_status       OUT NOCOPY    VARCHAR2,
    x_msg_count           OUT NOCOPY    NUMBER,
    x_msg_data            OUT NOCOPY    HZ_MESSAGE_OBJ_TBL
  ) IS
    l_msg_data            VARCHAR2(2000);

Line: 503

    update_orig_sys_refs_bo(
      p_init_msg_list       => fnd_api.g_true,
      p_orig_sys_refs       => p_orig_sys_refs,
      x_return_status       => x_return_status,
      x_msg_count           => x_msg_count,
      x_msg_data            => l_msg_data
    );

Line: 514

  END update_orig_sys_refs_bo;

Line: 565

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